Desarrollo de un sistema web para automatizar los procesos de gestión de inventarios en la Dirección Nacional de Investigación Técnico Científica Policial

Abstract

Manual processes related to inventory management at the National Directorate of Technical-Scientific Police Investigation affect the proper performance and workload of the warehouse personnel. Data compilation and report generation are impacted by the reliance on these manual procedures, leading to delays, information loss, disorganization, and inaccuracies. To address this issue, an inventory management system was developed and implemented to optimize the execution time of these manual processes and reduce human error associated with non-automated workflows. This solution improves operational performance and streamlines process completion times. The development followed an agile methodology known as Extreme Programming (XP). The technologies used include React and Node.js within a hexagonal architecture to ensure system scalability and maintainability, MySQL as the database, and TypeScript as the programming language. Requirements were gathered following the IEEE 830 standard. The implementation of this system reduced the completion time of key processes such as inventory management, reporting, supply location, and information tracking. The average time reduction achieved through the system was 73.8%, significantly alleviating the operational workload of warehouse staff at the National Directorate of Technical-Scientific Police Investigation. The system is designed for scalability and maintainability based on user needs.