Travel Payments and Realtime Backend

Faster payment processing, realtime updates and a GraphQL homepage backend for MNC Group's travel platform.

-15%
Reduction in realtime request latency with WebSocket and Redis
+30%
Increase in transaction speed after the payment gateway refactor
-40%
Reduction in errors after MySQL and service tuning; queries ran about 20% faster

Role: Backend Engineer, my first full-time role while completing university
Period: Feb 2022 to Feb 2023
Client: MNC Group (Mister Aladin)
Project type: Featured
Room in the 3D HQ: L3:payments-realtime-backend

Results

-15%
Reduction in realtime request latency with WebSocket and Redis
+30%
Increase in transaction speed after the payment gateway refactor
-40%
Reduction in errors after MySQL and service tuning; queries ran about 20% faster
+25%
Increase in homepage load speed after the GraphQL migration

Problem

Slow payments and stale data affected travel and hotel bookings at Mister Aladin. The payment gateway, realtime request handling and several MySQL-heavy endpoints were bottlenecks.

Contribution

I built realtime request handling with AWS API Gateway WebSocket APIs and Redis.
I refactored the payment gateway integration using GraphQL and AWS Lambda.
I tuned MySQL queries in Go (Gin) and Laravel services for the busiest endpoints.
I reduced homepage load time by migrating its backend to GraphQL.