LabTrans/UFSCFull-Stack Engineer
Jun. 2021 - May. 2024Florianópolis, Santa Catarina, BrazilAnalysis and development of a web system in the ICM (Maintenance Condition Index) project of the Transport and Logistics Laboratory (LabTrans) of the Federal University of Santa Catarina (UFSC). Problem Statement:
The ICM project, developed for the Brazilian National Department of Infrastructure and Transport (DNIT), aimed to create a system uses footage of federal highways to manage and maintain the condition of these roads. One of the core challenges during the development of the ICM-Web Application was a significant performance issue. The web application struggled under heavy user load, leading to slow response times, which threatened the overall efficiency and user satisfaction. Solution:
The ICM system comprised three main modules: the DNIT-ICM Desktop Application, the ICM-Mobile Application, and the ICM-Web Application. The ICM-Web Application, built with a Node.js back-end and a Microsoft SQL Server database, and a React.js front-end, provided highway managers with detailed reports and charts about road conditions. To address the performance issue, I conducted a thorough analysis of the codebase and identified inefficient database queries as the primary bottleneck. I addressed performance issues by optimizing inefficient database queries, implementing caching, and applying asynchronous processes to enhance efficiency. Result:
The optimizations significantly enhanced the application's performance, resulting in faster response times and a much smoother user experience, even under heavy loads. These improvements enabled highway managers to access critical information more quickly and efficiently, ensuring the system operated reliably during peak usage periods. This project solidified my expertise in Node.js and React.