Resume

QA Lead, Business Analyst, ETL Tester

Location:

United States

Posted:

March 06, 2024

Contact this candidate

Resume:

Gaurav Netkar

***** ********* *******, ***-***,

Ashburn, Virginia, VA 20147-7794

Email – ad35wh@r.postjobfree.com / ad35wh@r.postjobfree.com

Mobile – +1-571-***-****

https://www.linkedin.com/in/gaurav-netkar-52974115/

Senior Quality Assurance Associate Manager with 13 years of work experience in Quality Assurance /Software Testing & Business Analyst role on BFSI & Corporate & Investment banking domain

ISTQB – CTFL (Certified Tester Foundation Level) as Software Quality Assurance Analyst & Business Analyst

Well versed with Software Quality Management, Highlighting Risks at every stage of Product Lifecycle & mitigating the same.

ISTQB – Agile Extension Certified Tester & Expertise in Domain knowledge of Payments and Trade Finance

Agile Certified Scrum Master (CSM) from Scrum Alliance – 2018

Identification of defects at the early stage of the STLC/SDLC lifecycle such that IT Audit & Controls are in place at every stage of software development till go live in production & support of the same

Expertise in Agile Methodology, Scrum Master, Agile Project Management, Test Management, Release Management, Production Incident Management

Experience working on Cloud technologies, Microservices, load and performance testing

Testing in cloud environment (AWS s3)

Creation/Review of BDD Feature file

Experience in Test Automation by Test Complete using Java & Java Script

Knowledge on messaging middleware like IBM Websphere MQ (Messaging Queue), TIBCO EMS, and Kafka

Developed Test Automation Framework using Java & Python Selenium Web driver

Implemented Page Object Model Framework with Java & Python & Selenium

Integrated Automation scripts framed in BDD Framework + Glue Code (Java & Python) into continuous integration tools Jenkins for Nightly Consignment run of the scripts & Test Execution Report Validation for following day.

Performed Unit Testing by Junit & Pytest, which helped debugging of issues at earlier stages of testing cycle.

Extensively used Eclipse IDE, PyCharm IDE & IntelliJ IDE for framing the scenarios and maintaining latest Test scripts Repository.

Experienced in API Testing for Microservices by tools like Postman, Swagger, SOAP UI, Rest Assured

Well versed with API Testing – HTTPS Status codes like 200,400,500 series for Success, Client-Side error & Server-Side Error while validating API Gateway Endpoints for Microservices by Postman, Swagger, SOAP UI, Rest Assured

Well Versed in API testing using Postman, including creating and maintaining test suites, collections, and environments.

Excellent Knowledge and hands on experience Trade Finance applications specially in JP Morgan Chase’s in-house platform called as TCFE – Trade channel Frond end & TPS – Trade Processing System

Expertise in Hybrid and BDD (Behavior Driven Development) framework using Page Object Model and Data Driven Approach in Eclipse IDE

Well versed in Python and Java software languages and Selenium Web driver for Cross Browser testing and Regression Suite Testing via Automation

Experience in Service Now Platform, Service Now Application for SNOW tickets.

Experience in tools like Service Now instances, IDE Debugger, build tools, Unix, Putty, File Zilla

Worked Extensively on EDI Flat Files for Stored Procedure testing

Validated Excel Extract from Old Legacy Feed Files to New GKP Feed files

Validated data points from Tibco to Snaplogic

Maintained and enhanced existing Tibco integrations to meet evolving business needs.

Conducted troubleshooting and resolved issues related to Tibco integration processes.

Spearhead the migration from Tibco to SnapLogic, ensuring a smooth transition of existing integrations.

Design and implement new integration solutions using SnapLogic's platform.

Proficient in Cloud Services implantation via JPMC Internal GAIA Cloud platform involving Microprocessors for each & every module Like Data export Definition, MQ, Customer Purge, Inbound & Outbound processor from Partner system etc.

Proficient in End-to-End transaction processing in Trade Technology by Kafka Messaging queue

Good interpersonal skills, committed, result oriented, hard working with a Quest and zeal to learn new technologies and to perform challenging tasks and capable of working under tight project deadlines

Good Knowledge on JIRA – User stories repository & ALM – Test Plan, Test Lab, Defect Tracking

Ensured Test Strategy, Test Plan, Test Script Design, Test Cases reviews are conducted in Testing cycle

Ensured in scope items & out of scope items are mentioned in Test Strategy for testing

