SUMMARY:

• Over 7+ of experience in Software Testing and Quality Assurance, including data warehousing, reporting and web applications. Strong and flexible team player with self - driven enthusiasm to succeed .
• Manual software testing, Data warehousing and reporting, agile methodology. Strong focus on SQL and XML .
• Strong knowledge of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and QA Methodologies like Agile - Scrum, Waterfall .
• Involved in preparing the Test Plans, Test Strategy documents, Test Cases & Test Scripts based on business requirements, rules, data mapping requirements and system specifications .
• Experience on Functional testing, System Testing, Regression Testing, Integration testing, GUI Testing, Security testing, Smoke testing, System Integration Testing (SIT), Software Validation testing, UAT, Interface testing, and Performance Testing .
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, and Weekly Status Reports, Test Readiness Review Documents, Test Summary Reports .
• Experienced in Data Modeling for Data Warehouse projects and designing business logic. Extensive knowledge of Implementation of full Lifecycle in Data Warehousing Project.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators .
• Good understanding of FACT and Dimension tables. Very strong in SQL and PL/SQL, extensive hands on experience in creation of database tables, triggers, sequences, functions, procedures, packages, and SQL performance-tuning .
• Working Experience in Autopsy's. Strong experience in using Informatica mapping variables/parameters and session variables good in writing DOS commands .
• Have Good understanding of ETL/Informatica standards and best practices, Slowly Changing Dimensions (SCD1, SCD2, SCD3)
• Experience in testing coordination, writing test cases and executing test scripts, And logged defects in Quality Center (QC) .
• Extensively worked in the design, testing and applications development of data warehouses includes data marts, in 3NF & STAR schema .
• Thorough understanding and good experience on Data Loader. Working knowledge of Software development Life Cycle .
• Extensively Worked in Performance Tuning of SQL Queries. Extensively worked in estimation, analysis, design, coding, testing of development projects and has made quality deliverables in compliance with "CMM Level 5" quality standard .
• Extensively worked in preparing HLD and LLD. Excellent knowledge in MSBI. Extensively worked in creating various reports using SSRS .
• Good analytical and communication skills and able to implement projects on schedule. Exposure on Data warehousing concepts and PDW .

TECHNICAL SKILLS:

MS SQL Server (3 years), Oracle (4 years), SQL (4 years), SQL Server (3 years), Teradata (4 years)

SKILL SET:

Data Warehousing: Informatica PowerCenter, Datastage, SSIS, Autosys, Sqlplus, TOAD

Programming: Perl and Shell Programming, Python, SQL, PL/PLSQL.

Databases: Oracle 7.x/8/9i/10g, Teradata V2R6, MS SQL Server 2000/2005, IBM DB2 8.x

Reporting Tools: Business Objects, SSRS, SSAS, Cognos 8.0, OBIEE 11g, Tableau.

Operating System: Red Hat Linux (6.x/5.x/4.x), Microsoft Windows XP/7, IBM-AIX, HP-UX

Migration/Replication: Sqoop, Hive, DataPump, BCP, SQL Loader

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington, IL

ETL 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, Boston, MA

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, Cleveland, OH

ETL 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, Richmond, VA

ETL QA Tester

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.