Guidewire (Transformation) Automation

Customers always looking for "Need for Speed with Quality", Which can be achieve through automation 

Guidewire

Guidewire is software product for the insurers, Top insurers using the Guidwire product to run their business to maintain the policies , billing and claims

Most of the insurers are upgrade the existing Guidewire products and adding the new line of business in Guidewire product, 

Guidewire (Transformation) Automation

Automation can help in two ways in the Guidewire world

1. Building the Guidewire System

2.Moving the policies from Legacy to Guidewire systems

3.Testing

Automation in Guidewire Transformation

Following areas have automation scope in Devlopment and Moving Data from Legacy to Guidewire

1.1 Forms

In Guidewire Policy center have to map the Forms with specific transactions, States and LOB's along with inference conditions

The combination will be more if more states and LOB's involved, So tool can be build automating tool which will read from the requirement document and create the XML's as per the Requirement documents.

1.2 Loading User Roles & Permission

Any automation tool (UFT/Selenium) can be used to load into Guidewire Admin tab.

1.3 Coverage Creation

Automate the coverage creation in Guiewire studio as per "Product Model"

1.4 Premium Validation

Guidewire will interact with multiple systems, Some of the insurer will use the other product for the New Business policies, So there is chance to get the Premium discrepancies need to analyze the request and response files, it's very difficult to do manually so it would be better to have "In house tool" to find the mismatches

2.1 XSD Generator

Create XSD for ETL to map the fields as per PC Data Model

2.2 DB Validation

During the policies transformation from legacy systems to Guidewire systems DB validation can perform crucial role,since tons of data has been moving out. The following areas potentially leverage these tool Source validator, Archival Validator, Comparing two different databases.

2.3 ETL Smoke Test 

After Data load, Data Conversion QA team need to prepare a sheet which include detailed list of policies loaded in Guidewire, it landing status , associates underwriting issues ,activities etc. to downstream to validate the functionality, There are multiple environments running up and after every load,its tedious job to preare the sheet by having the automation solution in macro which will do it in single click and prepare the data in pivot to pass it with other streams.

3.1 InSprint Automation

If the Guidewire Transformation project followed in Agile methodology, each sprint we knew the user stories to be delivered, The changes has to be made on the Guidewire OOTB, So identify the potential candidates for "In-sprint automation" using this approach

3.2 API Automation

Always there's need for the policies, So leverage the web-services to create the policies to support the teams involved, Compare to the GUI automation Web-services will be much faster and easy to maintain

3.3 Forms Inferences Validation

There's lot of combination will be involved during the "Forms Inferences and Content validation" so it would be better if your system support Webservices for the policy creation along with inferences conditions

3.4 Forms Content Validation

Forms Content validation done through open source tool like Selenium, There is JAR(PDFUtil) files will be there to extract the values from PDF and validated with Mockup files. The same jar will support Pixel to Pixel comparison if any images or Logo to be validated in documents


Stay Tuned for Detailed solution

Popular posts from this blog

Forecast the Values with Machine Learning Models

Guidewire (Maintenance) Automation