Vaishali Bhana

QA Analyst (Manual and Automation)

Edmonton, AB

Cell: 424-***-****/780-***-****

E-mail: ac9won@r.postjobfree.com

PROFILE

A competent and result oriented professional with over 7 years of experience in Software Testing & Quality Assurance with blend of Manual and Test Automation.

Well versed with all stages of software development life cycle (SDLC) and agile/Sprint methodologies

Experienced in different types of testing on AUT like GUI, Functional, Regression, System Testing, UAT and Performance Testing.

Experience in Automation Regression Suite for UI and Middleware of large and complex application.

Experience in Database Testing using SQL Queries with multiple Databases Oracle, SQL Server, and MySQL and performed Database testing including data integrity and data validation testing.

Reviewed & revised suite of test cases to reflect changes made to the Test Plan, Requirement Base and Product backlog for new functionality and performance issues.

Participated in requirement review meetings, analyzed requirements, test plan and test cases, Requirement Traceability Matrix and Defects.

Excellent knowledge of Software testing Life cycle (STLC) and different testing techniques & methodologies.

Proficient in Automation tools like Selenium, MuleSoft MUnit, QTP (10.0), Test Management Tool – HP ALM, MTM

In-depth knowledge in RDBMS such as Oracle and MS SQL.

Expertise in

oRequirement Analysis

oTest Scenarios

oRequirement Traceability Matrix (RTM)

oTest Cases

oTest Execution

oDefect Reporting and Tracking to closure.

Experience in Defect management and Bug Reporting using TFS.

Experience in managing, mentoring and guiding QA test team members with effective processes.

Experience Planning and scheduling testing tasks and assigning work items to the resources.

Generating issue reports & interacting with the development team to resolve problems and track results/dispositions.

Possess excellent interpersonal, communication and analytical skills with demonstrated abilities in customer relationship management.

PROFESSIONAL EXPERIENCE

1.Deloitte Consulting, Lansing, MI May 19 –Till Date

QA Analyst (Manual and Automation)

Project: HUB integration services

Description:

1.1Hub hosts various web services through IIB ESB.

1.2Hub provides Soap and Rest web services to host and guest systems.

Technology:

1.3Environment: Windows 10

1.4Development Technology: Java, IBM WebSphere, IBM ESB

1.5Testing Technology: SoapUI, Oracle SQL Server, Rational Performance Tester

Roles and Responsibilities:

1.6Prepare and update manual and automation test cases, regression test cases in QA, UAT and staging environment

1.7Perform Rest and Soap API we service testing using SoapUI.

1.8Perform testing in Oracle SQL Server to verify web service response.

1.9Perform testing using RPT for user load and response time.

2.Edmonton Police Service, Edmonton, AB July 18 –Mar 19

QA Analyst (Manual and Automation)

Project: EPROS (Edmonton Police Reporting and Occurrence System) – Niche RMS

Description:

2.1EPROS is centralized RMS (Record Management System) to collect and store occurrence details, arrest details. Separate interfaces build on EPROS known as Gateway and iReporter.

2.2Gateway is used to enter occurrence details, street check and arrest details.

2.3iReporter is used to generate report for approval purpose.

Technology:

2.4Environment: Windows 10

2.5Development Technology: .net, C#, JavaScript, JQuery.

2.6Testing Technology: nUnit

2.7Testing tools: TFS

2.8Framework: .net

2.9Browser: IE 11 and Edge

Roles and Responsibilities:

2.10Prepare Test Plan, prepared and updated manual test cases using SRD/BRD documents.

2.11Prepare and executed smoke test cases, integration, regression, end to end test cases for Niche, gateway, iReporter, EMugs, EPlus applications.

2.12Perform system testing, UAT on Niche, gateway, iReporter, EMugs, EPlus applications.

2.13Log defects in TFS, discuss with business analysts and developers during defect triage meetings.

2.14Review business requirement document, log defects, prepare suggestion list in TFS for future enhancement in gateway, iReporter, EMugs, EPlus.

2.15Identify, and use various occurrence no. from Niche RMS client as test data to test various application functionalities in different test environments.

