Fleet Control System & Python Data Analysis
Public Sector – Municipality of Umuarama
Robust internal system developed to manage municipal fleet dispatch, drivers, public yards, and fuel expenditure at the Municipality of Umuarama. The application evolved with the integration of an automated Python data analysis pipeline to process raw log spreadsheets.
Hybrid Laravel + Python Integration & Data Processing
Developed a Python robot (using Pandas and OpenPyXL) to parse, sanitize, and statistically analyze raw fuel and odometer logs, detecting consumption anomalies and generating executive analytical reports for public expenditure savings. Backend structured in Laravel with Docker/Sail for absolute reliability.
Impact & Results
Complete automation of refueling and odometer data consolidation, providing reliable analytics that support municipal fuel expenditure reduction.
Lessons Learned
The necessity of decoupling heavy ETL pipelines into asynchronous Python scripts and containerizing the stack with Docker/Sail for absolute reproducibility.
Stack & Engineering Components
- Laravel 12 (MVC)
- Docker & Docker Compose
- Python (Pandas, OpenPyXL)
- Relational MySQL
- Tailwind CSS
Internal Corporate System
This software operates exclusively within the private infrastructure of the Municipality of Umuarama. Source code and external access are restricted by institutional security policies and public data confidentiality.