Post Job Free

Resume

Sign in

Test Engineer Sql Server

Location:
McKinney, TX
Posted:
September 09, 2023

Contact this candidate

Resume:

Sekhar Anamadevara

QA Test Engineer

adzk1q@r.postjobfree.com

+1-309-***-****

Professional Summary:

Around 10 years of professional IT work experience in Software Testing / Quality Assurance / Automation and Manual Testing in Web and Client-Server based applications.

Experience in Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) in Agile and Waterfall environments to ensure Quality Control.

Proficient on Automation tools like Selenium WebDriver, BDD Cucumber, and Rest Assured.

Good experience in creating automation framework along with developing, executing and maintaining automation testing script with Selenium WebDriver.

Work experience in integrating Automation scripts (Selenium WebDriver) on Continuous Integration tools Jenkins for nightly batch run of the Script.

Extensive work experience on Microservices, Java, API and Angular.

Extensive experience in designing on Data Driven and Hybrid framework.

Experience in designing Test Cases, Test Scenarios, Test Scripts and Test reports of manual and automated tests. Also using Zephyr tool for writing test cases and creating test metrics/reports

Experience include Functional testing, User Acceptance Testing, Integration testing, System testing, Performance testing, Sanity testing, Compatibility testing & Security testing of client/server and Web base Applications.

Good experience in Web Services Testing using Postman and REST Assured.

Good experience in Defect Life Cycle Management tools like ALM, JIRA, and Rally.

Experience working with Project Managers, developers, business analysts, and end users in defect resolution.

Experience in performing database testing and working with SQL queries and database like Oracle, MySQL.

Working experience in Waterfall (Software Development Life Cycle -SDLC), and Agile Project Environment.

Good experience in API testing both SOAP and REST services using SOAP UI, Postman, Rest Assured.

Good experience in working with CICD tools.

Working on POS / Progression / Regression / Order flows.

Worked to automate the test cases and integrate them with scheduled auto deployment pipeline to increase test coverage and leverage nightly builds as part of DevOps.

Hands on experience in using build and project management tools like MAVEN and Configuration management tool GIT.

Excellent interpersonal skills, proven team player with an analytical bent to problem solving and delivering under high stress environment.

Technical Skills:

Testing technologies/tools

Selenium WebDriver, Cucumber, TestNG, Apache POI, Jenkins, JUnit, Soap UI, Postman

Testing Methodologies

Agile, Waterfall Model

Defect Tracking Tools

Quality Center/ALM, Zephyr, JIRA, Rally

Databases

Oracle, MS SQL Server and MySQL, Mango DB

Languages

Java, SQL, JavaScript, XML, HTML

Build and Logging Tools

Maven, Log4j

Source Repository

GitHub, Bit Bucket, SVN

API Testing Tools

Soap UI, Postman, JMeter

IDE Tools

Eclipse

OS

Windows & Linux.

Education:

B.com from Nagarjuna University, India - 2002

Masters in HRM from Andhra University, India - 2004

Work Experience:

Role

Client

Location

From

To

QA Engineer

Verizon

Dallas, TX

Aug 2021

Till date

QA Engineer

T-Mobile

Bothell, WA

Feb 2020

July 2021

Quality Engineer

GE

Atlanta, GA

Sep 2018

Jan 2020

Test Engineer

AllState

Phoenix, AZ

Dec 2016

Aug 2018

Test Engineer

Hiscox

Atlanta, GA

Sep 2015

Nov 2016

Tester

Standalone IT Solutions

Hyderabad, TS

May 2013

Sep 2014

Project 1

QA Engineer

Verizon, Dallas, TX Aug 2021 – Till Date

Responsibilities:

Interacted with the Business Clients, Product Owners, Developers and QA Manager for clear exposure to trickle down the technical/functional User Requirements & Change Requests to Test Plans and Test Scenarios.

Identified test cases to automate. Automate those test cases using Selenium WebDriver.

Performing Functional Testing, Regression Testing, System Integration testing, (UAT) User Acceptance Testing, API testing, Performance testing and E2E Testing, Canary / PROD testing.

Utilized JIRA/ Zephyr to track, report and manage defects for Test management and execution of test cases

Working as POS testing team for full cycle Order management.

Working on Q-Test for test cases execution for both Progression and Regression testing.

Using Jenkins for API Testing with the help of e2e ID or cart ID.

Traceability document update and Test management tool Zephyr for logging defects in JIRA.

Coordinate with DEV team for Lower ENV or Prod ENV defects and close them with in the time line.

Identified the Test Scenarios based on Functional Specifications and Business Requirements.

Performed API, web services testing with Postman and Rest Assured.

Conducted workflow, process diagram and gap analysis to derive requirements for existing systems enhancements.

Supporting every release like ER / AMR in production with live data.

Responsible for taking the daily status updates from offshore team and sharing with clients.

Environment: Selenium Web Driver, Cucumber, GIT, Zephyr, JIRA, Confluence, Jenkins, SQL Server, Mango DB, all portals which are related to POS orders.

Project 2

QA Engineer

T-Mobile, Bothell, WA Feb 2020 – July 2021

Responsibilities:

Involved in creation of Hybrid automation framework using Selenium, Java. Extensively used Page Object Model for the objects and used external file for data handling and easy maintenance from developer perspectives.

Integrated with Jenkins, Sauce labs. Testing Microservices.

Developed BDD test using cucumber by writing behavior and step definition.

