case study

From Spreadsheets to Automation: Transforming Account Onboarding for Enhanced Efficiency

Insurance

Business Impacts

46+

Hours are saved monthly

42%

Reduction in TAT for application submission

23%

Reduction in possibility of error

Customer Key Facts

  • Country : America
  • Size : 10000+
  • Industry : Insurance
  • About : Client, an American insurance company, is the largest provider of supplemental insurance in the US providing financial protection to more than 50 million people worldwide.

Problem Context

Client’s sales and contracting team were evaluating opportunities to minimize rework and time taken for validation with agents during the account onboarding process. The partner teams wanted to automate the initial information intake process for notification forms with a web based interface to replace the spreadsheet driven legacy process

Challenges

  • High Error rate due to manual validation
    of the process and forms
  • Multiple version of documents required across platforms
  • Separate email, excel and sharepoint based process increasing complexity

Technologies Used

AWS EC2

AWS EC2

AWS EKS

AWS EKS

AWS RDS

AWS RDS

Mule Soft

Mule Soft

Snowflake

Snowflake

PostgreSQL

PostgreSQL

Solution

The core solution involved building the utilities to extract & validate agent and account onboarding information and simplify the process across 3 identified areas

Data Extraction
Extraction of data from agent notification forms into the data layer aggregated which can be easily searched and queried

Workflow Automation
Seeding in automations within the workflow using existing rules to validate inputs

Seamless Engagement
Unified engagement layer for personas to drive visibility of enrollment status & compensation details including validation, search of enrollment records and authorization status

Results

Ease of completion & elimination of manual steps

  • Automation of the agent notification form process has saved approximately 46 hours each month.
  • The new web-based interface has replaced the spreadsheet-driven legacy process, eliminating manual steps and reducing complexity.

Single view of form across all stages of completion

  • Unified view of the form at all stages of completion to provide clear visibility and tracking, enhancing user experience and process transparency.
  • Improved Tracking for users to monitor the form status, ensuring process accurately and efficiency at each each stage

Reduced Errors Ensuring Proper Payments

  • Automation has led to a 23% reduction in the possibility of errors, ensuring more accurate and reliable processing.
  • The streamlined process leads to accurate payment and improved trust in the system.

IDP, Process Automation, Data Extraction

  • Data Extraction: Efficient extraction of data from agent notification forms into a searchable and queryable data layer.
  • Process Automation: Workflow automation validates inputs using existing rules, streamlining the validation process and reducing the need for manual intervention.
  • Seamless Engagement: A unified engagement layer provides visibility of enrollment status and compensation details, including validation and search of enrollment records.

Start Your Next Gen AI Journey Today

Discover how Quantiphi’s AI-powered solutions can transform your business. Fill out the form, and we’ll help you explore tailored AI strategies to unlock new opportunities for growth.

Thank you for reaching out to us!

Our experts will be in touch with you shortly.

In the meantime, explore our insightful blogs and case studies.

Something went wrong!

Please try it again.

Share