Results
- Download and upload jobs run every 5 minutes in production
- About 11 production pipelines, plus daily and weekly reconciliations
The problem
The warehouse runs on Manhattan SCALE, and finance and inventory run on NetSuite. Every gap between the two systems turned into billing errors, inventory drift and manual clean-up.
What I built
- Airflow pipelines on Amazon MWAA. Items, customers, POs, sales orders and work orders with BOMs flow down to the WMS every five minutes. An upload sequence posts warehouse activity back to NetSuite.
- Six NetSuite RESTlets on a shared library: builds, inventory transactions, receipts, shipments, inventory balance and close transaction.
- Reconciliation jobs:
- Daily and weekly runs for finished-goods build catch-up and finished-goods billing.
- A NetSuite-vs-WMS inventory comparison, and a balance sync from the WMS database.
- Production-grade delivery. Separate dev and prod environments, SDF-managed scripts, and automatic deploys from GitHub Actions.
Why it matters
Warehouse and finance work from the same numbers, and mismatches surface in a report instead of at month end.