Prasanna

Senior QA Analyst

ady609@r.postjobfree.com

609-***-**** EXT 105

PROFESSIONAL SUMMARY

A highly efficient, methodical, and talented Senior Software Quality Assurance Analyst with 12+ yearsof professional experience in all the phases of the Software Testing Life Cycle (STLC), developing Test Cases, Test plansfor Manual in domains of Healthcare, Retail, Financial servicesutilizing Agile and Waterfall methodologies.

Expertise in Software Development Life Cycle (SDLC) and Test Development Life Cycle (TDLC).

Strong knowledge in implementing Waterfall and Agile (Sprint/Scrum) Methodology by analyzing requirement specifications and responsible for developing Test Objectives, strategies, Scope, Test procedures,and Test Matrices.

Hands-on experience in Quality Assurance including Functional, System, Smoke, Regression and Integration, User Acceptance Test (UAT), and Compatibility Testing of Web and Client server-based Applications.

Experience in Manual testing, and backend DB testing.

Strong working experience in GUI testing, testing, Positive & Negative testing, Boundary Value testing, End to End testing.

Reviewed and designed Test Scenarios and Test Cases in full Software Development Life Cycle.

Experience in writing System test plans, defining test cases, developing, and maintaining test scripts.

Prepared Test and Defect Summary reports using bug-tracking tools like Jira, Rally, and Quality Center.

Good exposure in writing SQL Queries to test backend and compare the database data with UI.

Worked closely with project stakeholders and SMEs to understand the requirements and specifications for new/existingapplications.

Experience in performing Risk assessment and Gap Analysis.

Involved in designing and Creating TDD, and Process Packs, BRD, implementation and Defect Management.

Experience in using Selenium Grid and Selenium Webdriver.

Involved in Cross Browser testing using selenium Grid.

Developed XML test data and implemented Functional and Data-Driven tests using SOAPUI.

Experience in functional testing of SOAP and REST API using SOAPUI Tool. Validated Request and Response in XML, and JSON formats.

Good experience in Documentation with MS Office Tools like MS Word, and MS Excel used to write Test Cases

Ability to articulate Test strategy and concepts to both high-level business audiences and technical individuals.

Training included claims processing, benefit interpretation and providing world class customer service to members and clients

Excellent analytical, problem-solving, and communication skills and a strong ability to learn new tools and technologies in a short span and implement them independently.

Card- Position: Claims Processing - Interplan claims processing. Blue Card

Responsible to make sure all previous claims processes were adhered to and adjusted correctly according to fee schedule and provider affiliations. System

An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hardworking, and a high level of motivation. A quick learner with an aptitude for taking responsibility.

TECHNICAL SKILLS

Development methodology

Agile/ Scrum, Waterfall

Artifacts

Test Plan, Test Case, RTM, Test Summary Report, Bug report

Mobile testing

Appium

Bug Management Tools

Quality Center -10.0,JIRA,ALM,Version One, Rally

Programming Languages

Java, HTML, Dot Net, XPath, CSS, Soap, WSDL, Restful, Gherkin

Database/Database tools

SQL Server, Oracle, MySQL, Toad, SQL

Operating Systems

Windows 07.XP, UNIX.

PROFESSIONAL EXPERIENCE

Client: State Farm Insurance, Chicago, IL Sep 2022 – Present

Role: Senior QA Analyst

Project Description:

This application was developed in Java and Consisted of three main modules: Query, Policy, and Rate Quote. The Query model was the interface with the insurance agent to query the database and generate customizable reports. The Policy module concerned the various insurance sectors including, Auto, Life and Fire insurance. The Rate Quote module provided rates and payment terms, funding and protection options, and coverage details for the various types of insurance.

Responsibilities:

Analyzed business requirements and functional documents, created the test strategy document that define the test environment, phases of testing, entrance and exit criteria into different phases of testing and resources required to conduct the effort.

Responsible for working within a team to create, document and execute testing strategy, test plans,test cases and test scripts in support of a set of global tools, systems, and databases.

Involved in Sprint planning, Review Sessions, Scrum meetings. Developed Test Scenarios, Test Cases, Test data, Test procedures, Test reports.

Used Selenium Grid to run test cases in multiple browsers and different Platforms.

Extensively worked in Regression testing, Parallel Processing using Selenium Web-driver.

Responsible for reviewing the test scenarios with business and developers.

Worked on distributed test automation execution on different environment as part of Continuous Integration Process using Selenium Grid and Jenkins.

Developed test scripts for Web elements by identifying the locators using Firebug and Fire-Path Firefoxplugins.

Performed Cross Browser Testing using Selenium Grid and have written various driver methods in the automation script to communicate with multiple browsers.

