Providing a Complete Suite of Information Management Solutions
Multi Country Roll Out of PeopleSoft EPM HCM DW
Business Requirements
Need for common reporting and analysis of HR information across its International Businesses.
To address the reporting gaps that currently existed and to streamline the data consolidation across its various lines of business through a data warehouse.
Solution
Developed common file layout to collect HR data from 50+ different countries.
Built hierarchies of and synced up with the LDAP system.
Leveraged our rich experience in design and development role in the actual Oracle PeopleSoft EPM product.
Built Cognos SDK based components for security implementation and audit reporting
Rolled out to multiple countries in four different phases.
Ensured minimal changes to the pre-packed ETL mappings for easier maintenance and leverage future upgrades.
Development of data marts, cubes and ad-hoc reports covering Workforce and Compensation.
Business Benefits
Decrease in overall effort (about 30%) in the overall lifecycle of the HR Analytics development project by implementing EPM Logical Data Model/Framework and pre-delivered ETLs.
Decrease in effort for future upgrades as there was minimum customization to the pre-delivered functionality provided in the product.
Integrated view of HR information
Technology Used
OLAP Tools – Cognos 8 Business Intelligence (BI)
ETL Tools – Data stage 7.5.2 server edition
Databases – Oracle
Source Systems – PeopleSoft HCM, Legacy systems
Other Application – PeopleSoft EPM
Enterprise BIDI Solutions
