SUMMARY

• Over 7 years of extensive experience in Quality Assurance, ETL Testing, Business Intelligence and Data Warehousing applications
• Ensuring onsite to offshore transition, QA Processes and closure of problems & issues.
• Extensive experience in testing of data warehouse / data marts for business applications with healthcare, Banking and Insurance Domain
• Extensively used ETL methodology for testing data extraction, transformations and loading process using Informatica, Ab Initio and other ETL tools
• Expertise in Testing complex Business rules by validating complex mappings and various transformations
• Tested data quality for MDM, customer data integration and Match - Merge process.
• Automated and scheduled the Data Stage jobs using UNIX Shell Scripting
• Extensive experience with ETL tools Informatica Power Center, IBM Data stage and Ab Initio.
• Experience in testing XML files and validating the data loaded to staging tables
• Strong working experience on DSS (Decision Support Systems) applications
• Experience in Cognos and Business Object Reports Testing
• Experience in writing test cases, test plans, and uploading test cases in Quality Center
• Experience using SQL queries to check the Data Validity after Extraction, Transformation & Loading for Business Intelligence Reports
• Experience in testing and writing SQL and PL/SQL statements including complex joins and numerous stored procedures
• Well acquainted with testing techniques used in SDLC
• Experience in Preparation and Execution of Test Cases, Defect Tracking, and Reporting using Quality Center & Bug tracker
• Experience in Functional testing, GUI Testing, Regression Testing and Automation testing
• Experience in coordinating testing activities with Onsite QA Team during different testing phases like Smoke testing, System integration and UAT Testing
• Experience with Test Development lifecycles and QA methodologies
• Review of project requirements and active involvement in all phases of SDLC
• Experience in different UNIX flavors (like Sun Solaris, HP- UX)
• Experience with Database tools like Toad, SQL Developer
• Strong documentation skills using Microsoft Word and Excel
• Effective communication and interpersonal skills, professional attitude, and strong work ethic
• Ability to interact with all levels of personnel from technical to high level executive management

TECHNICAL SKILLS

ETL Tools: Informatica 6.1/7.1/8.1 (PowerMart & PowerCenter), SSIS, Data Stage, Ab Initio

Reporting Tools: Cognos Series 8, Business Objects XI2

Operating systems: Windows 2003 & 2008 Server.

Database: Oracle 9i, 10g, 11i, D, Teradata

Utility: Toad 8.0, SQL developer, SQL Assistant 12.0

Testing Concepts: Manual Testing, Testing Levels, Test Techniques & Test Management

Test Management Tools: HP Quality Center 9.2, 10.0, Mercury Quality Center 8.2

Query Language: SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Chicago IL

ETL QA Tester

Responsibilities:

• Tested ETL Mappings and worked with Source to Staging area to validate the Basel II multiple source system data with SQL queries
• Planned, developed and executed test plans, including detailed test scripts and Test status reporting to Project manager
• Tested the data acquisition, data transformation and data cleansing approach for the MDM implementation.
• Performed monitoring of the ETL jobs (Extraction, Transformation and Loading) with the help of Informatica.
• Experience in Leading the Offsite Project, managing a team of 8 Offshore and 4 Onsite consultants
• Validated Data Migration from Source to Staging using SQL developer
• Involved in preparation of test data to test the functionality of the mappings
• Tested jobs for checking the record counts between data from source to target
• Analyzed Business Requirement and Technical Requirements documents
• Prepared test cases, executed test cases and report defect using HP QC 10.0.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan
• Experienced in creating the SSIS packages, DTS packages.
• Involved in Manual and Automated Basel II web Compliance tools testing using QTP/Quality Center/RQM
• Executed Informatica workflows to test the ETL processes.
• Reported accurate testing status and created test summary reports
• Involved in extensive DATA validation using SQL queries and back-end testing
• Test Plan Execution, Defect Reporting and Test status reporting to Project manager
• Involved in testing reports generated by OBIEE.
• Test newly developed features to ensure proper functioning prior to release to QA for multiple MDM processes
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Attended QA Walkthroughs, Defect meeting and Test Plan Reviews
• Tested reports and ETL mappings from Source to Target
• Functioned as the Onsite / Offshore coordinator for a team.
• Used the Informatica Designer to develop various workflows for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Integration testing for each new Release (CR-Change request or PST-Production Support Task) by identifying business requirement
• Involved in extensive DATA validation using SQL queries and back-end testing

Environment: Oracle, QC 10.0, Caliber, OBIEE, SQL Developer, SSIS, Informatica 8.6.1, Toad, Windows XP

Confidential, Buffalo, NY

ETL Informatica Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and documented functional requirements in Quality Center 10.0
• Planned, developed and executed test plans, including detailed test scripts and Test status reporting to Project manager
• Participate in developing test plans, including regression tests, for newly developed features in MDM
• Tested ETL Mappings and worked with Source to Staging area to validate the Basel II multiple source system data with SQL queries
• Reviewing the project and coordinating with onsite Clients, onsite Project Leads and local reporting managers.
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Validated Data Migration from Source to Staging using Toad
• Ensuring Data integrity and data duplication
• Determined the level of testing required, validated new or revised system capabilities
• Developed Test Plans, Test Cases and Test Strategy with input from the assigned business analysts and data architect
• Experienced in working with DB2, Terada.
• Expert in writing Complex SQL/PLSQL Scripts in querying Teradata and Oracle.
• Involved in preparation of test data to test the functionality of the mappings
• Tested jobs for checking the record counts between data from source to target
• Used TOAD, DB Artisan tools(9.0) to connect to Oracle database to validate the data
• Performed Database testing to validate the data in Sources and Targets
• Responsible for testing all new and existing ETL data warehouse components
• Experienced at testing ETL's and flat file data transfers without relying on GUI layer
• Tested several UNIX Shell Scripts for running ETL procedures and jobs
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R3.1
• Used Quality Center 10.0 to prepare test cases, test execution, extract testing status and Defect tracking
• Tested MDM platform roadmaps for current vs. future state
• Involved in testing the HIPAA EDI Transactions for eligibility (270, 271), claims (837, 835) and enrollment (834).
• Worked with XML transactions for multiple feeds.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Involved in testing the Claims application and HIPAA EDI Transactions.
• Also tested the integration between Claims application and other applications like Providers, Eligibility and Member Services application
• Planned, coordinated and executed Business Objects deployment for End-users and documented the entire project
• Attended the client calls and updated the status of the Testing status to onsite and offshore needs
• As a Team player worked very closely with other data warehouse testers and development team