Developed Behavior Driven Development(BDD) framework using cucumber.

Implemented Page Object Model Automation framework with Java, Selenium Web Driver.

Automated functionality to read data from external source such EXCEL, Properties File.

Created automation scripts using Selenium Hybrid and Data-driven developmentframework.

Developed Back-end testing using SQL queries to retrieve the user information to cross validate inUI and databases.

Analyzed test results, tracked the defects, and generated reports using JIRA.

Prepared the data to cover various scenarios and wrote SQL scripts to verify the database updates.

Maintained continuous test integration and automatic build by using Jenkins and mailed the buildoutputs to the team members.

Followed Agile testing methodology, participated in daily status meetings and testing eachdeliverable.

Performed benefit coding for benefit changes and mandates in claims application.

Experience in testing of Blue card claims (Blue2) both ITS Home and ITS Host, strong knowledge of Blue square application including Claims.

Recording all defects, create and distribute reports outlining the types of defects found and the steps taken to resolve these issues.

Environment: JAVA, Eclipse, Selenium Web Driver, Maven, Log4J, Cliams, JIRA-TM4J, Postman, SQL Server Management Studio, JIRA, Selenium Grid, Blue card

Client: Anthem,Texas Dec 2021 – June 2022

Role: Senior QA Analyst

Project Description:

Atlantic Health is a health organization with multiple branches in the US. The project is on a claim System thatallowschecking Insurance coverage, collecting payments from an insurance provider, uploading paperwork, and getting patient visit history to keep track of the patient’s records. It provides a dynamic solutionthat enables hospitals to improve the workflow by re-organizing their processes acrossvarious departments and different enterprises.

Responsibilities:

Analyzed application business requirements, technical specifications, and Installation guidelines.

Planning and Developing test plans, and test casesforapplications which include integration, regression, and smoke testing.

Requirements analysis, working with a business team and development team to understand the detailed requirements

Participated in Sprint planning and handled Test Planning and test case reviews in qTest in Agile.

Identify bottlenecks and bugs, and devise solutions to these problems

Responsible for reviewing the test scenarios with business and developers.

Recording all defects, creating and distributing reports outlining the types of defects found and the steps taken to resolve these issues.

Database testing for validating the recorded data and system settings using SQL queries.

Follow and practice Agile software development methodologies.

Validated request and response JSON in Web services using REST API service.

Ability to write clean, readable, and reusable Java code/libraries.

Environment:SQL Server Management Studio, Oracle, Qwest, Excel.

PROJECT-II

Client: Atlantic Health, Morristown, NJ May 2020 – Oct 2021

Role: Senior QA Analyst

Project Description:

Atlantic Health is a health organization with multiple branches in the US. Project is on claim System which allowschecking Insurance coverage, collecting payments from an insurance provider, uploading paperwork, and getting patient visit history to keep track of the patient’s records. It provides a dynamic solutionthat enables hospitals to improve the workflow by re-organizing their processes acrossvarious departments and different enterprises.

Responsibilities:

Analyzed application business requirements, technical specifications, and Installation guidelines.

Developed and maintained automated regression test cases in Selenium Web Driver using Java programming language

Created automation framework in Selenium WebDriver using a behavior-driven approach like Cucumber.

Wrote and executed test cases for major program modules as per Business Requirement Documents

Performed System, Integration, Smoke, Sanity, Functional, End to End, Positive and Negative and monitored the behavior of the applications during different phases of testing using testing methodologies.

Designed, coded, and executed automated tests using Java/TestNG-based test frameworks.

Designed and executed the Automation Test Scripts using Selenium Web Driver, Selenium IDE, and TestNG.

Designed and developed Page Objects using POM Model and Hybrid Framework.

Used Firebug/Fire Path Add-on tools to identify the Object's id, Name, XPath, and link in the application.

Used Apache POI to retrieve test data from Excel files.

Performed Data drove testing using Selenium Web Driver, TestNG functions, and JDBC Connections which reads data from scripts using property and XML files.

Tested REST web services using the different assertions like HTTP assertion, security assertions, XPATHassertions in SOAPUI

Implemented Page Object Model Automation framework with Java, Selenium Web Driver, and Cucumber.

Performed usability, GUI, Functionality, and regression testing of the new builds

Used GIT as the version control tool for the source code. Performed merge conflicts, and fork operations using the Git repository

Extensively worked in locating a web element using ID, name, class name, CSS selector, and XPath

Actively participated in QA team meetings and discussions. Participated in Sprint planning and Agile Scrum meeting on daily basis.

Environment: Java, Selenium Web Driver, Cucumber, Eclipse, Appium, TestNG, Jenkins, Maven, SOAP UI, Oracle 11g, Rally, HTML, XML, Xpath, Apache POI, Gherkin, JavaScript, GIT.

