Desarrollo del backend para un sistema de automatización de la gestión de proyectos de vinculación en la universidad católica de cuenca utilizando metodologías ágiles e inteligencia artificial

Abstract

This research presents the development of a backend that automates the management of outreach projects at the Catholic University of Cuenca. The platform takes the information requested by the institutional format F-VS-41, verifies budgetary coherence, and generates the official Word document using dynamic templates and HTML blocks via the altChunk technique. Annexes are stored centrally in AWS S3, and natural language queries are resolved with Oracle Select AI on controlled views in Oracle Autonomous Database, preventing users from having to manually review the entire document. The system's structure followed a hybrid methodology based on Scrum and complemented by elements of the Rational Unified Process (RUP). It was developed in eight sprints covering authentication with JWT, persistence with JPA, dynamic document generation, attachment management, and artificial intelligence integration. Requirements engineering and solution evaluation were supported by the FURPS+ model. Functional (Postman) and load (JMeter) tests with 100 and 200 concurrent users demonstrated acceptable performance within the environment's limitations. In individual measurements, authentication operations (registration and login) respond in the order of hundreds of milliseconds; under sustained load, latency can increase to a few seconds due to the use of free versions of the database, S3, and the deployment platform. The generation of the F VS 41 document varies around 20–30 s when simulating 100 users and approaches 50 s with 200 users. Despite this, test coverage reaches 82%, and no discrepancies were observed between the amounts stored and those reflected in the final file. The developed system eliminates transcription errors, prevents rework, and accelerates the creation of the F VS 41, while also establishing a scalable foundation for incorporating extensions such as electronic signatures, a web interface, and social impact analytics. This automation contributes to strengthening traceability and transparency in the management of outreach projects, allowing for the demonstration, with verifiable data, of the social relevance of university initiatives.