480 likes | 727 Views
End-to-End Solution for MIS/BI & Automated Data Flow to RBI. BI for Banks. MIS, BI & Similar Projects done by the same team. Project Objectives. How BI for Banks ADF meets Bank’s Objectives. 1. 1.
E N D
End-to-End Solution for MIS/BI & Automated Data Flow to RBI BI for Banks
How BI for Banks ADF meets Bank’s Objectives 1 1 • This solution is structured in four layers as outlined in the RBI framework to meet all the activities and tasks prescribed for implementing ADF system. It has ready data models key Features being the extensible Data Model, System for Governance, External Data Capturefunctionality OBJECTIVES Creating CDR 2 2 • The solution has data validating algorithms built in ETL and gives reports related to quality of data. • The solution can be easily integrated with data quality tools and provides for strong data governance. Data quality 3 3 Data integration from various source systems deployed in the bank. • It has ETL routines and mapping from source systems like Finacle, Treasury, Central Accounts department, etc. • Data management platform consists of rich set of transformation for a variety of task, Integration Analytics and Data Quality Transformation 4 4 • We have created 400+ reports in a public sector bank. Hence the data mapping to the reports are already available. • The reporting interface component of the proposed solution allows to create reports and dashboard with drag and drop facility with a strong metadata management component. Reporting, dashboards and conversion to XBRL format.
Data Quality Profiling Quality
Reporting and Alerting Increase Proactive Intelligence Empower users Increase efficiency • End User Alerting • Defined from within operational or ad-hoc reports • Intuitive Alert rules • Self-managed Alerts • XLS/Word 2007/2010 • Power View • Highly visual design experience • Rich metadata-driven interactivity • Presentation-ready at all times • Enabled as Shared Service • Built-in scale-out for RS Service Apps • Cross-farm reporting • Integrated backup & recovery, ULS logging, PowerShell etc. • Managed Self Service BI – Corporate BI
Proactive Intelligence SITUATION TODAY Need for the ability to proactively respond to exceptional data changes or trends. Data volumes are always increasing leading to data overload. Each Information Worker needs to monitor data specific to their job. Self Services Alerting capability makes it trivial for any end user while viewing a report to define rules and thresholds on data and be alerted when they are reached. This transforms a traditional pull mode activity to a push mode activity greatly increasing Information Workers productivity.
Solution Overview:MIS/BI & Automated Data Flow Infrastructure Deployment
Brief on Security Architecture • The application has a three tier architecture. (Web/App/DB) • Each of the layer Web/App/DB has been divided into zones separated by firewall. • The web layer is in DMZ which will be first layer for all users access. • The App/DB has been put into the MZ separately. • The application level security is through user access levels which is configurable as per the banks ISSP. • Security features of application: • Automatic logout of idle user after specified time. • Minimum password length of 8 characters available. • User lock after predefined unsuccessful login attempts. • Force password change after predefined periods. • System does not accept user id as password. • Password is not same as old password.
Case Study: Himachal State Cooperative Bank • Some of the Reports available • Weekly Flash Data Report • BSR Statements. • Industry wise advances. • Sector wise advances. • Facility wise advances. • Position of Priority Sector Advances and Disbursement. • 100+ reports are deployed which cover reports of different departments like Credit, Risk Management, Priority Sector Lending, Statistics, Retail Banking and International Banking Division etc. • Dashboards are made available • Statutory and regulatory reports as per RBI format are generated.
Case Study: ADF Solution • 203 ADF Reports Available for Reporting to RBI on defined frequency • Predefined templates available for data extraction. • Advances & Reminder Mail Alerts for Data upload, Report Due Data, Report Approval, Report Submission. • XBRL Report Generation Integrated available for RBI Reports. • User Management available to define access rights to user as designation and department integrated with bank employee data. • Report Scheduling and Auto Loading provided for report generation as on due date or on receipt of data. • Dashboards are made available
Sample – Dashboards CASA DASHBOARD
Solution Overview:MIS/BI & Automated Data Flow Proposed Implementation and Methodology
Proposition to Customer Commitment to Bank for project Success Proven Relationships & Techniques Accelerated Roll-out Thoughtful Solution Design Robust Governance • Requirement validation as applicable • Minimum Customization • Parallel builds synchronizing in to single Testing phase • Core Key team members from domain and technology are ready to be deployed • Governance Layer can be leveraged • Focus on current application needs • Alignment to Enterprise standards of SBI as applicable\required. • Design and development follow standard SDLC processes . • Bank/ NSCS key stakeholder participation in project governance • Proven BI Governance mechanism at all levels – Country, Region, Group • Delivery excellence across multiple projects over many years • Strong relationship with SAS as a partner • Real-time synchronization between Onsite-Offsite teams Successful Solution Implementation
Key Success factors Mature process framework based on CMMi 5 and ITIL…
Thank You! Q & A