Professional Summary:

• Over 7 years of experience as a QA Engineer in Manual Testing of Web based and Client/Server applications.
• Experienced with testing tools such as HP Quality Center, Quick Test Professional QTP SOAPUI and My SQL.
• Extensive hands on experience with all levels of testing including Smoke testing, Functional testing, Integration testing, System testing, Regression testing and Database testing.
• Experience in executing SQL queries in order to view successful transactions of data and for validating data
• Experienced in creating Test Plan, Test Cases, Test Scripts, Test Scenarios and Defect Reports.
• Several years of experience and advance knowledge of the Systems Development Life Cycle SDLC , Waterfall, Spiral, Rapid Application Development RAD , Extreme Programming XP , Rational Unified Process RUP
• Proficient in Business Requirement gathering, Business Process flow, Business Process Modeling BPM , Business Process Redesign, Business Process Reengineering BPR , mining, Automatic and manual testing, etc.
• Used Quality Center for managing, executing test cases and defect logging.
• Expertise in Functional testing, Regression testing, Integration testing, UAT testing and Sanity testing
• Extensive experience in the role of Defect management and performing activities like defect tracking, status reporting, defect root cause analysis, co-ordination etc.
• Expert in HP Quality Center.
• Expertise in defect tracking in both Clear Quest and Quality Center.
• Expert in testing/validation processes.
• Ability to identify problems, analyze test results, and investigating their cause and suggesting remedies.
• Designing of test case using black box testing techniques like boundary value analysis.
• Experience of Waterfall software development process and knowledge of various phases of Software Development Life Cycle SDLC .
• Experience in Black Box Testing, White Box Testing, Positive, Negative, Data Driven, Functional, System, Regression and Integration Testing.
• Expert in preparing Test Cases, Logging and Tracking Defects/Bugs.
• Possess intermediate knowledge and hands on experience in writing SQL Queries.

Technical Skills:

Professional Experience:

Confidential

Sr. QA Engineer

Responsibilities:

• Involved in writing Test Plans and Test Cases based on the Business requirement documents.
• Executed and run both manual and automated tests.
• Inserted Synchronization points wherever it was required using QTP.
• Conducted Data Driven Testing using QTP Data Driven Wizard for re-testing with multiple data through Excel sheets.
• Prepared test data for the Enter and Exit criteria in Integration testing.
• Performed Exception Handling in application using functions and Recovery manager in QTP.
• Used Parameterization to provide varied inputs for the scenario under testing.
• Performed Web Services testing and XML validation by creating test case suite using SOAPUI.
• Created Test Suites to do Functional and Data Driven Testing on the Web Services.
• Validated soap response using various assertions such as XPath, Contains, Not Contains, SOAP Fault, Schema Compliance.
• Involved in Backend Testing writing complex SQL queries and sub queries for database testing.
• Captured the SQL statements from the application execution and manually checked the results.
• Execute test scripts record problems issues in accordance with problem and issue management plans
• Develop and maintain testing standards procedures work by coordinating with off shore development team to develop common test data.
• Manage the test defect process including facilitating defect reviews reporting test execution status.
• Created Traceability matrix to match the requirements with the test cases using Microsoft excel.
• Interface between the users and the different teams involved in the application development for the better understanding of the business and IT processes.

Environment: Quality Center10/11, Microsoft SQL Server, Quick Test Professional 11, HTML, XML, Agile.

Confidential

Sr. QA Analyst

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Written complex SQL queries for querying data against different databases for data verification process.
• Scheduling the UNIX script from the CRONTAB.
• Unit tested the mappings using SQL scripts.
• Tested mappings to load data into II slowly changing dimension tables.
• Suggested to create Oracle Indexes on some of the source tables.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Worked with SSIS system variable, passing variables between packages.
• Created cascading prompts at the universe level. These cascading prompts were used within full client and thin client reports to narrow down the selection parameters.
• Tested different types of reports, like Master/Detail, Cross Tab and Charts for trend analysis .
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Designed and supported SQL 2000 Reporting services, Integration services and Analysis services.
• Creating test cases for ETL mappings and design documents for production support.
• Setting up, monitoring and using Job Control System in Development/QA/Prod.
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Worked on issues with migration from development to testing.
• Extensively tested several Cognos reports for data quality, data values, functionality, calculations, fonts, headers cosmetic.

Environment: Informatica Power Center 7.1 Power Center Designer, workflow manager, workflow monitor , Mercury Test Director 6.5, QTP 7.2, SQL Loader, Cognos 7.0, Oracle8i, SQL Server 2000, Erwin 3.5, Windows 2000, TOAD 7.

Confidential

Sr. QA Analyst

Responsibilities:

• Involved as a Tester in Manual and Automation testing of Web based Application.
• Executed the test scripts using QTP and analyzed the results.
• Automated some of the end to end scenarios using QTP.
• Involved in test case creation and modifying existing scripts/Test cases.
• Involved in Reviewing, Peer reviewing of Test cases and scenarios
• Involved in Test case merging with existing regression scripts.
• Test case execution and defect logging using Test Director.
• Performed sniff testing for regular builds.
• Used Descriptive programming to handle multiple objects with similar properties.
• Created Functional Libraries using VBScript and used them several times in the application testing in QTP.
• Tested Web Services using SOAP UI tool.
• Added Assertions for the validation purposes in SOAPUI.
• Performed backend testing by creating test data and validating database contents using SQL Queries.
• Reported bugs and interacted with developers to resolve the problems.
• Categorized bugs based on the Severity and Priority.
• Reported the bugs, Email notifications to the developers using Quality Center.
• Worked with development team to ensure that the testing issues/defects are resolved.
• Regularly involved in the meetings with the onsite co-coordinators to discuss the issues and report the status.

Environment: Quality Center 8.2/9, Microsoft SQL Server, Quick Test Professional 9.0/10, HTML, XML, Waterfall.