Quality Assurance Life Cycle

Avinash Gogineni *.*********@*****.*** 404-***-****

PROFESSIONAL SUMMARY

15+ years of experience in QA testing of software systems in Web based, Client/Server, cloud based, Mobile App and mainframe applications using Manual and Automated testing tools.

Extensive experience and strong knowledge of Quality Assurance in Retail, ERP, Banking, Healthcare (Hub Services in Specialty Pharma & EDI Transactions) and E - commerce domains.

Extensive Experience of QA Methodology, SDLC, Project development life cycle and QA Processes.

Expertise in creating, Master Test Plan, Test Reports, Test Cases and Test Scripts for Manual testing based on the functional specifications.

Expertise and proficient in Software Testing Life Cycle (STLC) – Requirement Analysis, Test planning, Test design, Test data identification and Defect management.

Specialized in reviewing, System Requirements, Infrastructure Requirements, Workflow Diagrams and Architectural Diagrams. Documenting Master Test Plans.

Extensive experience in manual testing methodologies, including functional, regression, and user acceptance testing.

Expertise in Black-Box Testing, Functional, Automation, System, Integration, Regression, ETL Testing, MDM Testing, end-to-end testing, GUI, UAT, Database, Smoke/Sanity, Adhoc and Compatibility testing

Strong proficiency in using JIRA for test case management, defect tracking, and project management.

Proficient in writing SQL queries to perform data driven tests and involved in front-end and back-end testing.

Expertise in MDM Testing with the tools Profisee, Stibo Systems (STEP)

Experienced with Verification of Master Reference Data, Control Total Checking, Data Standardization and Cleansing, Data Transformation checking, Duplicate Record verification, Attribute correctness check

Experienced coordinating and working with offshore and onsite team (QA, Dev, PM, BA, SME)

Hands on experience in implementing Agile (Sprint/Scrum) and Waterfall methodology.

Experienced in creating test scripts and performing End to End Testing in Ecommerce and ERP Domains.

Experience in performing testing on cloud-based applications Sales Force and custom configurations in SFDC.

Experience in testing custom object fields, role-based page layouts, list views, detailed views, reports in Salesforce testing in Sales cloud and service clouds.

Experience in testing standard and custom workflow rules, validation rules in salesforce applications.

Experience and strong knowledge on Oracle applications functional modules PTP (Procure to Pay), QTC (Quote to Cash).

Good working experience in automation tools: Selenium Web Driver, QTP.

Experience identifying regression test scenarios and converting into Automation scripts for reusability.

Good experience in Web Services testing using SOAP UI, XML, & WSDL. Providing required input data to request XML & get the required data from response XML & use the response data from other request XML using SOAP UI.

Worked in DevOps, installing, configuring, and integrating Automation scripts on Continuous Integration tools (CI/CD) like Jenkins for nightly test suite execution.

Strong knowledge and experience in Test management tools JIRA, HP Application Life Cycle Management (ALM), Quality Center (QC)

Experience in ETL, EDW, Data Migration testing, Report Validations using Step application Stibo systems.

Expertise in export rule checking and data format validation, Database validation for import data and Role based testing for Product Master Reference Hub.

Project Management skills including estimating, scope management, time management, risk management, change management, issue/conflict resolution, communication management, quality management, testing plans, training plans, and team management.

Acted as Project Lead in complex projects (onsite – offshore model) and good Team player.

TECHNICAL SKILLS

Operating System

Windows NT/2000/2003/Windows7, XP, Unix

Development Methodology

Agile, Waterfall, V model

Languages

Java, PL/SQL, C

Database

Oracle, SQL server, DB2

MDM Tools

STIBO Systems STEP, Profisee

Automation

Selenium web driver, QTP

Web Service Tool/Language

SoapUI, Rest API, POSTMAN, Fiddler, XML, Json, Groovy

Project Management Tools

JIRA, ALM, QC, Jira Zephyr, Version One, Remedy, Pivotal Tracker

Reporting Tools

Splunk

Mobile App Testing Tool

Emulator

File Transfer API

FTP Tools (Win SCP and File Zilla), Beyond compare

Cloud Applications

Salesforce

Framework

Cucumber, Page Object Framework

Version Control tools

GitHub, SVN

ERP Modules

PTP, OTC, ATC

Mobile Test OS /Other

Aandroid, iOS.

PROFESSIONAL EXPERIENCE

Sr QA analyst July 2023 – till date

