Test Manager Software Development
Resume:
Gaurav Goel
******.********@*****.***
PROFESSIONAL SUMMARY
Experience in the field of IT with focus on testing Desktop, web based, and Client-Server based applications.
I have worked in multiple domains, including 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).
Data Warehouse(ETL) Support experience in ETL development tools like Teradata, Informatica, Ab-Initio, Data Stage.
Good Experience in reconcilation of Daily & Historical ETL loads.
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 (Selenium Java,Ruby cucumber, UI Path test manager, geb with groovy).
Experience in test automation on API and UI testing using UI Path test manager.
Using test project automation tool automated different web stores.
I wrote automated test cases with UI Path test manager.
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.
Automated web-based applications using Page Objects, Watir Web Driver, UI Path test manager and Xpaths with Ruby.
Automated Angular JS based applications using a 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 into 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 include Development, Test, Verification, Validation, Preproduction and Production.
Supported configurations in a Service-Oriented Architecture (SOA) driven organizational framework.
Tested 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, Toad 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: UI Path test manager, Selenium (Java), Protractor, Cucumber, Watir, Quick Test Professional (QTP), Selenium (Ruby), Ruby Mine, WinRunner, TestNG, Protractor with Typescript, Test Project, Web Driver IO, Robot framework
Cloud: AWS, GCP
IDE: Visual Code, Ruby Mine, Visual Studio, NetBeans, Eclipse, IntelliJ
Performance Testing: Load Runner, Rational performance tester, Blaze meter, New Relic, Splunk, Dynatrace
Programming Lang.: Typescript, Ruby, JRuby, Groovy, Java, SOAP, C, C++, C#, SQL, VLSI, JavaScript
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, UI Path test manager, TestNG, Page Objects, REST Client, Nokogiri, XML in, XML Out, OCI8, Active Record, Factory Girl, RAutomation, Rake, RSpec, Sequel
PROFESSIONAL EXPERIENCE
Huntington Bank Nov 2024 – Current
UI Test lead
Tested mortgage applications and automated it using Geb with Groovy framework. Tested multiple APIs and their interactions and tested with external teams from multiple external partners for integration.
Responsibilities:
●Tested backend flow of information from Huntington internal mortgage application to external partner apps.
●Tested all APIs for data flow between multiple modules, each for customer creation, mortgage enrollments, verification and sending off information to external partners.
●Used oracle database, Splunk, swagger, insomnia to test multiple APIs and UI and their data flows.
●Queried oracle database to get data from Huntington internal teams to test multiple external team’s APIs and tested APIs using insomnia tool’s collection.
●Used azure devops for managing stories, test cases, test plans, test runs, defects and builds.
●Tested each individual APIs and respective UI and verified the data flow in Splunk right from customer creation, get their eligibility, enrollments/ assignment to multiple interfaces, get each customer detail and sending that info to external team.
●Used Geb with Groovy framework to automate data flow and executed them every day to make sure no issues are there after every change in any of APIs /UI.
●Make sure API description is valid in swagger with all positive and negative flows and is running with no issues.
●Used Geb with Groovy framework to do integration and regression testing before every release.
●Experience in test automation on UI and End-to-end testing in Geb with Groovy ..
●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 Coast application.
●80% of Contribution was to review & development of automation framework using Geb with Groovy, 20% of Contribution leading offshore test automation team.
●Performed API performance test created for all individual APIs, using JMeter, blaze meter and Grafana.
●Coordinated with other EPM teams to maintain ruby cucumber automation code build across teams for same application.
●Worked on multiple projects 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 1-2 by making sure automation test cases are running green and making changes to code according to changes made by our and other EPM 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 JMeter to measure performance of application before every release, to be sure that performance is within SLA.
Environment: Agile, Geb with Groovy, Azure devops, New Relic, Blaze meter, Gherkin, JMeter, Grafana, API, XPath, Page Objects, Web Services, GIT, Java, Oracle, rest assured services, APIs, insomnia, Swagger, Jenkins, Ruby/Cucumber.
Nationwide Inc., Columbus, OH May 2024 – Nov 2024
Test Lead
Developed and maintained automation suite for testing web-based application for applications like Coast, CAM, IAM for multiple projects that include ways to pay, Rivian authorization, MFA using Ruby/Cucumber automation framework. Performed ETL testing using jruby framework .
Implemented end to end automation for ways to pay, Rivian authorization projects.
Interacted with multiple stakeholders and gave them daily updates for their respective projects.
Make sure end consumers are updated about updates in project deadlines and made sure the project moves to production smoothly.
Design and define ETL requirements, creation and testing of mapping .
Define data strategy and approach on validation in ETL flow for data flow from files to central warehouse.
Testing involves validating the interfaces and conversion of data migration from legacy Inventory system to DB2 database as part of system test.
Analyzed the data mapping and developed scenarios to verify the data migration from different files and staging tables.
Trained other testers on all applications I am working on and distributed work among them.
Implemented new standards for automation.
Discussed with different consuming application’s PO and discussed what new functionalities can be implemented in future and worked on road map, funding approval, epics’ creation and estimation.
Met with different sister teams to make sure the application web content which are shared across for different projects are working smoothly and if any updates are there, share them with my own team.
Utilized backend testing, rest assured web services testing and UI testing for coast and cam using Ruby/Cucumber automation framework.
Experience in test automation on API and End-to-end application web content 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 web content.
Utilized excel engine in Ruby/Cucumber to read data from external partners and utilized them to test Coast application web content.
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 JMeter, blaze meter and Grafana.
Coordinated with other EPM teams to maintain ruby cucumber automation code build across teams for same application.
Worked on multiple projects 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 1-2 by making sure automation test cases are running green and making changes to code according to changes made by our and other EPM 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 JMeter to measure performance of application before every release, to be sure that performance is within SLA.
Environment: Agile, Jenkins, ETL, New Relic, Blaze meter, Gherkin, JMeter, Grafana, API, XPath, Ruby, Watir, Page Objects, Web Services, GIT, Java, Oracle, Rest Services, Jenkins, Ruby/Cucumber, JRuby.
Meijer, Grand Rapids, MI March 2023 -May 2024
Automation Lead
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 web content.
Test lead of team of testers that are working on DOB app.
Doing manual as well as automated testing using robot framework of DOB app.
Went to store on every release and performed release validation on site on the scanning 762 device for DOB app.
As part of back-office management. did manual and automated testing on backend, where all APIs related to checking inventory, order history, placing orders and maintaining inventory for different departments within Meijer store.
Automated DOB app and APIs using Robot framework with Appium and UI Path test manager.
Manually tested app on actual store scanning devices. Worked using Vysor for triggering app from actual device to monitor.
Automated cloud-based DOB 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.
Performed security testing, usability testing, smoke, scalability and regression testing.
Performed back-end testing for APIs.
Used Wireshark for penetration testing as part of security testing.
Worked in all phases for Model-View-Controller (MVC) software design and tested user interfaces, data, and also controlling logic.
Utilized Appium library to interact with android DOB app.
Utilized Rest Instance to interact with rest assured web services that are being used to test APIs.
Used azure cicd pipeline to run 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 also whenever some issues are reported by customers.
Used Figma to know the changes to app, Azure devops to manage cards to be worked in sprint and in regression testing.
Worked on SonarQube to verify code coverage and to know if there are any issues and to report them.
Environment: SQL server, SQL, Toad, Robot Framework, Azure, UI Path test manager, AWS cloud, Contrast, Vysor, Rational performance tester, Grafana, Postman, Security testing, penetration testing, Wireshark, Smoke testing, Back-end testing, Regression Testing, XPath, Page Objects, Web Services, GIT, Java, Rest Services, Appium
Meta Platforms, Inc., Sunnyvale, CA July 2022 – March 2023
Test Lead
Worked on Meta Store for different countries and supported different projects across META. Automated work order related scenarios in multiple projects.
Test automation leads to manual and automation testing of Meta Store Data warehouse for feeds from different countries.
Got data feeds for return items from Japan, south Korea, Belgium, Netherlands, Australia, USA and Canada and made sure the ETL jobs for each individual job is running fine.
Involved in End-End ETL workflows which involve legacy systems, big data systems & cloud environment.
Used test rail to execute manual test cases for data warehouse testing.
Created architecture of automation suite in JRuby cucumber using factory girl and implemented it.
Using automation, automated process of uploading test cases, creating milestones, creating test plans and test runs using tests project in order to mitigate time period needed to increase efficiency of QA manual test team.
Performed security testing with Australia and south Korea team on different feeds.
Performed Data quality testing, ETL performance testing, Data transformation testing and Integration testing on whole ETL process.
Tested csv files from feeds, made sure right transformation has taken place while loading data in staging tables.
From staging tables to snowflake made sure the right ETL transformation has taken place and data integrity is secured.
Test automation developer and lead for manual and automation testing of Oracle portal, and CRM tool salesforce application for work order creation from data utilized from data warehouse.
Worked in all phases for Model-View-Controller (MVC) software.
Executed/Managed already created automation scripts for different old and current projects on demand from manual QA team.
Coordinate automation efforts from different teams and give weekly/on demand update to manager on smoke, regression, and sanity automation coverage for all automation work.
Coordinated and lead 3 amigo triage meetings and converted user stories in test cases which were candidates for automation.
Environment: Web Services, GIT, Java, Rest Services, SonarQube, Test Rail, JavaScript, Salesforce, ETL, JRuby, Factory girl, Snowflake, Vulnerability testing, security testing, penetration testing, Regression, back-end testing, 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. Data warehouse with ETL tester for AMAG and SHOP. Tested and automated different components of project 231 (Lenel integration), project 241, project 133, MPP and MCIM. Used UI Path test manager to build automation framework and automate all components of project that include scale portal, service now, AMAG, Salesforce (MCIM) and MPP. Used UI Path test manager 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.
Data warehouse tester with ETL, Big Data implementation.
Used HiveQL for data analytics and warehousing on big data.
Thoroughly examine and tested the data warehouse and intermediate databases using HIVEQL for Hadoop.
Hadoop s Hadoop Distributed File System (HDFS) to maintain large data sets across multiple nodes.
Design and define ETL requirements, creation and testing of mapping and created validation scripts using RobotFramework using Python.
Define data strategy and approach on validation in ETL flow.
Tested and automated informatica flow in ETL data warehouse testing using RobotFramework using Python.
Developed and fixed rest assured APIs for passport team.
Performed DBT Testing that includes Data type validation, Completeness checks and data integrity checks.
Performed DBT validation locally and using ci/cd pipeline.
Performed security and penetration testing at school level for multiple k12 applications.
Used SonarQube and Wireshark tool for Vulnerability testing, security testing and penetration testing.
Automated UI for CLM using UI Path test manager and APIs for IDM, TASS, CLM APIs using RobotFramework using Python.
Used UI Path test manager to automate application user interface from end to end plus used different libraries to get logs that will show why tests failed.
Tested ETL jobs and troubleshooted SQL procedures based on errors displayed in error log.
Performed E2E to ingest mainframe binary data, structured data in ETL Data Warehouse
Checked Splunk with different queries to check if logs are generated for different get /post/put/delete calls.
In Splunk checked the errors that were occurring on applications and helped in finding root cause of errors.
I interacted with different teams to understand requirements for APIs to be built to support their applications and created automated tests based on end of end scenarios using RobotFramework with Python.
Used JavaScript commands in UI Path test manager 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.
Testing application web content and automating it using Protractor with Typescript based automation framework.
Created framework for testing applications’ UI, web services and trained to offshore team to use to enhance automation effort.
Worked on AUDI project which contains CRM tool salesforce application, oracle application for end-to-end flow.
Automated AUDI project using UI Path test manager. The flow contains account creation, opportunity creation, quote creation, order creation, order approval, Orchestration of order and creating invoices.
Utilized excel based approach in UI Path test manager to automate the project and created individual components of whole sales process to run on demand.
Test automation developer and lead for manual and automation testing of Scale portal, Service Now, Amag and salesforce applications.
Worked on scale portal, service now, AMAG, Salesforce (MCIM) and MPP and created test cases for end-to-end flow and manually tested and hence automated them using UI Path test manager.
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 a 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 RobotFramework with Python.
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 an offshore team to get defect fixes and review requirements and get 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 Study solutions 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 teams and giving weekly updates 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 causes 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, New Relic, Dynatrace, Splunk, XPath, Hadoop, HiveQL, Typescript, JavaScript, Protractor, Axios, Page Objects, Web Services, GIT, SonarQube, Wireshark, Security, regression, integration, Unit testing. Java, Rest Services, K6, UI Path test manager, RobotFramework, Python
Nationwide Inc., Columbus, OH Jan 2020 – June 2020
Test Automation 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 web content.
Utilized backend testing, rest assured web services testing and UI testing for SSC and RSC using Ruby/Cucumber automation framework.
Worked with nationwide bank on financial strategies and track the status and performance of the assets under management and update the client on the progress of each investment.
Worked on asset management module of nationwide bank where we performed asset tracking and send investment strategies to bank and insurance clients.
As part of asset management module for nationwide bank create documentation and reports on asset tracking and recommend corrective measures to the client.
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.
Experience in test automation on API and End-to-end testing in Ruby/Cucumber.
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.
Automated web-based application ISC using Watir web driver with Ruby using page object and ran the automation code on daily basis using Jenkins.
Coordinated with other iMedia teams to maintain 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 by 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.
Performed API performance test created for all individual APIs, using Rational performance testers.
Environment: Agile, Jenkins, Toad, New Relic, Splunk, 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/Java/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 a test lead for manual and automation testing of PCG application.
Testing PCG application UI and automating it using TestNG, Selenium and Java based automation framework.
Developed automation scripts for testing mobile apps 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 suites QAA, UAT and prod environment on every build.
Coordinating production deployment effort and running smoke test and reporting results to business.
Coordinating defect triage meetings and giving input on the deployment-based decisions to business.
Environment: Agile, Oracle, Jenkins, Gherkin, Cucumber, XPath, Selenium, Page Objects, Web Services, GIT, Java, TestNG, Appium, Appitools
Cardinal Health, Dublin, OH Mar 2017 – Aug 2019
Test Automation Lead/Developer
Automated tests for market application using Geb and Groovy. Performance test using Blaze Meter, Rational performance tester, 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 for 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.
Automated market application using Geb and Groovy and created automation framework accordingly for market application.
As part of Cardinal Health marketplace, we worked on Backoffice modules like fulfilling medical customers like hospitals. doctor’s requests for goods and services.
Managed inventory, products, processed sales orders, onboarding new employees and record management as part of back-office management.
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 the author side of AEM application web content.
Implemented end to end automation framework Geb with Groovy and developed test suite for all Corp sites.
Performed Security, smoke, regression, integration, Unit testing, penetration and back-end testing with multiple automation tools and SonarQube.
Performed penetration testing on AWS platforms.
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 rational performance tester.
Implemented Acceptance Test Driven Development (ATDD) in the line and maintain automated test suites 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 suits daily and on demand using Concourse pipeline.
Created browser-based
Contact this candidate