Post Job Free

Resume

Sign in

Quality Assurance Data Management

Location:
Nashville, TN
Posted:
February 29, 2024

Contact this candidate

Resume:

Prabhjot Gijwani

QA Automation Architect/Lead

** ***** ** ********** ** Quality Assurance/Automation

Email: ad30yd@r.postjobfree.com Contact: 224-***-****

Visa: US Citizen

Profile

I have more than 16 years of experience in information technology with significant expertise in project and as well as in developing, documenting, coding, modifying, testing, and implementing business technology solutions and managing multiple teams. Involved in developing test scripts using automated testing tools such as Selenium Web Driver/Cucumber/UFT. Good experience in Test/Defect management using JIRA. 16+ years’ experience testing client-server applications, web applications, API’s, databases and test automation solutions. seek increased responsibilities, offer help when needed, strives to increase productivity and work quickly.

CGI experience

Nissan, (07/22 to Till Date)

(07/22 to Till Date)

Working as Automation QA Lead to provide Automation solutions to multiple Teams.

Project1- Customer 360 is a master data management solution. The ultimate goal is to bring the NNA MDM (Master Data Management) in - house.

Project2- Fleet Portal UI Development: Car Dealership Rental Application

•Able to mentor and coach team members and develop quality systems, training programs, and expresses consistent, clear expectations, and practices that align with KBXTs Quality Strategy and ensures effective and efficient implementation across the organization.

•Hold the product team accountable for quality assurance and checkpoints to ensure quality and timely delivery; Review and write acceptance criteria for tickets with product managers and software engineers

•Able to handle multiple tasks/projects in a fast-paced environment and QA validations and sign-off on assigned projects

•Responsible for providing Load Testing Solutions to team using JMeter tool.

•Work cross-functionally with the operations teams to establish quality criteria and ensure alignment with customer expectations, troubleshoot complex issues

•Direct capacity planning, provisioning and scaling of the cloud infrastructures including cost benefit analysis of vendor offerings

•Lead working sessions on designing and building automation

•Good public speaking and presentation skills, interpersonal skills and ability to interact and work with staff and external partners at all levels.

•Implement standard methodologies for Operations across our teams to improve availability, security, visibility and incident response

•Responsible for Data level testing stored procedures moving data to staging tables in Snowflake and to Atacama master.

•Experience with ETL and data warehouse testing (Snowflake).

•Managed Team of QA’s working to build Automation Solution for C360 Project using Maven, Cucumber with BDD approach (Behaviour Driven Development)

•Responsible for providing manual/ automation solutions of API testing using SOAPUI/ Rest Assured tool.

•Responsible for AWS file upload testing and scheduling procedures testing.

•Responsible for leading Requirement Analysis and Test Review Meetings for teams.

•Responsible for Improvement of the processes, methodologies, and tools associated with quality assurance by implementing continuous improvement initiatives

•Maintain an understanding of industry best practices, evolving trends, and technological advancements in QA in order to identify areas of improvement, increase efficiency, and implement process improvements

•Responsible for proving test execution status in Internal and Client stand-up calls.

•Identify resources, resolve issues, and mitigate risks. Identify requirements, procedures and problems.

•Experience with application monitoring and logging tools (CloudWatch, etc.)

•Experience on Atlassian tools-Jira Test Cycle Management, Bitbucket, Confluence, Jenkins

•Responsible providing feedback to the development team on issues that are identified during testing. This includes working with developers.

•Quickly adapt to changes in the work environment; Able to deal with frequent requirement change, delays, or unexpected events.

•Participate in, and occasionally lead, sprint planning, standups, retrospectives, and other team meetings.

•Experience to lead, motivate, manage, hiring, training, performance management, mentoring and development a team of quality

•Guide the team through the SDLC & support the team in proactively triaging and resolving roadblocks throughout the testing cycle.

•Strong problem-solving skills to identify and address

•Experience in AWS SaaS products, data management and scheduling jobs.

•Responsible for hiring and training QA Staff on Project.

