Bhavini Patel
**** ******** ****** ****, ***********, M1B 6E1 Phone: 647-***-****
Email: *********@*****.***
Executive Summary
Over 7 years of diverse experience as QA Analyst in the competitive Software Quality Assurance and Testing industry
Excellent hands-on experience in Banking, Capital Markets, Financial, Government, and E-commerce verticals
QA Expertise
Comprehensive experience in developing user interface, functional specifications and application rules based on specific: Client/Server testing, web based application testing, GUI testing, functional testing, integration testing, regression testing, interface testing and database testing on various testing platforms
Expertise in working with Bug Tracking tools like ALM/Quality Center, Clear Quest, QA Director
Extensive experience in establishing QA procedures/standards to meet international QA standards proficient in writing test plans, documenting the testing procedures and writing in-depth test cases to meet the testing cycle
Well versed in testing applications using RDBMS like Oracle (SQL & PLSQL) and MS-SQL
Complete understanding of application analysis and design concepts for the purpose of testing
Sound knowledge of Test Plans, Test Cases, Test Scenarios and Test Conditions
Well conversant in testing and illustrate complete feature schematics and specifications, advocate for user-centric design, create visual elements and designs
Have excellent analytical and communication skills, proactive, well organized, efficient, a team player and foster collaborative work environment
Ability to work under deadlines, worked as an active team member and willingness to accept responsibilities
Professional Experience
Project
Client
Role
Duration
Investment Management System
RBC Investment, Toronto, ON
Sr. QA Analyst
Nov 2014 to Till Date
PROJECT DESCRIPTION:
RBC is a Canadian multinational financial services company and largest bank in Canada. They provide the integrated technology for Investments management systems through the wealth line of business. The project of WMTS (Wealth Management Technology Services) is about investment management systems for the Charles River Development. The IMS is a CITRIX based application which deals with equity, fixed income and long durations. The IMS allows the traders to perform trading on bonds and shares in the market. The project is about testing the functionality of all the modules in IMS and also tests the performance of IMS under different business scenarios.
RESPONSIBILITIES:
Analyze requirements gathered by clients
Responsible for creating the Test Plan, Test scenario, Test cases for end to end application testing
Actively engaged in designing of test plans, test procedures and test cases and executing test cases
Compiled test cases in Excel and uploaded them onto ALM
Validated the position integrity of asset classes such as equity, fixed income and long durations within the investment portfolio under test
Performed data mapping as a part of Grey Box testing
Developed test cases depending upon the requirement documents
Performed functional, system, integration and smoke test efforts during various phases of the project
Prepared status reports and checklists for various releases of the project
Examined various reports, both Ad-Hoc and scheduled reports generated off the system
Tracked the logs written for each process that runs in UNIX
Submitted metrics, reports, and schedules to management as necessary and participated in the design walkthroughs and meetings
Used ALM as a defect tracking tool
Map the requirements to test cases in ALM and generated requirement traceability reports for the purposes of audit compliance
ENVIRONMENT: ALM, Java, C, C++, .Net, Rapid SQL, UNIX, Citrix, FIX Server, Agile Methodology
Project
Client
Role
Duration
CCAPS (Credit Card Application Processing System)
American Express, Markham, ON
Senior QA Analyst
Sep 2013 to Oct 2014
PROJECT DESCRIPTION:
American Express is one of the largest credit providers in Canada, which serves consumer banking customers with credit cards and credit product services. Credit card application processing system is an integrated SAS (Statistical Analysis Software System) for the adjudication of credit card applications. The system incorporates various modules for handling distinct stages through which an application passes before finally being approved or rejected. All approved applications are uploaded for card number assignment and generation of the card personalization file. The system contains various modules like Data Entry, Quality Control (QC), Scoring, Policy and Contact Point Verification (CPV) and letter generation modules.
RESPONSIBILITIES:
Collaborate with the business analysts to understand user requirements and business requirements
Prepared test data as per the test scenarios documented in the test plan
Categorized test cases in the test plan module of ALM
Automated the test scripts for the Functional and Regression testing using QTP
Formulated positive and negative scenarios for Functional, GUI and Security testing during various release cycles
Extensively worked on validating positive and negative sets of data with complex SQL scripts
Captured the application objects using object spy and stored in object repository in QTP
Used the Step Generator to insert steps by using test object methods, utility object methods, and function calls
Inserted XML checkpoints to perform testing dynamically and changing the XML feeds
Reviewed and analyzed test results and reported defects using the defects module of ALM
Collected test matrices weekly from ALM defects database
ENVIRONMENT: SAS, ALM, Java, Struts, Java Script, XML, Oracle (SQL & PLSQL)
Project
Client
Role
Duration
RBC-Diverse Access
Royal Bank, Toronto, ON
Senior Software QA Engineer
Aug 2012 to Aug 2013
PROJECT DESCRIPTION:
RBC Financial is one of the largest bankcard providers offering online services such as 24-hour access to credit card accounts, instant account opening for deposits etc. RBC-Diverse is 24-hour online access to RBC credit cards, where customer can login and view the account information (Current and Previous Account history) and can make online payments and change their contact information (Address, Phone Number and Email Address) and contact customer service representatives for questions.
RESPONSIBILITIES:
Gathered the functional testing criteria as per the project milestone
Built test cases and test scenarios in Rational Robot
Performed system testing, functional testing and regression testing using Rational Robot
Performed GUI testing using Rational Robot
Executed test cases and performed stress testing and performance of the system
Loaded data to different databases using SQL scripts and maintained data for loading scripts
Tested the load intake and performance of the application using Rational Robot for predetermined loads
Developed test harness using Rational Robot that assisted the testers to use the commonly used functions and test scenarios and reduce the redundancy of automation scripts
Performed data-driven testing to get test input data from an Excel file and test the application with different positive and negative data and write reusable functions in Rational Robot
Updated, maintained, and promoted test plans and scripts to configuration management for version control in Clear Quest
Provided testing strategies, techniques and participated in group meetings
Documented and reported test progress on a daily basis.
Used Clear Quest as a defect tracking tool and reporting
Reported defects found in the system to the developing team using Rational Clear Quest
Worked with developers to identify the test case design errors and revised them
Wrote down the problems found during test in Clear Quest and discussed the issues with development team
ENVIRONMENT: Rational Robot, Rational Clear Quest, Clear Case, Oracle, Java, Web logic, SQL, UNIX
Project
Client
Role
Duration
Returns Management Agent
Cisco, Toronto, ON
Sr. QA Analyst
Dec 2011 to July 2012
PROJECT DESCRIPTION:
RMA Agent was created to allow CISCO customers to request return for credit orders. The customer is walked through the process of creating a return request by selecting line items from an original sales order. Regional managers and controllers are then presented with the return order request and have the option to either approve or deny the request. If approved, the order is imported into CISCO production order entry database for processing. An acknowledgment is sent to the customer who initiated the return request indicating either approval or denial.
RESPONSIBILITIES:
Created & managed the process of Testing Life Cycle (TLC)
Communicated with business and end users to get a better understanding of application and to escalate any issues during testing
Reviewed business requirements and wrote test requirements based upon them
Installed and configured the test environment and performed smoke test for every new build in the test environment to ensure the quality of the build
Accountable for writing test plans, test procedures, and test cases for RMA
Developed automated test scripts using TSL for functional, regression testing using QTP
Performed Data-Driven testing using QTP test scripts by importing the data from the database using SQL queries
Conducted back end testing on QTP by executing SQL queries in TOAD and Inserting Database checkpoints
Involved in Performance testing of the application using Load Runner
Created Vuser scripts for conducting the performance testing of the overall application under test using Load Runner
Used Quality Centre to create reports and graphs
Tracked, Reported and prioritized the bugs using Quality Centre
ENVIRONMENT: Quality Center, UNIX, XML, Oracle, Web logic, TOAD, Clear Case
Project
Client
Role
Duration
US Army E-Procurement Purchase
Buchanan Technologies, Mississauga, ON
QA Tester
Sept 2009 to Nov 2011
PROJECT DESCRIPTION:
Buchanan Technologies is a provider of internet business-to-business electronic commerce services. This is a B2B E-Commerce application developed for the US army in three-tier architecture. This application consists of various features like buyer bids, supplier bids, purchase orders, search, profile, etc., The Front end of the application is being developed using ASP.NET. Client side validation is done using JavaScript, VB Script and the middle-tier consists of business logic developed in COM. The backend is developed using SQL Server.
RESPONSIBILITIES:
Involved in writing test plans and developing test cases from Business Requirements and Functional requirements
Engaged in all phases of end-to-end testing which includes User Acceptance Testing, Functionality Testing, Regression Testing, GUI Testing, Boundary Testing, Negative Testing, System Testing, Unit Testing and Smoke Testing of the Purchase Pro application, its interfaces and client-server utilities
Constructed interactive customizable tests and components for the application
Involved in development and implementation test scripts for E-Source Application
Used Astra Quick Load for load testing
Performed smoke testing for the end to end process
Participated in meetings with developers, users and various members of my team to discuss and to resolve defects
Performed Unit, integration and functional testing manually
Data integrity testing and back-end testing was performed manually by creating and executing SQL statements
Conducted regression testing on different versions of the application
Worked with Clear Quest to trace bugs in the system
ENVIRONMENT: Clear Quest, Astra Quick Load, Java, SQL, Oracle
Education
Bachelor of Computer Applications (BCA- Computers) JUNE 2008
Veer Narmad South Gujarat University, Gujarat, India