Summary

. Over *.* years of experience in IT industry as an Architect,

Technical Lead, Project Lead in Software Design, Analysis,

Coding, Development and Testing with specialization in Client

Server Computing, Data Warehousing, MDM and Decision Support

Systems using Informatica,Siperian, IDQ.

. Over 5 years of experience as a Informatica Lead.

. Extensive experience as a data warehousing expert and ETL

developer/lead using Informatica PowerCenter/Power Mart

9.1/8.6/7.1/6.2(repository manager, server manager, mapping

designer, mapplet designer, warehouse designer, transformation

developer, workflow manager and workflow monitor)

. Over 2 years of experience in master data management

. Technical expertise in Data quality tool IDQ and MDM tool

Siperian.

. Expert in designing detailed technical specifications.

. Designed & executed complex ETL activities using INFORMATICA

(Power Center/Power Mart) between Oracle/MS SQL Server/DB2 UDB

databases, Flat files & XML files and cobol files using Power

Exchange.

. Expertise in OLAP and Reporting Systems using Crystal

Reports,Business Objects.

. Strong working experience on Data Warehousing applications,

directly responsible for the Extraction, Transformation and

Loading of data from multiple sources into Data Warehouse.

. Proven Data Design skills - Data Architecture, Data Modeling

using Erwin, Data Analysis & Definition

. Around 7 years of strong experience in OLTP/OLAP System Study,

Analysis and E-R modeling, developing Schemas such as Star

schema and Snowflake schema used in relational, dimensional and

multidimensional modeling.

. Strong experience in DB2/oracle database programming using

PL/SQL (Stored Procedures, Functions, Triggers, Materialized

Views, and Cursors) .

. Expert in UNIX Shell Scripting (Used SED, GREP & CUT utilities;

scheduling extensively).

. Expert in Troubleshooting/Problem Solving skills.

. Excellent Analytical, Communication skills and Leadership

qualities working in a team.

Skills

ETL Tools Informatica Power Center/Power Mart/ Power

Exchange

9.1.0/8.6.1/7.1.5/6.2.2, Informatica

PowerConnect

Quality Tools IDQ, Trillium 11.5 Discovery and Quality

application.

MDM Tools Siperian

Reporting Tools Business Objects 5.1

DBMS DB2 UDB 9,Oracle 10g, DB2, SQL Server

2005,2008

Language Unix shell scripting, PL/SQL, C, VB 6, JAVA

Job Function Architect, Project management, Analysis,

Design, Documentation,

Maintenance & support, Programming,

Testing.

OS/Environment HP - UNIX 11.0, SUN - UNIX 5.8, IBM AIX,

Windows NT 4.0/2000/95

Tools Visual Source Safe, Toad, Maestro, WinSQL,

Appworx, Erwin 7.

Professional Profile

Employer : Patni Computer Systems Limited (Now iGATE)

Title : Project Lead

Date of Employment : Oct 2004 - Till Date

Project Information

Project MetLife Individual Business Data

Warehouse

Employer Patni Computer Systems Limited

(Now iGATE)

Type Development

Role Technical Lead

Platform Windows, UNIX (SunOS 5.8, HP-UX B.11.00)

Technology/Software ETL-Informatica(Power Center 9.1.0),UNIX Scripting

(KSH), IBM

DB2

Duration Jan 2013 - Till Date

Client MetLife, USA

The Customer is a MetLife, Inc. which is a leading global provider of

insurance, annuities and employee benefit programs, serving 90 million

customers in over 60 countries. Through its subsidiaries and affiliates,

MetLife holds leading market positions in the United States, Japan, Latin

America, Asia Pacific, Europe and the Middle East.

Responsibilities:

. Responsible for the execution of all technical activities

associated with project.

. As a Tech Lead, managed activities between Client, business,

onshore and offshore team members.

. Interaction with Business Users and Managers in gathering business

requirements, developing and implementing the warehouse project.

. Technically managed team on 3 Onsite and 11 Offshore ETL

developers.

. Developed mappings and design workflows using Informatica Power

Center Source Analyzer, Target Designer, Mapping Designer, Mapplet,

Designer and Transformation Developer, Informatica Designer,

Workflow Manager to build DW as per business rules.

. Created scripts with the transformations with the Source Qualifier,

Aggregator, Lookup, Router, Filter Sequence Generator, Expression,

Joiner and Update Strategy.

. Developed and modified changes in mappings according to the

business logic, created Mapping variables, Mapping Parameters,

Session parameters.

. Coded, Debugged, Sorted out their time-to-time technical problems,