•Experience with Git / Node.Js/Angular

•Responsible for Leading/Mentoring team in UAT and Integration testing and document all test results and ensure execution results up to date

•Project management skills to plan and manage testing activities effectively.

•Responsible for keeping stakeholders well-informed of testing progress and statuses

•Responsible for starting Test Automation Practice/Framework Development from scratch

•Responsible to identify areas for automation and write automated tests to ensure repeatability, coverage, and reliability.

•Able to articulate issues, problems, impacts, and support needs across different internal teams as well as external teams

•Ensure proper documentation of Manual, and Automation test plans, test scenarios and test cases.

Other experience

Sr.QA Lead

HealthStream, Nashville, TN (03/16-06/22)

HealthStream Business: Focus on people providing healthcare Our solutions are contracted by healthcare organizations in

the U.S. for workforce development, training & learning management, talent management, credentialing, privileging,

provider enrollment, performance assessment, and managing simulation-based education programs.

Project: E- Portfolio Cloud Services: Document and Transcript Service Data Copy to MySQL database tied up with Cloud

Services from Legacy LMS SQL database. E-Portfolio 9 Microservices (Award, License, Education, Certification)

converted to AWS Cloud Services and existing transcript (Nurse’s existing Course Completions and Self Entered Learning

Events) were copied to AWS MySQL database through warp processes based on Organizational setting for Immediate and

Eventual data consistency and E-Portfolio portable suitcase development.

Responsibilities-

•Managed quality assurance activities for a large scale, Customer oriented project migration to Cloud AWS

•Team used Visual Studio on Windows Azure(Platform as a Service)

•Team Management: Working as onsite Lead for the team of 3 offshore QA’s, Responsible for Work assignment,

•tracking progress, issues troubleshooting and resolution. Setting up goals and objectives for testers and suggestions to improve test processes, assisting in tester training, answering queries and troubleshooting reported observations/issues

•Engage in typical responsibilities of a manager, including planning, evaluating, organizing, integrating, and delegating.

•Onsite Activities: Lead QA activities for set of product solutions. Handling both Frontend and Backend Team

•Testing on various platforms, with a focus on mobile products (iOS, Android, Windows phone,Tablet).

•Environment Systems Reset, Rebuild, Approve deployment. Responsible for requirement Analysis, Planning,

•Designing and Execution of the tests for entire project life cycle

•Create detailed, comprehensive, and well-structured test plans and test cases.

•Following HIPAA while working on customer data and completed mandatory trainings around this.

•Testing requires HIPAA training to view the sensitive data in the application.

•Experience using VSTS for continuous integration of feature branches and test case on each development story, Used

•Perform testing of XML or JSON feeds

•Preparing automation sanity and regression Test Sets for Web Application using open-source tool Selenium Web

Driver on Visual Studio and continuous check-ins and PR reviews

•Collaborate with leadership at all levels to efficiently implement Quality Improvement for Right-First-time product release.

•Experience in setting up Selenium BDD Framework for the project having config files, Pages and Test Cases.

•Worked with developers to update the defects, resolve them and track their status using VSTS.

•Working with Business users, Business Analyst, and development team throughout the different phases to understand requirement.

•Experience in automation Web, Mobile, and Living room Device Applications’ Testing using Selenium Web Driver, TestNG with TDD approach

•Conducting test case review meetings for API’s and UI functionality and ensuring the coverage of testing

•Driving in sprint automation of AWS Cloud API’s being delivered during the sprint

•Participating in backlog grooming calls to verify the required acceptance criteria is in place for functional and non-

•functional user stories and daily standups calls to call out impediments and provide previous day status.

•Automated testing to ensure addition of new features does not impact regression of existing features

•Responsible for data validations comparison using SQL and MySQL. Experience writing SQL queries.

•Be able to articulate issues, problems, impacts, and support needs across different internal teams as well as external teams

•Responsible for API testing using Postman/Fiddler and conversion to automatic functional tests and business logic exceptions

•Knowledge of Authentication and Authorization Platform API’s

