SUMMARY

• Over Seven years of testing experience/System Analyst in E - commerce, Web and Client/ Server applications with Quality Center, QuickTestProfessional (QTP) and WinRunner.
• Sound knowledge in Software Development Life Cycle (SDLC) & Software Testing Life Cycle (STLC)
• Excellent experience in System Testing, Integration Testing and User Acceptance Testing in Client-Server and Web-based applications
• Expertise in performing Black Box Testing, Smoke Testing, User Acceptance Testing (UAT), System Testing, Regression Testing and Integration Testing.
• Executed and updated SQL queries for manual and automated Back-End Testing.
• Excellent interpersonal skills and communication skills, proven team player with an analytical bent to problem solving and delivering under high stress environment with resource constraints.
• Excellent understanding of Software Development Life Cycle (SDLC) and Test Methodologies from project definition to post-deployment documentation.
• Devised, implemented Software Testing Methodologies/Strategies in both Client/Server and Web based applications to ensure Quality Assurance Control. Excellent skills in overall Defect Management/Problem Solving including tracking bugs, reporting using Quality Centre.
• Strong in Analyzing Business requirements and design specifications and development of Test Plans, Test Scripts, Test Cases and executing them. Ability to interact with developers and product analysts regarding application analysis.
• Performed Database Verification and Validation testing using SQL queries
• Experience in writing Complex SQL Queries in SQL Server for Database Testing and Test Data Preparation
• Very strong in Functional and Regression testing using the Quick Test Professional.
• Strong business understanding knowledge of Financial and banking, Insurance, Manufacturing and Pharmaceutical Projects. Very good at bug-reporting and bug-tracking using the test management tool like Test Director.
• Extensive experience in functional testing, unit testing, integration testing, regression testing, black box testing, white box testing, GUI testing, back-end testing, browser compatibility testing, in different stages of Software Development Life Cycle (SDLC).

TECHNICAL SKILLS:

Testing Tools: QTP 10/9.5/9.2, Quality Center, Win Runner, Selenium IDE.

Operating Systems: Microsoft Windows 98/2000/XP/Vista, Window Server 2003, UNIX.

Databases: Oracle 8i/9i/10g, MS Access, SQL Server 2000/2005/2008.

Development Environment: Weblogic, Eclipse IDE.

Domain Knowledge: Banking, Financial, Insurance, Healthcare and Manufacturing.

ETL TOOLS: Informatica 8.1, 8.6.1.

Testing Type: Black Box, Functional, Integration, System, Regression, User Interface, Database, ETL Testing.

Application Servers: WebLogic and WebSphere.

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburg PA

QA Analyst / Tester

Responsibilities:

• Involved in gathering business requirements for the project by interacting with the end client and holding sessions with developers. Analyzed business and technical requirements developed strategic Test Plans, Test Cases and Test scripts.
• Constructed complex SQL Queries to validate aggregation of schemes data at target tables.
• Responsible for data quality at target database tables as per the business requirements.
• Validated 24 Informatica mappings, which are constructed by the developers and responsible for signoff on it. Helped new team members understand the Business requirements & system flow.
• Responsible for executing the Test Cases, Test Scripts using Quality Center.
• Performed build readiness testing after each build to make sure the application is read for testing.
• Ran the scripts on multiple environments (QA, UAT and Production) to ensure that requirements were still met.
• Involved in writing Test Plan for the testing effort of the module.
• Developed and executed Test Cases and Test Scripts based on the requirement documents and managed it using Quality Center.
• Conducted functionality testing manually prior to Automated testing.
• Performed Negative and Positive testing manually.
• displayed in the AUT during the test run.
• Extensively used SQL in Toad for querying the database tables to verify the data as Back End testing..
• Created many function libraries using VBscript. Used Quality Center extensively for maintaining requirements, creating traceability matrix and defect tracking purposes.
• Generated Post Execution Reports using Quality Center Document Generator.
• Developed automation of test cases using Quick Test Pro to perform Regression Testing for different versions of application. Sent reports to Manager and business during the execution phase.
• Responsible for reviewing Test Scripts and Test Cases written by other members of the team.
• Responsible for prioritizing the defect and attending defect review board meeting.
• Wrote complex SQL commands for back end testing on the database.
• Expertise in QA Testing in distributed Windows Environment and Oracle databases as back end.