2.16Tested applications in desktop and web environments.

2.17Prepared and setup automation framework in Visual Studio using CodedUI for regression testing.

2.18Actively participated in test strategy planning, QA planning and evaluate testing tools.

2.19Actively participated in automation framework selection and setting up using Visual Studio for regression testing.

3.Alberta Gaming and Liquor Commission, St. Albert, AB Oct 17 – June 18

QA Analyst (Manual and Automation)

Project: Special Event Licensing

Description:

3.1Special Event Licensing project is developed by AGLC to replace paper form processing for getting liquor licenses for special events. Licensees can be personal, Company, municipality or charitable organization .SEL are required to sell/serve liquor for private events. External vendor has contracted for UI development where middle layer and back end developed in-house. I have been QA Analyst for testing UI, middle layer API, back end and its integration with other system e.g. JDE for payment.

Technology:

3.2Environment: Windows

3.3Development Technology: AnyPoint Studio (Eclipse), MuleSoft MUnit, JDK, SQL Server 2008, REST API.

3.4Testing Technology: AnyPoint Studio, MuleSoft, JMeter (Performance testing)

3.5Testing tools: JMeter, Kayako, team city, Rally

3.6Framework: Mule and ESB

3.7Browser: Firefox, Chrome, IE, IPhone, Android

Roles and Responsibilities (QA Analyst-Manual and Automation):

3.8Prepared manual test cases in Jira using SRD/BRD documents.

3.9Prepared and executed Unit Test Cases and End to End Automated Test Cases in MuleSoft using MUnit for REST API and JSON testing.

3.10Performance testing of Website using JMeter for end user experience during pick load.

3.11Imported test cases from Excel spread sheet into JIRA using Zephyr plugin.

3.12Mapped and linked requirements to test cases in Jira.

3.13Perform JavaScript code review and suggestions using Grey box testing.

3.14Actively participated defect triage meetings with Business Analyst, developers and JDE integrators, suggested future enhancement in application.

3.15Learn and Use Team City as continuous integration and development tool.

3.16Logged and manage UI defects in Kayako (vendor tool) and REST API and backend defects in Rally.

3.17Participated in preparation of test plan and prepared nonfunctional and functional defect report.

3.18Setup automated testing environment using AnyPoint Studio and Maven using JDK.

3.19Setup and integrated Selenium framework with AnyPoint Studio, prepared automated regression test scripts using Selenium WebDriver and POM, data driven testing using CSV.

3.20Prepared test execution report and coordinated with development team.

3.21UI application server hosted in cloud infrastructure by Yellow Pencil.

3.22Finance payment integration testing and verification using TD Bambora.

3.23Prepare SQL queries using SQL server2008 to verify financial transaction and unique transaction through TD Bambora.

3.24Verify and test user transaction using SQL queries.

3.25Perform JDE testing to verify JDE invoices, payment receipts and J/L reports from business perspective.

3.26In QA and UAT environment, verified and tested JDE reports with TD Bambora transaction reports, and SEL database to match daily transaction.

3.27Prepare test cycle in JIRA and test application on various platform including IE, Chrome, IPhone, Android, Firefox.

4.Global TESOL, Edmonton, AB Jan 16 – Sep 17

QA engineer/Developer

Description:

4.1Global TESOL is e-learning company providing various courses and TESOL certification in English learning along with Job opportunities overseas.

Technology:

4.2Environment: Linux (Production), Windows (Development)

4.3Development Technology: Apache HTTP Server, PHP, Moodle, MySQL

4.4Testing Technology: Selenium, Eclipse, JDK 8.0, TFS, JMeter (Performance Test)

4.5Framework: Symphony (Current), Opigno (Drupal), Moodle (Learning Management System)

4.6Browser: Firefox, Chrome, IE

Roles and Responsibilities:

Production Support:

4.7Fixing and supporting existing web application issues.

Developer and QA Engineer:

4.8Responsible for preparing Test Case scenarios, Test Case specifications, Use Case and Process flow documents

4.9Prepare test data, executing tests and verify results and logging issues

4.10Perform manual testing for new functionality, including integration testing.

