SUMMARY

• More than 8 years of IT experience in ETL Tester, Data Warehouse Consultant for Data warehouse, ETL, Backend, SQL, PL/SQL, MS SQL Server, Teradata, ORACLE, Web based, Client/Server applications using Manual and Automated testing tools.
• In depth technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and Data warehouse ETL.
• Wrote extensive SQL and PL/SQL scripts to test the Data warehouse ETL flow, Data Reconciliation, Initialization, and Change Data Capture, Delta Processing, Incremental process.
• Expert in Oracle database testing.
• Have the ability to evaluate an ETL/BI specification, verify it with Systems experts and data architects, and assess if it is complete and fully understand EDW and ETL Architecture
• Experience in Business Intelligence in generating various reports using Cognos and Business Objects
• Strong knowledge of test methodologies: Object Oriented test methodology, Service Oriented Architecture, Top to bottom and Bottom to top test methodology, QA Validations & QA Compliances to ensure the Quality Assurance Control.
• Experienced in Data Warehouse projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Hands on experience in writing test scripts, preparing test data, testing Informatica Mappings and creating SQL scripts using stored procedures, functions, PL/SQL.
• Expert in writing PERL & UNIX Shell scripting for various needs including text processing, data archiving, data parsing and database connectivity.
• Used Test Director, HP ALM/Quality Center and Business Process Testing for management of test plan, test design, test execution and defect log phase. Also Rational Quality Manager for management of STLC including requirements gathering, risk analysis, project planning, scheduling, testing, defect tracking, management, and reporting.
• Proficient in writing SQL queries to perform data driven tests and involved in front - end and back-end testing.
• Strong knowledge of RDBMS concepts. Developed SQL queries in SQL Server databases to conduct DB testing. Worked on Data files & label parameter of data files, strong in writing UNIX Korn shell scripting.

PROFESSIONAL EXPERIENCE

Confidential - Charlotte, NC

Sr. ETL Tester/Backend Tester

Responsibilities:

• Design and Development of QA documentation like Test Plans, Test Cases and Test scenarios from business and functional requirements
• Use HP ALM for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Results
• Perform SQL validation to verify the data extracts and record counts in the database tables by writing complex SQL minus queries
• Write test cases for checking the population of data correctly into fact and dimension tables
• Create Test documents in MS Excel template from the Test Plan and the Business Requirements documents
• Coordinate with development teams in system integration testing and services level unit testing
• Extensively worked with backend activities for testing several reports developed by BI tools such as Power BI and Cognos
• Test Complex Reports in Power BI and use methods like Slice and Dice Drill down Functions to dig deep in to the data
• Performed data analysis and data profiling using Excel Pivot Tables and Power BI on various source systems including SQL Server and Oracle
• Responsible for reviews and documentation for reporting the status to the project manager
• Create and test tabular cubes using SSAS and integration to Power BI
• Create ETL packages using Visual Studio and test the data flow

Environment: ETL, Data warehousing, BI, SQL Server, SQL, HP ALM, Power BI, COBOL, Excel Pivot Tables, SQL Server Data Tools, SSAS Tabular, SSRS, SSIS, Visual Studio, TFS, Cognos, Agile, XML, Oracle, Flat Files, BIML, Cubes

Confidential - Winston Salem, NC

Sr. ETL Tester/Backend Tester

Responsibilities:

• Review functional and design specifications to ensure full understanding of individual deliverables.
• Designed and developed Test Plans, Test Scripts and Test Cases in HP ALM/Quality Center and executed them.
• Identify test requirements from specifications, map test case requirements and design test coverage plan.
• Worked as Data warehouse ETL Tester responsible for the requirements / ETL Analysis, ETL Informatica Testing and designing of the flow and the logic for the Data warehouse project.
• Expert in writing Complex SQL and PL/SQL Scripts in querying SQL Server, Teradata and Oracle.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica.
• Identify any potential quality issues per defined process and escalate potential quality issues immediately to management.
• Designed and developed Test Plans, Test Scripts and Test Cases in HP ALM/Quality Center and executed them.
• Extensively used Teradata load utilities Fast load, Multiload and Fast Export to extract, transform and load the Teradata data warehouse.
• Reporting and tracking defects using Quality Center. Validate all UAT scenarios and scripts.
• Document all phases of the Systems in QA process. Checking database transactions using SQL Server.
• Prepared test data by executing SQL queries and Joins. Tested several Data warehouse ETL Informatica Mappings to validate the business conditions
• Executed SQL queries to compare the data in database with GUI and web services.
• UNIX / Linux commands Executed for backend data validation.
• ETL Testing process - Validated source and target databases to validate the report. Worked with automation team to identify regression test cases.
• Tested the Reports generated by the BI tool Micro Strategy and validated the data on the Reports.

