Streamlining Regulatory and MIS Reporting with Automated Solutions
Case Studies
Challenges & Solutions
Technical Environment
Results
Executive Summary
Client
International Banking Client
Industry
Banking, Financial Services, & Insurance
Business Problem
This International banking client was experiencing delayed regulatory reporting response timelines creating too little time for manual intervention and causing increased validation efforts due to data quality issues. Regulatory and MIS reports were being generated using legacy systems and without a central repository for data. Management wanted to build a CDR/DW with good quality data and automate the report generation and submissions through one solution. Data validation was also required for regulatory reports before submission.
Outcome
- Regulatory reporting enabled with actionable and timely insights and triggers for management.
- Data trust is improved and enabled confident decision making by management team.
Challenges
- Multiple system for MIS, RBI reports.
- Functional heads could not take decisions using existing MIS reports.
- Manual preparation of regulatory reports caused huge delay in reporting.
- No single DB (CDR) for implementing advanced analytics solutions.
- Automation for RBI reports.
- No advanced analytics to get proper KPIs in time.
Solutions
OTSI implemented a maker-checker option to validate the regulatory reports before submission. The solution handled both XBRL and non-XBRL reports automatically and seamlessly supported regular updates that periodically appear in the XBRL formats.
- Built unified data sources for analytics.
- Performed DQ assessment, data completeness and correctness validation with channel management.
- Designed the RBI ADF, MIS and other reports/dashboards.
- Created a web portal to provide the history of reports, punching the data, data validations and reporting usage stats.
- Defined drill-down dashboards to analyze each event with customized triggers and alerts.
- Integrated role-based access to the reports and dashboards.
- Built maker-checker option for regulatory reports enabling report verification before submission.
- Drill down reports were designed to enable access to facts and dimensions level.
- A web tool was created for users to build ad-hoc reports through a drag-drop interface.
Technical Environment
- SAS banking analytics
- SAS VA
- Java
- Oracle
- Java Fullstack
Results
- Enabled hands-free reliable end to end data flow ensuring data quality and consistency.
- Consistent reporting results driven by centralized data structures and processes.
