1 / 15

Global Corporate Performance Management

Global Corporate Performance Management. Gernot Molin - Program Manager. Agenda. The Customer The Problem Key Objectives Key Drivers For Selection The Solution Core Benefits Questions. Customer - Key Facts. UK Shipping Company - a $0.5 billion turnover organisation

heaton
Download Presentation

Global Corporate Performance Management

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. Global Corporate Performance Management Gernot Molin - Program Manager

  2. Agenda • The Customer • The Problem • Key Objectives • Key Drivers For Selection • The Solution • Core Benefits • Questions

  3. Customer - Key Facts • UK Shipping Company - a $0.5 billion turnover organisation • Controls a fleet of over 90 oil tankers, product carriers and liquefied natural gas vessels • Industries: Oil & gas, transportation & logistics • Category: Global corporation • Software: MIS DecisionWare, Microsoft SQL Server and Microsoft SQL Server Analysis Services, Informatica Power Centre • Data sources: Various SAP® systems, Oracle Financials, CODA, Informix

  4. The Problem Previous management information and financial management system did not meet the needs of this shipping organisation going forward: • Manually Intensive • Relied heavily on individual’s knowledge • Not globally consistent • Not technologically scaleable to support aggressive growth strategy • No visibility of future performance trends

  5. Key Objectives • A reliable and consistent environment reflecting the source data it receives on a daily basis from back-end accounting and operational transactional systems • A globally consolidated system replacing the multiple manually intensive spreadsheet based tools that were being used • A system to provide the sound platform needed to support a global growth strategy also allowing for follow-on phases delivering an enhanced capability

  6. Key Drivers For Selection Customised solution A solution that meets the unique corporate requirements of this global shipping company Flexible technology An adaptable solution that could quickly and easily keep up with the changing pace and requirements of the business One-stop shop Vendor to provide all systems and services for the management information system and beyond Relatively inexpensive to deploy and easy to maintain Packaged applications to speed up deployment and low effort maintenance to minimise costs No walls, no limits Potential to scale to massive data volumes and thousands of users. Existing solution to be extended with packaged applications.

  7. Source Systems • ISMISInformix 7.2.3 (Standard Edition) ISMIS is a tailor-made shipping-invoice-system based on an Informix database programmed and maintained by Dolphin Computers • CODAMicrosoft SQL Server 2000 CODA is the accounting system for the UK • PISCESOracle Financials 10.7 on Oracle RDBMS Enterprise Edition v7.3.4.3. PISCES is the accounting system for Singapore • CITY HALLOracle Financials 10.7 on Oracle RDBMS Enterprise Edition v7.3.4.3. CITY HALL is the accounting system for Malaysia • BIEOracle 8i The BIE is a dimensional data warehouse deriving its data from an SAP/R2 FI and J2 system • SAP BW Oracle 9i The SAP BW is the main US financial Business Information Warehouse

  8. MIS OnVision MIS Excel Integration Access Layer Direct Access Direct Access OLAP Layer MIS Alea Microsoft Analysis Services Voyage Monitoring and Benchmarking Fleet Management and Ship Vetting Global Finance Group Financial Outlook Strategic Plan Master Data Management ETL Process ETL Process Relational Layer Corporate Performance Management Data WareHouse Source Systems ETL Process ETL Process ISMIS BIE SAP BW CODA PISCES CITY HALL Architecture

  9. relational DWH Microsoft SQL Server 2000 Informatica Power-Centre STAGING AREA (STA) STAR SCHEMAS (SS) META DATA REP (MDR) OPERATIONAL DATA STORE (ODS) Relational Layer • Data Warehouse Key Benefits • Following the “Ralph Kimball Approach” • Makes an organisation’s information easily accessible • Presents the organisation’s information consistently • Is adaptive and resilient to change • Serves as the foundation for improved decision making • Is the ideal base for analytical applications

  10. Group Financial Outlook US Finance Global Finance SG Finance UK Finance Forecast & Assumptions Voyage Monitoring and Benchmarking OLAP Layer

  11. StandardReporting MIS onVision -ad hoc Reporting-Budgeting-Forecasting -Meta-Data Master-Data Maintenance MIS Excel-Integration Relational DWH MOLAP Access Layer

  12. Post Solution Capability Enhancement

  13. Core Benefits Benefit Summary: • Growth Maintain pace with new challenges (e.g. Green Book, Value Project) • Control Increased timely and accurate decision making including financial forecasting • Efficiency Reduced manual intervention, reduced impact of new business requirements & increased data integrity

  14. Benefits Across the Organisation • Better quality of information • Greater ownership and visibility of data • Improved predictability • Improved decision making

  15. Any Questions? Also visit the Systems Union stand to get further information

More Related