SUMMARY:

• 8+ 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
• Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience in UNIX shell scripting and configuring cron - jobs for Informatica sessions scheduling.
• Good working experience on SOAP UI for testing and validating various web services used in the application.
• Used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide- ETL Solution using Informatica and SSIS.
• Well versed with ETL procedures to load data from different sources like Oracle, flat files, XML files into DWH using Informatica Power Center
• Extensively tested OLAP applications and good knowledge on end to end testing of OLAP databases.
• Experience in Data Migration testing and Web Interface testing.
• Testing the source and target backend databases for conformance to specifications
• Expertise in Testing Complex Business rules by creating mapping and various transformations.
• Experience in testing XML files and validating the data loaded to staging tables.
• Experience in testing and writing SQL and PL/SQL statements.
• Expertise in ELT tool TALEND for automating the Integration.
• Log issues that are linked to both requirement and test cases in HP ALM.
• Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using SSIS.
• Experience in Financial, Banking, Brokerage, and Securities industries.
• Testing ETL experience using Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• Wrote complex SQL Testing scripts for Backend Testing of the data warehouse application
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Knowledge and experience in producing tables, reports, graphs and listings using various SAS procedures and handling large databases to perform complex data manipulations.
• Extensively worked on Informatica PowerCenter tools- Mapping Designer, Workflow Manager, Workflow Monitor.
• Experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
• Bug reporting, Bug tracking was done using various Bug reporting tools like Quality center, PR Tracker, Visual Intercept, TSF and various in house tools.
• Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Expertise in utilizing Oracle utility tool SQL*Loader and expertise in Toad for developing Oracle applications.
• Worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.

TECHNICAL SKILLS:

Testing Tools: Quality center, Test Director, Win Runner, Quick Test Pro, Load Runner, Rational Clear Quest, Rational Robot

Languages: Java, .NET, XML, HTML, SQL, TSL, Java Script, VB Script

Operating Systems: Windows, UNIX, LINUX

Databases: MS Access, Teradata, SQL Server, Oracle, Sybase, Informix, DB2

ETL Tools: Informatica Power Center, SSIS, Data stage, SSIS

Browsers: Internet Explorer, Netscape Navigator, Fire fox

Bug Tracking Tool: Rational Clear Quest, PVCS Tracker, Bugzilla, Quality center

GUI Tools: Soap UI, Visual Basic

BI Tools: Microstrategy, Cognos, Business objects, Crystal Reports, SSRS, SSAS

WORK EXPERIENCE:

Confidential, Hopkins, MN

Sr. ETL Tester

Responsibilities:

• Analysis of Business requirements & Design Specification Document to determine the functionality of theETLProcesses.
• Executed UNIX Shell Scripts for Batch Job Execution.
• Written several UNIX scripts for running test loads for regression testing purpose.
• Used multiple data providers, Master/Detail, cross tab, Charts.
• Tested Business objects reports and Web Intelligence reports.
• Extracted Data from Teradata using Informatica Power CenterETLand DTS Packages to the target database including SQL Server and used the data for Reporting purposes
• Involved in the error checking and testing of theETLprocedures and programs Informatica session log.
• Tracked and reported the bugs with HP ALM/Quality center.
• Extensively worked on Mercury Test Center and ran various scenarios and scheduled them.
• Involved in automation of test cases using QTP/UFT.
• Tested theETLInformatica mappings and otherETLProcesses (Data Warehouse Testing).
• Written various Unix Shell Scripts for Scheduling the job in production like check file script, load script, complete script, and DQ script.
• Involved in developing the UNIX scripts for Informatica Workflows using parameter files and monitoring the workflows on testing environment.
• Involved in requirements gathering and analysis in support of data warehousing efforts and data quality analysis for cleansing and developedETLspecifications.
• Written UNIX Scripts to manipulate test data and input files.
• Participated in bug triage meetings with developers to validate the severity of the bug and responsible for tracking of the bug life cycle using Test Director.
• Created various User Defined Functions for script enhancements and to verify the business logic.
• Wrote complex SQL scripts in DB2 for testing data quality and validation.
• Execute the Unix Shell Scripts to Know the Backend Batch Jobs Status

Environment: Informatica, QTP/UFT, Oracle, TOAD, SQL Server, HP ALM/Quality center, UNIX, Agile, Windows, Autosys, Business objects, XML, XSLT, SOAPUI, Web Services, MQ Messaging, PL/SQL, Test Director.

Confidential, Baltimore, MD

ETL Tester

Responsibilities:

• Analyzed the Functional requirements using Detailed Design Document.
• Coordinated and controlled testing project at every step of the quality cycle from test planning through execution to defect management.
• Created Data warehouse test plans, UAT plans, test cases based on theETLmapping document and functional design documents.
• Wrote/Maintained QTP/UFT automated scripts for Web based application using advanced VB Scripting.
• Performed additional data validation using custom SQL scripts.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Extensively used SQL queries to perform database validation and also automated the SQL scripts for re-usability.
• Analyzed the data mapping and developed test scenarios to verify the data migration from different data sources.
• Tested theETLInformatica mappings and validated transformation and involving business Logic.
• Worked with data analysts to understand Informatica mappings and workflows.
• Tested several reports generated by OBIEE included dashboards, impact assessment and productivity tool /PPT
• Created User Acceptance Test (UAT) plan and executed the product test cases with customers in determining the functionality of the application and also performed production verification.
• TestedETLmappings to extract and load data from different databases such as Oracle, SQL Server, XML files and flat files and loaded them in to Oracle.
• Used Mercury HP ALM/Quality center to formulate test plan, execute test cases and performed defect management
• Developed Requirements Traceability Matrix (RTM) to track the test cases and requirements during the QA Testing Phase

Environment: HP ALM/Quality Center, Informatica, QTP/UFT, SQL Server, PL/SQL, OBIEE, Oracle, UAT, XML, Windows and MS Excel

Confidential, Richmond, VA

ETL Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Written the SQL scripts to validate ETLs developed by SSIS.
• Validated SSISETLmappings and transformations like joiner, update strategy and lookup.
• Analyzed the data using SSIS Data Profiler giving Statics of the data like null values, maximum, minimum and average values.
• Utilize various SSIS components like Lookup, Join, Rollup and Reformat to process data.
• 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 Quality center.
• Analyzed test cases for automation and created scripts for regression testing using QTP Automated Test cases for the purpose of regression testing.
• Tested data migration to ensure that integrity of data was not compromised.
• Experienced in writing complex SQL queries for testing data in oracle targets.
• Prepared test data to validateETLrules wherever necessary.
• Accessed source files from UNIX environment.
• QTP was used to generate automated Test scripts for functionality and GUI Testing.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Written several complex SQL queries for validating Business objects Reports.
• Write SQL queries to validate Drilldown and Cross-Tab reports.
• Validated reports cosmetic like color, size in Business objects reports.
• Reviewed the test cases written based on the Change Request document.
• Preparation of System Test Results after Test case execution.

Environment: Oracle, SSIS, Quality center, QTP, DB2, SQL, UNIX, Toad, Business objects, MS Office, Windows XP.

Confidential, MANHATTON, NY

ETL Tester

Responsibilities:

• Involved in Test plan and Test case preparation.
• Prepared reusable function in QTP to use across the automation scripts
• Involved in Installation testing and Transformation of XML documents using XSLT.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Review the test cases written based on the Change Request document.
• Preparation of System Test Results after Test case execution.
• Interacting with developers for the Bug Fixes and Problem resolution.
• Involved in preparing Daily status report Proficient with various SSIS Parallelism and Multi File System techniques.
• Defect Report and requirement traceability using Quality center.
• Strong experience with Multifile (MFS) and Serial File (SFS) process, Parallel processes using SSIS.
• Tested the entire compliance reports generated using Microstrategy BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
• Tested the migration of reports from Microstrategy.
• Provided weekly management status reports.
• Executed SQL Queries to check table updates and data retrieval
• Conducted Data Driven Testing using different sets of external data
• Reporting defects to development team through the Test Director.
• Involved in Test Summary Report preparation
• Used SQL for Querying the DB2 database in UNIX environment.

Environment: Oracle, DB2, QTP, Test Director, Quality Center, XML, XSLT, SQL, PL/SQL, Unix, Test Cases, Test Scripts, Test Plan, Traceability Matrix, SSIS, Microstrategy.

Confidential, San Antonio, TX

ETL Tester

Responsibilities:

• Worked with cross-functional teams to manage defects, compile test results and communicate issues, risks and status on a timely basis to ensure solution meets the business requirements
• Involved in Functional testing, business requirement testing, data requirement testing, regression testing, system integration testing, data validation, and non-functional testing
• Analyzed the EDW mapping documents, Dimension tables and fact tables
• Wrote SQL queries to do the column level verification of the Dimension and Fact tables
• Involved in testing the data warehouse for both the initial load and the incremental loads of the target
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity
• Involved in the Informatica up-gradation testing to make sure that the existing, updated and new workflows are working as expected when migrated to Informatica from Informatica 8.6.
• Created and documented the test plan for the same.

Environment: Quality center, Informatica, Oracle, TOAD, SQL Developer, UNIX, Windows XP,Internet Explorer, SQL, JIRA, OBIEE, SPOTFIRE,ETL