Sunita Bhandari

Email: adfl8x@r.postjobfree.com

Phone: 518-***-****

PROFESSIONAL SUMMARY

●Over 8 years of IT experience in testing with emphasis on Quality Assurance, Manual Testing, Test Automation Frameworks using Selenium with Java, UFT, System testing of Web - based, large client, Multi-tier applications

●Expertise in performing various types of testing such as Integration, Regression, Smoke, Sanity, Functional(Black /Grey box), System, UAT, Database and End to End Testing.

●Domain knowledge in Personal Lines Auto, Property and Casualty Insurance, Banking, Healthcare, Retail and HCM Software

●Excellent grasp of the Software Development Life Cycle(SDLC), Software Testing Life Cycle(STLC), Waterfall, Agile (SCRUM) and Onsite-Offshore based development model

●Hands - on experience in the preparation of Test Plans, Test Cases, Test Reports, Requirement Traceability Matrix(RTM)

●Good understanding of Object Oriented programming Concepts(OOPS) and Java skills

●Proven ability in designing and developing data driven and hybrid test automation frameworks like Page Object Model/Page Factory for Java based applications using TestNG, Selenium Webdriver, Cucumber, Maven

●Experience in Cross browser testing across different browsers like Google Chrome, Mozilla Firefox, Safari and IE using WebDriver

●Proficiency in analysing, understanding, creating and updating XML and JSON format for validating request and response for the web services

●Expertise in creating customizable reports using TestNG and Extent Framework

●Expertise in writing SQL queries for different databases like DB2, SQL Server and MySQL

●Experience in manual and automated testing of Web Services and REST API using Postman and Restful API

●Experience in testing web and mobile applications on iOS and Android OS

●Experience of working with CSRs and Product Owner to re-create Production issues in test environment and create defects

●Proficient in using defect tracking and Test management tools like Remedy, Quality Center/ALM, Bugzilla, Rally

●Proficient in identifying the issues and creating detailed documentation

●Strong time management skills, ability to plan and prioritize workload

●Excellent communication skills, self-motivated, quick learner and active Team Player

EDUCATION

Master in Software Engineering, BITS Pilani, Rajasthan

TECHNICAL SKILLS

Testing Tools

Selenium WebDriver, TestNG, Selenium IDE, Selenium Grid,, UFT, Cucumber, Appium, Postman, SOAPUI, REST Assured

Technologies

Core Java, REST, HTML, CSS, JavaScript, SQL, XML, JSON

Testing Methodologies

Data Driven, Keyword Driven, Hybrid, Page Object Model (POM), Page Factory

Databases

DB2, Oracle, SQL Server, QMF, Toad, MongoDB

Test Build & Integration Tools

Maven, Jenkins, AutoSys

Defect Tracking Tools

Remedy, Quality Center / ALM, Bugzilla, Rally, JIRA

Operating Systems

Windows, Linux, Unix, iOS, Android

Project Management

Outlook, Word, Excel, PowerPoint, Visio

Other Tools

Eclipse, Git, GitHub, SVN

PROFESSIONAL EXPERIENCE

Wells Fargo, San Francisco, CA (Feb 2020 - Till Date)

Senior QA Analyst

Project: CEO Portal for Wholesale business enrollment

A brand new application is developed that will aggregate the customer profile, products, accounts and user entitlements for the wholesale business customers. My primary responsibilities is to perform system analysis to develop the test scenarios and execute functional and end-to-end testing for the new application. Also, test the moderate to complex enhancements to the existing enrollment applications.

Responsibilities:

●Worked in Agile model with 2-weeks release cycles and participated in Sprint planning and Agile Scrum meetings on a daily basis.

●Reverse engineered the various existing enrollment systems and downstream applications to document the current functionality and business flow. Created a matrix with all the mandatory and optional fields to be displayed in the new application.

●Worked with the Product Owner, SME and Development team to perform system impact analysis and developed the test scenarios for the initial rolled out products.

●Created MongoDB aggregation pipeline and SQL queries to validate the database updates.

