PROFESSIONAL SUMMARY:

• Over 8 years of IT experience in Validating Data Warehouses, Business Intelligence reports, ETL applications in the Banking, Health care, Energy, Financial, Telecom.
• Excellent ETL/BI testing experience with extensive backend testing and good understanding of Data Warehousing concepts & Architecture, Database concepts and Data Analysis skills.
• Expertise in Functional Testing, System Testing, Regression Testing, Backend Testing, ETL / Report Testing and UI Testing and used various Automated testing tools.
• Expertise in end to end testing, involved in preparing test plans, test cases, test scripts, execution of test cases, regression scripts.
• Very good knowledge in validating the data warehouses built on Oracle, SQL Server, Teradata and DB2.
• Expertise in developing Automation Frameworks for Web Applications using QTP
• Worked on HP's (Mercury) Quick Test Professional, Automated QA's Test Complete and guided them in handling individual projects.
• Expertise in Problem solving and creating Bug Reports using Bug Tracking Tools.
• Extensively used Test Director & Quality Center to write Test Cases and for reporting. All the Scripts are maintained using Test Director & Quality Center.
• Developed Test Scripts for manual testing and automated them using Win Runner, Load Runner and QTP.
• Experience in Front - end GUI testing of web based applications and client/server applications.
• Very good working knowledge of water fall and Agile/Scrum Software Development Life Cycles.
• Involved in UAT and Post production support activities.
• Expertise in testing ETL applications built in Informatica, Ab Initio, DataStage, and SSIS.
• Very good knowledge on complete test cycle and defect life cycle.
• Validated reports developed in SSRS, Cognos, SAP Business objects, Micro Strategy.
• Experienced in writing and executing SQL queries to verifying Source-to-Target Mapping.
• Used HP Quality Center for test management and defect management.
• Worked on validating reconcile and delta loads of ETL applications.
• Experience in validating functionality of the application on different browsers and operating systems.
• Experience in usage of defect tracking tools Quality Center, Clear Quest, Rally, JIRA for logging the defects, generation of reports and analyzes the reports.
• Good knowledge and working experience in using UNIX commands and VI Editor.
• Experience in working as onsite offshore coordinator.
• Experience working on various source systems such as RDBMS, Flat Files, XML Files, Legacy Systems.
• Working experience in all phases of software/Test development life cycle that including requirement Analysis, application/test design, test execution, UAT, post production support.
• Experience in validating ETL, PL/SQL, UNIX batch jobs scheduled using Autosys, Cron tab.
• Expertise in working with Informatica power center, power exchange, IDQ.
• Very good experience in working fast paced agile/Scrum environments.
• Excellent communication, technical skills and very good team player.

TECHNICAL SKILLS:

ETL Tools: Informatica, Data Stage, Ab Initio, SSIS

Test Management Tools: HP Quality Center 11/10.0, Rally, TFS, JIRA

Databases: SQL Server 2008/2005, Oracle 11g, DB2, Teradata

BI Reporting Tools: Cognos 10/8, MicroStrategy, Business Objects XI, SSRS

Software QA & Testing: SDLC, STLC, Test Plan Development, Development and Execution of Test Cases

Defect Management Tools: ClearQuest, Quality Center

DB Query Tools: Toad, Rapid SQL, Teradata SQL Assistant

Version Control Tools: Rational Clear Case, VSS, Win CVS

Operating System: Windows 7/XP, UNIX, LINUX

Languages: SQL, PL/SQL, XML, HTML, C, Java, .NET, Visual Basic

Browsers: IE, Firefox, Chrome and Safari

Other Tools: Putty, WinScp, Fiddler

EXPERIENCE:

Confidential, Addison, TX

Sr. ETL / DWH / BI Tester / Data Analyst

Responsibilities:

• Involved in creating the test strategies and test plans.
• Involved in creating the test cases based on Functional requirements, Business requirements, Mapping specifications, Entity relationship documents.
• Involved in executing test cases and also responsible for creating and maintaining the test results.
• Used Informatica workflow manager to execute the workflows and Informatica workflow monitor to monitor the status of the workflows.
• Validated the initial and incremental loads of EDW.
• Performed Backend testing, ETL testing, Reports testing, Black Box Testing based on the functional requirements.
• Performed User Acceptance Testing, Post production support.
• Strong knowledge of Project Life cycle, Software Development Life Cycle (SDLC) methodologies like Agile,Scrumand Waterfall, Software Testing Life Cycle (STLC) and the Role of QA
• Written several complex SQL queries for ETL and Report testing.
• Reported defects on ClearQuest and followed till they are closed.
• Involved in validating various ETL, PL/SQL, Report batch jobs scheduled using autosys.
• Involved in validating SSIS and SSRS packages according to business requirement documents.
• Involved in validating SSAS cubes according to functional specifications.
• Tested the Front-end functionality for the entire application, navigational testing, and tested broken links.
• Involved in validating cross browser testing.
• Tested the XML files and checked whether data is parsed and loaded to staging tables
• Involved in testing reports and closely worked with Release team, technical operations team to complete the SIT phase.
• Expertise in developing Automation Frameworks for Web Applications using QTP
• Worked on HP's (Mercury) Quick Test Professional, Automated QA's Test Complete and guided them in handling individual projects.
• Designed test data using excel and GS data generator to test the application with positive and negative inputs.
• Validated Informatica workflows that are using transformations such as aggregators, filters, expressions, joiners, routers, sorters, look up.
• Used Toad to run SQL queries to check data is populating as expected from tables.
• Performed in data validation, data profiling, data scrubbing, and data frequency analysis.
• Validated Cubes, Adhoc Reports and Standard Reports built from Cognos.
• Uploaded test cases into Quality Center and executed them in test lab.

Environment: Oracle 11g, SQL, PL/SQL, Informatica 9.1 (Power Center, Power Exchange, IDQ), Quality Center 11, Cognos 10, SQL Server 2008, SSIS, SSRS, SSAS, Java, XML, Autosys, Rational Clear Case, Rational Clear Quest, TFS, UNIX, Putty, TOAD

Confidential, Bloomfield, CT

Sr. Data Quality tester / ETL / Reports Tester

Responsibilities:

• Prepared Test Plan and the Test Strategy based on business requirements and Functional Specs.
• Developed Test Cases for Operational Data Store, Enterprise Data ware house, Standard Reports, Adhoc Reports, OLAP, CUBES and UI Testing.
• Involved in reviewing Test plans, Test cases and Test scripts according to requirement specifications.
• Created traceability matrix to map Test cases against Requirements using Quality Center.
• Validated the slowly Changing Dimension type 1 and 2 based on the requirement.
• Validated ETL DW load statistics and Data mart Loads on an Ongoing Basis.
• Validated whether Source to Target ETL mappings are according to transformation rules and Business Rules.
• Validated Data Stage jobs by running them in data stage director.
• Validated Data Stage ETL jobs for the data quality and record count.
• Validated Adhoc Reports, Standard Reports for Data quality.
• Prepared complex SQL scripts for functional and data validation of ETL applications.
• Validated the record count between source and target for passive and active ETL transformations.
• Created test sets based on scenarios to validate EDW.
• Expertise in developing Automation Frameworks for Web Applications using QTP
• Worked on HP's (Mercury) Quick Test Professional, Automated QA's Test Complete and guided them in handling individual projects.
• Collected and distributed Test and Defect metrics based on priority.
• Quality Center is used for Test management.
• Validated Cubes, Adhoc Reports and Standard Reports built using Cognos.
• Involved in all phases of Agile/Scrum Development Methodology.
• Participated in reviewing the project and coordinating with onsite Clients, onsite Project Leads and local reporting managers.
• Involved in onshore offshore co-ordination of project.
• Involved in reviewing and modifying test cases & scripts after initial iterations of testing phases to account for changes in project scope.

Environment: Oracle 10g, DB2, SQL Server, SQL, PL/SQL, Qlikview, T-SQL, Data Stage 8, Quality Center 10, Remedy, Rapid SQL, Toad, UNIX, Putty, Teradata, Flat Files, .Net, C#, Rational Clear Case, Rational Clear Quest, XML, XML Spy, Business objects XI, JIRA

Confidential, Seattle, WA

ETL/BI/DWH QA Analyst/Data Analyst

