Resume

Sign in

ETL Testingg

Location:
Hyderabad, Telangana, India
Posted:
October 19, 2020

Contact this candidate

Resume:

KOTHA RADHIKA ETL Tester, CapGemini (December, ***5 - till date)

E-MAIL: adg3g0@r.postjobfree.com PHONE: + (91) - 916*******

Professional Experience:

Overall 4.8 years of experience as a Software Test Engineer involved in Manual Guidewire Packages (Policy Center, Billing center) and Data Migration with HP ALM as test management tool.

Have end to end to idea on Guidewire Policy Center version 8 and Guidewire billing center version 9.

Create, Assign and review the test scripts designed using SQL scripts

Worked in Agile Methodology.

Effective Test Case preparation and execution.

Worked and gained knowledge in all phases of software testing lifecycle which includes Requirement Analysis, Test Plan, Test Design, Test Execution, defect raising and defect closing.

Good exposure in SQL Scripts.

Experienced on working with QC- ALM for manual and Business Process Testing of Agile modeled Projects.

Defect tracking, verification, classification of issues based on the severity using HP ALM Quality Center.

Quickly understand the business issues and data challenges of client's organization and industry.

Quick learner and great ability to coach people and strong commitment to customer service.

Educational Details:

Completed Bachelor Engineering in Gates institute of technology in 2015

Certifications:

Completed ISTQB basic level certification.

Completed Oracle12c certification.

Technical Skills:

SQL, ETL Testing.

Relevant Project Experience:

Project: #1

Project Title

HAP

Client

CNA

Role

Team Member

Period

2016 Jun – 2017 Oct

Project Description

The Primary goal of Project is to improve the client underwriting profit with for these products aimed to improve the product’s top and bottom lines. Delivering these product updates to market quickly in alignment with Client “go-forward” platform is critical for profitable growth in the different line of Businesses. This includes the ability to support automated underwriting and referral rules that will provide efficiency and governance over the rating, pricing and policy issuance process.

Client Description

HAL2000 is HealthPro insurance application developed by CNA in 1999. This is a very high premium generating application. It contains the Medical Malpractice lines for HealthPro including Doctors, Hospitals, Miscellaneous Healthcare, Miscellaneous Facilities, and Advanced Medical Technologies.

HAL2000 supports New Business, Renewals, Endorsements, Cancel, Decline transactions. From HAL the policies are booked for Professional Liabilities (PL) and Global Liabilities (GL). It is used by Underwriters and WWO.

Role and Responsibilities:

Test Case Preparation

Creation of test scripts

Executing Manual Test cases (using HP-ALM Quality Center), classifying and logging defects, retesting the fixed defects in order to identify defects in the application. Had set up test data for execution.

Preparing and submitting daily status report to the Onsite Coordinator.

Logging defects and tracking them to closure.

Involved in preparing Regression Suite by identifying the high level Test cases that were executed at the end of every execution cycle.

Participating in onsite-offshore calls as required.

Project: #2

Project Title

PHLY

Client

Philadelphia Insurance company

Role

Team Member

Period

2017 Oct – 2018 Sep

Project Description

The project is designed to migrate the data from the legacy version (APPS,PATHS) to latest version (Guide wire Billing center).

Client Description

Philadelphia Insurance Companies (PHLY), PA, designs, markets, and underwrites property and casualty insurance products for niche markets, with value-added coverage’s and services. It mostly works on commercial package. This program is to migrate data from legacy system (PATHS, APPS) to Guide wire billing center. I have been working on Conversion module.

Role and Responsibilities:

Extracting the data from various source systems, and applying the business rules on it and delivering the data to guide wire billing center application on time without any data loss.

Creation of test scripts based on the requirements and check the data through database from different layers.

Delivering the migrated data on time and providing key insights to the high level team to take the better decisions based on Guide wire application.

Project: #3

Project Title

AMD(Activity Management Dashboard)

Client

TMNAS

Role

Team Member

Period

2018 Oct – 2019 Oct

Project Description

The Activity Management Dashboard (AMD) is a dashboard that will provide a both Summary and detailed view into all Marketing Rep Activities. This document captures requirements for the Marketing Rep version of the AMD.Data requirement includes the robust level of data captured by PATH, Which will be passed through the ETL and stored in a design data model specific for AMD needs.

Client Description

Philadelphia Insurance Companies (PHLY), PA, designs, markets, and underwrites property and casualty insurance products for niche markets, with value-added coverage’s and services. It mostly works on commercial package. This program is to migrate data from legacy system (PATHS, APPS) to Guide wire billing center. I have been working on Conversion module.

Role and Responsibilities:

Extracting the data from APPS and PATH’s source systems, and applying the business rules on it and delivering the data to Cogno’s reporting application.

Creation of test cases and test scripts based on the Cogno’s reporting requirements and check the data through databases to cognos application.

Project: #4

Project Title

HANOVER INSURANCE GROUP

Client

HANOVER

Role

Team Member

Period

2019 Nov – till to date

Project Description

The Hanover Insurance Group, Inc. is the holding company for several property and casualty insurance companies, which together constitute one of the largest insurance businesses in the United States. The company provides exceptional insurance solutions in a dynamic world. The Hanover distributes its products through a select group of independent agents and brokers. Together with its agents, The Hanover offers standard and specialized insurance protection for small and mid-sized businesses, as well as for homes, automobiles, and other personal items.

Roles and Responsibilities:

Create, Assign and review the test scripts designed using SQL scripts

Required execution timeslots were reserved in HP ALM well in advance as per plan

Review the defects logged in HP ALM and ensure they were assigned to concerned teams for fix.

Created and maintained tracking log about releases, issues, downtime of application on various environments.

Involved in diagnosing the root cause of the problems by interacting with IT support, Database teams.

Attended scrum meetings in order to provide status updates on the application to the Project Management team

Attend status calls every week and update status to offshore and onshore people.

DECLARATION:

I hereby declare that above stated information is true to the best of my knowledge.

(Radhika Kotha)



Contact this candidate