High-Concurrency Real-Time Logistics ERP & Dispatch Platform

• Role: Lead Full-Stack Architect • Deliverables: Multi-Role Web Platform, Real-time SSE Dispatcher, Waybill PDF Generator, Android App API • Timeline: 8 Weeks

OVERVIEW A growing B2B/B2C courier and freight business was bottlenecked by manual phone dispatching, unstandardized pricing formulas, and physical paper waybills. I designed and deployed an end-to-end operations platform and mobile dispatch system serving administrators, operators, and field couriers with real-time state synchronization.

THE PROBLEM & DIAGNOSIS Fragmented State: Dispatchers, managers, and drivers worked from different spreadsheets, leading to lost packages and miscommunication.

Ad-hoc Pricing: Freight costs were estimated manually by operators, causing revenue leakage and inconsistent quotes.

Lack of Real-Time Visibility: Order status updates depended entirely on phone calls.

KEY ARCHITECTURAL DECISIONS • Decision 01: Strict Role-Based Access Control (RBAC) Architected 3 distinct role interfaces (Admin, Dispatcher, Driver) on a unified database schema with row-level security and permission boundaries. • Decision 02: Server-Sent Events (SSE) Live Feed Replaced heavy database polling with a lightweight SSE pipeline, pushing instant status updates to dispatchers and couriers under high concurrency. • Decision 03: Automated Pricing & PDF Waybill Engine Built a deterministic calculation engine based on volumetric weight and zones, coupled with automated instant PDF generation.

MEASURABLE RESULTS & IMPACT • 100% elimination of manual paper waybills via instant automated PDF generation. • Sub-second dispatch notifications via persistent SSE connections. • Deployed in live production powering daily logistics operations.

TECH STACK Next.js, Express.js, Supabase, PostgreSQL, Redis, Server-Sent Events (SSE), Tailwind CSS, Docker.