Skip to content
Back to ProjectsFull-Stack + Cloud

Aerox

With AI Features (ML Price Prediction, Chat Assistant, 30-Day Fare Forecasts)

Production-grade polyglot flight booking platform with ML price prediction, real-time SignalR hubs & 3-language architecture

WEBDESIGNCLOUDAILIVEPRODUCTION
PRODUCTION GRADE
Active
Dec 2025 - Present

// VIDEO SHOWCASE

01/05Homepage Scroll
MISSION STORY:

THE POLYGLOT SHOWCASE

Aerox is a production-grade, polyglot flight booking platform — the only project in the portfolio demonstrating cross-ecosystem fluency across C#/.NET, TypeScript/React, and Python. Originally scaffolded as a basic ASP.NET Identity + EF Core project rated 3.5/10, it underwent an intensive transformation to 7.5/10. The platform features a complete airline booking flow with flight search across 33 airports (14 Philippine domestic + 19 international), multi-passenger booking with a 4-step wizard, and an admin dashboard with Recharts analytics. The ASP.NET Core 8 backend implements Clean Architecture (Controller → Service → Repository with generic IRepository<T>), JWT refresh token rotation with family-based reuse detection, Google OAuth, 3-layer rate limiting, API versioning (URL + header), and Stripe Checkout with an IPaymentGateway strategy pattern designed for multi-gateway support. A FastAPI AI microservice provides chat assistance (Gemini 2.0 Flash / GPT-4o-mini / mock fallback) with SSE streaming, ML price prediction (GradientBoostingRegressor trained on 5,400 synthetic data points), and 30-day price trend forecasts. Three SignalR hubs deliver real-time updates with a Redis backplane for horizontal scaling. Infrastructure includes 6-container Docker Compose, Nginx reverse proxy, and dual CI/CD pipelines.

Backend API is live on Render. Frontend deployed on Vercel. The only C#/.NET project in the portfolio — demonstrates that engineering skills transfer across language boundaries, not framework lock-in.

Multi-service polyglot architecture spanning three backend ecosystems. ASP.NET Core 8 handles core business logic with Clean Architecture (Controller → Service → Repository with generic IRepository<T>), custom middleware pipeline, API versioning, and EF Core on PostgreSQL. FastAPI runs AI services (ML price prediction + chat assistant). SignalR provides real-time updates with Redis backplane. 6-container Docker Compose with Nginx reverse proxy, and GitHub Actions CI/CD.

Frontend App

Next.js 16 + React 19TAP TO FLIP

TypeScript SPA with 31 TanStack Query hooks, Axios token refresh queue (thundering herd prevention), 4-step booking wizard, admin dashboard with Recharts analytics, Framer Motion animations, and UI component library. Vitest + Playwright for testing. Deployed on Vercel.

Core API

ASP.NET Core 8 + C# 12TAP TO FLIP

REST API with Clean Architecture (6 repos, 9 services), ASP.NET Identity (JWT + refresh rotation + Google OAuth), EF Core Code-First, API versioning, Swagger docs, 3-layer rate limiting, Serilog structured logging, Stripe with IPaymentGateway strategy, and 59 xUnit tests. Deployed on Render.

AI Service

FastAPI + Scikit-learn + Gemini 2.0TAP TO FLIP

ML price prediction (GradientBoostingRegressor, 200 estimators, trained on 5,400 data points) with 30-day forecasts. Chat assistant with multi-provider fallback (Gemini → GPT-4o-mini → mock) and SSE streaming. Served via Uvicorn with Pytest coverage.

Data & Infra

PostgreSQL + Redis + NginxTAP TO FLIP

Supabase-hosted PostgreSQL with EF Core. Redis for caching + SignalR backplane. Nginx reverse proxy with WebSocket upgrade, rate limiting, and gzip. 6-container Docker Compose. Multi-provider email (SendGrid/Resend/Mock).

FRONTEND

Next.js 16React 19TypeScriptTailwindCSSTanStack React QuerySK-0061SK-0025SK-0087

BACKEND

ASP.NET Core 8C# 12Entity Framework CoreASP.NET IdentitySK-0101Swagger/OpenAPISK-0109SK-0076FastAPIPythonSK-0029SK-0030SK-0059SK-0078SK-0095SK-0081SK-0114SK-0092

DATABASE

PostgreSQL (Supabase)Redis

CLOUD & DEVOPS

DockerNGINXTerraformSK-0046SK-0049GitHub ActionsSK-0050

TOOLS & TESTING

PostmanSK-0076RFC 7807 Problem DetailsSK-0082SK-0083SK-0093SK-0072SK-0080SK-0096SK-0120
PhilippinesREMOTE GLOBALPulseCare