Desarrollo de un sistema de gestión de cobros para servicios de agua y alcantarillado dirigido a la comunidad de San José de Raranga utilizando tecnologías libres.

Abstract

This project presents the development of a web-based billing management system for water and sewage services of the Junta Administradora de Agua Potable y Alcantarillado (JAAPA) in the San José de Raranga community, implemented using open-source technologies such as Java Spring Boot, Angular, and PostgreSQL. Following the waterfall methodology, an exhaustive analysis of existing manual processes was conducted to define 18 functional and 12 non-functional requirements across six modules: billing, cash closing, meters, requests, operator portal, and client portal. The system features an N-Tier layered architecture with JWT authentication, responsive interfaces, and a normalized relational database. Testing validated a 98% success rate and an average response time of 1.5 seconds, successfully automating collections, improving administrative transparency, and establishing a precedent for the digitalization of community public services through open-source software.