Qa Analyst Selenium, API and database testing, SQL, Postman

Neha Bahl

Visa Status-H*EAD

****************@*****.***

Mobile-+1-858-***-****

Pittsburgh, PA-15106

QA Analyst

Detail-oriented QA Analyst with 11 years of experience in developing and executing test plans and test cases to ensure high-quality software products. Proficient in various testing methodologies, agile processes, and bug tracking tools. Strong problem-solving skills and a keen eye for identifying and resolving software defects. Seeking to contribute to a dynamic team and continue growing as QA Professional.

Skill Set

Web Automation Skills- Selenium WebDriver, Maven, TestNG, JUnit, CICD(Jenkins),GitHub, Cucumber, and Python

API Automation Skills- Postman, Karate

Test management tools- Jira, Version One, RTC and RQM

Database Analyst/testing -SQL Server, Toad, Teradata, Informatica, ETL, SSIS, Python

Reporting Skills- Excel, SSRS, Power BI, XML,

Software Development methodologies- Waterfall, Agile, SCRUM, KANBAN

Certifications

Safe Agile

Safe DevOps

Project Experience

Client: US Bank (Remote, Pittsburgh, PA) (Oct 2022 -May 2024)

Role: QA Analyst

Responsibilities:

Review and analyze system specifications and flow for Legacy and come up with functional testing plan for the new system.

Developed BDD Framework using Java, Selenium, Cucumber, Maven, Junit.

Build and enhanced automated test framework Page Object Model concepts

Created reusable component, helper class, common libraries, common extended report

Maintained and updated Selenium WebDriver scripts; Design, develop and implement a scalable test automation framework and strategy using Selenium WebDriver.

Performed webservices/API automation using Karate and Postman.

Perform Accessibility testing using Jaws and Axe.

Used JIRA for test management.

Execute Python based framework scripts in Pycharm.

Lead Offshore team and help them manage the dynamic nature of management requirement being the POC for the current function being developed.

Client: Highmark Health Solutions (Pittsburgh, PA) June 2019-Sept 2022

Role: QA Analyst

Responsibilities:

Define Business Requirements - project initiation document, what the needed achievements will be, and the quality measures.

Involve in developing selenium automation framework using TestNG

Create and maintain automation test script in Feature File, write reusable component, helper class in JAVA.

Work closely with Application Managers and identify Test Scenarios for different Test Types.

Performed data validation testing writing SQL queries

Develop SQL stored procedure as part of the ETL process.

Execute the test scripts against Teradata source and validate the rules according to mapping documentation.

Involve with extraction routines to verify all the required data load into target systems.

Work in multiple source data extraction and data transition from existing production system to test environment.

Analyze and resolve the major roadblocks affecting daily script development targets

Providing test automation results to project managers/developers/manual testers.

Tracking changes and corresponding requirements across multiple programs and reviewing the Requirements Traceability Matrix.

Client: TRACFONE WIRELESS (Miami, FL) March 2019–May 2019

Role: QA Analyst

Responsibilities:

Execute and Maintain automation test script in Feature File.

Creating the Feature File and writing the customized step definition for application automation

Involving in giving daily and weekly status report to clients

Maintaining the regression test case suit based on the new functionality.

Reporting any defects / Observation on day-to-day basis

Reviewing and analyzing the change request deliverables and work products to determine the viability of the scope, level of effort, resources, schedule, budget, workflow, reporting, and impact to county business operations and on the existing M&O work plans.

Client: Samsung India (Gurgaon, India) Jan 2014 -Feb 2016

Role: Sr. Data Analyst

Responsibilities:

Perform analyses to measure performance & identify trends.

Development of operational reporting using SQL, and BI tools.

Responsible for time-to-time SLA, KPI definition/ redefinition and scope change meetings and subsequent documentation along with KPI evaluation.

Regulating & Controlling Information in all Service Centers across the country

Maintains the integrity of the MDM (master data model) by supporting business-driven rationalization of data elements and governing maintenance processes Reviewing the Test Reports and preparing Test Summary report.

Executing End to End testing covering all the functionality ensuring integrity of the application.

Client: Indus Towers (Gurgaon, India) Nov.2009-Jan.2014

Role: Data Analyst

Responsibilities:

Developed Functional requirements - describe what the system, process, or product/service must do in order to fulfill the business requirements.

Execute SQL queries to perform backend database testing and verify/modify user data.

Developing analytical methods for data collection, data variables, storage, analysis, statistics, and presentations.

Collaborate across technical teams and Business Analysts/Consultants (Indus or 3rd party) to procure and analyze data

Acquire and abstract primary or secondary data from existing and futuristic data sources Ensuring documentation using best practices, support processes and escalation protocols.

Performed data validation testing writing SQL queries

Proactively create and present quality analysis including dashboards and interpret trends and patterns

Focal point for making sound decisions related to data collection, data analysis, data security, methodologies, and designs.

Responsible for time-to-time SLA, KPI definition/ redefinition and scope change meetings and subsequent documentation along with KPI evaluation.

Education

Bachelor of Engineering in Electrical and Electronics (BE – EEE)

MDU Rohtak - 2009

Contact this candidate