NetSuite–Boomi Integration Framework
CompletedEnterprise-grade bidirectional data pipeline connecting NetSuite ERP and Boomi AtomSphere, processing 50k+ transactions per day with sub-3s latency.
Tech Stack
Designed and implemented a production integration framework connecting NetSuite (ERP) and Dell Boomi (iPaaS) to synchronise customer orders, inventory levels, and financial records across a mid-market retail organisation.
The architecture uses a hub-and-spoke pattern: Boomi acts as the orchestration layer, consuming NetSuite RESTlets for CRUD operations and exposing normalised payloads to downstream systems via JMS queues. Error handling employs exponential back-off with dead-letter routing to a Supabase audit table, giving operations staff full visibility into failed records without code changes.
Outcome: reduced manual reconciliation time by 90 %, eliminated a nightly batch job that caused a 4-hour data lag, and cut integration-related support tickets from ~20/week to <2/week.
Other Projects
A dbt + Databricks pipeline using a medallion (Bronze→Silver→Gold→Mart) architecture to turn raw ERP data into analytics-ready models for manufacturing, inventory, sales, and workforce reporting.
Serverless appointment-slot monitor for Australian visa applications — sends real-time alerts when new slots open, built on Playwright, Vercel Cron, and Supabase.
A collection of SQL scripts, pgBadger dashboards, and Python automation tools for diagnosing and resolving slow-query issues in high-traffic PostgreSQL clusters.