PROFESSIONAL SUMMARY:

• Over 8 years of IT experience in the Analysis, design, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Experienced in all phases of Systems Development Life Cycle (SDLC), including requirements analysis/design, development and testing
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Experience in Data Warehouse Development Life Cycle using Dimensional modeling of STAR, SNOWFLAKE schema, Fact and Dimension tables.
• Experienced in Onsite - Offshore Co-ordination, Test Management, Test Automation, Onsite Offshore Model Process Consulting, Requirements Management, Defect Management, Release Management and Team Management.
• Worked on Logical and PhysicalDatabase data model
• Experience in Financial, Banking, Insurance and Retail Domains.
• Extensive ETL Testing experience using Informatica PowerCenter 9.0/8.x/7.x, (Designer, Workflow Manager, Workflow Monitor and Workflow Manager)
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Experience working on Oracle, Teradata, SQL Server,MS Access and DB2.
• Expertise in preparing Test Strategy, Test Plan, Test Summary Reports, Test Cases, Test Scripts for Manual and Automated Testing
• Performed Black Box, White Box, Smoke Testing, Integration Testing, System Testing, End-to-End Testing, Regression Testing, Adhoc Testing, Performance testing and security testing
• Experienced in Performance Tuning of sources, targets, mappings and sessions.
• Experienced in running SQL queries using Toad, SQL Assistant and SQL Server.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Strong experience in testing tools like TestDirector 6.5, Quality Center, Quick Test Pro.
• Automated and scheduled multiple ETL jobs using UNIX Shell Scripting.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R2

TECHNICAL SKILLS:

ETL Tool: Informatica Power Center 9.1/8.6.1/8.1/8.0/7.1.3 (Repository Manager, Designer, Workflow Manager, workflow Monitor)

Data Modeling: Star schema Modeling, Snow flake modeling

ChangeMgt Tools: Quality Center 9.2/8.2, Test Director 6.5

Languages: C, SQL, PL/SQL

Databases: Oracle 9i/ 10g/11g, MS SQL Server 2005/2008/2000, DB2, Sybase, Teradata V2R6

SQL Tools: SQL Developer, TOAD, SQL Server Management Studio, SQL*PLUS, SQL*Loader

Office Tools: MSOffice, MS Project, MS Access

Operating Systems: Windows 98/NT/2000, XP, UNIX.

Scheduling Tools: Autosys

PROFESSIONAL EXPERIENCE:

Confidential, MO

Sr. ETL Tester

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Successfully leading a team and coordinating the testing activities to complete System, Integration Test Preparation on schedule.
• Coordinating Functional testing, Integration testing and Regression testing.
• Experienced in defining, creating and implementing testing process and methodology for onsite/off-shore team.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center
• Worked on issues with migration from development to testing
• Involved in fixing invalid mappings, testing of sessions and the target data.
• Scheduled several workflows for its execution.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Review the test cases written based on the Change Request document.
• Wrote SQL queries to validate source data versus data in the RWA datamart including identification of duplicate records.
• Checked the data flow through the front and backend and used SQL queries to validate the output data with the database.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Developed SQL Stored Procedures and Queries for Back end testing to implement business rules.
• Involved with ETL test data creation for all the ETL mapping rules.
• Used Quality Center for test management and defect Reports.
• Participated in frequently held Defect Meetings which included Project Management, QA, Development and Business Line teams and submitted weekly defect and test status updates during the Defect Management meetings.
• Involved in the error checking and testing of the ETL procedures and Informatica session log.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Tested Different schedules/reports generated by the RAY tool.

Environment: Informatica 9.1, TOAD 9.2, Oracle 11g, MS SQL Server 2008, XML, HP Quality Center 9.2, Autosys, MS Access, MS Excel, MS PowerPoint, Microsoft Share Point, Unix.

Confidential, CA

