Trabill
OTA Platform
2023
14 months
6 engineers
System Architect & Backend Lead
Full-scale Online Travel Agency system with GDS integrations
Trabill is an enterprise-grade OTA platform built to handle the full lifecycle of flight bookings — from real-time availability search through GDS aggregators to final ticketing and post-booking management. The system processes hundreds of thousands of API calls daily while maintaining sub-200ms response times through aggressive caching, connection pooling, and async processing via Server-Sent Events. The architecture supports multi-tenant agency setups, role-based access, and deep financial reporting. Integration with both Galileo/Travelport and Sabre GDS gives agents access to the full global inventory with real-time fare validation before payment.
Real-time flight search across Galileo and Sabre GDS with unified response schema
SSE-based fare streaming eliminates polling and cuts frontend load by 60%
Multi-agency tenant system with isolated financial ledgers per branch
Automated revalidation before payment to eliminate fare mismatch errors
PNR management and e-ticket generation fully automated
Redis caching layer for popular routes reduces GDS round-trips by 45%
Galileo and Sabre return wildly different XML/JSON schemas for the same flight data, making unified handling complex.
Polling-based fare updates created high backend load and stale UX. Users would see outdated prices until they manually refreshed.
Simultaneous bookings for the same seat caused double-confirmation issues during peak traffic.
Backend
Database
Frontend
GDS APIs
Infra
PHASE 01 — Discovery & Architecture