波

Better Health Benefits Administration with Less Effort

波

Overview of Use Case

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.

Describe the business challenge or problem you needed to solve

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

  • Platform designed to help our clients and their people navigate the complexities of their employer sponsored health and wealth benefits
  • Multi-Instance deployment (around 200 instances)
  • Common architecture across all instances
  • Isolated environments
  • High level of customization based on client specific requirements

Describe your working solution

OUR JOURNEY

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.

  • When we started 96% of our user base had no experience with Alteryx
  • One on one trainings with real work examples and sample workflows tailored to our environment were very successful
  • Demos: Asking users to try something new is more effective when they see results first-hand
  • Make solutions mandatory or the only option will grow adoption!
  • Eliminate barriers: we created Custom Macros to give access to data to our users
    • SQL macro – Run multiple queries against TBA system with one tool
    • FTP macro – Pull vendor files into Alteryx
      • Transformed a process that typically took 5-10 min to 30 seconds

PATIENT ZERO

Objective Statement: Complete 100% validation while reducing effort

Solution:

  • Alteryx enabled 1 user to automate pricing validations and increasing speed to deliver. Improving accuracy while reducing effort. The rate structure is on the highly complex with over 50 variances in pricing formulas to account for
  • 8 hours to review and iterate on results vs. hundreds of hours of manual review and inspection both internally and externally

PAYROLL VALIDATION IMPROVEMENT

Objectives:

  • Increase the quality of the payroll processing
  • Establish a payroll compare process between Alight and the payroll provider

Validation includes:

  • Arrears
  • Large deductions split over multiple pay checks
  • Pay frequency changes

Solution: Created an inbound payroll actuals response file and using custom FTP macro built a repeatable H&I deduction compare process

Describe the benefits you have achieved

  • PATIENT ZERO: 600 hours saved annually and 100% coverage
  • PAYROLL VALIDATION IMPROVEMENT: 1m + Payroll deductions validated and 100% coverage
REDUCE INCREASE
  • Demand for custom reporting (high effort and long lead times)
  • Errors by improved inspection
  • Demand for manual inspection
  • Risk of process failure due to knowledge transfer
  • Time waiting for insights due to handoffs
  • Self-service reporting and analytic capability
  • Ability to offer insightful observations and supporting solutions
  • Control and confidence in our services
  • Ability to focus on analysis rather than requesting and waiting for data
  • Refined outputs
  • Speed to deliver

By Brian Davis and Grant Jollands, Director and Senior Practice Manager, Alight Solutions

デスクワークをする男性と女性

導入効果を計算する

ROI カリキュレーターで、分析の自動化による費用対効果をご試算いただけます。
マクラーレンのレーシングカー
お客様事例
5 分で読む

データ分析の高速化により、勝利を手中に収めるマクラーレン・レーシング

週末に開催される F1 レースは年間 20 戦以上にも及び、1 レースあたり 1.5TB ものデータが生成されるため、こうした膨大な量のデータの効率的な収集、処理、活用を可能にするソリューションは欠くことのできない存在です。
マクラーレン F1 チームでは、Alteryx Analytics Automation Platform を使用して、サーキット内外で戦略的な意思決定を加速させています。

サプライチェーン
アナリティクスリーダー
ビジネスインテリジェンス/分析/データサイエンス
今すぐ読む
Apter Streamlines Customer Tax Projects with Alteryx
お客様事例
5 分で読む

Apter 社が Alteryx + UiPath で顧客の税務プロジェクトを効率化

税務コンサルティング会社の Apter 社は、完全に自動化されたエンドツーエンドの税務管理ソリューションをわずか 3 週間で構築しました。

リスク低減
UiPath
ビジネスリーダー
今すぐ読む
Takenaka logo atop photo of modern building
お客様事例

300年にわたり蓄積されたデータを次世代建築の設計に

蔵に眠っていた古い情報を、『人の想い』を伝える「使えるデータ」へと変貌させた Alteryx 老舗のデータ利用を支える Alteryx は現代における大工道具箱

データ準備と分析
製造
Alteryx Designer
今すぐ読む

分析を変革

データに潜むインサイトを引き出しませんか?
Alteryx 製品