AI & Data
Calibrate BI Dashboard
2.26M transactions and $7.79M revenue modeled over 18 SQL views. Big queries return in under 200ms.
- Client
- Calibrate Network
- Industry
- Logistics / 3PL
- Role
- Lead Full-Stack Engineer
- Stack
- Next.js · React 19 · Flask
Problem
A 3PL logistics operator needed to reliably sync and analyze 975K+ rows from Logiwa WMS in real-time without API timeouts.
Approach
Engineered a Python ETL pipeline on Google Cloud Run feeding into BigQuery, surfaced via a Next.js App Router dashboard.
Outcome
Delivered a sub-200ms API response time on massive datasets, enabling real-time revenue tracking for 56 clients.
Next.jsReact 19FlaskBigQueryCloud Run
This was ai & data work — see the service page.
Have a project like this?
Tell me what you're solving. I reply within one business day.