Context
A Fortune 500 importer raised an issue with their customs brokerage: the reports they were receiving didn't match their internal records. The discrepancy had been building for weeks. Their contract was up for renewal in 30 days.
Diagnosis
The system appeared to be running normally. But the failure was in a processing layer pulled from a vendor's upstream system — the kind of silent break that leaves no error logs and doesn't trip any monitoring. Wrong numbers had been reaching client-facing reports cleanly.
The Build
I built a Power BI validation layer to cross-check the vendor's calculations against source-of-truth data, identified the full set of errors, rewrote the affected logic, and added automated validation so similar failures would surface internally before reaching any client-facing report. Then I audited the rest of the pipeline for the same exposure.
Outcome
The client started receiving accurate reports the same week. The contract was signed for a multi-year renewal. The brokerage now runs with a monitoring layer that surfaces data issues internally — before any client ever sees them.