NetSuite–Boomi Integration Framework
已完成Enterprise-grade bidirectional data pipeline connecting NetSuite ERP and Boomi AtomSphere, processing 50 k+ transactions per day with sub-3 s latency.
技术栈
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.
其他项目
Internal data cataloguing and lineage platform integrating dbt, Metabase, and Supabase to give a 200-person org a single source of truth for 300+ data assets.
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.