Quality Assurance Qa Analyst

VARADARAJ DESHPANDE

614-***-**** ******@*****.*** https://www.linkedin.com/in/varadaraj-deshpande-72b71b5/

QA Analyst Test Lead Automation

Professional Summary

20+ years of IT experience in Software Testing and Quality Assurance across diverse industries including ServiceNow, Banking, Insurance, CRM (Siebel), and Web-based applications.

Led successful QA projects at Ventech Solutions, Nationwide Insurance, and IBM, demonstrating expertise in Test Management, Test Planning, and Process Implementation.

Strong Agile experience, working in dynamic environments and delivering quality in short durations using best practices.

Expert in Defect Management, using tools like “HP Quality Center”, JIRA, ServiceNow” to track defects, monitor severity, and report progress to stakeholders.

Proven leader in managing offshore/onshore teams, delivering projects on time while optimizing efficiency and enhancing collaboration.

Extensive experience in User Acceptance Testing (UAT) coordination, ensuring smooth transitions from development to production, with detailed reporting and user training.

Skilled in Backend Testing using SQL queries to ensure accurate data retrieval from databases.

Advanced reporting and metrics: Created detailed test execution summaries, defect status reports, and testing progress reports to ensure transparency and timely issue resolution.

Introduced testing procedures and templates, improving team efficiency and consistency in test activities.

Certifications

Scrum Master Certificate from Scrum Alliance on July 26, 2018

CSTE (Certified Software Test Engineer) Certified from QAI in September 2004.

CSTM (Certified Software Test Manager) Certified from STQC, India.

RDBMS Concepts from Brain bench in 2006.

ITIL Certified in V3 Foundation Examination in Sept 2008.

TRICENTIS - Automation Specialist Level 1 in Dec 2019.

TRICENTIS - Automation Specialist Level 2 in Dec 2019.

Domain Certifications:

INS 21 - Property and Liability Insurance Principles from “The Institutes” in 2013.

Principles of Insurance (280) Certified from LOMA in Mar 2012.

Skill Set

Processes : IT Infrastructure Library (ITIL), IT Service Management (ITSM)

Testing Tools : QTP 8.2, HP Quality Center, JIRA, ServiceNow ATF, API (Postman), TRICENTIS (AS1 and AS2), SQL Server Management Studio

Database : MS SQL Server, Toad 7.6, DB2

Applications : Mainframe, Siebel CRM and Web based applications, Debt Manager, ServiceNow

Automation Framework: Data Driven Framework, ServiceNow ATF (Automated Test Framework)

Methodologies: SAFe, Agile Scrum, Waterfall, SDLC.

Work Experience

Test Lead, 10/2014 to Current

Ventech Solutions Inc. – Columbus, United States

Vertiv – Service Catalog: Testing ServiceNow Service Catalog and Workflows, creating and maintaining automated tests for platform functionality.

Service Catalog application allows users to create service catalogs that provide customers with self-service opportunities. Customize portals where your customers can request catalog items such as service and product offerings.

The Service Catalog codelessly automates workflows and approvals to enable organizations to improve customer experience. End to end transformation of your IT services and infrastructure through use of a single cloud based platform

CMS - Center for Medicare and Medicaid Services: Testing ServiceNow Service Catalog and Workflows, creating and maintaining automated tests for platform functionality.

Led testing efforts for CMCS 1135 Waivers (CMS 1135 Waiver / Flexibility Request and Inquiry), ensuring compliance with the Centers for Medicare & Medicaid Services (CMS) regulations for healthcare systems.

Health Care Quality Information Systems (HCQIS) is part of CMS – HIDS and provides quality services to Network providers, Doctors, Patients, Suppliers, and Service Contractors. ServiceNow Platform was chosen to provide Service Catalog Services and Case Management.

Service Catalog application allows users to create service catalogs that provide customers with self-service opportunities. Customize portals where your customers can request catalog items such as service and product offerings.

