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