SUMMARY

• Over 7 + years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Ab Initio, Informatica power Center
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Experience in testing and writing SQL and PL/SQL statements.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Experience in testing Business Intelligence reports generated by various BI Tools like Micro Strategy, Cognos and Business Objects
• Highly experienced with different RDBMS such as Oracle 9i and 10g, MS SQL Server 2000, Teradata, Mainframes DB2 and MySql.
• Experience in analyzing business specification documents, developing test plans, defining test cases, developing and automating test scripts.
• Extensive experience in Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing.
• Extensive experience in writing SQL and PL/SQL scripts to validate data warehouse.
• Involved in all the phases of Software Testing Life Cycle.
• Experience in UNIX commands and shell scripting.
• Experience with bug tracking tools like Quality Center and Clear Quest.

TECHNICAL SKILLS

Operating Systems: Windows Vista/XP/NT/2003/2000, Linux and UNIX

Databases: Oracle 11i/10g/9i/8i, MS SQL Server 2008/2005/2000 , Confidential DB2 8.1, Teradata V2R6, MS Access 2008

ETL Tools: Informatica Power Center 7.1, Ab Initio (GDE 1.15, Co. Op 2.15)

Languages: SQL, PL/SQL,Unix Shell Script, C

Testing Tools: Quality Center 10.00, Test Director, Rational Clear Quest

Reporting Tools: Micro Strategy 8.0, Cognos, Business Objects XIR2

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Responsibilities:

• Analyzed Business requirements from BRS document.
• Participated in rigorous meeting with Business and Development team in analyzing the requirements and estimating and defining the test approach.
• Involved in time estimates for ETL and reports validations.
• Prepared Test Scripts according to the business requirements in HPQualityCenter.
• Responsible for testing Business Reports developed by Micro Strategy.
• Performed Master data regression, which is very important data for THD.
• Validated the data for core customer tables, which is a part of Performance enhancements to the core customer tables.
• Preparation of various test documents for ETL process in Quality Center.
• Validated data for Teradata and Mainframes DB2
• Developed test cases to test Teradata scripts (Bteq, multiload, fastload).
• Validated microstartegy reports as well as dashboards.
• Validated functionality and data in dashboards and reports.
• Validated Drill down reports and Ad hoc reports developed by microstartegy.
• Written Complex SQL for validating the Ab Initio Graphs.
• Converted Business and system requirements into positive and negative test cases.
• Experienced with UNIX commands like ls, wc and grep.
• Used SQL Assistant to query Teradata database tables.
• Reviewed log files in UNIX for error cause when graphs failed.
• Involved in Non-Functional testing i.e. Back out and Implementation.
• Used Teradata Export and Import utility for loading and unloading the Flat file data into Teradata tables.
• Validated Complex Ab initio graphs using mapping document provided by development team.
• Worked on issues with development team for migration of defect fix from development environment to QA environment.
• Updated Project lead and Project Manager with QA daily status report.

Environment: Teradata V2R6, Oracle 10g/11i, Ab Initio, Quality Center 9.2, SQL, UNIX, TOAD, Teradata SQL Assistant, Mainframes DB2 PL/SQL, Micro Strategy 8.0, MS Office, Flat File, Windows

Confidential, Richmond, VA

ETL/BI Tester

Responsibilities:

• Analyzed system requirements specified in Quality Center Requirements.
• Participated in meetings for code migration from dev to QA.
• Extensively used SQL to validate Teradata tables loaded by Ab Initio Graphs.
• Reviewed source to target matrix document and developed validations.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Developed positive and negative test cases to validate Teradata tables.
• Executed Ab Initio ETL graphs from UNIX environment.
• Experienced with UNIX commands like ls, wc and grep.
• Used Unix VI Editor to access flat files data to validate target tables.
• Used SQL Assistant to query Teradata database tables.
• Validated Ab Initio transformations like reformat, filter and aggregates.
• Written complex SQL queries to validate ETL that loaded the data marts.
• Maintained defect life cycle from time to time using Quality Center.
• Preparation of various test documents for ETL process in Quality Center.
• Developed test cases to test Teradata scripts (Bteq, multiload, fastload).
• Used Toad for oracle for querying Oracle database tables.
• Compared Oracle and Teradata tables using Toad for Oracle.
• Responsible for testing Business Reports developed by Micro Strategy.
• Validated cosmetics like font and color in Micro Strategy reports.
• Written complex SQL queries to validate reports developed by Micro Strategy.
• Validated drilldown and crosstab reports developed by Micro Strategy.
• Worked with development team to ensure testing issues are resolved.
• Updated Project manager and QA Lead with QA and defect status.

