Test Cases Project

Preeti Khode

Phone: 210-***-****

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

PROFESSIONAL SUMMARY:

•Over 7 years of experience as a Quality Assurance Engineer in software methodologies and QA testing of various application systems.

•Knowledge and experience working with Agile, Waterfall methodologies.

•Experience in preparing test plans and estimations of the project

•Experience in testing the Mobile application on both I-OS (I-phone, I-pad) and Android devices.

•Experience in Web-Service testing through SOAP UI.

•Technical Knowledge and understanding of Data Warehousing, SQL, UNIX, Oracle and ETL.

•Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.

•Well versed in designing and executing test cases for GUI testing, Functionality, Regression and Integration Testing.

•Strong knowledge of Unit Testing, System Testing (ST), User Acceptance (UAT) testing and Risk Based Testing.

•Scheduling test cycles and effectively testing the product, properly documenting the reported bugs and tracking the bugs until fixed.

•Experience on using testing tools such as QC, Test Director, Bugzilla and UFT.

•Good experience in working with Onsite - Offshore team model projects.

•Excellent communication, interpersonal, analytical and leadership skills, self-motivated, quick learner and a team player.

TECHNICAL SKILLS:

Operating Systems

Windows XP/7, UNIX

Programming/Scripting Languages

C, SQL

Databases

Oracle, DB2, SQL Server

Testing and bug tracking Tools

QC, UFT, Test Director, Bugzilla, Borland Star team

Methodologies

Agile, Waterfall

WORK EXPERIENCES:

Client: Security Service Federal Credit Union Jun 2013 – Sep 2014

Project Title: Customer Identity Verification Location: San Antonio,TX

Role: QA lead

Description:

Customer Identification needs to be performed whenever a new member is having financial relationship. This project is to replace the existing non-IT supported system with the new IT supported system so that the business users can be productive and easy to follow the business rules.

Responsibilities:

•Followed the Scrum methodology to execute the project.

•Worked with Business Analysts to define testing requirements (acceptance criteria) to satisfy the business objectives.

•Analyzed the Stories and prepared Test Plans,Test Cases and User release notes.

•Created Test Cases in Quality Center and mapped to the corresponding Stories.

•Developed Traceability matrix and Test Coverage Reports.

•Prepare the QA Test Plan and Test scenarios for each Release, Review them with Business and QA Manager, get the QA Plan approval and upload the Test cases into ALM.

•Performed Integration, Smoke Testing, End to End System testing, Regression Testing.

•Automation assets for the key functionalities have been created using the UFT.

•Used the Datastage Director and to run the jobs, validating and debugging its components, and monitoring the resulting executable versions.

•Extensively used the Control M jobs for the entire project.

•Database validations have been performed by writing SQL queries based on source to target mappings.

•Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting

•Preparing documentation on recurring defects and resolutions, business comments for those defects.

•Interacted with Developers, Business & Management Teams and End Users.

•Prepared status summary reports with details of executed, passed and failed test cases.

•Conducted daily defect meetings and discussed the details of the defect.

•Involved in Release plan and had discussions on Exit Criteria with the project team frequently.

•Updating the RTC on daily basis to track the tasks for each story.

•Coordinate with Offshore Testing Team, explain them the existing functionalities and the functionalities being implemented in the project and explain the Testing scope.

Environment: Datastage 9.1, Quality Center, UFT, UNIX, Oracle, Control M, RTC, Windows 7.

Client: Citicorp Inc. Apr 2012 – May 2013

Project Title: Account Owner Authentication Location: San Antonio,TX

Role: Sr QA Analyst /Scrum

Description:

This project is to reduce the fraudulent losses which occur whenever customer does a funds transfer to the external accounts. We tested funds transfer application through web, mobile and speech. Validated the alerts which have been triggered on the fraudulent accounts. We tested interaction of the systems with the vendor tool with the mocked up data to get the owner of the account is fraudulent or not.

Responsibilities:

•Participated in the Requirements and Planning Phase to review the project requirements.

•Developed Test Plans and Test Cases based on requirements and the business documents.

•Creating, maintaining, and modifying Test Scripts for Web Based environment.

•Participated and involved in the peer reviews and walkthroughs of the Test Cases.

•Responsible for reviewing the Test Plan and Test Cases with Delivery managers, Business users, Business Analysts and Development Teams.

•Validated the test suite on I-OS (I-phone, I-pad ) and Android platform devices.

•Validated the Native changes in the Mobile devices.

•Performed End to End regression testing after resolving the bug in each and every build.

•Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.