●Performed API testing to validate the restful API services developed for the new application.

●Developed the brand new ALM structure for creating test cases.

●Performed various types of testing like Functional(Black/Grey box), Integration, System, Smoke, Sanity, End-to-End and Regression.

●Performed end to end testing for the complex project that implemented the request key to be part of new users enrollment to Product for the new or existing companies.

●Worked on multiple moderate to complex enhancements to the existing online enrollment applications as part of the monthly releases.

●Created data driven automated regression test suite including happy/critical path end to end test cases for QA and Pre-production environment using Selenium WebDriver, TestNG, Maven.

●Logged and tracked defects to closure using HP ALM and JIRA.

●Responsible for providing the daily status of test cases execution and the defects to the project team.

Environment: Java, HTML/CSS, Selenium Webdriver, TestNG, Eclipse, Extent Reports, Apache POI, Data Driven and Page Object Model Framework, SQL Developer, Oracle, MongoDB, MongoDB Compass, Maven, Agile/Scrum, JIRA, HP ALM, Agile Central

TD Bank, Florham Park, NJ (Feb 2018 - July 2019)

Senior QA Analyst

Project: Online Personal Banking

TD Bank is a banking and financial services company. As part of this project, online personal banking was redesigned to create an intuitive dashboard using quick links for faster access and better customer experience. Also, enhanced the Bill Pay module for the users to be able to access the features directly such as Add/Modify Payee, Pending Payments, View/Edit/Cancel your pending payments directly. My primary responsibilities were to perform functional and end-to-end testing and develop the automation scripts for the new personal banking webpage and Bill Pay features.

Responsibilities:

●Worked in Agile model with 3-weeks release cycles and participated in Sprint planning and Agile Scrum meetings on a daily basis.

●Interacted with the Business Analyst, Product owner and front end and backend developers to understand the existing application design and functionality.

●Estimated testing efforts, help lead prioritize projects, plan implementations and rollout changes.

●Analysed the user stories and created detailed Test Plans and Test Cases in JIRA.

●Performed various types of testing like Functional(Black/Grey box), Integration, System, Smoke, Sanity, End-to-End and Regression.

●Worked with application SME and Product Owner to identify business critical end to end test cases and prepared automated Regression test cases for the UAT environment.

●Performed feasibility study for the manual test cases that can be automated for future Sprints.

●Developed automated regression test suite including happy/critical path end to end test cases for QA and production environment using Selenium WebDriver, TestNG, Maven. The script was run as part of sprint CI/CD pipeline.

●Performed batch testing by creating multiple .bat files and scheduled them to run daily.

●Performed Parallel, Cross browser compatibility testing on Chrome, Firefox, IE, Safari browsers using Selenium Webdriver, TestNG and Selenium GRID.

●Performed mobile testing by accessing the online banking webpage and new features in different browsers in latest Android, iOS phones and tablets.

●Worked closely with the Jenkins team to ensure the integration of the test automation scripts for timely executions.

●Performed backend database testing by creating and executing SQL queries to validate data in the Oracle tables.

●Logged and tracked defects to closure using JIRA.

●Conducted meetings with product managers, developers, Stakeholders and other QA members to review the defects and their status.

●Reported the daily status of test cases execution to the team and manager.

Environment: Java, HTML/CSS, Selenium Webdriver, TestNG, Eclipse, Extent Reports, Apache POI, Data Driven and Page Object Model Framework, SQL Developer, Oracle, Maven, Agile/Scrum, JIRA, Jenkins

ADP, Roseland, NJ (Sep 2016 - Feb 2017)

Senior QA Analyst

Project: ADP Workforce Now

ADP's Workforce Now is a SaaS HCM product suite that allows employers to manage their workforce. The product has numerous modules such as HR, Payroll, Talent Management. As part of this project, following major HR features were implemented: Redesigned New Hire Wizard, Quick Hire Wizard and Employee Rehire.

Responsibilities:

●Worked with the Product Owner and Development team to gather project/application related information and developed test scenarios.

●Developed detailed Test Plans and Test Cases based on the User stories

