Plan De Mejora “Implementación de base de datos en Excel” Banco De Bogotá Banca Vivienda – Crédito constructor

Abstract

In this improvement plan work, we present and evidence the results that were obtained as an objective when developing a database in which all the information is attached through pivot tables with the APERCAN report to improve the processes that are handled manually. The reports of Builder Credit of Banco de Bogotá arrive daily, and the information obtained is very long and some data can be missed or lost. The implementation of these pivot tables will allow Banco de Bogotá's construction credit area to have concrete and accurate information on a weekly basis about the loans to which disbursements have been made and those for which the bank has received payments. With this implementation, the specialists will have a better view of how their projections are and thus be able to make a decision regarding the loan and have direct communication with the client who is waiting or has not complied with certain agreements.