CAREER SUMMARY

• Having *.* years of professional IT experience in ETL testing/Database testing, BI Testing, UI Testing worked on various domains – Insurance, Retail.

• Expertise in writing test cases and testing the test scenarios in tools HP-ALM Test Management, Azure Databricks, JIRA.

• Working experience on writing complex SQL Queries.

• Strong working knowledge on End-to-End Defect life Cycle management using HP-ALM.

• Good experience in OLTP & OLAP.

• Extensive work experience in Initial and Incremental Load Testing as Part of System Integration Testing.

• Good knowledge on STLC and SDLC.

• Good working knowledge of writing Database queries on SQL Server, Oracle and Teradata Databases.

• Good experience on Star and Snowflake Schemas.

• Strong knowledge of Slowly Changing Dimensions (SCD-2) Testing.

• Good Knowledge of UNIX commands.

• Good knowledge on Relational Database Management System.

TECHNICAL SKILLS

Development Skills : Informatica,, Snowflake

Test Management Tools: HP ALM, JIRA, TFS

Database Tools : SQL Server Management Studio, Oracle SQL Developer, Teradata SQL Assistant, Unix(Putty), PL/SQL Developer, SAP HANA

Automation Tools : Azure Databricks(Python)

Languages : SQL, Basic UNIX Commands

ACADEMIC QUALIFICATION

• B. Tech from JNTUK University, 2016 – Kakinada

WORK EXPERIENCE

• Working as an Senior Software Engineer for Value Momentum from August 2022 to till date

• Worked as an ETL Tester for Wipro from Feb 2020 to July 2022

• Worked as an ETL Tester for Florida Software Solutions from Jun 2017 to Jan 2020

PROJECT SUMMARY

Project Name Preferred Mutual Insurance Company (PMIC)

Tools SSIS, Power BI, TFS

Duration Sept 2022 to till date

Role Test Engineer

Team Size 2

Description Preferred Mutual, originally founded as the Preferred Mutual Fire Insurance Company of Chenango County, was first established in 1896.The insurance company is headquartered in New Berlin, NY.

The insurance company offers a large catalogue of coverage options for individuals and

businesses, including auto insurance, homeowner’s insurance, and more.

Responsibilities Preparation of Final Test Query referring to mapping document and BA query.

Extracting data from files, tables and comparing with Dev data

Preparation of Test Cases based on USER Story and loading to the TFS

Raising the Bugs while testing

Testing application in positive and negative way to make sure it is working as expected.

Verifying performance as per business requirements.

Updating daily task’s in TFS

Performing data validations

Preparation of Test Data to perform Historical Load Testing and Incremental Load Testing

Project Name Prime Therapeutics

Tools SAPHANA, SNOWFLAKE DATABASE, POWER BI, JIRA

Duration Dec 2020 to July 2022

Role Test Engineer

Team Size 3

Description PBMs managed pharmacy benefits for 266 million Americans. In 2017, the largest PBMs had higher revenue than the largest pharmaceutical manufacturers, indicating their increasingly large role in healthcare in the United States. However, in 2016 there were fewer than 30 major PBM companies in this category in the US, and three major PBMs (Express Scripts, CVS Health, and Opium of UnitedHealth Group) comprise 78% of the market and cover 180 million enrollees

Responsibilities Preparation of Test scenarios to cover entire SAP Tables and Snowflake Tables.

Writing the required SQL Queries to verify the data from SAP Tables to Reports.

Verifying Power Bi Reports as per business requirements

Experience in Regression testing with frequent code changes.

Verifying Audit Fields to test SCD type 2 tables.

Raising the defects while performing data validations from SAP tables to report Testing.

Prepared Test case Document and handled offshore as Lead.

Project Name Stellantis N.V

Tools INFORMATICA WINSCP JIRA, FLAT FILES

Duration Feb 2019 to Nov 2020

Role Test Engineer

Time Size 6

Description The principal activity of Stellantis is the design, development, manufacture and sale of automobiles bearing its 16 brands of Abarth, Alfa Romeo, Chrysler, Citroën, Dodge, DS, Fiat, Fiat Professional, Jeep, Lancia, Maserati, Mopar, Opel, Peugeot, Ram and Vauxhall. At the time of the merger, Stellantis had approximately 300,000 employees, a presence in more than 130 countries with manufacturing facilities in 30 countries

Responsibilities Understanding the Business Requirements which exists in Mapping Document.

Writing the required SQL Queries to verify the Source and Target Data.

Preparation of Test Data to Perform Incremental load Testing.

Experience in Regression testing, Sanity Testing, Boundary value Testing.

Verifying Audit Fields as part of Incremental Load Testing.

Involved in Defect Triage Meetings and prioritizing the Defects.

Attending the calls with Dev team to discuss about the Defects that found during the SIT and Re-Testing them once they got fixed.

Project Name Philips

Tools UI Application

Duration Jun 2017 to Jan 2019

Role Test Engineer

Team Size 3

Description Commonly shortened to Philips, is a Dutch multinational conglomerate corporation that was founded in Eindhoven in 1891. Since 1997, it has been mostly headquartered in Amsterdam, though the Benelux headquarters is still in Eindhoven. Philips was formerly one of the largest electronics companies in the world, but is currently focused on the area of health technology, having divested its other divisions

Responsibilities Preparation of Test scenarios to cover entire application.

Testing application in positive and negative way to make sure it was working as expected.

Verifying performance as per business requirements.

Experience in Regression testing with frequent code changes.

Raising the defects while testing.

Prepared Test case Document and handled offshore as Lead.

Contact this candidate