Quality Assurance Software Development

Gaurav Goel

740-***-****

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

PROFESSIONAL SUMMARY

Experience in the field of IT with focus on testing of Desktop, web based, and Client-Server based applications.

I have worked in multiple domains that include Banking, Insurance, Biotechnology, Mortgage and Electronics and communications industries.

Diversified experience in the various Client/Server, database and Web applications as a QA / Testing professional in an Agile/Scrum environment (designing, coding, debugging, testing, documentation, maintenance and enhancement).

Working in SRE team (Software Reliability Experience) and supported multiple team’s software quality assurance.

Experience in writing Gherkin scripts.

Wrote new automated unit tests, functional tests, and Cucumber feature specifications (with selenium with Java, ruby, geb with groovy).

Experience in test automation on API and web application’s End-to-end testing in TOSCA.

Using test project automation tool automated different web stores.

Developed regression suite on thin client test cases using TOSCA tool.

Worked on recovery scenario, API and databases in developing custom controls, execution task in TOSCA.

Maintained automation test framework in TOSCA with multiple test cases for different projects in different companies.

Wrote automated test cases with Selenium Web driver.

Supported configurations in a Service-Oriented Architecture (SOA) driven organizational framework.

Performance testing for APIs, and web-based application.

Strong knowledge and exposure of quality related activities and all phases of software development life cycle.

Working knowledge of software development methodologies including Behavior Driven Development, Waterfall, Joint Application Development with emphasis on Agile.

Working knowledge of Agile and waterfall SDLC environment with focus on Defects’ resolution and test cases execution.

Assign test cases’ task /test cases, gather test data, requirements to test team and taken initiative to automate and maintain test cases using tools that include TOSCA, selenium, ruby/cucumber etc.

Automated web-based applications using Page Objects, Watir Web Driver, Selenium Web driver and Ruby cucumber.

Automated Angular JS based applications using new automation framework.

Automated Java swing-based application using Java based Shim tool created for same purpose.

Created automation code that will call shim tool methods and convert them in ruby classes.

Involved in all phases of SDLC that include Requirements analysis, Software design, Implementation, Test planning, Test design, Test analysis, Test cases executing, Bug reporting and tracking, Deployment and Maintenance.

Tested applications in all phases of SDLC that include Development, Test, Verification, Validation, Preproduction and Production.

Supported configurations in a Service-Oriented Architecture (SOA) driven organizational framework.

Tested and automated Rest assured web services using curl, Firefox plugin and Junit test cases.

Hands on experience with HP Mercury Quality Center, Test Track pro, Team foundation server and Test link for Test cases, Defects and User Stories Management.

Extensive experience in writing SQL queries (Oracle, SQL server, MySQL and MS-Access) for complicated back-end testing.

Extensive experience in building, executing Test Plans, Test Case scenarios, Test Cases in accordance with business, functional and user requirements specifications and hence writing Test Scripts, Reports.

Strong knowledge of Software testing (Gray Box Testing, Functional Testing, Structural Testing, White Box Testing, Black Box Testing, Unit Testing, Integration Testing (SIT), System Testing, Regression Testing, Load Testing, Stress Testing, Volume Testing and User Acceptance Testing.).

Expertise and complete understanding of QA Life Cycle, which includes Designing, Developing, Execution and Documentation of the Test Cases, Automated Test Scripts and Test Plans

Strong experience in implementing test scripts UAT scripts, table, database and file handling and manipulations.

TECHNICAL SKILL SET

Methodologies: Agile Scrum, Waterfall, Test Driven

Test Management: Quality Center/ALM, Test Link, Test Track Pro, MS Team Foundation Server (TFS), QTest, JIRA

