Operational Context & Objectives
The client distributed thousands of freight shipments weekly across multiple national carriers. Each carrier generated complex, opaque billing statements containing surcharges, dimensional weight adjustments, fuel indexing, and accessorial fees.
Reconciliation was managed manually by three full-time analysts using giant Excel spreadsheets. Because manual auditing took 14 business days per billing cycle, hundreds of thousands of dollars in erroneous carrier surcharges slipped past payment approval deadlines without dispute.
Engineering Architecture & Delivery
I engineered an automated data ingestion and cross-reconciliation pipeline that interfaces directly with carrier electronic data interchange (EDI) feeds, shipping APIs, and the client's internal ERP dispatch database.
The pipeline normalizes divergent carrier invoice formats, automatically cross-checks billed dimensions and weights against actual scan logs at the warehouse scale, recalculates negotiated contract rates, and flags unauthorized charges within minutes of invoice receipt.
Explore this consulting service
This project leverages core methodologies from the Process Optimization & Automation consulting practice.