Desarrollo de aplicación web para la automatización de la fiscalización y subida de información de las redes de distribución al sistema de información geográfica de la Empresa Eléctrica Ambato Regional Centro Norte S.A.

Abstract

This project was born with the need to automate the review process of the "Hojas de Estacamiento" received by the Planning Department of Empresa Electrica Ambato Regional Centro Norte S.A., the review of these sheets is a process that takes approximately thirty minutes and for each error found added more time in its review. First, in the requirements gathering for the development of the system, surveys and interviews were conducted with EEASA staff in order to obtain technical and functional requirements that would allow the understanding of the processes they manage and use them in favor of the automation and development of the system. For the storage of digital files, we opted for BLOB data types because it gives greater advantage than using external storage. Secondly, agile methodologies were investigated to facilitate the development of the application, giving OOHDM as the best option, during its early stages of development allows to generate a code base from its diagrams. On the one hand, it speeds up the development of the application, on the other hand, it takes time to diagram, define its navigational context and create abstract views, but in the end, it is time invested for the benefit of the development stage of the methodology. Finally, as technological tools. Spring Boot and Oracle were used as a requirement requested by the head of the PD. Also. Angular was selected as the best Front-End framework in a comparison with other tools. In short, the system is currently being used by all contractors, allowing them to upload their files and obtain their certificate at any time of the day, at the same time, the work used by the DP administrative staff was reduced considerably.