SUMMARY

• Over 6 years of IT experience in the Analysis, Design, development, testing maintenance of database and Data Warehousing applications.
• Experienced DWH and BI Tester/QA Analyst with strong background in design, development, and support of databases and information products as well as data analysis / reporting / Testing.
• Experienced in Functional testing, System testing, Application testing, Performance testing, Integration testing, Regression testing, Black Box testing, Stress Testing, Smoke testing, Recovery testing, Reports testing, browser compatibility testing, UAT or End to End Testing.
• Involved in all stages of Software Development Life Cycle.
• Ability to perform root cause analyses and drive improvements
• Effectively manage multiple work assignments and priorities.
• Excellent understanding and expertise in writing complex SQL queries to perform back - end testing.
• Strong working experience on DSS (Decision Support Systems) applications and various ETL tools like Informatica and Data Stage.
• Experienced in using UNIX commands for shell scripting.
• Extensively used ETL methodology in supporting data extraction, transformations and loading process.
• Expertise in testing complex Business rules by using mapping documents.
• Worked with HP Quality Center and Clear Quest for Test Management and defect tracking.
• Knowledge of SOA & web services.
• Extensive experience in manual testing the ETL and Business Intelligence Applications.
• Developing and Delivering System Documentation and UAT Test scripts and auditing documentation for maintaining ITIL.
• Excellent problem solving, interpersonal, and communication skills.

TECHNICAL SKILLS

ETL Tools: SSIS, Informatica Power Center, Datastage

Testing Tools: HP ALM 11 /Quality Center 10, Test Director, QTP, Manual Testing

Database: Oracle, SQL Server, MySQL, ODBC, DB2, MS Access, Teradata, Netezza Aginity

Reporting Tools: SSRS, Business Objects, Cognos

Operating Systems: Window 2003 Server, Windows 2000 Advanced Server, Windows 98, Windows XP, Linux and UNIX(AIX).,Window 2007 Server

Version control: Visual Source safe, Clearcase, Requisite Pro, RQM, CQ

Languages: XML, SQL

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Senior ETL Tester/QA Engineer

Responsibilities:

• Worked extensively on analyzing customer data from various source systems so as to create mapping documents.
• Involved in client interact interactions at various stages of project to ensure all customer requirements are meet and respective projects are delivered on time.
• Worked on agile development process and attended daily scrum meeting.
• Worked with the Data analysts and client for requirements gathering, analysis of various source system data.
• Develop test plans based on test strategy and ETL mapping document. Created and executed test cases based on test strategy and test plans.
• Written complex SQL queries for querying data against different databases for data verification process.
• Tested mappings to load data into type II slowly changing dimension tables.
• Tested performance of SQL queries. Suggested to create Indexes based on the results.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support.
• Worked with ETL group for understating mappings for dimensions and facts.
• Tested data extracted from various sources like Oracle, flat files and SQL Server.
• Worked on issues with migration from development to testing.
• Executed and saved queries in GIT.
• Worked with automation tool DB Fitnesse.
• Raise and track a bug in JIIRA.

Environment: IBM Infosphere DataStage 8.5, Git Versioning tool, Netezza, Cognos, DB Fitnesse, JIIRA, Windows 7,UNIX, SQL

Confidential, Herndon, VA

BI/DW QA Engineer

Responsibilities:

• Prepared the test plan, test strategy and test case documents with the help of BRD, FRS, HLD, LLD and other supporting documents.
• Attended walkthrough meetings with the Business Analysts and DEV team to get a clear understanding of the business and the applications being used in house.
• Designed and developed Test Cases based on the Business Rules and Mapping Documents.
• Validated the source data coming from various databases using complex SQL queries.
• Aggregated the data at source and compared with the Target to validate Transformations.
• Prepared Traceability Matrices to track the requirements with the test cases and make sure none of them have been missed.
• Validated Data Migration and Data Cleansing
• Logged defects using HP Quality Center 10, linked defects with requirements and generated Defect Reports in QC.
• Participated in change review meetings and suggested on the testability of the CRs.
• Tested drill down reports, sub reports, linked reports, parameterized reports created using SSRS.
• Worked with other members of the QA and Development teams and managed efforts with offshore team in improving the processes, methods, effectiveness and efficiency.
• Attended daily status call with Offshore to review assigned tasks and solve any impediments.
• Used Toad to query against the Oracle data source.
• Tested Fast-Load, MultiLoad and BTEQ utilities.
• Tested Informatica jobs scheduled using Autosys.
• Participated in walkthrough and defect report meetings periodically.
• Documented and reported various bugs during the Testing process.
• Written SQL Queries to identify and validate the code written for the data movement into the database tables.
• Retested the resolved defects/issues after the developers fix the defects.
• Involved in preparing test data/ Test script for UAT and participated in UAT signoff
• Updated the status of the testing to the QA manager, and accomplished tasked for the assigned work to the Project Management team regularly.

Environment: Informatica 9.0, Oracle 10g, My SQL, Teradata V2R5, SSRS, SSAS, Teradata SQL Assistant, AutoSys, TOAD 8.0, SQL, UNIX, Quality Center 10.0,RQM

Confidential, Baltimore, MD

BI/DW QA Engineer

Responsibilities:

• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Tested data migration to ensure that integrity of data was not compromised.
• Managed multiple OLAP and ETL projects for various testing needs.
• Debugged the developer written SQL-Statements and stored procedures for various business scenarios.
• Performed extensive Data Validation, Data Verification against Data Warehouse
• Responsible for the understanding the business requirements, ETL and subsequently design ETL testing strategy using SQL scripts.
• Tested several Business Objects Reports for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI’s, Grouped List, Cascade and Web Reports.
• Tested and validated the Business Objects reports by running similar SQL queries against the source system(s).
• Tested various SSIS tasks like Conditional Split, Derived Column, Merge join, data conversion.
• Testing the source and target databases for conformance to specifications.
• Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center 9.8
• Tested several data migration application for security, data protection and data corruption during transfer.
• Tested the scripts designed to monitor uptime/downtime of different system components
• Written Test Cases for ETL to compare Source and Target database systems.
• 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 written test scripts for back-end validations

Environment: SSIS, Oracle 9i,DB2, Teradata, SQL Server 2008 R2, Business Objects XIR3, WinSQL, QTP 9.5, Quality Center 9.8, TOAD, Teradata SQL Assistant 6.0, PL/SQL, IBM DB2.

Confidential, Edison, NJ

ETL QA Tester

Responsibilities:

• Analyzed Business Requirement Document, Software Design Document, Software Requirement Specification and Functional Requirement Document.
• Validated data from front end systems to the backend databases.
• Performed both Positive Testing and Negative Testing.
• Performed Code review of automation Scripts and made comments for changes made in the script.
• Involved in User Acceptance Testing, GUI Testing, and Regression testing, on different versions of the application.
• Involved in Data migration and Data distribution testing
• Validated the web services by testing the WSDLs using SOAP UI.
• Validated all the ETL mappings developed to fetch data from OLTP system to the data warehouse.
• Validated all the session logs.
• Participated in SCRUM and SPRINT meetings.
• Created Scenarios as per business requirements with various user loads using Performance Center.
• Extensively used SQL to query the Database to setup the test data for at least 500 virtual users for each applications.
• Also worked closely with the developers for the Performance Tuning of a new application by gradual Scaling of the application.
• Assigned critical performance Defects to the developer using Quality Center.
• Weekly meeting with the management team and share the Status Report on the weekly basis.
• Tested and validated data on MicroStrategy reports

Environment: Informatica, DataStage,SQL Server, Oracle, MicroStrategy 9.0, Quality Center (QC) 9.0/9.2, VB script, SQL, TOAD, Microsoft Visio, MS Access, Windows XP/2003/2007, Oracle