aviation-analytics

This project develops a machine learning pipeline to analyze and predict air traffic trends using historical aviation data.

Full-stack Aviation BI Dashboard: A Docker-deployed Metabase instance utilizing SQL to monitor Astra aircraft fleet health. Features a 'Maintenance Command Center' tracking 4,200+ airframe hours, fuel efficiency, and real-time alerting for engine component inspections (ATA 72/73) within a 50-hour critical window.

Collection of interactive Tableau dashboards showcasing data visualization expertise across entertainment, real estate, and aviation industries. Features Netflix content analysis, housing market trends, and British Airways customer satisfaction metrics with advanced filtering and drill-down capabilities.

PySpark-based analytics project exploring U.S. flight delays, cancellations, route performance, and airport trends through data visualization and interactive dashboards.

Data analytics applied to aviation operations — punctuality, traffic, fares, and MRO KPIs

USA flights analysis

Workforce management tool for predicting ground handling delays and optimizing staff allocation for airport operations.

Portside is a cloud-based business aviation management software company headquartered in Cary, North Carolina, serving corporate flight departments, charter and managed fleets, fractional and aircraft management companies, business jet owners, and government and military aviation across more than 30 countries.

Data analytics and forecasting system to predict passenger traffic, detect bottlenecks, and optimize airport operations.

An end-to-end, containerized data pipeline built with Apache Airflow and PostgreSQL to track commercial aviation reliability. Utilizing a strictly typed Star Schema, it ingests flight events to calculate auditable, industry-standard A15/D15 On-Time Performance (OTP) and Completion Factor metrics for fact-backed reporting.

End-to-end U.S. flight reliability analytics platform with Python ETL, PostgreSQL star schema, SQL analytical views, data-quality validation, and Power BI dashboards.

Interactive dashboard for analyzing Vietnam's aviation sector. Built with React, TypeScript, D3.js, and Python. Visualizes flight density, pricing trends, passenger routes, and airline metrics. Ideal for travelers, airline strategists, and policymakers.

SQL Server data analytics project analyzing air traffic passenger trends, airport performance, airline activity, and travel demand using SQL for business insights.

Local Generative AI prototype for operational risk analysis and executive reporting using Ollama, Docker, and Open WebUI.

✈️ FlightWise AI is an end-to-end Machine Learning project that predicts flight delays using XGBoost and aviation analytics. Features advanced feature engineering, model comparison, interactive Streamlit dashboards, delay risk prediction, and operational recovery recommendations.

AI-powered platform for intelligent operations in healthcare, pharma, and aviation.

Documentation of an end-to-end data lifecycle for airline operations. Focuses on relational integrity, multi-source ingestion protocols, and Row-Level Security (RLS) for departmental data isolation.

This project focuses on the intersection of real-time data engineering and aviation analytics. Built to bridge the gap between raw API streams and structured data insights, it tracks global flight movements, schedules, and historical data while navigating the technical challenges of external API management.

Airline route-evaluation engine on open government data: gravity demand + QSI-lite share + route economics turned into LAUNCH/MONITOR/PASS verdicts, validated end-to-end. Live Streamlit demo.

Auditing minimum connection time standards at U.S. hub airports using BTS On-Time Performance and DB1B data. January 2019, Python.