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 HCM Reporting SAP HCM reporting SAP HCM SAP Reporting HCM reporting EPI-USE Labs Payroll Document Builder SAP Analytics Cloud SAP Query SAP SuccessFactors Employee Central Payroll SAP Payroll SAP SuccessFactors People Analytics SAP HCM Data SAP SuccessFactors Reporting Human Capital Management (HCM) Microsoft PowerBI Payroll Data Query Manager Analytics Connector Variance Monitor people analytics sap query hr Data Sync Manager Payroll reporting SAP SAP Payroll data Tableau COVID-19 Employee Central Payroll HCM Productivity Suite HR Journey to SAP SuccessFactors SAP HCM journey reporting solution successfactors ABAP Cloud-based SAP HCM solutions GeoClock HXM Move PRISM Pay Recon Query Manager with Document Builder SAP SuccessFactors HCM Journey data validation payroll control center DSM for HCM Data Sync Manager for HCM Employee data Let's Talk HCM OData SAP ERP HCM SAP HCM Analysis SAP HCM On-Premise Solutions SAP HCM On-premise SAP HR Reporting SAP HXM 2021 SAP On-Premise customers SAP S/4HANA Private Cloud Edition (S/4 PCE) SAP SuccessFactors Roadmaps SAP and SuccessFactors HXM Reporting SAP customers Success Factors SuccessConnect 2019 Successconnect Tax Reporting Transformation without re-implementation certification custom infotype data source DSM Object Sync for SuccessFactors Hybrid Employee Central Employee Central Payroll Reporting Employee Letters Employee payroll Free HCM Assessment GDPR HCM, HR HR Journey HR Service Delivery Human Resources Human Resources data Hybrid Reporting SAP and SuccessFactors Hybrid reporting Hybrid reporting solution Intelligent HR and Payroll Microsoft Excel OData integration OM Object Sync On-Premise Payroll On-Premise Payroll S/HANA Sidecar On-premise reporting PA People Analytics Workforce Planning Personalized documents Robotic Process Automation framework SAP Data Security SAP Data Warehouse Cloud SAP HCM Payroll SAP HCM/HXM SAP HR SAP Mentors SAP Payroll to the Cloud SAP S/4HANA SAP SuccessFactors Hybrid SAP SuccessFactors Time Management SAP SuccessFactors Time Tracking SAP certified solution SAP data privacy and compliance SAP migration SAPPHIRE 2018 SuccessFactors' Employee Central Payroll The Report Center The Road to People Analytics Time management Workforce Planning ad hoc easy reporter ebook high-speed, low-risk on-premise SAP HCM on-premise SAP data partner roadmap s/4HANA single reporting solution sq01 technology third party ALE STP report ASUG Accessing COVID-19 data Ad Hoc Query American Payroll Association (APA) Analytics Connector Analytics solution Analytics solutions At-risk employees Australian Payroll Australian Tax Office (ATO) Automated analysis and pay run reconciliations Automated reports Automation 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 Cloud migrations Company Branding Compare legacy HR and Payroll data Comparing data Configuration Center Copy and mask test data Coronavirus Created timestamp Customer-specific infotypes DSAG Data Privacy Data Replication Data Sources Data Sync Manager (DSM) Data Types Data analysis Data production support issue solution Description Diversity & Inclusion reporting DocuSign Document Building Dynamic data ECC EPI-USE Labs’ solutions ERP Education sector Electronic Signatures Embedded Analytics Edition Employee Central time Employee Central timesheets Employee NICs Employee communication Employee payment summaries Employer NICs Encrypt data FAQ Index Font Guidelines Gender Pay Gap General Data Protection Regulation Government forms Grid control Grid layout HANA HCM Client Sync™ HCM/HXM/HR Blogs HIPPA HMRC HR Innovations 2019 HR and Payroll Integration HR and Payroll data HR conference HR documents HR employee reports Historical payroll results Hourly time tracking Human Capital Management Human Resources reports HumanRevolution Hybrid SAP SuccessFactors environment Hybrid SAP and SuccessFactors IRS Tax Withholding Estimator Infotype Instance Refresh Instance Sync Instance Syncing Integrated reporting SuccessFactors SAP Intelligent Enterprise Intelligent slicing of payroll data JHUCSSE Knowledge Base (KB) Articles Kronos LabsScript Learning and growth Leave Liability Reporting Legislative compliance Leveraging Fiori Technology Location Managed Payroll Merging and splitting of cells Modified timestamp Move to SuccessFactors Employee Central New York Times News OCHA Organization of the data Owner PRISM for HCM (Private Cloud Edition) Pandemic Parent template Password protection Pay As You Go (PAYG) Pay reconciliation Payroll data in a dashboard Payroll support and reconciliation
+ See More

Get Instant Updates

Leave a Comment: