DATA & PERFORMANCE
PostgreSQL Dashboard Optimization: 15s → 2s
Moving repeated reporting work out of the request path with materialized views, pre-aggregation and revised queries.
ALI ANJUM / ENGINEERING WITH OWNERSHIP
I solve difficult backend, data and integration problems — and turn AI prototypes into reliable production systems.
Node.js · TypeScript · PostgreSQL · MongoDB · AI systems
Dashboard optimization with materialized views, pre-aggregation and revised queries.
Explore the case studyNODE.JS / AWS5 min → 15 secSequential browser-heavy processing replaced with concurrent Axios/Cheerio work.
Explore the case studyMONGODB26.6M records~1s chart queriesPre-aggregated time-series data and chart-specific queries.
Explore the case studyResults from separate projects and workloads. Each case study explains the measurement context.
01 / PROBLEMS I SOLVE
Start with what is getting in the way.
Investigate API, query, concurrency and architecture bottlenecks and implement measurable performance improvements.
See relevant evidence02PostgreSQL/MongoDB analysis, aggregation, materialized views, reporting architecture and pre-computation.
See relevant evidence03Model integration, backend APIs, validation, fallbacks, observability, data flows and production architecture.
See relevant evidence04Payments, CRM systems, webhooks, queues and third-party APIs.
See relevant evidence05Reproduce → measure → investigate → isolate → implement → verify.
See relevant evidence02 / SELECTED CASE STUDIES
DATA & PERFORMANCE
Moving repeated reporting work out of the request path with materialized views, pre-aggregation and revised queries.
PRODUCTION DEBUGGING
An Apple Pay failure showed why a plausible AI answer must still survive contact with observed browser behavior.
03 / HOW I WORK
Understand the business impact, reproduce the issue, identify the real bottleneck, implement the smallest safe change, measure again and monitor the result.
04 / APPLIED AI & EXPERIMENTS
Svelte and TypeScript with Fastify, Gemini, Google Places and PostgreSQL. Caching, validation and fallbacks, metrics, and PDF export. The repository is private.
Explore Travel JuniorGemini embeddings, ranking and personalization with PostgreSQL/pgvector and Supabase. No public usage or adoption claim.
View project details05 / EXPERIENCE & OWNERSHIP
At a Toptal client, I worked directly with the technical CEO on backend systems, AI lead qualification, payments, HubSpot and difficult production issues.
Software development since 2014, across independent client work and engineering teams.
CLIENT EVIDENCE
“Muhammad did a great job. He improved on the previous NodeJS code base and made it run nearly 20X faster! He was readily available for any small changes we requested and understood immediately what we're asking for. Would recommend.”
06 / ASK ALI
Ask my AI assistant about a case study, my experience, or a technical problem. It can point you to relevant work. The opinions—and occasional stubborn debugging sessions—are mine. The assistant is AI.
Ask Ali a questionLET’S SOLVE IT
If you’re dealing with a backend bottleneck, production issue, unreliable integration or an AI prototype that needs production engineering, let’s discuss it.
Discuss the problem