●Conducted walkthrough meetings with scrum team to review Test plan and Test case

●Performed GUI validation on various new hire fields introduced as part of New hire, Quick Hire and Rehire wizards.

●Performed Functional, Smoke, Integration and Regression Testing

●Used Postman to manually validate request and response in test Quick Hire API

●Developed automated regression test suite for QA and IAT environment using Selenium WebDriver and TestNG

●Used Data Driven/Page Object Model Framework to fetch new hire data from Excel files using Apache POI

●Used Jenkins as continuous integration tool to execute automated test suites

●Developed and executed automated Rest Assured API test cases to test Quick Hire API

●Used Maven for build and dependency management to add different dependencies such as apache poi/TestNG/Maven-plugin-api/log4J

●Created SQL queries using SQL Developer to validate data in various Oracle tables such as Employee, Position, Salary, Tax Arrangement, Tax tables.

●Used Extent framework to generate customized test execution status reports including screen shot of errors, for automated regression test suite

●Performed Cross Browser and parallel testing to test the new hire features are working as desired in different browsers

●Performed Mobile Testing by executing Appium scripts by accessing the new features in different browsers in latest Android and iOS phones.

●Logged, reported and tracked defects using Rally

Environment: Java, HTML/CSS, Selenium Webdriver, Selenium Grid, TestNG, Eclipse, Extent Reports, Apache POI, log4J, Data Driven and Page Object Model Framework, Appium, SQL Developer, Oracle, Maven, Agile/Scrum

Highmark, Pittsburgh, PA (Sep 2014 - Aug 2016)

QA Analyst

Project: Medicare Applications Development

Member 360 is a web based health-care application that maintains member data and provides various features such as process enrollment, dis-enrollment, and eligibility check for member’s Medicare. As part of this project, Member 360 application was set up and implemented for a new Client.

Responsibilities:

●Analyzed Business Requirements document to develop Test strategy and Test scenarios.

●Actively interacted with the Business Analyst, Highmark SME and development teams to understand Business Process, application functionality and requirements.

●Developed detailed Test Plans and Test Cases for integration and QA environments.

●Verified new DB2 tables created for the client’s members and also set up the test data in these tables in QA and UAT region for testing purposes.

●Performed different types of manual testing like Functional, Smoke, GUI verification, Regression, Integration, System, Database and Correspondence content verification.

●Worked with UAT to create and execute End-to-End test cases covering multiple business Transactions such as enrollment of new member, processing dis-enrollment due to multiple reasons(Non payment, eligibility check failure), verifying database updation, enrollment/dis-enrollement correspondence letter generation(PDF), existing member requesting changes to their data, CMS feed generation

●Preformed Cross-Browser Testing using Google Chrome, Internet Explorer, Firefox, & Safari

●Developed data driven automated test suite using Selenium webdriver, Page Object Model and TestNG to perform daily health check of the application and generate status report emailed to distribution.

●Created SQL queries in TOAD to retrieve and validate data for the new member and existing member updates.

●Performed bulk database verification testing for initial one time load of all the existing client’s members into Member 360 database.

●Performed batch jobs verification for the weekly/monthly batch jobs to update member enrollment data in the database.

●Used Bugzilla to create and track the defects. Created daily test execution status and defect status reports sent to

●Conducted weekly meetings with Developers, Product Managers, leads and other QA members to review the open defects.

Environment: Java, HTML, CSS, Javascript, Selenium, TestNG, AutoSys, Apache POI, log4J, Eclipse, DB2, Toad, Maven, Waterfall

Stop & Shop, Rocky Hill, CT (April 2013 - Aug 2014)

QA Analyst

Project: Online shop / Express shop

Stop & Shop is a chain of supermarkets located in the northeastern United States.This project involved ongoing maintenance of existing applications and developing new functionalities such as webpage for viewing the private brand’s catalogue and enhancing the features in Online shop and Express shop module . As part of this project, I performed manual testing and developed automated test scripts

Responsibilities:

