Data Developer

D HAVAL PATEL

***************@*****.*** 512-***-****

Summa ry:

Over 8+ Years of experience in Software Development Life Cycle (SDLC) with in Design, Coding, Testing,

Development & Implementation of Data Warehouse/Data Mart under Unix & Windows Environments.

Extensive experience with Informatica PowerCenter 9.0.1/8.6.1. Advanced knowledge and excellent concepts in

development and design of ETL methodology for supporting data transformations and processing ETL solutions.

Experience with IDQ Data Developer and Data Analyst tool i nstallation & configuration.

Comprehensive knowledge in implementation of Data Warehousing, Data Marts, Star and Star Flake Schema

Modeling, Dimensional Modeling on OLTP and OLAP concepts using Ralph Kimball and Bill Inmon methodologies

Extensive experience in integrating data from various Heterogeneous sources like Relational database (Oracle

11g/10g, SQL Server 2008), Flat Files (Fixed Width and Delimited), XML Files and Excel files into Data

Warehouse and Data Mart.

Strong analytical and conceptual skills in database design and implementation of RDBMS concepts. Extensive

experience in Oracle Technologies in back-end oracle database design, development, testing, performance tuning,

p roduction migration, production support and maintenance activity.

Well acquainted with Performance Tuning of sources, targets, mapping and sessions to overcome the bottlenecks in

mappings

Designed and developed complex mappings, from varied t ransformation logic like Unconnected and Connected

lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.

Have created Match, and Merge rules, developed address validations etc and developed address

validations to count ries like US, and also developed reusable error handling rules using IDQ

Supports and enhances existing Informatica environment and develops new, complex ETL processes to support

additional design, development and deployment of the new Telemetric capabilities.

Experience in implementation of Slowly Changing Dimensions (Type1 and Type 2) keep t rack of historical data.

Experience in UN IX shell scripting (file validations, file downloads, workflow executions).

Communicate with business users to collect and understand requirements, socialize ideas among peers, and

document work product

Excellent communication and interpersonal skills. Demonstrated ability to quickly grasp new concepts, both

technical and business related and utilize them as needed.

Technical Skills:

Informatica Power Center 9.0.1/8.6.1

E T L Tools

Oracle 11g/10g/9i/8i, SQL server 2008, Netezza

Databases

TOAD, SQL Developer, SQL Plus, MS SQL Management Studio

R DB MS Tools

Crystal Reports, Universe

Reporting Tools

Unix shell scripting

Scripting

ERWIN 4.2/4.0/3.5.2 Control –M, Autosys, TIDAL, Secure FTP(SSH), MS Excel,

O ther Tools

Notepad++

Windows/Mac-OS/ UNIX

Operating Envi ronment

Expe rience:

V M wa re, Palo Alto, CA May 2011 – Cu r rent

Sr. E T L Developer

VMware, Inc. is an American software company that provides cloud and v irtualization software and services, the first

to successfully virtualize the x86 architecture. Founded in 1998, VMWare is based in Palo Alto, California, USA. In

2004. This is MDM project we have multiple sources like Oracle, SFDC, Trilium, Flat files. We pull data from these

sources and load it into Universal customer master (UCM).

Responsibilities:

Analyzed business requirements, performed Impact Analysis, created technical design specifications, developed

code, performed Code Deployment, and provided production support, Captured requirements from the

B usiness Analysis Team, designed Test Plan, Test Strategy, Test scenarios and executed in Development/ QA/

Performance environment.

Developed various t ransformations like Source Qualifier, Update Strategy, Lookup & Expression

t ransformation, Expressions and Sequence Generator for loading the data into target table.

Designed complex mapping logic to implement SCD1 and SCD2 dimensions.

Extract the data from relational source Oracle, f lat files and perform mappings based on company

requirements and load into Oracle tables. Used lookup transformation (Static as well as Dynamic), aggregator

t ransformations, Update Strategy, Filter and Router Transformations.

Extensivelyused Informatica functions LTRIM, RTRIM, I IF, DECODE, ISNULL, TO_DATE,

DATE_COMPARE in Transformations.

Extensively used Re-usable Objects (shortcuts) like Sources, Targets in all mappings to handle metadata

changes efficiently

Also used Used-defined Function, which declared once globally and used in various mappings.

Creating Informatica Development Standards. This document describes the general guidelines for Informatica

developers, the naming conventions to be used in the Transformations and also development and production

environment structures.

