Back to projects
Industrial
2023
Production
Truck Monitoring System
Fleet telemetry platform collecting position, fuel level, engine hours and driver events from in-cab devices.
- Role
- Backend & dashboard engineer
- Duration
- 6 months
- Status
- Production

Background
The operator managed 40 trucks with paper logs and phone calls, leaving fuel losses and route deviations undetected.
Problem
No visibility into vehicle location or fuel consumption between checkpoints, and no evidence trail for customer disputes.
Solution
GSM telemetry units publish position and sensor data on an interval and on event. The backend applies geofence rules and generates daily utilization and fuel reports.
Features
- Live map with clustered vehicle markers
- Geofence entry/exit alerts
- Fuel level trend and theft detection
- Trip history replay
- Driver behaviour scoring
Architecture
- 1In-cab GSM/GPS telemetry unit
- 2MQTT ingestion with per-vehicle topics
- 3Rules engine for geofence and threshold alerts
- 4PostgreSQL with partitioned position tables
- 5React + Leaflet operations dashboard
Challenges
- Sparse GPS in tunnels and remote routes required path interpolation.
- High write volume was solved with table partitioning and batched inserts.
Lessons Learned
- Store raw telemetry forever, derive metrics on read.
- Reports drive adoption more than live maps do.
Gallery

Related projects
Industrial
Elevator Monitoring System
Real-time monitoring and fault alerting platform for 60+ elevator units across multiple buildings.
View detailWeb
Library Management System
Circulation, cataloguing and member management platform for a campus library.
View detailWeb
Book Store
Online bookstore with catalogue, cart, checkout and order tracking.
View detail