Multiple payroll efficiencies for large public sector client

May 14, 2018
Written by Adan Willemse

Adan Willemse is an experienced Services Consultant in the European region who specialises in products and services developed around SAP HCM. Adan joined EPI-USE Labs a few years ago, having previously spent ten years as an SAP HCM Consultant. This experience gives him invaluable insight into the practical application of EPI-USE Labs' solutions, including Query Manager, Variance Monitor and our Data Sync Manager suite.

EPI-USE Labs cuts time for DET payrol

EPI-USE Labs recently had the opportunity to assist a large public sector customer with their parallel pay run program. The program compared the payroll results of their legacy systems to their new SAP Payroll that contains more than 150 000 employees, many with multiple concurrent assignments.

For this project, we combined three of our products: Data Sync Manager, Variance Monitor and Query Manager (including Document Builder). We were able to:
Artboard 3-2

Using Data Sync Manager Client Sync, we set up a new baseline SAP system that could receive the data migration team’s data loads, and then after the loads were complete, we replicated this through the test landscape. This was done multiple times and has saved the project many months of time compared to using traditional tools and approaches..
 Artboard 5-10
Previously the SAP client copy process took over a week per client. DSM provisions the data in under four hours – and we have built over 20 environments.

We built lean fit-for-purpose SAP clients ensuring the project had the data it needed and also removed redundant legacy data from the landscape with DSM’s HCM profile, and Object Sync for HCM.

