Jonathan Cunliffe Group IT Projects Manager n United

Jonathan Cunliffe Group IT Projects Manager n United Business Media n Group Reporting Project

United Business Media n Who are United Business Media?

United Business Media n A leading provider of business information services to the technology, healthcare, media, automotive, financial services and property industries n Provide services in news distribution, market research, publishing and events to customers across the globe n Brands include: è è è PR Newswire - world’s leading corporate news distribution service NOP World, one of the largest market research groups globally CMP, the B 2 B media and exhibition group operating in the US, UK, Asia and Europe.

Major UBM Products

UBM Media Channels

UBM Media Channels

UBM Media Channels

UBM Media Channels

UBM Media Channels

United Business Media n What size of system were we implementing?

United Business Media n For Group Reporting, Divisions report to Head Office è è 10 Divisional Offices in US 2 Divisional Offices in UK 1 Divisional Office in Asia Head Office operations in Ireland, Luxembourg, NY and London n 25 divisional users of the system plus Head Office staff

The Project and its Drivers n When and why did the project start?

The Project and its Drivers n 2003 - Decided to replace Group Reporting system n Main Drivers were: è è è è End of life of existing application Looking for enhanced analysis and production reporting capabilities for group management Statutory and Management applications to sit on 1 platform Wanted to automate cash flow Required more real-time validation checks Aiming for improved inter-company reconciliation Wanted integration with local accounting applications such as Oracle GLs Looking for quicker system operation in general n From beginning considered Project Management methods

Software Selection n What steps did we take to select the vendor and software?

Software Selection n First collected “feature” requirements using Use-Case modelling n Drew up a list of all known vendors 20+ and then using a Gartner survey, narrowed this down to 5 n Initial introduction to each of these products and requirements sent to vendors n Utilised scripted scenarios n Cartesis Magnitude was chosen as most suitable product for our requirements on this particular project

Selection of the Vendor and Software n Why did we choose Cartesis?

Selection of the Vendor and Software n Why did we choose Cartesis? è The Magnitude software met our feature requirements è Specifically Intercompany Reconciliation was better è Cartesis showed best understanding our particular requirements è Known quantity as a supplier long relationship with UBM

Selection of the Vendor and Software n What were the challenges?

Selection of the Vendor and Software n Challenges: è Getting stakeholders to buy in to the process è Trying to remove prejudice towards/against certain products è Concentrating on our requirements rather than being impressed by features that were not actually useful to us

Project Management Approach n What project management approach did we take?

Project Management Approach n Used PRINCE 2 Project Method, which revolves around: è è è è Management by exception Defining the requirements Having representatives from the users, suppliers and the business Has a project manager and project assurance Actively manages risks and issues Puts in place a clear communications plan Focuses on quality checking Has specific planning techniques n Timing was not ideal n But the Project Method did deliver and is being used on many other projects now

Stakeholders

Stakeholders CFO DCFO Group Head of Accounts And Divisional Users Group Financial Systems Analyst And Cartesis Project Manager from US HO Group IT Projects Manager Internal and external team managers

Results and Benefits n What did we get from the project?

Results and Benefits n Faster consolidation – from hours to seconds n Enhanced usability and interface n Up-to-date software n Running on industry standard databases n Significantly greater detail of data n Many more reporting/analysis options – company/FX simulation n More flexible to update company and account structures than previous application n Platform upon which we can expand our management systems

Key Lessons Learned n What were the key lessons to learn for the future?

Key Lessons Learned n As part of PRINCE 2 process an End Project Review n Lessons Learned - 5 main areas è Understand the method to be used and treat project roles seriously è Do not under-resource from the start è Do not start project until user requirements agreed and signed è Manage risks - but also give each an owner è Operate a dual-level communication channel with vendor

Future Steps n What are we going to do next?

Future Steps n Launch our Statutory part of the system with IFRS capability for interims, followed by US GAAP capability for year end n Refinement Project – to enhance the applications further to remove some areas where we evolved the system n Roll out Magnitude management system for one of our divisions CMP Medica è è è Additional 30 Offices Subset of our Group Application so quicker development Possibly explore this model for other group companies n Ensure the applications are SOX compliant for next year n Consider Magnitude for planning, forecasting and budgeting

Summary n In summary…

Summary n Challenging at times and many lessons learned n Overall has been a successful implementation n Project Team now fully understands the benefits of Project Management n You may be able to benefit from our experience n Questions…

Questions…