Cleaveland Clinic Beachwood, Cleaveland

Responsibilities:

Responsible for creating and executing functional, regression and E2E test case design and execution.

Designed and executed functional and regression tests for healthcare management APIs.

Developed comprehensive test plans and test cases for API endpoints based on functional and technical specifications.

Utilized Postman for manual testing to validate API functionality, responses, and error handling.

Responsible for reviewing test cases prepared by QA team based on user stories.

Create and manage test cases within JIRA, ensuring that each test case is clearly documented, including steps, expected results, and associated requirements.

Validated API responses, including status codes, headers, and payloads, against expected results.

Collaborated with development teams to identify and resolve defects, ensuring seamless API functionality

Create user guides or documentation within JIRA to assist team members in understanding test management processes.

Conduct training sessions or workshops to familiarize the team with best practices for using JIRA in test management.

Providing LOE for the user stories identified for the sprints

Prepared Test scenarios to test the web services using Postman, Soap UI tools for rest service testing.

Executing tests on dev, test, and production environments.

Conducted defect triage meetings with development and BA for fixes and validate back.

Identifying and automating the regression test scenarios using selenium webdriver.

Sr. Software Quality Control Engineer Jan 2021 – May2023

North Carolina Administration of Courts (State Project), Raleigh, NC

Responsibilities:

Analysis of all functional and business requirements from the functional design specification and product backlog sheets.

Responsible for Responsible in reviewing configuration in TEST and PROD environments

Responsible for test cases preparation and peer review with QA team based on PDDs.

Worked in Agile/Scrum model by participating in Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective.

Involved with setup Testing process using JIRA tool to manage Requirements Traceability, Test case Design, Test execution status, Defect tracking, reporting and generate dashboards.

Creating the defects on the AOC SharePoint and integrate them with Tyler’s JIRA boards, and tracking the fixes and other changes on a daily basis.

Provided training to team members on JIRA test management processes and best practices. Create and maintain documentation to support ongoing knowledge transfer.

Regularly review and analyze testing processes within JIRA for areas of improvement.

Encourage team members to provide feedback and suggestions for enhancing the efficiency of test management in JIRA.

Tested security and sharing rules at different levels of the organization profiles in sales force applications.

Verified dash boards, validation rules and workflow alerts and action based on client and business requirements.

Executing tests on dev, test, and production environments by performing Functional, E2E integration testing and UI testing.

Conducted defect triage meetings with development and BA for fixes and validate back.

Performing E2E integration testing and UI testing.

Responsible for weekly status updates on progress of the testing efforts and open issues.

Conducting Sanity tests in UAT and Production.

Identifying and automating the regression test scenarios. Develop and execute automation scrips using Selenium web driver.

Tests executed from use cases, test cases, test plans and testing matrix. Testing performed via manual and automated testing as well as web service testing using SoapUI, Postman and Selenium.

Training Judicial officers, Police officers, Magistrates, and court clerks on the functionalities and assisting them in reporting and resolving the data discrepancies and tested data security, user-roles access testing, and accessibility testing.

QA Lead Mar 2018 – Jan 2021

CareMetx LLC., Bethesda, MD

Responsibilities:

Lead team in offshore and onsite which is responsible for functional, integration, regression, and sanity testing.

Responsible in reviewing test cases prepared by QA team based on user stories.

Worked in Agile/Scrum model by participating in Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective.

Responsible for creating and executing functional, regression and E2E test case design and execution.

Utilized JIRA for tracking and managing defects throughout the development lifecycle.

Create and manage test cases within JIRA, ensuring that each test case is clearly documented, including steps, expected results, and associated requirements.

Execute and verify API changes using PostMan. Involved in validating the API with PostMan tool and create the Continuous Integration mechanism.

Create user guides or documentation within JIRA to assist team members in understanding test management processes.

Conduct training sessions or workshops to familiarize the team with best practices for using JIRA in test management.

Tested integrated external applications with salesforce.com.

Configured by creating users and user profiles and created roles in Salesforce cloud applications.

Tested multiple objects such as Leads, Opportunities, Accounts and campaigns in sales cloud platform in salesforce applications.

Tested workflow rules and custom page layout based on profile in Sales and service clouds in SFDC applications.

Created reports and report folders to help managers better utilize salesforce as sales tool.

Configured and tested reports for different user profiles for specific salesforce applications.

Tested ETL maps for correctness to move data from source to target.

