SUMMARY

• 7 years of extensive experience in Information Technology with emphasis on Quality Assurance, Data warehousing Testing, Manual testing of Web and Client/Server based commercial applications.
• Involved in the Analysis, testing and Implementation of Business Intelligence solutions using Data Warehouse / Data Mart Design, ETL, OLAP, Client/Server applications.
• Well versed with Software testing concepts, SDLC, Agile and Waterfall methodologies
• In depth technical understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.
• Extensive experience in testing ETL data from multiple sources into Data warehouse using Informatica.
• Experience in Data Analysis, Data Validation, Data Modeling, Data Profiling, Data Verification, Data Mapping, Data Loading, Data Warehousing/ETL testing and BI Reports Testing
• Extensive ETL testing experience using Informatica Power Center 8.1/7.1/6.2 components (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• Expert in using Test Management Tools - HP Quality center 10
• Worked with different querying tools like SQL Assistant, TOAD, Oracle SQL Developer, iSQL * plus
• Experience in writing complex SQL and PL/SQL statements.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
• Expert in Test plan, Test strategy, Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Implemented various Test cases for the Functional Testing, smoke testing, re-testing, Regression Testing, Configuration Testing, Performance Testing, Back-End and User Acceptance testing (UAT)
• Ability to understand and adapt to new technologies and environments faster, good at analysis and troubleshooting and excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS

Test Management Tools: TestDirector9.0/8.0/7.5, Quality Center 10 / 9.2 / 8.2

ETL Tools: Informatica 7.1/8.x, Data Stage 7.5, Ab Initio (GDE 1.13, Co>Op 2.13

Bug Reporting: Quality Center 9.2,Rational Clear Quest, Test Director, Bugzilla

Programming/Scripting Languages: SQL, PL/SQL, XSLT, JCL, HTML, XML

Operating Systems: Windows XP/NT/2000, DOS, Mac 10.4, AIX-UNIX, LINUX

Databases: Oracle 10g/9i/8i/7.3, MS SQL Server 6.5/7.0/7.5/2005 , Sybase12.0/11.0, MS Access 2005, Teradata V2R6/V2R5

Reporting Tools: Business Objects, Cognos 8.0

PROFESSIONAL EXPERIENCE

Confidential, Richmond VA

Sr. ETL QA Analyst

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Interacted with senior peers or subject matter experts to learn more about the data.
• Validating the Workflows and running them using Workflow Manager.
• Prepared Test Cases and Test Plans for the mappings developed through the ETL Informatica tool.
• Tested different detail, summary reports and on demand reports. Extensively used Cognos for report generation.
• Experienced in writing complex SQL queries for extracting data from multiple tables and validating with target tables.
• Experience testing tables like SCD Type 1, Type 2 & Type 3 verified history load and incremental load data.
• Developed advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Validated target tables DDL, counts, data (Business rules), negative testing and regression testing.
• Involved in preparing Test Plan from the Business Requirements and Functional Specification, Design, Development and Implementation of RDM (Report Data Mart).
• Strong technical Knowledge of UNIX Utilities, Shell Script to automate process.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Involved extensively in doing back end testing of the data quality by writing complex SQL.
• Ensured data integrity and verified all data modifications and calculations during database migration.
• Responsible to get Test data from Production source to QA Source
• Exported Manual Test Cases from MS Excel template directly to QC and executed the Test Cases in Test Director with Pass/Fail/Blocked status.
• Executed the developed Test Cases and Test Plans and also responsible for creating Test Strategy for the Data Warehouse.
• Reported the Bugs/Defects using Quality Center 10 defect management tool.
• Responsible for communicating Defect Status Reports to business in project meetings
• Worked with Production environment to resolve several data issues.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Performed Functional testing, System testing, Regression testing and Back end testing.
• Involved in Production Support related activities including resolving end user queries, investigation and resolving data related issues
• Provide flexible & high quality support to wider Testing strategies on key regular deliverables & Adhoc reporting issues
• Coordinated with the developers to resolve defects.
• Involved in documentation in order to maintain and run scripts for future enhancements.

Environment: Informatica Power Center 9.1/8.5.1, Oracle 10g, SQL, PL/SQL, Excel Files, Windows NT & UNIX, Quality center 9.2, Cognos8.4.1

Confidential, Columbus, OH

ETL QA Analyst

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Developed Test Plan and overall Test Strategy for the Application.
• Preparation of technical specifications and Source to Target mappings.
• Developed test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Created Test Strategy for Enterprise Data Warehouse in ETL framework, including Business Intelligence.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Deleting the target data before processing based on logical or physical primary key.
• Design and execute the test cases on the application as per company standards.
• Testing of records with logical delete using flags.
• Experience in data retrieval methods using Universes, Personal Data files, Stored Procedures, and free hand SQL.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Loader to load Test data from flat files to tables.
• Reported bugs and tracked defects using Quality Center.
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Designing and creation of complex mappings using SCD Type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Worked on issues with migration from development to testing.
• Extensively tested several Cognos reports for data quality, fonts & headers.

Environment: Informatica power center 8.6, Oracle 9i, SQL, PL/SQL, SQL Server 2005, UNIX, Unix Shell Scripting, IBM DB2, XML, SQL *Loader, Cognos 7.0, Erwin 3.5, Windows 2000, TOAD 7, Quality Center 9.2

Confidential, Howell, NJ

ETL/Data Warehouse Tester

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Written Test Cases for ETL to compare Source and Target database systems.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet designer and Transformation.
• 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.
• Tested the ETL process for both before data validation and after data validation process.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Testing has been done based on Change Requests and Defect Requests.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Involved in integration testing of Informatica mappings.
• Performed all aspects of verification, validation including Functional testing, Unit Testing, System testing, Regression testing, structural testing, Performance, load and Back-End testing manually.
• Experience testing tables like SCD Type 1(Staging Tables) and Type 2(Target Tables)
• Responsible for different Data mapping activities from Source systems to Teradata.
• Queried Teradata Database and validated the data using SQL Assistant
• Used Quality Center to track and report system defects.
• Performed Data validity testing for reports and feeds based on client's requirement.
• Created reports that included a general overview, open bugs, new bugs and enhancement requests.
• Entered new bugs and maintained the current status of those bugs.
• Responsible for communicating Defect Status Reports to business in project meetings.
• Participated and Organized weekly meetings and walkthroughs to improve the testing efforts.
• Worked closely with engineering team to discuss the design and testing aspects of the applications to design the test plans and to isolate the root cause of defects.
• Involved in meetings and walkthroughs.
• Responsible for weekly status.

Environment: Informatica Power Center 7.2 (Power Center Designer, workflow manager, workflow monitor, UNIX, Oracle8, Teradata V2R4, SQL Server 2005, Windows 2000, Cognos8.4.1,Quality center 9.2

Confidential, San Francisco CA

QA Tester

Responsibilities:

• Participated in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis.
• Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Beds, Test Data and Traceability Matrix.
• Conducted Functional, GUI, Regression and User-Acceptance (UAT) testing.
• Developed XML test files based on XML schema.
• Generated XML data files using XML Spy.
• Validated the Web Services (SOAP), both Request and Response messages.
• Tested the Source and Target databases and ETL process.
• Developed Test Cases and Test Design using Quality Center.
• Automated the scripts using QTP by developing VB scripts. Developed functions in QTP.
• Worked with SQL, PL/SQL and functions to test the database integrity (Oracle).
• Created Traceability between Requirements and Test Cases.
• Conducted Data Driven testing to test various sets of data. Worked with UNIX Shell Scripts.
• Tracked the defects using Test Director and generated defect summary reports.
• Maintained Test Logs, Test Summary reports and participated in defect review / Status / GO-NOGO Meetings.
• Configuration management / Version control was done using Visual Source Safe.

Environment: Mercury Tools, QTP 8.0, VB.NET, ASP.NET, IIS, XML, SOAP, Windows XP, SQL Server, Mainframes (DB2, JCL, CICS), MS-Office.