analyze the types of business tools and transformations to be

applied.

. Tuned performance of Informatica session for large data files by

increasing block size, data Cache size and target based commit

interval. Worked with short cuts for various Power Center objects

like sources, targets and transformations.

. Wrote the Unit Test scripts to validate and pre-validation the data

with business rules using SQL.

. Responsible for fixing the bugs in the Mappings, Sessions and

Parameter files.

. Developed, monitored and tuned SQL, PL/SQL code and monitored long

running sessions using Qwest tools (Toad 8.0).

. Loaded data from different source files such as XML, flat file,

.CSV files to Oracle and DB2.

. Developed shell scripts to send out an E-mail on success of the

process indicating the destination folder where the files are

available.

. Dealt with Unit Testing of all the mappings end to end and

supporting in UAT, Production.

. Configured and managed Informatica Repositories using Informatica

administrator console, worked on Dimension modeling as per business

needs.

. Provided Knowledge Transfer to the end users and created extensive

documentation on the design, development, implementation, daily

loads and process flow of the mappings.

Project Master Data Management Initiative in

R&P

Employer Patni Computer Systems Limited

(Now iGATE)

Type Development

Role Technical Architect

Platform Windows, UNIX (SunOS 5.8, HP-UX B.11.00)

Technology/Software IDQ, Siperian, ETL-Informatica(Power Center 8.6.1

and 9.1.0),UNIX Scripting

(KSH) MS SQL Server 2008, Oracle

Duration Jun 2010 - Dec 2012

Client Genworth, USA

For consistent reporting, regulatory compliance, strong interest in Service-

Oriented Architecture (SOA) Genworth has prompted a great deal of interest

in Master Data Management (MDM). To use the information on consistent way

and to accommodate the changing business needs Genworth took initiative to

implement MDM in organization.

Responsibilities:

. Responsible for the planning and management of all technical and

operational activities associated with MDM project.

. Developed Informatica mappings and also tuned them for better

performance.

. Implemented Aggregate, Filter, Join, Expression, Lookup and Update

Strategy, Normalizer,Sequence generator transformations

. Developed reusable Mapplets and Transformations to use them in

different mappings.

. Development of MDM functionality with diff. tools like IDQ,

Informatica and Siperian.

. Documentation involving creation of HLDs, LLDs and UTCs, KT

document for QA Team and for production rollout, technical

specification documents.

. Preparing the test cases and create the test data.

. Responsible for dealing with right peoples from business

experts,BA's to Data analyst for correct understanding of all the

source data for MDM implementation.

. Identify the risks associated with the project and ways to minimize

or eliminate those risks.

. Analyzing the data requirements to establish MDM feasibility.

. Responsible for handling relevant technical communication with

offshore team / Client.

. Responsible for project management activities including handling

onsite/offshore team, creating/updating Project Plans,

Communications, One Minute Project Management meeting documents,

status reports and risk assessments plans.

Project CMR SEC Print

Employer Patni Computer Systems Limited

(Now iGATE)

Type Development

Role Technical Lead

Platform Windows, UNIX (SunOS 5.8, HP-UX B.11.00)

Technology/Software DB2 UDB Version 8 fix pack 9, SQL Server 2005, ETL-

Informatica

(Power Center 8.6.1), UNIX

Scripting (KSH), PL/SQL, SQL

Navigator, Maestro,

Informatica PWX Version 8, Erwin 7.

Duration Jun 2009 - May 2010

Client MetLife Insurance, USA

In MetLife SEC Print provides mailings to MetLife customers who either own

or have an interest in MetLife contracts with the data available from the

various admin systems and vendors. To reduce the cost of vendors, CMR SEC

Print project has been implemented to get the client info from CMR (Client

Management Repository)

CMR is a separate client data repository, being built by the CIF Team. This

repository will be the strategic customer data store and IBDW will use the

clientized information from CMR to build and support party Information in

the IBDW warehouse. This system integrate client data from CIF and IBDW and

perform data clean up and standardizations. CMR will associate individual

and organizational parties who are identified as being the same individual

or organization and present them as Clients. The Clients will be associated

to the contracts on which their component parties play roles. Each role, in

turn, will have an associated mailing address and possibly an email

address. This association of contracts to the Client will allow IBDW to

present back to SEC Print the Clients with their roles on the contracts and

the associated mailing information.

Responsibilities:

. Responsible for the planning and management of all technical and

operational activities associated with Data Warehouse

Architectures.

. Responsible for project management activities including handling

onsite/offshore team, creating/updating Project

