Data Warehouse and Business Intelligence Platform for a leading Public Sector Bank in India

Objective was to implement a robust and highly scalable end to end Data Strategy with Data Management, Data Warehouse , Analytics and BI Platform. The bank overall envisaged DWBI Project to improve its operational efficiency, profitability, customer centricity and risk management.

Business Challenges
• Implement Single Version of Truth
• Formulate analytical problems and hypothesis based on business and process
• Address Data quality aspects of data- Completeness, Consistency, Timeliness and Accuracy
• Optimize TCO for data management & analytics and enable Bank to streamline data driven decisions

Solution Proposed
• SAS Data Management
• Data Quality
• Oracle DWH
• SAS VIYA Server
• Advanced Analytics
• SAS Visual Analytics
• SAS VDMML

Solution Implemented
• Integration with Bank’s Internal source systems and External data APIs
• Implemented Data Warehouse and AI-ML Platform to implement
• Creating Top Executive and operational dashboard using analytics
• Automated and improved accuracy of 50+ MIS reports
• Implemented 5 ML Use Cases

Customer Benefits
• EDW makes it easier to access, manage, and analyze data efficiently
• Help bank to better understand its customers and target its marketing and sales efforts
• Use to assess the creditworthiness of borrowers and identify potential risks
• KPIs- financial performance, customer satisfaction, and risk exposure