With support from WIT, our client deployed multiple Alteryx workflows to cleanse and shape data for Current Expected Credit Losses (CECL) reporting - saving them hundreds of hours annually.
Regulatory Compliance Reporting
This large regional bank offers exceptional full-service banking and lending expertise with a distinctive, personal focus. Chartered as a federal savings bank, today the bank has assets of over $25 billion, is among the top 10 largest bank mortgage originators nationally, and among the top five largest savings banks in the country.
As one of many regulatory requirements mandated by the Securities and Exchange Commission, the Current Expected Credit Losses (CECL) accounting standard was implemented to improve credit loss forecasting and reporting across the banking industry. This new standard went live in early 2020.
Credit loss forecasting was not a new phenomenon at the bank. The bank was already leveraging a third-party credit impairment service to help predict credit risk across its loan portfolio. However, with the new specifications defined by CECL, the bank needed to redefine how loan data was collected and transformed for reporting in a CECL context. In addition, some of the bank’s portfolio did not match the required input format of the legacy credit impairment service, and those predictions had to be developed outside of the standard process. Key opportunities to address in this project include:
- Provide an automated process for CECL reporting
- Harmonize data from multiple sources
- Apply business rules and data cleansing procedures, preparing the data for input into a third-party credit impairment prediction service
- Apply custom data science models to predict risk for non-standard loans in the overall credit portfolio
- Provide world class analytics at an enterprise level
The regional bank initially contemplated building the new CECL process around a largely manual, spreadsheet and pivot table-based methodology. However, having already experienced the value of Alteryx for other internal solutions, the decision was made to leverage Alteryx to automate the CECL process. Key elements of the process include:
- Merge and cleanse loan data from multiple sources, applying CECL-related business rules where required
- Import the consolidated loan data into a third-party credit impairment service, which assigns predictive risk profiles for each standardized loan
- Design and build predictive data science models for non-standard loans that did not quite meet the input requirements of the credit impairment service
- Merge the standard and non-standard loan risk values to automate the delivery of the Loan Value % Risk Set Aside Report, required by the CECL accounting standard, and make the data available for ad hoc analytics
As the new CECL accounting standard was researched by the bank, Alteryx was quickly determined to be the ‘best tool for the job’ and provided significant value. Key outcomes include:
- Automation of what would have otherwise been a highly manual effort, saving hundreds of hours annually
- Deployment of quality control checks into the process
- Deployment of an audit-friendly process using Alteryx’s self-documenting capability
- The bank is required to run this process quarterly, but thanks to the Alteryx solution, the process can be initiated monthly or multiple times per month to stay on top of any trends or abnormalities that may occur