Plans,Communications, One Minute Project Management meeting

documents, status reports and risk assessments plans.

. Mapping business requirements to technical specifications and

design logic for implementing the same.

. Documentation involving creation of HLDs, LLDs and UTCs, KT

document for QA Team and for production rollout, technical

specification documents.

. Data Modelling using Erwin.

. Worked on Power Center client tools like Source Analyzer, Warehouse

Designer, Mapping Designer, Mapplet Designer and Transformations

Developer.

. Used ETL to extract and load data from COBOL files to DB2 UDB to

then Flat files.

. Responsible for writing technical specifications and mapping

documents.

. Used Power Exchange to define file layout using COBOL copybooks.

. Building Generic code for quick implementation.

. Generic Error Strategy implementation.

. Performance Tuning of Sessions and Mappings to meet the SLA of

almost 25 systems required for this critical project.

. Involved in Unit Testing of the mappings plus integration testing.

. Responsible for handling team of 9 resources including onsite and

offshore.

. Automated the process through unix scripting.

Project CCV (CLIENT CONSOLIDATED VIEW)

Employer Patni Computer Systems Limited

(Now iGATE)

Type Development

Role Project Lead/Tech Lead

Platform Windows, UNIX (SunOS 5.8, HP-UX B.11.00)

Technology/Software DB2 UDB Version 8 fix pack 9, SQL Server 2005, ETL-

Informatica

(Power Center 8.6.1), UNIX

Scripting (KSH), PL/SQL, SQL

Navigator, Maestro,

Informatica Power Exchange Version 8.

Duration May 2008 - Jun 2009

Client MetLife Insurance, USA

Project Details:

MetLife IBDW is in the process of implementing the warehouse for Life and

Annuity. Any new product that will be introduced in MetLife will use this

Standard Feed and Code to quickly go live without needing any new code.

The IBDW team build a standard file layout as Mainframe Copybook and

standard table layout for any new feed / product. The Mainframe files will

then be pushed into the warehouse using ETL tool. Warehouse is build to

provide data to the Investment Tracker which does not capture all of the

proprietary products. The project is increasing the number of products

feeding into Investment Tracker

Responsibilities:

. Responsible for project management activities.

. Requirement gathering and Analysis.

. As a onsite coordinator, managed activities between Client,

businesss, onshore and offshore

. As a designer, designed and coded various key modules which include

creation of analysis document, LLDs and UTCs.

. Developed mappings for extracting data from various sources involving

flat files.

. Developed data Mappings, Transformations between source systems and

warehouse using Informatica Designer.

. Developed different ETL strategies like set processing, error

strategy, polling, and reconciliation, error processing and re-

processing.

. Created sessions using Informatica Power Center workflow Manager.

. Involved testing and UAT support activities.

. Running integration test cycles and integration testing.

. Frequent communication with the client on technical and functional

queries.

. Maintained the updated version of all the software, which is used for

the project.

. Documentation involving creation of HLDs, LLDs and UTCs, KT document

for QA Team and for production rollout, technical specification

documents.

Project MetLife IBDW Maintenance and Production

Support

Employer Patni Computer Systems Limited

(Now iGATE)

Type Development/Maintenance/Production Support

Role Senior Developer/Onsite Co-ordinate

Platform Windows, UNIX (SunOS 5.8, HP-UX

B.11.00)

Technology/Software DB2 UDB Version 8 fix pack 9, SQL Server 2005, ETL-

Informatica(Power Center

7.1.5), UNIX Scripting (KSH), PL/SQL,

Maestro, Informatica Power

Exchange Version 8.

Duration Apr 07 - Apr 08

Client MetLife Insurance, USA

Project Details:

MetLife has built an Individual business Data Warehouse (IBDW) that is

loaded on a daily basis from internal and external data sources. This

Individual Data Warehouse further feeds data at various intervals into

various Marts like Compliance data mart, Sales data mart and MetBank data

mart. These Data Marts provide critical information for business analytic

and decision-making purpose. Individual data warehouse receives data in

the form of flat files and MS SQL database, which are transformed and

loaded into warehouse using Informatica as an ETL tool. Business users use

this information for their decision-making using Microstrategy reports.

The purpose of this project is to provide maintenance and production

support to data warehouse for Individual Business that will have

information that spans several subject areas, including Compliance, Sales,

and MetBank.

Responsibilities:

. Provide analytical solutions to Production Support problems with my

current knowledge base.

. Participate in design, code reviews, documentation of design, and

implementation of methodologies for all databases.

. Proof of Concept (POC) for any new software.

