Pfizer - Corporate HR Data Warehouse - Global Rollout
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 in over 80 countries speaking more than 13 languages. In addition to immense cultural differences, there were also major differences in employment law and its application (ex. no other country requires Social Security Numbers). Each of these issues presented the HR Department with difficult, unique challenges.
The Human Resources Department made a strategic decision to merge and combine all the corporation's disparate HR databases worldwide. The intention was to place all HR related information into one source which would drive all future HR related matters. The resulting database had to be extremely flexible in order to adapt to the previously mentioned myriad of differences in each location.
BI Source Solutions
BI Source was able to develop a unique solution for this difficult problem. Working seamlessly as a partner with a number of other vendors to accomplish this enormous task, BI Source provided the key core competency to create the Data Warehouse from which all information flowed. BI Source wrote over 450 unique ETL (Extraction, Transform and Load) scripts designed to assist the HR Department in addressing its sophisticated information needs. In addition, this application required over 195 customized tables from PeopleSoft.
Result
The result of this powerful solution was the seamless integration of the company's numerous HR databases with minimal interruption. It allowed the HR Department to better serve its most important constituency - the company's valued employees.
