Practica Empresarial desarrollo e implementación de una plataforma integral para la gestión de mantenimiento preventivo y correctivo, control de inventarios y monitoreo manual de horómetros con generación de alarmas, basada en PostgreSQL y java swing

Abstract

Problem: At Soluciones Omega S.A, maintenance management was carried out manually in Excel spreadsheets, which made it difficult to track information, control spare parts, and plan activities, leading to inefficiencies and the risk of data loss. Objective: To design and implement a comprehensive preventive and corrective maintenance system that would centralize information, automate alarms, and strengthen inventory management in order to optimize equipment availability and operational efficiency. Method: A five-phase methodology was applied: requirements analysis, database design in PostgreSQL, interface development in Java Swing with FlatLaf, implementation of security measures through token authentication, and functional testing in the real environment. Results: The system integrated the modules for preventive and corrective maintenance, inventory management, and work order generation. Planning was improved through automatic alarms, exporting reports to Excel, and detailed control of spare parts inputs and outputs. The results show that the solution reduced downtime, strengthened the traceability of interventions, and ensured the availability of supplies, representing a significant contribution to the optimization of maintenance processes in the business context.