PROFESSIONAL SUMMARY:

• 7 years of diversified experience in complete SDLC life cycle with analysis, design, testing and maintenance of business applications using ETL and BI.
• Strong knowledge of data warehousing concepts
• Extensive experience in complete testing life cycle including requirements review, test plan preparation, test case preparation, test script preparation, test execution and defect logging
• Work with Business Analysts and key Business Users to develop major Test Scenarios
• Hands on experience in positive testing, negative testing, smoke testing, regression testing, retesting, load testing, stress testing, performance testing and user acceptance testing.
• Developed Ab Initio test environment for UAT testing and used all Ab Initio components while testing the graphs and ran the jobs on back ground.
• Good understanding of data warehousing concept and different strategies for testing of DWH applications
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Access, Flat Files and XML files and VSAM files
• Experienced in test data preparation for positive and negative testing scenarios
• Created ETL test data for all ETL mapping rules to test the functionality of the Ab Initio graphs
• Experienced in testing BI reports generated using different BI tools like Cognos and BO
• Strong knowledge of Extract Transform & Load (ETL) processes using UNIX shell scripting
• Hands on experience in writing, executing and debugging SQL queries to perform source to target data audit for data accuracy and completeness.
• Tested the ETL Ab Initio graphs and other ETL Processes (Data Warehouse Testing)
• PL/SQL (Stored Procedures, Functions and Triggers) for validating data between source and target
• Experienced in Tuning SQL statements and procedures for enhancing performance.
• Point of contact for off shore team responsible for work allocation & coordination activities.
• Leadership skills, excellent verbal and written communication skills, ability to work independently with minimal supervision, be a team player, well organized and efficient with excellent judgment and decision - making skills.

TECHNICAL SKILLS:

Testing Tools: HP Quality Center10/9.2/Test Director, Clear Quest, QTP 8.0

Utility Tools: TOAD v.10.5, SQL Server Management Studio, SQL*Plus, SQL*Loader, SQL Developer, SQL Assistant

Databases & RDBMS: Oracle 10g/9i/8i, DB 2 8.0/7.0/6.0, SQL Server 2000/2005/2008, MS Access, Teradata V2R4

Operating Systems: Windows 98/2000/XP/7, Linux and UNIX

Languages: SQL, PL/SQL, T-SQL, C, C++, Dot Net

Networking: TCP/IP, FTP, UDP, ATM, Ethernet, LAN & WAN

Data Warehousing Tools: Informatica 8.6.1/8.1.1, DataStage 7.5

BI Tools: Business Objects XIR3, Cognos 8, SSIS

PROFESSIONAL EXPERIENCE:

ETL/DWH Test Lead

Confidential, NJ

Responsibilities:

• Functional and Technical understanding of the insurance domain to validate the data obtained from the insurance members.
• Analyzed requirement documents like BRD and SRS and worked with business partners, analysts, developers and project managers to develop test plan.
• Experienced in coordinating resources within Onsite-Offshore model.
• Metadata graphs from legacy source system to target database fields and involved in creating Ab Initio DMLs.
• Designed & Created Test Cases based on the Business Requirements, Source to Target mapping & Transformation rules document.
• Developed Tractability Matrix and Test summary reports.
• Ensuring smooth onsite to offshore transition of requirements and conducting knowledge transition sessions.
• Used SQL*LOADER to store data in the Oracle database from different types of flat files.
• Managed and conducted smoke, functional, integration, system, regression, retesting, and performance testing
• Involved in developing Unix Korn Shell wrappers to run various Ab Initio Scripts
• Coordinated system walk through, training, User Acceptance Testing (UAT) and facilitate issue resolution
• Manually performed Back-End testing by writing SQL queries and validating the database using Complex SQL Joins and Functions.
• Experience in Leading the Offsite Project, managing a team of 8 Offshore and 4 Onsite consultants..
• Worked with all kinds of components with Ab Initio including Dedup, Denormalize, Normalize, Rollup, Scan, Reformat, Redifine, Sort, Joiner, XML Read, XML Write, FBE, Partition Components.
• Report product bugs, bug isolation, verify fixed bugs and issue resolution.
• Interacted with the client on a daily basis and attended status meetings
• Extensively used the AutoSys jobs for the entire project.
• Tested Ab Initio graphs and used Ab Initio as an ETL tool to load the final loads.
• Used HP Quality Center for requirements, test cases and defect tracking.
• Responsible for identifying the performance bottleneck in Mapping, Sessions and Targets.
• Performed Data Driven Testing of the Application for different users/data sets
• Tested BO report for performance and functionality like cross tab, table, charts and Drill-up, Drill down, Slice and Dice
• Worked closely with offshore team and allocated and jobs for completion
• Coordinated and Developed user documentation for all the application modules.