•Experience of tracking the end objectives against goals/KPIs to ensure coverage

•Responsible for load testing application using LoadRunner Tool. Imported basic selenium scripts to LoadRunner for testing performance

•Visual studio code management/ merge/check-in

using SOAPUI tool, comparing data between Microservices and Cloud Services after Data Copy, AWS Paas Validation

•Audit and logging of lambdas

•Working knowledge of VSTS test case and defect management

•Responsible for creating Plan of action for offshore team validations.

•Experience in Onshore - Offshore delivery model with good coordination/communications skills.

•Experience in HIPAA Standard transactions.

•Responsible for test script walkthrough across Teams for knowledge sharing and implementing suggested changes

•Ensures timely and accurate entry of status, defect information and metrics to facilitate accurate/timely QA reporting

•Responsible for creating performance testing scripts for API’s using Locust and Python

•Proactively escalates issues, problems, status via proper channels and alerts/communicates with team on items of

•impact to ensure adherence to QA test schedule.

•Responsible for measuring quality throughout the CI/CD process

•Responsible for supervision of Quality Engineers to include hiring, training, performance management, mentoring and development.

•Responsible for Production Deployment supports and downtime deployment testing support of performance test

•modification script changes

Sr. Quality Analyst

Bridgestone Americas, Nashville, TN (07/15 to 02/16)

Bridgestone Business: The Bridgestone Group delivers a wide range of tires to customers around the world, such as tires

for passenger cars, trucks and buses, aircraft, construction and mining vehicles, motorcycles, etc.

Project: Bridgestone’s Cross Border Cross Business Program was created to develop API’s that outside vendors (like

Amazon) can consume to market Bridgestone Products directly to outside customers. These API responses display

Bridgestone’s Inventory at different warehouse locations. Product Web Services- for different type of Bridgestone tires

and models. Location Web Services- for different warehouse locations of Bridgestone, Inventory Webservices – for

Inventory of all types of tires at all warehouse locations.

Responsibilities-

•Responsible for defining requirements and test cases in ALM and linking test cases with requirements.

•Responsible for leading a team of 8 testers

•Worked for End to End integration testing for Product Web Services, Location Web Services and Inventory Web

Services projects and automation using SOAPUI

•Responsible for testing products data flowing from AEM systems to SAP Hana and all the way to outside world from

Rest API’s.

•Responsible for testing Inventory information flowing from SAP system, BSRO system and TWW system to SAP

Hana and to API’s.

•Responsible for raising defects in ALM tool and discussions about the defects with developers and getting those

resolved.

•Responsible for testing API’s through Mashery and Developer Portal testing for Product Web Services.

•Experience in using SAP Hana SQL queries to validate database updates.

•Experience using Postman/Advanced Rest Client for testing Rest API’s

•Experience using SOAPUI tool for end to end functional and Business exceptions of Rest API’s

Automation Lead

Bridgestone Americas, Nashville, TN (11/14 to 06/15)

Middleware Automation Project is started to automate the End to End testing of information flow between SAP

