300+
over 300 running pipelines for this enterprise
100% automation
eliminated manual data entry
< risk
removed risk of sharing sensitive employee data
A major wholesale chain consisting of more than 200 stores and 60,000 employees struggled with painfully manual processes when it came to end-of-year profit distribution for its staff. They decided it was time to automate.
The Challenge
- Integrate three distinct, complex systems – Oracle, ADP, and calculation percentage software
- Replace manual ADP data extraction into spreadsheets to calculate payout amounts
- Accurately account for employees whom are eligible
- Reduce employee time and money used for calculations
- Time – get the solution out quickly in order to meet end of year quarter for annual payouts
The Objective
No automation was in place to extract employee data from ADP and calculate entitled employee amounts – making the process exhaustive, extensive, and expensive. The main goal for the project:
- Process automation and integration between ADP and the system performing automatic calculations
The Plan
Digibee automated their processes and integrated an application allowing data to enter directly into the company’s database. The Digibee platform was the integral piece to their digital ecosystem – connecting employee data in ADP, their Oracle database, and system used to calculate amounts to be paid.
The solution included file consumption, various encryptions, and database loading. Digibee ensured the highest level of security and compliance for the business, processing sensitive employee data securely and with ease. The entire process took two months and involved extensive collaboration between Digibee’s team, the customer’s HR and IT groups, and external analysts from ADP.
The Outcome
Digibee met the deadline and employee payouts were distributed for the new year automatically and accurately.
Other key results include:
- Continued performance as the central piece in this enterprise’s integration strategy – adding to Digibee’s list of over 300 running pipelines for the customer
- Reduced liability by removing spreadsheet circulation containing sensitive data
- Mitigating risk and human error
- Elimination of manual data entry reducing employee spend and boosting productivity
- Agility in the calculation and payout process
“This project makes up a fraction of the 300 existing pipelines running for this enterprise. Digibee is used as a core integration platform for its business operations.”
Digibee Functional Analyst