Eficiencia en la Auditoría de Obras Civiles: Desarrollo e Implementación de un Motor de Busqueda para la Contraloría General de Boyacá

Abstract

During the internship in the Civil Works Office of the Office of the Comptroller General of Boyacá, I participated in the monitoring and auditing of contracts in various municipalities of the department. The work consisted of supporting the lead auditor in the review of contracts, analyzing documents from SECOP I and II, as well as the documentation sent by the mayor's offices. This process included verifying the quantities and costs specified in the contracts through field inspections to ensure conformity with the prices established by the governor's office, culminating in the preparation of detailed reports. To optimize this process and improve the efficiency of the Civil Works Office engineers, the need was identified to develop a search engine using Excel. This search engine was designed to generate organized documents with all the necessary information for report writing. The tool facilitates quick access to information carriers, ensuring that auditors have the relevant data in a structured and efficient manner. Using Excel as the main platform, a system was designed that allows engineers to easily access relevant information on audited contracts. The system organizes the data in a structured manner, facilitating the writing of detailed reports and ensuring that the auditors have the necessary backup for their work in an accurate and timely manner. This project not only contributed to my professional development as a civil engineer, but also provided a valuable tool to improve transparency and efficiency in the management of civil works contracts in the Office of the Comptroller General of Boyacá.