ETL Tester

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Involved in writingTest Plans based on Business Requirement and Functional Requirement documents.
• Created Test sets in Test Lab to move all the test cases from Test plan to execute the test cases.
• Tested the data for data integrity among various sources and targets.
• Performed ETL testing based on ETL mapping document for data movement from source to target.
• Reviewed Informatica mappings and test cases before delivering to Client.
• Reviewed the test cases written based on the Change Request document.
• Involved in preparation of System Integration Test Results after Test case execution.
• Experienced in writing complex SQL queries for extracting data from multiple tables and validating data.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Validated slowly changing dimension Type 1 and Type 2 for Change data capture.
• Created critical scenarios for each change request and defect request.
• Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, Parallel Testing, Performance Testing and Regression Testing.
• Wrote SQL queries to validate the test case results for back-end test cases.
• Tested Business Objects reports and Web Intelligence reports.
• Created several Ad-hoc reports in Business Objects XI R2 to validate the data.
• Tested the ETL Informatica mappings and other ETL Processes.
• Trained and coordinated with the offshore team members in understanding the requirements.
• Involved in ETL Mapping Design and Performance tuning to improve the performance of data Load process.
• Experienced in writing UNIX script.
• Effectively coordinated with the development team.
• Worked on HP Quality Center and updated defects status with appropriate information.
• Hands on experience with working on Autosys jobs.
• Provided Autosys expertise for batch processes running in the QA environment within the Enterprise Business Intelligence group.

Environment: Informatica Power Center 8.6.1, SQL, PL/SQL, SQL Server 2005/2008, Unix Shell Scripting, XML, TOAD 9.2,Oracle 10g, Business Objects XIR2,HP Quality Center, Autosys.

Confidential, HOBOKEN, NJ

ETL QA Analyst

Responsibilities:

• Interacting with Business Analysts and Development teams to understand the business requirements and giving the estimates from testing prospective.
• Used Informatica Power Center for Extraction, Loading and Transformation (ETL) of data into the Data Warehouse.
• Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly
• Developed Test cases, Test plans, and Test procedures using MS Word and MS Excel.
• Involved in Positive and Negative Testing.
• Validated the ETL logic to Load Data into ODS.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created the test data & Coordinating with Developers/Leads in resolving bugs.
• Experienced in writing complex SQL queries for validating the data in all stages.
• Extensively involved in the Performance testing of the programs, ETL Procedures and Processes
• Validated SCD Type2 (Efficient Key Approach) to store Transaction level as well as Table level data, which services Reporting Needs of the Organization.
• Documenting test procedures, test plans, test cases and test results.
• Used Quality Center for test management and defect tracking.
• Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD.
• Involved in identifying the cause of Defect and reporting the same to developers.
• Involved in testing the Business Objects reports by writing complex SQL queries
• Tested Business Objects reports and Web Intelligence reports.
• Tested the universes and reports in Business Objects 6.0
• Developed Shell Scripts to perform pre-session and post-session operations.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g/9i, MS SQL Server 2000, Teradata, Business Object 6.0, MS Excel 97, Flat files, PL/SQL, SQL, Toad, Unix Shell Scripting.

Confidential, BUFFALO, NY

ETL /BI Tester

Responsibilities:

• Analyzed the Data sent by the Vendor Care Mark and Made ETL specification sheet.
• Validated Oracle staging stable where we would bring the data from source to staging.
• Validated target tables for reporting purpose, Which would serve as source for Tools like INGENIX and IMPACT pro, this is an architectural exception where we bypassed EDW.
• Validated various business logics implemented to load data from staging to target databases.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Worked with reporting professionals for creating views and altering some of the dimensional tables to satisfy their reporting needs.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Preparation of technical specifications and Source to Target mappings.
• Developed and documented data Mappings/Transformations, and Informatica sessions as per the business requirement. Involved in the development of Informatica Mappings and also tuned them for better performance
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Worked on issues with migration from development to testing.
• Involved in writing the Test Cases, Test Plans and Test Scripts using the Business Requirement
• Worked on HP Quality Center and updated defects status

Environment: Informatica PowerCenter 8.1,Oracle 10g/9i, DB2, MS SQL Server 2000, MS Excel 97, Flat files, PL/SQL, SQL, SQL*Loader, Toad 7.0, HP Quality Center, Windows 2000, Unix Shell Scripting.