SUMMARY

• Over 7 years of Manual and Automated testing experience on Web, System and Client/Server applications.
• Excellent understanding of QA methodologies.
• Strong Experience in Agile and Waterfall Methodologies.
• Experience in capturing Business requirements and creating User Stories for every Sprint in Agile Methodology.
• Good Technical Experience in Writing System Test Plans, Test Cases, Test Scripts, documentation and Setting up Test lab Environment.
• Extensive working experience in GUI, Mobile Testing, System Testing, Integration Testing, Regression Testing, Stress Testing, End to End Testing and User acceptance testing.
• Execution of Tests using both Manual, Automated - Testing Tools.
• Expertise in Manual Testing and Automated Testing Tools like Win Runner, Quality Center and Quick Test Pro.
• Ability to write UNIX commands and for automation of file manipulation and data validation procedures using UNIX shell scripts.
• Experience in Using Quality Center/Clear case/Clear Quest/Test Manager extensively for establishing Traceability to Requirements, Test Cases, Bug tracking and Reporting.
• Expertise in Analysis of Problem Severity, Defect Tracking System and Defects Reporting System using Test Management tools like JIRA, PVCS Tracker, Quality Center and Clear Quest.
• Ability to write complex SQL queries for querying data against different data bases for data verification process
• Able to work collaboratively with Developers and Team Members in testing Complex Projects and in the overall enhancement of Software Product Quality.
• Communicate closely with Customer Service Groups, Vendors, Retailers, and Off-Shore Teams.
• Extensive experience in Banking, Insurance, Health Care and Retail Domains.
• Excellent team member with good communication and interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.
• Ability to manage project activities ensuring timely deliveries as per defined timelines and quality standards.

TECHNICAL SKILLS

Database Languages: SQL and PL/SQL

Database: SQL Server 2008, Oracle 10g/11g

Database Management Tools: SQL Server Management Studio Express 2008, SQL Developer, Teradata SQL Assistant

Operating Systems: Windows 2000/XP/Vista/7, UNIX

Productivity Tools: MS Office (Word, Excel, Visio, Project, PowerPoint)

Test Management Tools: HP Quality Center 10.0, JIRA, HP ALM 11.0

Functional Test Tools: SOAP UI, HP QTP

PROFESSIONAL EXPERIENCE

Confidential, CA

QA Analyst

Responsibilities:

• Analyzed the objectives and scope of each stage of testing process from the Test plan.
• Interacted with business analysts to gather the requirements for business and performance testing.
• Participated in the Manual Vs Automated testing decision-making process.
• Responsible for testing the Navigation Flow, Functionality Testing, System Testing and User Acceptance Testing.
• Interacted with users and vendors for full life cycle of project.
• Prepared test data and helped load test data into the test database environment.
• Tested the application by inserting checkpoints such as Data base and Text checkpoints in test scripts using QTP.
• Tested the application by inserting Synchronization in test scripts, generated Automated Test Scripts using the recording feature of QTP.
• Performed Functionality, Regression and Data Driven testing using QTP.
• Prepared Test Data and executed Test Cases from Quality Center.
• Stimulated financial calculations for a given formula for a given period.
• Involved in Life cycle test for various products.
• Conducted Functionality testing during various phases of the application.
• Worked on parameterizations, calling/copying, Check points heavily.
• Performed Database testing by writing SQL Statements for various Business transactions on Oracle.
• Extensively performed manual testing using Quality Center.
• Involved in defect reporting and bug tracking using Quality Center and Share point.
• Determined testing requirements developed and reviewed scripts for positive and negative test scenarios, conducted baseline testing, and generated reports.
• Conducted various management activities by analyzing and verifying test results, providing status reports.

Environment: Asp.Net, Quality Center 10.0, QTP 11.0, Share point, Oracle, SQL, Ms Excel, Windows 7.

Confidential, Manhattan, NY

QA Analyst

Responsibilities:

• Documented Test Plans wrote Test Cases and decided schedules for Test Case Execution.
• Demonstrated the projects to different groups.
• Performed Grey-Box Testing for each individual functionality and regression testing of the application.
• Conducted System Testing, GUI Testing and Cross Browser compatibility testing during the releases and interacted with the developers to resolve any technical issues.
• Coordinated configuration management of build and release cycles with the business, development and QAteams.
• Involved in Back End Testing using UNIX and automated Regression Testing using Korn shell scripting.
• Created Smoke test cases for the end to end test process of the successful and failure path.
• Used BugZilla for bug tracking.
• Wrote and executed complex SQL queries including JOINS to validate Back-end data.
• Defined test strategies, planned and performed and managed all testing activities including functional, UAT, and regression testing.
• Designed and Developed data validation, load processes and test cases using PL/SQL, SQL.
• Developed UML Use-Cases and Use-Case diagrams after accessing the status and scope of the project and understanding the business processes using Rational Rose.
• Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application and managed them using Rational Requisite Pro.
• Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements.
• Coordinated activities with project manager and various other teams using MS Project.
• Supported User Acceptance testing (UAT) and collaborated with the QA team to develop test plans, test scenarios, test cases and test data to be used in testing, based on business requirements, technical specifications and/or product knowledge.

Environment: Rational Clear Case, Doors, IBM WebSphere, Quality Center, XML, Java, J2EE, JSP, RUP, VoAVPN, Oracle, MS Visio, MS Access, DB2, Sybase, SQL Server Reports, UNIX, Win Runner, Load Runner, Quick Test Pro.

