Commercial Daily Delinquency Report Automation for a Banking Institution in Puerto Rico

Abstract

Commercial credit risk management entails the monitoring of key performance indicators, including delinquency ratios, for the commercial loan portfolio. The Commercial Credit Risk (CCR) team in a banking institution in Puerto Rico provides a Commercial Daily Delinquency Report for Business Units to provide visibility of delinquency metrics and direct risk mitigation efforts. However, the report is prepared manually and takes a considerable time to prepare. The CCR team embarked on a project to automate the report to create efficiencies and improve the allocation of resources. The Extreme Programming methodology was selected due to its suitability for the nature of the project and the team size. After the automation was finished, efficiency increased since the time required to complete the report was reduced by 75% and resource availability improved by 20%. Key Terms ⎯ Automation, credit risk, delinquency, extreme programming.