SUMMARY

• Over 7+ years of experience in Software Quality Assurance and Quality Control.
• Excellent Functional knowledge on various domains like Finance, Banking, Derivatives, Equities, Fixed Income, Confidential and Telecommunication.
• Good knowledge of Quality Assurance methodologies like Agile, Waterfall, VModel, Scrum.
• More than 3+ years of experience in ETL Testing.
• Proficiency in Backend Testing/Database Testing specifically in developing and executing SQL queries to interact with databases and also involved in review of ETL architecture, ETL design, and analysis and ETL technical specifications.
• Extensive experience in testing to ensure that ETL process functions well with all the upstream and downstream processes.
• Proficient in different types of testing that includes Black Box testing, Smoke testing, Functional testing, System Integration testing, Load Testing, Performance Testing,
• Stress Testing. Regression testing, End - to-end Testing, & User Acceptance testing (UAT) and also has good knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Well versed with writing detailed test cases for functional & nonfunctional requirements.
• Experience in designing, documenting, and executing test plans, test harness, test scenarios/scripts & test cases for Manual, Automated & bug tracking tools.
• Responsible for collection of metrics/ reporting on metrics/ design preventative and corrective measures for senior management consideration.
• Understanding and experience working on a variety of technologies such as UNIX & HTML.
• Work experience reviewing and testing of data maps between various legacy systems and relational databases. Experience in IT testing with expertise in test plan preparation, system testing and in automated tools such as QTP.
• Expertise in use of Quality Center (QC) & Test Director for writing test cases, test execution, defect management, defect tracking and Bug Reporting.
• Experience in creating Traceability Matrix to ensure comprehensive test coverage of requirements.
• Experience in interacting with business analysts, developers, technical support & help them base line the requirement specifications.
• Attend periodic meetings, teleconferences and led discussions on problem resolution.
• Extensive experience working with onsite/ off site team model; Aware of the cultural issues; Aware of the issues in terms of planning efforts/ schedules etc.
• Open to dynamic work environment and ability to work collaboratively with business analysts, other testers, developers and other team members in the overall enhancement of software product quality.

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

ETL QA Tester

Responsibilities:

• Involved in Business meetings to understand the assumptions of implementing new application.
• Providing estimation based on the assumptions.
• Revised estimation in case of discrepancies in assumptions.
• Assigning resources throughout the SDLC process based on the Test Estimates.
• Preparation of Test strategy (Functional, Conversion and E2E).
• Preparation of ETL Test Scenario's Based on FSD.
• Working with Front end and UAT teams to prepare E2E scenarios.
• Working with Vendor in case of data issues. (Conversion and Functional)
• Performed ETL Test case Execution with highlights, risks, test case summary, defect summary and test design summary.
• Performed requirement based testing and Regression testing of the whole application with different scenarios.
• Interacted with development and Vendor team to fix the issues.
• Involved in ETL Functional, Conversion, Regression and E2E Testing.
• Review work delivered by offshore team members and mentored junior team members.
• Participated in status meetings to report issues. Communicated with developers through all phases of testing to prioritize defect resolution.
• Preparation of Test summary report. (Including Purpose of the Document, Testing scope, Metrics used, types of testing performed, test environment and tools, lessons learned, recommendations, best practices, exit criteria and conclusion/sign off).
• Preparation of daily, Weekly status reports.

Environment: Quality center, Oracle, Toad, XML, HTML.

Confidential

Sr.QA Tester

Responsibilities:

• Coordinated all QA activities and enhancements using Agile Methodology.
• Conducted Smoke testing, Functional testing, Regression testing, Integration testing, and User Acceptance Testing (UAT) and Data validation testing.
• Developed and maintained multiple project deliverables such as Test Plans and Test Cases.
• Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
• Tested the performance bottlenecks at sources, targets, mappings, and sessions and employed required measures.
• Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
• Created Integrated summary data from multiple Oracle tables to represent the business perspective of the top management executives
• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various cruise specialists and the business team.
• Prepared scripts, running tests, Analyzing results for Performance testing.
• Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
• Executed SQL queries for validation of data and used SQL Server to write SQL queries for validating constraints, indexes.
• Executed and managed test cases and reported bugs in Quality Center.
• Used Clear Quest and Quality Center as the Defect management Reporting tools.
• Created and executed automated tests for functional, and regression testing using Quick Test Professional
• Inserted various types of checkpoints including text checkpoints, text area checkpoints and Image checkpoints.
• Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
• Hands on work experience working with offsite team model; Coordinate my own efforts with team members in the offsite team.
• Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.

Environment: Windows - 7, Vista, XP, UNIX, SQL Server 2008, SQL, PL/SQL, QC 10.0, QTP 10.0, HTML, XML, Word, Excel, PowerPoint, Outlook, MS Visio, MS Project, Firefox, IE, Chrome, Safari

Confidential - Houston, TX

QA Tester

Responsibilities:

• Analyzed system Specifications and design document and developed test plans.
• Prepared the test environment including setup of facilities, hardware and software.
• Tested modules dealing with property and casualty Confidential of auto and homeowners.
• Created test templates, test cases and conditions using Quality Center.
• Used QC as a defect tracker.
• Preparation of Test Plan which specifies testing overview, testing approach, testing strategy, roles and responsibilities and scope of testing.
• Executed different scenarios like compatibility, scalability, and load test to identify bottlenecks on every component of the system.
• Developed Automation test scripts for Regression testing of the application.
• Performed Load Testing on the application using Load Runner.
• Executed test scenarios in different test environments.
• Interacted with Business Analysts, Developers and QA team members in different defect raising situations.
• Created a cycle that tests the user interface of the application and the application's performance under stress.
• Performing queries on the database using 'SQL' to check successful Transaction & to create particular test cases.

Environment: Load Runner, QC, HTML, Oracle, SQL, Microsoft SQL Server and UNIX.

Confidential, Milwaukee, WI

Manual Tester QA

Responsibilities:

• Review the Business/Functional/System Requirement and Specifications Analysis and Design phase.
• Responsible for analyzing business requirements and development specifications to create and execute test plans.
• Created Test Scenario based on Business Requirement and Test Cases to validate functionality during Functional testing.
• On daily basis interact with Developers to discuss defects and remediation.
• Develop and maintained traceability matrix between requirements and test cases
• Executed Test cases, logged defects and attended defect triage (with the developer, BA and tester) meeting to help understand defects and recreation steps.
• Executed Integration test cases along with developer and Business Analyst.
• Create and executed data driven test scripts in QTP
• Conduct Functionality testing during various phases of the application using QTP
• Checked the data flow through the frontend to backend and used SQL queries to extract the data from database.
• Generated SQL queries to validate the data in the database.
• Conduct Backend testing using SQL Queries. (like insert, check constraints, update, delete and joins)
• Provide Testing status to Test Lead on daily basis.
• Attend project meeting to provide testing updates to team and discuss any issues impacting testing schedule.

Environment: MS Office tools, PL/SQL, Windows NT/2000, HTML, JIRA, SQL, Quality Center, Quick Test Professional, HP ALM.