Lojaroute

Problem

Logistics companies were dispatching vehicles manually, deliveries went unverified at handoff, and cash-on-delivery was reconciled on paper. Without centralized tracking, dispatchers were flying blind.

Solution

A multi-tenant fleet management system consisting of a dispatcher dashboard and a driver mobile application. Features database-level tenant isolation, GPS tracking, and automated cash reconciliation.

Key Features

• Server-enforced multi-tenant isolation, ensuring secure branch-level data segmentation within normalized MySQL schemas
• Cryptographically signed QR code scanning for pickup and delivery verification, eliminating handover disputes without SMS/OTP overhead
• Optimized real-time telemetry pipeline utilizing Ably, delivering low-latency driver location syncs to the dispatcher UI
• Non-blocking Cash on Delivery (COD) state machine with automated timeout reconciliation queue workers
• Real-time GPS tracking and route playback using MapLibre GL with stop-centroid detection
• Automated cleanup and recovery workers for transaction gateway sessions using PayMongo APIs
• B2B connection portal featuring self-registration, KYB document verification, and contract-specific rate cards

Challenges

• Enforcing secure tenant and branch data isolation across 95+ relational database tables at the query middleware layer.
• Handling high-frequency GPS coordinate streams in the React frontend without causing main-thread rendering lag or UI performance issues.
• Developing a secure physical handoff verification system that operates reliably in low-connectivity areas, bypassing SMS dependency.

Results

• Shipped a fleet management system with multi-tenancy, B2B client registration, and automated billing.
• Reduced booking creation time by implementing a multi-step booking wizard with real-time price estimation and draft persistence.
• Automated COD payment reconciliation pipelines, minimizing driver delays at delivery handoffs.