Amey’s challenges included:

The Query Manager solution:

Expensive ABAP and the need for third party intervention

Query Manager has empowered the business to be able to create the reports themselves in-house, rather than use expensive third-party ABAP developers. The estimated amount of time for the process of creating reports has reduced from approximately two months via an external ABAP developer, to two hours in-house.

The need for a solution that was flexible to report on custom tables or attributes. For example, a number of external companies want to know department and business sector, where the person works and who to contact, and this wasn’t available.

Query Manager has built-in capability to link to custom tables and fields. Amey has used this in headcount reporting; they have a framework that requires up to 20 attributes attached to positions. Query Manager has allowed Amey to report accurately on these and give the business visibility.

Lack of governance, the risk of widespread access to SAP, and the inability to report out in groups

Query Manager gives Amey control and allows them to restrict access to selected users, to allow them to publish only the reports they need. Not only does this empower users, it also cuts admin time down by weeks.

The statutory reporting obligations were very difficult to manage in SAP, and not easy to adapt as new requirements arose.

With Query Manager, Amey can manage these regulatory reports much more easily. Reports required by Statutory Obligations include the National Minimum Wage, the National Salary Statistics Reports, Diversity reporting, holiday average and ONS. Because some of these reports are unique to the company, and Amey has created them, they can simply adapt them every year as needed.

As a contract-based company, Amey manages 2000 TUPE transfers in and out of the company every year, an enormous reporting burden

From a very laborious process previously of running about 30 reports and creating a spreadsheet, Query Manager has allowed Amey to create a much more streamlined report. An automated solution for data going in and out of SAP has reduced time from a couple of days to a couple of hours.

HR Input Audits were a challenge

Query Manager allows Amey to track any input errors and ensure that employee information is correct.

Payroll and third-party reporting; Amey provides around 75 third-party payroll reports to different companies (from unions to medical insurance providers). The process was very time-consuming and repetitive.

Amey used the Query Manager payroll wizard to create numerous payroll reports. Many are based on a gross-to-net report that gives them full payroll costing.

Amey also built a report in Query Manager which automatically determines wage-type and is automatically distributed by email; this task now takes about 20 – 30 mins rather than a few days.

The control of interfaces, and ensuring HR data is regulated when going outside of the business

Amey has a project to remove all interfaces and move all the data into Query Manager, giving them greater control. Also, the added security gives them reassurance with GDPR laws coming into effect.