Have developed IDQ plans to standardize & de-duplicate data. Used IDE extensively during application

m igration.

Collaborate with business data stewards to monitor, investigate, correct and prevent data quality issues in

accordance with a data quality plan

Improved performance by using Explain Plan, Creating appropriate indexes,queries optimization, utilizing

t able spaces and partitioning schemes.

Extensively worked in the performance tuning for mappings and ETL procedures both at mapping and session

level. Implementing performance tuning the Informatica objects to increase the Performance of the Informatica

loads. Performed Tuning by identifying and eliminating the bottlenecks occurred for increasing the

performance, used Informatica Partitioning.

Supports and enhances existing Informatica environment and develops new, complex ETL processes to support

additional design, development and deployment of the new Telematics capabilities.

Ensure smooth t ransition of work to offshore team. Transfer ETL requirements and ensure timely completion

of deliverables with offshore.

Worked closely with database administrators and application development team(s) on the design and

i mplementation of the database.

Participated in weekly end user meetings to discuss data quality, performance issues. Ways to improve data

accuracy and new requirements, etc.

Create Mapping that Generate Parameter file and load log.

Developed shell scripts in UNIX to automate Informatica jobs in dev and QA.

Coordinate with production support group as release coordinator for IDW monthly release.

Envi ronment : I nformatica Power Center 9.0.1, Oracle 11g, Salesforce, TOAD, XML Files, Windows, Mac, Unix, SSH

C lient.

I ntuit, Mountain view, CA M ay 2010 – April 2011

Sr. E T L Developer

Intuit Inc. is a leading provider of business and financial management solutions for small and mid-sized businesses;

f inancial institutions, including banks and credit unions; consumers and accounting professionals. Project I was

working on IDW (Integrated data warehouse) maintaining projects to enhance the business decision for sales, revenue

and expense data mart. IDW provides a consolidated view of sales, revenue, expense, subscriptions, plan and forecast

data across business units. IDW teams integrate and aggregate data from multiple sources and build subject-oriented

data marts, which are then accessed for reporting purpose.

Responsibilities:

Interacting and coordinating with System architects, Business executives, analysts, Data population engineers

and developers.

Analyzing the Functional requirements and Technical requirements, preparing technical design documents,

H LD and LLD for mappings and automating the daily f low.

Syncing the data model with concurrent changes.

Used Informatica Power Center 8.6.1, to developed Mappings/Sessions/Workflows.

Designed Complex Informatica mappings with t ransformations such as Aggregator, Expression, Joiner, Filter,

Source Qualifier, Union Transformation, connected and unconnected Lookups, Update Strategy, Stored

P rocedure, Router and Normalizer to t ransform and load the data from different data sources to relational

t ables.

Implementing performance tuning the Informatica objects to increase the Performance of the Informatica

loads. Performed Tuning by identifying and eliminating the bottlenecks occurred for increasing the

performance, used Informatica Partitioning.

Performed data quality analysis to validate the input data based on the cleansing rules.

Worked on database connections, views, aggregate conditions and also wrote various PL/SQL procedures,

F unctions and Triggers. Performance tuning of SQL.

Performed unit testing on the Informatica code using the Informatica Debugger and by manually checking

t hrough Sql Queries

Actively involved in migrating the Informatica version, interacted with DBA, Middleware, Informatica

administrators and UNIX/Linux administrators to identify and analyze the impact/risk on the

upstream/downstream systems.

Envi ronment: I nformatica Power Center 8.6.1, Oracle 10g, PL/SQL, TOAD, Flat Files, Windows XP, Unix.

GAP I nc, San F rancisco, CA O ctober 2008 - April

2010

Senior ET L Developer

Gap Inc. is a leading global specialty retailer offering clothing, accessories, and personal care products for men, women,

children, and babies under the Gap, Banana Republic, Old Navy, Piperlime, and Athleta brands. In this project, we

have multiple sources like Flat files and relational database (Oracle 10g). We pull data from these sources and load it

i nto data warehouse.

Responsibilities:

Analysis in Business requirements and created design specifications and developed the code using Informatica

power center 8.6.1 and Oracle 11g.

Developed the code for customer Tables, sales Tables Using Informatica Power Center Client components.

Designed and developed complex ETL mappings making use of t ransformations like Source Qualifier, Joiner,

Update Strategy, Lookup, Sorter, Expression, Router, Filter, Aggregator and Sequence Generator

t ransformations.

Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse.

Developed t ransformation logic as per the requirement, created mappings and loaded data into respective

