Data & BI Solutions

  A global enterprise with millions of annual travel transactions had no single source of truth. Spend data arrived in monthly batch drops from multiple TMCs and suppliers — air, hotel, car, rail, card, and expense — each in incompatible formats. Finance, sourcing, and leadership teams were flying blind on leakage, carbon, and program compliance. 

Designed and owned end-to-end development of TripTracker across four major versions — from initial architecture through global production operations. Built Azure Synapse pipelines, normalized a multi-source invoice data model, and published a Power BI reporting suite covering spend analytics, leakage detection, carbon calculations, forecasting models, and org-level roll-ups.

Co-led joint schema design with a partner TMC engineering team to replace monthly batch feeds with a near-real-time daily ingestion architecture. 

Consolidated multiple TMC data sets into a single normalized model, enabling true cross-program analysis for the first time.

• Millions of invoice-level transactions processed annually across six data sources
• Optimized data ingestion and transformation services 
• Monthly batch latency replaced with near-daily data freshness
• Single normalized schema spanning multiple TMCs
• Adopted globally by finance, sourcing, and executive leadership

   Many travel programs rely on supplier-provided portals that reflect the supplier's version of reality. An independent, integrated analytics layer (one you own and control) gives procurement teams the leverage to negotiate from fact rather than feeling. 

An independent, supplier-agnostic data platform changes supplier relationships entirely. When your analytics layer sits outside any single vendor, your data moves with your program, not with your contracts. Switch TMCs, add a new OBT, consolidate expense platforms: the data keeps flowing, the schema keeps normalizing, and the history stays intact. That's data fluidity: the ability to bring any source in, compare it against any other, and carry your institutional knowledge forward regardless of who your suppliers are at any given moment.

The programs that negotiate best aren't the ones with the biggest spend — they're the ones that walk into a supplier conversation knowing more than the supplier expected them to know. That only happens when the data is yours, the architecture is yours, and no vendor holds the keys.