Handson for In Sprint Test Script Design & Automation is happening parallelly

Expertise in Agile Methodology, JIRA for Stories/Defects/Test Scripts Tracking

Worked upon Multiple Production Issues related to TCFE project and brought it to closure for quality

deliverables

Handson Knowledge of Service Now Platform & Automated Test Framework – resolving SNOW Tickets & bring it to closure, Able to automate the testing of applications, customization & configuration.

Handson experience of ITSM Requests/ Alacrity Issues for P1, P2, P3 & P4 level of Production Issues. Testing & simulating in QA env, Providing Signoff & implementation of same in Production & bringing ITSM requests to Closure.

Familiarity with NPM module and package management, as well as Maven for Java Projects.

Familiarity with remote execution tools like Sauce Labs, Browser-Stack and Selenium Grid.

Handson Experience in testing Microservices

Experience in ADA – American Disability Act Web Accessibility Compliance Testing, including section 508, WCAG 2.0 & WCAG 2.1 standards with a focus on conducting thorough compliance audits. Experience in ARIA attribute specifications for web elements

Hands On knowledge of Assistive Technology (e. g screen readers, magnifiers, alternative input, etc.) & able to create Assistive Technology (AT) story for capturing ADA Checkpoints

Assessed & improved the web accessibility score from 75% to 90% by identifying 200+ accessibility violations, addressing 90% of accessibility issues & discussing with ADA SME’s & Development team for fixing the issues & addressing as per Business Most valuable product backlog items

Good Experience in Requirements Traceability Matrix (RTM) & traces each story requirement with pertaining test scripts.

Leading performance testing for Chase Application using Apache JMeter and Dynatrace or similar monitoring tools.

Contributing in evaluating Business Use cases & executing performance test scripts, focusing on different types of performance testing (Stress, Volume, Load, etc.) to meet business requirements.

Experience in performance testing and monitoring Kubernetes/Microservices.

Experience In Consumer & Community Banking (CCB) Line of Business under Self Directed Automated Investing (SDAI) Vertical, JP Morgan Chase’s inhouse Investment Solution in Chase Mobile & Web > Investments > Self Directed Automated Investment (SDAI) > Screeners Webpage & E2E Functionality for Stocks/Mutual Funds/ETF’, Equities, Fixed Income, Treasury Bonds, Securitized products etc.

Conducted end-to-end testing of mobile applications using Appium, ensuring optimal functionality and performance across various devices and platforms.

Collaborated with developers and QA team to create and maintain automated test scripts for new features and regression testing.

Implemented test strategies and executed test plans to identify and resolve defects, ensuring the delivery of high-quality software products.

Utilized Appium for mobile application automation, including both Android and iOS platforms.

Worked closely with product owners to understand requirements and provide feedback on testability and potential issues.

Handson Experience in Perfecto, Cypress, Jasmine, Playwright, PowerBI, Kubernetes, Docker, Container, Azure, xUnit, JestJasmine

Experienced in Testing applications & validations against Databases, Analytics & Data engineering Platform/ETL

Handson experience in SQL and complex SQL queries, Stored Procedures, Views for validating business rules.

Experience with Validation of data transformations and performing End-to-End data validation for ETL systems.

Experience in testing Online Transaction Processing - OLTP, Online Analytical Processing - OLAP and Reports.

Involved in Automation testing using TOSCA Tool

Worked with all modules of TOSCA like Modules, Test Cases, Requirements, Test Case Design & Execution List

Worked for TOSCA Integration with Jenkins

Experience in Test Automation in API & End to End Testing in TOSCA

Handson experience in eCommerce websites

Experience working with Jenkins Pipelines, AWS Cloud Watch, Splunk and building test automation.

Expertise in building and maintaining web test automation frameworks preferably using Playwright

Experience in web performance testing principles

Experience with analytics tools such as Dynatrace, Splunk

Experience with using Charles Proxy, Fiddler, or similar tools

Experience in monitoring tools like DataDog & experience in executing load, spike, stress and endurance testing.

Experience in JMeter & LoadRunner for Performance testing.

Experience in Back End testing the functionality, performance, and reliability of the back-end components of applications.

Experience in processes that extract data from source systems, transform it into a usable format, and load it into a target system, typically a data warehouse.

Experience in Delta Lake which is an open-source storage layer that brings reliability to data lakes.

Experience in Databricks a unified analytics platform for big data and machine learning. Experience with Databricks suggests involvement in data processing, analytics, and machine learning workflows.

