Skip to content
Muhammad Safyan

Palmetto Air Balance

One warehouse for a $40M project portfolio

An Azure data warehouse joining NetSuite, UKG and Air1 with 50+ Data Factory pipelines — real-time visibility into a $40M+ portfolio and 70% less manual reporting.

portfolio made visible
$40M+portfolio made visible
Data Factory pipelines
50+Data Factory pipelines
less manual reporting
70%less manual reporting

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

  1. 01Built an Azure SQL warehouse fed by 50+ Azure Data Factory pipelines, with key mapping and financial reconciliation across the three systems.
  2. 02Wrote dynamic MERGE procedures that detect primary keys, catch and categorise errors, log at pipeline and database level and email alerts.
  3. 03Processed 1M+ records a day with sub-second queries using composite indexes, partitioning and materialised views.
  4. 04Delivered Power BI dashboards for revenue, backlog and utilisation, with automated weekly backlog snapshots for trends.

Screens

Backlog dashboard mock-up with total backlog, change orders and backlog by location
Backlog dashboard mock-up with total backlog, change orders and backlog by location
Productivity dashboard mock-up with project status and performance by office
Productivity dashboard mock-up with project status and performance by office

75%+

catalogue coverage, up from 15%

E-commerce intelligence platform · Data engineering

From 15% to 75% catalogue coverage on Snowflake

faster database loads
10–20xfaster database loads
products per run
100k+products per run
Read the case study

Want results like these on your project?

Tell me what you are building and where it hurts, and I will come back with questions or a plan.