← All Work

Software Engineering Internship

Aspire Web Suite

Full-stack engineering for high-growth scale-ups — optimising performance and building internal tooling during a production internship in Beirut.

Next.js · TypeScript · Supabase · Tailwind CSS

GitHub
35%Latency Reduced
5Apps Built
95%Unit Test Coverage
1,000+Requests / Day

01 / Overview

During my internship at Aspire, the existing infrastructure was struggling to keep up with user demand. Response times were sluggish due to unoptimised database queries and heavy client-side rendering.

Over the internship I shipped 5 production full-stack applications delivering 10+ features, profiled and optimised 15+ backend queries to cut average response latency by 35%, and hardened security with row-level security and JWT auth middleware — at 95% unit test coverage.

02 / Engineering Solutions

01

Performance Optimization

Refactored legacy API endpoints using efficient SQL joins and indexing in Supabase. Implemented caching and SSR in Next.js, resulting in a measurable 35% reduction in backend latency.

02

Internal Tooling

Architected and deployed 5 internal full-stack applications that automated manual data entry workflows and provided real-time analytics dashboards for the operations team.

03

Security & Reliability

Hardened the platform with Postgres row-level security and JWT auth middleware, with normalized schemas serving 1,000+ daily requests at 95% unit test coverage.

Stack

  • Next.js (React)
  • TypeScript
  • Supabase (PostgreSQL)
  • Tailwind CSS

Share

Up NextAskAlan