SUMMARY:

• Over 7 years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Experience in Data Analysis, Data Validation, Data modeling, Data Cleansing, Data Verification and identifying data mismatch.
• Tested Cognos reports to check whether they are generated as per the company standards
• Solid Back End Testing experience by writing and executing SQL Queries.
• Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Informatica.
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP, RAD and SDLC methodology environments
• Extensive working experience in RDBMS technologies like Oracle … DB2 … MS SQL Server … Dbase, Excel and MYSQL. SQL Developer, TOAD, SQL Plus, Win SQL, Quest Central for DB2. Good at working with SQL Assistant 7.1 in Teradata environment.
• Experience in UNIX shell scripting and configuring cron - jobs for ETL Loads.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Data Stage.
• Expertise in Testing Complex Business rules by creating mapping and various transformations.
• Experienced in working with HP Quality Center 10.0, Rational Clear Quest & Test Director.
• Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries to perform back-end testing.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience with Agile Methodology.
• Experienced in running SQL queries using Toad and SQL Server.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Extensive experience in manual testing the ETL and Business Intelligence Applications.
• Strong working experience on data warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Developing and Delivering System Documentation and Training; Testing and Auditing
• Excellent problem solving, interpersonal, and communication skills.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Extensive experience in manual testing the ETL and Business Intelligence Applications.

WORK EXPERIENCE:

Confidential, Omaha, NE

ETL Data Warehouse Tester

Responsibilities:

• Involve in Business analysis and requirements gathering.
• Responsible for testing packages using SSIS to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Created the Regression Test cases and automated them for the purpose of regression testing using QTP.
• Worked in an Agile technology with Scrum. Conduct QA scrum call to gather status of the offshore team. Communicate or KT the project details as and when needed. Provide QA testing timelines understanding the project requirement and scope of testing.
• Develop Validation plan and Quality summary report for the project
• Draft test plans based on test strategy. Reviewed, created and executed test cases and test scripts based on test strategy and test plans based on Product Requirement Document.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Reviewing the project and coordinating with onsite Clients, onsite Project Leads and local reporting Managers.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings
• Effectively communicate testing activities and findings in oral and written formats.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Involved in Performance testing to ensure the load and stress capability of the application. Validated documented user requirements.

Environment: Informatica 8.6.1/8.1, MS SQL Server 2005/2008, QTP, Oracle 10g, PL/SQL, TOAD 8.0, SQL, Linux, Agile, Remedy, Test Director/Quality Center, Power Connect, PowerAnalyzer4.1, Cognos, WEBLOAD

ETL QA Tester

Responsibilities:

• Developed a detailed Test Plan, Test strategy, Test Data Management Plan, Test Summary Report based on Business requirements specifications.
• Provided support to sales team management and sales operations support groups in the receipt, warehousing and reporting account level sales information.
• Extremely involved in using Test Director for identifying the bugs with the help of SQL queries.
• Involved in understanding the Requirements of the end Users/Business Analysts and Developed Strategies for ETL processes.
• Responsible for Mini specifications document that describe the functionality of each subject area.
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning
• Reported software mismatches (from the test planning), to the development team using Quality Center
• Implemented Database Checkpoints for Back-end Testing
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Managed and executed the test process, using Agile Methodology
• Analyzed the Data Dictionary developed by the Systems Analyst for developing test scripts to test the Policy and Claims systems.

Environment: Informatica 8.1.1, Business Objects Xi R2, Windows XP, Oracle10G, Sybase, IBM DB2, TOAD for Oracle, UNIX, MS SQL Server 2008, Reflections, Agile, Quality Center.

ETL Data Warehouse Tester

Responsibilities:

• Developed and Designed Test Cases based on the Business requirements.
• Written several complex SQL queries for validating Cognos Reports.
• Extensively tested the reports generated in Cognos by writing SQL queries to validate the data on the report and compare with the TPW data.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports
• Used SQL for Querying the database in Linux environment for testing the business rules imposed on data movement with Informatica ETL tool.
• Used the ETL processes of Informatica tool to load data from MS SQL Server and Oracle, into the target Oracle database.
• Attended walkthrough meetings with the Business Analysts and development to get a clear understanding of the business and the applications being used in house.
• Prepared Traceability Matrices to track the requirements with the test cases and make sure none of them have been missed.
• Developed automation test scripts to test the database by retrieving the data from the tables using HP QTP 10 and VB Scripting.
• Validated that design meets requirements and function according to technical and functional specifications.
• Used HP Quality Center 9.2 to state requirements, business components, test cases, and test runs for every iteration, defects. Also link defects with requirements.
• Involved in recording change requests on the Change Request Form (Remedy) Participated in meetings.
• Performed all aspects of verification and validation

Environment: Cognos 8.x, Informatica 8.1/ 7.1.4 (Power Center Designer, workflow manager, workflow monitor), MS SQL Server 2008, Oracle 10g, PL/SQL, TOAD 8.0, QTP, SQL, Linux, Netezza, Maestro 8.0 (Tivoli Work Scheduler), Charm, Agile, Remedy, Test Director/Quality Center, Power Connect, PowerAnalyzer4.1

QA Test Engineer

Responsibilities:

• Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC)
• Reported periodic project status and updates to the QA Lead and QA Manager
• Performed Integration Testing of different modules.
• Heavily involved in interacting with UNIX Shell scripts.
• Analyzed Business Requirements and Developed the Test Plan, Test Scripts and Test Cases Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Identified the Test Cases to be automated and lead the effort for automating the product.
• Used Test Director to organize the Win Runner Scripts and schedule test execution.
• Used Test Director for Bug Reports and Defect Tracking.
• Tested User Interface inconsistency and application functionality.
• Developed test scenarios for testing Enterprise Data warehouse and Credit Data Mart data in DB2 environment.
• Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
• Developed Reports and Graphs to present the results to the management.
• Preparation of test data for various levels of testing
• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
• Load new or modified data into back-end Oracle database.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center

Environment: Informatica Power Center 7.1 (Power Center Designer, workflow manager, workflow monitor), OBIEE, Oracle 9i, Agile, HP Quality Center, TOAD 7, SQL *Loader, SQL Server 2000, QC, Test Director, Erwin 3.5, Windows 2000 .