Hiral Patel
Contact: 817-938-8151.
E-mail: hitudev@yahoo.com


Summary:

v Over five years of overall IT experience in Design, Analysis, Application Development, Implementation and Maintenance in Client/Server architecture, Informatica Power Center, Windows NT, Oracle 8.0/8i/9i.
v Developed and supported Extraction, Transformation and Load process (ETL) using Informatica Power Center to populate the tables in Data warehouse and Data marts.
v Developed Slowly Changing Dimension Mappings
v Extensively worked on Data Analysis, Design, Development, Implementation and Testing of ETL mappings.
v Worked on Informatica tools - Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
v Extensively used ETL to load data from flat files to ORACLE.
v Extracted and transferred source data from different database like Oracle, SQL SREVER and flat file into Oracle.
v Programming Knowledge using SQL, PL/SQL and Java.
v Developing mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup – Connected & Unconnected, Sequence Generator, Filter, Sorter and Source Qualifier.
v Developed Unit Test Case Document.
v Using Debugger to troubleshoot the mappings
v Developed several reusable transformations and mapplets.


Technical Skills:

Operating Systems Windows 2000 Pro,Windows XP Pro, Unix
Languages C, C++, Java
RDBMS / Database Oracle 8.0/8i/9i, MySQL, MS-Access.
4GL Tools PL/SQL
ETL Tool Informatica Power center 6.1

Education: Bachelors of Commerce.


Professional Experience
Great West Insurance Dec 05 – Nov 06
Project : FINPRO
Role : Informatica Developer
Great West Insurance Company serves more than 3.6 million Americans through a full range of managed healthcare, life and disability insurance, and retirement savings products and services. This system gives full information regarding benefits, plans offered by the company, educate people about diseases, prevention, ICD codes, HIPPA act and users can enroll and can avail the benefits offered. This project includes developing Data warehouse from different data feeds and other operational data sources. This application is specifically designed for Financial and Productions department. It helps these departments to frequently evaluate their strategies regarding Production and Finance.
Build a central Database where data comes from different sources like oracle, SQL server. Actively involved as an Analyst for preparing design documents and interacted with the data modelers to understand the data model and design the ETL logic.

Responsibilities:
· Creating new mappings and updating old mappings according to changes in Business logic
· Performing major role in understanding the business requirements and designing and loading data into data warehouse (ETL).
· Using ETL (Informatica) to load data from source to ODS.
· Using Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and code the process of data flow from source system to data warehouse.
· Implementing Slowly Changing Dimensions – Type I & II in different mappings as per the requirements.
· Using Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status
· Using Debugger to troubleshoot the mappings
· Creating Workflows, Worklets using Workflow Manager.
· Developing mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier
· Preparing Unit Test Cases.

Environment: Windows 2000, Oracle 9i, PL/SQL and Informatica Power Center 6.2


Exsifww, NY Feb 2005– Nov 2005

Project : TLS
Role : Informatica Developer
Project was on a Tank leasing system (TLS) development project. Data Warehouse built involves source data from different locations and provides complete analytic solution for the users in effective decision-making analysis using Business objects. This Data warehouse is aimed at delivering mission critical reports such as Accounting, Billing Extract, Contracts, Management and Repair (M&R), Sales, and Tracking reports using Business Objects.

Responsibilities:
· Extensively used ETL (Informatica) for loading data from source to ODS.
· Extensively used Informatica client tools like Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and code the process of data flow from source system to data warehouse.
· Implementing Slowly Changing Dimensions in different mappings as per the requirements.
· Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status Task View.
· Used most of the transformations such as Source Qualifier, Aggregator, Connected & Unconnected Lookups, Filters, Sorter, Router & Sequence Generator in the mapping.
· Used Debugger to troubleshoot the mappings.
· Preparing Unit Test Plans.

Environment: UNIX, WinNT/2000.Oracle 9i, PL/SQL and Informatica Power Center 6.1 (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager, Workflow Monitor, Worklets).





GMAC Mortgage - Cherry Hill, NJ April 2003–Jan 2005

Project : Warehouse Bank
Role : J2EE Developer
GMAC Mortgage is an indirect wholly owned subsidiary of General Motors Acceptance Corporation (GMAC), one of the largest financial companies in the world. GMAC Mortgage provides Home related Services. Warehouse Bank is an online B2B application, which allows its customers/ mortgage brokers to create funding requests and process them. This application has two modules. The first module in the applicati