Responsibilities:

• Analyzed the Business Requirements and Rules and worked with Business Analysts and Business Users in preparing Test Plans.
• Gone thru the Functional Specifications and implemented their technical aspect in System and Integration testing (SIT).
• Developed Test cases, Test scripts from the data mapping documents, functional Specification documents and mapped the test cases with the requirements for generating the Requirement Traceability Matrix (RTM).
• 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).
• Developed and executed test cases and test scripts.
• Performed Integration, Regression, Performance and Functional Testing.
• Worked with the UNIX shell scripts.
• Used HP Quality Center as test management tool.
• Validated various SSIS packages according to functional specifications.
• Tested Cognos Reports according to the business requirements.
• Exclusively used Analysis Studio and Query Studio to test the Cognos Reports.
• Tested several complex reports generated by Cognos including Dashboards, Summary Reports, Master Detailed,Drill down.
• Prioritized the test cases based on the projected metrics and project deadlines.
• Analyzed and tested DataStage jobs with OLTP source data, staging and target data.
• Worked with Developers on Defects until the test case is passed.
• Extensively written SQL to confirm the data transfer from source to target.
• Found the Defects when running the test cases and assign to ETL Developers using Defect Tracking tool like Clear Quest.
• Tested data and cosmetics of Micro Strategy reports.
• Tested the PL/SQL procedures, functions, packages according to the requirements.
• Performed Backend database testing, by executing the Group functions, complex Joins and sub queries.
• Verified test results (viewing the log files using VI editor, querying the database using the SQL) documenting the defects.
• Involved in testing the UI screens, reports which was used by the internal business team.
• Involve in the defects tracking meeting for the system integration testing and communicated the issues and escalations with the project manager.
• Responsible for Data integrity and Data validation testing.
• Involved in testing the functionality of Data Stage jobs.
• Executed ETL jobs through Data Stage director and monitored status.
• Effectively coordinated with the development team for closing a defect.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Attended Bi-Weekly Defect Review and Defect Status meetings. Provided updates to Team Lead on testing activities.

Environment: Data Stage 8.0, SQL, Qlikview, HP Quality Center, Cognos 8.0, Micro Strategy Clear Case, Clear Quest, RequisitePro, TOAD, JCL, Web Logic, Oracle 10g, SQL Server 2008, SSIS, SSRS, DB2, PL/SQL, UNIX, PuTTY, Flat files, Session Logs, Windows XP.

Confidential, Charlotte, NC

ETL Tester/Data Analyst

Responsibilities:

• Created Test Scenarios and test plans to Validate Data from source.
• Developed Test cases and Test scripts and Traceability matrix from Functional Requirements and Use cases.
• Involved in validating data moving from multiple source systems to ODS and EDW.
• Performed functional, integration, regression, UAT and end to end testing for the project.
• Validated the Fact and Dimension tables in Star Schema
• Extensively used Oracle/Teradata to write SQL Queries to validate the initial and incremental loads.
• Prepare and maintained test cases with changes in application interface and navigation flow.
• Validated SSIS packages for record count and the data moving from source to target.
• Performed batch testing of ETL jobs schedules in Autosys.
• Validated various Complex ETL graphs based on data mapping specifications to load data from desperate source flat files and RDBMS tables to target tables.
• Collected QA documents like test metrics, reports, and schedules.
• Involved in validating various business objects reports for layout and data presented.
• Validated several SSRS reports according to functional specifications.
• Reported and prioritized defects using Quality Center and presented reports in weekly team meetings.
• Involved in testing the Ab Initio ETL graphs based on data mapping requirements and Entity relationship diagrams.
• Validated various options like pushbutton, textboxes, radio and check boxes on the web pages are working fine.
• Validated Adhoc Reports, Standard Reports, drill up, drill down, dashboards and charts.
• Closely worked with Technical operations and Release management teams to resolve the production issues.
• Validated various database objects including stored procedures, functions, packages, triggers using data driven approach.

Environment: Ab Initio 2.13, Teradata V2R5, Quality Center, SQL, PL/SQL, TOAD, Autosys, UNIX, Business Objects, Oracle, Rally, SQL Server, SSIS, SSRS, C#, .net, Java, Clear Case.