Experience in Apache Oozie a workflow scheduler for managing Hadoop jobs for orchestrating complex workflows in data processing.

Experience in Apache Airflow an open-source platform for orchestrating complex workflows & used for data pipeline orchestration.

Familiar with Azure DevOps (ADO, ADO ATP), Postman, Newman, SOAPUI, Database Query tools

Manual testing experience of ServiceNow applications like Incident, Problem, Change, Request, Knowledge, CMDB, Release modules

Experience of requirement gathering document and experience of converting the same in test cases

Experience of ServiceNow development and objects used in development

Experienced in testing of ServiceNow domain separated environments

Responsible for conducting testing activities, improving the existing manual testing procedures, and leading the transition from a manual testing focus to one of automated testing.

Work with ServiceNow project manager, developers, and administrators to develop manual and automated testing solutions for continuous enhancement and integration of ServiceNow platform and applications.

Implement ServiceNow Automated Test Framework, Test Management, and other test tools to verify/validate continuous release of ServiceNow major, minor enhancement and maintenance releases.

Seeking assignments in the areas of Software Testing and Quality Assurance with a growth-oriented organization that lends me a supportive and operative learning environment with ample chances to contribute and diversify my knowledge and skills, challenges me intellectually and offers me a good potential for future growth.

Currently Associated with LGL Technologies LLC, Texas

QA Lead Contract with Virtusa & Client JPMorgan Chase Ltd., Columbus,Ohio,US – October 2023 to February 2024

Quality Assurance Associate with JPMorgan Chase Ltd., Mumbai – January 2013 – December 2022

Process Associate with Tata Consultancy Services Banking & Financial Services Ltd., Mumbai January 2010 – August 2012.

Good understanding of test automation cost vs. benefit and analyzing ROI such that Status, Risks, Compliance Controls & Checks, Audit & Automation Saving report can be shared with senior management stakeholders

Excellent communication skills between Business stakeholders, Business Analyst’s, Testing Team, Development Team, Production Support team & Partner system teams in coordinating job tasks for smooth delivery of the release in production environment

Programming languages

Java, Python, C++, ASP.Net, Apache Groovy, Spock, Spring, Spring Boot, React JS, Ember JS

RDBMS/DBMS

Oracle, SQL developer, ETL Data Warehouse testing

Operating System

Windows, Mac OS

Testing Tools

SQL, FileZilla, Putty, Rest Assured Web-services, Postman

SOAP UI, Appium, Swagger, Sauce labs, Browser stack, BlazeMeter, JMeter, Tableau, TOSCA, iOS& Android Mobile Testing, NVDA, JAWS, SNOW Tickets, ITSM/ Alacrity Requests,NPM, TIBCO,Snaplogic,Perfecto.Cypress,Jasmine,Playwright,,PowerBI,Kubernetes,Docker,Container,Azure,xUnit,JestJasmine

Defect Reporting & Test

Management Tools

JIRA, Confluence, SharePoint, Zephyr, HP ALM, HP QC, Team Track

Automation Tools

QTP, Selenium Web Driver, BDD,Figma

Build & DevOps - CI CD

Tools

Jenkins, Docker, Maven, Kubernetes, Splunk

Version Control Tools

GitHub, Bitbucket, Subversion (SVN),Sharepoint,JIRA,Confluence

Testing Model

Waterfall, Agile Methodology

Testing Frameworks

TestNG, Junit, BDD, Cucumber, Pytest

IDE

Eclipse IDE, IntelliJ, PyCharm, VS code

Testing Types

SIT testing, QA Testing, UAT Testing, Smoke & Sanity Testing, Regression Testing, Cross Browser Testing, Mobile Testing, Web-services Testing, Automation Testing using Selenium Web driver, Performance Testing

Current Organization: - LGL Technologies LLC, Texas

Past Associations

PROJECT NAME: Self Directed Automated Investment (SDAI)- Discover Team > Screeners Webpage & E2E Functionality for Stocks/Mutual Funds/ETF’s etc,

Organization: - J.P. Morgan Chase, Columbus, Ohio, US

Client: - JPO/CPO Customers under JP Morgan Wealth Management Portfolio

Role: - QA Lead/QA Automation Architect/QA SDET

Domain: - Self Directed Automated Investment (SDAI) – Consumer & Community Banking

Designation: - QA Lead

Tenure: - October 2023 to February 2024

Responsibilities: -

