Paul Gathard at

Pfizer Pharmaceuticals

Pfizer Pharmaceuticals, Pension Data Analyst - Forensic Reconstructionist– Pfizer has acquired many companies over their business history and recent federal legislation required them to finally pull all of the employee history, including compensation from all legacy payroll systems, into one comprehensive data file within the PeopleSoft Pension Administration and HRMS systems. Pfizer uses a career average earnings benefit formula.

In many cases, some of the data sources contained gapping holes in the earnings history of large groups of employees from acquired companies including non-US sources. Mercer Human Resource Consulting and Actuarial Services was tasked to conduct forensic accounting for all employees using all possible data resources in the reconstruction of the earnings history of approximately 94,000 employees dating back to 1963.

Mr. Gathard’s role was in the reformatting and consolidation of data from these various sources of earnings history and build a rational earnings history for each employee affected for actuarial certification. Once the reconstructed employee earnings data was approved by the actuaries, Mr. Gathard wrote the SQL scripts to update incorrect data or insert missing data into the Pension Administration and HRMS production environment.