Portfolio
SaaS & Platform Engineering

Real-Time Multi-City Logistics ERP & Dispatch Engine

End-to-end multi-tenant logistics platform featuring live driver telemetry via Redis SSE, 3-tier Row-Level Security (RLS), automated ledger reconciliation, and 4-city dispatch coverage.

Case Study on Contra
<300ms
Live Telemetry
Redis SSE push to all connected dashboards
3
RBAC Tiers
Admin / Operator / Driver with PostgreSQL RLS
4
City Coverage
Multi-tenant isolation per regional branch
Automated
Reconciliation
Nightly ledger close with audit trail
The Problem

Regional logistics operators managing multi-city fleets need real-time dispatch visibility, strict multi-tenant data isolation between clients, and automated financial reconciliation — without off-the-shelf enterprise software costing $50k+/year.

The Solution

A multi-tenant Next.js + Express backend with Redis Server-Sent Events for sub-300ms live telemetry, PostgreSQL RLS enforcing 3-tier RBAC (admin/operator/driver), a React Native driver app synced via the same API, and an automated ledger reconciliation engine that closes books nightly.

Architecture Highlights

01

Sub-300ms live driver telemetry via Redis Server-Sent Events — no polling, no WebSocket overhead

02

3-tier PostgreSQL RLS: every query is scoped to tenant + role at the database level

03

React Native driver app sharing the same API contract as the web dashboard

04

Automated nightly ledger reconciliation with discrepancy alerts

05

Multi-tenant architecture: each city branch sees only its own fleet and financials

Tech Stack

Next.jsReact NativeExpress.jsSupabase PostgreSQLRedis SSERow-Level Security (RLS)TypeScript

Want something similar?

Available for Founding Engineer roles & architecture contracts.

Discuss ProjectAll Projects