Graphic Section Divider

2. Graphic Section Divider

3. Aligning Risk & Treasury Operations for Compliance through IT Transformation Divyesh PatelSenior Practice Director Subin Paul Master Principal Consultant

4. Program Agenda • Current Scenario : Risk, Finance & Treasury • The Case for Unified Platform • Oracle Solution Landscape • Reality Check • Focus Areas for Successful Implementation • Questions and Answers

5. Safe Harbor Statement The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

6. Typical Current State of Data Processing Case: Risk, Finance and Treasury Reporting X Multiple version of Truth X Lack of Golden Ref Data X Proliferation of Data Extracts X Intensive Manual Intervention X Fragmented Processes & Reports X High Cost of Infrastructure X Heavy Reconciliation Effort X Too many Tool and Technologies Inaccurate Costly Delayed

7. Ever Increasing Demand on Operations Shareholders, Management, Regulator Evolving Regulations Demanding Shareholders Harsher Financial Climate • Risk Aware Financial Numbers • Proactive Balancing of Performance & Risk • Upto Date Finance Data to Respond to Crisis • Transparency, Accuracy, Traceability and Flexibility • INTEGRATED INFORMATION

8. Contrast and CompareRisk, Finance, Treasury Objectives Focus Data

9. The Case for Unified Platform Positions & Transactions Reference Data Market Data Customer Data • Improve ROC and Optimize Returns • Promote Efficient, Accurate and Timely Reporting • Risk-Adjusted Financial data for Front-Office Decisions • Support risk-based price verification • Improved Decision-Making

10. Industry is Convinced Chartis-Research Survey: About 90% considered that an integrated approach to risk, finance, treasury & compliance was either critical or important in the present day environment • Improve Risk Management • Improve Business Performance • Improve Regulatory Compliance

11. RISK & FINANCE: Unified Platform Analysis & Reporting Common Staging /Foundation Financial Management & Planning SOURCE SYSTEMS Data Cleansing, Mastering, Routing & Transformations General Ledger Accounting Hub GL Consolidation GL Balances Customer Detailed Balances Products Profitability Analytics Financial Close & Disclosure Core Banking Accounting Flow Account Daily Average Balances Accounting Rules Investment Ledger Planning / CAPEX Trading Transactions Thick GL Bal Thin GL Bal Cards Forecast OLAP Analysis & Adhoc Reporting Enterprise Dimensions Loans Custom Tables Analytical Applications (Engines) Finance & HRMS Common Processing Common Results Oracle GL Data Quality Enterprise Performance Finance, Treasury & Risk Flow AP/ AR PFT FTP ALM Alerts & Exception Based Management Data Validation HRMS Financial Reporting RAPM Enterprise Risk Financial Recon Op Risk ICAAP Credit Risk Custom Dashboards/ Reports Other Systems Basel II LRM Econ. Capital Manual Feeds Adjustments Central Bank Reporting

12. Technology Oracle Solution Overlay Application Analysis & Reporting Common Staging /Foundation SOURCE SYSTEMS Data Cleansing, Mastering, Routing & Transformations Financial Management & Planning General Ledger Accounting Hub GL Consolidation Customer GL Balances Detailed Balances Products Profitability Analytics Financial Close & Disclosure Core Banking Account Daily Average Balances Accounting Rules Investment Ledger Planning / CAPEX Thick GL Bal Thin GL Bal Trading Transactions OLAP Analysis & Adhoc Reporting Cards HYPERION ESSBASE WEBCENTER PORTAL BPM BUSINESS INTELLIGENCE FINANCIAL SERVICES DATA FOUNDATION Enterprise Dimensions Loans Custom Tables Analytical Applications (Engines) E BUSINESS SUITE FINANCIAL ACCOUNTING HUB FINANCIAL SERVICES ANALYTICS APPLICATIONS HYPERION PLANNING HYPERION FINANCIAL MANAGEMENT Finance & HRMS Common Processing Common Results Oracle GL Data Quality Enterprise Performance Alerts & Exception Based Management AP/ AR E Business Suite GENERAL LEDGER GOLDEN GATE PFT FTP ALM Data Validation HRMS Financial Reporting RAPM Enterprise Risk DATA RELATIONSHIP MANAGEMENT Financial Recon Op Risk ICAAP Credit Risk Custom Dashboards/ Reports Other Systems Basel II LRM Econ. Capital Manual Feeds Adjustments Central Bank Reporting

