Twenty years of mining data, made live
Consolidated 20+ years of bauxite data trapped in 24 interdependent Excel models into a single scalable, SQL-backed web platform with real-time dashboards.
A global commodity research firm ran its entire business on 24 complex, interlinked Excel workbooks built up over two decades. A single change rippled unpredictably across sheets, reconciliation was manual, and no one could see the whole picture. The knowledge lived in the spreadsheets — and in a few people's heads.
- Reverse-engineered the 24 models to expose every hidden link, formula and dependency — and turned that into a repeatable data-mapping method the whole team could follow.
- Designed a structured SQL "flat-DB" schema so data lived once, cleanly, instead of being copied across sheets.
- Built automated transformation pipelines (Python / Pandas) to migrate and validate the historical data with no manual reconciliation.
- Delivered a C# web interface with Power BI dashboards, giving distributed teams real-time insight instead of emailed spreadsheets.
- Coordinated developers, designers and QA across seven time zones with daily stand-ups and weekly stakeholder calls.