Environment: Informatica 8.6, Business Objects XIR3, Oracle 11i, Windows, Mainframe, HP Quality Center 10.0, Rational Clear Quest,Unix,DB2, SSIS, XML Files, Teradata, Teradata SQL Assistant

Confidential, PA

ETL QA Tester

Responsibilities:

• Reported accurate testing status and created test summary reports
• Continuously improved test models, test data, and test processes based on lessons learned
• Tested Business Objects reports and Web Intelligence reports.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Expert in writing Complex SQL/PLSQL Scripts in querying Teradata and Oracle.
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Managed user accounts and security using Business Objects Supervisor
• Tested data coming through various lines of business applications & databases like IPOS, OPUS, PDCLITE, RWOT and IMEFlex systems
• Involved in gathering and reviewing Basel II DWH Stakeholders Scope and Business Requirements with Business and Dev teams.
• Coordinated component and system testing with the appropriate technical groups and Release Management and documented test procedures and findings
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used TOAD, SQL developer software for querying the Oracle databases
• Created test mappings and MLOAD scripts for testing purposes
• Extensively used Data Stage tool to extract, transform and load the data from Oracle to DB2.
• Used Maestro scheduler for composing and executing jobs to simulate the production environment in QA
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Identified & analyzed functions, errors and performed Root Cause Analysis for the defects in the application and documented defects
• Prepared Test Cases with Entry and Exit Criteria
• Integration testing for each new Release (CR-Change request or PST-Production Support Task) by identifying business requirement
• Used Data Stage to test mappings, transformations and source and target tables
• Performed GUI Testing, Functional Testing
• Created and Executed Korn Shells in UNIX for ETL loading process
• Tested several business reports generated using Excel pivoting and Dashboards

Environment: Windows XP, Informatica Power Center 7.2,Business Objects XIR2, Unix, Mercury Quality Center 8.2 (Test Director), Maestro Conman Scheduler, IBM Rational Clear Quest, Oracle 10g, TOAD, Teradata SQL Assistant, DB2,SQL Developer

Confidential, LA, California

ETL /DWH Tester

Responsibilities:

• Extensively used Complex SQL queries and UNIX commands to first verify the data at file level and then at database level
• Analyzed data using SQL, Excel, Unix and data testing tools
• Prepared the shell script to verify data.
• Executed test scripts developed in Quality Center to perform functional testing on the securities business reporting application
• Performed the Back-End integration testing to ensure data consistency on front-end by writing and executing SQL queries on the Oracle database
• Built SQL queries to get data from both source and destination and to compare them in the test bed
• Read and understand the Log files to verify the processes for debugging.
• Prepared and Executed the Test cases
• Data warehouse testing for various FACTS & dimension tables
• Verified the transfer of the data from source tables to target tables based on direct mapping and lookup tables, as part of data migration testing
• Verified the mappings based on incremental Load and Non Incremental Load
• NWCS-Web application testing for each Release
• Bug Tracking and Reporting, Verified fixes
• Designed and developed number of test plans based on high-level and detailed level designs documents
• Analyzed the use cases given by the business analysts and developed test cases using them
• Involved in developing detailed test plan, test cases and test scripts using Test Director for Functional, Security and Regression Testing
• Worked with the team lead to coordinate the test case turnover process, proceeding each cycle and selectively executed the test.
• Performed black box/functional testing, regression testing on Application Under Test
• Parameterizes test cases for use with varied, controlled test input values (runtime-generated, user-defined, or from data sources)
• Used TOAD, SQL developer software for querying the Oracle databases
• Did testing on multiple Informatica mapping for data validation and data conditioning
• Experienced using database query tools for Oracle, SQL and UNIX such as TOAD, Teradata SQL Assistant and SQL Plus

Environment: Oracle 9i, Toad8.0, Informatica 7.2, DB2, Mercury Quality center 8.2, SQL, PL/SQL, Cognos Reportnet

Confidential, New York City, NY

SQL DB Tester

Responsibilities:

• Analyzed Business Requirement and Technical Requirements documents
• Used UNIX commands and utilities to monitor server side activities and performance
• Identify the source tables from which the Data Warehouse extracts data
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan
• Reported accurate testing status and created test summary reports
• Managed user accounts and security using Business Objects Supervisor
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used TOAD, SQL developer software for querying the Oracle databases
• Test Plan Execution, Defect Reporting and Test status reporting to Project manager
• Involved in Cognos testing for each reports
• Attended QA Walkthroughs, Defect meeting and Test Plan Reviews
• Involved in holding QA meeting with Siebel, CMR and MFI development teams
• Worked with the DBA’s to maintain backup and recovery plans for QA databases
• Created test case scenarios, executed test cases and maintained defects in Remedy
• Tested reports and ETL mappings from Source to Target
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application

Environment: Test Director 9.0, Oracle 8i, SQL Developer, TOAD 8.0, DB2, Datastage7.0, Cognos, Maestro Conman Schedular