t argets.

Used Parameter Files defining variable values for mapping parameters and variables.

Used Informatica Functions like REPLACECHR, UPPER, DECODE, TRIM, FIRST, DECODE Functions in

T ransformation level.

Extensively worked on Unit testing for the Informatica code using SQL Queries and Debugger.

Improved performance testing in Mapping and the session level.

Coordinated with Autosys team to run Informatica jobs for loading historical data in production.

Documented Data Mappings/ Transformations as per the business requirement.

Created XML,Autosys JIL for the developed workflows.

Extensively involved in code deployment from Dev to Testing.

Envi ronment: I nformatica Power Center 8.6.1/9.0.1, Oracle 11g, TOAD, Flat Files, SAP, Windows, Unix

United Health Group, Nashville, T N Oct 2006 – September 2008

E T L Developer

United Healthcare is an operating division of UnitedHealth Group, the largest single health carrier in the United

States. I t is considered as a recognized leader in the health and well-being industry in striving for improved health

care for all Americans by creating products and services that make health care more affordable and use technology to

make the health care system easier to navigate. In my tenure at this Insurance Company, The primary role at this job

is to support Technical Services DW by maintaining and adding enhancements in insurance quote to support the Data

warehouse operations.

Responsibilities:

Worked with heterogeneous sources including relational sources and f lat files.

Worked with Data Modeler and Data Architect to understand the Architecture of Data warehouse and the

mapping Documents.

Design mappings based upon the complex business logic provided by data modeler, which includes Dimensions

and Fact Tables.

Designed complex mapping logic to implement SCD1 and SCD2 dimensions.

Extract the data from relational source Oracle, f lat files and perform mappings based on company

requirements and load into Oracle tables.

Used lookup transformation (Static as well as Dynamic), aggregator t ransformations, Update Strategy, Filter

and Router Transformations.

Extensivelyused Informatica functions LTRIM, RTRIM, I IF, DECODE, ISNULL, TO_DATE,

DATE_COMPARE in Transformations.

Extensively used Re-usable Objects (shortcuts) like Sources, Targets in all mappings to handle metadata

changes efficiently

Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse.

Ensure smooth t ransition of work to offshore team. Transfer ETL requirements and ensure timely completion

of deliverables with offshore.

Also used Used-defined Function, which declared once globally and used in various mappings.

Working extensively on Informatica Designer, workflow manager to create, sessions, workflows and monitor

t he results and validate them according to the requirement.

Used Informatica Workflow to create, schedule, monitor and send the messages in case of process failures.

Involved in Performance Tuning of sources, targets, mappings, sessions and data loads by increasing data

cache size, sequence buffer length and target based commit interval.

Tested the target data against the source system tables by writing the SQL queries and documented the

results in the excel sheet.

Participated in weekly end user meetings to discuss data quality, performance issues. Ways to improve data

accuracy and new requirements, etc

Used EXPLAIN Table plans to tune the SQL Quires

Automated the load process using UNIX shell scripts

Create Mapping that Generate Parameter file and load log.

Used Autosys to schedule the workflow.

Experience in creating reports using Business Objects.

Documenting the ETL mapping strategies and t ransformations involved in the extraction, transformation and

loading process

Interact with various business users of VCMG in order to understand concept and Business Logic.

Envi ronment: I nformatica Power Center 8.6, Oracle 10g, TOAD, Flat files, Linux, Windows XP, Autosys, Business

Objects.

I DB I Bank, Ahmedabad, I ndia Aug 2005 – Sep 2006

Oracle Developer

I DBI Bank Ltd. is a Universal Bank with its operations driven by a cutting edge core Banking IT platform. The Bank

offers personalized banking and financial solutions to its clients in the retail and corporate banking arena through its

l arge network of Branches and ATMs, spread across length and breadth of India.

Responsibilities:

Created the Interface with Visual Basic and connect Oracle Database through connection string.

Interact with various business users of VCMG in order to understand concept and Business Logic.

Involved in creation of Tables using storage parameters and clusters

Coded many generic routines (as functions), which could be called from other procedures

Created user defined Exceptions while handling exceptions

Wrote the Connection String procedure for the Database connectivity using ODBC

Wrote stored procedures, Functions and Database t riggers using PL/SQL

Take the backup of server using import/export command

Envi ronment : Oracle 9i, PL/SQL, SQL*Plus, Excel, Word, Windows2003 and Visual Basic 6.0

Contact this candidate