. Train others on my current knowledge base (IBDW, all Marts and

Informatica knowledge).

. Effectively communicate to Business Partners and team members the

problem and the expected time of resolution. As measured by my

feedback.

. Set Standards and Procedures for development team.

. Provided new dashboards for Production Support (SLA, Abends) to

senior management.

. Responsible for planning the disaster recovery scenarios.

. Architect, design and execute strategic projects for IBDW and its

Marts.

. Work with Relational Modeling (Logical and Physical) IBDW and

Dimensional Modeling for all the Marts.

. Fine tune SQL queries and database performance for all applications

within the development environment.

. Oversee performance monitoring and tuning and capacity planning.

. Responsible for Updating Licenses for various software such as

Informatica, UDB, Erwin.

. Key member of Informatica Competency centre that will provide a

roadmap for developing data warehouse applications using

Informatica. Produce Standards, procedures and guidance for next

strategic IBDW project.

. Participate and Provide analytical solutions for the strategic

vision of the IBDW in the Architecture Meetings.

. Performance Monitoring, benchmarking and Tuning of Sessions and

Mappings that are in Production.

. Managing and completing new fixes opened by Business users.

. Creating all paperwork for Production deployment.

. Upgrading Informatica Platform (7.1.5, 8.5.1), DB2 UDB (8.2, 9)

. Re-leasing MetLife servers (every 4 yrs)

Project MetLife Bank Data Warehouse and data mart

Employer Patni Computer Systems Limited

(Now iGATE)

Type Development

Role Analyst, ETL Developer

Platform Windows, UNIX (SunOS 5.8, HP-UX B.11.00)

Technology/Software DB2 UDB Version 8 fix pack 9, SQL Server2005, ETL-

Informatica

(Power Center 6.2.2), UNIX

Scripting (KSH), PL/SQL, SQL

Navigator, Maestro.

Duration Aug 06 - Mar 07

Client MetLife Insurance, USA

Project Details:

Bank Data Warehouse is part of the MetLife IBDW (Individual Business Data

Warehouse) enterprise data warehouse. It is a centralized data warehouse,

which will contain information pertaining to the MetBank's Accounts,

Customers and sales agents. IBDW is a shared environment, so that all the

customers (Marts) can query the warehouse globally. MetLife's Individual

Business offers a wide variety of protection and asset accumulation

products aimed at serving the financial needs of its customers throughout

their entire life cycle. Products include insurance products, such as

traditional whole life & term life insurance, universal & variable life

insurance, individual disability insurance & long-term care insurance,

annuities & investment products such as variable annuities, fixed annuities

and mutual funds.

The source of the data will be the extract flat files for customers,

agents, and accounts. The files will be sent 7 days a week, and 365 days a

year.

I was responsible for leading the team technically, meeting the deadlines,

updating project plan, creating admin jobs to monitor the load activity. I

was also responsible for introducing, and creating control total reports

(data quality checks). I was also part of the Architecture team to come up

with standards and procedures on Referential integrity, Error Strategy,

Warehouse keys for Type 2 etc.

Responsibilities:

. Building and Modeling a Relational model using 2nd and 3rd normal

form (2NF, 3NF).

. Building and Modeling a Dimensional model for the Marts using Star

Schema.

. Worked on Power Center client tools like Source Analyzer, Warehouse

Designer, Mapping Designer, Mapplet Designer and Transformations

Developer.

. Responsible for updating Project Plans, One Minute Project

Management meeting documents.

. Responsible for hiring resources for the project.

. Involved in creating repositories, Folders, Permissions and users

using repository manger.

. Used ETL to extract and load data from flat files to DB2 UDB.

. Involved in writing lot of Functions, Stored Procedures.

. Responsible for creating detailed technical specifications, and

mapping documents.

. Responsible for updating Project Plans, One Minute Project

Management meeting documents, status reports and risk assessments.

. Developed mapping to load data in slowly changing dimensions.

. Performance Tuning of Sessions and Mappings.

. Involved in Unit Testing of the mappings.

. Scheduling mappings using Maestro.

Project Sales and Compliance Data

Warehouse

Employer Patni Computer Systems Limited

(Now iGATE)

Type Development

Role Analyst, ETL Developer

Platform Windows, UNIX (SunOS 5.8, HP-UX B.11.00)

Technology/Software DB2 UDB Version 8 fix pack 9, SQL Server

2005, ETL-Informatica

(Power Center 6.2.2), UNIX

Scripting (KSH), PL/SQL, SQL

Navigator, Maestro.

Duration Jun 05 - Jul 06

