Pfizer - Enhanced Severance Program (ESP)
"The result of this was a system that clearly keeps track of severance package payment methods, such as in installments, deferred payments, or a lump sum payout. I have enjoyed my experience working with BI Source and would recommend them to any organization facing difficult business challenges."
Christina Nunnink
Project Manager, Process Development
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 was charged with managing the severance packages for the employees eliminated due to this merger. The Enhanced Severance Program (ESP) system was designed by BI Source to manage severance packages for the purchased company's employees. Upon completion of the merger, care was taken to ensure that all employees of the purchased company would have their jobs protected for at least 2 years. Enhanced severance packages were provided to employees in the event that they had to move more than 22 miles in order to find a position within the new company, their positions were lessened, or jobs were eliminated due to duplication.
BI Source Solutions
BI Source was able to develop a unique solution for this difficult problem. The project dealt with two major areas - handling all termination details as well as creating a fully integrated payroll system. Calling upon our expertise in Data Warehousing, Data Mapping and Cognos, various queries were written against the Oracle database to derive HR information. We then utilized Cognos reports to calculate actual package amounts that employees deserved, taking into consideration rules such as: age, salary, and length of employment. Working in conjunction with the Legal Department, the system provided EEOC and age discrimination reporting to the government while complying with all applicable labor laws. In addition, BI Source had to develop a payroll system to track when and to whom payments were made. BI Source designed a Cognos PowerPlay cube to provide management with over 70 different reports, allowing them to utilize virtually any variable to derive the report.
Result
The result of this powerful solution was a system that clearly keeps track of severance package payment methods, such as in installments, deferred payments, or a lump sum payout. The functional system has been in use for several years and has flawlessly handled payments of over $1 billion to over 1,300 people.
