Centralized EDW & Ad-Hoc Analytics for Regulatory Reporting
Case Studies
Challenges & Solutions
Technical Environment
Results
Executive Summary
Client
Leading Bank
Industry
Banking, Financial Services, & Insurance
Business Problem
Banking client’s regulatory and MIS reports were being generated using legacy systems and without a central repository for data. The response timelines were too short for manual intervention and caused long delays and increased validation efforts due to errors. Management wanted to build a CDR/DW with good-quality data, automate report generation and submissions through one solution. The solution required the implementation of a Maker-Checker option to validate the Regulatory reports before submission and handling of both XBRL and non-XBRL reports. The solution needed to automatically incorporate the changes that periodically appeared in XBRL formats.
Outcome
Organized central repository for data with process checks ensuring data validation and minimization of human error. Enabled rapid response reporting to meet short timelines and enabled ad-hoc drag-n-drop reporting for self-service.
Challenges
- Multiple system for MIS, RBI reports.
- Functional heads could not make decisions using existing MIS reports.
- Manual preparation of regulatory reports caused excessive delays in reporting.
- No single DB (CDR) for implementing advanced analytics solutions.
- Automation for RBI reports required.
- No advanced analytics to get proper KPIs in time.
Solutions
- Built unified data sources for analytics.
- Performed DQ assessment, completeness and correctness validation with channel management.
- Designed the RBI ADF, MIS and other reports/dashboards.
- Created web portal to provide the reporting history, perform validations, download reports, and provide for ad-hoc reports with drag-n-drop build capabilities.
- Designed drill-down dashboards to analyze each event with customized triggers and alerts.
- Instituted role-based access to reports and dashboards.
- Enabled Maker-Checker option for Regulatory report verification before submission.
- Defined drill-down reports to facts and dimensions level.
Technical Environment
- SAS Banking analytics, SAS VA, Java, Oracle, Java Fullstack