•Created Daily Status Reports, Test Incident Reports and Test Summary Report.

•Responsible for collecting and analyzing the test metrics and then submitting the reports, which kept track of the status and progress of the testing effort.

•Report and Track Defects using Quality Center.

•Performed User Acceptance Testing in the final phase of software development process to check the functionality of the software.

•Reported and Interacted with the developers of the Bug Activity by date wise and engineer wise.

•Involved in Release plan and had discussions on Exit Criteria with the project team frequently.

Environment: Quality Center, I-OS & Android platform, Sharepoint,Windows XP.

Client: Citicorp Inc. Sep 2011 – Mar 2012

Project Title: Account Reconciliation Location: San Antonio,TX

Role: QA Analyst

Description:

This effort is to bring all accounts information of the customer from heterogeneous sources so that this could be utilized one source for the reporting purposes.

Responsibilities:

•Understanding the Business requirements based on Functional specification provided.

•Interacting with senior peers & subject matter experts to learn more about the data.

•Conducted and actively participated in reviews, walkthrough of test cases.

•Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.

•Identifying field and data defects with required information in ETL process in various jobs and one to one mapping.

•Tested Complex ETL Mappings based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.

•Created and executed SQL queries to perform source to target testing on DB2 database. Performed the following tests:

•Data Extraction,

•Uniqueness

•Data Integrity

•Data Transformation

•Tested the entire data reconciliation process for multiple source and target systems.

•Executed the jobs in different UNIX servers and analyzed the results in the database.

•Attended weekly production meetings and frequent project status meetings.

•Coordinated between offshore and onshore teams on daily basis for testing activities, issues and information.

•Performed Smoke Testing, System testing, Functional testing and Regression testing.

•Used Quality Center for requirements, test plan, test lab, defects and dashboards.

•Prepared status summary reports with details of executed, passed and failed test cases.

•Involved in Release plan and had discussions on Exit Criteria with the project team frequently.

Environment: Oracle, db2,Quality Center, UNIX,Windows XP.

Client: GSI Commerce Inc. Oct 2009 – Aug 2011

Project Title: Email Marketing and Marketing Affiliates Location: Chennai, India

Role: QA Analyst

Description:

GSI Commerce an e-commerce company which takes care of developing and customizing the online shopping sites. As part of this effort we need to develop the feeds for Email Marketing and Marketing affiliates (third party customers) so that they take care of marketing on the products and customers.

Responsibilities:

•Analyzed the source to target mappings given by the technical team.

•Developed test scenarios, test cases and test data files as per the business requirements/use cases.

•Created Tractability Matrix and Test Coverage reports.

•Test Data has been set up accordingly specific to each client.

•Worked on SQL scripts to load data in the tables.

•Experience testing on XML documents.

•Worked with Data Warehousing developers who extensively used data stage, to design mapping to move data from source to target database using stages.

•Performed system, adhoc, Functional, Integration and Regression testing.

•Executed the test cycles on different releases and validated actual results against the expected results.

•Generated manual Scripts and responsible for executing and bug tracking.

•Created detailed level of defect and knowledge transition documentation.

•Prepared status summary reports with details of executed, passed and failed test cases.

Environment: Oracle, db2,Toad, UNIX,Windows XP.

Client: Bank of America Inc Jan 2008 – Sep 2009

Project Title: Customer Due Diligence- Occupation Location: Chennai, India

Role: QA Analyst

Description

Occupational information needs to be collected for the customers to be compliance. We have implemented this feature both in .com and portal. Hijack flow is created and give 3 chances to enter the occupational information.

Responsibilities:

•Got knowledge transfer on the applications where this occupation feature will be implemented.

•Analyzed Business Requirements and asked clarifications to the onshore team.

•Developed test scenarios, test cases and test data files as per the business requirements/use cases.

•Performed system testing of the applications in both CIT and runway environments.

•Identified bugs and documented clearly with the screenshots

•Re-tested the application thoroughly after the bug fixes have been placed.

•Created QTP script to validate all the drop down values.

•Created Daily Status Reports, Test Incident Reports and Test Summary Report.

•Responsible for collecting and analyzing the test metrics and then submitting the reports, which kept track of the status and progress of the testing effort.

•Reported and Interacted with the developers of the Bug Activity by date wise and engineer wise.

•Copybook of the whole project has been created.

Environment: QTP,Quality Center, Bugzilla, windows xp

•Bachelor’s Degree, Visvesvaraya Technological University, Karnataka – India.

Instrumentation Technology - 2008

Contact this candidate