Pfizer - Talent Management System (TMS)
"With the TMS application, our HR Department can now support the Talent Review Process more efficiently without duplication of manual input. BI Source played a significant role in making this project a success; I would strongly recommend them.""
Chris Erickson
Director, Applications Strategy & Planning
Pfizer
Business Problem
One of the world's largest pharmaceutical companies was in the process of revamping its entire Talent Management Program. The company wanted to formalize the succession planning process worldwide, allowing it to anticipate future open executive management positions and proactively create and develop a pool of management talent designated to fill these positions.
The Human Resources Department needed a solution that utilized PeopleSoft as a data source and provided a highly secured, easy-to-use front end.
BI Source Solutions
BI Source was able to develop a unique solution for this difficult problem. Calling upon our expertise in Data Warehousing and Cognos, BI Source was able to use PeopleSoft as the data source and Cognos as the reporting engine. BI Source built queries that extracted data from PeopleSoft, built a staging area to "hold" the data and then built a Data Warehouse to "store" the data. Cognos then interacts with this Data Warehouse and delivers its reports via an Intranet application. This application utilizes the established security rights in PeopleSoft to maintain tight security. In addition, BI Source built a unique front-end for the Talent Management System (TMS) application. This front-end allows users to create multiple filtering applications (ex. by region, by discipline) and store these filters for future use, making the entire process much more efficient and effective.
Result
The result of this powerful solution was the HR Department could provide an extremely high level of service to the executive team without the duplication of manual input. By pulling data directly from PeopleSoft, BI Source ensured the accuracy of the existing data without the HR Department having to reenter it. In addition, due to the tremendous success of the application, the client has now decided to apply this solution to all levels of management, ensuring continued smooth transitions and development of leaders within the company.
