Mel Case Study

  • Uploaded by: Carl Terrantroy
  • 0
  • 0
  • October 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Mel Case Study as PDF for free.

More details

  • Words: 603
  • Pages: 26
EPM Case Study

Goldman Sachs JBWere Mark Nottle Finance Systems Controller Goldman Sachs JBWere

Goldman Sachs JBWere

• Australasian pre-eminent financial services organisation • Providing quality investment, advisory, wealth management and execution services to a broad range of private, corporate and institutional clients. • 1,500 employees • Part of the Goldman Sachs Group

Budgeting – the old way • Process was predominantly spreadsheet based • Supporting schedules via excel, word email • Budget data loaded into Oracle eBusiness Suite (General Ledger) • Reporting via Oracle GL

The journey Evaluating Budgeting Solutions • Evaluating systems in 2005 • Commenced project Feb 2006 Implemented Hyperion System 9 • Several months of data analysis and detailed business requirements • Initial build on Hyperion System 9 • Cost allocations tool

Deployment FY07 First Budget Cycle • Go Live: August 2006 • 100 users

•9 drafts (only 2 drafts in FY06) • Supported by James & Monroe • Internal Training by GSJBW

Why Hyperion Planning? • User Interface – User friendly interface – Input forms and task lists set up and owned by GSJBW

• Hyperion provide “train the trainer” • Single sign-on with Microsoft Active Directory • Real-time reporting of the budget model for end-users and reviewers (Hyperion Workspace) • Essbase • Forecasting – changes in market conditions • Minimal IT support (server infrastructure only)

Why Hyperion Planning? For the Budget process • Multiple drafts (including allocation runs) • Able to use comparative data (prior year actuals, calculated forecast columns) • Budget stays open during review cycles • Security access by Business Unit, Geographical Location and Account • Supporting detail worksheets held within the system • Workflow notifications for approvals

Why Hyperion Planning? Calculation and Modelling Features • Modelling key drivers: – Head count – Phasing based on Trading days, Business Days

• Built-in calculations – PRT, FBT, Depreciation on CapEx, Travel

Oracle Financials • Planning remains the formal budget system of record • “Member hierarchies” (account definitions, business unit structure, etc) based on Oracle Financials structures – Scheduled ETL process custom-built by James & Monroe

• ASO database for enhanced reporting and analytics of Oracle Financials data

Project Success • Business and Management Buy-in • Dedicated project team • Bed down business requirements in planning phase • Project to determine Go Live not vice versa • Consultants: rely on Hyperion knowledge • Scope Creep

EPM Case Study

Goldman Sachs JBWere Ben White Principal Consultant James & Monroe

About us

• Specialist Oracle EPM consulting partner • Commercial background • Consultants with 10+ years’ experience with the core components of Oracle EPM

Our engagement • Methodology • Phased implementation • Focus on Knowledge Transfer

The implementation Oracle EPM: Hyperion Planning • Extending Oracle eApplication Suite (Oracle Financials General Ledger) • Detailed budget by Account, Cost Centre, and Project Code • 100 budget users • Modelling: – Foreign Exchange – Centrally-budgeted items

• Managed Workflow

Extending Planning: Allocations • Allocating back-office costs to front office • Previously... – Took 2 to 3 days to complete – Extremely error-prone

• Allocation module developed by J&M – Automatic validation – Under 1 hour to complete

• Based on Oracle’s Hyperion Planning • Developed as an Oracle Fusion application • Fully integrated with Planning

EPM Approach

Integrated Management Process

Start Anywhere Approach

Business Intelligence Oracle EPM: Hyperion Essbase • Full-detail Reporting & Analysis of Oracle Financials General Ledger data – Standard monthly report packs – Speed-of-thought analysis in Excel

• Corporate Card Expense Analysis

The future • New Business Intelligence applications • Statutory Consolidations and Financial Reporting • Balance Sheet Substantiation

EPM Case Study

Goldman Sachs JBWere James & Monroe

Q&A

Related Documents

Mel Case Study
October 2019 16
Mel
December 2019 27
Mel
June 2020 21
Case Study
April 2020 41
Case Study
May 2020 38
Case Study
June 2020 28

More Documents from ""

Brisbane Case Study
October 2019 15
Sydney Case Study
October 2019 15
Perth Case Study
October 2019 20
Malcolm Acca
October 2019 21
Mel Case Study
October 2019 16