Módulo web para la gestión de sistemas de información, programación de backups y reportes de mantenimiento del Hospital Universitario San Rafael de Tunja

Abstract

This internship thesis describes the development and implementation of a web module for the San Rafael University Hospital of Tunja (HUSRT), integrated into the existing HUSRT-Biomédica system. The main objective was to centralize and automate the management of information systems, backup scheduling, and maintenance reports to address the operational gaps identified in the Information Technology Department (ITD). Problem: The hospital lacked a unified system inventory; backups were managed manually without a visible calendar or alerts; access control was insufficient; and the service desk was not integrated with the equipment inventory. Developed Solution: A module was built featuring: Information systems parameterization (CRUD with Angular, Express, and MariaDB). Automated backup scheduling with 7 configurable frequencies (daily, weekly, biweekly, monthly, quarterly, semi-annually, annual) and automatic yearly occurrence generation. Interactive visual calendar with color coding by status (Scheduled, Completed, Not Done, Failed), tooltips, management modals, and Excel export. Reactive alerts via a bell with badge and overlay panel, with auto-regeneration of the next backup upon completion. Granular access control based on role and assigned systems, including the new SYSTEMUSER role. Service Desk integration with the equipment inventory, allowing cases to be linked to equipment and generating structured maintenance reports upon case closure. Methodology: An agile approach was used with 27 epics and 69 user stories, validated by the company tutor. Technologies included Angular 17 (standalone), Node.js + Express, Sequelize (ORM), and MariaDB, with PrimeNG for the UI and JWT for authentication. Results: The module was approved and deployed to production, reducing backup monitoring time from several hours per week to less than 30 minutes daily, eliminating forgotten backups, improving information security (aligned with Colombian Law 1581 of 2012), and providing complete traceability of equipment maintenance.