SUMMARY:

• Over 8 years of solid IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Experience in Confidential, Financial, Banking, Brokerage, and Securities industries
• Extensive testing ETL experience using Informatica 8.1/7.1/6.2/5.1 (Power Center/Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica
• Experience in testing and writing SQL and PL/SQL statements.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos 7.3 Series and Business Objects XI R2
• Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
• Proficient experience in different Databases like Oracle, SQL Server and DB2.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Expertise in utilizing Oracle utility tool SQL*Loader and expertise in Toad for developing Oracle applications.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Extensively worke d with all the Data warehouse testing strategies like Data Completeness, Data Transformation, Data Quality, Performance and Scalability.
• Performed Regression testing, Integration Testing and User acceptance testing.
• Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts.
• Documented Test Strategy, Test Plans and Test Final Reports.
• Experience in Performance Tuning of SQL and Stored Procedures using Explain Plan.
• Experience in all phases of Software Development life cycle.
• Good analytical and problem solving skills.
• Strong documentation skill using Microsoft Word and Excel
• Effective communication, professional attitude, strong work ethic and interpersonal skills

TECHNICAL SKILLS:

ETL Tools: Informatica 8.1/7.1/6.2/5.1 (Power Mart/Power Center) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect)

Data Modeling: Erwin 4.0/3.5, Star Schema Modeling, Snow Flake Modeling

Databases: Oracle 10g/9i/8i, MS SQL Server 2005/2000, DB2, Teradata

OLAP Tools: Cognos 8.0/7.0/6.0, Business Objects XI r2/6.x/5.x

Languages: SQL, PL/SQL, UNIX Shell Script, Visual Basic, XML

Tools: Toad, SQL* Loader, WinSQL

Operating Systems: Windows 2003/2000/NT, AIX, Sun Solaris, Linux

Testing Tools: QTP, WinRunner, LoadRunner, Quality Center 9.2, Test Director

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. ETL/ QA/ DWH Analyst

• Analyzed business and system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0
• Performed source system analysis and Data Analysis including data profiling by writing queries on the data.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity
• Developed Data Mapping documents.
• Involved in developing detailed test plan, cases and scripts using Quality Center for functional and regression testing.
• 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.
• Created test environment for staging area, loading the staging area with data from multiple sources.
• 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
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Wrote several complex SQL queries for validating Cognos Reports.
• Tested several stored procedures.
• 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.
• Validating the data passed to downstream systems.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Involved in testing data mapping and conversion in a server based data warehouse.
• Worked with business team to test the reports developed in Business Objects.
• Used Quality Center and JIRA to track and report system defects and project enhancements.
• Focused on Data Quality issues/problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Worked as liaison between support team, business and development team for resolving multiple issues during test execution and data loading.
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Validated business reporting requirements with internal and external customers.
• Conducted Defect review meetings with the Development team to discuss the defects which are reopened and defects which are newly opened.
• Conducted meetings with the Production Support Team to discuss the defects which are raised during the testing.

Environment: Informatica Power Center 9.1, (Power Center Designer, workflow manager, workflow monitor), Oracle 10g, SQL, PL/SQL, Quality Center 8.2, Business Objects XI R2, SQL Server 2005, Erwin 4.0, UNIX, Windows 2000, TOAD

Confidential, Berwyn, IL

Sr. ETL/QA/DWH Analyst

• Worked with Data Source team to understand the source data.
• Created test plan and test cases for manual and automated testing from the business requirements to match the project's initiatives.
• Tested to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify my test cases.
• Reviewed ETL Jobs and test cases before delivering to Client.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Worked on Mercury Quality Center and updated defects status with appropriate information.
• Worked on Version Control Tool for Migrating code from one environment to another environment.
• Actively involved in Review meetings and walkthroughs.
• Perform black box testing by designing and constructing test cases, test data and test execution. Experienced in writing complex SQL queries for extracting data from multiple tables.
• Review the test cases written based on the Change Request document.
• Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Experienced in writing UNIX script.
• Effectively coordinated with the development team.
• Created critical scenarios for each change request and defect request.
• Guide, train and support teammates in testing processes, procedures, analysis and quality control of data, utilizing past experience and training in Oracle, SQL, Unix and relational databases.
• Maintained Excel workbooks, such as development of pivot tables, exporting data from external SQL databases, producing reports and updating spreadsheet information.
• Created cases for settlement claims analysts by printing documents from a website that maintains information, regarding settlement claim data, compiled documents and updated settlement claim data into database system
• Deleted users from cost centers, deleted users authority to grant certain monetary amounts to certain departments, deleted certain cost centers and profit centers from database
• 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.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio

Environment: Ab Initio (GDE 1.5, Co > OP 2.15), UNIX, Shell Scripting, XML, XSD, XSLT, XML Spy, IBM AIX 5.2, SQL *Loader, Cognos 7.0 Suite, Oracle8i/9i, SQL Server 2000/2005, Erwin 3.5, Windows 2000, TOAD 7.

Confidential, Bloomfield, CT

ETL QA Tester

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Tested Full Client reports to WebI using Report conversion tool.
• Tested/found defects in universes and reports. Used Mercury Quality Centre for tracking the defects.
• Responsible for testing the reports according to client’s requirement using Business Objects 6.5.1.
• Created Short-cut joins, aliases and contexts to make the universe loops free.
• A test reporting environment was established to combine Distribution Work Management and PeopleSoft information into a consolidated place to allow combined reports to be generated.
• Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Tested various complex WebI reports with multiple data providers.
• Tested and worked on creating open document reports.
• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select for testing Business Reports with various boundary conditions.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Effectively communicate testing activities and findings in oral and written formats.
• Extensively used Informatica power center for extraction, transformation and loading process.
• 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.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio

Environment: Informatica Power Center 7.1 (Power Center Designer, Workflow Manager, Workflow Monitor), SQL *Loader, Business Objects XIR2, PL/SQL, SQL, Stored Procedures, IBM AIX 5.1, Unix Shell Scripting, Test Cases, Test Scripts, Test Plan, Oracle8i/9i, SQL Server 2000/2005, Erwin 3.5/4.1, Windows 2000, TOAD 7.

Confidential, Urbandale, IA

ETL QA Tester

• Collecting the requirement from Users.
• Developed JavaScript files for front-end validations.
• Developed start-up Servlets using WebLogic.
• Developed Servlets for generating reports, displaying the assets hierarchy.
• Developed pages using JSP for posting user transaction forms and validating user inputs for doing accepting online transactions.
• Developed Session Beans for user profile screen.
• Developed Entity and Session Beans for business functionality.
• Designed the database using Oracle 7.4.3.
• Created and registered the Servlets and database connection pool.
• Developed HTML pages.
• Resolved any SQL query issues. Escalated and tracked unresolved issues.
• Recommended SQL queries for standard and custom reports. Documented SQL statement and created report specifications.
• Involved in testing, implementation & maintenance.

Environment: Java, JDBC, JSP, Servlets, Java Script, WebLogic 5.0.1, Oracle7.4.3, Red Had Linux.