Created and enhanced numerous test scripts to handle changes in the objects, in the tested application’s GUI and in the testing, environment using Selenium.

Responsible in executing automation test scripts on different browsers and checked for compatibility.

Involved in Peer-to-peer reviews and sign off.

Tested the application in highly dynamic environment with sprint team using Agile methodology.

Involved in end-to-end testing of the application for frontend Angular.

Identified the Test Scenarios based on Functional Specifications and Business Requirements.

Performed API, web services testing with Postman and Rest Assured.

Conducted workflow, process diagram and gap analysis to derive requirements for existing systems enhancements.

Responsible for keeping up with the test schedule and interacting with software engineers to ensure clear communications on requirements and defect reports.

Responsible for taking the daily status updates from offshore team and sharing with clients.

Environment: Selenium Web Driver, Java, Cucumber, GIT, Confluence, Jenkins, SQL Server, Mango DB

Project 3

Quality Engineer

GE, Atlanta, GA. Sep 2018 – Jan 2020

Responsibilities:

Reviewed business requirement and software specification requirements to achieve better understanding of product.

Developed Automation and Manual Test Strategies, Test Plans, Test Scenarios & defining Test Cases in java.

Involved in creation of automation framework in Selenium WebDriver using Data Driven and Page Object Driven Approach.

Developed BDD test using cucumber by writing behavior and step definition.

Developed and maintained automated regression test cases in Selenium WebDriver using Java programming language, Angular as UI and TestNG Framework.

Used Eclipse IDE to develop and debug the code.

Used Maven for generating source code, compiling code, and packaging code to jar.

Used Jenkins for continuous integration and doing API testing.

Integrated automated test cases to Sauce labs to run script on cloud based and perform Cross Browser Testing.

Track code on daily basis using Git.

Attended daily Scrum Meeting, Sprint Demo and Sprint Retrospective.

Prepared Test Cases with the complete description of requirement, upload Test Cases & reported results and bugs in JIRA.

Generated Test data and Data Request document for various types of testing for valid data, Invalid data testing.

Reviewed and interpreted systems documentation and business requirement gathering.

Provided support during production release.

Environment: Selenium Web Driver, Java, Cucumber, AWS, GIT, Jenkins, Sauce labs, SQL Server

Project 4

Test Engineer

All State Phoenix, AZ Dec 2016– Aug 2018

Responsibilities:

Involved in analyzing requirements documents.

Developed test strategy, test plan, test cases and test scenarios based on requirements Document.

Developed Test Strategy and Test Plan to ensure that test cases reflect user needs for the functional Performance, Usability and Security requirements.

Identified program variance from functional requirements and recommended modifications for standardization and increased usability.

Prepared manual test cases for service appointment creation, modification and deletion. Generated test scripts, and performed functionality testing.

Involved in performing extensive back-end testing to make sure data is properly reflected on the web Application.

Executed the test cases manually and automation as necessary and worked on XML.

Used Quality Center as a defect management tool and API end point testing.

Performed Manual Testing and regression testing activities for new releases as an end-to-end testing on Different platforms like windows with different web browsers.

Responsible for documenting errors, their resolution, as well as performing extensive Regression Testing.

Maintained defect tracking in Excel spreadsheet and prepared weekly reporting for the management.

Involved in weekly walk through and inspection meetings to verify the status of testing and to discuss defect and like scenarios.

Environment: Manual Testing, HTML, MSOffice, Quality Center, SQL Server, Windows.

Project 5

Test Engineer

Hiscox, Atlanta, GA Sep 2015– Nov 2016

Responsibilities:

Involved in analyzing requirements documents.

Developed test strategy, test plan, test cases and test scenarios based on requirements Document.

Performed Manual Testing and regression testing activities for new releases as an end-to-end testing on Different platforms like windows with different web browsers.

Responsible for documenting errors, their resolution, as well as performing extensive Regression Testing.

Maintained defect tracking in Excel spreadsheet and prepared weekly reporting for the management.

Involved in weekly walk through and inspection meetings to verify the status of testing and to discuss defect and like scenarios. Identified program variance from functional requirements and recommended modifications for standardization and increased usability.

Prepared manual test cases for service appointment creation, modification and deletion. Generated test scripts, and performed functionality testing.

Involved in performing extensive back-end testing to make sure data is properly reflected on the web Application.

Executed the test cases manually and automation as necessary and worked on XML.

Environment: MSOffice, Quality Center, SQL Server, Web services, Java script, SQL, Windows.

Project 6

Tester

Standalone IT Solution, Hyderabad - Telangana May 2013– Sep 2014

Responsibilities:

Prepared and Executed Test Cases for Functional and Integration testing.

Created Traceability matrix to keep track of changes in requirement to that of the testing efforts.

Identified high-level requirements for documenting detailed business requirements

Maintained the Test Matrix and Traceability Matrix.

Tested applications and documented results and bugs including documentation of information useful in the debugging process

Strong POS Sales (T-log) Knowledge and integration with Payment processing

Involved in preparing Test Plan and Test Cases based on business requirements.

Created, Reviewed and updated Test Scenarios, Test Cases and Test Data.

Running queries against databases to verify the correctness of XML response

Document request/response XML's test procedures and functional/technical findings from the test run.

Defects Reporting and Web Services Test Results Reporting

Generated test cases in spread sheet and upload them into Quality Center.

Environment: Quick Test Pro, QTP, Quality Centre, PL/SQL, XML, HTML, Web logic, Web services, Java script



Contact this candidate