Work
Systems in production.
Case studies from our data engineering and analytics practice: the problem, what we built, and what changed.
Selected projects
Case studies
Names are shared with permission. Each one links to a short write-up.
ADP payroll and time card data, event-driven into Azure SQL
Three ADP APIs integrated through Azure Functions and Data Factory, with webhook-triggered loads, hash-based duplicate prevention and a historical backfill.
Read the case studyJ.P. Morgan balances and transactions, loaded daily
Certificate-based OAuth to the bank's treasury APIs, then daily account balances and transaction detail into Azure SQL for cash reporting.
Read the case studyFull ETL platform migration into the client's own Azure tenant
Aspire, Acumatica, Fleetio, HubSpot and Ramp pipelines rebuilt in the client's tenant with managed identity, an exact-match historic seed and a same-day cutover.
Read the case studyInventory, forecast accuracy and OEE reporting in Power BI
Operations analytics across two plants: days on hand with zero-stock visibility, purchase forecasting, forecast accuracy by salesperson and machine-level OEE.
Read the case studyWant a project like one of these?
We will walk you through the closest match and what it would take for your business.