Case Study: Alight achieves 600+ hours saved and 1M+ payroll deductions validated with Alteryx

Alight - Customer Case Study

Alight Solutions, a health and wealth benefits administrator serving over 3,000 clients (including nearly half of the Fortune 500), needed to verify millions of daily transactions stored in a DB2 back end while relying on Excel and Access. Ensuring every payroll and benefits transaction was correct was critical to participants’ pay and coverage, so the company sought to reduce manual effort and increase confidence in complex pricing and payroll calculations.

By adopting Alteryx, building an internal ambassador program, and creating custom macros (SQL and FTP), Alight automated pricing and payroll validations so a single user could run complex checks. The approach validated more than 1 million payroll deductions, cut a multi-week review to a single day, and saved hundreds of hours (for example, ~600 hours annually for one validation and ~400 hours in a payroll conversion), delivering 100% coverage and faster, more reliable insights.

Alight

Grant Jollands

Director and Senior Practice Manager