Sumit Singh Shekhawat

Senior QA Software Engineer

Minneapolis, MN 651-***-**** adzthj@r.postjobfree.com

https://www.linkedin.com/in/sumit-shekhawat-8b339623a/

PROFESSIONAL SUMMARY:

●Over 5 years of Quality Assurance and Software Testing experience with Client-Server applications, Web based applications, and Enterprise applications.

●Strong in developing and executing Test Plans, Test Cases and Test Scenarios for automated testing.

●Proficiency in Test Analysis, Bug Detection, Defect Isolation and Report Generation

●Ability to work with Business Analysts, Developers, Project Managers, and other Team Members in complex testing projects and in the overall enhancement of software product quality.

●Knowledge and experience of Selenium WebDriver using JAVA for developing automation scripts in Eclipse.

●Experience with Agile development methodology.

●Good experience with automated testing tools like Selenium, TestNg, Maven and Jenkins.

●Experience in various databases MS SQL Server.

●Worked on all phases of Software Development Life Cycle using Agile/Scrum, Waterfall methodologies.

●Experience with Cross-Browser and compatibility testing to test Web Application using Selenium WebDriver and TestNG, Nightwatch.js for E2E, running parallel testing for regression and functional Testing.

●Experience in backend testing by preparing and executing SQL Queries.

●Configured Bamboo to use Maven executable.

●Good Knowledge on using Maven's central repository to manage external JARs and other dependencies.

●Experienced in using GitHub as a source repository system to share code within the office as well as with the team overseas.

●Executed Automation test scripts on different browsers like Firefox, IE, Chrome & Safari.

●Experience on operating systems like Windows, Linux and Mac.

●Excellent knowledge in writing unique CSS and Xpath locators using source code of the page to identify each unique element.

●Proficient in creating automation Framework from scratch and configuring various other peripheral tools to perform tests.

●Ability to Perform API Manual testing using Postman.

●Hands on design experience on Behavior Driven API Testing Framework using Cucumber.

●Working experience with defect tracking tools like Jira, and Quality Center (ALM).

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

●Strong attention to detail ensuring issues are logged and resolved prior to launch.

●Experienced in estimation of test effort and coordinate test schedule with overall project schedule.

●Utilized Jenkins, Git, Bitbucket and Eclipse for deployment on test servers and to move towards CI/CD.

●Hands-on experience with API testing framework karate.

●Write BDD (Behavior Driven Development) tests using Cucumber and JavaScript.

●Develop Node based Automation scripts using JavaScript for UI Automation.

●Experienced in creating Automated Web services testing processes using SoapUI NG Pro tool and Karate DSL framework.

●Supervisory experience with both in - house and offshore teams in the Release and QA automation functions.

●Knowledge on working with Data Warehouse, Data Lake, Data Factory and Bigdata.

●Hands-on experience on Azure Devops & Microsoft Azure.

●Expertise in ETL Testing, BI Testing, Database Testing and Report testing.

●Experience in all phases of SDLC like Requirement Analysis, Implementation and Maintenance, and extensive experience with Agile and SCRUM.

●Worked on IDE tools like JSP, IntelliJ, Web Storm, Notepad++, Sublime Text and Eclipse.

●Experienced in working on DevOps /Agile operations process and tools area (Code review, unit test automation, Build & Release automation Environment, Incident and Change Management) including various tools.

●Performed Cross Browser Testing Using Sauce LABS Enterprise version and Automated that using Jenkins.

SKILLS MATRIX:

Testing Tools

Selenium WebDriver/RC/IDE/GRID, TestNG, HP Quality Center/ALM, HP UFT, HP(QTP), ETL, Cucumber, SOAP UI, Page Object Model, Page Factory, Groovy, Karate DSL,

SDLC Methodologies

Waterfall & Agile

Build Tools

Ant, Maven, Apache POI

Continuous Integration Tool

Jenkins, GitHub

Bug Tracking Tools

JIRA, HP Quality Center/ALM, Bugzilla, Rally

Programming Languages

Java, JavaScript

Testing Framework

TestNG

Databases

RDBMS, MySQL, Oracle SQL Server

Browsers

Chrome, Firefox, Opera, IE, Safari

Packages

MS Office Suite, MS project