Environment: Data warehouse ETL Informatica Power Center, Agile, COBOL, SQL Server 2012/2008, SQL, PL/SQL, QTP, UFT, VB Script, Teradata, Unix Shell Scripting, XML, TOAD 9.2, HP ALM/Quality Center, Rational Suite, Micro Strategy and AutoSys

Confidential, Pittsburgh, PA

QA Tester

Responsibilities:

• Designed and developed Test Plans, Test Scripts and Test Cases in HP ALM/Quality Center and executed them
• Worked as a Data warehouse ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project
• Involved in writing the Test Plans based on Business Requirement and Functional Requirement documents.
• Extensive experience writing complex SQL queries for extracting data from multiple tables.
• Tested all the Data warehouse backend programs, ETL Informatica Mappings and update processes
• Involved in implementation of the Test plans, Test cases and Test Scripts
• Performed Teradata SQL and PL/SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Tested to verify that all data were synchronized after the data is troubleshot, and also used SQL to verify/validate my test cases
• Created reports using Business Objects functionalities like Slice & Dice, Drill Mode, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Trained and coordinated with the offshore team members in understanding the requirements and test cases for UAT.
• Tested the different sources such as Flat files, Main Frame Legacy Flat Files, SQL server and Oracle to load into the Oracle data warehouse
• Created Test Cases in ALM/Quality Center, executed Test Cases, and reported defects
• Tested several Data warehouse ETL Informatica Mappings to validate the business conditions
• Executed Complex SQL queries within UNIX shell scripts in the UNIX environment
• The reports that were created in Business Objects were testing by running the SQL statements
• Involved in Data warehouse ETL Mapping Design and Performance tuning to Load mapping process
• Involved in preparation of System Test Results after Test case execution. Obtained experience writing UNIX scripts
• Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance Testing, Parallel Testing, Performance Testing and Regression Testing
• Used various SQL queries to validate the test case results for SQL Server back-end test cases
• Well exposed to Software Development Life Cycle and Test methodologies

Environment: Agile, Informatica Power Center 8.6.1, SQL Server 2012/2008, COBOL, Business Objects XIR3, SQL, PL/SQL, QTP, Teradata, Unix Shell Scripting, XML, XML Spy 2008, XSLT, TOAD 9.2, HP Quality Center, Rational Suite, IBM ODS/DWL, DBArtisan 8.5.2, AutoSys and MQs

Confidential, Atlanta, GA

QA Tester

Responsibilities:

• Developed a wide-range of SQL queries to assure data validation and avoid duplication in tables of the database.
• Tuned Data warehouse ETL Data stage jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance divisions and across geographies.
• Performed data analysis and data profiling using SQL and Data warehouse ETL on various sources systems including Oracle and Teradata.
• Wrote Test Cases for Data warehouse ETL to compare Source and Target database systems.
• Supervising the QA team in accomplishing their tasks as per the deadlines
• Deleting the target data before processing based on logical or physical primary key
• Promoted Unix/Informatica application releases from development to QA and to UAT environments.
• Involved in requirements gathering, source data analysis and identified business rule for data migration and for developing data warehouse/data mart
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various source systems including SQL Server and Teradata
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Created and maintained test reports, identified bugs and reported findings using Quality Center
• Interacting with senior peers or subject matter experts to learn more about the data
• Identifying duplicate records in the staging area before data gets processed
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
• Wrote test scripts for back-end validations and ensured that the mappings are correct
• Extensively used Informatica power center for extraction, transformation and loading process
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application
• Wrote SQL scripts to test the mappings and extensively used Cognos for report generation
• Tested Cognos reports to check whether they are generated as per the company standards
• Wrote UNIX Shell scripts for cleanup, error logging, text parsing, job scheduling and job sequencing
• Debugging the SQL-Statements and stored procedures.
• Conducted Training & Knowledge Transfer Sessions on new applications to QA Analysts

Environment: Data warehouse ETL Data stage, BI Cognos, Teradata V2R6, SQL Server 2005/2008, SQL Assistant 6.0, QTP, TOAD, Win SQL, Windows XP, Quality Center 9.2, and VB Script, Oracle 10G, SQL, PL/SQL, XML, XSLT, XSD, XML Spy 2008, TOAD and UNIX