PROFESSIONAL SUMMARY:

• 7+years of extensive experience as a QA Engineer involving in the entire SDLC and working with DWH/BI applications for various industries Data Modeling, Data Extraction, Data Loading and Data Analysis.
• Extensive experience in ETL and BI testing of DWH applications and reporting applications.
• Proficient in writing Test Strategies, Test Plans, Test Cases, Test Scripts and Test Scenarios
• Experienced in testing requirements that were developed in ETL and BI of DWH applications and reviewed scripts for positive and negative test scenarios, and prepared test summary.
• Possess extensive experience performing Backend, Frontend, Regression, Functional, System, Interface, Usability, Black box, Integration and User Acceptance Testing.
• Extensive Experience in Agile Methodology and waterfall methodologies of SDLC.
• Well experienced in writing complex SQL queries for extracting data from multiple sources.
• Technical strengths and automated test tool expertise includes Quick Test Professional (QTP), Quality Center, VBScript, SQL and Rational Tool Suite
• Excellent experience in different Databases like Oracle, MS SQL Server, DB2 and Teradata.
• Proficient in HP s Quality Center for Test Designing, Requirement Mapping, Reports and Defect Tracking
• Extensive experience working with ETL tools like Data Stage, Informatica, AbInitio, SSIS, and AutoSys tools.
• Experience in testing and writing SQL and PL/SQL statements.
• Good experience in Business Objects, Cognos, Micro strategy and Crystal Reports testing
• Hands on experience in writing SQL queries, Joins, Functions, Procedures, Packages, DBMS, RDBMS, and Triggers in Oracle and SQL Server databases.
• Created requirements from Test plans, FRD, Use cases and updated those is Requisite pro and then in Clear Quest (CQ), Quality Center (QC) and Application Life Management (ALM).
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema and working with slowly changing dimensions Type I II and III.
• Ability to work independently or in a team environment or in a rapid pace environment. 
• Possess strong interpersonal skills, communication and presentation skills with the ability to interact with people at all levels.

TECHNICAL SKILLS:

Testing Tools: Quick Test Pro (QTP), Test Director, HP Quality Center 10/9.2/8.2

ETL Tools:  InformaticaPowerCenter 8.6.1/8.1,7.x, Data Stage 8.1, Ab Initio (GDE 1.15, Co>Op 2.15)

BI Tools: Business Objects, Cognos, Crystal Reports, SSRS

IBM Rational Suite Rational Functional Tester: 8.0/7.0, Rational Clear Quest, Clear Case

Scripting languages:  VB Script, HTML, Shell Scripting

Operating Systems: Windows XP/NT/2000/Vista/7, DOS, UNIX

Databases Oracle: 11g/10g/9i, MS SQL Server, IBM DB2, Sybase and Netezza

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City

Sr. QA/ETL/DWH BI Tester

Responsibilities:

• Designed and executed various well described Test scripts for System testing based on the Functional Design Document.
• Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• Estimated UAT effort for individual change item and ensured schedule commitments met.
• Developed ETL test cases for various lines of businesses based on ETL mapping document.
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and Oracle databases.
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
• Investigating issues occurred while System testing and Regression testing.
• Involved in validating SSIS and SSRS packages according to functional requirements.
• Involved in investigating the errors by tracking the root cause for the error.
• Collected evidence for each step of the process to ensure that any errors are captured in time and resolved immediately.
• Extensively used ETL for testing and supporting data extraction, transformations and loading processing in a corporate - wide-ETL Solution using Informatica.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI
• Have programming skills in SQL and PL/SQL and experience in Oracle databases on UNIX and Windows platforms.
• Wrote SQL and PL/SQL scripts to validate the database systems and for backend database.
• Raised defects in HP Quality Center defect tracking system. Log project related issues in the defect tracking tool identified for the project (Rational Clear Quest)
• Designed Traceability Matrix to match test scripts with the Functional design document.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Experience in testing Business Report developed in Business Objects XIR2
• Developed User-Acceptance Test cases and assisted users in conducting UAT.
• Worked with ETL group for understating mappings for dimensions and facts.
• Tested data from various sources like Oracle, flat files and SQL Server.

