SUMMARY

• Extensive experience as QA/Testing Analyst in the field of Information Technology, Financial and Banking fields with emphasis on Software Testing, Client Server and Web based applications using Automated testing and Manual testing techniques.
• Experience with both team and individual work environments as QA Tester handling complex projects and participating in complete Software Development Life Cycle (SDLC).
• Hands of experience working in Financial, Mortgage, and Asset Management Organizations.
• Software Development Lifecycle (SDLC) experience includes Requirement Analysis, Detail design Analysis, Business models, System integration, and supporting deployment.
• Experience in performing Automated Functional Testing and Performance Testing using Quick Test Pro (QTP), Load Runner and Quality Center.
• Well versed in the analysis of Business Requirements and System Specifications to formulate and document test plans prior to performing testing.
• Expertise in Developing Test Plan Document, Test Strategy Document, Requirements Traceability Matrix (RTM), Test Results Document, Defect Summary Reports and Daily Status Reports.
• Accomplished in Test case design, Test script design, Test condition design, Test data sets and execution using various structured testing procedures.
• Expertise in Writing and Executing Test cases based on functional specifications and business requirements in HP ALM/Mercury Quality Center/Test Director. Expert in Defect tracking and Reporting.
• Extensively worked on Relational Databases like Oracle, Sybase, DB2 and MS Access.
• Extensive expertise in writing complex SQL Queries and Scripts to validate the data for Back End Testing.
• Proficient in working on various UNIX environments (Solaris and Linux).
• Vast experience in executing ETL Scripts and Scheduling Autosys jobs in unix environment to test the extraction, transformation and loading of data using IBM Data Stage tool.
• Solid experience with Back - End service testing with XML.
• Related technical experience involves extensive hands of experience working on IBM Rational Tools like Clear Quest for defect reporting and Clear Case and DOORS for Requirements Management and Version control.
• Documenting Test Documents Using MS Office Suite - Word, Excel, and Power Point.
• Good Knowledge and Experience performing Data Base Testing, Front End Testing, Backend Testing, Automation Testing, Regression Testing, Functional Testing.
• Ability to work collaboratively with Business Analysts, System Analysts, Developers, UAT teams and other team members in complex testing projects and in the overall enhancement of complex Business Data Quality.
• Ability to manage simultaneous projects effectively and efficiently.
• Excellent Verbal and Written Communication Skills have proven to be highly effective in interfacing across business and technical groups.

TECHNICAL SKILLS

Methodology/ Techniques: SDLC, Agile, Rational Unified Process (RUP)

Languages: C, C++, VB Scripting, SQL, HTML, XML

Operating Systems: UNIX - Solaris, Linux, Windows

Relational Databases: Oracle 10g, Sybase, DB2

Database Operating Tools: TOAD, SQL PLUS, Rapid SQL

Testing: HP ALM11.5, QualityCenter10.0, TestDirector8.0, ClearQuest8.0, DataStage9.1

Automated Test Tools: QTP10.0, LoadRunner9.1

Version Control Tools: ClearCase8.0, DOORS9.4

Documentation Tools: MS Office Suite

PROFESSIONAL EXPERIENCE

Confidential, Mclean, VA

Quality Analyst

Responsibilities:

• Worked with Developers and Quality Assurance lead to understand Use Case and functional Requirements.
• Generated and implemented Test Plan, Test Cases, and Test Scripts.
• Created the detailed test plan and test cases from the business requirements documents and meetings.
• Performed automated testing of the test cases using QTP and LoadRunner.
• Perform ad-hoc tests to uncover defects and log them in Quality Center.
• Coordinated with developers to fix the bugs and conducted Functional (Positive and Negative), and Integrity Testing.
• Participate in weekly meeting with the management team and walkthroughs.
• Data Driven Testing using parameterization in QTP to test the application with various sets of data.
• Successfully implemented the change request and defect tracking using Quality Center for utilization of developers and QA Team.
• Created and Maintained SQL Scripts and Unix Shell Scripts to perform back end testing of the Oracle database.
• Worked closely with Software Developers to isolate track and troubleshoot defects
• Participated in meetings and discussed Enhancement and Modification requests.
• Worked in Mercury QualityCenter to Write and Execute Test cases based on business requirements.
• Conducted Requirement Analysis and GAP Analysis.
• Performed Extensive Data Analysis on Oracle Databases.
• Developed Source to Target Mappings using Excel Spreadsheets and maintained them by Versioning.
• Executed SQL to ensure data is populated into correct table and data integrity is maintained.
• Extensively tested the ETL process of extracting the Source data, their transformation as per business rules and the subsequent loading into the CDW tables.
• Worked with users to develop user acceptance plan and test cases.
• Isolated and simplified problems discovered during testing so that developers can fix them easily.
• Attended various meetings with the developers, clients, and the management team to discuss major defects found during testing, enhancement issues, and future design modifications.

Environment: SDLC, HP ALM11.5, DataStage9.1, QTP10.0, Oracle10g, Sybase, SQL, Unix, ClearQuest8.0, DOORS9.4, Toad, Putty, MS Office

Confidential, Richmond, VA

