Oracle Banking Data Template Catalin BOGDAN Oracle Romania

Oracle Banking Data Template Catalin BOGDAN Oracle Romania – Senior Presales Manager Oracle Proprietary and Confidential 1

Overview Ÿ Bringing together data in one place is good Ÿ Use a predefined industry template Ÿ Of course, not all banks are the same Ÿ Oracle BDT is wide ranging Oracle Proprietary and Confidential 2

What is the Template? ŸNOT a PRODUCT, IT’s a SOLUTION ŸCollection of unified banking terms/data organized into groups and containing relations among them, describing banking activities/operation. ŸTEMPLATE for Logical Data Model as part of DW projects. Oracle Proprietary and Confidential 3

Business & Conceptual Model Party Event Legal Contract Account Product Transaction Channel Oracle Proprietary and Confidential 4

Why is it good? Ÿ Customer analytics – ranging from customer value analysis through to the application of data mining for customer segmentation, cross-selling opportunities, fraud detection etc. Ÿ Economic and regulatory capital allocation to support the calculation of Risk Adjusted Performance Measurement – RAPM (RORAC, RAROC or RARROC) Ÿ Support Basel II, AML, IAS, compliance with SOX or other Performance Management requirements & measures. Ÿ Seek to get a common definition of terms across a business. Oracle Proprietary and Confidential 5

Oracle Proprietary and Confidential 6

Objectives and roles Ÿ Save time and money by building on years of experience Ÿ Defines data attributes required for management information across the bank Ÿ Introduces data constancy across the organisation Ÿ Extendibility, providing a platform to model the bank’s unique requirements Ÿ Design basis for analysis Ÿ Enables a business conversation, link IT and business Oracle Proprietary and Confidential 7

Customer Analysis Ÿ Segmentation Ÿ Customer value analysis Ÿ Retail banking analysis Ÿ Corporate banking analysis Ÿ CRM Oracle Proprietary and Confidential 8

Risk Analysis Ÿ Credit Risk Ÿ Credit Analysis Ÿ Operational Risk Ÿ Scoring, rating Oracle Proprietary and Confidential 9

Performance Measurement Ÿ Customer/Product profitability Ÿ Teller performance Ÿ Cost allocation Ÿ Transfer Pricing Oracle Proprietary and Confidential 10

Channel Utilization Ÿ Sales report Ÿ Campaing Ÿ Channel utilization Oracle Proprietary and Confidential 11

Experiences – Business side Ÿ Visual understanding of the planned DW Ÿ Accelerate business requirement survey Ÿ Common definitions used across the bank Ÿ Guideline for mapping Business processes & products Ÿ Report requirements could be easily validated Ÿ Suggestions for Basel II (especially for PD, LGD modeling) Oracle Proprietary and Confidential 12

Experiences – IT side Ÿ Early discussions on what data are available and from which source system Ÿ Accelerate logical data modelling, DW design Ÿ High level data mapping between DW and source system was supported Oracle Proprietary and Confidential 13

BDT references, projects Ÿ Data Warehouse project using BDT – – – OTP Bank, HU – Marketing, Basel II K&H Bank, HU (KBC sub – Customer Analysis, Performance measurement DSK Bank, BG – Basel II, Controlling, Risk Analysis, Customer Analysis Oracle Proprietary and Confidential 14