Decades of secondary side-revenue status created a data vacuum.
For decades within full-service national flag carriers, passenger commercial operations took all the spotlight. Air cargo was historically treated merely as opportunistic side revenue, considered extra cash earned from whatever belly space was left over after passenger baggage was loaded.
Because cargo was never treated as an independent strategic commercial engine, there was zero corporate mandate or IT budget allocated for structured data governance. Over ten-plus years of commercial contracts, station-level airway bill (AWB) performance records, flight capacity records, and customer rate sheets were completely fragmented:
- 1. Records were siloed across the personal laptops and USB drives of 20+ head office commercial and operational staff.
- 2. If a staff member went on annual leave or resigned, their critical pricing calculations and historical route volume models were lost.
- 3. Month-end corporate performance reports required weeks of manual copy-pasting across incompatible spreadsheets, meaning executive insights were perpetually 30 to 45 days stale.
- 4. Frontline ground operations relied on an external 3rd-party Cargo Management System (DRC) whose proprietary database could not talk to corporate reporting systems.
When airline leadership asked basic commercial questions, such as "Which cargo routes generated positive contribution margins last month?" or "What is our true capacity utilization on the transpacific corridor?", answering required assembling multiple analysts for days of manual reconciliation. You cannot optimize what you cannot measure.
A boardroom restructuring elevated cargo to direct C-level scrutiny.
A watershed moment occurred when Garuda Indonesia established an independent, dedicated Cargo Directorate, officially placing a Cargo Director directly at the executive C-suite board table.
This organizational shift altered our operating leverage entirely. As a Business Analyst situated just two levels below the Cargo Director, I had an unobstructed channel to present operational pain points, propose system investments, and secure immediate resource clearances without wading through layers of corporate bureaucracy.
The Cargo Director needed ammunition for executive board meetings: reliable, defensible, live performance figures that proved cargo was not just ballast, but a major margin contributor. We seized this momentum to build a permanent institutional data layer.
Automating ingestion from the DRC Cargo Management System every 30 minutes.
Building the Cargo Data Center required solving two distinct challenges: historical archival backfilling and automated forward-looking ingestion.
Working with one other analyst, we initiated a hands-on audit across all 20+ head office laptops. We extracted over 10 years of historical flight manifests, airway bill data, tariff structures, and billing adjustments. We designed a unified schema normalizing station codes, aircraft type capacities, density factors, and currency rates.
For forward operations, we built automated ETL pipelines directly interfacing with the 3rd-party Cargo Management System (DRC) that handled airport cargo terminal operations:
Automated scheduled scripts pulling flight manifest snapshots, airway bills, and booking statuses directly from DRC databases.
Reconciled legacy discrepancies across airport codes, block hour definitions, volumetric weight ratios, and multi-currency billing.
Cleaned, de-duplicated, and enriched transactional records before loading into the centralized warehouse database.
Customized visualization layers giving senior executives real-time drilldown into route profitability, station performance, and load factor.
- 10+ years of data scattered across 20+ individual staff laptops
- Data frequently lost when employees resigned or transferred
- Zero connection between airport ground software (DRC) and head office
- Monthly performance reporting took 30 to 45 days to assemble
- No ability to run ad-hoc route profitability queries
- Single consolidated Cargo Data Center spanning 10+ years of history
- Automated 30-minute ETL syncing directly with DRC system
- Instant multi-dimensional querying across flights, routes, and agents
- Daily executive dashboards with real-time operational metrics
- Served as the foundational data layer for all future predictive models
Extreme operational leverage through a lean two-person unit.
This entire infrastructure was designed, built, and deployed by a two-person team. As Business Analyst, I owned the end-to-end scope:
Data Engineering & Architecture: Formulated the core database architecture, designed normalized schemas, authored automated extract scripts, and configured database indexes to support rapid time-series analytical queries across millions of rows.
Stakeholder Diplomacy & Change Management: Persuaded 20+ veteran staff members to surrender their personal spreadsheets, auditing their idiosyncratic business logic, formulas, and edge cases to ensure our unified data definitions reflected real-world aviation physics and contract terms.
Executive Direct Engagement: Maintained direct reporting channels with the Cargo Director and senior commercial managers, refining BI views to answer high-stakes commercial inquiries on short notice.
From analytical paralysis to near real-time operational agility.
The Garuda Cargo Data Center permanently altered the airline's commercial capability:
1. Instant Multi-Dimensional Analytics: Queries that previously took weeks of manual data compilation across departments could now be answered in under 5 minutes, allowing rapid commercial repricing and immediate capacity reallocation.
2. Near Real-Time Monitoring: Automated 30-minute sync enabled ground station supervisors and head office planners to monitor flight load factors, volumetric density, and no-show patterns in near real time before flight departure.
3. The Springboard for Future Innovation: Unlocking 11 years of clean historical data directly enabled subsequent high-impact initiatives, including our 34% YoY yield growth forecasting models and multi-million dollar data recovery operations.
Systems beat heroics every time.
When critical business data resides on individual laptops, performance depends on personal heroics. When it is unified in an automated system, the entire enterprise gains the power to act with precision.
Large enterprises rarely suffer from a lack of data; they suffer from fragmented ownership and brittle processes. By pairing technical automation with direct executive alignment, a tiny, determined team can rebuild the operational foundation of a legacy airline.