Procter & Gamble & Gillette Merger
Braun/OralCare Process and Data Integration
Gillette PK1 to P&G GBP SAP R/3 6.0
This project integrated pre-acquisition processes at both companies (P&G and Gillette) into a new set of processes for the combined companies. DRO coordinated the work of the project team, which included business and IT experts from both companies, and accounting and tax experts from P&G.
DRO worked with P&G’s on-site contractor for work process mapping (in Mega®), P&G’s business and IT experts, and Gillette’s business and IT experts to execute a week-long, co-located paper prototyping session, during which every transaction in the capital budgeting, purchasing, receipt, payment, and asset management processes were mapped out using paper index cards taped to a wall (literally). This highly visual and engaging method proved to be an effective way for the two organizations to negotiate and align on a set of future processes.
The project also included data migration from one Gillette SAP instance (PK1) to one P&G SAP instance (GBP), used solely for capital and asset management.
Like many data migration projects in our portfolio, this work began with the writing of functional requirements, for a transformation tool to extract SAP data from the ‘source’ database (Gillette PK1), then transform (edit, convert) data for input to a ‘destination’ database (P&G GBP), and finally load clean data into the destination database. The tool provided for archiving a record of the source data, batch editing of data to ensure conformance to the destination database, automated error detection, online record-at-a time manual editing to correct errors, loading of the resulting clean data in the destination database, and lastly, online validation to ensure that destination data totals line up with source data totals.
For this project, familiarity with Gillette data structure was a key to successful data integration. For that reason, P&G selected Gillette’s alliance contractor for IT services to build the data migration tool. DRO, as project manager, coordinated the efforts of the project team, defined the steps and gate reviews for the project, and oversaw the work to migrate data.
Much the same as any data migration project, the process was structured as:
> Import Source
> Check Source for Errors
> Manually Eliminate Errors
> Summarize and Total Source Data
> Transform From Source Format to Destination Format
> Check for Errors
> Manually Eliminate Errors
> Load to Destination
> Validate Destination matches Source
Test & Acceptance
Working with the customer’s key business and IT experts, DRO developed and tested detailed test plans to ensure data integrity at all stages of construction.
As each module is developed and determined to be ready for test, DRO observed the customer’s team of experts running sets of data from a ‘QA’ instance of the source data through the data transformation tool.
Reports were saved at each stage to document a baseline from which to test the next module at the appropriate time.