BFSI - Leading Bank – EDW & MIS-ADF Implementation

Engagement Details

Primary Operations: India

Associated since: 2019

Service Type:
Development & implementation

Service Model:

Status: On-going

Methodology: Waterfall

Scope/Challenges/Key objectives

Business Case:

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 huge delays and increased validation efforts due to errors. Management wanted to build a CDR/DW with good-quality data and automate the report generation and submissions through one solution. The solution required the implementation of a Maker-Checker option to validate the Regulatory reports before submission. The solution required handling of both XBRL and non-XBRL reports automatically and be able to incorporate the changes that periodically appear in the XBRL formats.


  • Multiple system for MIS, RBI reports
  • Functional heads could not take decisions using existing MIS reports
  • Manual preparation of regulatory reports causing 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
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
  • Maker-Checker option for Regulatory reports enabled report verification before submission
  • Drill Down reports to Facts and Dimensions level
  • Web tool to build Ad-hoc reports through Drag-Drop


Technical Environment:

  • SAS Banking analytics, SAS VA, Java, Oracle, Java Fullstack


  • Hands free end to end Data flow ensuring data quality and consistency
  • Data Trust is improved and enabled confident Decision Making

Automated report update with maker-checker

Self-service BI

Readymade dashboards

Datawarehouse- dnified sources with future need addressed