Módulos de sistemas web para la gestión de Procesos en el Hospital Universitario San Rafael de Tunja

Abstract

This report documents the business internship carried out by Daniel Estiven Ramírez Muñoz at the Hospital Universitario San Rafael de Tunja, a high-complexity healthcare institution that faced deficiencies in the management of technological processes within its IT department, particularly the lack of formal control over the spare-parts inventory used for equipment maintenance. In response to this problem, two modules were designed and developed to extend the institutional system HRCATCH 2.0: the Spare Parts Management Module and the Systems Indicators Module. The work was carried out under the SCRUM agile methodology, organized into four sprints over fourteen weeks, and implemented an MVC architecture with Angular on the frontend, Node.js/Express.js on the backend, and MariaDB as the database engine, using Sequelize as the ORM. The spare-parts module centralized the inventory catalog, automated stock deduction, generated minimum-stock alerts, and recorded an immutable audit trail of every operation, while the indicators module provided an interactive dashboard with KPIs for monitoring maintenance performance. The development was validated through functional, integration (22 automated tests using Jest and Supertest), and acceptance testing with the IT department, obtaining stakeholder approval. The results show improved information traceability, the elimination of manual spreadsheet-based control, and the consolidation of a scalable technological foundation for the continuity of the hospital's technological services.