#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