Test Manager Quality Assurance
Resume:
Gaurav Goel
******.*******@*****.***
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).
● 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 (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.
●Wrote automated test cases with UI Path test manager.
●Expertise in processing and validating Card payment transactions using ISO 8583 standard specifications.
●Excellent understanding of Credit card life cycle and Banking applications and functionalities.
●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 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 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 SKILLS:
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, RubyMine, 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
EDUCATION:
Bachelor of Technology (Electronics and Communication) AKG Engineering College-2006
M.Sc. in Computer Science University of Houston - Clear Lake-2010
PROFESSIONAL EXPERIENCE
Huntington Bank Jun 2024 – Current
Test lead /Automation Architect.
Tested external applications and automated it using selenium java 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 teams to external partner.
●Tested all APIs for data flow between multiple modules, each for customer creation, enrollments, verification and sending off information to external partners.
●Used oracle database, Splunk, swagger, insomnia to test multiple APIs 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 verified the data flow in Splunk right from customer creation, get their eligibility, enrollments/ assignment to multiple interfaces, get each detail of customer and sending that info to external team.
●Used selenium java framework to automate API data flow and executed them everyday to make sure no issues are there after every change in any of APIs..
●Make sure API description is valid in swagger with all positive and negative flows and is running with no issues.
●Used selenium java framework to do integration and regression testing before every release.
●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 Coast 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 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 my 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, Selenium, Azure devops, New Relic, Blaze meter, Gherkin, JMeter, Grafana, API, XPath, Ruby, Watir, Page Objects, Web Services, GIT, Java, Oracle,,rest assured services, APIs, insomnia, Swagger, Jenkins, Ruby/Cucumber.
Meijer, Grand Rapids, MI March 2023 -Jun 2024
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.
Responsibilities:
●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 testing 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 is 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.
●Performed performance testing using Rational performance tester.
●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
QA Lead/Architect
Worked on Meta Store for different countries and supported different projects across META. Automated work order related scenarios in multiple projects.
Responsibilities:
●Test automation lead for 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 involves 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 efficient 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 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 team and giving 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
ETL 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.
Responsibilities:
●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.
●Tested 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.
●Define data strategy and approach on validation in ETL flow.
●Tested and automated informatica flow in ETL data warehouse testing using Java cucumber automation framework.
●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 also 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 java cucumber framework.
●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.
●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 java cucumber framework.
●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 applications’ UI 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 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 UI Path test manager.
●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 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 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, New Relic, Dynatrace, Splunk, XPath, Hadoop, HiveQL, Typescript, JavaScript, Protractor, Axios, Page Objects, Web Services, GIT, SonarQube, Wireshark, Security, smoke, regression, integration, Unit testing. Java, Rest Services, K6, UI Path test manager, Cucumber
Nationwide Inc., Columbus, OH Jan 2020 – June 2020
Test Automation Lead/Architect
Developed and maintained automation suite for testing web-based application for iMedia applications like SSC, RSC and ISC using Ruby/Cucumber automation framework.
Responsibilities:
●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.
●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 manage 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 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.
●Performed API performance test created for all individual APIs, using Rational performance tester.
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.
Responsibilities:
●Working as 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 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.
●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
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.
Responsibilities:
●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.
●Automated market application using Geb and Groovy and created automation framework accordingly for market application.
●As part of Cardinal Health marketplace worked on Backoffice modules like fulfilling medical customers like hospitals. doctor’s requests for goods and service.
●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 author side of AEM application.
●Implemented end to end automation framework 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 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 rational performance tester.
●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 rational performance tester 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. Test automation SAP using Work soft.
●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, Cucumber, XPath, Java, GCP cloud, AWS cloud, PhantomJS, JavaScript, Selenium, Page Objects, New Relic, Web Services, UNIX, GIT, Groovy, eCommerce, Blaze Meter, rational performance tester, Site Speed IO, JavaScript, Performance test, Security Testing, Concourse pipeline, GitHub, Java
Nationwide Inc., Columbus, OH Nov 2014 – Mar 2017
ETL 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.
Responsibilities:
●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.
●Checked Splunk for logs for different APIs specific to applications in different environments.
●Created dashboards in Splunk to check the usage of APIs for specific applications over the time.
●Automated CTI Admin, IVR/VRU Admin, eCommisions, eRenewals using Ruby
Contact this candidate