SUMMARY:

• 7 years of IT experience in Design, Analysis, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Specialized in Coordination between teams and projects, Quality Assurance and testing, worked as ETL Tester, BI Tester and QA Analyst.
• Experienced in all phases of Software development life cycle (SDLC).
• Experience in using Test management tools like Quick Test Professional, Win Runner, Load Runner and HP Quality Center in Client/Server applications.
• Solid experience in RDBMS technologies like Oracle, DB2, MS SQL Server, Excel and MYSQL, TOAD, SQL Plus, Win SQL, Quest Central for DB2.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Experience in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing in a corporate - wide-ETL Solution using Informatica.
• Extensive knowledge and experience in producing tables, reports, graphs and listings using various SAS procedures and handling large databases to perform complex data manipulations.
• Experience in testing XML files and validating the data loaded to staging tables.
• Experience in testing and writing SQL and PL/SQL statements.
• Experienced in different Databases like Oracle, DB2, Teradata and Sybase.
• Experienced in Black Box, and White Box Testing of Database and Web applications.
• Good expertise in using TOAD, SQL Plus and SQL Advantage, SQL Assistant in Teradata environment.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Professional Experience in Financial, Banking, HealthCare applications and strong understanding of Mortgage lending applications.
• Collaborator that thrives in a social atmosphere and actively

PROFESSIONAL EXPERIENCE:

Confidential

Project Coordinator/ ETL Tester

Responsibilities:

• Created and executed test cases based on test strategy and test plans based on ETL Mapping document. Created test data at design level based on ETL mapping document for both positive and negative scenarios. Working with internal customers to identify requirements for ETL processes. Identify potential problems, omissions and open issues and attend walkthroughs and attend signoff meetings. Tested ETL SCD type 1 and Type 2 scenarios which load into Teradata Fact tables and validate the data loads. Involved in test planning, writing test cases/scripts, test case automation and test execution. Used Quality
• Centre as the test management tool for the maintenance of the test cases and to track the defects. Tested ad hoc and canned reports for Business objects Tune SQL queries and database performance for OLTP and DSS applications within the development environment. Uploaded from excel spread sheets in
• Quality Center, run these scripts through QC for validation. Developed and executed formal test plans to ensure the delivery of quality software applications. Debugging the SQL - Statements and valid scenarios comparing the STMs for various business strategies. Extensively written test scripts for back-end
• Validations. Extraction of test data from tables and loading of data into SQL tables. Tested the messages published by ETL tool and data loaded into various databases. Testing of records with logical delete using flags. Involved in Manual and Automated testing using QTP/UFT and Quality Center. Experience in testing many multi-layer data warehouse on Unix, Windows and Teradata systems Writing Sub Queries, Correlated Sub Queries to retrieve data from multiple tables and used indexes efficiently. Wrote numerous Pre and Post session SQL and Unix Scripts.

Environment: Oracle, Informatica Power Center, HP Quality Center, Teradata, MicroStrategy, UNIX Shell Scripting, TOAD, Transact-SQL, XML Files, SQL Server, TOAD, WinSQL

Confidential

ETL Tester

Responsibilities:

• Involved in understanding the ETL mapping document and Source to Target mappings. Execute and analyze complex test cases and compare the results with expected results and product requirements. Analyzed business requirements, system requirements, data mapping requirement specifications and responsible for documenting functional requirements/supplementary requirements in Quality Center. Defect Reporting, Analyzing, Tracking and Report Generation, using HP Quality Center.
• Tested Transformed data from various sources like Relational and Non - relational databases, Flat files, Excel and XML files in to reporting database to design most analytical reporting system. Prepared the test plans and test cases for different functionalities involved in the application. Used Quality Centre as the test management tool for the maintenance of the test cases and to track the defects. Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Performed the Smoke, Functional testing, Ad Hoc testing and Regression testing of the application. Involved in Testing Cubes for Data warehouse. Performed Regression Testing of the affected test cases to confirm that the defect has been resolved when defect corrections are delivered in a build. Tested different detail, summary reports and on demand reports. Involved in backend testing for the front end of the application using SQL Queries in SQL Server data base.
• Worked with Teradata SQL Assistant for data retrieval and data validation Optimizing/Tuning several complex SQL queries for better performance and efficiency. Tested automated SQLs as part of the ETL process and pulling the data.

Environment: SQL Server, Informatica Power Center, Teradata, HP Quality Center, SQL *Loader, Oracle, TOAD, WinSQL, SQL, XSD, XML

Confidential

ETL Tester

Responsibilities:

• Reviewing the business requirements for Data Warehouse ETL process and working with business and requirements team for gaps found during the review. Developed a detailed Test Plan, Test strategy, Test Data Management Plan, Test Summary Report based on Business requirements specifications.
• Coordinated with Different project teams to set up common test environment and common Integration for different applications. Involved in Unit testing and integration testing of Informatica mappings. Prepared a UAT Plan and set up UAT environment. Prepared Execution procedure document format to prepare the Test cases based on mapping document. Defined and ran jobs using the Autosys Graphical User Interface (GUI) and Job Information Language (JIL), monitoring and managing Autosys jobs and alarms. Ran jobs using the Autosys to load the data from Source to Target and test incremental data. Validated the Data in the Warehouse using SQL queries Validated data flow from Source through to FACT tables and Dimension tables using complex queries(left outer Joins, sub queries etc) Validated data model for landing zone, staging zone and Warehouse tables for column length and data type consistencies.
• Validated FK failures and data integrity checks for all the tables. Validated Business codes, Error process and Purge process. Extensively used UNIX shell scripts and compared the files in SAS to make sure the extracted data is correct. Worked on ETL Data Warehousing, database testing using Informatica for
• Workflow process. Conducted defect review meetings with the development team members Involved in peer review of test cases, Test Pool meetings and Impact analysis Involved in testing the applications in Target host in IBM Mainframe environment

Environment: Informatica, Oracle, HP Quality Center, TOAD for Oracle, Shell Scripting, WinSQL, SQL plus, XSD, XML