4.11Prepared and executed automated testing, AJAX components, and batches using Selenium (Eclipse, JDK 8) as part of regression testing for existing functionality.

4.12Current website and new website developed In house.

4.13Setup automated testing environment using Eclipse, JDK, Selenium and TestNG.

4.14Build automated test execution framework for test data creations, script execution and execution report preparation.

4.15Dynamic data injection using MS Excel with Selenium.

4.16Developed and executed automated test scripts from scratch using Selenium Webdriver and TestNG framework for student registration, student course enrollment, and Payment processing, course and exam module. Run batches of test suites using TestNG and XML.

4.17Perform cross browser testing using Selenium for browser compatibility.

4.18Create and update Unix Shell script to extract log information on Linux server (Ubuntu).

4.19Prepared test execution report and coordinated with offshore Development team.

4.20Involved in complete application life cycle i.e. Analysis, Design, Customization, and Testing, debugging, maintenance and support for new website.

4.21Evaluate various platform (Opigno, Moodle) and framework (Drupal, WordPress) for next version of current Global TESOL application and integrate modules for user functionality

4.22Experience in Defect management and Bug Reporting in HP ALM.

4.23Preparing high level and detailed test cases, perform testing in QA and UAT environment.

4.24Executing test cases and logging defects in HP ALM, and identify any workaround.

4.25Writing and executing SQL Queries to perform back end testing of the application.

4.26Managed and supported cloud based infrastructure from “One and One” web host.

4.27Performance Test – Prepared and executed JMeter tool for student registration, course and exam module.

4.28Working knowledge of mobile application development using Android Studio (Java and IntelliJ) and Genymotion emulator and testing using Selendroid tool

5.Vancouver Media Marketing, Vancouver, BC Aug 09 – Dec 15

QA Engineer/Developer

Project # 1: Sales1Up

QA Engineer/Developer

Description:

5.1Sales1Up is an Internet-based, referral and sales system for business owners who want to work more productively, get more clients and close more sales in today’s increasingly competitive marketplace. It is developed using .net technology.

Roles and Responsibilities:

QA Engineer:

5.2Successfully developed Admin module unit test cases using C#

5.3Reviewed program and design specification documents by QA

5.4Reviewed business requirements from QA perspective and provided input to business.

5.5Reviewed program and design specification documents by QA perspective.

5.6Setup the test environment with the help of Technical Team Lead and developer.

5.7Successfully prepared test plan, test design, test environment set-up, manual & automated test execution and test reporting.

5.8Managed traceability of test cases against requirements

5.9Build automation test execution framework for test data creations and test script execution.

5.10Current website and new website developed In house.

5.11Test cycle planning and execution in co-ordination with development team.

5.12Developed the NUnit test cases using C# for main service methods.

5.13Build automation test cases for regression testing using Selenium.

5.14Prepared SQL Script part of Data preparation for Testing script execution and test result verification.

5.15Prepared SQL queries part of Admin module development.

5.16Build SQL Query to verify the data consistency and test data.

5.17Managed and supported cloud based infrastructure for application.

5.18Test Design for each module, detailed test design for each functionality for test cases.

5.19Prepared automated regression test cases using Selenium and C#.

5.20Coordinated UAT testing with Business team.

5.21Prepare UAT test cases.

5.22Prepared manual test cases for Admin module and help module, also prepared integration test cases for modules.

5.23Design and develop test scripts for each module.

5.24Defect report using MTM and TFS.

5.25Defect analysis and prioritizing.

5.26Performance Test – Prepared and execute Load Runner for Business Owners, Referral and clients.

5.27Prepare presentation and report for performance test execution for each web page.

5.28Analyze and reproduced production issues and defects, reported by business, in QA environment.

5.29Tested websites both web (computer) and tablet (mobile) browser.

5.30Managed traceability of test cases against requirements

5.31Environment: Windows 8, Web application

5.32Development Technology: ASP.net, C#, SQL Server 2008, TFS

5.33Testing Technology: Selenium

Project#2: Auto Portal

QA engineer

Description:

5.34The website is a complete car portal with almost all functionality which is available in most of the advanced and popular car portals online like Edmunds.com. It has Admin, dealer and visitor roles and different users have different options available with respect to buying/selling and searching cars through the portal.

Roles and Responsibilities:

5.35Build automation test cases for regression testing using QTP.

5.36Successfully developed and executed unit test cases using C# for main service methods.

5.37Test Design for each module, detailed test design for each functionality for manual test cases.

5.38Reviewed business requirements from QA perspective and provided input to business.

5.39Setup the test environment with the help of Technical Team Lead and developer.

5.40Current website and new website developed In house.

5.41Prepared manual unit test cases for non-critical functionality. E.g. help module.

5.42Responsible for Smoke and Sanity test.

5.43Tested websites both web (computer) and tablet (mobile) browser in test and UAT

Environment.

5.44Prepared SQL Script part of data preparation for Testing script execution and test result verification.

5.45Data preparation using SQL query for SQL Server.

5.46Prepared Insert and Update queries (CRUD) queries for testing data preparation.

5.47Execute the test iterations.

5.48Prepared test plan, test design, test environment set-up, manual & automated test execution and test reporting using C#.

5.49Defect reporting in MTM and TFS.

5.50Identify testing issues with development, specially data related and come up with alternative solution.

5.51Performance Test – Prepared and execute Load Runner for Dealers, Sellers and Clients.

5.52Managed and supported cloud based infrastructure for the application.

5.53Prepare presentation and report for performance test execution for each web page.

5.54Coordinated UAT testing with Business team.

5.55Prepare UAT test cases.

5.56Prepared test execution report.

5.57Development Technology: ASP.net, C#, SQL Server 2000, TFS

5.58Testing Technology: QTP

6.NIIT, India May 04 – Aug 06

Developer cum QA engineer

Description:

6.1E-mail gateway is Intranet email facility designed for internal communication. After valid login, Emails can be composed with attachment and retrieved in Inbox.

Roles and Responsibilities:

6.2Performed requirement feasibility analysis, design documents and identified test scenarios/test objectives/test scope for website.

6.3Provided web based email interface, to access, send, read, and download attachments.

6.4Developed a cost efficient project using free tools (Java, Tomcat, and Apache HTTP Server).

6.5Identified end-to-end test cases, regression suites and system test cases

6.6Involved in Test data identification and gathering

6.7Documented test cases.

6.8Responsible for Smoke and Sanity test.

6.9Responsible for unit testing, integration testing, and system testing.

6.10Performed browser compatibility testing on browsers like Internet Explorer, Firefox

6.11Performed functional and non-functional testing

6.12Performed requirement feasibility analysis, design documents and identified test scenarios/test objectives/test scope for the module.

6.13Identified end-to-end test cases, regression suites and system test cases

6.14Involved in Test data identification and gathering

6.15Documented test cases.

6.16Responsible for Smoke and Sanity test.

6.17Responsible for unit testing, integration testing, and system testing.

6.18Tested websites both web (computer) and tablet (mobile) browser.

6.19Environment: Windows, Web application

6.20Development Tools: JDK2.1, Servlet, JSP, JavaScript, HTML, CSS, Java Mail API

6.21Testing Tools: manual testing

EDUCATION

7.Education

7.1Masters in Computer Application (MCA) 2001 – 2004

-SGSITS, Indore, India

7.2BSc (Electronics) 1997 – 2000

-DAVV, Indore, India

TECHNICAL SKILLS SUMMARY

Functional Testing Tools: Selenium2.9.1, Eclipse SDK 3.6.2, QTP 10.0, MuleSoft MUnit, AnyPoint Studio, SoapUI

Performance Testing Tools: JMeter, Loadrunner, Rational Performance Tester

Test Management Tool: HP QC (ALM), TFS, SVN

Scripting Languages: VB Script, Java, JDK 7.0, C#, C, C++

Databases: Oracle 10g, SQL 2000/2005, MySQL

Operating Systems: Windows XP/7, Linux

Architecture: OOPS, client server, web based application

Bug Tracking Tool: TFS, Kayako, Rally

Contact this candidate