Quality Analyst

Responsibilities:

• Worked extensively with SME’s in understanding, extracting and refining the Business Requirements pertaining to testing of RSC data.
• Carried out extensive Data Analysis to validate the data populated in certain fields in the CDW tables.
• Provided estimates to the Project Manager on the testing schedule and resources.
• Created Test Plan based on the scope and schedule of the project.
• Managed Project Requirement Traceability and Artifacts to test cases using DOORS.
• Wrote and Executed Test cases based on functional Specifications and Business Requirements in HP ALM.
• Tracked the progress of test cases planning, implementation and execution results.
• Wrote SQL queries to perform the Back End Testing of the Oracle database to ensure data integrity.
• Develop and execute scripts to test data extraction and transformation using SQL and UNIX Shell Scripting.
• Conducted regular team meetings to coordinate the testing progress or risks and the ways to mitigate those risks.
• Responsible for validating Data Quality reports whether they are pulling correct data from RSC and CDW Databases.
• Attended various meetings with developers, clients and the management team to discuss major defect found during testing, enhancement issues and future design modifications.
• Performed Smoke Test before moving the code to a Stable Test environment.
• Performed Execution of test cases in multiple cycles including Regression. Created a Regression Test Suite which can be progressively updated for new release of the application.
• Updated the Test Scripts for Regression build based on the enhancements to the application
• Triaged and Tracked Defects in HP ALM and sent Daily Status Report to Project Team.
• Timely escalation of issues related to different teams to ensure an early resolution.
• Provide support and data as and when needed to the UAT Team.
• Prepared daily and weekly status reports.

Environment: SQL, UNIX, Agile, XML, LoadRunner9.1, QualityCentre10.0, RequisitePro7.0, Oracle 9/ 8i, MS Access & Windows

Confidential, Richmond, VA

Quality Analyst

Responsibilities:

• Analyzed the user requirements by interacting with system architect, developers and business users.
• Documenting and executing Test plans, Test cases, and Test scripts based on baseline requirements of the PRUFN Application.
• Developed presentation slides in PowerPoint to give Test Plan review session to Business, Development and UAT Team.
• Developed and maintained the Data Mapping Document for multiple releases in the project using Access Database/ Excel Spreadsheets.
• Worked in Mercury Quality Center to document testing artifacts (Test cases, Test Results) and generate reports (Test Execution Summary, Test Case Reports) as per SDLC Standards.
• Reported Defects in ClearQuest by assigning Defects to development team.
• Prepared Test Scenarios based on reviewing Use Cases and UML Diagrams.
• Prepared Test Data for the design phase as per the specifications of the Functional Design document and followed RUP methodology.
• Participated in change management by identifying risks associated with the change and the impact that it will have on the Testing Timeline.
• Performed Integration testing, System testing, and Functional testing.
• Created and Maintained SQL Scripts to perform back end testing of the DB2 database.
• Worked with Rational ClearCase and ClearQuest for change request and bug tracking.
• Identified system test issues and coordinate resolution and/or escalate to system Test Lead as needed.
• Worked with Dev teams in validation of detailed reports, problem detection during testing, and problem resolution.

Environment: C++, RUP, SQL, UNIX, QualityCenter9.2, RationalClearCase v7.0, RationalClearQuest v7.0, Rapid SQL, DB2, MS Access

Confidential, Pittsburgh, PA

Quality Analyst

Responsibilities:

• Analyzed existing systems logic difficulties and revised them as the needed.
• Analyzed Business needs and Business Use Cases. Involved in developing Testing planning to meet business needs.
• Involved in assisting Test Lead for preparing the Test Strategy document that defines the test environment, phases of testing, time lines of different phases of testing, entrance and exit criteria into different phases of testing and resources required to conduct the effort.
• Created Test Cases, Test Scenarios in Test Director, ensured traceability to Business Use Cases and according to application.
• Performed Web Testing for verification of Broken Links, HTML Images, and HTML Content. Verified, updated and validated cardholder data information, account information, and authorization of transaction data.
• Performed Back-End testing by extensively using SQL commands to verify the database integrity.
• Reported Defects in Defect tracking tool of Test Director by assigning Defects to development that are encountered during testing phase based on application teams.
• Make sure to trace test cases to operations use cases.
• Recommend and implement naming convention for Test Cases, Test Sets, and Defects.
• Performed Gap Analysis.
• Coordinate with Test Coordination Center to set up and follow up on daily, weekly, and monthly reports.
• Attended Weekly status meeting in reporting and provided a weekly report that includes test metrics consisting of status reports.

Environment: TestDirector8.0, SQL, Windows NT, MS Excel, MS Access

Confidential

Tester

Responsibilities:

• Performed extensive manual testing on critical functionalities of the application.
• Executed the Test Cases Manually and analyzed the results and reported the defects to Developers.
• Executed Role Based Regression and System Testing for all the Test Cases.
• Used SQL queries for test backend.
• Performing extensive manual testing to verify the application is complete and stable.
• Tracked all testing results for management, categorizing issues and created/distributed trouble reports and managing defect listings.

Environment: SQL, Windows NT, MS Excel, MS Word