Testing Application: - In Consumer & Community Banking (CCB) Line of Business under Self Directed Automated Investing (SDAI) Vertical, JP Morgan Chase’s inhouse Investment Solution in Chase Mobile & Web > Investments > Self Directed Automated Investment (SDAI) > Screeners Webpage & E2E Functionality for Stocks/Mutual Funds/ETF’, Equities, Fixed Income, Treasury Bonds, Securitized products etc.

Proficient & Involved in Quality Assurance Discipline & Leading QE activities in Agile like Test Strategy, Test Case Preparation, Risk based testing approaches, Daily Standup Meetings, Retrospective Meetings, Sprint Planning, Story Point estimation, Defect/Bug Logging & Tracking, Reporting to stakeholders by Sprint wise/Weekly or Monthly Test execution metrics, Automation execution metrics etc.

Involved in JIRA Dashboard – User stories repository & ALM, Zephyr – Test Plan, Test Lab, Defect Tracking. Showcasing expertise in Agile Methodology, JIRA for Stories/Defects/Test Scripts Tracking

Leading the Scrum Activities & Representing the Testing team during Sprint Planning, Retrospective Meetings, Defect calls, Product Backlog Review meetings etc.

Contributing in Chase Desktop & Mobile App Web Accessibility - ADA testing by NVDA & JAWS tool.

Contributing in Using of ADA tools like Axe Dev Tool & Color Contrast Analyzer for achieving accessibility compliance, including Section 508, WCAG 2.0 & WCAG 2.1 standards, with a focus on conducting thorough compliance audits.

Working with various technologies such as Web-logic & TOMCAT, Application Server, HTML/ XHTML, ASP.NET, AS Applications, jQuery, Advanced JavaScript, NodeJS, ReactJS, Cascading Style Sheets (CSS) and Java Server Faces (JSF), Java/J2EE, Java Script, Ajax, SQL, SOAP, REST, JSON, SQL Queries, Green lines,Figma,Wireframes,HTML Semantics, UDF Scripts etc.

Creation of Assistive Technology (AT) Story for tracking ADA WCAG 2.1 checkpoints are getting covered as part of Web Accessibility testing for web components based on MDS – Manhattan Design System & Octagon.

Experience in ARIA attribute specifications for web elements

Hands On knowledge of Assistive Technology (e. g screen readers, magnifiers, alternative input, etc.) & able to create Assistive Technology (AT) story for capturing ADA Checkpoints

Conducted end-to-end testing of mobile applications using Appium, ensuring optimal functionality and performance across various devices and platforms.

Collaborated with developers and QA team to create and maintain automated test scripts for new features and regression testing.

Implemented test strategies and executed test plans to identify and resolve defects, ensuring the delivery of high-quality software products.

Utilized Appium for mobile application automation, including both Android and iOS platforms.

Worked closely with product owners to understand requirements and provide feedback on testability and potential issues.

Handson Experience in Perfecto, Cypress, Jasmine, Playwright, PowerBI, Kubernetes, Docker, Container, Azure, xUnit, Jest,Jasmine

Good Knowledge on JIRA – User stories repository & ALM – Test Plan, Test Lab, Defect Tracking

Ensured Test Strategy, Test Plan, Test Script Design, Test Cases reviews are conducted in Testing cycle

Ensured in scope items & out of scope items are mentioned in Test Strategy for testing

Handson for In Sprint Test Script Design & Automation is happening parallelly

Handson experience in eCommerce websites

Experience working with Jenkins Pipelines, AWS Cloud Watch, Splunk and building test automation

Experience in monitoring tools like DataDog & experience in executing load, spike, stress and endurance testing.

Experience in JMeter & LoadRunner for Performance testing.

Familiar with Azure DevOps (ADO, ADO ATP), Postman, Newman, SOAPUI, Database Query tools

Manual testing experience of ServiceNow applications like Incident, Problem, Change, Request, Knowledge, CMDB, Release modules

Experience of requirement gathering document and experience of converting the same in test cases

Experience of ServiceNow development and objects used in development

Experienced in testing of ServiceNow domain separated environments

Responsible for conducting testing activities, improving the existing manual testing procedures, and leading the transition from a manual testing focus to one of automated testing.

Implement ServiceNow Automated Test Framework, Test Management, and other test tools to verify/validate continuous release of ServiceNow major, minor enhancement and maintenance releases.

PROJECT NAME: TRADE CHANNEL FRONT END (TCFE)

Organization: - J.P. Morgan Services India Pvt Ltd, Mumbai