PROJECT-III

Project: Rebranding

Client: Dealer track, NY Dec 2017 to Dec 2019

Role: Sr. QA Analyst

Project Description

Dealer track Inc. headquartered in New York is a leading provider of on-demand software and data solutions for automotive retail in the United States. In recent times Dealer track acquired many companies like Trevin, JM Solutions, Arkona, etc. To identify and resolve branding violations in facing customers (UI) of different products which were originally owned by different organizations and that are acquired by dealers track rebranding project was implemented. The main agenda of the project is to provide a unique look and feel for the customers.

Responsibilities:

Assessed & analyzed user stories and participated in Sprint planning, Review Sessions &Scrum Meetings

Developed Test scenarios, Test cases, Test data, Test procedures, and Test reports.

Involved in creating Test Cases in order hit each functionality and data point based on the Functional Requirement Document.

Involved in various testing when the code was dropped into the QA environment.

Performed Smoke testing, Functional testing, Regression testing, Integration testing, Boundary testing, Positive and Negative testing, and was involved in System testing.

Conducted walk-through meetings to understand the requirements and provided feedback and suggestion to the Business Analyst.

Assisted Business Analysts in creating the Requirement Traceability Matrixto map the test case to the functional requirements documented in the Functional Requirement document.

Working knowledge of Software Development Life Cycle (SDLC), having a thorough understanding of various phases like Requirements, Analysis/Design, Development, and Testing.

Involved in Writing Test Plan documentsand involved in designing templates.

Incorporated and followed Agile methodology in the Software Development Life Cycle.

Performed black box testing, database testing, and web-based testing on several test phases.

Performing data analysis and data validation by writing complex SQL queries.

Reviewed database test cases according to assigned Requirements to validate reports by retrieving data, updating, insertion, and deletion of complex SQL queries from the oracle database.

Involved in Validating the Data while data Migration from the initial stage tothedata warehouse.

Involved in Web services testing using SOAPUI Tool. Validated request and response XML. Added assertions to validate the XML in Web services SOAP and REST API service.

Interacted with the development configuration and operation team to ensure the quality of software to user expectations.

Executed Test cases and reported the defects in Bug tracking tool JIRA.

Experience in Writing Test Scripts for Automation and involved in Automation testing using Selenium.

Participated in Release Review/Requirement Analysis and Design review meetings.

Environment:Jira, SQL, Microsoft Office, SoapUI, Oracle, Test Cases, Test data, Windows, Agile.

PROJECT-IV

Project: Default and Recovery

Client: Standard and poor’s, NY Dec 2015 to Sep 2017

Role: Senior QA Analyst

Project Description

Standard & Poor’s is a leading provider of financial market intelligence. The world’s foremost source of credit ratings, indices, investment research, risk evaluation, and data, Standard & Poor’s provides financial decision-makers with intelligence. The Default and Recovery have two modules called Creditpro as DR1 and Data Management tool as DR2. Creditpro is used to get the default and recovery rating information for the Issuer, Instrument, Structure Finance, and Sovereign across geographies, regions, industries, and sectors.

Responsibilities:

Understanding client requirements and system functionalities to develop test cases for the complete functionality of the application.

Involved in Requirements walkthrough with the Product team and Knowledge transferring the same to team members.

Actively took part in Sprint planning meetings and discussed the features which would be built in the sprint.

Wrote test Plans, test Cases, and test scenarios using MS Office Suite and test Management tools.

Made use of share point to upload the Test Cases and Test plans.

Involved in analyzing the Manual test Cases for Automation.

Performed Daily smoke Test Manually on different browsers (e.g.: Firefox, Safari, and IE)

Performed Black box and white box testing.

Reported daily status in the Scrum meeting.

Involved in Executing test cases and reporting the defects in the defect tracking tool.

Coordinated the User Acceptance testing with the end users.

Maintained traceability Matrix to ensure all conditions are covered in the test cases.

Responsible for performing Smoke, sanity, regression, re-testing, and functional testing of the application.

Wrote custom reports and reported status and issues to the Project Manager.

Performed defect logging and tracking using Rally.

Provided test summary documentation and analyze test results, identifying trends and/or root causes of problems.Involved in Bug- triage meetings if necessary.

Performed back-end testing by writing and executing queries to validate that data is being populated in appropriate tables and manually verify the correctness of the data with front-end values.

Performed database testing to validate the schema, validate the data, and validate data Integrity.

Environment: Agile, Microsoft, BDD, Cucumber, Share point.

PROJECT-V

Project: Billings and Payment Systems