Confidential, Jacksonville, FL

QA Analyst

Responsibilities:

• Involved in gathering Requirements, Systems Analysis, preparing Functional Specifications, Design Reviews and Test Plan Reviews.
• Participated in project planning sessions and all technical client meetings.
• Created Test Plans, Test Scripts and Performed the testing for data conversion process during all phases of Testing Starting from Unit, System, Integration and Prod.
• Created QDQ's for documentation.
• Automated Functional testing using QTP.
• Tested Logical Flow of Data Conversion including source data, data profiling and data cleansing and data migration from Oracle 9i and DB2 Databases.
• Created TSQL, PL/SQL (Functions, Procedures, Packages and Triggers) and Shell Scripts for improving the performance of the System.
• Developed SQL script (developed complicated SQL Script in Toad) to validate data, automated UNIX based process (using UNIX utilities like awk, grep, sed, vi, network process, file level, directory level) with shell scripting and executed all test scenarios in minimal time.
• Performed the Back-End testing to ensure data consistency on front-end by writing and executing SQL queries on the database.
• Recorded the bugs and reported using Mercury Quality Center.
• Created SQL queries using SAS to check data flow in the various Databases.
• Generated Reports using the Web Report Studio (WRS).
• Developed SQL queries to validate conversion requirements and the format of legacy data.
• Carried out testing to check whether the application was functioning as per the Business rules and functional documents.
• Developed the SQL Procedures and SQL queries to validate the reports.
• Tested the application in all the phases.
• Participated in walkthroughs and technical reviews to report testing status.
• Experienced in Developing SQL scripts for database testing using SQL and PL/SQL. Extensive experience in Database Testing on Oracle and SQL servers.
• Defined problems in test data and determined alternatives and initiated corrective action to recover/restore data and return system back to normal operations.
• Provided the Application Support for Post-Production Process.
• Developed SQL and Shell scripts to create temporary tables and developed SQL*Loader scripts to load data into the temporary staging tables.

Environment: SAS Enterprise Guide 4.1, Quick Test Pro, Mercury Quality Center, Web Report Studio, Rational Test Manager, Rational Clear Quest, Rational Clear Case, DB2, Oracle 10g, SQL Server 2005, PL/SQL, TSQL, UNIX, Informatica, Quest Central, SQA Navigator, and Windows NT.

Confidential, Marlton, NJ

QA Analyst

Responsibilities:

• Prepared and Executed Test Cases for Functional and Integration testing.
• Created Traceability matrix to keep track of changes in requirement to that of the testing efforts.
• Identified high-level requirements for documenting detailed business requirements using.
• Maintained the Test Matrix and Traceability Matrix.
• Tested applications and documented results and bugs including documentation of information useful in the debugging process
• Involved in preparing Test Plan and Test Cases based on business requirements.
• Created, Reviewed and updated Test Scenarios, Test Cases and Test Data.
• Running queries against databases to verify the correctness of XML response
• Document request/response XML's test procedures and functional/technical findings from the test run.
• Defects Reporting and Web Services Test Results Reporting
• Generated test cases in spread sheet and upload them into Quality Center.
• Performed end-to-end testing, Integration Testing, UAT Testing and Regression testing.
• Performed Manual Testing and Automation Testing of the application.
• Tested Mobile app on Mobile device such as iPhone4
• Created automated Keyword Driven Frame by using Quick Test Pro for Dynamic functionality and Validate.
• Used Environmental variables to analyze the execution environment of QTP
• Created recovery scenarios to handle unexpected events.
• Defect tracking & logging of defects in Quality Center and verifying the fixes.
• Extensive use of SQL queries to perform data integrity testing.
• Manually perform backend testing using TOAD to validate the data migration efforts with Oracle.
• Used Toad SQL queries to verify extract data. Written UNIX commands and UNIX scripts to consolidate extract data in a more easily readable format to make data analysis easier.
• Followed up with developers on defects status on a daily basis.

Environment: Microsoft suite, Soap Ui, Oracle, TOAD, UNIX, Informatics, Oracle SQL +, Quick Test Pro., Quality Center, Java, HTML, SharePoint

Confidential, Bentonville, AR

QA Analyst

Responsibilities:

• Prepared Test Cases, Test conditions based on the Functional Specifications and Technical Design Document.
• Categorized the test cases mapping with the requirements.
• Developed test scripts for data driven, functional and regression testing.
• Coordinated testing activities with testing team members.
• Developed Test Plans, Test Metrics and testing categories from project spec and requirement documents.
• Prepared comprehensive test plans and test cases for functional, regression and performance/load testing of project.
• Developed Test Plans, Test cases in Mercury Quality Center.
• Responsible for Manual Testing, Integration Testing, System Testing, Smoke Testing.
• Developed automated test scripts and enhanced the scripts with VBScript as necessary for functionality testing using QTP.
• Updated the defect status and opened new defects while testing the defects and prioritize them based on severity in Quality Center.
• Maintained the test Reports in Excel spreadsheets.
• Ensured proper documentation of the testing procedures.
• Coordinated with the development team on a daily basis regarding bugs and issues.
• Environment: QTP, Quality Center, MS SQL Server 2005, MS Project Access, IE, MS Office, Windows XP..