Sistema de gestión de recomendaciones de la Contraloría General del Estado para el “Gobierno Autónomo Descentralizado Municipalidad de Ambato”

Abstract

In Ecuador, the Comptroller General of the State (CGE) supervises the use of state resources in the Municipal Decentralized Autonomous Governments (Municipal GADs) through audits that generate crucial recommendations. The Municipality of Ambato faces difficulties in tracking and implementing these recommendations due to inefficient systems, making it challenging to meet the established deadlines. This project aimed to develop and implement a recommendation management system using Oracle APEX and the Extreme Programming (XP) methodology to improve efficiency and effectiveness in managing these recommendations. The system leveraged Oracle APEX for integration with existing technologies, while the XP methodology facilitated agile and collaborative development. Additionally, Business Process Model and Notation (BPMN) was used to optimize work processes, allowing for the automation and centralization of information, significantly enhancing operational efficiency and reducing errors. To evaluate the usability of the system, a survey based on the Technology Acceptance Model (TAM) was applied, validated with a Cronbach's alpha of 0.95, indicating high internal consistency. The results revealed a high acceptance of the system among users, demonstrating its effectiveness and efficiency. Thus, the developed system has significantly optimized the management of recommendations, improving internal communication. The use of Oracle APEX and the XP methodology has laid the foundation for future improvements and technological expansions within the institution, thereby promoting better use of state resources and greater transparency in management.