SUMMARY

• Over 8 years of IT experience as Data Warehouse/Business Intelligence solutions and Web - based Applications Quality Assurance Analyst.
• In depth knowledge of Testing methodologies, Concepts, Phases, and Types of testing, developing Test Plans, Test Scenarios, Test Cases, Test Procedures, Test Reports and documenting test results accordingly after analyzing Business Requirements Documents (BRD), Functional Requirement Specifications (FRS).
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Exclusive experience in all aspects of Software Test Life Cycle including System Analysis, Design, Development, Execution, Reporting and Closure Documentation.
• Experience in writing and executingTestPlansandTestCasesfrom Requirements and Design documents
• Used ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Ab Initio, Informatica PowerCenter.
• Experience in testing Business Objects reports along with the data validation for the reports
• Expert in writing complex SQL Queriesto check the integrity of data to perform database testing.
• Have solid experience on database query tools such as Teradata SQL Assistant, TOAD, SQL Navigator, and SQL Plus.
• Prepared Test Cases and Test Plans for the Enterprise Data Warehouses and Web Applications and executed those Test Cases and Test Plans.
• Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Experience on UNIX commands and Shell Scripting
• Experienced in Functional testing, Performance testing, Load testing, Integration testing, Regression testing, GUI Testing
• Experience in Requirement Analysis, Feasibility Studies, and Deliverables.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Understanding of Data Models, Data Schema,ETLand created extensive store procedures, SQL queries to perform back-end data warehousing testing.
• Experienced in Bug Reporting and Defect tracking using tools like HP Quality Center, Rational Clear Quest, and Test Director to log and defect management.
• Strong analytical, dynamic trouble-shooting and requirement traceability skills.
• Extensively worked with batch scheduling tools Control M, Autosys to run and monitor the ETL workflow jobs.
• Analyzing bugs, interacting withQA/development teams in fixing errors and User Acceptance Testing methodologies to validate the product before implementation.
• A skillful team player with excellent communication skills and has ability to work in a team and individual environment.
• Experienced in interacting with Clients, Business Analysts, IT leads, UAT Users and developers.

TECHNICAL SKILLS

Databases: Teradata 13.X, Oracle 11g/10g/9i, MS SQL, DB2, SQL Server 2008/2005

Methodologies: Waterfall, Agile/Scrum, RUP

ETLtools: Ab Initio 3.X, InformaticaPower Center 8.X, Data Stage 8

Reporting Tools: OBIEE, Business Objects, Cognos, MicroStrategy

Testing Tools: Test Director 8.2/8.0, Quality Centre 10/9.0/8.2Rational Clear Quest

Data Access Tools: Teradata SQL Assistant, TOAD, SQL NavigatorOracle SQL Developer

Programming Languages: C, C++, HTML, JavaScript, SQL, PL/SQL

Modeling Tools: MS Visio, Rational Rose 6.0

Requirement Tools: Rational Requisite Pro, Doors

Version Control Tool: Rational Clear Case, Win CVS

Operating Systems: MS DOS, Win 98/2000/XP/Win 7, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

Sr. DWH/ETL/BI QA Analyst / Data Analyst

Responsibilities:

• Analyzed the Business Requirements, Data Mapping 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), Backend (Database).
• Involved in testing the batch programs by using the Control -M tool.
• Used HP Quality Center to for test management activities.
• Tested Business Objects Reports according to the report specifications.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Prioritized the test cases based on the projected metrics and project deadlines.
• Worked with Developers on Defects until test cases are passed.
• Extensively written SQL scripts and executed 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 Quality Center.
• 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.
• Validated the data passed to downstream/upstream systems.
• Worked with the development team to create a suite of test data (Input files, Expected results), that fully exercises data validation (detecting, rejecting bad data) to test ETL functionality (properly processing).
• Involved in maintaining the test environments; with activities like requesting data loads, data base backups, restarting the servers, requesting the deployments, trouble shooting issues.
• Attended Bi-Weekly Defect Review and Defect Status meetings. Provided updates to Team Lead on testing activities.

