SUMMARY:

• Over 7+ years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Expert in writing complex SQL queries and Unix to execute the back end jobs.
• Expertise in defining Test Strategies, writing detailed Test Plan and Test Cases, Defect Tracking and Defect Reporting using Mercury Test Director and Quality Center.
• Extensive experience in Database Testing in Oracle, SQL Server and DB2 SQL.
• Expertise in Data Mover scripts for Data Export and Import.
• Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Sybase, and Teradata, Ms Access, Flat files into a staging area.
• Extensive experience in Data validation and verification in all ETL Stages (Source, Staging and Target environments).
• Created manual Test Cases in HP QC/HP ALM for various User Stories based on Release and Sprint Plan.
• Good knowledge on Automation Tool Selenium and Quick Test Professional.
• Extensively Used Quality Center, PVCS Tracker, Rational Clear Quest for Test Case and defect tracking management.
• Hands on expertise in Data ware housing concepts and tools. Involved in the ETL processes where in the organizations were using Data stage, Informatica, Ab initio and Auto sys tools.
• Analyzed and tested Data Stage jobs with OLTP source data, staging and target data.
• Experience on different types of Testing like Black Box, White Box, Integration, System, Functional and Regression Testing.
• Generated automated Scripts in QTP and designed Automated Test Suites for regression testing in Quick Test Pro.
• Knowledge of and ability to apply a wide range of software test engineering concepts: testing principles (Testing Methodology) and concepts, building a test environment, tracking defects n Quality Center
• Hands on expertise with test automation tools such as HP QTP (Quick Test Pro).
• Experience in assisting the customer in User Acceptance Testing (UAT).
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP and SDLC methodology environments.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture
• Excellent skills in TeraData, DB2, SQL Server and Oracle 11g/10g/9i/8i RDBMS and Sybase.

TECHNICAL SKILLS:

Quality Assurance Tool: HP ALM 11/HP Quality Center 10, Test Director 7.5, IBM ClearQuest

Environment: Windows 98/2000/NT/XP, IBM Mainframes, Unix, Linux.

Languages: SQL, PL/SQL,Shell, Perl and bash

RDBMS: Oracle 8i/9i/10g/11g, SQL Server, Teradata, Sybase, DB2

GUI/RDBMSQuery Tools: SQL* Plus, Oracle SQL Developer, SQL Server Management studio, Teradata SQL Assistant 13.0, TOAD, WinSQL

ETL Tools: Informatica PowerCenter 8.x/9, Ab Initio, SSIS and Datastage

BI Tools: Business Objects XIR2/XIR3, Cognos, Microstrategy, SSRS and Hyperion

PROFESSIONAL EXPERIENCE:

Confidential, Durham, NC

Sr. ETL QA Analyst/Backend Tester

Responsibilities:

• Documented the business requirements, developed test plans, test cases created for the database backend testing and to test database functionality.
• Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• Different Data Stage components especially are used effectively to develop and maintain the database
• Developed ETL test cases for various lines of businesses based on ETL mapping document.
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and Oracle databases.
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
• Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, System (End to End) and Backend (Database).
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded.
• Developed and Executed Test Plan & Test Script in Quality Center
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate - wide-ETL Solution.
• Execute batch jobs using Control-M enterprise manager and check SYSOUT, ERROR LOG details.
• Used SQL for Querying the Oracle database in UNIX environment
• Written Complex SQL Queries. To do Manual testing in my feature for every release and check the configurations
• Tested several ETL job activity for data stage using Data stage designer
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS packages.
• Tested several different types of reports including Report Layout, Naming Conventions, Totals, and Sub-Totals, Drilling options, prompts, metric calculations, drill maps and security filters.
• Ran several jobs in data stage from both command line and front-end.
• Wrote SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Raised defects in HP Quality Center defect tracking system.
• Designed Traceability Matrix to match the test scripts with the Functional design document.
• Good experience in writing SQL in order to data validation in migration as part of backend testing Worked with ETL group for understating mappings for dimensions and facts.
• Assisted in promotion of Data stage code and UNIX from UAT to Production.

Environment: SQL,PL/SQL, TOAD, Data warehouse ETL IBM Data Stage 8.1, Micro strategy, Quality Center 10.0, Visual studio, MS Access,, DB2, SDLC, TSYS, SQL Developer, Oracle 10g/11g, QTP, UNIX, PERL, DB Visualizer, EMWE WEBSITE, Flat Files, Pivot Tables, Pivot Tables.

Confidential, Winston-Salem, NC

Sr. ETL QA/Backend Tester

Responsibilities:

• Running of ETL jobs and test data setup using Autosys, Quality check for test data. -Transformation logic verification, RCA for defect found.
• Used SQL tools like TOAD for Oracle to run SQL queries and validate the data loaded into target tables
• Tested several Informatica Mappings to validate the business conditions.
• Testing the source and target backend databases for conformance to specifications
• Participated in daily meetings with Business/DEV teammates to enhance the productivity.
• Worked in an intense AGILE environment, where the code is delivered every 3 days .
• Participated in weekly defect review meetings with the dev./business and test team peers
• Extensively involved in Onsite-Offshore model, where need to held meetings on daily basis, as were following AGILE methodology.
• Tracked the defects using QC ALM tool and generated defect summary reports.
• Extensively used grep,AWK,find commands and used Shell Scripting to call back end jobs
• Validated the data movement (XML, Flat Files, VSAM,.dat,.xls) and transformations are done correctly
• Worked with Data Warehousing developers who extensively used Informatica9x, to design
• Mapping to move data from source to target database-using Stages to do the functionality.
• Testing of Data Mapping documents between source and target databases as per transforming logic
• Prepared status summary reports with details of executed, passed and failed test cases
• Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application and Oracle databases.
• Reviewing Functional Specification Document and preparing traceability matrix for test case mapped.
• Responsible for WQA representation in the full end-to-end testing processes.
• Design and write formal test plans and test specifications to address system, integration, and data conversion testing.
• Participated to develop automation scripts in QTP to automate smoke and regression testing.
• Tested several BO Reports for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI’s, Grouped List, Cascade and Web Reports
• Used Quality center to execute automation scripts in batch mode or unattended mode.
• Enhanced the scripts in QTP by applying checkpoints, parameterizations, synchronization point, data driven tests and creating modular tests.
• Partner with business and development partners to create detailed test plans and validation strategies.
• Identify and document defects in a defect tracking system and manage issues/defects through resolution.
• Identifying duplicate records in the staging area before data gets processed. Provide communication to project stakeholders.
• Manually execute detailed test procedures designed to validate application functional requirements.
• Ensure software requirements are verifiable and quantifiable with the ability to build test cases.
• Contribute to efficient and effective program in solving medium-complex business problems.

Environment: SQL, Oracle, TOAD, Unix, ETL Informatica 9.1, AutoSys, WIN SCP, QTP, Java, VB descriptive scripting, HP ALM Quality Center 11.0, Microsoft Windows 7, Shell scripting, Business Objects, C++, XML, Test Director, J2EE, SAP

Confidential, VA

QA DWH Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Assisted for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• External interactions with NSCC, DTCC, NFS and various fund companies in which MMLISI is associated.
• Promoted Unix/Data Stage application releases from development to QA and to UAT environments as required.
• Wrote Complex SQL queries and PL/SQL subprograms to support the test case results, SQL performance tuning.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to test business rules and security.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Assisted in promotion of Data Stage code and UNIX Shell scripts from UAT to Production.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Assisted in System Test and UAT testing scenarios as required
• Worked with thin client and thick client (Business Objects )
• Extraction of test data from tables and loading of data into SQL tables.
• Created ETL test data for all ETL mapping rules to test the functionality of the Data Stage Mapping
• Extensive experience in writing complex SQL and PL/SQL scripts.
• Tested the ETL Data Stage mappings and other ETL Processes (Data Warehouse Testing)
• Written several complex SQL queries for validating Cognos Reports.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc..
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with business team to test the reports developed in Cognos
• Used Quality Center to track and report system defects
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables

Environment: Data Stage, SQL, PL/SQL, TOAD, MVS, UNIX, Oracle, DB2, Business Objects Windows 2000 Pro, XML, XSLT, XSD, Rapid Data Files, XML Files, Visual Studio, MS Access, Quality Center, Autosys

Confidential, Chicago, IL

SQL Tester

Responsibilities:

• Involved in Data Validation using SQL queries.
• Performed negative testing, to make sure validations are done properly.
• Provide update to management on testing status and some other issues.
• Carried out and oversee test execution for Business scenario, User acceptance and Regression testing
• Reviewed Data Stage Jobs and test cases before delivering to Client.
• Involved in Data Validation with Business Team.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.
• Was involved in design part for Extracting data from different source systems into the target database using Data stage Server 6.1.
• Extensively involved in Extracting, Transformation and Loading of data to target oracle warehouse database.
• Was responsible for Creating Job, Job Sequencers and Shared Containers.
• Extensively developed and deployed Unix Shell scripts as wrappers that build runtime parameters to DataStage jobs.
• Validated several Business Objects reports. Reviewed and tested business requests for data and data usage.
• Validated Business Objects dashboard reports by writing several complex SQL queries based on reporting logic.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Review the test cases written based on the Change Request document.
• Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Used Test Director, to manage the entire process and log in defects
• Effectively coordinated with the development team.
• Created critical scenarios for each change request and defect request.

Environment: Data stage Server 6.x, Oracle 9i, Business Objects 5.0, C++, UNIX, IBM AIX 5.0, Test Director, and Shell Scripting