Core Java Sql Server
Resume:
Srinivas Thumma Mobile: + * -470-***-****
E-mail :ad5wsr@r.postjobfree.com
Summary of Experience:
●Overall, 15+ years of extensive experience in Analyzing, Designing and Implementation of QA testing strategy using Manual testing along with Selenium testing automation.
●Strong knowledge in testing of Standalone, Client Server and Web based applications using Manual & Automation testing in core Java Selenium with TestNG,GT Framework and Karate,JUNIT frameworks.
●Good working Experience in Guidewire Policy Center Testing (Rating, Forms and Integration testing), Guidewire Billing Center Testing
●Well versed with Core Java,Python Scripting
●Having experience in Automating Guide Wire Application Using GT framework.
●Experienced in leading QA team across the globe and in working with Onsite/Offshore model by interacting with the client/vendor teams.
●Hands on Experience in TestNG Framework, Selenium Components Web Driver and Selenium Grid.
●Good Knowledge of P&C Insurance with experience in Personal and Commercial Lines of Business.
●Exposure to Database testing with SQL Server with proficiency in writing SQL queries to ensure that data transformations are applied properly.
●Good knowledge in CI/CD activities using Jenkins, Git and Maven.
●Extensive experience in conducting different kinds of tests such as Integration, Regression, Functional, Performance, Volume and Load Testing (QTP and Loadrunner)
●Have used Cucumber along with Selenium for BDD Automation.
●Worked on REST and SOAP API testing manual and automation (Selenium).
●Configured Jenkins for automation test suite job setup and CICD pipeline for automation test execution.
●Configured GitHub to maintain test automation repositories and Integrating the automation code to Jenkins for running Automation suite.
●Good Working Experience in ETL(Informatica) testing and have strong knowledge in Informatica & Data Warehousing.
●Well Versed with Cloud Platforms AWS, GCP and Azure.
●Worked in different domains like Banking, Insurance and Life sciences.
●Good Knowledge on HTML, CSS.
●Experience in defect reporting tools like ALM and JIRA
●Expertise in Guidewire ISO Rating, Integration and ISO Forms Validation
●Good Knowledge on troubleshooting the issues on Guidewire Policy Center Premiums and working with web service or Guidewire Development team for finding a Root Cause or Resolution,
Technical Skills:
●ETL : Informatica, Datastage.
●Databases : Oracle, Teradata, SQL Server
●Operating System : UNIX, Windows Family
●Other Tools : Quality Centre, ALM, Toad, MTM, Control-M, JIRA.
●Languages : SQL.Java, Python,HTML
●Bug Tracking Tools : ALM, TFS
●Automation : Selenium, LoadRunner,,UFT, API Testing, Rest Assure, SOAP, TestNG, Junit,Postman
●Policy Management : Guidewire Policy Center, Billing Center.
●SDLC Methodologies : Agile, Waterfall
●Cloud : AWS,GCP,Azure
Certifications:
Sun certified Java Programmer.
Internal Certified with Guidewire Policy Center (Intermediate Level) from Capgemini
Professional Experience:
●Working for S4 Works LLC from April 2024 to till date
●Worked for Capgemini from March 2015 to March 2024.
●Worked for IBM from October 2009 to February 2015
●Worked for IPass from March 2008 to February 2009.
●Worked for Capgemini from August 2006 to February 2008.
PROJECT DETAILS:
Project# 1:
Project Name : Zurich Surety Modernization
Client : Zurich North America
Role : Test Lead/SDET Engineer
Environment : Selenium, JIRA, SQL Server, Jenkins, GitHub.GuideWire
Project Duration : March 2022- March 2024
Description:
Zurich Surety is growing faster than the surety market. Zurich’s ‘best in class’ UW practices underpinned by cutting edge technology will enable Surety to deliver consistently high-quality underwriting, effective management of risk (entity and enterprise levels), differentiated service and lower, long term operating/ loss costs.
Responsibilities:
●Spearheading the Testing effort by performing requirement analysis for both Automated and Manual testing.
●Build and maintained an automated CI build and test pipeline with a goal of continuous delivery.
●Integrated Selenium tests into a continuous integration (CI) pipeline using tools like Jenkins.
● Created test scripts using GT framework for Automating Guide Wire
●Executed Test scripts using the GT framework
●Created Automation Page Object Module (POM) Scripts using Selenium Web Driver and C#. Involved in Selenium Script Review and Execution.
●Created test scripts for web applications using Java as programming language and Selenium Web driver and TestNG as automation framework.
●Involved in Designing & developing the Hybrid Model framework for the UI Web applications and Backend APIs using Selenium Web Driver and Python.
●Designing Cucumber (BDD) automation framework for subscription REST services.
●Performing functional testing for subscription API’s using postman.
●Developed test code in Java language using Eclipse IDE and configured Web Driver, TestNG, Maven tool and created Selenium automation scripts in Java using TestNG framework and page object model (POM).
●Created Test Plan, Test Cases, SoapUI NG Automation, opened and tracked bugs in JIRA, assisted User Acceptance Testing (UAT).
●Experience in performing Cross-platform, Functional & Regression testing.
●Cucumber was used for the entire regression testing and functional testing with Selenium as primary tool to the Test Scenarios, Test Cases and Test conditions identified.
●Preparing and Executing Batch Test Suite through Combat tool.
●Verify the Automated Test Result, and Logging the Defects in JIRA and creating report
●Participated in weekly status meetings with the team, developers to discuss open issues and communicating with the onsite team.
Project# 2:
Project Name : TOP3 Program – Guidewire Implementation (selenium testing)
Client : FICOH USA
Role : Test Lead
Environment : Selenium, JIRA, Confluence, Jenkins, GitHub, Guidewire
Project duration : March 201s8 -February 2022
Description:
First Insurance Company of Hawaii, Ltd. (FICOH) is the oldest and largest property and casualty insurer domiciled in Hawaii. The company offers personal products which include automobile, homeowners, and dwelling fire coverage, as well as home warranty and personal umbrella insurance. Its commercial lines include commercial auto, general liability, property, surety, and workers' compensation insurance.
Responsibilities:
●Develop test strategies and plans for Guidewire applications, considering factors like project timelines, resources, and requirements
●Work with the team to design comprehensive test cases covering various scenarios in Guidewire applications. This includes functional testing, regression testing, and integration testing.
●Design and implement automation frameworks using Selenium WebDriver for testing Guidewire applications. This involves selecting appropriate frameworks, creating reusable components, and ensuring scalability and maintainability.
●Oversee the execution of automated test cases using Selenium, ensuring proper configuration and environment setup
●Created test scripts using GT framework for Automating Guide Wire
●Executed Test scripts using the GT framework
●Monitor test results and investigate any failures or issues.
●Track defects found during testing, prioritize them based on severity and impact, and work with developers to ensure timely resolution
●Verify the Automated Test Result, and Logging the Defects and creating report
●Participated in weekly status meetings with the team, developers to discuss open issues and communicating with the onsite team.
●Involved in Automation Environment setup using Eclipse, Java, Selenium WebDriver jars
●Participated in weekly status meetings with the team, developers to discuss open issues and communicating with the onsite team.
●Understood the complete requirements of the Client.
●Preparing test plan and test strategy document
●Identify the day to day issues/gaps and resolve them.
Project# 3:
Project Name : West Bend Mutual Insurance
Client : West Bend, USA
Role : Test Lead
Environment : Selenium, JIRA, Confluence, GuideWire, Jenkins, GitHub
Project Duration : March 2015- Feb 2018
Description:
West Bend Mutual Insurance Release 1 is a Project delivering reporting capability for improved management control and business decision making of the Enterprise through more granular data capture and reporting of policies, claims and Agency Performance data.
Responsibilities:
●Preparing test plan and test strategy document.
●Getting work from client / onsite and assigning tasks to offshore team
●Developing and executing Selenium Automation scripts
●Identify the day to day issues/gaps and resolve them.
●Responsibilities starting from requirement analysis, Test designing and test execution activities.
●Designing test cases and mapping the test cases to requirements.
●Executing the test cases and reporting the defects if there are any deviations from the expected behavior.
●Sending the daily and weekly status reports to stakeholders.
●Trained the team members to perform their tasks smoothly.
Project# 4:
Project Name : Zurich Michelangelo
Client : Zurich USA
Role : Tester
Environment : Informatica, SQL Server, ALM.Guidewire
Project Duration : Jan 2014-Feb 2015
Description:
Project Michelangelo is the Zurich Project delivering IM reporting capability for improved management control and business decision making of the Enterprise through more granular data capture and reporting of claims data. Reporting majorly covers Claims function Reporting and Enterprise Reporting.
Responsibilities:
●Identify the day to day issues/gaps and resolve them.
●Responsibilities starting from requirement analysis, Test designing and test execution activities.
●Designing test cases and mapping the test cases to requirements.
●Involved in guidewire Policy Center Integration, Forms, Rating testing.
●Writing SQL queries and executing them to ensure that data transformations are applied properly.
●Executing the test cases and report the defects if there are any deviations from the expected behavior.
●Sending the daily status reports to stakeholders.
●Trained the team members to perform their tasks smoothly.
Project# 5:
Project Name : Business Intelligence Platform (ETL testing)
Client : DBS Bank
Role : Tester
Environment : Informatica, DB2, SQL Server, ALM.
Project Duration : October 2009 to Dec 2013
Description:
The BIP (Business Intelligence Platform) is a regional data warehouse to support the bank's regulatory, MIS and analytical functions. The BIP is loading data from various source systems (VisonPlus, CIS, Finacle, Murex and PeopleSoft). A majority of the different types of data are been loaded into the BIP, which include customer data, product information and detail balance and transaction data.
Responsibilities:
●Identify the day to day issues/gaps and resolve them.
●Responsibilities starting from requirement analysis, Test designing and test execution activities.
●Writing SQL queries and executing them to ensure that data transformations are applied properly.
●Designing test cases and mapping the test cases to requirements.
●Executing the test cases and reporting the defects if there are any deviations from the expected behavior
●Sending the daily status reports to stakeholders.
●Trained the co-team members to perform their tasks smoothly
Project# 6:
Project Name : Master Information Hub Warehouse Testing
Client : Belastingdienst.
Role : Tester
Environment : Datastage, SQL Server, Winscp, Unix, ALM, CDC.
Project Duration : Mar 2008-Feb 2009
Description:
Dutch Tax Authority needs to have a complete customer profile when performing its tasks; the Tax Authority wants to offer its users within the Service and Supervisory Domain reliable data more rapidly than it is able to with the current systems and methodologies. We cannot acquire this customer profile within the current situation based on tax-oriented applications (Back Office) such as an application for handling the income tax and national insurance levels (IH) and an application for handling payroll taxes (LH).
Responsibilities:
●Designed the System Integration test cases for various releases of the project.
●Used Change Data Capture tool to capture the changes of data
●Responsibilities starting from requirement analysis, Test designing and test execution activities.
●Designing test cases and mapping the test cases to requirements
●Writing SQL queries and executing them to ensure that data transformations are applied properly.
●Executing the test cases and report the defects if there are any deviations from the expected behavior.
●Sending the daily status reports to stakeholders.
Project# 7:
Project Name : Achmea Solvency II
Client : Achmea Insurance
Role : ETL Tester
Environment : Informatica 8.1, Win SQl, DB2, Clear quest, UNIX.
Project Duration : August 2006- Feb 2008
Description:
To fulfill the compliance and legislation requirements, Achmea has started with the ‘Value Management’ program. The objective of the program component ‘Data Management’ has been arranged to satisfy the Solvency II directives from an IT perspective. Data Management is responsible for the availability of actuarial data to support all the Value Management calculations and analyses and for putting in place the processes, organization and technical environment necessary to provide this data. The reliability of the data is crucial for the result of Value Management. Unreliable data will cause unreliable reports and risk calculations. The overall quality of the Data Management system can be proved by a solid test approach.
Responsibilities:
●Identify the day to day issues/gaps and resolve them.
●Understood the logical test cases (FAT) of the different building blocks for R3/R4/R5/R6 releases
●Involved in developing the Physical test cases from Logical test cases
●Generated .DAT files with test data set to start execution of PB1 phase
●Identified re-usable test cases for re-use in a next phase as well as for regression tests
●Writing SQL queries and executing them to ensure that data transformations are applied properly.
●Designing test cases and mapping the test cases to requirements.
●Executing the test cases and reporting the defects if there are any deviations from the expected behavior.
Contact this candidate