1 / 22

The Experian DRM Journey

The Experian DRM Journey. Oracle Open World InterContinental Ballroom A 23 rd September 2013 3.15-4.15pm. Richard Harwood and Mariana Venter. The Experian DRM journey Presenter introductions. Richard Harwood Global Transaction Reporting and Data Quality Manager. Mariana Venter

adie
Télécharger la présentation

The Experian DRM Journey

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. The Experian DRM Journey Oracle Open World InterContinental Ballroom A 23rd September 2013 3.15-4.15pm Richard Harwood and Mariana Venter

  2. The Experian DRM journeyPresenter introductions Richard Harwood Global Transaction Reporting and Data Quality Manager Mariana Venter Global Financial Systems Manager • 9 years at Experian • CIMA & ACMA qualified accountant • Various finance roles at Experian • Currently, responsible for: • Managing Global Chart of Accounts • Driving consistency across the group • Various project engagements • Business Intelligence • 2 years at Experian • Accounting and Information Technology degree • 13 years experience in developing, consulting and implementing Hyperion Essbase, Planning and DRM applications

  3. The Experian DRM journeyExperian PLC overview • Revenue: US$4.7 billion • EBIT: US$1.3 billion • Market Capitalisation*: c.£12 billion • In top 50 of FTSE-100 • Employees: c.17,000 • Offices in 40 countries • Largest markets: US, Brazil, UK • Corporate headquarters: Dublin Leading global information services company, providing data and analytical tools to clients around the world For the year ending 31 March 2013 * At 9 May 2013

  4. The Experian DRM journeySession content The Power of Oracle Hyperion Data Relationship Management at Experian [CON6122] • Experian before DRM • Initial DRM deployment • DRM expansion • Current projects • Next steps for DRM at Experian • DRM benefits • Critical success factors

  5. The Experian DRM journeyExperian: October 2008 Disparate local financial systems The key drivers for Global Finance Transformation Non-standard local chart of accounts Inconsistent processes Excel-based local reporting In-country transaction processing Highly manual regional/global reporting Project Gemstone Multiple local bank accounts OSA OFA Outlook Soft

  6. The Experian DRM journeyProject Gemstone (live January 2010) • Single global instanceof Oracle EBS R12 • Global Chart of Accounts design & implementation • Standard finance processes SAPPHIRE Global finance system & optimised processes Emerald Rationalisation of legal entities Opal Tax efficiency optimisation • 3 regional finance shared service centres • Global finance sharedservices organisation • Regional standard banks DIAMOND Global finance shared services Glass Functional currency • Hyperion HFM, Planning, Essbase, OBIEE & OBAW • Integrated with EBSleveraging DRM & FDQM • Global finance CoE RUBY Global finance reporting and analytics Topaz Order to Cash Optimisation (US)

  7. The Experian DRM journeySystem configuration overview – January 2010

  8. The Experian DRM journeyDRM and the Chart of Accounts change process • CoA data master • Create / update • Standard hierarchies 2 days • Additional hierarchies • Property setting • CoA documentation 5 days (after test cycle)

  9. The Experian DRM journeyHyperion Essbase properties set in DRM • DRM properties and hierarchies used to populate Essbase metadata • Export to application • Alias • Consolidation operator • UDA • Alternative hierarchies • Store Data • Formula • One central place to update for all applications

  10. The Experian DRM journeyHyperion Planning properties set in DRM • All Planning properties are set in DRM: • Alias, Account Type, Variance Reporting, Time Balance, Skip, Smart Lists, Data Type etc.

  11. The Experian DRM journeySupport team and volumes • The long run average is 165 CoA changes per month • Experian is a dynamic organisation • Organic growth, geographical expansion and acquisition • Central team of 3 employees • Monthly process is c. 20 person days

  12. The Experian DRM journeyEvolution of DRM Oct-08 Jan-10

  13. The Experian DRM journeyCustomer and Account Manager dimensions Sales Insight UK&I (Feb 2010) • Add Customer and Account Manager dimensions • Daily loads from UK&I Billing system Sales Insight EMEA & APAC (Nov 2012) • Add Customer and Account Manager dimensions • Daily loads from Oracle AR system for new Customers and Account Managers DRM changes required to support Sales Insight • New dimensions • Customer • Account Manager • Vertical Market • Additional alternative hierarchies • Additional 120,000 nodes

  14. The Experian DRM journeyAutomation • Manage daily batches through DRM • DRM version used as front end • Manage by end user • Logs • Tracking • E-Mail alerts

  15. The Experian DRM journeyManage Batches through DRM

  16. The Experian DRM journeyDRM connections today • Daily DRM processes • Feeds from Oracle AR and Billing • Feeds to Oracle AR and Billing • Exports to Staging Layer • Essbase Studio build cubes • Monthly DRM processes • Feeds from Oracle EBS • Exports to Staging Layer • Batch load Hyperion Hyperion 11.1.2.1

  17. The Experian DRM journeyEvolution of DRM Feb-10 Nov-12 Oct-08 Jan-10 Nov-12 Sep-13

  18. The Experian DRM journeyWhat next? CURRENT • Problems with current process • Manual set-up in Oracle EBS • Elements of dual keying • Difficult hierarchy management • Timing difficulties in process • Inflexible/inefficient ‘what if?’ • Oracle Data Relationship • Governance (DRG) • Front-end workflow for DRM • End-users propose changes • Approvals routing • Automated value creation • New applications • CAPEX planning • OPEX planning • Leverage existing dimensions FUTURE • Benefits of future process • Easy ‘what if?’ modelling • Simultaneous app. updates • Auto upload limit dual-keying

  19. The Experian DRM journeyBenefits of DRM at Experian • Single source of metadata for downstream systems • Flexible reporting solutions; calculations & hierarchies • Helps to facilitate central governance model and timings • Can be administered by non-technical users • Drag and drop hierarchies, property settings etc. • Version control allows appropriate testing and roll back • Ability to leverage existing structures in new applications

  20. The Experian DRM journeyCritical success factors and lessons learned • Project – DRM implementation • Resourcing: Get the right business/consultancy mix • Senior stakeholder sponsorship and engagement • Excellent intra-team communications • Involvement of post implementation support team • Technical • Use appropriate prefixes to identify application • Re-use exports/queries/properties wherever possible • Leverage existing hierarchies for new applications • Consider DRM version (EBS control, DRG implementation) • Governance process & data quality • Full CoA documentation – think about process driven • support rather than a dry list of definitions • Set appropriate calendar for metadata changes • Empowerment of governance team to own the application

  21. The Experian DRM journeyQuestions? Questions?

More Related