Custom Supply Chain & Inventory Portal for Global Logistics
Technical Environment
Disjointed spreadsheets and legacy desktop software across 6 regional warehouses
The Business & Engineering Challenge
The client suffered from frequent inventory discrepancies, manual re-entry errors, lack of real-time shipment visibility, and inability to integrate with major carrier APIs.
Architecture Overview
Next.js frontend with Tailwind CSS and TanStack Query, backed by Python FastAPI asynchronous services, PostgreSQL database with PostGIS spatial tracking, and Redis pub/sub queue.
Implementation Approach
- Conducted on-site warehouse discovery and mapped operational workflows
- Built responsive mobile-first warehouse scanning UI with offline synchronization
- Created asynchronous webhooks integrating with FedEx, DHL, and customs freight APIs
- Deployed automated end-to-end testing preventing order calculation discrepancies
Demonstrated Business & Technical Impact
Custom Supply Chain & Inventory Portal for Global Logistics — System Topology
Next.js 16 Web Portal
Server Components + Edge CDN caching
Tailwind CSS v4
Responsive mobile-first interfaces
Kong / Envoy Gateway
Rate-limiting & TLS termination
JWT / OAuth2 Auth
Role-based permission tokens
Python FastAPI Services
High-throughput spatial calculation
Node.js Event Workers
Asynchronous webhooks & carrier sync
PostgreSQL (PostGIS)
ACID ledger with spatial indexes
Redis Cache & Pub/Sub
Sub-millisecond query caching


