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.

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

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.

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