Full-Stack Web Application
FleetHub | Enterprise Fleet & Visa Management Platform
FleetHub is a comprehensive enterprise-level web application designed to streamline fleet management operations, visa processing, financial tracking, and compliance management for transportation companies. Built with modern technologies, it handles complex business workflows involving vehicles, drivers, customers, corporate contracts, and multi-entity financial transactions.
Project Overview
FleetHub is a comprehensive enterprise-level web application that transforms how fleet management companies in the UAE transportation sector operate. The platform eliminates operational fragmentation by consolidating 5+ disconnected systems into a single, powerful application.
The system addresses critical business challenges including multi-national visa processing, complex vehicle ownership models (owned, financed, rented), multi-partner vehicle ownership with percentage allocation, and sophisticated financial tracking across multiple entities. Every aspect of fleet operations is managed through an intuitive interface with real-time visibility.
Built with a robust database schema featuring 27 interconnected tables, FleetHub handles the complete lifecycle of vehicles - from purchase through operation to sale - while maintaining comprehensive audit trails for compliance. The platform supports multiple ownership models, tracks insurance and registration, manages driver assignments, and documents traffic accidents with complete historical preservation.
The financial system is particularly sophisticated, supporting invoice generation for 6 different entity types (customers, companies, drivers, vehicles, suppliers, applications) with automated tax calculations, discount management, installment tracking, and multi-currency precision. The double-entry accounting system ensures financial accuracy with automated reconciliation.
FleetHub's visa and application processing module streamlines the entire workflow from request submission through completion, handling labor transfers, document uploads, and payment tracking. The contract management system enables corporate fleet arrangements with custom pricing per vehicle and automated invoice generation.
Designed for scalability and built with enterprise-grade security including role-based access control, comprehensive audit logging, and session management, FleetHub delivers measurable business impact: 70% reduction in data entry time, 99% faster decision making, and 15% improvement in data accuracy.
Key Features
Challenges
- Designing a database schema to support 6 different invoice entity types while maintaining referential integrity
- Implementing flexible vehicle ownership models (owned, financed, in-house financed, rented) in a single table
- Managing 40+ database migrations over 3 months while preserving production data with zero loss
- Ensuring precise financial calculations across multi-currency transactions with proper decimal handling
- Building performant search across 27 interconnected tables with sub-200ms response times
- Handling complex multi-partner vehicle ownership with percentage allocations and visa company associations
- Creating a polymorphic invoice system that prevents orphaned records and maintains data integrity
- Implementing cascade deletion rules that preserve critical business data while removing dependencies
- Optimizing database queries for large datasets with proper indexing strategies
- Managing complex business workflows involving vehicles, drivers, customers, and corporate contracts
Solutions
- Implemented optional foreign keys with application-level validation ensuring exactly one entity per invoice
- Designed conditional schema with discriminator field (ownedOrFinanced) dynamically showing/hiding relevant fields
- Adopted incremental migration approach with backups, testing, and reversible migrations for data safety
- Used PostgreSQL DECIMAL(12,2) for all financial amounts with server-side-only calculations and consistent rounding
- Built intelligent search with entity-specific indexes, parallel queries, and result prioritization
- Created VehiclePartner junction table supporting multiple partners per vehicle with ownership percentages
- Developed validateInvoice() function enforcing business rules at the application layer
- Utilized Prisma cascade rules with careful onDelete behaviors and soft deletes for critical data
- Implemented Prisma include for eager loading, database indexes on foreign keys, and query result caching
- Designed 27-table normalized database with referential integrity and materialized views for performance
Results & Impact
efficiency
70% reduction in data entry time (from 20 hrs/week to 6 hrs/week)
reporting
Real-time report generation vs 2-3 days previously - instant access
accuracy
15% improvement in data accuracy (from 80-85% to 98-99%)
consolidation
80% reduction in systems used (from 5+ tools to 1 platform)
decision Making
99% faster decision making (from days to minutes)
search Performance
Sub-200ms search across entire 27-table database
data Integrity
Zero data loss across 40+ database migrations
scalability
Successfully handles complex workflows for transportation companies
Project Info
Client Type
UAE Transportation Company - Enterprise Client
Duration
4 months (September 2025 - December 2025)
My Role
Full-Stack Developer & System Architect
Team Size
Solo Development
Technologies Used
Tags