Having 2.5 Years of IT Experience as ETL Tester. Good Knowledge in SQL.
Having knowledge on SDLC, STLC, BLC. Good coordination with project teams to complete the testing assignments with utmost quality.
Involved in Document reviews and walk throughs. Performed functional/system, Regression testing and Re-testing.
Involved in the preparation of Test design, Test Cases and Test execution.
Migrate the policies from NextGen to Guidewire to identify the migration flow is as expected.
Preparing the Test data based on the functional specification document.
Validated the report in PowerBI tool to compare the summary of the policies.
Overview
3
3
years of professional experience
Work History
Test Analyst
Cognizant Technology Solutions, CTS
09.2021 - Current
Project :1 Project Name: Mercury (US based Insurance customer)
Tools: JIRA, DBVisualizer, PowerBi ,Guidewire, Nextgen Domain: Insurance Project Duration: Sept 2021 to till date
This is a Guidewire conversion project to convert policies from NextGen UI to Guidewire UI.
The project implementation is in a phased manner.
Migrate the policies from NextGen to Guidewire to identify the migration flow is as expected.
Used automation to validate data between two different databases. Used Arf and Eclipse automation to validate data between two different databases.
Validation of multiple scenarios based on the business inputs. Validation of data flow as per mapping, technical & business requirement documents in the below mentioned data layers
1.NextGen UI
2. NG DB to Stage
3.Stage to Preload
4.Preload to PMTIN/PMTOUT
5.Guidewire UI
6.Snowflake DB
Stories and bugs are tracked in JIRA for each phase.
Validated the report in PowerBI tool to compare the summary of the polices.
Education
Bachelor of Engineering - Civil Engineering
Velammal College of Engineering And Technology
Madurai, Tamil Nadu
07.2021
Technical skills and Tools
Operating System: Windows
Databases: MYSQL, DB2, MS SQL Server, PostgreSQL
Testing Tools: JIRA, Bugzilla, ALM, Eclipse
Programming Languages: SQL
ETL Tool: Informatica Power Center
Database Tool: DBvisualizer
Reporting Tool: PowerBI
Roles And Responsibilities
Responsible for testing on every data load and executing arf scripts through eclipse or arf tool.
Analyzing a root cause of errored out policies and rejected policies.
Reconciliation testing for failed policies due to recon mismatch.
Understanding the business requirements and functional specifications
Analyzing requirements and creating and executing test cases.
Preparing testcases, Reviewing testcases and executing those testcases.
Involved in Document reviews and walkthroughs.
Performed functional/system, Regression testing and Re-testing.
Preparing documentation for some of the recurring defects and resolutions and business comments for those defects.
Updating the weekly status report.
Logged defects in JIRA.
Declaration
I hereby declare that the information given above are true to the best of my knowledge and belief.