1 / 27

Graphic Section Divider

Graphic Section Divider. Aligning Risk & Treasury Operations for Compliance through IT Transformation. Divyesh Patel Senior Practice Director Subin Paul Master Principal Consultant. Program Agenda. Current Scenario : Risk, Finance & Treasury The Case for Unified Platform

holleb
Download Presentation

Graphic Section Divider

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Graphic Section Divider

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

  3. 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

  4. 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.

  5. 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

  6. 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

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

  8. 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

  9. 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

  10. 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

  11. 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

  12. 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

  13. 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

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

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

  16. Reality Check – Challenges.. As always

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

  18. 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’

  19. 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

  20. 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

  21. 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

  22. 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

  23. 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

  24. 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

More Related