Java Project Management

Maven

Continuous Integration Framework

Jenkins

Page Object Model

POM Design Pattern

Mobile Testing

Appium

Cloud Technologies:

Microsoft Azure

WORK EXPERIENCE:

PNC Bank, Pittsburgh

January2023-Present

Sr. Automation Tester

The PNC Financial Services Group, Inc. (stylized as PNC) is an American bank holding company and financial services corporation based in Pittsburgh, Pennsylvania. The project involved regulating quality-affirmation and testing groups on frameworks advancement ventures. Performed system, execution, load, unit, backslide, stress and data interface testing. Provided the customer engineer groups point by point details regarding quality measurements, distinguished bugs/defects, and suggested fixes. Tested the ACP application flow and involved in Identity Proofing crew which includes the testing of the API flow and third-party vendor collaboration.

Responsibility:

●Actively participated in PI and sprint planning and end-user review meetings to refine the criteria and identify priorities and scenarios for ACP and PAY application.

●Effectively engaged in stand-up meetings every day for agile and scrums and engaged in Iteration preparation and retrospective meetings.

●Worked with Business Project Managers (BPM) and Product Delivery Managers (PDM) in identifying targeted projects for each release.

●Worked together with PDM and BPM analyzers to survey the Disclosure Mapping Plan and Test contents for comparing all checking and saving account packages.

●Recorded software defects on the customer information page and Login functionality page using the bug tracking system and documented defects to software developers affecting program features, performance, online screen and content.

●Serve on committee to develop new documents on the requirements for technical specifications.

●Used HP Quality Center to review, execute, and track scripts progress for each project.

●Developed Manual Test Cases, verified Actual results with expected results for the application.

●Performed End-to-End testing manually.

●Performed Defect Tracking and Management in ClearQuest and ALM.

●Participated in daily Scrum meetings and defect review meetings.

●Developed test cases in Excel sheets and imported it into the Quality Centre.

●Manually directed User Interface, Functional, Integration, Regression testing, multi-program testing and associated with engineers to determine the issues on application Status page.

●Working on the Karate framework to automate the API testing.

●Working on the BDD cucumber framework for all the UI test cases.

●Ran regression scripts to ensure that the existing features are working fine using cucumber for ACP and PAY application

●Performed API testing with the help of Postman and automating the same test cases with Karate framework and setting up the base URL and end point in karate config file and running the regression test suites.

Environment: HP ALM, MS office, Java, JIRA, APPIUM, karate, Postman, JMeter

Publicis Sapient-Houston, TX

May2021-December2022

Sr. Automation Tester

PROJECT2

Publicis Sapient is an American digital consulting company. The Project, Novartis Pharma involved working with Business Validation and QA team. There are plenty of project is involved and I got the ownership of three Project Phoenix, NLP and Reporting So need to involve in the testing and complete the SIT and UAT and provide the sign off for Production. Recently started the Automation and I am involved in creating the BDD framework from scratch for Automation testing.

Responsibility:

●Experience in working with the different vendor and always involved in the business management meeting.

●Coordinated the test efforts with offshore India and Spain QA teams to maximize the test efficiency.

●Validated the SOAP output Backend results by writing SQL queries and executing them in Snowflake.

●Experienced in setting up configuring the testing environment with JUnit and Selenium Web Driver.

●Developed Data warehouse ETL test cases for various lines of businesses based on ETL mapping document.

●Ability to work on high pressure environment and can work independently with minimal supervision.

●Hands on experience on JIRA tool for Bug tracking, issue tracking and project management functions.

●Experience in doing performance testing of service using JMeter.

●Involved in working on a project where we implemented BDD (behavior Driven development), TDD (Test Driven development) using Cucumber framework with Java, JUnit and Page Object Model.

●Setup testing environment and maintain framework using Python.

●Working on the BDD python Framework from Scratch.

●Performing the UAT as per business requirement.

●Performing the testing with the help of Automation tool.

●Automation of web application using Selenium.

●Automation of API’s using Request Lib.

●Experience working with Automation Test scripts using TOSCA tool, which helped in executing the Regression scripts automatically.

●Expertized in using Jira software with Jenkins and Bitbucket for real time bug tracking and issue management.

