The Situation

The Operational Improvement Programme was a multi-year initiative designed to deliver a revised global workforce location strategy, and to deploy operational excellence (OpEx) working practices that would result in cost efficiencies throughout this US-headquartered financial services corporation. 

I was part of a UK-based programme team focused on implementing the required changes into operations across Western Europe – Germany, Switzerland, The Netherlands, Sweden, Finland, Denmark, Spain and Ireland.

The senior management team within each in-country operation had developed a business case which quantified the costs and benefits of realising the strategy across their business – typically illustrating the impact on operating costs, including headcount – and local project teams were then tasked with delivering the required changes, to the agreed targets. 

Delivery progress was to be monitored and reported on a monthly basis and communicated to the US-based Executive to facilitate ongoing decision-making, including any course-corrections required to achieve the aims of the overall global strategy.

Skyscrapers
coins in jar

The Task

I was asked to develop efficient and effective programme financial management processes and supporting tools that would:

  • Enable the monitoring of delivery progress against targets
  • Provide the reporting required to inform the US-based Executive

When I joined the programme, a significant amount of manual effort was being spent by offshore resources based in India to collate data and re-key into the PlanView PPM tool in use across the global programme.  

There were different outputs from the various HR and finance systems used by each in-country operation, complicated by a key requirement for accurate currency conversion – as global reporting was required in US Dollars. 

The Approach

By interviewing a cross-section of those involved in the programme, I gained sufficient understanding of the business problem I needed to solve. I also built relationships with the UK-based HR and finance teams to better understand what might be possible for the various in-country teams they had regular contact with as part of their business-as-usual (BAU) operations.

As-is process maps were produced and supporting materials validated, and from this information I could begin to identify opportunities to streamline processes and improve accuracy.

Two core objectives emerged:

  • Minimise the opportunity for error by taking data directly from the source wherever possible
  • Automate the upload of that data into the PlanView PPM tool

During my investigations I discovered that financial data from each country was collated into a central ORACLE-based system on a monthly basis, a BAU processed managed by the financial team in the UK.  This made it much easier to investigate the details of how the currency conversions were being managed along with the cost categorisations being applied – although it then became clear that programme-related costs were not always being coded correctly by the in-country finance teams, and that the monthly data feeds into ORACLE were not all received at the same time or in the same formats. It also became clear that the programme cost categorisations that had been set up on the PlanView PPM tool were not consistent with those used by either the UK or in-country finance teams – meaning that subjective decisions were being made as to where to attribute costs by each individual inputting the data alongside the risk presented by keying errors. 

As with the financial BAU processes, the HR team in the UK were also collating data into a central system (TIBCO SpotFire) on a monthly basis. Countries were again using disparate systems and providing their data feeds at different times, but this was compounded by being aligned with payroll timelines and not month end.  Quantifying any headcount-related costs very much depended on the contractual arrangements of the individuals impacted by the programme, but the HR team was much more reluctant to engage around making the information available to the programme. We eventually determined a way to anonymise the HR data by using employee IDs – however this would require consistent application and therefore buy-in from each of the in-country HR teams.

Four significant challenges to the proposed approach had now emerged: 

  • Ensuring that the correct cost categorisations and employee IDs were applied by the in-country finance and HR teams
  • Providing a valid and timely flow of data into ORACLE and SpotFire
  • Re-aligning the PlanView PPM tool to enable useful reporting of past and future programme performance
  • Whatever was changed for the Western Europe countries would also need to be adopted by the rest of the global programme, otherwise the reporting roll up to the US-based Executive would not be possible.

The Action

The cost of full automation directly between ORACLE, SpotFire and PlanView PPM was prohibitive, but previous experience meant I could explain to the PlanView PPM tool administrator that semi-automation via data import using Excel WAS possible, as long as the export of data from ORACLE and SpotFire in the required format could be agreed and that the field mapping was correct and consistent. 

The UK finance and HR teams agreed to provide the data exports, but the cooperation of the in-country project managers was needed to get the local teams on board. First I had to help them to understand why using the correct cost categorisations and employee IDs were so important – and then to reinforce that importance to the local finance and HR teams in tandem with their BAU contacts on an ongoing basis.

To achieve this I designed comprehensive communication and training which involved: 

  • Holding a series of group and 1:1 sessions with the in-country project managers via Skype to walk through the cost categories – what they included and how any exceptions should be handled. 
  • Publishing guidance on the programme team’s SharePoint site that could be shared with the in-country finance and HR teams and referenced as required.
  • Designing an Excel workbook for each in-country project manager to enable them to maintain a forecast for the costs and benefits which was aligned to the relevant categories, and could be used for discussions with their local finance and HR contacts. These were also stored on the SharePoint site for easy access and version control.
  • Determining a monthly reporting calendar indicating when the data feeds from each country would be submitted and then available from ORACLE and SpotFire – once further validation checks had been completed by the UK teams – and when that would be available for a single upload into the PlanView PPM tool.
  • Demonstrating to the PlanView PPM tool administrator how to import the Excel data and what the field mapping needed to be. 

The offshore resources that had previously been responsible for manually re-keying the data into the PlanView PPM tool were instead asked to populate the Excel workbooks for re-issue to the in-country project managers with the reported actuals, to enable a direct comparison with their forecasts. Eventually this part of the process was also semi-automated.

I also held review calls with each in-country project manager to make sure they understood how their forecasts related to the actuals reported, and what adjustments needed to be made. Over time their local finance and HR contacts joined these calls as they recognised the value in having a collaborative conversation.

The Result

I took responsibility for overseeing the end-to-end process for the first quarter, carrying out a series of defined validation checks to ensure the data upload into the PlanView PPM tool was successful. Adjustments were made where required, and the to-be process documented for roll-out to the rest of the global programme plus handover for ongoing management by the offshore team.

  • By semi-automating the data transfer process, approximately 3 days of manual effort was saved each month which could be re-directed towards tasks providing greater value to the programme. 
  • Introducing an end-to-end programme financial management process resulted in a significant reduction in time spent resolving data-related queries each month.  When a subsequent decision to re-baseline the overall programme business case was made by the US-based Executive – due to significant global exchange rate fluctuations over time – this approach became invaluable as it enabled the re-work of costs and benefits over several years to be completed quickly and accurately.
  • Communicating directly with and supporting the teams in-country not only provided accurate cost and benefit forecasting to project and programme completion, but promoted increased ownership and enhanced stakeholder communications with longer term benefits for the BAU finance and HR teams. 

Let's talk!

You can book a free 30 minute call or send us a message and we'll be in touch.