Overview
Customer is a leading North American provider of transportation and logistics services, operating across the United States, Canada, and Mexico. The company offers a comprehensive range of services through its network of operating companies, including package and courier delivery, truckload, less-than-truckload, freight forwarding, transportation management, and logistics brokerage.
Problem
Union rate calculations were manual and time-consuming, relying on Excel sheets that caused delays, errors, and limited traceability. Complex union rules, varying by job, seniority, and location, required robust logic to maintain compliance.
- Manual, Excel-based union rate calculation with no real-time visibility
- Delays, errors and limited traceability across the process
- Complex union rules varying by job, seniority and location
The business needed an automated and compliant process to determine hourly wage rates for employees governed by collective labour agreements. The existing process was heavily manual, managed through offline Excel files, and lacked real-time visibility.
Approach
The team implemented an automated union rate calculation solution using Oracle Workforce Compensation, integrated seamlessly within Oracle HCM Cloud. This approach provided a centralized platform for managing, calculating, and reviewing all union-driven pay components in one place, ensuring transparency and efficiency.
- Automated weekly union rate computation using predefined union rules and formulas
- Flexible calculation rules covering role, work arrangement, location and experience
- Wage rates and minimum wage data held directly in Oracle as a single auditable source of truth
Winfo provided real-time visibility into union rate changes through a single workforce compensation worksheet, enhanced by fast formulas, eliminating the need for offline tracking. Alerts were designed to notify compensation managers of any exceptions.
Outcome
Automating the union rate process reduced processing time from days to a few hours, and established a scalable, maintainable solution catering to a large group of technicians and drivers.
The deployment of the automated rate calculation process in Oracle HCM Cloud, leveraging Workforce Compensation, enabled the client to centralize, standardize, and automate complex union pay processes.
Before vs After
The Difference Automation Makes
Manual Process
- Union rates calculated in offline Excel files
- Delays, errors and limited traceability
- Complex union rules maintained by hand
- No real-time visibility for HR and Compensation
Automated Workflow
- Weekly union rate computation automated in Oracle
- Centralized, auditable compensation data
- Rules covering role, location, experience and work arrangement
- Real-time visibility with exception alerts