220 likes | 500 Views
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
E N D
The Experian DRM Journey Oracle Open World InterContinental Ballroom A 23rd September 2013 3.15-4.15pm Richard Harwood and Mariana Venter
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
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
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
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
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)
The Experian DRM journeySystem configuration overview – January 2010
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)
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
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.
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
The Experian DRM journeyEvolution of DRM Oct-08 Jan-10
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
The Experian DRM journeyAutomation • Manage daily batches through DRM • DRM version used as front end • Manage by end user • Logs • Tracking • E-Mail alerts
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
The Experian DRM journeyEvolution of DRM Feb-10 Nov-12 Oct-08 Jan-10 Nov-12 Sep-13
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
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
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
The Experian DRM journeyQuestions? Questions?