●Analyzed the SRS (System Requirement Specifications) and developed Test Cases, Test Scripts to cover overall quality assurance testing.

●Actively participated in the Review Meetings for Functional Specifications Document and Technical Design Documents

●Created test cases and test scripts and developed Requirement Traceability Matrix to match the requirements

●Involved in manual testing of front end functionality, hyperlinks, navigation, GUI and system integration testing of the application.

●Performed Smoke testing to check the High level functionality of the application after each build.

●Performed functional testing to identify various critical points in the application and automated it by using Selenium WebDriver.

●Created automated test Scripts to validate the functionalities of frontend web applications using Maven, Eclipse, Selenium WebDriver, JAVA.

●Performed end to end testing and executed regression test cases for each production release.

●Created an automated test suite to perform the health check in production daily.

●Performed data validations at various levels to check the data integrity, and conducted database testing by executing complex SQL.

●Logged and tracked defects in HP Quality Center.

●Participated in Weekly team meetings and walked through to discuss open defects and provide the testing status.

Environment: Windows, Java, HTML, CSS, Selenium, JUnit, Apache POI, Eclipse, Oracle, Toad, Maven, HP Quality Center, Waterfall

The Hartford, Windsor, CT (June 2010 – March 2013)

QA Analyst

Project Description:

QTI is a web based Quote to Issue application available for Hartford Agents to create Quotes and issue Auto and Homeowners Policy for AARP members. As part of this project, PCC(Policy Change Center) application was developed allowing Agents to submit change transactions for existing Auto policy members, which reduced the manual work load of Hartford Customer Service Reps. Also, new Screens and transaction flow was developed to process policy change transactions for AARP Homeowners members.

Responsibilities:

●Followed Waterfall Methodology from project initiation to closure.

●Involved in analyzing System Maintenance Technical Document (SMTD) and System design specifications for existing Mainframe applications used by CSRs to process Auto policy changes, identified and developed Test scenarios and Test cases to ensure complete test coverage.

●Worked with the project team to update the Requirement Traceability Matrix with test cases.

●Set up multiple walkthroughs with Business Analyst, Application SME, Developers, and State Product Owners to review the end-to-end test scenarios for various states.

●Performed manual verification of all the fields present on multiple UI screens by initiating multiple policy change transactions.

●Tested and verified multiple policy change transactions by executing them parallely on existing Mainframe applications and PCC to compare the data/flow between two applications.

●Created and managed UFT Test Scripts with check points using regular expressions based on the Requirements and Scenarios.

●Conducted Data Driven Testing using parameterization in UFT to test the application with different sets of data.

●Tested Web Services, Validated Request and Response XML, SOAP Calls, Restful calls and WSDL using SOAPUI tool created for the Agents to retrieve and verify existing Policy member information using different search criteria such as policy number, Insured Name, THF id.

●Developed automated test scripts using descriptive programming in UFT.

●Created user defined and custom functions using VB scripting.

●Created a Hybrid Framework of automation for the application using VBScript coding in UFT.

●Enhanced existing libraries, test cases and updated the existing test regression cases as per new changes in application such as include transactions for new States being rolled out after every quarterly release.

●Queries in QMF and Toad to retrieve and create test data in QA and UAT databases.

●Performed Cross Browser testing on IE and Google Chrome.

●Created and executed the batch jobs to verify data updates in Mainframe DB2 tables.

●Co-ordinated test execution activities with offshore team and scheduled daily sessions to review the updates, issues or roadblocks and update the team about any requirement changes/updates.

●Worked with UAT to help developers re-create production issues in QA environment.

●Created detailed defect reports describing the step by step with screenshot for the failed transactions.

●Used Remedy and Quality Center/ALM to log and track defects.

●Identified multiple production issues in the existing QTI and Mainframe applications, created production incidents and informed the respective application maintenance team.

Environment: Java, HTML, CSS, UFT, Mainframe, JCL, DB2, QMF, SOAPUI, REST API, Toad, Eclipse, Maven, Remedy, HP Quality Center / ALM, Waterfall, Onsite-Offshore model

Contact this candidate