SUMMARY:

• Over 7+ years of experience in IT as a Data Warehouse Analyst/ Developer in ETL, BI, Web based and Client/Server applications using Manual and Automated testing tools in Windows and UNIX environments.
• Expertise using Informatica and Ab Initio ETL tools along with Business Objects and Micro Strategy reporting tools.
• Expert knowledge in creating ETL Test Plans, ETL Test Cases, ETL Test Scenarios and Test Strategies to ensure Quality Assurance and to test all the business requirements.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Expertise in Entire Software Development Life Cycle and Test Development Life Cycle which includes Requirement analysis, system integration and Team Building.
• Experience in both Agile and Waterfall Software Development Models.
• Worked with the components of Data Warehousing like components model, ETL tools.
• Experience in writing SQL Queries for different Databases such as Oracle and SQL server.
• Experience with automation Testing Tools of Selenium IDE tool and QTP Automation tool.
• Experience in planning, coordinating and performing Integration Testing, Validation Testing, Functionality Testing and Regression Testing, Database testing, Performance testing, GUI testing, User Acceptance Testing.
• Experience with bug tracking tools like Quality Center/Test Director and familiar with Clear Quest, Bugzilla.
• Excellent Client Facing Skills, Involved in Product Acceptance Testing.
• Documented Testing Strategies for Functional and Automated testing.
• Extensive ETL Testing experience Informatica 8.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Well versed with Handling Elements in Selenium Web Driver.
• Extensively worked on backend testing and well versed with SQL, PL/SQL queries to run the data integrity tests.
• Validation of backend data using SQL joint scripts. Involved in data driven tests using SQL queries to extract data from different databases and verified them.
• Proficient in writing SQL scripts to validate ETL flow, Data Reconciliation, Initialization, and Change Data Capture, Delta Processing, Incremental process.
• Extensively worked on Dimensions and Facts, Data cleansing and Data Staging of operational sources using ETL processes.
• Good understanding of data warehousing concepts like Star schema, Snowflake schema, Slowly Changing Dimensions, Fact and Dimensional tables etc.
• Extensively used Quality Center for Test Planning, Test Execution and Defect tracking.
• Experience in automation testing using mercury tools like Quick Test Professional for functional and regression testing of the application.
• Developed Test strategy and Test plans for the ETL process.
• Prepared test data for all ETL mapping rules to test the functionality of the Informatica mappings.
• Strong testing Quality Assurance experience within Agile environment.
• Performed Testing of database applications developed with Oracle, Netezza and SQL Server.
• Effectively involved in Defect tracking, reporting reviewing and analyzing test results using Clear Quest.
• A very good team player with Exceptional written/verbal communication skills, including the ability to effectively document procedures, processes and results.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center9.0, Ab Initio, SSIS

Testing Tools: Quick Test Professional (QTP), Rational Rose, Selenium, Rally Agile Project Tool, Jenkins, Bugzilla

Bug Reporting Tools: Quality Center 10/9.0, Test Director, IBM Rational Clear Quest and JIRA

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

Query Tool: TOAD, PL/SQL Developer, Aginity Workbench

Web Technologies: VB Script, XML, Java script, HTML, Dot NET

Databases: Oracle 9i/10/11g, SQL Server 2008/2005, Teradata SQL Assistant, Netezza 7.0.2

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

Languages: SQL, PL/SQL, XML, HTML, Java Script, and VB Script

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Lead ETL Analyst

Responsibilities:

• Developed Test approach, Test cases for Informatica ETL’s based on technical specifications and Mapping documents.
• Worked closely with Business Analyst's, SMEs and Developers to understand Requirements and Technical Design documents then provided QA approach and Test Strategies for multiple projects.
• Managed offshore teams, assigned the work tasks on daily basis and updated the status reports to appropriate customers.
• Executed test cases and mapped it for forward and backward Traceability matrix in Quality Center.
• Conducted Automation/Manual testing using the Standards, guidelines and structured methodology in testing the application. Analyzing Business Requirement/Features and preparing the Test conditions in HP Quality Center.
• Performed Integration test between sources Transaction Systems like ID3, ALIP & VS10 and the target AZTEK systems.
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application (AZTEK).
• Validated Informatica extraction, transformation and loading process by writing SQL against Business rules.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands - on mentoring in the use of Informatica for testing.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting and CA Workload automation.
• Extensively used TOAD to verify source data and target data after the successful workflow runs using SQL.
• Reviewed Informatica mappings and test cases before and also given Demos to Product owners.
• Actively Participated in all Grooming, Demos and Retrospective meetings in every sprint.
• Experience with CA Work load automation and Autosys job scheduler including jil scripting.
• Automated manual test cases into automated scripts using QTP Developed several regression test suites. Involved in developing functions, which are reusable in other scripts.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.
• Advised process teams representing client needs regarding cross-functional considerations, workflow integration and coordination, and optimization of best practices.
• Assigned in creating various testing scenarios for performing Functional & Integration Testing.
• Validated the Source, Stage and Target (End-to-End) based on the test conditions derived from the business requirements.
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements.
• Used Aginity tool to run SQL queries and validate the data loaded in to the target tables in Netezza DB.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica.
• Experience in Mercury Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting.
• Involved in writing various test cases based on the BRD and uploading the same in the QC.
• Worked with Quality center to document test results and validate test scripts. Used Quality Center in routing defects, defect resolution and assigning business cases to business users.
• Experience to test along with Agile and SCRUM team.
• Effectively used Rally Agile software to access the User Stories and Testing defects within the sprint and to verify the results as per acceptance criteria.
• Executed QTP data driven testing at regression testing phase.
• Created test result report and worked on software process development approach on Agile Rally.
• Created and Validated the XML files based on the defined XSD’s with the help of XML SPY.
• Worked on Informatica Power Center (Workflow Manager, Workflow Monitor) to trouble shoot the job issues and Defects.
• Conducted meetings with onsite and offshore team to discuss showstopper defects.
• Worked closely with Developers in resolving the issues and discussing the functional dependencies.

Environment: IBM Clear Quest, Oracle11g, PL/SQL Server, Rally Software, Java, HTML, MS Office, Altova XML spy, Informatica 9.0, Autosys, Agile, SSRS, SSIS, UNIX, HP Quality Center, UNIX, QTP 10.0.,Netezza,Aginity, Business Objects.

Confidential, Jacksonville, FL

ETL Tester/ Reports Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Written SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Tested Ab Initio graphs for various ETL data mapping requirements.
• Extensively involved in testing the ETL process of data sources, SAP, PeopleSoft, SQL Server, Oracle, flat files into the target Teradata, Oracle database as per the data models.
• Experienced using database query and integration tools such as SSIS, TOAD, SQL plus etc.
• Tested SSIS packages according to business requirements and data mapping requirement documents.
• Obtained detailed understanding of data sources, Flat files & Complex Data Schemas in order to write the best test scripts.
• Extensively ran the Ab Initio graphs, monitored the log files and involved in find the root cause of the failures.
• Responsible in testing Initial and daily loads of ETL jobs.
• Interacted with design team to decide on the various Dimensions and Facts to test the application.
• Tested & developed the mapping for extracting, cleansing, transforming, integrating & loading data using Autosys.
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Reported bugs and tracked defects using Clear Quest.
• Extensively used SQL to verify and validate the data loaded into Target.
• Done data validation, accuracy of calculated fields, Accuracy of the data shown, Selection criteria shown, Accuracy of subtotals for the SSRS reports.
• Validated the front end reporting components created using Micro strategy reports as well as performed back end testing, making sure that the correct data for a specific report are being pulled out from the Data ware house.
• Responsible for the validation of any additions/modifications to the Micro strategy reports before release to production.
• Used SQL Queries for data validation in ETL process and also in validation of Micro strategy Reports.
• Used SQL for Querying the database for data validation, data verification and data conditioning.
• Writing the test scripts, test cases & test plan for multiple ETL Feeds.
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Involving in Functional testing, Backend Testing, End to End testing and Regression Testing.
• Load new or modified data into back-end database.
• Defect Triage with Development team.
• Involved in peer review of test cases. Tested large volume databases by using stored procedures.

Environment: Ab Initio 2.14, SQL Server 2008, Oracle 11g, Micro strategy, XML, XSLD, Flat Files, SQL, PL/SQL, SSIS, SSRS, Clear Quest, Quality Center 10, Remedy, TOAD, UNIX, MS Office, HTML, Windows XP/Vista, Internet Explorer 9.0.

Confidential, Santa Ana, CA

ETL/UAT Tester

Responsibilities:

• Interacted with Business Analysts and subject matter experts to learn more about the data.
• Validating the Workflows and running them using Workflow Manager.
• Prepared Test Cases and Test Plans for the mappings developed through the ETL Informatica tool.
• Experienced in writing complex SQL queries for extracting data from multiple tables and validating with target tables.
• Validated target tables DDL, counts, data (Business rules), negative testing and regression testing.
• Involved in preparing Test Plan from the Business Requirements and Functional Specification, design and development.
• Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD.
• Used TOAD Software for Querying ORACLE and Used Teradata SQL Assistant for Querying Teradata.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Strong technical Knowledge of UNIX Utilities, Shell Script to automate process.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Involved extensively in doing back end testing of the data quality by writing complex SQL.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various Sources systems including Oracle and Teradata.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Reported bugs and tracked defects using Quality Center.
• Worked with ETL group for understating mappings of target tables.
• Worked on issues with migration from development to testing.
• Extensively tested several Cognos reports for data quality, fonts & headers.
• Validating all the XML messages against the schema through ALTOVA Xml spy.
• Testing the different use cases to make sure the data sent in the xml is in the application and implies in a proper outbound message.
• Verify the Inbound and Out Bound Messages between the CCMSV4 and in Integration partner (IP).
• Validate the Error messages Produced for the invalid messages and message failure scenarios at the web service level.
• Interacted with Clients for their issues in Product/User Acceptance Testing (PAT).
• Developed UAT Test cases adhering to specifications and business requirements.
• Used UNIX shell scripts for submitting Autosys jobs.
• Identified & presented effort estimations related to UAT testing efforts to Project Management Team.
• Smoke testing the application to make sure the quality of the code is pristine before and after every build.
• Using File Zilla client to FTP the xml’s into the Application.
• Creation of the Transaction through the Xml and to test whether the scenario goes end to end.
• Defect Logging in QC and Retest the defects fixed.
• Performed SOA Web Services Testing using SOAPUI testing tool using WSDL and XML files.
• Collaborated through the Clear Case for project documentation and change management.
• Setup the SOA Web Services Testing Strategy and Prepared the SOA Test Plan.
• Used Irise to create and update the screenshot of the actual application, for the developers to create the code as per the spec.

Environment: Oracle 11g, Quality Center9.0, Clear Case, Altova XML spy, iRise Studio 6.5, Rational Rose. Web Services (SOAP, HTTP and XML), XML/XSLT, WSDL, FileZilla FTP, Web sphere 6.0, TOAD, PL/SQL, Teradata, Cognos and UNIX Shell Scripting.

Confidential

ETL Developer

Responsibilities:

• Develop ETL Mappings between Source and Target database tables using Informatica Power Center.
• Experience in Dimensional Modeling using Star and Snowflake Schema, Identifying Facts and Dimensions, Physical and Logical modeling using Erwin tool.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Query and perform data analysis using Microsoft SQL Server (T-Sql) and Oracle.
• Develop ETL Data Mappings between Source and Target database tables using DTS package
• Create ETL Data Mappings documents between Source and Target database tables using Microsoft office.
• Strong Experience in Developing Store Procedures using T-SQL.
• Involved in creation of Schema objects like Tables, Views, Stored procedures and functions.
• Documented the mappings used in ETL processes including the Unit testing and Technical document of the mappings for future .
• Coordinated with the Informatica administration team during deployments.
• Experience in Production Support for the work I developed like Informatica WFs and SQL Store Procedures.
• Strong experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and User acceptance testing.

Environment: Informatica Power Center 8.1, XML, Quality Center 9.0, Windows NT 4.0, DB2, TOAD, Crystal Reports, Oracle 9i, PL/SQL, UNIX.

Confidential

ETL Tester

Responsibilities:

• Developed Test Plan and Test cases for testing the application using Test Director.
• Interacted with developers, Business & Management teams and End Users.
• Interacted with programmers to identify and resolve technical issues.
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Conducted Data Migration and Data Cleansing.
• Responsible for creating different sessions and workflows to load the data to Data Warehouse using Informatica Workflow Manager.
• Extensively tested the reports for data accuracy and universe related errors.
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables.
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
• Involved in user sessions and assisting in UAT (User Acceptance Testing).
• Wrote data conversion and data migration scripts for ETL process.
• Created ETL execution scripts for automating jobs.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Used workflow manager for session management, database connection management and scheduling of jobs.

Environment: Informatica Power Center 8.1, XML, MS SQL Server, Quality Center, TOAD, Oracle 9i, PL/SQL, Excel.