Applications and various other systems (ERP, High Jump(WMS), Entire net, TMS, PeopleSoft, BSRO, EDI (Electronic Data

Interchange), ASRS, AJWMS, IVR at Warehouses or customers of Bridgestone America’s Tire Operations

Automation of SAP Applications and Middleware Interfaces covers SAP Order Creation, Delivery Creation, Shipment

Creation, PGI, Tire Pick, Audit, and Ship to customers and Retread operations in High Jump and Hand Held and EDI

interfaces including automation of File transfers from WPS and processing in SAP using UFT (Unified Functional Tester)

tool. Supply Chain & Distribution Management.

Responsibilities-

•Managed team of 6 automation testers to develop automation of Bridgestone Middleware Interfaces, had to interact

with different teams like SAP Functional, SAP PO developers, WPS Developers, Legacy system support to

consolidate the interface testing and documentation required before automating all interfaces.

•Developed Business Process Testing Framework.

• Maintained the UFT Function Library, Shared Object Repository and Application Areas per system

•Created scripted components that are File based (EDI), API, Web, PeopleSoft, Java and SAP tests

•Created different data for iterations through different environment

•Involved in Creation of Automation Test Plan

•Involved in Feasibility Study of Automation to identify the areas that can be automated

•Responsible for completion of Automation of 51 Interfaces within specified timelines

•Scope Creation for Functional Testing and Automation

•Tools Used- UFT 12, ALM

•Responsible for accessing data from High Jump Interfaces through SQL Queries

•Meetings with Design Teams and Business Users for Requirement Study

•Involved in automation of end to end interfaces using HP Unified Functional Tester 12

•Implemented Business Process Testing framework from scratch

•Extensive experience in VB script and experience in Descriptive Programming

•Responsible for creation of weekly Status Report

•Responsible for maintaining manual steps documentations for all the interfaces for future reference

•Experience working with File system objects, Excel objects, Windows objects, SAP objects

•Automated SAP Order management module, WPS file processing, Excel files, SQL database, JDA/TMS and Filezilla

for file transfer from local machine to remote machine automatically and vice versa.

Test Lead

IBM India Pvt. Ltd, (05/10 to 05/13)

The AKBANK Banking Center, which is the highest transaction capacity operations center in Turkey, commenced service

in 2010. Equipped with state-of-the-art technology, this complex is positively contributing to AKBANK’s productivity.

AKBANK BPR is a project implemented IBM-developed framework for understanding the business processes, a

methodology for business process reengineering (BPR). AK bank BPR project Credit Factory vertical Part of testing team

for AK bank BPR project in AIS stream. Actively involved in testing of various modules in Credit Factory (CF) vertical to

be used by branches across the globe

Responsibilities-

•Analyzed and reviewed functional design, technical designs documents to write test cases Lead a team of 6 testers

for automation of AK Bank Credit Card Services.

•Responsible for designing new test cases for the new functionalities and also refining test scenarios for existing

functionalities

•Involved in peer review of test cases

•Maintained the traceability matrix

•Logged defects during the QA cycles and followed up with different teams on defect status during daily triage

calls

•Involved in writing Business Scenario Identification and Screen Identification documentation

•Involved in implementation of data driven testing framework in automating the BPR process testing

•Involved in writing scripts using tool Rational Functional Tester to automate testing

•Involved in execution of test scripts using IBM Rational Quality Manager and compared and analyzed actual to

expected results and reported all deviations for resolution

•Supported UAT team during the UAT phase and analyze their defects before passing them on to the development

team

QA Functional/Automation Tester

Tata Consultancy Services, India (12/08 to 05/10)

Common Capabilities is British Telecom’s UK’s project. BT& 21st century network consists of a common communication

platform for devices and applications currently in existence and new ones yet to be developed

Common capabilities are a set of re-usable components for use in product and service development. They are like a

construction kit, a set of parts that can be used to assemble different products and services. This was IVVT Test Project

which TCS got from Tech M Responsibilities-

•Involved in review of requirement documents of Managed User identity, Managed Fraud Reduction, Cyber Ark etc.

•common capabilities

•Involved in creating test plan document for testing

•Involved in test planning phase for writing test cases

•Responsible for designing new test cases for the new functionalities and refining test scenarios for existing

functionalities

•Reviewed test cases for all the team members and provided feedback as required

•Responsible for logging bugs and followed the defect life cycle to closure of the defect

•Mentored new team members with walk-through of the application

•Prepared Traceability Matrix and mapped Requirements and Test cases

•Involved in security testing and creation of security improvement plan

• Responsible of defining the feasibility and scope of automation testing

•Responsible of development of automation scripts for automating functional testing of Managed User Identity using

Tool- Quick Test Professional and integrated the scripts with Quality Centre

•Involved in execution of test scripts and resolution of defects

QA Automation Engineer

Tata Consultancy Services, Melbourne, Australia (07/07 to 12/08)

Qantas Airlines has grown to be Australia’s largest domestic and international airline. Automation application was

designed to automate FFSC and CC business user’s services being provided by FFSC and CC executives of Qantas

Airlines project earlier manually. These services involve processing emails to Frequent Flyer service center’s Lotus Notes

mailbox through users automatically, creating correspondence records on USAS Mainframes environment. Eventually

many repetitive tasks in other applications as well have been automated by Automation application. It includes the

processes developed for Amadeus queue sorting, Customer Care Email Processing and others. Responsibilities-

•Responsible of Requirement analysis and preparation of Automation feasibility and scope

•Responsible of creation of test scripts and execution of scripts using Quick Test Professional

•Responsible for Identifying defects and followed the process of defect life cycle to get them resolved by suggesting

workarounds

•Responsible for understanding the requirements for new enhancements suggested by business users

•Responsible for scheduling of scripts on Windows XP PC’s as per the guidelines provided in requirement document

•Involved in creation of folder structure for automation scripts on Windows XP machine server Used My SQL

to query database of Qantas Airlines

•Responsible for and reporting the test results of automated scripts

QA Engineer

Tech-Mahindra – Pune, India, (07/07 to 12/08)

Switch Manager supports the management, administration and maintenance activities associated with the Public Switched

Telephone Network (PSTN) service and its overlays Switch Manager plays an essential part in providing business and

residential customers with easy service provision or modification and ensure the subsequent reliability of those services.

Many external systems like CSS, OSS, NTMS, GTFM, BSS, PAPIP, STT/ISPT etc. Utilize Switch Manager's facilities.

Switch Manager manages a diverse selection of exchange types and automates around 90% of switch configuration

management.

Responsibilities-

•Involved in L2 support and testing

•Involved in requirement gathering from client

•Involved in creating Estimation document and taking signoff from client

•Involved in creating Test Plan and taking signoff from client

•Responsible for execution of functional test cases in Quality center

•Responsible for logging defects in BT’s tool Pirate used for defect tracking.

•Involved in writing test specifications and manual functional testing of the applications

•Involved in BAU activities and resolving Fault Incident Reports raised by IVVT team

•Defect Reporting to L3 and getting them resolved from client

•Training L1 (New Joiner’s)

Education

Bachelor of Engineering (Computer Science)

MAHARISHI DAYANAND UNIVERSITY–Haryana, India

August 2002 to May 2005

Industry experience

Airlines

Healthcare

Manufacturing

Telecom

Technical specializations

Test Plan Creation

Automation Test Strategy Development

Automation Framework Development

A

F

Areas of expertise

Quality Assurance

Team Lead

Offshore Tasking/Management

STLC

Automation Framework Development

Environments

My SQL

Snowflake

AWS

Sql Server Management Studio

Tools & Software

QTP/UFT

Selenium

QA Run

IBM Rational Functional Tester

Cucumber

SOAPUI

JMeter

PyCharm

VSTS

QC

Jira

Languages

Java, C#, JavaScript

Groovy Script

VB-Script, Python

Skills summary

Skill

Number of years

Skill level*

Technical skills

Test Case Management

16

Automation

10

Framework Development

8

STLC

16

Performance Testing

6

Functional Testing

16

Client Requirement Gathering

8

Test Plan Development

1

Support Production Deployments

6

Security Testing

2

User Acceptance Testing

2

QA Methodologies

6

AWS

2

Helping in Unit Testing

1

Application knowledge

Nurse Healthcare Learning Center

6

Nurse Assessment Management

6

Nurse Eportfolio Management

6

SAP Order Management

2

JDA TMS Trasport Management

2

Warehouse Management, Handheld Devices/ HighJump

2

Airlines Customer Care Service Center

2

Airlines Frequent Flyer Service Center

2

Industry knowledge

Airlines

2

Manufacturing

4

Telecom

2

Healthcare

6

Other relevant skills

Team Management

Offshore Task Management

6

Team Performance Management

2

Recruitment Events

2

*Skill Level: = Basic, = Intermediate, Advanced, Expert



Contact this candidate