Client: SkyWest Airlines, UT Aug 2013 to Nov 2014

Role: QA Analyst

Project Description:

SkyWest Airlines is a North American airline owned by SkyWest, Inc. and headquartered in St. George, Utah, USA. This project was to create a web application for an e-Commerce Website and Web services for customer billing.The Billing and Payment application needs to interact with the legacy system to maintain synchronization between the two systems. The main business flows implemented are Establishing and billing the down payment process, creating a Billing Account, InitiatingaPayment Process,SuspendingtheBilling Process and choosing the method of payment, and Make Payment.

Responsibilities:

Wrote test Plans, test Cases, and test scenarios for monthly releases using MS Office Suite(Word, Excel, PowerPoint)

Analyzed code to perform white box testing.

Involved in Regression testing of several Code changes or new functionality implementations in the SIT (System Integration Testing) environment of the application.

Coordinated the UAT testing process with business users and cross-functional development teams for the proper execution of UAT and also prepared the required test data for business users.

Identified the Test Cases and documented them in Quality Center.

Maintained Test Matrix and Project Matrix using an excel sheet to keep track of the Project schedule and status.

Maintained existing QTP scripts written for functional testing and enhanced the existing keyword-driven framework to meet the current need and to have an effective automation suite in accomplishing optimal results.

Used record and playback options to capture the objects in QTP automation.

Wrote SQL Queries to connect to the database and retrieve data for a specified set of test requirements.

Documented and tracked test scripts, and test results and reported test defects in QC.

Environment:Manual Testing, QTP automation, HP Quality Centre, VBScript, SQL, MS Office suite

PROJECT-VI

Project:Medical Record Management System

Client: St. Joseph’s Hospitals, IN Jan2012 to July 2013

Role: Software Test Engineer

Project Description:

The project is to develop software for a hospital maintenance system. It consists of Administration, Patient Information, inquiry, Billing, Blood bank, Pharmacy, ICU and Security, and Inventory Modules. The administration Module is to maintain database backup and password security, Patient information module maintains all details about every patient starting from admission to discharge. The inquiry module gives information about the availability of beds and rooms of different categories and fixes appointments with doctors. The blood bank and pharmacy module maintain information about blood and drugs respectively. ICU module handles allotment of ICU. This also had Inventory and billing modules.

Responsibilities:

Understanding the Business requirements, Application and function specifications, and Design documents.

Involved in writing and designing templates for the Test Plans and Test cases.

Involved in the Preparation of Test Scenarios and review of Test Cases.

Involved in updating and executing test cases according to requirements.

Identified the Test Cases and documented them in Quality Center.

Performed GUI, Functional, Negative, Positive, Regression, and User Acceptance Testing.

Prepared various reports based on different stages of Testing.

Involved in Bug reporting and bug tracking using QC.

Updated Reports and dashboards to display the status of test coverage including the number of test cases passing, failing, or pending.

Interacted with developers, users, and various members of the team to discuss issues, resolve defects, and set priorities.

Highly Involved in Managerial Meetings and attended various conference calls at different levels from QA, Developers,and Clients.

Environment: JSP, Servlets, SQL Server7.0, Windows XP, Manual Testing, MS-Excel, QC.

PROJECT-VI

Project: Inventory Management System

Client: Genpact Pvt, Ltd., IN.June 2008 to Nov 2011

Role: Software Test Engineer

Project Description:

The Project is to test software for the GE Inventory Management system. It consists of Equipment information, serial number, manufacturing date, expiry date, warranty, inquiry, ship-to, and Bill-to. The equipment module contains different types of machines and the usage, Serial number of the equipment. The inquiry module gives information about the availability of Equipment, and the cost of the equipment.The warranty contains a start date and an end date. Ship-to and Bill-to have a street address, city, and Zip code respectively.

Responsibilities:

Understanding the Business requirements, Application and function specifications, and Design documents.

Involved in writing and designing templates for the Test Plans and Test cases.

Involved in the Preparation of Test Scenarios and review of Test Cases.

Involved in updating and executing test cases according to requirements.

Identified the Test Cases and documented them in Quality Center.

Performed GUI, Functional, Negative, Positive, Regression, and User Acceptance Testing.

Prepared various reports based on different stages of Testing.

Involved in Bug reporting and bug tracking using QC.

Updated Reports and dashboards to display the status of test coverage including the number of test cases passing, failing, or pending.

Interacted with developers, users, and various members of the team to discuss issues, resolve defects, and set priorities.

Highly Involved in Managerial Meetings and attended various conference calls at different levels from QA, Developers, and Clients.

Environment: Manual Testing, Windows,QC, SQL Server, Oracle10g,MS Excel.

Contact this candidate