Business Intelligence, Regulatory Reporting for Banking Sector
Engagement Details
Primary Operations: India
Associated since: 2019
Service Type:
Development & implementation
Service Model:
Managed service
Status: On-going
Methodology: Waterfall
Scope/Challenges/Key objectives
Business Case:
Regulatory and MIS reports are being generated using legacy systems and without a central repository for data. With the response timelines are too little for manual intervention and causing huge delays and increased validation efforts due to errors. Management wanted to build a CDR/DW with good quality data and automate the report generations and submissions through one solution. Solution should implement a maker-checker option to validate the regulatory reports before submission. Solution should handle both XBRL and non-XBRL reports automatically and support to incorporate the changes that periodically appear in the XBRL formats.
Challenges:
- Multiple system for MIS, RBI reports
- Existing MIS system can provide numbers to the functional head, it cannot bestow decision making powers.
- No single DB (CDR) for implementing advanced analytics solutions
- Automation for RBI reports
- No advanced analytics to get proper KPIs in time
Solution, Technical Environment, Benefits
Solution / Project Engagement:
- Building unified data sources for analytics
- DQ assessment, completeness and correctness validation with channel management
- Designing the RBI ADF, MIS and other reports/dashboards.
- Web portal to provide the history of report, punching the data, performing the validations and downloading the reports.
- Drilldown dashboards to analyze each event with customized triggers and alerts
- Role based access to the reports and dashboards
Technical Environment:
SAS Banking analytics, SAS VA, Java, Oracle, Java Fullstack
Benefits:
- Automated report update with maker-checker
- Self-service BI
- Readymade dashboards
- Data warehouse – unified sources with future needs addressed
Automated report update with maker-checker
Self-service BI
Readymade dashboards
Datawarehouse- dnified sources with future need addressed