For example we:

  • Replicated the Base SAP Client so that each project stream had an environment
  • Created project milestone specific snapshot systems for future reference (including the ability to compare stage 1 vs stage 2, 3 etc.
  • Replicated the Org Structure into new systems when required.

Not only did our approach and products save the project a lot of time, but also allowed it to use its system resources more efficiently. (For example, instead of having single client environments we could create multi-client environments that used less space.)

Using Variance Monitor, we were able to assist independent auditors to set up comparisons with triggered rule networks that compared the legacy system’s payroll results from a file to either simulated or saved SAP Payroll Results.

The ability to use tolerances and conditional branching in these rule networks significantly sped up the identification and resolution of issues.
Using Variance Monitor, we were able to assist independent auditors to set up comparisons with triggered rule networks that compares the legacy system’s payroll results from a file, to either simulated or generated SAP Payroll Results from the RQ Cluster.

Above: Variance Monitor 3 Sample Rule Network

We saved the Variance Monitor run results to a table that allowed us to prepare run-by-run reporting, tracking the reduction of variances over time with a Query Manager report.

Artboard 4-6
What stood out was Variance Monitor’s ability to accommodate complex wage type mappings, and how fast it could complete full comparisons for 150 000 employees (100 minutes). This meant that when data or configuration changes were released into the testing system, we could rerun payroll, compare the full set of results for over 150  000 employees and produce trend reports in less than half a day. The quick turnaround and trend reporting meant that the project team almost immediately knew how effective the changes were and whether they had a positive or negative impact. Most importantly, the project could execute more test runs which increased test coverage and lowered the overall project risk. 

What certainly expedited the analysis of variances was that each of the Variance Monitor Rules categorised the type of problem, be it missing data, configuration, SAP vs Legacy System calculation difference etc. So not only did Variance Monitor identify the issues but it also grouped the information logically which helped the team to triage faster and home in on the root causes, even with such a large set of data.

Variance Monitor 3 Summarizing Statistics

Above: Variance Monitor 3 Summarizing Statistics

Using Query Manager, we supported the project with some utility reports and customer-specified dashboards. Not only did we report on payroll result comparisons executed with Variance Monitor, but we also summarised and reported on Leave Accrual comparison data, prepared by a third-party product and saved into twelve different file formats. What stood out was the built-in formula language used to classify conditionally, count and add up data, the QM4 file data source extension, and the charts and graphs delivered by the Document Builder extension.

Sample Query Manager 4 Run-by-Run Comparison: Total Number of Variances

Above: Sample Query Manager 4 Run-by-Run Comparison: Total Number of Variances

Sample Query Manager 4 Run-by-Run Comparison: Source of Variances

Above: Sample Query Manager 4 Run-by-Run Comparison: Source of Variances

We looked at the holistic needs of the project, combining all of our solutions to deliver quality data, fast and effective automated testing and practical visualisation of the data. This helped the project to meet tight project deadlines and keep all stakeholders informed in real time.




Explore Popular Tags

Query Manager SAP SuccessFactors SAP HCM reporting HCM Reporting SAP HCM SAP Reporting HCM SAP Payroll SAP SuccessFactors Employee Central Payroll reporting EPI-USE Labs Payroll SAP SuccessFactors Reporting Document Builder Payroll reporting Query Manager Analytics Connector SAP Analytics Cloud SAP HCM Data SAP Query Microsoft PowerBI PRISM SAP Payroll data SAP SuccessFactors People Analytics Variance Monitor HR and Payroll data Human Capital Management (HCM) Tableau HXM Move Payroll Data people analytics sap query hr Data Sync Manager Employee Central Payroll Intelligent HR and Payroll Journey to SAP SuccessFactors SAP HCM Payroll SAP HCM journey SAP S/4HANA SAP S/4HANA Private Cloud Edition (S/4 PCE) COVID-19 Employee payroll HCM Productivity Suite HR SAP SAP ERP HCM SAP HR Reporting SAP HXM SAP and SuccessFactors HXM Reporting reporting solution ABAP Cloud-based SAP HCM solutions DSM for HCM Employee data GeoClock Let's Talk HCM Pay Recon SAP Data Warehouse Cloud SAP HCM Analysis SAP HCM On-Premise Solutions SAP HCM/HXM SAP SuccessFactors HCM Journey SAP SuccessFactors Roadmaps SAP data privacy and compliance SuccessConnect data validation payroll control center successfactors Data Sync Manager for HCM Employee Central Employee Central Payroll Reporting GDPR HCM, HR OData PRISM free assessment Query Manager with Document Builder Real-time reporting and document creation SAP Analytics Cloud (SAC) SAP HCM On-premise SAP HR SAP On-Premise customers SAP Payroll to the Cloud SAP Road maps SAP customers SAP data SAP data privacy & security Success Factors SuccessConnect 2019 Tax Reporting Transformation without re-implementation accurate payroll data certification custom infotype data source on-premise SAP HCM s/4HANA Analytics solutions Automated reports Automation Cloud migrations DSM Object Sync for SuccessFactors Hybrid Data Secure Data Types Data analysis Digital tranformation EPI-USE Labs’ solutions Employee Letters Employee communication Free HCM Assessment H4S4 HR Journey HR employee reports Human Resources Human Resources data Hybrid Reporting SAP and SuccessFactors Hybrid SAP and SuccessFactors Hybrid reporting Hybrid reporting solution Integrated reporting SuccessFactors SAP Microsoft Excel OData integration OM Object Sync On-Premise Payroll On-Premise Payroll S/HANA Sidecar On-premise reporting Organization of the data PA PRISM for HCM (Private Cloud Edition) People Analytics Workforce Planning Personalized documents Protect personal employee data Report Stories Reporting and analysis Robotic Process Automation (RPA) Robotic Process Automation framework S/4HANA Private Cloud Edition (PCE) SAP Data Privacy Suite SAP Data Security SAP ERP Payroll customers SAP HCM Roadmap SAP HCM and Payroll customers SAP HCM for SAP S/4HANA On-Premise SAP HXM 2021 SAP Mentors SAP SuccessFactors Hybrid SAP SuccessFactors Release updates SAP SuccessFactors Time Management SAP SuccessFactors Time Tracking SAP Wage Type Reporter SAP certified solution SAP migration SAPPHIRE 2018 SuccessFactors and the Intelligence Enterprise SuccessFactors' Employee Central Payroll TCO Calculator The Report Center The Road to People Analytics Time management Workforce Planning ad hoc data variances easy reporter high-speed, low-risk on-premise SAP data partner roadmap single reporting solution sq01 stories in SAP SuccessFactors People Analytics technology third party ALE STP report ASUG Accessing COVID-19 data Ad Hoc Query American Payroll Association (APA) Analytics Connector Analytics reports Analytics solution At-risk employees Australian Payroll Australian Tax Office (ATO) Automated analysis and pay run reconciliations Automatic HR reports Best practice in BI Bots Business Analytics Business Intelligence COVID-19 statistics COVID-19 vaccinations Certified solutions Check for data replication errors Client Sync Cloud hosting SAP PCE Company Branding Compare legacy HR and Payroll data Comparing data Configuration Center Copy and mask test data Coronavirus Created timestamp Custom store Customer-specific infotypes DSAG Data Privacy Data Replication Data Sources Data Sync Manager (DSM) Data access Data privacy regulations Data production support issue solution Democratize data Description Diversity & Inclusion reporting DocuSign Document Building Dynamic data ECC EPI-USE ERP Education sector Electronic Signatures Embedded Analytics Edition Employee Central time Employee Central timesheets Employee NICs Employee payment summaries Employee right to privacy Employer NICs Encrypt data FAQ Index Font Guidelines Gender Pay Gap General Data Protection Regulation Governance, Risk Management and Compliance (GRC) Government forms Grid control Grid layout HANA HCM Client Sync™ HCM/HXM/HR Blogs HIPPA HMRC HR Innovations 2019 HR Service Delivery HR and Payroll Integration HR conference HR documents Historical payroll results Hourly time tracking
+ See More

Get Instant Updates

Leave a Comment: