High-Concurrency Analytics Engine
The Problem: Querying multi-million record datasets on legacy SQL engines took over 12 seconds per dashboard refresh, crashing during peak traffic hours.
The Solution & Outcome: Rebuilt with columnar ClickHouse indexing and Redis caching, cutting query speeds down to sub-35ms with 99.9% availability.
DailyBus Realtime Transit Platform
The Problem: Commuters experienced route delays due to un-synchronized location updates across active bus fleets.
The Solution & Outcome: Engineered a WebSocket pipeline broadcasting live GPS positions with zero dropouts across thousands of active mobile sessions.
Automated Order Search System
The Problem: Support teams struggled with slow cross-table lookups for peak holiday orders, impacting response times.
The Solution & Outcome: Created an indexed search engine processing thousands of queries per second seamlessly with instant filter responses.
Cloud Infrastructure Automator
The Problem: Manual server provisioning led to deployment bottlenecks and unexpected scaling outages.
The Solution & Outcome: Deployed automated AWS EC2 & Lambda CI/CD pipelines ensuring 99.9% uptime and zero-downtime releases.