Pfizer - Corporate HR Data Warehouse - Pfizer / Warner Lambert Merger
"The result of this powerful solution was a seamless integration of both companies' HR databases with minimal interruption. This solution allowed our combined company to immediately institute an early retirement program with incredible accuracy and timeliness. In addition, it allowed the HR Department to never lose touch with its most important consituency - our company's valued employees. My experience with BI Source has been excellent. I would strongly recommend BI Source to any organization facing difficult business challenges."
Nancy Fuhrmann
Manager, CHRIT Systems
Pfizer
Business Problem
One of the world's largest pharmaceutical companies was in the process of purchasing another pharmaceutical company. The result of this purchase was the creation of the world's largest pharmaceutical company. The resulting company had over 93,000 employees globally of which over 40,000 were located domestically.
The Human Resources Department needed to merge and combine each company's main Oracle employee database into a single Oracle database, effectively combining all HR related information from both companies. Pfizer was planning on using this database to drive and feed all future HR related programs including payroll, PeopleSoft, employee benefits and retirement packages.
BI Source Solutions
BI Source was able to develop a unique solution for this difficult problem. Calling upon our expertise in Data Warehousing and Data Mapping, BI Source was able to integrate and map each company's unique database into a single Oracle HR database. The result was a HR database with over 4.3 million records, 15,000 unique data fields and over 1,200 tables. In addition, this database contained historical information dating from 1986.
Result
The result of this powerful solution was a seamless integration of both company's HR databases with minimal interruption. This solution allowed the combined company to immediately institute an early retirement program with incredible accuracy and timeliness. In addition, it allowed the HR Department to never lose touch with its most important constituency - the company's valued employees.
