The problem
Revenue lived in NetSuite, projects in Air1 and labour in UKG. Leadership waited days for backlog and utilisation reports that were assembled by hand and rarely agreed.
What I built
- 01Built an Azure SQL warehouse fed by 50+ Azure Data Factory pipelines, with key mapping and financial reconciliation across the three systems.
- 02Wrote dynamic MERGE procedures that detect primary keys, catch and categorise errors, log at pipeline and database level and email alerts.
- 03Processed 1M+ records a day with sub-second queries using composite indexes, partitioning and materialised views.
- 04Delivered Power BI dashboards for revenue, backlog and utilisation, with automated weekly backlog snapshots for trends.
Screens


