Selected Work — Case Study

HIL
Transport

Client
HIL Transport — Dubai, UAE
Industry
Container transportation & freight logistics
Type
Internal enterprise web application (PWA)
Stack
React · Vite · Supabase · Cloudflare Pages · Sentry
Status
Live in production, ongoing maintenance
Admin Portal — anonymized
HIL Transport admin dashboard
0%

Less Manual Data Entry vs Excel

0

Role-Based Portals

0s

Real-Time Sync Across Portals

0

Data Lost in Low-Signal Port Yards

The problem

HIL Transport operates a fleet of trucks moving shipping containers between UAE ports — Jebel Ali, Khalifa, Rashid, Hamriyah — and customer warehouses. Before this platform, every job, commission payment, supplier invoice, fuel receipt, and proof of delivery lived in Excel spreadsheets, passed around on WhatsApp, manually reconciled, and often weeks out of date.

The pain points were expensive ones: blind-spot fuel fraud (drivers over-claiming diesel litres at fuel stations), commission disputes between admin and drivers, lost proof-of-delivery for subcontracted containers, and zero real-time visibility into customer receivables.

The solution

A full-stack custom logistics platform with four role-based portals — Admin, Driver, Supplier, and Accounts — replacing the Excel workflow entirely while preserving the simplicity the team was used to.

01

Column-restricted security

Database-level Row Level Security plus column-restricted RPC functions: a driver can update their delivery status but physically cannot modify a commission rate — even via direct API call.

02

Real-time sync

When a driver signs a Proof of Delivery on their phone, the admin dashboard and supplier portal update within 2 seconds — no refresh. Built on Supabase Realtime across 16 tables.

03

Offline-first PWA

Drivers in container yards regularly lose signal. The app caches the shell, queues writes in IndexedDB, and auto-syncs when connectivity returns — POD submission, status updates, and diesel logging all work fully offline.

04

AI-powered diesel fraud detection

OCR extracts litres and odometer readings from photos, cross-checks them against manual entries, computes km/L, and flags mismatches, suspicious patterns, and round numbers — three independent verification layers in one workflow.

05

Single-use POD links

Suppliers generate a unique URL per container and share it via WhatsApp — the receiver signs on their phone with no login and no app install. The link self-destructs after one submission.

06

Full financial audit trail

Commission logic centralized in one function (9% HIL drivers, 0% supplier jobs). Soft deletes preserve history, every change is logged with a diff view, and CHECK constraints make invalid data impossible to insert.

Diesel reconciliation screen with flagged entries
The highest-impact screen — month-end diesel reconciliation with automatic fraud flags
OCR cross-verification of fuel receipt and odometer
OCR reads the receipt and odometer photos, then cross-checks the driver's manual entry
Driver POD signing flow on a phone
POD signing on the driver's phone
Offline sync queue with pending actions
Offline-first is real — queued writes sync automatically when signal returns

Architecture

Admin Driver (PWA) Supplier Accounts FOUR ROLE PORTALS React + Vite Offline queue (IndexedDB) Optimistic UI · code-splitting OCR capture flows CLOUDFLARE PAGES writes / RPC realtime push Supabase Postgres · Row Level Security Column-restricted RPC functions Realtime — 16 tables Storage — POD photos, receipts SINGLE SOURCE OF TRUTH Sentry · UptimeRobot error tracking (masked PII) · availability Single-use POD links no login · self-destruct after signing

The stack

A modular monolith on React + Vite, deployed to Cloudflare Pages with a Supabase Pro backend. Production monitoring via Sentry with masked PII, UptimeRobot for availability, and an automated pre-deploy quality check. The codebase follows a documented set of 12 engineering principles — from centralized business logic to column-restricted RLS — captured as a reusable best-practices playbook.

React Vite Supabase Cloudflare Pages Sentry PWA · Offline-First

Results

  • ~94% reduction in manual data entry compared to the Excel workflow.
  • Real-time visibility into receivables, commission, and fuel consumption.
  • Zero data loss for drivers working in low-signal port environments.
  • Sub-second perceived responsiveness thanks to optimistic UI and code-splitting.

Screens shown are anonymized recreations of the production interface. This is an internal enterprise application — demo access is not publicly available, but a walkthrough can be arranged for serious enquiries.

Running your operations on spreadsheets and WhatsApp?

This platform replaced exactly that. If your business has outgrown Excel — fleet, trading, distribution, or anything multi-location — the first conversation costs nothing.

Let's Connect →