Client: - Home Depot, Lowes, BBB, Trade Beam Ross, Medline, Burlington, Dillard’s, Target, Walmart, Bunge, VF Corp, Li & Fung

Role: - QA Lead/Manager/QA Automation Architect/ QA SDET

Domain: - Trade Finance Technology – Corporate & Investment Banking

Designation: - Senior Quality Assurance Associate (Assistant Vice President)

Tenure: - January 2013 to December 2022

Responsibilities: -

Perform analysis of current features are being developed to help design and maintain software automation architecture & maintain periodic audits for the project

Implement test practices, standards, and processes, troubleshoot test issues, record test results, track and prioritize defects, participate in product readiness, and release decision

Knowledge on messaging middleware like IBM Websphere MQ (Messaging Queue), TIBCO EMS, and Kafka

Experience working on Cloud technologies, Microservices, load and performance testing

Testing in cloud environment (AWS s3)

Experienced in API Testing for Microservices by tools like Postman, Swagger, SOAP UI, Rest Assured

Well versed with API Testing – HTTPS Status codes like 200,400,500 series for Success, Client Side error & Server Side Error while validating API Gateway Endpoints for Microservices by Postman, Swagger, SOAP UI, Rest Assured

Well Versed in API testing using Postman, including creating and maintaining test suites, collections, and environments.

Proficient in RESTful and SOAP, Postman web services testing, data validation, and performance testing.

Strong knowledge of API concepts, protocols (HTTP, HTTPS, JSON, XML), and authentication mechanisms (OAuth, JWT) by Postman, Swagger, SOAP UI, Rest Assured

Developed Test Automation Framework using Java & Python Selenium Web driver

Implemented Page Object Model Framework with Java & Python & Selenium

Performed Unit Testing by Junit & Pytest, which helped debugging of issues at earlier stages of testing cycle.

Extensively used Eclipse IDE, PyCharm IDE & IntelliJ IDE for framing the scenarios and maintaining latest Test scripts Repository.

Experience in testing microservices architectures, including containerization (Docker, Kubernetes).

Make sure the automation is constantly running and being analyzed using continuous integration, continuous development methodology

Experience in Service Now Platform, Service Now Application for SNOW tickets.

Worked Extensively on EDI Flat Files for Stored Procedure testing

Validated Excel Extract from Old Legacy Feed Files to New GKP Feed files

Validated data points from Tibco to Snaplogic

Maintained and enhanced existing Tibco integrations to meet evolving business needs.

Conducted troubleshooting and resolved issues related to Tibco integration processes.

Spearhead the migration from Tibco to SnapLogic, ensuring a smooth transition of existing integrations.

Design and implement new integration solutions using SnapLogic's platform.

Experience in tools like Service Now instances, IDE Debugger, build tools, Unix, Putty, File Zilla

Participate in technical governance and help negotiate overall product quality standards with development and business teams such that quality is assured throughout from SIT to Production env

Work with the QA Manager/Director to research, investigate, implement, and train other QA Resources in the areas of Agile Testing Practices, Test Driven Development and Testing Automation

Coordinate with team members for testing activities, participating in Requirements Ambiguity, & Use Case / User Story Reviews, and conduct QA analysis & test support activities

Developed Test Strategy, Test Plan and Test cases based on the requirements and maintained the traceability matrix.

Created test plan, test estimations, daily status, monthly QA Metrics, and the test summary report and provided sign-off. Early Identification of Defects for Quality Deliverables

Building Created test plan, test estimations, daily status, monthly QA Metrics, and the test summary report and provided sign-off.

Test scripts by BDD Framework in Gherkin Language with corresponding glue code/step definition

Leading Defect Triage call with Business stakeholders, Product Owner, Development team & partner Business system teams

Review Test scripts created by QA team members & provide review comments wherever needed

Experienced in Resource allocation for TCFE (CR) Coordinated Releases as well as Production issues

Provide Demo for new functionality to stakeholders, Product Owner’s, Development & QA Team members

Responsible for formulating & sharing Weekly QA Execution Status Report to Business stakeholders, Product Owner’s, Development & QA Team members

Participation in Scrum Calls, Sprint Planning, Effort Estimation, Retrospective meetings, IT Audit Background Controls &Compliance Checks.

Experience in Perfecto, Cypress, Jasmine, Playwright, PowerBI, Kubernetes, Docker, Container, Azure, xUnit, Jest,Jasmine