Environment: /Tools: Teradata 13.10, Ab Initio 3.x, HP Quality Center 10, Business Objects XI 3.3, Manual Testing, Teradata SQL Assistant, Share Point, Control - M, UNIX, Waterfall, Agile

Confidential, Dallas, TX

Sr. DWH / BI Quality Analyst / Data Migration Tester /GUI Tester

Responsibilities:

• Conducted walkthroughs with customers, project management, and development team.
• Created Test Plans for various versions of ERP Reports applications from different Business Requirements created by the Project Management, and Business Line Teams.
• Prepared test cases, scripts based upon the business requirements documentation (BRD), use case documentations, and functional requirements specification (FRS).
• Performed Data Analysis for all incoming feeds toETL. Worked with Business Unit Managers for developing Mapping Document after Data Analysis.
• Created different objects: Stored Procedures, triggers script to populate data into different tables according to different parameters specified.
• Tested the data load process using theInformaticaPower CenterETLtool
• Error checking and testing of theETLprocedures and programs usingInformaticasession log.
• Focused on Data Quality issues/problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Used Workflow Manager for Workflow and Session Management, Database Connection Management and Scheduling of jobs
• Used HP Quality Center as Test Management Tool.
• Validated various SSIS and SSRS packages according to functional specifications.
• Utilized TOAD, SQL tools for querying and analysis of Oracle databases.
• Used Data Stage director to run the data stage jobs and verify according to data mapping requirements.
• Extensively performed backend testing on databases by writing complex SQL queries.
• DW was tested for the row counts and errors after each transaction loads.
• Suggested query improvements in some of the Stored Procedures and Views using SQL Profiler and Query Execution Plan.
• Point of contact for the client data testing, data accuracy and accuracy of functionality.
• Coordinating with source system owners, day-to-dayETLprogress monitoring and maintenance of dailyInformaticabatch schedule run on a nightly basis.
• Defects were identified, provided documentation to the development team for debugging.
• Tested standard and Ad hoc reports and undergone data validation for the OBIEE reports
• Exclusively used Analysis Studio and Report Studio to test the OBIEE Reports
• Tested several complex reports generated by OBIEE including Dashboards, Summary Reports, Master Detailed,Drill down.
• Performed Regression testing of the fixed issues in the new build until no new issues are identified.
• Submitted Final Test Report; required documentation for the project within assigned time frame.
• Involved in getting final signoffs from Test Manager and Business.

Environment: /Tools: Oracle 10g/11g, SQL, InformaticaPower Center 8.6, Rational Clear Case, Clear Quest, OBIEE Reports, TFS, SQL Server 2008, SSIS, SSRS, Manual Testing, PL/SQL, TOAD, HP Quality Center, UNIX, Data Stage, Agile, Doors

Confidential, Baltimore, MD

Sr. DWH/BI QA Analyst/ Web-based Tester

Responsibilities:

• Participated in requirements gathering, project definition, analysis and scoping activities associated with the SLD project
• Assisted with business and technical requirements, developed requirements traceability matrices
• Prepared test cases by understanding the business requirements, Data Mapping documents and technical specifications.
• Prepared Test Strategy document, System Test Plan, Performance Test Plan, Traceability matrix and Test Summary Reports
• Validated the most granular data items against OLTP systems and identified the source tables from which the data warehouse extracts data.
• Extensively worked with backend activities for testing several reports developed by BI tools. Written several complex SQL queries.
• Analyzed the requirements and fine tuned the stored procedures to improve performance.
• Validated the base table (Star schemas - Fact and Dimension) by writing complicated SQL statements and reports.
• Extensively tested several MicroStrategy reports for data quality
• Manual verification of data in the backend using SQL.
• Maintained the Requirement Traceability Matrices (RTM) to track the coverage of Requirements v/s designed test cases.
• Used Quality Center to store, schedule the test cases and report the Defects.
• Involved in functional, load, performance, stress and regression testing of the application. Performed Load and Performance Testing to identify and report performance bottlenecks.
• Involved in verifying the initial and daily load Ab Initio graphs.
• Involved in System Integration Testing & User Acceptance Testing.
• Created Test lab reports and defect reports on a daily basis.
• Tested standard and Ad hoc reports and undergone data validation for the MicroStrategy reports
• Involved in development and testing status report meetings which involved business, testing and core technology group on weekly basis
• Work with theQAand Project Managers to set and evaluate milestone criteria to ensure released products are on schedule with high quality.

