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.

Confidential

QA Engineer

Responsibilities:

• Analyzed Business Requirement Document, Software Design Document, Software Requirement Specification and Functional Requirement Document.
• Validated data from front end systems to the backend databases.
• Performed both Positive Testing and Negative Testing.
• Performed Code review of automation Scripts and made comments for changes made in the script.
• Involved in User Acceptance Testing, GUI Testing, and Regression testing, on different versions of the application.
• Validated all the web services by testing the WSDLs using SOAP UI.
• Validated all the ETL mappings developed to fetch data from OLTP system to the data warehouse.
• Validated all the session logs.
• Participated in SCRUM and SPRINT meetings.
• Created Scenarios as per business requirements with various user loads using Performance Center.
• Enhanced the Ramp Up and Ramp Down time's to simulate the real time scenarios.
• Generated Load Runner reports with Running Vusers, Hits per Second, Throughput, Average Response time and Total Transactions per Second graphs.
• Created a Performance Report for the end to end testing in comparison with the baseline and final values.
• Uploading the Performance Test Plan, Test Scripts, Scenarios and Final Reports in the Quality Center for every application.
• Extensively used SQL to query the Database to setup the test data for at least 500 virtual users for each applications.
• Also worked closely with the developers for the Performance Tuning of a new application by gradual Scaling of the application.
• Assigned critical performance Defects to the developer using Quality Center.
• Weekly meeting with the management team and share the Status Report on the weekly basis.
• Tested and validated data on Hyperion reports.

Environment: Hyperion, Quality Center QC 9.0/9.2, VB script, SQL, TOAD, Microsoft Visio, MS Access, Windows XP/2003/2007, Oracle 9i, Informatica

Confidential

QA Engineer

Responsibilities:

• Developed Test cases for each functionality specification to ensure quality performance.
• Analyzed requirements and documents to identify manual test cases.
• Involved in walkthroughs and formal meetings with developers to discuss enhancements and modifications.
• Involved in testing all back end processes using Microsoft SQL Server.
• Captured the SQL statements from the application execution and manually checked the results.
• Wrote complex SQL queries to ensure that data at the front end matched data at the backend.
• Used SQL to check for referential integrity, for logical checking and for checking format of data in database.
• Designed test scripts in QTP for automating regression test suites.
• Used Recovery Scenario Manager in QTP to recover from unexpected events that happen during a run session.
• Enhanced scripts in QTP using Functions and Actions.
• Inserted Checkpoints in QTP to check for broken links, for back-end testing and for regression testing.
• Used Smart Identification in QTP to handle dynamic objects.
• Carried out Functional and Data Driven Testing of Web services using SOAP UI.
• Validated WSDL's using SOAP UI.
• Used various kinds of Assertions like Schema Compliance, SOAP Response, XPath Match, etc in SOAP UI to validate SOAP Responses.
• Identified and documented all issues and defects to ensure application software functionality.
• Interacted with developers to explain where required, software bugs and re-tested the fixed issues.
• 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.

Environment: Quality Center 8.2, Quick Test Professional 8.0, MS-Office, Test director, SQL Server, Visual Studio2008, .NET and Internet Explorer.

Confidential

QA Analyst

Responsibilities:

• Responsible for conducting training sessions to the end-users of the software applications.
• Responsible for Quality Center Administration.
• Performed extensively various testing task like Smoke testing, Sanity testing, Functional testing, Regression testing, Usability testing, Recovery testing etc.
• Performed System Testing conducted on application with end-user interactions to validate test cases to ensure application perform as expected and is technically sound.
• Analyzed and Revalidated post production issues reported by End users from production environment.
• Designed, documented and implemented Test Plan for the Automation and conducted walkthroughs with the development. Assisted Dev with debugging and developed test automation solutions.
• Reviewed BRD/FDD/TDD to understand application scope, requirements and functionalities for various Projects.
• Developed Test plan/Strategy for each testing efforts to identify test scope, Roles and responsibilities, types of test planned, test milestones and acceptance criteria.
• Responsible for leading QC Pilot Project and established the test cycles and sets for the team. Assigned, Prioritize and scheduled test cases prior to the test case execution.
• Involved in GUI Web application Testing, Manual Testing, Functionality Testing, Regression Testing and Integration Testing.
• Executed test cases using QC Manual Runner. Reported defects for failed conditions using HP Quality Center and retested resolved defects.
• Created test metrics to ensure test coverage, test effectiveness and testing productivity. Reviewed/Approved and linked the test cases to the requirements for the traceability and test coverage.
• Entered requirements Business/Functional/Tech using HP QC for the BA's to be reviewed/Approved. Imported Testing scenarios, Test cases written in MS Excel into HP Quality Center.
• Performed defect tracking and maintenance and identified defect root cause critical area.
• Extensively work on SQL Queries, Stored Procedures, Functions, Views, Joins, Triggers, and Cursors to retrieve data.
• Performed System Integration Testing, End-to-End Testing and Regression Testing in the ITE environments. Structured UAT will be conducted at the end of the SIT.

Environment: ORACLE, SQL Server 2005, SSIS, SSRS, ORACLE 9g, C , XML, Dataware House, Informatica, UNIX.