Test Cases Manager

Name: Jaspal Kaur Sandhu

Skills: Quality Assurance Tester

Phone No: 559-***-****

Email: ********@*****.***

PROFESSIONAL PROFILE

Having 3 years of experience in the domain for Software Testing and Quality Assurance Extensive experience in the Manual/Automated testing and Quality assurance of Webbased Client/Server applications on Windows and UNIX environments. in both waterfall and agile SDLC environments. excellent communication skills and is a self-directed, team player.

SUMMARY:

Over 3 years of diversified exposure in both Manual & Automated Testing of different Client-Server & Web-based applications.

Worked on complete Project Life Cycle (PLC) right from gathering of functional specifications to sustaining mode.

Proficient in analyzing Business Requirements, Designing and Developing Test Plans, Test Scenarios, Test Cases, Test Scripts, maintaining Traceability Matrix followed by Bug Tracking and Reporting.

Strong experience in Functional testing, GUI testing, System Integration testing, End-2-End testing, Smoke testing, Regression testing and User Acceptance testing (UAT).

Highly proficient in working with automated testing tools like Quick Test Professional, Load Runner and Quality Center. Proficient with QTP in Creation of Automation Framework and running test suites in Quality Center. Extensively used Load Runner to perform Load and Stress Testing.

Experienced with various Defect tracking tools like Quality Centre, JIRA, BugZilla, and IBM Rational ClearQuest.

Thorough understanding of the SDLC process entailing requirement analysis, design, development, testing, change request management and maintenance / enhancement support with different models like Waterfall and Agile-Scrum software development process.

Experienced in Product Demonstration to Product Owner and Agile Team at the end of each Sprint Cycle.

Experienced in Creating or Importing a Web Service testing project and added a WSDL to create tests from Web Service requests in SOAPUI.

Knowledge of Selenium (Integrated Development Environment, Remote Control and Web driver).

Proficient in Prioritizing Key Areas of testing to meet deadlines including Organizing Walkthroughs and Team Meetings.

Experienced in database testing using SQL queries on RDBMS databases like Oracle, SQL Server and MS Access.

Excellent team player with Good Communication, Interpersonal, Intuitive and Analytical Skills.

TECHNICAL SKILLS:

Operating Systems Windows XP/ 2000/ Vista, Windows 7, 8 & 10

Languages C, C++, Java, JavaScript, VB Script, HTML, XML

Databases SQL Server, MySQL, Oracle, MS Access

Functional Test Tools Quick Test Professional, Quality Center, Load Runner, Selenium(IDE, RC, Web driver), SOAP UI, Eggplant, Ranorex, Rest Client

Bug Tracking Tools Quality Center, Jira, Bugzilla, IBM Rational ClearQuest

Version Systems Git, SVN, Visual SourceSafe, CVS

Methodologies Agile, V Model, Waterfall

PROFESSIONAL EXPERIENCE:

Client : United Parcel Service (UPS) Paramus, NJ November 2017 - Feb 2018

Role: QA Tester

Project : UPS Access Point

Description:

United Parcel Service typically referred as UPS, is an American global package delivery company headquartered in Sandy Springs, Georgia, United States in Greater Atlanta. UPS faces many challenges in the delivery of residential packages on first attempt. Most countries' operational procedures do not allow for driver release, nor does the residential lifestyle landscape lend itself to driver release (e.g. barred entrances, security code at front gate entry, and multi-tenant dwelling). With the objective to meet consumers' ever growing expectation for flexible delivery solutions and to reduce operational costs related to multiple attempts to deliver residential packages, UPS began offering shippers the ability to send packages directly to Retail Access Points (Access Points). In this project a web application to manage activities at an Access Point is being built.

Responsibilities:

Analyze and review business requirement and use case documents.

Create test plan, test scenario, test matrix (traceability matrix).

Write test cases in QC based on the functional requirements.

Prepare automated test script for System, Product and User Acceptance testing.

Create setup for QTP automated Regression testing from scratch, this includes creation of Object Repositories, Function Libraries, Descriptive Test Scripts and test data excel database.

Create, execute and maintain data driven testing scripts for QTP.

Write SQL queries for backend testing to check data integrity and data consistency.

Execute test plan and report progress of testing activity.

Execute test cases, record result of testing and log defects in QC.

Perform Load and Performance testing using Load Runner.

Created Load Scenarios, schedule the Virtual Users and Parameterize V-user scripts to generate realistic load on the server using Load Runner.

Generate reports and documents and communicate test results on daily basis.

Analyze the results gathered during test scenario execution.

Run the daily and weekly status meetings and report progress of testing activity.

Environment: Java 7, Weblogic, Spring MVC, Webservices, JSP, CSS, XML, UNIX, ANT, Quality Center, Quick Test Pro, Load Runner, SQL, Oracle

Client : Wells Fargo, Philadelphia PA August 2016 to October 2017

Role: QA Test Engineer

Project : Trade ERP

Description:

Wells Fargo & Co. (NYSE: WFC) is a diversified financial services company with operations around the world. Trade ERP is a Corporate and Investment Banking domain application. It provides Purchase order processing functionality to Wells Fargo's customers. Purchase orders record business transaction between Business entities involved in Trade. Purchase order data is provided by different sources (Web based interfaces, Data transmission services, File upload) in different formats (EDI, XML, and CSV). Purchase order data is converted into Wells Fargo specific XML format (POXML) before processing, after that a set of validations and business rules are executed on the purchase order data and finally the purchase order data is loaded in various databases so that it can be further used by various Wells Fargo applications.

Responsibilities:

Analyzed business requirement documents and design specification documents.

Participated in studying system process flows (includes front, middle and back office) to frame test strategies, quantifying Manual and Automation tests.

Created test plan and test scenarios based on the requirement documents.

Created and maintained requirement traceability matrix (RTM) for overall requirements coverage (Gap Analysis).

Prepared test scripts for the System, Product and User Acceptance Testing (UAT) based on requirements.

Created SQL queries to verify data in target databases.

Conducted manual execution of test cases, evaluated the results with expected results to ensure application is functioning in a stable way and logged defects in QC.

Performed XML testing through QTP using XML checkpoints.

Performed extensive Data Driven Testing using concepts of Parameterization.

Generated and executed test scripts by creating Test Suite for Batch Testing in Quality Center.

Used Recovery Scenario Manager to handle various exceptions.

Created data driven tests in QTP with global parameters and local parameters.

Generated reports and documents and communicated test results on daily basis.

Analyzed the results gathered during test scenario execution.

Participated in status review meetings with developers and QA team.

Maintained consolidated weekly status reports and test logs and reviewed with QA manager periodically.

Exported/Imported excel files in automation tools (QTP) to run tests.

Environment: Java 7, UNIX, XML, Weblogic, IE, Firefox, Chrome, Load Runner, Quality Center, Quick Test Pro, SQL, Oracle

Client: TD Banknorth, Portland, Maine Oct 2014 –May 2015

Role: QA Analyst

Project Description:

Data Center Consolidation (DCC) project consolidates certain data center functions in Lewiston with those at data centers in Canada. This is one of the largest Technology projects that TD Banknorth has undertaken resulting in good remarkable milestone in the history of TD Banknorth.

This project allowed leveraging of TD's technical infrastructure and gave added flexibility and increased scalability to grow.

DCC project involved in the Migration of the current existing Applications Database from Lewiston USA Data Center to a new location in Toronto CANADA. Migration happened in five phases. Each phase was more complex than the previous phase related to bank’s several business lines such as consumer, commercial, fixed assets and loan operation.

Responsibilities:

Worked closely with the Business team to fully understand the scope and functionality of each application

Derived Test Plans and Test Cases for several applications after discussion with the Application BA’s and Manager.

Scheduled meetings with the Business Team and discussed the process flows to make sure that each identified transmission and Batch process is reflected in the test cases.

Attended meetings for each application to gather the information required for QA Team and participated in status meetings

Communicated Defects and Bugs that came up during the testing of the application in each testing phase and raised an issue ticket in the SPARCS defect tracking tool.

Ensured that the Issues listed in SPARCS were successfully resolved by communication either with the DBA’s or concerned managers

Analyzed and documented the Test results.

Environment: Web based application, SQL, Functional Testing and Quality Center, SharePoint.

CINGULAR, Dallas TX Nov 2013 – Sep 2014

Sr. QA Analyst

Project Description:

This project at Cingular involved the Order Tracking System, which is designed with the aim of assisting Sales oriented employees to access data in a quick and efficient manner for informed decision-making. Order Tracking System was integrated with the in-house developed web-based tool and Oracle Financial modules mainly AP (Accounts Payable), AR (Accounts Receivable) and General Ledger, Inventory and Order Management.

Responsibilities:

Worked closely with developers and the Business team to fully understand the scope and functionality of the proposed systems requirements

Discussed and Derived Test Plans with the Manager

Communicated Defects (Test Director) with the developers and later fixed them.

Performed black box/manual testing to ensure the best quality of the source code

Tested Application for GUI Appearance, Functionality and Performance. Tested back-end content management mechanism

Performed manual testing for implemented modules

Developed and executed numerous test cases for complete testing coverage of many functional areas. As a result of performance testing suggested several changes to the database structure

Processed feedback from users in order to analyze and reproduce software problems. Provided management and vendor with analysis reports and recommendations, which resulted in a redesign of the architecture by the vendor. Communicated with the vendor to resolve issues.

Tested the database using SQL queries.

Identified Software bugs and interacted with developers to resolve technical issues.

Analyzed and documented the test results.

Coordinated the QA team and conducted and participated in status meetings.

Environment: Oracle, UNIX, Windows 2000, Test Director, QC, TOAD, PL/SQL, SharePoint.

Education :

Bachelors in Computer Science from India.

Contact this candidate