The Service Catalog codelessly automates workflows and approvals to enable organizations to improve customer experience. End to end transformation of your IT services and infrastructure through use of a single cloud based platform.

Day to Day and basic job duties/responsibilities:

Scrum calls, story discussions and sprint planning every week.

Providing updates to day-to-day development activities

Bi-weekly Demo's with client and perform end to end application walk through.

Providing update Sets and batching update sets after each sprint.

Designed and Developed Test plan and test scripts based on User Stories.

Created and executed manual test cases using Test Rail and reviewed test cases developed by other testers.

Involved in Smoke Testing, Functional Testing, Regression Testing. Production Validation.

Performed Front end and Back-end testing of all the Modules using Manual as well as Automation Testing using ATF [Automation Test Framework].

Logged the defects in JIRA to perform defect lifecycle.

Involved in defects Daily Stand-up meetings, Backlog refinement meetings, Iteration review meetings, Retrospective meeting and interacted with Product Owner and Developers for resolving Defects.

Provided test metrics to the Scrum Master.

RRB - LSMS (Railroad Retirement Board): Transitioning legacy systems to modern platforms, focusing on parallel testing strategies.

The RRB LSMS project includes the conversion of TAX Mainframe applications to Modern applications. Test strategy used for system testing will be “Parallel Test strategy”. The objective of Parallel Testing is to validate new system behavior to be like legacy system.

The Legacy Systems Modernization Services (LSMS) project is being implemented to convert Legacy data currently stored on the mainframe in DB2 databases, VSAM files, and sequential files will be converted to SQL database. There are three types of data that will be converted: master, transactional (aka orbit), and historical data.

Ohio Attorney General's Office: DM9 (Debt Manager): Data conversion from legacy SYSTEMS AND perform extensive backend testing using SQL.

Day to Day and basic job duties/responsibilities:

Scrum calls, story discussions and sprint planning every week.

Providing updates to day-to-day development activities

Bi-weekly Demo's with client and perform end to end application walk through.

Providing update Sets and batching update sets after each sprint.

Responsibilities:

Actively engage in agile development activities, including Daily Stand-ups, Backlog Grooming, Sprint Planning, Retrospectives, and Iteration Reviews. Collaborate with Product Owners and Developers to resolve defects and write user stories.

SQL Query Development & Data Analysis

oExpertise in writing SQL queries to achieve the business requirements, perform in-depth data analysis.

oExtracted data from source systems and validated data accuracy within database tables.

Backend Testing:

oPerformed backend testing to ensure accurate and authentic data retrieval using SQL queries.

oDeveloped and executed test cases covering data completeness to ensure all required fields are populated.

ETL Execution & Data Validation

oExecuted ETL processes to upload business batch files and payment imports via the DM9 application.

oAGO Project – We did move data from Legacy database system to SQL Server. Conducted validation of data in both DM9 and corresponding database tables to ensure data integrity. Compare Data before and after Data is transformed into a new database for correct data mapping.

oRRB Project – Transformed data from DB2 to SQL Server and executed queries against both databases to validate data quality, ensuring accuracy, completeness, and consistency.

Test Data Management & System Testing

oDesigned and prepared customized test data (NAPS Policies) to support unit testing based on development requests.

Report test coverage and automation progress weekly to leadership and Scrum Master, contributing to agile metrics and targets.

Test Specialist, 12/2007 to 10/2014

IBM India. – Columbus, United States

Nationwide Insurance: Duration: Jul-09 to Oct-14

Telematics – Smart Ride Program: Telematics Pilot project in Virginia was introduced in December 2010 to provide a 10% vehicle level participation discount to customers willing to install a Telematics Device. Till Date, Nationwide has rolled out Telematics Program in VA (Virginia), OH (Ohio), SC (South Carolina), PA (Penn), MS, KY, GA and AL would like to expand Telematics Program to other states in USA.

New Company Program: Nationwide new Company Strategy is an On-going product and

pricing initiative to focus on helping regions provide steady, profitable growth by opening new

