📞 0321-2582327 · 📧 [email protected] · GitHub
Forensic Data Analyst specializing in auditing messy operational databases to isolate system latency, structural revenue leaks, and broken workflow pipelines. Expert in building end-to-end telemetry systems—spanning complex MySQL schema engineering, sub-second memory DAX modeling, and executive-level Power BI architectures. Combines production-grade backend execution with an operations-first strategy to transform corrupted transaction logs into multi-million dollar margin reclamation frameworks.
Database Engineering: MySQL · Advanced CTEs · Mathematical Window Functions · Subqueries · Schema Normalization · Session Overrides · Foreign Key Constraint Engineering
Visualization & Automation: Power BI Dashboard Design · DAX Modeling · Automated Reporting Processes · Advanced Excel · ETL Data Pipelines · KPI Formulation
Analytical Focus: Funnel Mapping · Retention Cohorts · Revenue Leakage Quantifying · Supply Chain Optimization · Onboarding Latency Analysis · ABC Inventory Segmentation
Technical Stack: MySQL (Star Schema & CTEs) · Telemetry Data Modeling · Executive Dashboard Architecture Repository Code & Technical Report: [Link]
The Bottleneck: Traditional dashboards track gate-to-gate "On-Time" arrivals, completely masking why airlines are silently hemorrhaging cash. Padded flight schedules act as a lagging indicator, hiding massive tarmac fuel destruction occurring right before takeoff.
The Implementation • Engineered an enterprise Star Schema data warehouse joining 513k flight legs with technical burn parameters from the ICAO Aircraft Emissions Databank. • Formulated deduplicated DAX lookup models to bypass relational table boundaries and isolate wide-body propulsion penalties under sub-second memory constraints. • Enforced a 4-minute engine warm-up buffer in SQL logic to strip safe operational windows and target true excess ground latency.
The Impact Metrics • Exposed $42.69M in tarmac cash destruction driven by ground traffic gridlocks at core hubs like Atlanta (ATL). • Uncovered a 54% to 57% short-haul menu spoilage rate across Delta and American Airlines due to over-boarding for customer availability. • Reclaimed $2.58M in simulated margin leaks by transitioning to a 100% shelf-stable inventory model that rolls unconsumed items over to subsequent flights. • Isolated a 9% telemetry sync drop rate among regional commuter airframes, flagging a $725K legal fine exposure from corrupted logs. • Coded an automated Reorder Point (ROP) trigger tool to permanently insulate warehouses against catastrophic $1.50M out-of-stock asset groundings (AOG).