HRHalden Ross ~/$
Book a call
booking new engagements — from August 2026mainUS Mountain (UTC−7) · overlaps US + EU morningsresp < 1 business day
Commerce / ERP · 2025

Replaced a fragile nightly batch with a 28-second sync

Inventory and orders were synced to a legacy ERP by a nightly batch that broke weekly and left data a day stale. I replaced it with an event-driven pipeline.

Integration engineer (contract)Fixed-scope project6 weeksAPIs & Integrations →
measured outcome
24h→28s
data freshness
−96%
oversell incidents
99.95%
sync success rate
0
lost events (outbox pattern)

// The problem

A nightly cron synced inventory and orders to an ERP. It failed often, was hard to debug, and meant the storefront showed day-old stock — causing oversells.

// The approach

Outbox + event stream — durable, observable, near-real-time.
  1. Mapped the failure modes of the existing batch and the ERP’s brittle API limits.
  2. Introduced an event stream: domain events published on every inventory and order change.
  3. Built an integration service with idempotency, retries with backoff, and a dead-letter queue.
  4. Added an outbox pattern so events are never lost even if the ERP is down.
  5. Wired tracing and alerts so a stuck sync pages someone with the exact failing record.
stack
GoKafkaPostgreSQLOpenTelemetryAWSTerraform
Our storefront finally tells the truth about stock. The whole thing just works, and when it hiccups we know exactly why.
Sam Okafor, Director of Engineering — Wholesale distributor
Start a conversation Next: Embedded for two quarters — deploys 4×, pages down 52%

Case studies, metrics, prior companies, and testimonials in this template are illustrative and anonymized for demonstration; they do not name or represent any real client or employer and are not a guarantee of future results. Outcomes vary by system, team, and constraints.

next step

Have something that has to ship — or stay up?

Book a 30-minute call. We’ll talk through what you’re building, what hurts, and whether I’m the right person for it. No charge, no pitch — and a scoped plan before any work begins.

Book a call hello@haldenross.example