13. Oracle Solution: Typical Data Flow Portal Financial Planning THICK GL Events, Transactions Positions Real Time DI HYPERION FINANCIAL MANAGEMENT Source Data Adjustments Workflow GOLDEN GATE Balances THIN GL Financial Consolidation Data Feeds WEBCENTER PORTAL BPM BUSINESS INTELLIGENCE FINANCIAL SERVICES DATA FOUNDATION Reporting “ELT” E BUSINESS SUITE FINANCIAL ACCOUNTING HUB FINANCIAL SERVICES ANALYTICS APPLICATIONS HYPERION PLANNING Source Data Ref. Data Analytics & Results Analytical Results Positions Master / Ref Data E Business Suite GENERAL LEDGER OLAP Cubes Ref. Data DATA RELATIONSHIP MANAGEMENT HYPERION ESSBASE

14. Oracle Solution: Unified Data Model • OracleFS Data Foundation • Fully supports all key analytical use cases for Financial Services in Risk, Compliance, Customer Insight and Performance Management. • Immediately deploy new and advanced analytics • Provide the fastest possible query performance across all business domains • Easily meet emerging or changing cross-functional business and regulatory mandates • Reduce the complexity and cost of maintaining multiple data marts • Enables consistency, transparency and auditability across all analytical domains

15. Collaborative Reporting – Modernizing the process of Financial Reporting Collaborative Reporting Factory - Process Business Challenge

16. Collaborative Reporting Architecture (Logical View) WEBCENTER PORTAL BPM BUSINESS INTELLIGENCE BUSINESS INTELLIGENCE HYPERION ESSBASE

17. Reality Check – Challenges.. As always

18. FOCUS Areas for Successful Implementation Senior Management Sponsorship Multi-phase, Iterative Implementation Approach

19. Implementation Best Practices • Data Integration • Use Ready Adaptors for Sourcing from Variety of Databases • Choose and Validate, Need for Real Time Data Integration • Use CDC concept for Real Time Data Integration • Evaluate need for Transaction Level data from all sources • Evaluate a ‘Pre-Staging’ data repository for efficient • Scheduler Driven ETL Process • Harness the Power of Database Server by adopting ‘ELT’

20. Implementation Best Practices • Data Quality • Plan for a DQ Due-Diligence exercise • Adopt Rule Based DQ Processing • Classify DQ into ‘Business Impact Severities’ • Process ALL Technical DQs as near to Source as possible • DO NOT manipulate data during Data Sourcing and Loading • Pre-define Default Values for Mandatory Attributes • Periodically Re-assess DQ Thresholds

21. Implementation Best Practices • Master Data • Evaluate Master Data – Current Status • Identify Golden Sources of Key Master Data Entities • Introduce Master Data Program to create Golden Source of Key Masters (Customer, Product, Organization etc) • Proactively Identify Asymmetrical Hierarchies • Use Oracle DRM for Servicing Reference Data & related Hierarchy

22. Implementation Best Practices • Data Authoring Eliminate need of Transferring Data to XLS Provide Collaborative Workflow Environment for Report Generation and Approval Resort to Portal Concept where Reports need to be Distributed through an Interactive Channel Provide for Custom Report Development by end Users Implement Data Level and Report Level Security & Control

23. Implementation Best Practices Data Governance • Establishing DG Council and various levels of Data Stewardship • Establishing Principles, Policies, Standards for all data management functions • Establishing various Data Quality dimensions and KPIs • Establish in monitor, control and feedback mechanism for efficient DG • Establish Collaborative-Communication Environment

24. Implementation Best Practices Harmony Method of Implementation Startup Information Study Harmonization Pre-fulfillment & Testing Cutover to Live • Understand requirements and scope, finalize project plans considering customer and oracle staffing • Conduct requirement gathering sessions, review current topology and layouts and prepare drafts • Configure Oracle modules, establish system and application tables and meta data, test all modules Perform transition activities to promote to production, finalize data interface specs, finalize hand over documents • Assist with production migration, process controls, business operations

25. Aligning Risk, Finance and Treasury Summary of Oracle Value • Financial Accounting • Financial Management • Enterprise Risk Management • Enterprise Performance Management Complete Set of Applications • Data Integration – Batch and Real Time • Data Quality Management • Reference and Master Data Management • Reporting Portal with Collaborative Authoring Complete Set of Technology • Define Information Architecture and Technology Architecture • Establish Data Governance Policies and Framework • End to End Data Integration, including 3rd Party Engines • Implement Reporting Portal End to End Consulting