Validated the source database, target database and transformations.

Responsible in handling production deployments and prepare Sanity Test Plan to perform after production deployment.

Worked closely with Scrum Master/Project Manager/Director/Stake Holders/BAs about the status of testing efforts, state of the system and provide input on system acceptance on daily basis.

Report project status, metrics, and process innovation to Test Manager/QA Director on weekly basis as part of Weekly QA Core meeting.

Analysis of all functional and business requirements from the functional design specification and product backlog sheets

Responsible for Verification of Master Reference Data, Control Total Checking, Data Standardization and Cleansing, Data Transformation checking, Duplicate Record verification, Attribute correctness check

Involved in testing match rules for de-duplication in Profisee (MDM) tool.

Providing LOE for the user stories identified for the sprints

Prepared Test scenarios to test the web services using Postman, Soap UI tools for rest service testing.

Executing tests on dev, test, and production environments.

Conducted defect triage meetings with development and BA for fixes and validate back.

Identifying and automating the regression test scenarios using selenium webdriver.

Responsible for weekly status updates on progress of the testing efforts and open issues.

Conducting Sanity tests in UAT and Production.

Involved in DevOps Migration/automation processes for Build and Deploy systems.

Sr QA analyst April 2017-Feb 2018

Genuine Parts Company Atlanta, GA

Responsibilities:

Analysis of all functional and business requirements from the functional design specification and product backlog sheets

Performed functional testing using the JIRA for Test Case Creation and Organization, Test Plan Development, Test Execution Management, Defect Tracking and Management.

Tested the source, Target databases and Transformations.

Active participation in Sprint Planning, Review and Retro.

Providing LOE for the user stories identified for the sprints.

Preparation of Test Plan and Test Strategy document

Perform ambiguity reviews on requirements and design documents.

Prepared Test scenarios to test the web services using Postman, Soap UI tools.

Executed sessions and batches in Informatica and tracked the log file for failed sessions

Creating Jobs to run daily, weekly, and monthly basis to process ETL Jobs using Informatica.

Executing tests on dev, test, UAT and production environments.

Conducted defect triage meetings with development and BA for fixes and validate back.

Coordinating with the offshore and onsite team and update project plan and status reports

Perform backend validation in SQL server using SQL quires.

Executed SQL statements manually to execute record counts on each table loaded into system and compared with source table

Maintaining the team in terms of status reporting, resource management and reporting.

Responsible for weekly status updates on progress of the testing efforts and open issues.

Conducting Sanity tests in UAT and Production.

Preparing User documentation for the UAT use cases.

Participating in Code reviews.

Sr. QA Analyst and QA Lead Sep 2013 - Mar 2017

The Home Depot (THD), Inc Atlanta, GA.

List of Major Projects in THD:

1.Worked in COMPASS - This project intends to retire the JDA platform and eliminate the third-party hosting arrangement with JDA for STH, STS orders and implanting in Sterling platform.

2.Worked in Project7 Blinds - The objective of Project 7 Phase III is to provide an integrated shopping experience between Homedepot.com/Blinds.com.

3.Worked in One Page Checkout - project provides a streamlined, single-view checkout experience for the customer across desktop, tablet, and mobile channels.

4.Worked in TDM (Test Data Management) - To develop and maintain a Data Setup and Data Maintenance Strategy across all LLC for all the Home Depot Online Projects. Developing Test data Tool to fetch the golden data with different requirement combinations.

Responsibilities:

Analyzed Business Requirements and Functional Specifications and developed Test Plan detailed Test Scenarios, Test Strategies and Test cases.

Creating Master Test Plan document and get it signed off from Business teams.

Participated in Agile grooming sessions, scrum meetings, retrospective/planning sprint reviews by identifying tasks and estimating story points for each task.

Created, Updated and Reviewed of Test cases and Test Scenarios as per the business requirement and executed them in ALM tool.

Maintained and coordinating the offshore and onsite team.

Experienced at testing ETL's and flat file data transfers without relying on a GUI layer.

Preparation and execution of E2E, Integration Test scenarios.

Preparing and Maintain Traceability Matrix document.

Maintain/develop the automation scripts as per new stories and changes.

Automate the test cases using Selenium Web Driver.

Participated in daily, weekly meetings and technical reviews. Prepared reports showing the testing efforts

Provided estimations to automation and carried out automation testing of web services using SOAP UI, POSTMAN.

