Data Project

Professional Summary:

. * plus years of progressive experience in design, development and

maintaining Data Warehouses and Data Marts using Informatica

8.6/8.5/7.1.3, Netezza, Teradata, IBM DB2, Oracle.

. Exposed to various domains of Data warehouses like Insurance,

Financial, Banking, Retail etc.

. Extensively worked on Data Extraction, Transformation and Loading

(ETL) from disparate Data sources like Netezza, Teradata, Oracle,

DB2, Sybase, Mainframe, XML, Flat files, Web-services provider

using Informatica PowerCenter.

. Sound understanding of Data warehousing concepts and Dimensional

modeling (Star schema and Snowflake schema). Experience in using

ERWIN Data Modeling tool 4.1.2.

. Strong understanding of Software Development Life Cycle (SDLC).

. Experience in writing UNIX shell scripts for automation of ETL

process and Data transfer tasks.

. Experience in Performance Tuning of sources, targets, sessions and

existing mappings, identifying and resolving performance

bottlenecks at various stages.

. Excellent experience of development, testing, debugging,

implementation, documentation and production support.

. Handled critical job failures in the production environment and

Involved in fixing the data issues in the EDW database.

. Excellent communication and interpersonal skills. Ability to work

effectively in supervisory and non-supervisory environments as a

team member as well as an individual.

. Strong project management skills including Planning, Problem

Solving and Decision Making abilities.

Technical Skills:

ETL Tools: Informatica PowerCenter 8.6.1 Real-

time/8.5/7.x/6.x.

Databases: Netezza, Teradata, IBM DB2, Oracle 10g, SQL

Server 2005, Sybase.

Scheduling Tools: IBM Maestro (Tivoli Workload Scheduler),

Autotsys, Crontab

Modeling Tools: Erwin 4.1.2, Rational Rose

Reporting Tools: Business Objects 5.x, Seibel Analytics

RDBMS Tools: Embarcadero Rapid SQL 7.5.1, TOAD 8.x, SQL*Loader

(Oracle).

Languages: SQL, PL/SQL, Java, C, C++, Perl, VS.NET, web-

services.

O/S: Windows 95/98/00/NT/XP, DOS, UNIX.

Packages: MS Office (MS Access, MS Excel, MS Visio, MS Word),

Visual Studio 6.0.

Education/Certifications:

. MS in software Engineering, Southern Polytechnic State

University, Marietta, GA

. BE in Mechanical engineering, from South Gujarat University,

India

. Informatica Certified in Mapping Design

. Informatica Certified in Advanced Mapping Design

. Informatica Certified in Architecture and Administration

. Oracle Certified in Exam# 1Z0-007 Introduction to Oracle 9i: SQL

Professional Experience:

MassMutual Financial Group, Springfield, MA

11/24/2008 - current

Systems Specialist

Retirement Services

Projects:

1. Electronic Data Feeds (EDF):

The strategic purpose of the Electronic Data Feeds (EDF) project

was to provide reporting and data feeds to MassMutual's strategic

distribution channels by sending file feeds from the RS Information

Factory to Distribution Firms, like Morgan Stanley and UBS which

includes financial and distribution data for all contracts and plan

types associated with the firm. These files were sent either daily

or once a month based on the customer's request. Moving the source

data into the data warehouse also made distribution data available

to the Siebel Customer Data Mart (CDM) for reporting and analysis.

Responsibilities:

. Involved with the Business analysts in requirements gathering,

business analysis and project coordination.

. Analyze the source systems data and the current files at the

client side to gather the requirements for the Data Warehouse Data

Model.

. Worked with data architect team and developed requirements specs

and also created technical specs documents for all the mappings.

. Developed Source to Target Mappings using Informatica PowerCenter

8.5 Designer to load data from various source systems like DB2 and

Flat files to staging and ODS tables.

. Extensively used various Informatica transformations such as SQL,

Source Qualifier, Aggregator, Expression, Lookup, Router, Filter,

Update Strategy and Joiner transformations etc.

. Created reusable transformations and Mapplets and used them to

reduce the development time and complexity of mappings and better

maintenance.

. Extensively used the Informatica Debugger for debugging the

mappings associated with failed sessions.

. Involved in Unit testing, Integration testing, and code reviews.

. Created design documents to Schedule the workflows and batches

using Maestro and worked extensively with Production Support team.

. Used labels, queries and static/dynamic deployment groups to

migrate code from source repository to target repository for

Monthly Production and QA builds.

. Involved in fixing production defects by modifying existing

Mappings.

2. Pyxis Mobile:

Lead Informatica Developer

The purpose of the Pyxis project was to provide a mobile solution

for accessing data to the Retirement Services Sales

Representatives. Through a Blackberry device they would be able to

access a portion of the Siebel CRM application, as well as view

reports about that data created from the Siebel Analytics data

mart. Data was extracted from the Siebel CRM and the Seibel

Analytics databases using Informatica, and loaded to a staging area

on a SQL server database. From there the data was loaded to the

Pyxis database, which would be accessible via Blackberry devices.

Responsibilities:

. Actively involved in overall project planning and resource

management.

. Helped in the DW development, provided High level supervision

for other team members.

. Developed Source to Target mappings using Informatica

PowerCenter 7.1.3 Designer to transform data from Siebel CRM and

Seibel Analytics databases table views to Flat file and ftp'd

using UNIX Korn Shell scripts to Windows Server source file

