PROFESSIONAL SUMMARY:

• 7 years of extensive experience as a Manual QA Engineer involving in the entire SDLC and working with DWH/BI applications for various industries Data Modeling, Data Extraction, Data Loading and Data Analysis.
• Extensive experience in ETL and BI testing of DWH applications and reporting applications.
• Proficient in writing Test Strategies, Test Plans, Test Cases, Test Scripts and Test Scenarios
• Experienced in testing requirements that were developed in ETL and BI of DWH applications and reviewed scripts for positive and negative test scenarios, and prepared test summary.
• Possess extensive experience performing Backend, Frontend, Regression, Functional, System, Interface, Usability, Black box, Integration and User Acceptance Testing.
• Extensive Experience in Agile Methodology and waterfall methodologies of SDLC.
• Well experienced in writing complex SQL queries for extracting data from multiple sources.
• Technical strengths and automated test tool expertise includes Quick Test Professional (QTP), Quality Center, VBScript, SQL and Rational Tool Suite
• Excellent experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Proficient in HP s Quality Center for Test Designing, Requirement Mapping, Reports and Defect Tracking
• Extensive experience working with Data warehouse ETL tools like Data Stage, Informatica, AbInitio, SSIS, and AutoSys tools.
• Experience in testing and writing SQL and PL/SQL statements.
• Good experience in Business Objects, Cognos, Micro strategy and Crystal Reports testing
• Hands on experience in writing SQL queries, Joins, Functions, Procedures, Packages, DBMS, RDBMS, and Triggers in Oracle and SQL Server databases.
• Created requirements from Test plans, FRD, Use cases and updated those is Requisite pro and then in Clear Quest (CQ), Quality Center (QC) and Application Life Management (ALM).
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema and working with slowly changing dimensions Type I II and III.
• Ability to work independently or in a team environment or in a rapid pace environment.
• Possess strong interpersonal skills, communication and presentation skills with theability to interact with people at all levels.

TECHNICAL SKILLS:

Testing Tools: Quick Test Pro (QTP) 9.5/9.2/8.0, Test Director, HP Quality Center 10/9.2/8.2

DWH ETL Tools: InformaticaPowerCenter 8.6.1/8.1,7.x, Data Stage 8.1, Ab Initio (GDE 1.15, Co>Op 2.15)

BI Tools: Business Objects, Cognos, Crystal Reports, SSRS

IBM Rational Suite: Rational Functional Tester 8.0/7.0, Rational Clear Quest, Clear Case

Scripting languages: VB Script, HTML, Shell Scripting

Operating Systems: Windows XP/NT/2000/Vista/7, DOS, UNIX

Databases: Oracle 10g/9i, MS SQL Server, IBM DB2, Sybase and Netezza

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburg, PA

ETL QA Tester

Responsibilities:

• Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases
• Conducted Smoke testing, Functional testing, Regression testing, Integration testing, and User Acceptance Testing (UAT) and Data validation testing.
• Used Agile testing methodology for achieving deadlines in UAT.
• Executed and managed test cases and reported bugs in Quality Center.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company
• Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
• Hands on work experience working with offsite team model; coordinate my own efforts with team members in the off - site team
• Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company
• Maintain, backup and restore the Informatics ETL repositories for the QA team.
• Used Joins like Inner join; Outer joins while testing from multiple tables.
• Tested Informatics folders, global sources, global targets, global ODBX connections, global FTP connections workflows, data profiling and manage metadata.
• Tested data models and data maps (extract, transform and load analysis - ETL analysis) of the data marts and feeder systems in the aggregation effort.
• Good knowledge on Data Ware house concepts.
• Good knowledge on Testing Life Cycle, Bug/Defect life cycle, Defect tracking and management.
• Verifying the data in target database by ETL process
• Verified column mapping between source and target

Environment: Informatica 8.6.1/8.1, Business Objects, Oracle 10g/11g, EDI, XML, XSLT, QTP, XPath, XQuery, Rational Clear Quest, Rational RequisitePro, Quality Center 10.0, DTS,, TOAD, SSIS, MS SQL server, PL/SQL, UNIX, PERL, MS Access, Sybase, SQL Server.

Confidential, Peoria, IL

Sr. ETL QA Tester/Backend Tester

Responsibilities:

• Designed and executed various well described Test scripts for System testing based on the Functional Design Document.
• Assisted in gathering the business requirements, Data warehouse ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• Estimated UAT effort for individual change item and ensured schedule commitments met.
• Developed ETL test cases for various lines of businesses based on ETL mapping document.
• Backend Database 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.
• Investigating issues occurred while System testing and Regression testing.
• Involved in validating SSIS and SSRS packages according to functional requirements.
• Involved in investigating the errors by tracking the root cause for the error.
• Collected evidence for each step of the process to ensure that any errors are captured in time and resolved immediately.
• Extensively used DWH ETL for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI
• Have programming skills in SQL and PL/SQL and experience in Oracle databases on UNIX and Windows platforms.
• Worked on the EDI claims including both the batch processing and direct data entry.
• Written and executed the functional and regression test script using Test Script QTP.
• Wrote SQL and PL/SQL scripts to validate the database systems and for backend database.
• Raised defects in HP Quality Center defect tracking system. Log project related issues in the defect tracking tool identified for the project (Rational Clear Quest)
• Designed Traceability Matrix to match test scripts with the Functional design document.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Experience in testing Business Report developed in Business Objects XIR2
• Developed User-Acceptance Test cases and assisted users in conducting UAT.
• Worked with ETL group for understating mappings for dimensions and facts.
• Worked on issues with migration from development to testing.