Environment: Ab Initio CO>OP 2.15, GDE 1.15, ERWin, Business Object XIR 3.1, ORACLE 9i, Sybase, TOAD, SQL*plus, SQL*Loader, Remedy 7.0, Linux, Windows 2000/NT, HP Quality Center 11.0, XML, XSLT, XSD, XML Spy 2010, .

ETL QA Tester

Confidential, NY

Responsibilities:

• Functional and Technical understanding of domain with reference to BRD, SRS and design documentation
• Develop and execute functional/system test cases to ensure ETL data movement meets functional and design specifications.
• Tested Ab Initio graphs and used Ab Initio as an ETL tool to load the final loads.
• Developed Tractability Matrix and Test Coverage reports.
• Worked with different sources such as Oracle, Excel, Flat file, COBOL.
• Functioned as the Onsite / Offshore coordinator for a team.
• Manually performed Back-End testing by writing SQL queries and validating the database using Complex SQL Joins and Functions.
• Worked with all kinds of components with Ab Initio including Dedup, Denormalize, Normalize, Rollup, Scan, Reformat, Redifine, Sort, Joiner, XML Read, XML Write, FBE, Partition Components.
• Performed functional test and load test on SQL queries, store procedures and forms.
• Reviewing the project and coordinating with onsite Clients, onsite Project Leads and local reporting managers.
• Performed smoke, functional, integration, system, regression, retesting, performance and User Acceptance Testing.
• Ensuring onsite to offshore transition, QA Processes and closure of problems & issues.
• Analyze data using SQL, Excel, UNIX & data testing tools. Review SQL code.
• Used SQL*LOADER to store data in the Oracle database from different types of flat files.
• Report product bugs, bug isolation, verify fixed bugs and issue resolution.
• Tested graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio ETL Tool.
• Tested BO report functionality using WEBI like cross tab, table, charts and Drill-up, Drill down, Slice and Dice
• Worked closely with offshore team and allocated and jobs for completion
• Managed Test cycle reporting & status meetings / coordination.
• Developed user documentation for all the application modules.

Environment: Ab Initio CO>OP 2.14, GDE 1.14, ERWin 7.1, Business Objects XIR3, DB2 9/8, TOAD, Unix, Windows 2003 Server, Autosys Scheduling Tool, MS Visio 2003, SQL, PL/SQL, WinSQL, Shell Scripting

ETL/DWH Tester

Confidential, Jersey City, NJ

Responsibilities:

• Designed & Created Test Cases based on the Business Requirements, Source to Target mapping & Transformation rules document.
• Developed separate test cases for ETL process (Inbound & Outbound) and reporting
• Developed and Performed execution of Test Scripts manually to verify the expected results
• Extensively tested ETL processes using DataStage ETL tool.
• Conducted Black Box - Functional, Regression and Data Driven and Integration Testing.
• Defects tracking, review, analyze and compare results using HP Quality Center.
• Identify and assess potential risks associated to testing scope, quality of the product and schedule
• Created and executed test cases for DataStage jobs to upload master data to repository.
• Conducted test case review and revision of surrogate key generation in DataStage to uniquely identify master data elements for newly inserted data.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Tested summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
• Extensively tested several Cognos reports for data quality, fonts, headers and cosmetic
• Tested the list, cross tab, repeater and Drill-through reports in different formats like PDF, XML and HTML.

Environment: Windows XP, Data Stage 7.5, QTP 9.2, SQL Server 2005, Quality Center 9.0, Oracle 10g, Java, Unix AIX 5.2,VB Script, IBM Cognos 8, XML, XSLT, XSD

DWH QA

Confidential, Princeton, NJ

Responsibilities:

• Performed Integration, system and Regression testing to validate report and mapping functionality.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Worked with XML transactions for multiple feeds.
• Performed quality assurance reviews on all System Development Life Cycle.
• Participated in defect review meetings with the team members. Used MS-Word for documentation.
• Involved in other test planning meetings and submitted test metrics daily to the management.
• Responsible for different Data mapping activities from Source systems to Teradata
• Worked with the DW Architecture team in Testing complex Delta processing Loads
• Wrote test scripts to compare OLTP vs OLAP for ETL testing

Environment: Siebel Analytics 7.8.4, Teradata V2R4, MLOAD, FLOAD, SQL, PL/SQL, Oracle 8i, XML, XSLT, XML Spy 2008, Shell Scripting, Informatica PowerCenter 6.2, Siebel epharma, UNIX.