Banking Intelligence | Financial Services Intelligence


Client
A global financial services leader, delivering value and innovation to 4.3 million customers worldwide, in brokerage, banking and lending service areas.


Objective

• Create a consolidated platform for facilitating enterprise reporting and analytics across retail and institutional lines of business.
• Provide business with web-based access to dashboards and reports.
• Build a user-driven infrastructure for query, output and analysis.
• Allow business & financial analysts the ability to perform value-added analytics as opposed to ad-hoc queries and ongoing reports.

Benefits

• Drill Down capability: Users attained ability to drill into reports for further analysis
• Operational Efficiency: Analysts obtained real-time, user-driven and directed query and output capability.
• Improved Flexibility: Users achieved ability to create charts and graphs in Business Objects or export to excel.
• User Empowerment: Users gained ability to perform their own drill-down analysis in real-time by selecting new variables, setting filters, and changing dimensions.

Challenges

• Data Dependency: Data structure and available tools forced the business to rely on a limited number of resources to obtain data, reports and analysis from the customer information warehouse. This resulted in an extensive work queue and it was generally agreed that the previous process was not meeting the needs of the business.
• Disparate data sources: Inconsistent data sources (external data, MS-Excel spreadsheets, flat files)
• Inconsistency: Inconsistent data definitions
• Restricted ability to arrive at the appropriate level of granularity across various dimensions
• Process Non-uniformity: Lack of uniform reporting processes and procedures
• Inadequate documentation: Lack of proper documentation

Solution

• Client chose InfoSTEP as consultants services partner for defining the needs, recommending solution as well as implementing it.
• InfoSTEP played a key role by identifying 350 key metrics and by creating complete and clear definitions, housed in a corporate data dictionary
• Implemented Business Objects XI-R2 reporting platform on DB2 databases
• Migrated from a system driven data model to a business driven data model
• Reports were scheduled and delivered via each users portal and/or email
• Identified consistent data sources