Automation Tools: TOSCA, Selenium (Java), Selenium (C#), Visual Studio, Protractor, Cucumber, Watir, Quick Test Professional (QTP), Ruby Mine, WinRunner, TestNG, Protractor with Typescript, Test Project, Web Driver IO, Robot framework

Cloud: AWS, GCP

IDE: Visual Code, RubyMine, Visual Studio, NetBeans, Eclipse, IntelliJ

Performance Testing: Load Runner, JMeter, Blaze meter, New Relic, K6

Programming Lang.: Typescript, Ruby, JRuby, Groovy, Java, SOAP, C, C++, C#, SQL, VLSI, JavaScript, Python

Web Services: SOAP, REST Assured

Scripting Languages: UML (Unified Modeling Language), XML, VBScript, ASP

Databases: Oracle, MS SQL Server, MySQL, SQL Developer, PostgreSQL, Teradata

Content Management: Adobe Experience Manager

Automated Testing: XPath, Watir WebDriver, Axios, New Relic, Selenium WebDriver, TestNG, Page Objects, REST Client, Nokogiri, XML in, XML Out, OCI8, Active Record, Factory Girl, RAutomation, Rake, RSpec, Sequel

PROFESSIONAL EXPERIENCE

Meijer, Grand Rapids, MI March 2023 -Current

Test Lead /Automation Architect

Worked on Meijer store DOB (Digital Order book) app which is being used at Meijer store for scanning /ordering/managing inventory. Tested front and backend of application.

Test lead of team of testers that are working on DOB RMS app.

Doing manual as well as automated testing using robot framework of DOB RMS app features that include placing orders, managing orders, invoice generation, history management, managing hierarchy of items and managing them as per required departments in each store (like produce, clothing, meats, Meijer express etc.).

Tested data exchange and handshake process of 762 devices integrated with BLE technology .

Used client emulator app (Nordic nRF Connect app) to scan nearby BLE devices and connect /read /write to their values.

Create accessibility test cases with guidelines from 508 standards and writing test scripts for multiple software products that include mobile and Web applications.

Doing manual and automated testing on backend also, where testing all APIs related to checking retail inventory, order history, placing orders and maintaining inventory for different departments within Meijer store.

Reviewed websites for accessibility issues with JAWS, NVDA, and Voice over also review code to understand the root cause of the issues.

Went to store on every release and performed release validation on site on the scanning 762 device for DOB app.

Automated DOB app and APIs using Robot framework with Appium and selenium with Java.

Manually tested app on actual Meijer retail store scanning devices. Worked using Vysor for triggering app from actual device to monitor.

Automated cloud-based DOB RMS apps on devices that were placed at various locations across Michigan.

Compared and extracted data from SQL server database and used for backend and front-end testing.

Performed HTTP level testing using Python Requests on robot framework.

Worked in all phases for Model-View-Controller (MVC) software design and tested user interfaces, data, and controlling logic.

Utilized Appium library to interact with android DOB app.

Utilized Rest Instance to interact with rest assured web services that is being used to test APIs.

Used azure devops(ado) cicd pipeline to run smoke, regression and E2E test cases on weekly basis or as per need.

Performed security testing on APIs using Contrast.

To test production instance, take actual device to test app inside stores after every production build and whenever some issues are reported by customers.

Performed performance testing using Load runner.

Used Figma to know the changes to app, Azure devops (ADO) to manage cards to be worked in sprint and in testing.

Worked on SonarQube to verify code coverage and to know if there are any issues and to report them.

Environment: SQL server, SQL, Robot Framework, RMS, Azure, AWS cloud, Contrast, Vysor, BLE testing, Load Runner, Grafana, Postman, Swagger, XPath, Page Objects, Web Services, GIT, Java, Rest Services, JAWS, NVDA, Voice over, Appium

Meta Platforms, Inc., Sunnyvale, CA July 2022 – March 2023

Automation Lead / Architect

Worked on Meta Store for different countries and supported different projects across META. Automated work order related scenarios in multiple projects.

Test automation lead for manual and automation testing of Meta Store for different countries.

Using test project (free version of Tosca) automated different meta stores for Japan, south Korea, Belgium, Netherlands, Australia, USA and Canada.

Worked with Australia team using Icertis CLM for procurement and sales contracts, IP licenses, and internal agreements.

Worked with Japanese partner for controlling contract management using Icertis clm.

Worked on returns module of salesforce to deal with meta quest returns.

Used JavaScript commands in test project for automating different portions of meta webstore.

Used test rail to execute manual test cases for different meta projects.

Tested integration of contract processes with third-party systems using CLM.

Tested notifications received of the key milestone dates from Korean supplier for meta quest supplier using CLM.

Created architecture of automation suite and implemented it.

Used test project also to automate test rail in order to support QA team.

Integrated SAP modules with marketplace and tested modules of SAP that includes managing and planning products, materials management, cost center accounting, accounts payable and sales distribution.

Automated META stores and SAP integrated modules cost center, sales and distribution using build process automation.

Created and imported test cases for automating sales and distribution modules of SAP with external team using build process automation tool.

Took help of tricentis TOSCA in order to initiate automation of SAP modules and created multiple automated test cases in TOSCA to start moving test cases from build process automation tool to TOSCA.

Sent daily report on latency of SAP modules to improve performance of Meta store.

Using automation, automated process of uploading test cases, creating milestones, creating test plans and test runs using tests project to mitigate time period needed to increase efficient of QA manual test team.

Test automation developer and lead for manual and automation testing of Oracle portal, and CRM tool salesforce application for work order creation.

Worked in all phases for Model-View-Controller (MVC) software.

Using test project and custom JavaScript commands inside selenium, automated work order creation, editing work order and managing it.

Executed/Managed already created automation scripts for different old and current projects on demand from manual QA team.

Coordinate automation efforts from different team and giving weekly/on demand update to manager on smoke, regression, and sanity automation coverage for all automation work.

Coordinated production deployment effort and running smoke/regression test and reporting results to business.

Coordinated and lead 3 amigo triage meetings and converted user stories in test cases which were candidates for automation.

Environment: XPath, Page Objects, Web Services, GIT, Java, Rest Services, CLM, Selenium web driver, ERP, SAP, Build process automation, Test Project, Test Rail, JavaScript, Salesforce, Oracle portal.

McGraw-Hill Education, Columbus, OH June 2020 – July 2022

Test Lead

Worked on HECLR, SHOP, Study solutions, Passport, application for McGraw hill education. Tested and automated APIs for IDM/CLM/TASS interfaces that support multiple application across McGraw hill. Tested angular component as well as AEM based components of all applications. Tested and automated different components of project 231 (Lenel integration), project 241, project 133, MPP and MCIM. Used TOSCA to build automation framework and automate all components of project that include scale portal, service now, AMAG, Salesforce (MCIM) and MPP. Used Selenium with TestNG to automate AUDI project which include CRM tool Salesforce and oracle application.

Test automation lead for manual and automation testing of SHOP, passport APIs and Study Solutions application with their Heclr components.

Developed and fixed rest assured APIs for passport team.

Test automation developer and lead for manual and automation testing of Scale portal, Service Now, Amag and salesforce applications.

Created and executed tests in Jira/Zephyr.

Shared reports from zephyr test cases and test runs.

Automated UI for CLM using selenium with java and APIs for IDM, TASS, CLM APIs using java cucumber framework.

Tested contracts using templates provided by Icertis CLM.

Tested legal clauses in CLM for multiple contracts.

Used TOSCA to automate application user interface from end to end plus used different libraries to get logs that will show why tests failed.

Created modules in TOSCA for different applications using xscan in TOSCA wizard.

Ran smoke test, integration, regression tests using TOSCA at different phases of test cycle.

Worked on scale portal, service now, AMAG, Salesforce (MCIM) and created test cases for end-to-end flow and manually tested and hence automated them using TOSCA.

Interacted with different teams to understand requirements for APIs to be built to support their applications and created automated tests on based on end of end scenarios using TOSCA.

Used JavaScript commands in TOSCA to automate CRM tool salesforce pages that are not supported by tool.

Worked with colleagues from south Africa/Ukraine and India to build and test interfaces which were dedicated for each individual country.

Worked in all phases for Model View Controller (MVC) software design and tested user interfaces, data.

Move all automation code from robot framework to Protractor for MPP project.

Testing MPP applications’ UI and automating it using Protractor with Typescript based automation framework.

Created TOSCA test module for testing applications’ UI, web services and trained to offshore team to use to enhance automation effort for HECLR, SHOP, Study solutions, Passport applications.

Worked on AUDI project which contains CRM tool salesforce application, oracle application for end-to-end flow.

Automated AUDI project using TOSCA. The flow contains account creation, opportunity creation, quote creation, order creation, order approval, Orchestration of order and creating invoices.

Utilized QTest to save and execute TOSCA tests and to generate report.

Scheduled nightly TOSCA regression test cases run using QTest.

Utilized excel based approach in selenium to automate the project and created individual components of whole sales process to run on demand.

Worked with scale portal and service now teams to resolve the issues that were found while manually running test cases or that were found while running automated test cases on daily basis and helped in resolving them.

Worked on CRM salesforce application MCIM, understood application from vendor, wrote manual test cases and eventually automated them.

Automated end to end scenarios for almost 100 test cases for all projects using TOSCA.

Working on project 133 that is surrounding service now application and working with TCS team to fix test cases and eventually will pick them up once they are ready to be automated.

Worked with offshore team to get defect fixes and review requirements and getting ready for releases.

Created performance testing framework using K6 and integrated it with circle Ci to be able to catch performance regression and problems earlier in lower environments.

Testing web services for MPP and automated using Axios / Protractor.

Worked on circle ci, to enable automation suite to be part of release.

Coordinating automation efforts from offshore and onsite team and giving weekly update to team on smoke, regression, and sanity automation coverage for automation frameworks/code.

Running automation suite in Dev, QALV, DEMO and prod environment on every build.

Assisted on biweekly releases and test UI /Web services on each Blue /Green environment on every release.

Assisted developers to identify root cause of defects and make sure defects are resolved on time.

Updated GitHub with latest automation code and utilized Circle CI for running automation code on different environments on every code merge.

Environment: Agile, CircleCI, TOSCA, Zephyr, New Relic, XPath, Typescript, JavaScript, Protractor, Axios, Page Objects, Web Services, GIT, CLM, Rest Services, K6

Nationwide Inc., Columbus, OH Jan 2020 – June 2020

Test Lead

Developed and maintained automation suite for testing web-based application for iMedia applications like SSC, RSC and ISC using Ruby/Cucumber automation framework.

Implemented end to end automation for SSC/ISC/RSC application.

Utilized backend testing, rest assured web services testing and UI testing for SSC and RSC using Ruby/Cucumber automation framework.

Coordinated application web content to move from JavaScript to Angular 7.

Used emulators to perform manual mobile testing.

Developed automation script for mobile native applications using Appium java.

Automated mobile app using selenium, java with Appium.

Tested both android and iOS mobile devices /app.

Used Appium inspector, android studio, Visual studio code for mobile testing for android mobile devices connected to machine.

Experience in test automation on API and End-to-end testing in Ruby/Cucumber following BDD approach.

Developed Ruby/Cucumber Automation Framework & performed script maintenance.

Identified object by image, anchor and index and utilized them to automate application.

Utilized excel engine in Ruby/Cucumber to read data from external partners and utilized them to test SSC application.

80% of Contribution was to review & development of automation framework using Ruby/Cucumber, 20% of Contribution leading offshore test automation team.

Performed API performance test created for all individual APIs, using Load runner.

Automated web-based application ISC using Watir web driver with Ruby using page object and ran the automation code on daily basis using Jenkins.

Migrated all tests cases from ruby cucumber framework to TOSCA.

Created modules, test cases, test case design and execution in TOSCA for both ISC and SSC application using TOSCA and migrated all test cases from ruby cucumber framework to tosca.

Took help of tricentis to migrate test cases from ALM to excel sheet and imported those excel sheet in test cases module of TOSCA.

Coordinated with other iMedia teams to maintain TOSCA automation code build across teams for same application.

Worked on multiple projects like Linc plus, Low-cost VA and Single PR and coordinated development work for project as well as managed testing effort for same.

Managed release certification for code that is being pushed to prod every week by making sure automation test cases are running green and making changes to code according to changes made my our and other iMedia teams.

Managed and created new relic synthetics scripts making sure synthetic scripts are running with 100% pass percentage for over a week for every release.

Ran blaze meter to measure performance of application before every release, to be sure that performance is within SLA.

Tested typescript code, to ensure that move to angular 7 move is working or not.

Environment: Agile, Jenkins, TOSCA, New Relic, Blaze meter, Gherkin, Cucumber, XPath, Ruby, Watir, Page Objects, Web Services, GIT, Java, Oracle, Rest Services, Jenkins, Ruby/Cucumber.

Sherwin Williams, Cleveland, OH Sep 2019 – Dec 2019

Test Lead

Develop and coordinate TestNG/Selenium/C#/Appitools based automation suite for testing web-based application build using AEM, REST Assured web services, and Appitools for testing page layout, images, text, and videos.

Used Appium with java to test Sherwin Williams mobile app for PCG application.

Working as test lead for manual and automation testing of PCG application.

Testing PCG application UI and automating it using Specflow, Selenium and C# based automation framework.

Developed automation scripts for testing mobile app of client to test in IOS and android using Appium java.

Created manual as well automated tests to test for mobile native applications using Appium and Java.

Creating core automation framework for testing UI, services and Appitools and classes and giving training to offshore team to use to enhance automation effort.

Testing web services for PCG and automating using Gherkin/Cucumber, Selenium, Java based framework.

Testing application based on AEM and training other testers on how to test AEM based application effectively.

Testing page layout, images, texts, and video using Appitools and creating automation framework for same using TestNG, Selenium and Java based framework.

Coordinating automation efforts from offshore team and giving weekly update to manager on smoke, regression, and sanity automation coverage for all three automation frameworks.

Running automation suite in QAA, UAT and prod environment on every build.

Coordinating production deployment effort and running smoke test and reporting results to business.

Using QTest managing test cases creating by testers and building automation test on basis of them.

Coordinating defect triage meetings and giving inputs on the deployments-based decisions to business.

Environment: Agile, Oracle, Jenkins, Gherkin, Cucumber, XPath, Selenium, Page Objects, Web Services, GIT, Java, TestNG, Appium, Appitools, QTest

Cardinal Health, Dublin, OH Mar 2017 – Aug 2019

Test Automation Lead/Developer

Automated tests for market application using Geb and Groovy. Performance test using Load runner, Site speed IO with GCP. Automated Test AEM and automated author and publish instances of AEM and implemented Acceptance Test Driven Development.

Worked as part of SRE (Software Reliability Engineering team) as test lead and took responsibility of automated quality assurance of three different applications.

Used web driver IO using JavaScript to test Corp sites. Tested AEM (Adobe Experience Manager) and automated author and publish instances of AEM.

Test automation of ERP SAP using Worksoft.

In market application tested and automated SAP modules that includes quality management, materials management, and managing and planning products using worksoft.

Tested ERP SAP sales and distribution and cost center modules in market and automated using worksoft and sent reports on daily basis.

Automated market application using Geb and Groovy and created automation framework accordingly for market application.

Utilized GCP (Google Cloud Platform), Docker images to run automation code on Linux virtual machines (pulled from GitHub) which in turn get triggered from Concourse pipeline.

Used jQuery and JavaScript code to automate author side of AEM application.

Implemented end to end automation framework and developed test suite for all Corp sites.

Utilized New relic synthetics scripts, making sure synthetic scripts are running with 100% pass percentage for over a week for critical scenarios.

Utilized new relic to measure performance once all web services were manually triggered using Blaze meter for performance testing.

Implemented Acceptance Test Driven Development (ATDD) in the line and maintain automated test suite with multiple test scripts.

Automated web-based applications using Selenium with Java using page object WebDriver, XPath and ran the automation code on daily basis using Jenkins.

Created automation code in Java for multiple operations and integrated code with Concourse pipeline for nightly build.

Ran automation suite daily and on demand using Concourse pipeline.

Created browser-based performance test suite using docker images (GCP) and site speed to help triage performance of individual components of every event in application.

API performance test created for all individual APIs for market using Load Runner.

Helped in success of Pardot, AEM to AWS move and AEM upgrade projects.

Test Automation of Corp sites using Geb with Groovy, Phantom JS, Selenium, and Curl.

Helped transition of APIs from PCF to AWS and performed functional and performance test for APIs before and after moving to compare performance and pass ratio.

Helped transfer of APIs from AWS to APIGEE (GCP) move and performed automated functional and performance tests for APIs.

Load testing for all APIS using Load runner and created test suite for endurance test.

Research on different tools for browser-based performance and load test for market to choose suitable one. Created automation suite that can be triggered from Pipeline with multiple user execution in parallel.

Created automation suite to test APIs for market in all environments.

Utilized and automated running of Curl commands to test AEM, created/edited in and outflow of assets and page.

Executed scripts using continuous integration tool Jenkins.

Executed scripts in different browsers to test all Corp sites across multiple browsers and platforms.

Performed mobile testing for Corp sites. Provided efficiency by enabling team to adopt to Standard Agile practices.

Worked with developers/BAs/Scrum Master/JPM to report discrepancies to resolve defects and track changes.

Provided estimates at initiate and solution scope phases.

Environment: Agile, Jenkins, Gherkin, Geb, WORKSOFT, Cucumber, XPath, Java, GCP cloud, AWS cloud, PhantomJS, JavaScript, Selenium, Page Objects, New Relic, Web Services, UNIX, GIT, Groovy, eCommerce, Blaze Meter, Load Runner, Site Speed IO, JavaScript, Performance test, Concourse pipeline, GitHub, Java

Nationwide Inc., Columbus, OH Nov 2014 – Mar 2017

Test Lead

Worked with IW team, engaged in test automation/manual testing of Java Swing based applications Vision, Views, Indexing, and Batch prep and 3SG projects. Automated testing of web based NBSG Workflow maintenance application.

Worked as Test Lead/Automation tester/Manual tester for automating web based SRT applications that include Vision, Views, Finra renewals, eRenewals, eCommissions, CTI Admin, IVR/VRU Admin.

Automated CTI Admin, IVR/VRU Admin, eCommisions, eRenewals using Ruby cucumber using BDD approach.

Automated Java Swing based applications Vision, Views, Indexing, and Batch prep using ruby with cucumber.

Performed rest assured web services testing and UI testing for different application using Ruby cucumber automation framework.

Performed 3 amigos on Data Models and Data Mappings and engaged in checking /editing Architectural Documentation.

Performed integration testing (SIT), and End-to-end testing in Ruby cucumber.

Developed Ruby cucumber Automation Framework & performed script maintenance.

Ran Ruby cucumber in continuous integration (Hudson and Jenkins).

Engaged in all meetings for on Data Models and Data Mappings.

Identified object using Anchor, image and index and created common repository on GitHub so that it can be shared across IVR and VRU application’s Ruby cucumber automation framework.

Performed XML testing by using Ruby cucumber test suite.

Performed Data driven testing using Ruby cucumber using BDD approach.

Automated Java Swing based applications Vision, Views, Indexing, and Batch prep with Ruby and cucumber.

Used OCI8, Active record with Ruby cucumber for backend testing.

Automated web-based applications using Page Objects, Watir Web Driver, Selenium Web driver and XPaths with Ruby.

Tested data snowflake data warehouse applications NBSG Workflow maintenance application that include backend testing, UNIX server to and from communications from sending and receiving feeds.

Ran UNIX and Linux commands to test data coming in and going to/from database in form of feeds.

Executed scripts using continuous integration tool Jenkins.

Executed the UNIX Shell scripts that invoked SQL loader to load data into tables.

Automated Java swing-based application using Java based Shim tool created for same purpose.

Moved all automation code from subversion to GIT and ran using continuous integration tool Jenkins.

Created automation code that will call shim tool methods and convert them in Ruby classes.

Used OCI8, Active record with Ruby Cucumber for backend testing.

Used Factory Girl with JRuby Cucumber for snowflake data warehouse testing.

Snowflake Data warehouse testing using Teradata and Oracle stored procedures.

QA test lead for ETL testing.

Tested Informatica jobs and changes in database correspondingly and automated the whole ETL flow.

Created automation framework using Ruby cucumber in such a way that even manual testers can enhance and use it for their scenarios without the need of touching Ruby code.

Automated AngularJS based applications using new automation framework.

Utilized multiple combinations of page objects, XPath and Watir WebDriver to automate web pages.

Converted multiple QTP scripts to Ruby cucumber automation scripts for Vision, Views, Indexing applications.

Created automation framework in ruby to run and validate REST Assured and SOAP web services.

Educated/trained interns and co-workers in Ruby and best practices in automated testing.

Trained testers/developers in Ruby Cucumber, Gherkin scripts.

Mentored/coached Agile lines to adopt Standard Agile practices.

Established and managed continuous integration bed for automation suite using Jenkins (DC) and Hudson (ARM) and trained team how to use it.

Coached testers online to adapt Acceptance Test Driven Development (ATDD).

Ran Ruby features using rake tasks in continuous integration (Hudson and Jenkins).

Created automation bed using Ruby Mine and wrote

Contact this candidate