Environment: Teradata V2R6, Oracle 10g/11i, Ab Initio, Quality Center 9.2, SQL, UNIX, TOAD, Teradata SQL Assistant, PL/SQL, Micro Strategy 8.0, MS Office, Flat File, Windows

Confidential, Durham, NC

Data Warehouse QA Analyst

Responsibilities:

• Analyzed the Functional requirements using Detailed Design Document.
• Setting up of environments to be used for testing and the range of functionalities to be tested as per technical specifications.
• Developed test cases and SQL queries based on mapping document.
• Worked with development team to ensure testing issues are resolved.
• Executed Ab Initio ETL graphs from Unix environment.
• Reviewed log files in UNIX for error cause when graphs failed.
• Written SQL queries to validate Ab Initio graphs and transformations.
• Queried Teradata target tables using SQL Assistant and documented results.
• Validated data marts against stage tables using complex SQL queries.
• Used SQL Server Management Studio to query SQL Server database.
• Tested reports like drilldown and crosstab reports developed by Micro Strategy.
• Validated filter and calendars in micro strategy reports.
• Conducted system and integration testing on Ab Initio ETL graphs.
• Tested summary reports, detail reports developed by Micro Strategy.
• Defects tracking, review, analyze and compare results using Quality Center.
• Preparation of various test documents for ETL process in Quality Center.
• Involved in time estimates for ETL and reports validations.
• Executed test cases and documented test results in excel spreadsheet.

Environment: SQL Server 2005/2008, Teradata V2R5, SQL, Ab Initio, Quality Center 8.0, SQL Assistant, Unix, SQL Server Management Studio, Micro Strategy 8.0,XML.

Confidential, SFO, CA

ETL/BI Tester

Responsibilities:

• Written test cases for validating Informatica Power Center mappings.
• Queried Oracle tables using Toad for Oracle.
• Created and executed test cases and compared the result with expected result
• Used Informatica workflow manager to run workflows.
• Used workflow monitor to monitor workflows and review session log files.
• Experience in preparing the traceability matrix, test scenarios and test cases.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics,
• Defect Report and requirement traceability using Test Director.
• Reviewed the test cases written based on the Change Request document.
• Tested data migration to ensure that integrity of data was not compromised.
• Experienced in writing complex SQL queries for testing data in oracle targets.
• Tested Cognos business reports using complex sql queries.
• Validated reports cosmetic like color, size in cognos reports.
• Reviewed the test cases written based on the Change Request document.
• Preparation of System Test Results after Test case execution.
• Developed SQL* loader scripts to load the data into the custom tables.

Environment: Oracle 10g, Informatica Power Center 7.1, Test director, SQL, Unix, Toad, Cognos, MS Office, Windows XP

Confidential, IL

ETL QA Analyst

Responsibilities:

• Involved in Design and development of test plans based on high-level and detailed designs.
• Analyzed requirements given by the business analysts and developed test cases.
• Performed black box/functional testing and regression testing.
• Written SQL for validating Informatica ETLs.
• Used Informatica workflow manager and workflow monitor during data load.
• Parameterizes test cases for use with varied, controlled test input values (runtime-generated, user-defined, or from data sources)
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Developed Test Plan, Test Strategy and Testing Scope Document.
• Tested business reports developed by Business Objects.
• Used SQL for Querying the database in UNIX environment
• Developed separate test cases for ETL process (Inbound & Outbound) and reporting

Environment: Informatica, Windows, MS-Office Tools, SQL, PL/SQL, XML, XSLT, Manual Testing, Test Director, Oracle, UNIX, Manual Testing, Business Objects

Confidential

QA Analyst

Responsibilities:

• Analyzed business requirements and functional specifications.
• Conducted the Functional, System, Integration, Regression, and performance testing of the Web application
• Worked with Functional Analyst and Solutions Architect for converting requirements and design documents.
• Closely worked with Subject Matter Experts. Extensively involved with performance testing.
• Created test processes, test cases and methods for performing these tests using technical document.
• Written SQL queries to validate backend database tables.
• Involved in Manual testing of the Java applications
• Developed and Tested the Web application

Environment: Java, Java Servlets, Oracle, HTML, DHTML, JDBC