Automation of DFAST Processes Saves Days of Manual Work

技术

分析与建模 - 预测分析
应用基础设施与中间件 - 数据交换与集成
功能应用 - 企业资源规划系统 (ERP)

适用行业

金融与保险

适用功能

商业运营
质量保证

用例

过程控制与优化
监管合规监控

服务

软件设计与工程服务
系统集成

挑战

A large bank was collecting and managing DFAST-related data from multiple sources using uncontrolled Excel spreadsheets before manually aggregating all received data. The collection of uncontrolled spreadsheets through email proved extremely challenging. It was virtually impossible to confirm the accuracy of the data because any user could add, delete or alter spreadsheets. Files were stored in a bulky, multi-tab workbook that was at risk of becoming too large and complex to function. Otherwise, files were stored in locked-down shared drives. The bank needed a solution to streamline the collection and analysis of DFAST data, ensure data accuracy, and comply with regulatory requirements.

关于客户

The customer is a large bank that was facing significant challenges in managing DFAST-related data. The bank's data analysts were responsible for collecting information from regression models, other analysts, and various lines of business, and inputting everything into spreadsheets. This process was highly manual and time-consuming, involving several iterations to aggregate all necessary data. The data from any one line item could come from up to four regression models, requiring the team to break down a single line into four pieces before aggregating the data. The aggregated data then needed to go through multiple review stages, including line of business review, executive committee review, and bank board committee review. Qualitative adjustments were often made at the review stage, and the team had to manually paste data into a separate workbook to perform adjustments and compare historical data with macroeconomic factors. This cumbersome process took time away from the team's core roles and made it difficult to ensure data accuracy and compliance with Fed requirements.

解决方案

Vena optimized the data collection process by breaking up a single Excel file into smaller, more manageable files. Data from these files are automatically rolled into a central data repository. The repository stores multiple versions of templates, including Fed scenarios, bank scenarios, etc., in addition to multiple versions of each scenario and the results of what-if analyses. The graphical process designer can break processes into a series of repeatable steps that include instructions, due dates, and the ability for contributors to attach supporting documentation to their submission. Vena automatically notifies managers and contributors via email when a step has been completed and associated templates and notes are available for review. Vena’s audit trail records user activity (who did what, when), allowing the firm to instantly differentiate between qualitative adjustments and model-driven entries. Vena’s playground environment has business rules and other features that allow users to adjust assumptions and immediately visualize their effects on a projection scenario.

运营影响

The firm no longer has to contend with an unwieldy workbook but continues to benefit from Excel’s most useful features, including powerful calculations and modeling logic.
The central data repository stores both projection and historical data and makes it available for instant retrieval, allowing the firm to make version comparisons on the spot.
Data captured through projection templates are automatically consolidated in the central repository.

数量效益

The automation of DFAST processes saved days of manual work.
Instant forecast version comparison provides immediate insight into the bank’s financial status.
Contributors have enough time to make necessary adjustments due to the streamlined process.