Integrated Selenium automation with continuous integration i.e., Jenkins for continuous test runs.

Monitored Jenkins jobs for test runs and raised defects for legitimate test failure

Interacted with development teams for defect fixes. Used JIRA, ALM, PVT as defect tracking tool.

Performed Integration testing to test the functionality of the modules

Created test scripts for API testing automating functional tests, regression, debugging

Fiddler tool to help Web services Rest methods integration.

WinSCP to transfer files to remote server and file management

Performed Back-end testing using SQL queries to access the main database.

Data creation and data setup using writing SQL and running delta feed jobs for the data requests which received from different teams.

Communicate risk to QA Leads and QA Manager as needed.

Responsible for preparing the Test summary and Execution status reports on daily and week basis.

Preparation of various kinds of process artifacts like Requirement Traceability Matrix, Code Review Reports, Test reports, KT documents.

QA Analyst Sept 2011 – Aug 2013

Qualcomm Inc. City, Bangalore.

Responsibilities:

Understanding the Business requirements and analysis of Business Requirement Documents (BRD), Functional and Technical Specification (FS/TS).

Preparation, execution of Test Cases and Report the defects in QC.

Performed testing on custom objects, Page layouts, custom tabs, components and triggers workflow rules on salesforce applications different sandboxes.

Involved on salesforce custom configuration by creating custom profiles, page layouts, Roles.

Created Email templates and rested in sales and service clouds in SFDC application.

Verified visual force pages, Dashboards, validation rules, roles, users and permissions.

Created and tested list view and detail view pages in SFDC as per user roles.

Developed and maintained the Traceability matrix between requirements and test cases.

Involved in the Development of Plan and Test Cases for Integration, Functional, System and Regression Testing.

Perform cross browser functionality Testing.

Performed Sanity, Functional, regression, Integration and E2E testing.

Responsible for data set up and Test environment.

Performed Back-end testing by writing SQL Statements.

Scheduling batch test, log and track defects using HP Quality Centre. Executed test cases before and after bug fixes for each build for User acceptance testing.

Actively participated in Conducting Peer reviews team meetings and walkthroughs.

Executed the test scripts on different releases and validated the actual results against the expected results.

Involved in UAT and executing sanity test in production server and production support during deployments.

Software QA Engineer Feb 2008 to Sept 2011

Motorola INC, Motorola Mobility, USA Bangalore.

List of Major Projects in Motorola Mobility:

1.Worked in MD - ecommerce Platform Replacement

2.Worked in MD NA ERP_L3 Bundle Releases

3.Worked in Global Logistics

4.Worked in Critical Patch Updates (CPU)

5.Worked in Revenue Cycle Project

Responsibilities:

Understanding the Functional Requirements and Scope of the Application

Responsible for delivering test design, test execution and test reporting of the application.

Developed QTP automated test scripts for ease of execution.

Enhanced modified test scripts as and when required.

Data creation of different interfaces using automation scripts.

Execution of Scripts as and when required. Analyzing the results and reporting defects.

Involved in system test cases and regression test cases preparation and execution.

Reporting daily execution status to all the project stake holders.

Conducting defect triage meeting and working with development team to close the defects.

Performing Back-end testing using SQL queries.

Prepared ERP oracle apps functional test suits for PTP (Procure to Pay), QTC (Quote to Cash) Modules using QTP and Manual.

Executing automated regression test suits on weekly basis and report the issues.

Preparing Test summary reports on daily/weekly basis.

Creating and Maintaining the Traceability Matrix

Conducting and participating in Peer reviews for test scenarios and test results.

Software Engineer Oct 2006 to Nov 2007

Bank of America Bangalore.

Responsibilities:

Participated in Requirement Analysis, Use-Case Analysis with Business Analysts, project Architects, Leads and developers

Developed, execution and maintenance of test cases based on functional specifications. Ensure that all the test cases are updated in the Quality Center along with test plan.

Perform the compatibility testing using different browsers. Perform IVR call testing.

Executing automated regression test suite in QTP.

Identifying regression test cases and maintain and updating for each release.

Coordinating with automation teams and helping them to understand the functionality to automate the regression test suites.

Participating in daily status meeting and update the testing status and defects status.

Participating in code review and test case review meetings.

EDUCATION QUALIFICATION

Pursued Master of Science in Computer Science (2003), Bharathidasan University, Tiruchirappalli, Tamil Nadu, India.

Contact this candidate