●Extensively worked on Jenkins to implement Continuous integration (CI) and Continuous deployment (CD) processes.

●Setup Continuous integration with Jenkins and make use of wide range of plugins available to setup smooth developer friendly workflows.

●Expert in automation with UFT/QTP, Selenium Web driver, Tricentis Tosca, SoapUI, Postman.

●Working on different project on AWS Cloud (S3, EC2)

●Worked on Multiple Prism home application and perform the UI testing with Selenium.

●Working on AWS secret manager.

Environment: Selenium WebDriver, Jenkins, Maven, TestNG, Quality Center, Fire path, Firebug, Eclipse, XPATH, Java, HTML, CSS, TDD, SQL, Oracle, JMeter, Snowflake, DataIku, BDD, Python, Jira,API., Bitbucket.

PROJECT 1

Publicis Sapient is an American digital consulting company. The project Chevron involved working on the Data testing I am Part of the SCDF project involved different testing Such as Report testing, End to End Testing, Interface testing, Webservice Testing. There are many interfaces involved in the testing in some interface the data is moving from the old version (Teradata) to Synapse So needs to execute the DataStage for Preside and Microsoft Azure pipeline for post side which is automated.

Responsibility:

●Experience in working with the Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirement, and observed design inconsistencies.

●Clear understanding of business procedures and ability to work as an individual and as a part of a team.

●Experience in SDLC and Agile methodologies such as SCRUM.

●Analysing requirements and creating and executing test cases

●Performed Integration, End-to-End, system testing.

●Analysed solution architecture and design documents including Source to Target & detail design documents needed for each track and plan test design activities.

●Used SQL server to develop and execute test scripts in SQL, to validate the test cases.

●Involved in reviewing test scenarios, test cases and test results for data warehouse/ETL testing.

●Extensively used ALM to track defects and manage them.

●Written Test Cases for ETL to compare Source and Target database systems.

●Written several complex SQL queries for data verification and data quality checks.

●Use of POSTMAN plugin in browser to verify JSON request and response headers for API testing.

●Hands on experience on Azure Devops tool for Bug tracking, issue tracking and project management functions

●Run Power BI reports & effective dashboards after gathering and translating end user requirements

●Run Spotfire reports & effective dashboards after gathering and translating end user requirements

●Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL Data Warehouse environment.

●Expert in automation with UFT/QTP, Selenium Web driver, SoapUI, Postman.

●Tested Web Services /XML / SOAP and Restful services using SoapUI tool.

●Experience in testing Web Services using SoapUI tool, validating WSDL, request and response xml.

●Proficient in test execution and management of testing defects.

●Experience with Azure Cloud Services, AZURE Virtual Machines Storage, SQL,Azure,Azure Active Directory, application insights, and logic apps.

Environment: Selenium WebDriver, Jenkins, Maven, TestNG, Quality Center, Fire path, Firebug, Eclipse, XPATH, Java, HTML, CSS, TDD, SQL, Oracle, JMeter,Karate DSL,JavaScript, Azure DevOps, Microsoft Azure(Cloud), SoapUi, Postman, Spotfire, Power BI.

YASH Technologies

March 2018 – April 2019

Sr. Automation Tester

YASH Technologies is a leading technology integrator specializing in helping clients reimagine operating models, enhance competitiveness, optimize costs, foster exceptional stakeholder experiences and drive business transformation. The Project at Cigna involved testing the Insurance Quote plan page which incorporated the functionalities based on location and customized client’s data to acquire and estimate month to month projection costs.

Responsibilities:

●Performed functional, regression, end-to-end, GUI, Exploratory, Performance and acceptance testing on the Insurance Quote plan page & Cigna Login page.

●Used Maven as the build tool, Git for version control, Bamboo for Continuous Integration and JIRA as a defect tracking tool to check any bug on the login page.

●Create keyword-driven, data-driven test automation scripting for testing newly developed API services and functional and user interfaces.

●Developed Automation framework to automate the API's using Data Driven Framework, Java Rest Assured and Cucumber.

●Implemented TDD (Test Driven Development), BDD (Behavior Driven Development), using Cucumber and Java.

●Created Regression Document to track and report testing activities on Get a Quote page during each phase of testing, including testing results, test case coverage, required resources, logged defects and their status, performance baselines.

