OBJECTIVE

• To acquire professional edge through hard work and continuous learning. Seeking an Interactive and Challenging environment wherein I can apply my interpersonal and technical skills to add value to quality process.

SUMMARY

• Quality Assurance Analyst with 6 years of experience in Database, System, Functional, Automation and Regression testing in Banking, Education and financial domain.
• Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL for data integrity.
• Involved in ETL process testing using Informatica ETL tool.
• Extensive experience with Quality Assurance Testing on Client - Server and Web Based applications, Data Driven Applications using Manual and Automated testing procedures.
• Created test plan, test strategy, test cases and test report on basis of business requirements and software requirements specification.
• Experience in manual testing and automation testing using HP/Mercury Quick Test Professional.
• Experience in using HP Quality Center, Test Director, Bugzilla and Jira for Bug Tracking and Defect Reporting.
• Excellent problem solving skills, experience in working group projects, desire and ability to learn and apply new technologies. Self motivated and detail oriented
• Actively participation in walkthroughs, project status and SQA meeting.

TECHNICAL SKILLS

Operating Systems: Windows

Database: MS-SQL, Oracle, SQL Server, MySQL

Languages: SQL, VB Script, Java Script, XML

Tools: SQL Server Management Studio, Informatica 8.1.1, QTP 10.0, 11.0

Defect Management Tool: QC(Test Management tool) 10.0,11.0, Bugzilla, Jira

PROFESSIONAL EXPERIENCE

Confidential, MN

Quality Assurance Analyst

Responsibilities:

• Interacted with Project Manager, Business Analysts and Developers to analyze data error timely and effectively to ensure deliverables on time.
• Experience in preparing test strategy, developing test plan by decomposing Business Requirements, and developing test scenarios to support quality deliverables.
• Performed database testing by writing complex SQL queries to verify data loaded by developer team based on technical document.
• Used Web Based Virtual Integration Management System for defect tracking and reporting, also followed up with the development team to verify defect fixes and updated defect status.
• Conduct extensive Database testing to ensure data validation and data integrity.
• Design and Executed SQL scripts to validate all defined criteria.
• Review data load, mail file, check file and internal application to maintain data quality.
• Actively participated in project and QA team meeting.
• Providing training to new team member.
• Effectively communicated, documented and validate data defect across department.

Confidential

ETL tester

Responsibilities:

• Worked closely with development and business team to understand requirements and business flows.
• Tested the ETL Informatica mappings
• Performed data validation testing writing complex SQL queries.
• Prepared Test Conditions and Test cases based on the system requirements
• Preparing the SQL script to compare the counts and data from source to target.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.
• Review and understand the ETL processes, functionality and identify test requirements and coverage.
• Reporting and tracking the defects in Quality Centre.
• Prepare test status reports during test execution process, Participate and report statuses in all test-related projects team meetings.

Confidential

Software Quality Tester

Responsibilities:

• Worked with Business Analysts and Developers in requirement gathering, analysis and documentation.
• Performed database testing by writing complex SQL queries.
• Working knowledge of using QTP Scripts with Standard, Text, Bitmap, Table Checkpoints and Synchronization Points.
• Re-running of the Test Scripts after deployment of each new build in the application for identification of errors, and manipulation of the script for Customization of Testing Process.
• Designed and developed automation test scripts using Quick test Professional and managed testing activities using Mercury Quality Center.
• Used Quality Center to prepare Test cases, procedures, Requirements Traceability Matrix and managing the Defects as per the Business requirements.
• Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.

Confidential

Software Quality Tester

Responsibilities:

• Responsible for preparing test plans, test strategy, developing test cases, test procedures and test scenario.
• Perform functional, regression and GUI testing.
• Write and record scripts for functional and regression testing using descriptive programming in QTP.
• Optimized QTP scripts for Regression testing of the application with various data.
• Worked with Developers and BA to analyse software requirement specification and investigate, prioritize and resolve software bugs based on testing results.
• Inserted Bitmap and Text checkpoints where needed, to compare the current behavior of the application using Quick Test Pro (QTP).
• Conduct database testing by using SQL queries.
• Utilized Test Director /HP Quality Center for managing requirement documents (RD), and bug reporting/tracking tool.
• Created detailed periodic status reports and actively participation in weekly meeting.

Confidential

Junior Software Quality Tester

Responsibilities:

• Involved in preparation of Test Plan, Test Cases and Test Scenario based on requirement specification.
• Conducted system, functional and user interface testing.
• Involved in Automation of Web Application and performed testing with multiple sets of data driven test using QTP.
• Involved as part of automation team using QTP, developed test scripts, executed test cases, validate test results, and determine defects.
• Created Test Cases and Test Scripts in Quality Center as per the business requirements and executed them.
• Reporting and tracking defects using QC.
• Worked with the Business Analysts and Developers to resolve the defect issues.
• Conducted Peer reviews Meetings with the Team members and Development Team.
• Attended the Walkthroughs and status meetings.

Confidential

Quality Tester

Responsibilities:

• Understand the Requirements and Functional Specifications of the application.
• Designed and developed test plan and test cases on basis of requirement specification.
• Generated test scenarios and test data. Executed tests and created incident reports.
• Analyzed test results, identified issues and report defects using Jira.
• Performed manual testing for core functionality.
• Involvement in Test Reporting on daily, weekly basis and reported it to developers and project managers.
• Attended weekly defect report meetings and presented progress updates.