Environment: /Tools: Oracle 9i/10g, db2, SQL, UNIX, Use Cases, BI tool: MicroStrategy, Data warehousing, Ab Initio 2.13, Teradata, Teradata SQL Assistant, Quality Center, TOAD, Windows XP, MS Project, MS Visio, MS Office Suite, Rational Clear Case, and Rational Clear Quest, Rational Requisite Pro

Confidential, Phoenix, AZ

DWH/Reports Tester

Responsibilities:

• Participated in business requirement walk through, design walk through and analyzed Business requirements and Coordinated with the business analysts and developers to discuss issues in interpreting the requirements.
• Analyzed the user requirements, functional specifications and Use Case documents and created the Test Plans, Test cases for Functional testing.
• Worked closely withETLteam in each phase of project (data requirement analysis, data field analysis, data mapping andETLtesting)
• Built external mapping to transfer data from SQL Server database to Oracle Data Warehouse. This includes writing SQL Statements.
• Coordinated in testingdata stage ETLusing complex stored procedures.
• Acted as first point of contact for all critical issues related to data mapping and data sourcing
• Reviewed and testedInformaticaETLcode
• Involved in Integration Testing, and Data Testing including boundary testing.
• Developed procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements.
• Actively participated in Functional testing, System testing, and Ad-hoc testing.
• Analyzed bugs, worked with development team andETLteam members in fixing defects and validating the solutions.
• Interacted with the development and product management team to find out the end user actions and scenarios.
• Tested adhoc and standard reports generated by using MicroStrategy.
• Involved in providing the Testing effort estimates and provided the timely feedback on progress of the testing activity.
• UpdatedQAManager and Lead weekly with the testing status, which included Test Task Plan, Defect Management, and Test Metrics.
• Successfully Coordinated User Acceptance Testing (UAT) on each release of the project with the help of end user requirements.
• Involved in doing Business analysis and Requirements gathering for newInformaticamappings.
• Coordinate all aspects of the solution delivery including design, development, testing, and deployment.

Environment: /Tools: Oracle 9i, MS SQL Server 2005,InformaticaPower Center 8.1/7.1, Data Stage, Cognos, Manual Testing, PL/SQL, Rational Rose, Rational Clear Case, Rational ClearQuest, MS Office Suite.

Confidential, Fairfax, VA

Manual Backend Tester

Responsibilities:

• Involved inQAAnalysis, Design, and Testing of the data warehousing application.
• Created Test strategy and Test Plans, reviewed requirements to ensure they were clear and testable
• Executed Test Scripts and Test Cases using manual testing procedures.
• Designed test design documents andQAproject development design documents.
• Followed up the timelines with the test Plan document and development design documents.
• Coordinated test activities with all testing resources
• Performed Regression testing on corporate and personal documents and fixed the errors.
• Tracked defects through Test Director.
• Testing to make sure that data is moved from source database to destination database by writing SQL queries.
• Created Traceability Matrix to ensure that all the requirements are covered by the test cases
• Involved in testing Crystal reports for data quality and cosmetics according to requirements.
• Conducted status report meetings with internal team on a weekly basis and Documented and tracked status meeting minutes and activities.
• Provided clear concise feedback to Development team on recurring errors both on an individual and team basis with aim of long-term reduction of defects found in final releases

Environment: /Tools: SQL, Oracle 8i, DB2, Crystal Reports, Manual Testing, MS Office, MS Visio, MS Excel, LINUX