Refactorización y Optimización del Backend de la Plataforma “PlanearPro” para la Gestión de Proyectos en la Empresa Ideapro

Abstract

The PlanearPro project addresses the challenges faced by territorial entities in managing the public investment cycle, including limited process automation, outdated information, and weak traceability across planning, execution, and monitoring stages. These issues negatively impact administrative efficiency, report reliability, and transparency in public resource management. Within the framework of an industry internship conducted at the company Ideapro, the project focused on optimizing the Backend of the PlanearPro platform through database refactoring and the development of planning and execution modules using Java and the Spring Boot framework. The platform is integrated with Colombia’s Integrated Public Investment Platform (PIIP) and the General Adjusted Methodology (MGA) of the National Planning Department, enhancing project traceability, control, and monitoring. As a result, PlanearPro improves project data loading, management, and evaluation processes, reduces operational errors, and replaces manual methods such as spreadsheet-based workflows. System testing carried out in municipalities in the department of Boyacá validated its functionality in real-world public administration contexts, contributing to more efficient, transparent, and reliable public management.