system for downstream processing.

. Developed Mappings and workflows using Informatica PowerCenter

7.1.3 running on Windows Server to move data from Flat Files to

SQL Server database.

. Created Maestro design document to schedule workflows on both

AIX and Windows Server.

. Provide support to analyze the data and define the issues when

found.

3. Statement Architecture customer data mart (CSM)

Tech Lead

The scope of Statement Architecture project is to create quarterly

participant benefit statements for 1.5 million active defined

contribution (DC) participants. The project involved integration

between different technologies such as SIEBEL, WebMethods, ASL,

.NET, UNIX and Informatica. Informatica portion of the project

involved creation of participant benefit statements in XML format

in real time which will be transmitted to external vendors who will

convert them into individual PDF files.

. Worked on Informatica Real- Time edition - web services

component to multi-thread the workflow to meet strict service

layer agreement (SLA).

. Developed complex mapping having numerous transformation

including web-service provider sources and xml targets.

. Used various mapplets and user-defined functions (UDFs) to

increase readability, reusability and maintainability of the

code.

. Used workflow variables to dynamically capture source xml file

names and dynamically populate target file names.

. Coordinated with offshore Infosys resources.

. Trained in-house SQL developer for Informatica PowerCenter

platform.

. Trained in-house Informatica developer for Real Time

development.

. Extensively used SQL transformation to support real time

implementation.

. Developed mappings used to populate multi terabyte CSM data

mart.

. Extensively tuned maps involving multi-billion records.

. Tuned SQL queries for both source qualifier and lookup override

to better use of indexes and joins.

. Expert in using Quality Center for tracking defects.

Environments: Informatica PowerCenter 8.6 Real-time Edition, DB2, MS

SQL Server 2005, Sybase, UNIX, Windows, Quality Center, SOAP UI,

Embarcadero Rapid SQL 7.5.1, Maestro.

SoftPath Systems LLC, Atlanta GA

3/1/2007 - 11/23/2008

Sr. ETL Consultant

Clients: MassMutual Financial Group, RH Donnelley, Scotia Bank

RH Donnelley is the nation's largest yellow pages publisher. The

current Sales DW provided the foundation for an overall

infrastructure and knowledge base. The existing solution solved the

immediate sales reporting requirements for the end user, but has

been recognized that a more robust infrastructure will be needed in

the future. The main goal of modernization is to have a robust,

complete sales reporting platform.

Responsibilities:

. Involved in analysis, gathering requirements and documenting

functional and technical specifications. Involved in preparing

detailed ETL design documents, unit test plans for the mappings.

. Developed transformation logic and designed various complex

mappings and mapplets using the PowerCenter Designer 7.1.1.

. Extensively used various Informatica transformation such as SQL,

lookup, aggregator, joiner, source qualifier, update strategy,

sorter, router, expression, sequence generator, rank, stored

procedure while transforming data as per business requirements.

. Actively involved in migrating Informatica repository from 6.2 to

7.1.1

. Extensively used SQL and PL/SQL Scripts and worked in both UNIX and

Windows Environments.

. Worked on different data sources such as Oracle, Flat files, MS SQL

Server etc.

. Created reusable transformations and mapplets and used them in

mappings.

. Used Informatica PowerCenter Workflow manager to create sessions,

workflows to run with the logic embedded in the mappings.

. Configured and ran the Debugger from within the Mapping Designer to

troubleshoot the mapping before the normal run of the workflow.

. Wrote shell scripts to perform pre-session and post-session

operations.

. Fine tuned Transformations and mappings for better performance.

. Provided Production support by Run schedule jobs, diagnose session

problems, fix mappings for minor business changes etc.

Environment: Informatica PowerCenter 6.2/7.1.1, UNIX, TOAD 7.6,

Oracle 8i, SQL, PL/SQL, Windows NT.

BMS InfoTech, India April 2004 -

Jan 2005

Informatica Developer

BMS InfoTech is a leading global IT solutions provider based in India.

The project involved populating an existing Sales DataMart, based on

specific business rules.

Responsibilities:

. Created database objects like tables, views, synonyms, indexes and

sequences.

. Created Database Triggers, Stored Procedure, Functions and

Packages.

. Developed transformation logic as per provided business rules and

designed various simple and complex mappings.

. Created Mappings using various transformations like Update

Strategy, Lookup, Stored Procedure, Router, Filter, Sequence

Generator, Joiner, Aggregate and Expression.

. Used SQL Loader to load the data.

. Fine tuned the mappings to improve performance and tested for

anomalies using the debugger.

. Created Sessions and used pmcmd command line to start/stop/schedule

Workflows.

Environment: Oracle 8.x, PL/SQL, Informatica 6.2, SQL Loader, Windows

2000

Vensoft, India August 2003 - Feb

2004

Oracle Developer -Part time

The project was to automate the payroll of a company, AVR Chemicals

Pvt. Ltd., which had around 1100 employees. The scope of the system

covered all calculations regarding wages, leaves, earnings and

deductions like HRA, DA, ESI, PF, and PT etc.

Responsibilities:

. Initial system study and design using ERwin.

. Preparation of Entity Relationship diagrams

. Table design and creation.

. Normalization of database to remove data redundancy.

. Development of database tables, relationships and PL/SQL

procedures.

Environment: Oracle 8.0, ERwin 3.x, PL/SQL, Windows NT

Contact this candidate