#ValueLeap with PDF Reader Utility – Stratus Driving Innovation with Automation

By Bhanu Regulagedda, Partha Pritam & Garima Goel

Problem Statement:

Rate Testing holds utmost importance for each insurance carrier as it deals with ensuring the accuracy of Premium and financials that the carrier charges to their customers. However, Rate Testing is complex to validate due to below factors:

  • Thousands of Testing combinations
  • Multiple States and LOB variations
  • Multiple level of Input data combinations

It is also practically difficult and challenging to validate all the combination and levels of input data manually since it is time consuming, error prone and expensive.

Proposed Solution Overview:

  • Stratus developed in-house Rate automation tool built using Selenium & Java, to automate the rate validation steps.
  • This tool compares the Individual coverage Premium and Total Policy premium of a Policy with premium generated in Rating algorithm sheets provided by the actuaries.
  • Generate user friendly reports to check the premium mismatches along with insights to the premium matches for easy understanding

Solution Details:

Step 1: Identifying the Rating Test scenarios

  • Functional QA team identifies the Rating Test scenarios for automation
  • Identify Test Scenarios covering multiple levels of data combinations which cannot be covered via manual validation

Step 2: Prepare the Test Data Sheet

  • Populate Rating algorithm worksheets (provided by actuaries) with diversified input data combinations
  • Create unique Rating algorithm sheet for each scenario
  • Use selenium scripts to read all the premium bearing fields and pull their values from Rating algorithm sheet to another spreadsheet called Test Data worksheet
  • Add the data input for fields those are non- premium bearing but mandatory for quoting the transaction in Test data spread sheet

Step 3: Execute the automation script

  • Selenium automation script inputs these data into GW PolicyCenter UI and Quote the transactions being tested (Submission, Renewal, Rewrite etc.).

Step 4: Result validation

  • Automation Script compares both individual Coverage premium and Total Policy premium stored in the test data sheet with Premium generated in PolicyCenter UI and reports the comparison result.

Understanding of Solution Architecture:

#ValueLeap – Business Value Delivered

  • 40% to 50% reduction in manual effort through Parallel bulk execution of automation scripts bringing efficiency
  • Increased test coverage helping to enhance the scope of test scenarios
  • Accuracy and consistency in validation of premiums and financials
  • Reduced defect leakage caused due to manual comparison
  • Reduced execution timelines
  • Easy and user-friendly end result reporting

Meet the Authors

Bhanu Regulagedda

Garima Goel

Associate SVP, Program Delivery, Stratus Global Technology Services