Environment: DWH ETL Informatica 8.6.1/8.1, Business Objects, Oracle 10g/11g, EDI, XML, XSLT, QTP, XPath, XQuery, Rational Clear Quest, Rational RequisitePro, Quality Center 10.0, DTS,, TOAD, SSIS, MS SQL server, PL/SQL, UNIX, PERL, MS Access, Sybase, Netezza Flat Files.

Confidential, Madison, WI

ETL QA Tester/BI Tester

Responsibilities:

• Extensively involved in Business Analysis and Requirements Gathering
• Analyzed business requirements and interfaced with vendors for development and enhancement of a system to support multiple business areas including Asset Management, portfolio management and risk management.
• Developed SQL scripts to validate the data loaded into Data warehouse and Data Mart tables using ETL Informatica.
• Performed Regression, UAT and Database testing. Performed data validation-using SQL.
• Involved in analyzing the requests for new, enhanced, and modified systems, against user and business requirements.
• Conducted discussions and facilitate requirements gathering, process analysis, and application design sessions with company staff across all levels and functions
• Responsible for validating the files availability, format and data on UNIX server
• Executed SQL queries to verify the flow of data between back end and front end.
• Coordinated system walk through,, User Acceptance Testing (UAT) and facilitate issue resolution
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD/Exceed.
• Strong hands-on experience in maintaining and using IBM Rational Clear Quest for Defect reporting, tracking & Change Management.
• Written cases to test application manually in Quality Center and automated using QTP
• Performed Data warehouse ETL testing and extensively used SQL functionalities. Used TOAD to connect to Oracle Database.
• Develop EDI mapping and scripts using proprietary tools. Support multiple in-house EDI systems. Create ad-hoc queries for data quality issues. Performed Data Driven Testing of the Application for different users/data sets
• Conducted Functional testing to ensure that the application meets the requirements and to ensure usability readiness
• Involved in creation of defect analysis report for system Test and UAT.
• Experience in creating UNIX scripts for file transfer and file manipulation.

Environment: DWH ETL Informatica Power Center 8.1, SQL, PL/SQL,, Sybase, UNIX, EDI, Toad, Test Director V7.6, SSIS, Windows NT, Sun Solaris, MS SQL server, Rational Functional Tester, QTP, Rational Clear Quest, Rational RequisitePro, Oracle 9i, Crystal Reports and Netezza.

Confidential, Nashville, TN

ETL QA 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, Data warehouse ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• Wrote Complex SQL queries to support the test case results.
• Involved in user sessions and assisting in UAT (User Acceptance Testing).
• Assisted in promotion of Informatica code and UNIX Shell scripts from UAT to Production.
• Tested Complex DWH 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
• Created Data warehouse ETL test data for all ETL mapping rules to test the functionality of the SSIS packages.
• Scheduled and managed QA/UAT execution activities and defined, wrote and prepared QA/UAT Test Strategy, Test Plan and Test Scripts.
• 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 Informatica Mapping
• Proficiency in using Rational Clear Case for Documentation and used Clear Quest for Defect tracking.
• Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
• Written several complex SQL queries for validating Business Object Reports.
• 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
• Experience in creating UNIX scripts for file transfer and file manipulation.
• 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: DWH ETL Informatica 7.1, MVS, UNIX, Oracle, SQL Server 2005, Rational Functional Tester, Rational Clear Quest, Rational RequisitePro DB2, Quality Center, Windows 2000 Pro,, Sybase, XML, XSLT, XSD, Rapid SQL, PL/SQL, TOAD, XML Files, SSIS.

Confidential, NY

ETL QA Tester

Responsibilities:

• Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging defects.
• Involved in development and implementation of test cases test plans test data and test scripts for customers.
• Involved in testing the data warehouse for both the initial load and the incremental loads of the target
• Involved in various kinds of testing like functional testing, system testing and integration testing.
• Constructed context diagrams and data-flow diagrams based on the description of a business process. Analyzed the data model to code efficiently in SQL.
• Worked on generating reports using SQL and PL/SQL. Worked on tuning SQL statements.
• Involved in preparing detailed Business Analysis documents, ETL design documents, unit test plans for the mappings
• Defined and executed test cases across a number of internally developed Front and Middle office applications through Clear Quest.
• Involved in complete life cycle activities like pre-testing phase and testing phase.
• Analyzed system requirements specifications, developed executed detailed test plans test cases, security and usability of application information.
• Created Test Procedures and Test Cases to perform the system testing and Regression testing.
• Attended bug review and client meetings.

Environment: DWH ETL Informatica power mart 5.1, Toad, Test Director, SSIS, Visual Basic 6.0, Rational Functional Tester, Rational Clear Quest, Rational RequisitePro Oracle 8i, Windows 2000, UNIX.