●Modification and execution of Test Case Scripts (Java-Selenium WebDriver) in Eclipse IDE, the design of automation test framework.

●Actively participated in requirement gathering from end Users, Responsible for writing functional Specifications and design documents.

●Perform Quality Assurance tests at different levels such as functional testing, unit testing, configuration testing, integration testing, systems testing, regression testing and user acceptance testing. Document test results, Analyze and interpret test results, test data and prepare reports.

●Tested Cigna Login page website in different types of browsers and versions, such as Internet Explorer, Firefox, Google Chrome to simulate production environment.

●Work with CI tools such as Jenkins to move to CI/CD processes.

●Used Teradata SQL to save queries to a file so they can be run automatically from the same file in the future.

●Hands-on experience on SauceLabs.

●Used HP Quality Center to review, execute, and track scripts progress for each project.

●Developed Manual Test Cases, verified Actual results with expected results for the application.

●Performed End-to-End testing manually.

●Performed Defect Tracking and Management in ClearQuest and ALM.

●Participated in daily Scrum meetings and defect review meetings.

Environment: Jira, Jenkins, Selenium WebDriver,Eclipse,Java, JMeter, Maven, SQL, ALM,JavaScript.

Alliant Infotech

Nov2016– March2018

Automation Tester

Alliant Infotech is central India's fastest-growing pure-play big data analytics company helping a range of industries with data-driven solutions. We have been helping clients from all walks of industries like consumer-packaged goods, insurance, healthcare, life sciences, retail and technology, and the financial sector.

●Developed Test Cases, Use Cases and Automation test scripts. Other activities included test execution, report generation using selenium web driver and TestNG.

●Used Maven as the build tool, Git for version control, Bamboo for Continuous Integration and Rally as a defect tracking tool to check any bug on the login page

●Performed End-to-End testing manually.

●Tested the ios and Android Mobile based application with the help of Appium Test Framework.

●Participate in review meetings for the various sprint cycles to understand the release backlog to estimate and plan for the release cycle accordingly.

●Used Maven, Selenium Grid to execute Selenium automation suites on different platform, browser combinations in parallel.

●Enhanced Test scripts using Java programming features and TestNG Annotations.

●Generated UI test final reports by using Selenium TestNG framework.

●Expert in automation with UFT/QTP, Selenium Web driver, Tricentis Tosca, SoapUI, Postman.

●Expertise in working with Cypress and Selenium Web Driver using TestNG for Automation testing.

● Build and enhance automated test framework using Cypress and POM concepts.

● Created cypress projects in the command line, and Git repo to manage code.

●Create docker images of webdriverIO tests and run them in various containers in parallel to reduce time taken for test execution.

●Created and executed SQL queries using Multiple inner and outer joins, Complex joins between multiple tables, sub queries, Unions, decode functions, aggregate and analytical functions to improve auto generated emails.

●Participate in review meetings for the various sprint cycles to understand the release backlog to estimate and plan for the release cycle according.

●Executed test cases for order list and History table in my account DB which process manually and compared actual results against expected results.

●Performed GUI, functional, regression, positive, negative and system testing on various applications.

●Maintained Requirement Traceability Matrix (RTM) to make sure that test plans were written for all the requirements.

●Ran regression scripts to ensure that the existing features are working fine using cucumber.

●Tested time for query execution, performed load testing and stress testing.

●Hands on experience on JIRA tools for Bug tracking, issue tracking and project management functions.

Environment: TestNG, Quality Center, E-commerce, SQL, JIRA, RALLY, HP ALM, Cucumber, Maven, Selenium Webdriver, Java, Eclipse

Education:

●St Cloud State University (USA) Aug 2019- May2022

Master’s in engineering management

●DAVV University Aug 2014-May2017

Bachelors in commerce

Professional Affiliations:

●Active Member of American Society of Engineering Management (ASEM) SCSU Student Chapter and assists the council in conducting industrial tours, corporate events at Plymouth campus.

●Board member for Public Relations at DAVV Cultural Committee in managing public relations, preparing, and pitching sponsorship proposals for organizing cultural events at college.

●Certificate of Publication of Research Paper in International Journal of Science

Research.

●Green Belt Certification on Lean Six Sigma.

Contact this candidate