DWBI – What drives it

2. DWBI – What drives it According to Gartner, Inc., the average enterprise has 14 different databases and spends 60 to 70 percent of its application development creating ways to access that data. Financial services companies have more, and their demands are greater. They also require the ability to combine real-time data with information they should already know to make real-time decisions. According to Gartner, the “big four” now own two-thirds of the BI market. Gartner Research Director Kurt Schlegel writes that, “The consolidation in the market has not simplified vendor selection decisions; if anything, it has made them more complicated because the acquisitions have thrown many existing product road maps into confusion. These acquisitions have also caused the mega-vendors to focus on product integration versus BI innovation - as they watch the TCO and time-to-value of their BI solutions go down the drain.

3. How Enterprises think of DW BI

4. The Information predicament in a Bank • Banking Data Sources INTELLIGENCE for a profitable future FUTURE What NEXT? Actionable KNOWLEDGE What strategies can I apply? PRESENT Why did it happen? INFORMATION processing BUSINESS VALUE • Identify the correct sales channels for different customer segments. • Identify the right target marketing strategy • Identify the correct collection strategy. • Integrated channels targeting unified messages to customers powered by a single view of the customer • Effective cross-sell and up-sell leading to increased profitability • Predict and proactively manage churn, delinquency, fraud. What data do I have? How can it help me see what happened? • Am I efficiently utilizing the right sales channels? • Is my marketing spend aligned to bring on profitable customers? • Is the collections dollars appropriately channelized to minimize delinquency? The Banking DATA deluge PAST • What is the effectiveness of different sales channels in my bank? • Who are the most profitable customers in my bank? • Are my delinquencies under control? DATA – INFORMATION – KNOWLEDGE – INTELLIGENCE

5. The Traditional Approach

6. The Traditional Approach Delivery Focus Value Validation

7. The “Solution” Approach

8. Benefits Delivery Focus Value Validation

9. Case Study: BI Implementation in a Mid sized Bank

10. Sample Reports • Card Product Sales • Sales Balanced Scorecard • Loan Delinquency Monitor • Marketing effeciency The iCreate Solution Approach • TCO Crunched • Small yet powerful delivery cycle • Managed service option • Other factors • Core skills are around core systems, BI technology and understanding of Banking • Ongoing solution quality improvement • Cycle Time Crunched • Focused solution eliminates “noise” • Limited Dimensions and Measures • ETL Operational cycle simplified Requirement Analysis Build DM+ETL+ Reporting Solution Delivered Testing Validation 7 WEEKS

11. Handling the Downsides • Core System Knowledge • Functional Solutions • Reusable dimensions • Master data management techniques The Solution Centric Approach • Tailor made solutions • Organization Policies

12. Summary • Gartner Inc. says: “As BIS firms get a grip on the more mundane problems of aggregating and reporting, they need to both extract more value from the BI tools they own (and there are often many of them) and prepare for a BIS world that is more volatile, more uncertain and more competitive.”

13. Presenting Biz$core

14. ETL Tool License BI Tool License Systems Integration • Significant cycle time • Tools evaluation and selection • Vendor evaluation & selection, • Detailed Requirements phase, • Data model design from scratch, • Data integration strategy developed • Development • Testing • Significant cost drivers • License cost of tools • Service fees of System integrator • Other factors • Multi-party collaboration challenges • Maintenance Issues • Ongoing solution quality improvement • Lack of domain knowledge Requirements gathering Acceptance testing Report, Dashboard, KPI devlpt Design and data modeling Data Acquisition Integration testing A TYPICAL BI PROJECT TAKES UPTO 20 MONTHS 20 MONTHS

15. Adapters with CBS Banking Data Models • TCO Crunched • Open source based product • Managed service option • Other factors • Focus as a business is BI for Banking • Core skills are around core systems, BI technology and understanding of Banking • Ongoing solution quality improvement • Cycle Time Crunched • Pre-defined front-end • Reports, Dashboards, Scorecards • Evolved Domain model • ODS, Data warehouse, Data marts • Productized Data Integration • Adapters for standard core systems DEEDWorkshop Acceptance testing Model / Adapter Customization PoC Delivered Integration testing 20 WEEKS A DEPLOYMENT TAKES ONLY20 WEEKS !

17. Biz$core Suite Customer / Channel Intelligence Central Bank Reports Charts Dashboards OLAP Engine L3 Data Marts Reporting Engine Roles L2 Operational Data Store L1 Staging Area Operational / Analytical Reports Risk / Fraud Parameters Metadata Role / User Management Data Governance Performance Management

18. THANK You. Questions?Email: Naren.ns@icreate.in

19. About Us Focus & Expertise Customers we work with • Business Intelligence, Reporting, Analytics and Enterprise performance management for the BFSI segment • Wide-ranging transactional systems knowledge for BFSI (Core banking etc.) “iCreate’s commitment to delivering to set project schedules irrespective of the obstacles is amazing and a contrast to other vendors” - Michael Kokkinos, NBG (Cyprus) “NBK looks at iCreate as a service provider partner in its journey for Change” - Hani Khalil, NBK Products and Tools The Right Partner • Healthy financials strengthened by funding from a leading US based VC firm • Presence in Africa, APAC, Middle East & Europe • World Headquarters in Bangalore, India • 100+ Banking technology professionals • Integrated Reporting, BI, Analytics & EPM product. • BFSI Industry Data Models, CBS adapters