Banking Intelligence | Financial Services Intelligence


Client
Client is one of the leading private banks in India with a nationwide network of 684 branches and 1605 ATM's in 316 Indian towns and cities.

Objective

• Build Data warehouse: Integration of the disparate data sources in retail assets and retail liabilities
• Consolidation of all the business rules in both retail assets and liabilities
• Build data marts for retail assets and liabilities
• Build reports: Generate 170 interactive reports with drill down capability, both in retail assets and liabilities
• Provide role-based access to reports
• Sizing and capacity planning
• User training
• Documentation

Benefits

• Automation: Automatic extraction from different sources and scheduling of jobs based on events defined by business. This will reduce the manual dependency and improve the processing time by 90% (approx)
• Operational Efficiency: User-friendly reporting using the financial automation solution improves the operational efficiency. Business will have flexibility in monitoring their by business performance by click and drag functions.
• Improved Visibility: Enablement of cross-functional view and visibility into performance of various entities of the business functions.
• User Empowerment: User-friendly semantic layer allows business users to generate ad-hoc reports. This will reduce the dependency on others for data
• Data Standardization: Consolidation of naming conventions enabling common understanding, visibility and collaborative analysis
• Scalability: The scalability of the solution will accommodate vertical and horizontal growth

Pain Areas

• Dependency: Interdependency across teams for report generation
• Time Consuming: Manual report generation and multiple-passes
• Lack of Flexibility: Drilling down and aggregated views of data requires effort
• Work Overload: MIS Operations Team is overloaded the first 2 weeks of the month
• Data Reliability: Data manipulation is being done outside the reporting system
• Maintenance Overheads: Data extraction processes are developer and technology dependant
• Ad-hoc Reporting: Increased turn-around time for developing ad-hoc reports
• End-user reports: Users need to be familiar with technology to generate reports

Solution

• Client chose InfoSTEP as consultants for recommending solution as well as implementing it. Client procured Business Objects product suite for solution implementation
• InfoSTEP conducted a four-week business requirements gathering and analysis, as part of which the consultants conducted workshops and met financial analysts (MIS) and operations team in order to understand the business objectives, ASIS processes, business needs, business rules and challenges.
• InfoSTEP proposed to build a Data Mart for client’s retail assets and liabilities business areas over the existing diverse source systems.
• InfoSTEP will integrate the data from different sources by standardizing the ETL jobs
• The solution will include data model design and semantic layer for the business users
• InfoSTEP will then build standard report templates for all the subject areas
• InfoSTEP proposes to do post-production support for the client