companies while concurrently enhancing renewal features to our long-term customers. In the past, I

have worked on “Georgia New Company” project. Nationwide regular plans for new

company releases every year.

Rate Stability Program – Nationwide’s renewal customers are most profitable customers and

Our pricing research tells us premium changes drive our customers to shop more than competitively.

position. Therefore, Rate Capping was implemented in 2005 to control renewal premium

impacts from rate change activity. This project has helped us control customer rates when large

initiatives introduced a variety of rate swings to customers. This is currently implemented in PA

WV and TX states for Nationwide.

Responsibilities:

Requirements

oAttend project meetings as appropriate, such as Kick-Off meetings, Weekly Status meetings, Requirements Walkthroughs, Defect Triage meetings, Project Test Plan Peer Reviews, System Test Entrance and Exit Criteria reviews.

oUnderstand the requirements for assigned tasks within the project.

oIdentify unclear or incomplete requirements and communicate issues to the Test Lead and Requirements Analyst via email.

Test Preparation

oDevelop customized test data (NAPS Policies) and configure the test flow for Unit Testing based on NAPS Development Email Requests. Ensure policies are prepared prior to System Testing.

oDesign detailed Test Scripts and Scenarios that trace directly to Business Requirements, ensuring comprehensive end-to-end coverage.

oIncorporate Business-Critical Scenarios provided by the Business Analyst into the Test Plan.

oUpload and maintain the Test Plan on the project server for team accessibility.

oDocument the Test Strategy, including Project Summary, affected Companies and Products, etc.

oPresent and discuss the testing Approach, Standards, and Procedures with the Peer Review and Business Teams. Incorporate feedback and make necessary revisions.

Test Execution

oExecuted Test Plans and Test cases according to Project schedule and report Defects using HP Quality Center. Defect Management and Tracking using through Mercury Quality Centre 9.0.

oResponsible for saving and sending data to the downstream area for their System Testing.

oResponsible to communicate Test Project status, Resolve and Escalate issues and ensure effective End to End Testing.

oComplete the UAT / UET checklist and send it to the UAT / UET Analysts prior to UAT / UET Testing.

oCommunicate System Testing Sign OFF at the end of System Testing to the Project Team, upload the Test Plan in the Release Website after system Testing Sign Off.

oResponsible for carrying out Production Validation. Also responsible for validating defects, those are under the Production Warranty support.

oResponsible for carrying out First Day reviews and testing the first 10 Production policies, if the analyst is assigned to New Company Project.

American Express, Phoenix, USA Onsite Duration: May-07 to Jul-09

Project Title: IT Service Catalog - Onsite Test Coordinator

Project Description: IT Service catalog provides a central tool to expose and track all service

requests. American Express IT service catalog is in the process of migrating all the existing services

currently requested and fulfilled using American Express legacy tools to web-based site IT service

Catalog. It will also allow the customer to track the status of service requests. Shorten the end-to-end time

needed to deliver the service to Customers.

Project Title: B2B Purchasing Portal (American Express) – Test Lead

Project Description: The B2B Purchasing Portal is an initiative as part of the “Savings@Work” platform by Amex to build and leverage the need for a shopping portal specifically catering to its small and

medium corporate customers. The Savings at Work will provide Corporate Clients and

participating Merchant Partners with a compelling, unique opportunity for comparison shopping and

purchasing. Through this portal Amex is bringing together its customers and big merchants (Target,

Staples, Office Max, etc.) by leveraging its existing relationship. The Portal gives the merchants bigger

footprint to showcase and sell their products competitively at discounted rates. It gives the customers the ability to do comparison shopping through a secure, trusted and industry-accepted payment gateway provided by Amex. In this process, Amex can generate increased spending and also cross-sell its other products and service offerings.

Previous Experience, 2000 to 2007

Bangalore, India

Education

Bachelor of Engineering (B.E): Electronics & Communications

Gulbarga University, KARNATAKA India

Contact this candidate