— Case Studies
Case Studies
In-depth looks at problems I've solved and how I solved them
How a Redis Stampede (Thundering Herd) Hit Our OTA Search Ranking Engine — And How We Fixed It
When 30 integrated suppliers and 40-50 unique airlines per search met an uncached rank lookup, concurrent cache misses stampeded the database in unison — here's how negative caching and locking around retrieval broke the herd.
How I Made My Static Website Editable — Without a Server or Database
This portfolio site is hosted completely free with no server behind it. Here's how I still gave myself a private dashboard to update every part of it from a browser, without adding a server or a database.
Progressive Search: Showing Flight Results Before All 30 Suppliers Answer
Flight search used to wait on all 30 suppliers before showing anything — one slow responder meant everyone waited. Here's how Server-Sent Events let us stream results the moment each supplier answers.
Building an Airline Fare Intelligence Platform Across Multiple GDS & NDC Suppliers
An airline fare intelligence platform integrating multiple GDS and NDC suppliers to aggregate, normalize, and analyze competitor pricing — turning scattered market data into data-driven fare recommendations.
Cutting ADM Penalties with an Automated Booking Cancellation Service
A background service that automatically cancels un-ticketed bookings before the last ticketing time, saving ~$23K-$27K across 6 OTA clients.
Splitting Reads From Writes: A CQRS + ETL Pipeline That Cut Job Search Query Time by 30%
Job search was slowed by relational joins across a normalized MSSQL schema — here's how a CQRS split with a MongoDB read model and an ETL sync pipeline cut query time and improved search efficiency by 30%.