Aviation · Data · Strategy

Where flight operations meet data science.

I'm Cristian Villada — aeronautical engineer and data scientist, currently Flight Crew Training Officer (DS) at Etihad Airways in Abu Dhabi. I design EBT/SBT digital training programmes, build BI solutions, and develop Python automations across a fleet of 106+ aircraft.

Before Etihad I led commercial strategy and pricing at TAAG Angola Airlines — building their Google Cloud data infrastructure from scratch — and worked in ancillary revenue and fuel analytics at Viva Air Colombia.

EBT / SBT Analytics Revenue Management Network Strategy Machine Learning Python · SQL · Databricks
Etihad Airways · Abu Dhabi
Cristian Villada
CRISTIAN VILLADA
From the Andes to the Arabian Desert
Current Role
Flight Crew Training Officer — DS
Etihad Airways · Abu Dhabi, UAE
Education
BSc Aeronautical Engineering
Pontifical Bolivarian University · Colombia
Languages
Spanish · English · Portuguese
Native · C1 · B1
Core Stack
Python · SQL · Databricks · Power BI (DAX) · Tableau · LlamaIndex / RAG · GCP · Navitaire · Amadeus · Lean Six Sigma
106+
Aircraft fleet supported
8
Tools deployed live
218
ZED agreements mapped
3
Languages spoken
Journey

Three continents. One thread.

Aviation took me from the Andes to the Angolan coast to the Gulf — each move adding operational context, commercial depth, and technical capability.

MDE LUA JNB AUH
CO
Medellín, Colombia
Viva Air · Ancillary & Fuel
Where the data career started — pricing models, ancillary strategy, and fuel analytics for a fast-growing ULCC.
AO
Luanda, Angola
TAAG · Commercial Strategy
Built the GCP data infrastructure and BI framework from scratch. Led revenue management across the network.
SA
Johannesburg, SA
TAAG · Southern Africa
Anchor market for the airline's cross-continental commercial push across Southern Africa.
AE
Abu Dhabi, UAE
Etihad · Flight Crew Training
Designing EBT/SBT programmes and BI + Python automation across a fleet of 106+ aircraft.
Selected Work

Tools, in the right hands.

8 live · 1 in development
Live · Updated Jun 2026
ZED Atlas

All 218 ZED agreements with the full fare matrix and an interactive world map across six view modes — plus FR24 route depth and a coverage-gap view. Etihad-authorized users.

218 agreements194 FR24 networks1,103 airports
Open ZED Atlas
Live · Cirium Q4 · 4 airlines
Network Analysis

A 30-carrier capacity matrix plus Cirium deep-dives for EY, QR, EK and ET — growth, exits and fleet shifts — and the new "Biggest Summer Ever" Etihad schedule analysis.

30 carriersCirium Q4FR24 live
Open Network Hub
Live · Voice AI + ICAO
ATC+ Clear2Speak

A real-time, voice-driven radiotelephony trainer — transmit your readback to an AI controller and get instant ICAO-phraseology scoring, with safety gates on frequency, QNH, squawk and runway.

Voice AIICAO gradingEBT scenarios
Open ATC+ Trainer
Live · altairaero.com
Altair Pilot Logbook

A GCAA/EASA-aware digital pilot logbook — log flights, track hours by type, monitor currency and FTL limits, and export a compliant aeronautical record. Built for cockpit professionals.

Pilot logbookFTL limitsCurrency
Open Logbook
Live · React PWA
OTP Pilot App

A progressive web app for pre-departure milestones and on-time performance — in-app alerts, background push via Upstash QStash, and a service worker for offline capability.

React PWAPush alertsOffline-ready
Open OTP App
Live · WebGL · Spotify API
Spotify Visualizer

A real-time, audio-reactive WebGL visualizer for your Spotify account — fluid simulation, lightning, particle trails and neon rings across six renderer modes driven by beat detection.

WebGL / Three.jsGLSL shadersBeat detection
Open Visualizer
New · Blueprint Gallery
Aerospace Learning

A technical blueprint gallery — Airbus A380-800 and A350 XWB structural, aerodynamic and composite drawings in full engineering-documentation style, with lightbox and category filtering.

A380-800A350 XWB12 blueprints
Open Gallery
Open Source · GitHub
Airlines BI

A Power BI dashboard suite for airline commercial analytics — revenue management, network performance, load factors and schedule efficiency, built with DAX and aviation data models.

Power BIDAXOpen source
View on GitHub
In development
Layover Intelligence

A per-city layover guide — hotel tier, transport cost, must-do attractions, currency tips, crew recommendations, and best ZED routing for onward travel from each EY outstation.

LayoversCrew guidesZED routing
Coming soon