Professional Summary

• Over 5 years of experience as a Quality Assurance Analyst.
• Extensive experience in writing Test Plans, Test Cases/Scenarios, Test Procedures and analyzing test results.
• Experience in the Data Warehouse, client/server and web applications.
• Good knowledge of testing ETL processes.
• Performed functional testing using the application and back-end testing using SQL.
• Well experienced in Manual Testing and working knowledge of Automation Testing using QTP.
• Experienced in error reporting and bug tracking using the test management tools like Test Director and Quality Center.
• Involved in all aspects of problem reporting, defect tracking and documentation.
• Ability to interact with developers, product analysts, and management regarding testing status and maintain detailed QA documentation.
• Excellent understanding of Waterfall and Agile SDLC processes.
• Good knowledge of XML and XQuery.
• Excellent team player and able to work independently in a time sensitive environment.
• Excellent communication skills.

Technical Skills
Testing Tools Mercury Quality Center, Test Director, QTP, Rational Tools, Jira, XMLspy, SOAP UI.
Testing Methodologies Black Box testing, System testing, Regression testing, Integration, End-to-End testing, Data validation and Verification.
Database Skills Toad, Oracle, SQL Server, Teradata, MS-Access, SQL queries
Web Technologies HTML, XML
Operating Systems UNIX, Windows
ETL Tools Informatica Power Center, UNIX Batch Processes
Reporting Tools Business Objects, Cognos

Professional Experience

Client : Confidential
Location : Dallas,TX
Duration : Oct 2010 –Nov 2011
Role : QA Tester

Description:
This was a web-based application developed for various mortgage modules offered by Confidential. The application was an enhancement of the one already existing and provided Bank of Texas customers to apply for the loan and check the status, while the employees could accept the mortgage applications, process the loans etc. The customers can also logon to their accounts via Internet to check the balance, make the payment or refinance the loan. The fundamental goal of the project was to enhance the entire insight product line to be more robust in the current global market segments. This online banking system was created using Java, JavaScript, HTML and Oracle on UNIX platform.

Responsibilities:

• Involved in gathering requirements and analysis of other business applications.
• Developed Test Plans, Test Cases and Test Scripts.
• Created Test Cases in Quality Center and RTM and mapped Test Cases to Requirements in RTM.
• Developed Tractability Matrix and Test Coverage reports.
• Managed and conducted System testing, Integration testing, Functional testing, UAT and Regression testing.
• Prepared status summary reports with details of executed, passed and failed test cases.
• Created and tracked the defects using Quality Center and generated defect summary reports.
• Performed Functional and Regression testing using QTP.
• Ran ETL jobs using Informatics Power tool.
• Performed testing of ETL processes created using Informatica for the Data Warehouse.
• Used the Informatica Designer to validate processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
• Involved in data warehouse testing by checking ETL procedures/mappings using Informatica.
• Performed Back end testing by writing SQL statements using SQL Plus and TOAD.
• Interacted with developers, Business & Management Teams and End Users
• Participated in regular project status meetings related to testing.
• Responsible for client interaction and reporting during user acceptance testing.

Environment: Windows XP, .Net, Oracle 10, SQL Server 2005, Toad, Informatica, Quality Center 10, QTP 10

Client : Confidential 
Location : Washington, DC
Duration : Apr 2010 – Oct 2010
Role : QA Tester

Confidential System is a web-based custom application built with Microsoft ASP, .Net, and SQL Server database. It is used to track trained, experienced, and readily available personnel for disaster assignments in the United States and its territories. The application is used by staff at NHQ, Service Areas, and at the disaster lead units in each of the 50 states.

This project was to upgrade the DSHR application. The testing was done to make sure that the new system has all the existing functionality as well as the new upgrades requested.

Responsibilities

• Worked with the developers and the clients directly to understand the project testing needs.
• Conducted Functional, System and Regression Testing of the application during various phases of the development
• Wrote and executed the test cases according to the requirements.
• Documented and tracked the defects in the Mercury Quality Center.
• Updated the RTM with the test case information.
• Provided training/data to the business analysts during UAT.
• Wrote SQL queries using the data dictionary to validate input data submitted through GUI with the actual data in the Database.
• Attended weekly status meetings with developers and business analysts to review the testing progress.

Environment: .Net, SQL Server, Mercury Quality Center.

Client : Confidential.
Location : McLean, VA 
From : Dec 2009– Mar 2010
Role : Test Engineer

Confidential is the worlds leading confectionary company. Their brands include M&M, Snickers, Dove, Mars, Twix, Wrigley and others. Mars Symbioscience is the global health & life sciences segment of Mars Inc focused on delivering evidence-based science.I worked as a tester for Mars ecommerce and business websites.

Responsibilities

• Performed testing of the ecommerce micro sites.
• Interacted with the requirements analysts and developers to better understand the website requirement/functionality
• Worked with the developers to create the test environment and supported them during the TRR(Test readiness reviews)
• Created the test cases for the micro sites based on the requirements.
• Executed the test cases and produced the TAR (Test Analysis Report) documents.
• Performed integration testing of the ecommerce websites with order placements.
• Used Mercury Quality Center for defects assignment and tracking.

Environment: Mercury Quality Center, Jira, SQL

Client : Confidential, 
Location : Washington, DC
From : Jan 2008 – Nov 2009
Role : Test Engineer

Confidential is a global asset management company with offices across the globe. Carlyle implemented a new application called the PlanIT to track the timesheets for the project times of the employees. PlanIT is a web based application with SQL Server as the backend. The management ran the reports to monitor project spending and the key customer initiatives.

Responsibilities

• Assisted in development of Test Plans based on business and functional requirements.
• Involved in the development of test data.
• Developed Test Cases based upon the Functional Requirements.
• Updated the RTM (requirement traceability matrix) as needed with test case information.
• Executed Test Cases manually using the test data to test the functionality of the application.
• Performed Integration testing between employee set up and Timesheet modules.
• Performed extensive Regression Testing of enhanced modules and bug fixes.
• Involved in User acceptance testing.
• Regularly interacted with Project leads, Business Analysts and Developers.
• Tracked Defects in Test Director and reported to the Developers logging a Modification Request.
• Performed backend testing using SQL.
• Involved in the end user training of Time entry application after go live.

Environment: TestDirector/Mercury Quality Center, SQL Server 2005

Client : Confidential, 
Location : USA
From : Dec 2006 - Nov 2007 
Role : QA Analyst/Tester 

Facility Management System for the Apollo Hospitals keeps track of many medical and surgical equipments used in the several hospitals across the country. It allows the network of geographically different locations to share information about supplies available and facilitates movement of equipment as necessary.

Responsibilities:

• Helped in preparation of test plan in accordance with the business requirements
• Performed front-end testing
• Analyzed and documented defects using Jira
• Used SQL queries to perform the back-end testing on Oracle.
• Executed positive and negative scenarios.
• Conducted regression testing after every new build.
• Used CVS for the version control of source code and documents.

Environment: Java, JSP, Tomcat, MySQL, Jira

Education

• BS in Textile Engineering .