Client MetLife Insurance, USA

Project Details:

The high level goal was to have a single data warehouse (IBDW) as the

central data repository for IB (Individual Business). From this warehouse,

reporting and operational systems will extract data for their purposes.

This is the governing part and is considered the master application.

The overall objective of the Compliance Data Mart was to consolidate the

three existing Compliance data marts into one single warehouse to be used

by the Compliance Organization. The goal was to have all of Compliance

using this warehouse as the Single-Source for reporting and analytical

needs. The source for this application was SQL Server, and Microstrategy

was the BI Tool. Informatica was the tool used for extraction,

transformation and to load the data.

The overall objective of SDM (Sales Data Mart) is to be the single source

of information for reporting on gross, net, payment and commission

information.

The source of the data will be the extract flat files from different admin

systems for different Sales Products.

Responsibilities:

. Building a relational model using 2nd and 3rd normal form (2NF,

3NF).

. Worked on Power Center client tools like Source Analyzer, Warehouse

Designer, Mapping Designer, Mapplet Designer and Transformations

Developer.

. Involved in creating repositories, Folders, Permissions and users

using repository manger.

. Used ETL to extract and load data from flat files to DB2 UDB.

. Involved in writing lot of Functions, Stored Procedures.

. Created various transformations such as Update Strategy, Look Up,

Joiner, Filter and Router Transformations.

. Developed mapping to load data in slowly changing dimensions.

. Performance Tuning of Sessions and Mappings.

. Involved in Unit Testing of the mappings.

. Scheduling mappings using Maestro.

Project MetLife IDW Ereporting

Employer Patni Computer Systems Limited

(Now iGATE)

Type

Development/Maintenance/Production Support

Role ETL Developer, Configuration

Manager

Platform Windows XP, UNIX (SunOS 5.8, HP-UX

B.11.00)

Technology/Software UDB 7.x/8.x, SQL Server, ETL-Informatica

(Power Center

6.2.2), UNIX Scripting

(KSH), PL/SQL, SQL Navigator, Maestro,

UNIX (SunOS 5.8, HP-UX

B.11.00)

Duration Oct 04 - May 05

Client MetLife Insurance, USA

Project Details:

MetLife has built an Institutional Data Warehouse (IDW) that is

loaded on a daily basis from internal and external data sources. This

Enterprise Data Warehouse further feeds data at various intervals into

various Marts viz. Company Relationship Mart, Dental Mart, Disability Mart,

Finance Mart, eMetrics Mart, Long Term Care Mart and Life Mart.

The IDW/Data Marts provide critical information for business analytic and

decision-making purpose. IDW receives data in the form of flat files, which

are transformed and loaded into warehouse using Informatica as an ETL tool.

Business users use this information for their decision-making using COGNOS

and ACTUATE reports. IDW/Data Marts are available 24x7 and reside on a

distributed hardware across different sites.

The project involves production support activities for the data load

process for IDW and current Marts and any other data marts that might be

sourced from IDW in future. The scope of support covers the code developed

for data load processes using Informatica PowerMart, Unix Scripts, UDB SQL

scripts and Maestro Schedules.

Responsibilities:

. Provide analytical solutions to Production Support problems with my

current knowledge base.

. Participate in design, code reviews, documentation of design, and

implementation of methodologies for all databases.

. Train others on my current knowledge base (IDW, all Marts and

Informatica knowledge).

. Effectively communicate to Business Partners and team members the

problem and the expected time of resolution. As measured by my

feedback.

. Check data consistency/accuracy/integrity.

. Maintain production log, analysis and abend history.

. Set Standards and Procedures for development team.

. Provided new dashboards for Production Support (SLA, Abends) to

senior management.

. Responsible for planning the disaster recovery scenarios.

. Architect, design and execute strategic projects for IDW and its

Marts.

. Work with Relational Modeling (Logical and Physical) IDW and

Dimensional Modeling for all the Marts.

. Fine tune SQL queries and database performance for all applications

within the development environment.

. Participate and Provide analytical solutions for the strategic

vision of the IDW in the Architecture Meetings.

. Performance Monitoring, benchmarking and Tuning of Sessions and

Mappings that are in Production.

. Managing and completing new fixes opened by Business users.

. Creating all paperwork for Production deployment.

Training and Certification

Project Management Professional.

Education

B.E. (Computer Science And Engg.), India.

Contact Information / Personal Details:

E-mail Address : acd039@r.postjobfree.com, acd039@r.postjobfree.com

Cell number : 001-732-***-****

D.O.B. : 07/22/1981

Contact this candidate