Diseño e implementación de una aplicación web para la gestión y trazabilidad de actas de salida de materiales en el área de inspecciones de ENEL Colombia

Abstract

This undergraduate project aimed to design and implement a web application to automate the management and traceability of Material Dispatch Records (Actas de Salida, AS) in the Inspections Department of Enel Colombia. The identified problem was related to the manual processing of multiple Excel files with non-standardized structures, resulting in long processing times, high operational workload, increased risk of human error, and limited traceability of technical assets. To address these challenges, a web application was developed using Python, PostgreSQL, and Streamlit. The proposed solution implements an Extract, Transform, and Load (ETL) process capable of automatically reading files, detecting headers, cleaning and transforming data, and performing bulk uploads into a centralized database. Additionally, an intuitive web interface was developed to allow users to search materials by serial number, reference, or item code, as well as to perform both manual and bulk file uploads while preventing duplicate records. The system was validated using real operational data from the Inspections Department, processing 21 Material Dispatch Records containing more than 15,000 serialized material records. The results demonstrated a processing time reduction of over 99%, a significant decrease in manual intervention, and improvements in data quality, availability, and traceability. The proposed solution strengthened operational control, streamlined material verification processes, and supported decision-making by automating a task that previously relied on repetitive and time-consuming manual activities.