Manufacturing – Large International Manufacturer

Large International Manufacturer

Strengthening a single enterprise view with integrated financials for IT portfolio and project management

A global leader and one of the largest confectionery manufacturer in North America this organisation wanted a single view of its IT investments globally to optimise business support from IT. It chose Oracle Primavera Portfolio Management and had Hyde Park Solutions assist it, most recently by integrating two streams of financial data using our Portfolios Data Load Utility.

Challenge

This large US based international retail organisation required regular uploads from two different finance systems, one daily and the other monthly to manage their portfolio of IT investments.

Approach

Our team was responsible for the initial implementation of Oracle Primavera Portfolio Management and during one of several subsequent phases we were asked to interface to their two finance systems.

A daily scheduled task was established to collect each of the two files placed in the interface directory on the Primavera Portfolio Management server by an extract routine provided by Finance. Once collected each file was processed in turn by Hyde Park Solutions Portfolios Data Load Utility (PDLU), undertaking a series of data validations, before executing the transformations and the load into the Primavera Portfolio

Management via the API.

Benefit

This was our first multiple system interface using PDLU, the key to which was the selection of the correct file configuration definition XML to correctly process the unique datasets provided. A previously sceptical Service Management welcomed the Hyde Park teams PDLU deployment saying it was

“as a single robust way of managing multiple data integrations to the OPPM tool”.

Service Sectors