This bank’s need to prevent and reduce credit losses from defaulted commercial loans was symptomatic of a greater challenge. It needed a data management program that could help it more effectively manage different aspects of the business. Follow the story of how a new data-driven strategy helped our client triumph over the core challenges of 1) meeting stringent regulatory demands for more robust reporting and 2) dealing with issues surrounding its data and data access.
Each year, banks approve billions of dollars in commercial loans. Throughout the approval process, documents are signed and covenants are created to ensure that funds will be repaid. Funds not repaid within the outlined term can result in higher capital requirements on the institution and, ultimately, credit losses for the bank.
Most often, the only indicator that a loan has gone bad is when payments become delinquent – which is too late. Our client wanted to analyze such scenarios well in advance to prevent payment default. And that’s what led to the need for an improved data management program.
Our team's assessment revealed that this bank’s ability to quickly uncover and manage credit loss was constrained by a lack of consistent, quality data, and by static reporting and manual processes. In addition to regulation issues, other issues to resolve included:
Incomplete and inconsistent data
A desire to have more time to analyze data before monthly, quarterly, and yearly reporting
An inability to see the “story” behind the data
An inability to interact with the data through visualization tools
Summary of deliverables
An Enterprise Data Management framework that included culture, people, process, and technology change management
The enablement of a new data leader, i.e., a chief data officer
Numerous executive dashboards:
Status dashboards – accrual, AQR status, charge-off and recovery, delinquency, and others
Trend dashboards – commercial portfolio, retail and mortgage portfolio, charge offs, large dollar exposure, etc.
Operational dashboards – delinquencies and maturities
Alert dashboards – accruals, loan structure alerts, AQR alerts, etc.
The strategic data management program we developed has been critical to improving operations and the bottom line for this client. It generates more meaningful, accessible, and secure data. By implementing more effective reporting and more insightful data, the bank has revitalized its data management program, while leveraging existing architecture and resources. Fewer hours are spent on static reports and fewer conclusions are drawn from inefficient data.
Based on conservative assumptions, the potential favorable financial impact of this project is estimated at nearly $1.8 million annually, resulting in an ROI of over 1,000% over three years. In addition, the bank now proactively addresses credit issues and aligns with regulatory and compliance requirements.