HR Analytics Led to Improved Efficiencies in HR Operations

The client is a security service, monitoring, consulting, and investigation group, based in Stockholm, Sweden. The group has over 300,000 employees in 53 countries worldwide. As the Leader in Protective Services, it helps organizations achieve superior security programs and results. 

 

Background

 

One of the major business challenges for the client was the mundane and laborious processes involved in compiling HR reports from various sources, and the time and efforts spent in sifting, tweaking, combining, and manipulating the huge volume of data to come up with a usable report. The client had, therefore, embarked on an initiative to cut down manual maneuvering and the time required to generate reports. 

Solution

 

DiLytics implemented its HR Insight solution on Oracle Analytics Cloud. As part of the implementation, DiLytics:

  • Captured business requirements
  • Prepared Fit-Gap analysis document to identify the customization that needs to be done to fit its solution
  • Deployed HR Insight data warehouse
  • Deployed HR Insight data integration components
  • Deployed HR Insight business model, reports, and dashboards:

– Headcount

– Turnover

– Retention

– Payroll

– Leave and Absences

– Compensation

  • Customized ETL and loaded data from PeopleSoft into HR Insight data warehouse
  • Customized and validated the reports and dashboards in HR Insight
  • Performed UAT and trained client staff on HR Insight

Business Benefits

 

Key business benefits to the client included:

  • Improved efficiency in HR operations via the availability of multi-dimensional and insightful analyses
  • Effort and time savings in the generation of HR reports

Technical Stack

Source Systems: PeopleSoft, SAFES (Legacy system) and Microsoft Excel files

Data Integration Tool: Oracle Data Integrator (ODI)

Data Warehouse: Oracle 11g Enterprise Edition

Reporting Tool: Oracle Analytics Cloud

DiLytics Delivers