slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Graphic Section Divider PowerPoint Presentation
Download Presentation
Graphic Section Divider

Loading in 2 Seconds...

play fullscreen
1 / 27

Graphic Section Divider - PowerPoint PPT Presentation


  • 104 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Graphic Section Divider' - holleb


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
aligning risk treasury operations for compliance through it transformation
Aligning Risk & Treasury Operations for Compliance through IT Transformation

Divyesh PatelSenior Practice Director

Subin Paul

Master Principal Consultant

program agenda
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
safe harbor statement
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.

typical current state of data processing
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

ever increasing demand on operations
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
the case for unified platform
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
industry is convinced
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
risk finance unified platform
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

oracle solution overlay

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

oracle solution typical data flow
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

oracle solution unified data model
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
collaborative reporting modernizing the process of financial reporting
Collaborative Reporting – Modernizing the process of Financial Reporting

Collaborative Reporting Factory - Process

Business Challenge

collaborative reporting architecture logical view
Collaborative Reporting Architecture (Logical View)

WEBCENTER PORTAL

BPM

BUSINESS INTELLIGENCE

BUSINESS INTELLIGENCE

HYPERION ESSBASE

focus areas for successful implementation
FOCUS Areas for Successful Implementation

Senior Management Sponsorship

Multi-phase, Iterative Implementation Approach

implementation best practices
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’
implementation best practices1
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
implementation best practices2
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
implementation best practices3
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

implementation best practices4
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
implementation best practices5
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
aligning risk finance and treasury
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