Alight Solutions it’s a health and wealth solutions and benefit administrator. They serve over 3,000 clients in nearly 50% of the Fortune 500 companies providing different analytics solutions. Alteryx unlocked the power of their data to deliver services with improved quality and reduced effort while enhancing the team’s ability to provide value added solutions and insights. With their Alteryx solution Alight saved 400 hours in a payroll conversion reconciliation process, by allowing automation to validate one million payroll deductions, transforming a multi-week review process for health and insurance plans into a single-day review.
When you enroll in your annual benefits each year, we may be the back end that’s capturing and sharing that information with the carriers. What we have is an internal system. It’s a DB2 database and I was pulling in information to crunch it with Excel and Access database. We need to verify millions and millions of transactions that we get every day that impact participants’ lives. Whether it’s their paycheck or their health coverage. It’s very important that every one of those transactions is correct, because it does impact the person at the end of the day. It’s going to impact their coverage and their pay. Our objective is to reduce effort and increase confidence in complex calculations to enable the team to focus the project resources on value added solutions for our clients.
Total Benefits Administration (TBA) Platform
To grow your user base, you must focus on training and developing a group of Alteryx ambassadors. These users would help spread the capability through the organization. These ambassadors could be from any role and area of the business but should have a perspective on how to use the capability to solve business problems.
Objective Statement: Complete 100% validation while reducing effort
Solution: Created an inbound payroll actuals response file and using custom FTP macro built a repeatable H&I deduction compare process
By Brian Davis and Grant Jollands, Director and Senior Practice Manager, Alight Solutions