Environment: Informatica 9.6.1/9.1, Business Objects, Teradata 14.0, XML, XSLT, Rational Clear Quest, Rational RequisitePro, HP Quality Center 11.0, HP QTP/UFT 11.0, MS SQL Server 2012, DTS,, TOAD, SSIS Oracle 11g/10g, PL/SQL, UNIX, PERL, MS Access, Sybase, Flat Files.

Confidential, Minneapolis, MN

Sr. QA DWH ETL Tester

Responsibilities:

• Extensively involved in Business Analysis and Requirements Gathering
• Analyzed business requirements and interfaced with vendors for development and enhancement of a system to support multiple business areas including Asset Management, portfolio management and risk management.
• Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
• Performed Regression, UAT and Database testing. Performed data validation-using SQL.
• Involved in analyzing the requests for new, enhanced, and modified systems, against user and business requirements.
• Conducted discussions and facilitate requirements gathering, process analysis, and application design sessions with company staff across all levels and functions
• Responsible for validating the files availability, format and data on UNIX server
• Executed SQL queries to verify the flow of data between back end and front end.
• Coordinated system walk through, training, User Acceptance Testing (UAT) and facilitate issue resolution
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD/Exceed.
• Strong hands-on experience in maintaining and using IBM Rational Clear Quest for Defect reporting, tracking & Change Management.
• Performed ETL testing and extensively used SQL functionalities. Used TOAD to connect to Oracle Database.
• Executed SQL queries to verify the flow of data between back end and front end.
• Performed Data Driven Testing of the Application for different users/data sets
• Developed Test cases for the data warehouse in Oracle System
• Conducted Functional testing to ensure that the application meets the requirements and to ensure usability readiness
• Involved in creation of defect analysis report for system Test and UAT.
• Experience in creating UNIX scripts for file transfer and file manipulation.

Environment: Informatica Power Center 9.1, SQL,, HP Quality Center 10.0, HP QTP/UFT 10.0, PL/SQL, UNIX, Toad, Test Director V7.6, SSIS, Windows NT, Sun Solaris, MS SQL server 2010, Rational Functional Tester, Rational Clear Quest, Rational RequisitePro, Oracle 10g, Crystal Reports and Netezza.

Confidential, Baltimore MD

ETL SQL DWH QA Test Analyst

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Assisted for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• Wrote Complex SQL queries to support the test case results.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Assisted in promotion of Informatica code and UNIX Shell scripts from UAT to Production.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Assisted in System Test and UAT testing scenarios as required
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS packages.
• Scheduled and managed QA/UAT execution activities and defined, wrote and prepared QA/UAT Test Strategy, Test Plan and Test Scripts.
• Extraction of test data from tables and loading of data into SQL tables.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Proficiency in using Rational Clear Case for Documentation and used Clear Quest for Defect tracking.
• Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
• Written several complex SQL queries for validating Business Object Reports.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Used Quality Center to track and report system defects
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: Informatica 8.6.1, Cognos 8.2, MVS, UNIX, Oracle, SQL Server 2008, Rational Functional Tester, Rational Clear Quest, Rational RequisitePro DB2, Quality Center 9.2, QTP 9.2Windows 2000 Pro,, Sybase, XML, XSLT, XSD, Rapid SQL, PL/SQL, TOAD, XML Files, SSIS.

Confidential, Atlanta, GA

ETL QA Engineer

Responsibilities:

• Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging defects.
• Involved in development and implementation of test cases test plans test data and test scripts for customers.
• Involved in testing the data warehouse for both the initial load and the incremental loads of the target
• Involved in various kinds of testing like functional testing, system testing and integration testing.
• Constructed context diagrams and data-flow diagrams based on the description of a business process. Analyzed the data model to code efficiently in SQL.
• Worked on generating reports using SQL and PL/SQL. Worked on tuning SQL statements.
• Involved in preparing detailed Business Analysis documents, ETL design documents, unit test plans for the mappings
• Defined and executed test cases across a number of internally developed Front and Middle office applications through Clear Quest.
• Involved in complete life cycle activities like pre-testing phase and testing phase.
• Analyzed system requirements specifications, developed executed detailed test plans test cases, security and usability of application information.
• Created Test Procedures and Test Cases to perform the system testing and Regression testing.
• Attended bug review and client meetings.

Environment: Informatica power mart 7.1, Toad, Test Director, SSIS, Visual Basic 6.0, Rational Functional Tester, Rational Clear Quest, Rational RequisitePro Oracle 9i, Windows 2000, UNIX.