Environment: HP Quality Center 10, Selenium IDE, Unix, Sql Server 2008, XML.

Confidential, Jersy City NJ

QA Engineer

Responsibilities:

• Identify the Test Scenarios based on the Business Requirement Document (BRD) and obtain sign-off of the Test Scenario document from the respective business owners
• Defined and implemented Testing Practices including Test Strategy and SCRUM Testing Process Workflow for Subdirectory using Agile QA methodology
• Created application independent test automation framework using Keyword Driven approach for reusable and modular test scripts
• Used HP Quality Center 9.0 for Defect Tracking, Organizing, Managing, Planning and Executing the Tests
• Planned all QA activities including Sanity, Full Length Functional, Regression, Compatibility, Integration, Load testing
• Performed web-site testing to test Links and security issues
• Creation of Requirements to Test cases traceability in Quality Center for each release.
• Used different joins on the tables to retrieve information from different tables in database to check the database on a regular basis using SQL queries
• Logging and tracking defects and measuring the testing effort and the quality of the software by creating reports in Quality Center
• Monitor releases and builds going out to production and track production bugs over time
• Performed System Testing before the application went into staging & production
• Verify all projects have undergone at least two complete cycles of testing (all test cases executed) for the alpha and final release testing milestones
• Requirements for staffing, back end testing, and automation testing are identified
• Setup and run Bug Triages (Bug Review Meetings, minimum of weekly meeting once in development)
• Trouble shooting of customer issues on daily basis

Environment: QTP 9.2, Quality Center 9.0, SOAP UI, XML, HTML, Ajax, PHP, Unix.

Confidential, Thousand Oak, CA

QA Analyst

Responsibilities:

• As a QA Analyst, responsible for Analyzing ETL system specification and Transformation requirement. Interacted with business analysts and Developers and developed the Test plans. Participated in Walk through and Defect report meetings periodically.
• Validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center as per the ETL process defined by the project management.
• Designing the Test Cases based on requirements and HLD & LLD. Responsible for Functional, Regression testing, Integration testing.
• Constructed complex SQL queries to validate the data in between Source Tables Vs Data warehouse as per the Transformations defined in Data Specification documents.
• Used Mercury Quality Centre 9.2 for requirements management, planning, scheduling, running tests, defect tracking and manage the defects and executing the test cases Interacted with Developers for analysis of the Application.
• Involved in testing Cognos Reports manually in the initial stages and in the later stages Carried out Automated tests and batch tests in QTP 9.2 using Quality Centre. Used database check points in test script to check databases and detect defects.
• Experience in System, functional and Regression testing methodologies.
• Communicating with Offshore Team and assigning the Scripts to the Team. Investigated software faults and interfacing with developers to resolve technical issues. Defect tracking, defect reporting, analyzing results and documentation.
• Conducted defect tracking and fix progress meetings and planned back-up and alternate solutions to make the developers life easier.
• Involved in submitting Bug Report weekly. Used resource Excel spread sheets to list problems for different modules. Performed Data Validation before loading into the target database and documented test results in comparison with the expected results. Preparing test summary reports.
• Preparing the Understanding documents. Testing the scripts in QA, Staging and Production databases.

Environment: Mercury Quality Center 9.2, Mercury Quick Test Professional 9.2, Window Vista, Informatica 8.1, Oracle 10g.

Confidential

Quality Analyst

Responsibilities:

• Worked closely with team members to discuss the testing aspects of the applications to design the Test Plan.
• Analyzed the business requirements document to formulate the Test Cases and test plan.
• Documented Test Cases corresponding to business rules and other operating conditions.
• Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes.
• Performed Positive and Negative testing.
• Conducted Functional, Regression and System testing.
• Conducted Manual Testing for the entire application.
• Gathered requirements for UAT (User Acceptance Testing) and created Scripts based on business.
• Created Test data to support the User Acceptance Test Cases.
• Wrote the SQL queries to validate the data created in backend.
• Involved in Planning and Implementation tasks and schedule check list meetings / reviews.
• Responsible for weekly status meetings showing progress and future testing efforts.

Environment: Mercury Quality Center 8.2, SQL Server, UNIX, Window Server 2003.