Informatica Developer

Chetan Chodankar

Contact: +1-412-***-****

Email: ****************@*****.***

Summary :-

• Total 5.5 years of professional IT experience in requirement gathering, analysis,

development, testing using Informatica, database, Unix, Perl.

• Experience in software full lifecycle development and system integration.

• Strong in data model design, data definition language, data modification language and

analytical skill.

• Experience in ETL design, Creating High Level and Low level design documents .

• Extensively used Informatica Designer to create and manipulate Source and Target

definitions, Mappings and Transformations.

• Extensively worked on Informatica Power Center Transformations such as Source

Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy,

Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator.

• Have clear understanding of Data warehousing and Business Intelligence concepts with

emphasis on ETL and life cycle development using Power Center, Repository Manager,

Designer, Workflow Manager and Workflow Monitor.

• Have knowledge in Performance Tuning, Tuning Techniques.

• Have knowledge in Command line programs like PMCMD, PMREP.

• Have Knowledge in Importing and Exporting of Objects from one Repository to another

repository.

• Using Teradata for Data loading/accessing, for creating dashboard model.

• Good knowledge and experience in working with Teradata in DML, DDL, SQL tuning,

TPT.

• Excellent command over DB2. IBM DB2 certified SQL Procedure Developer.

• Experience in Perl/Shell to generate equity reports for business users.

• Knowledge in Banking and Finance domain front.

• Significant experience of working with operation units, desk users, Sales Team,

Business Units, commission management groups of Morgan Stanley to understand their

business requirements and provide data reports for data analysis.

• Discussion with the client and documenting the functional and technical requirement.

• Possess excellent interpersonal, communication and analytical skills with demonstrated

abilities in customer relationship management.

• Excellent analytical & logical abilities and relationship management skills.

Technical Skills :-

Operating systems Windows XP/7, Red Hat Linux (9.0), UNIX

Programming Languages Perl, Shell, template toolkit

IDE DB Artisan, RapidSQL, Teradata SQL assistant, Teradata Studio,

MS SQL server management studio, Toad

DB object migration tools syts, db2ts

Tools Autosys, Batchmon, Hummingbird Connectivity 10,WinSCP,

Power Center 9.1

Database Sybase 12.5 and 15, Teradata 14, MS SQL Server, IBM DB2 9.7,

Oracle.

Configuration Perforce, Harvest

Management

Education :-

B.E (Computer Science) from Walchand college of Engineering, Shivaji University, Sangli,

India.

Year of passing: 2009

Certification and Achievements :-

Certification in DB2 730 (Fundamentals)

Certification in DB2 9.7 SQL Procedure Developer

Lean Six Sigma Certification- Green Belt

NSE's Certification in Finance Module (NCFM) - Beginner’s Module

NCFM Mutual Fund’s Beginner Module

NCFM Equity Derivatives: A Beginner's Module

NCFM Commercial Banking in India: A Beginner's Module

Got award at portfolio level for performance

Work Experience :-

Project - I

Project Name: Activity Based Costing (ABC) - Retail Profitability

Client: PNC Bank

Domain: Banking and Finance

Duration: June 2014 to till date

Solution Environment: Windows 7, UNIX, Informatica 9.1, Teradata 14, MS SQL Server,

Oracle

Tools: Informatica Power Center, Teradata Studio, MS SQL Server

Management Studio, Toad, Putty, Notepad ++, Microsoft Visio,

Harvest, ACORN.

Role: Onsite Tech Lead

Project Description:

The primary function of this project is to provide accurate metrics and a source

of reliable ongoing costing information for Retail customer, channels and products in

order to support optimal decision making and to increase net income through the

Serving Customers Tomorrow (SCT) initiative as well as other related efforts. It

calculates costing information on the basis of different drivers for a account. It considers

both general ledger and organizational hierarchies. It shows how dollar amount flows

from each general ledger to its related activity. ABC calculates profitability at account

level and reports data into Enterprise Profitability Management (EPM) data mart

(Oracle).

As a part of ABC, We have new initiative started to provide ABC retail

profitability data to ICDM application. It involves sourcing ABC profitability data (SQL

Server) and transforming it as per ICDM requirement and keeping it in Enterprise Data

Warehouse (Teradata). As a another initiative we have started analysis to keep EPM like

data in EDW (Teradata). This will be useful to resolve EPM space issues, making retail

profitability data more accessible for other applications.

Task:

Requirement gathering and requirement Analysis.

Preparation of ETL High level and Low level Design (Visio) documents, Mini

Task Document (MTD), Scheduling document.

Assist in implementation of source to target maps developed by the Data

Architect/Modeler and Business Analyst.

Translate customer requirements into technical specifications and data mappings.

Creation of mappings, Mapplets, task, workflows.

Developing Informatica mappings, Sessions and Workflows.

Preparation of parameter files for Informatica workflows.

Creation and execution of test cases of Informatica workflows.

Debugging of mapping while Unit Testing.

Creation of harvest packages for deployment of Informatica objects.

Creation of tables, collection statistics, Partitioning of tables.

Creation BTEQ scripts (Teradata), maintaining history of tables, writing queries,

checking query plans.

Writing shell scripts for housekeeping.

Involved into source code review, the mappings created by team members and

perform debugging and tuning of mapping.

Reviewing test cases prepared from other team members.

Raising proper request for Code migration.

Project - II

Project Name: True Customer View - Management Information Dashboard

(TCV MI Dashboard)

Client: Barclays Bank

Domain: Banking and Finance

Duration: July 2013 to May 2014

Solution Environment: Windows 7, UNIX, Informatica 9.1, Teradata 14.

Tools: Informatica Power Center, Teradata SQL Assistant,

Putty, Notepad ++, Microsoft Visio.

Role: Developer

Project Description:

TCV (True Customer View) is a strategic platform built by Barclays to get complete

understanding of customer across line of businesses.TCV model holds data from

multiple source system.

Project objective is to be able to identify potentially incorrect customer data. We rely on

predetermined rules to validate the data we hold for all Personal customers.

Validation includes number of business rule checks on important fields like DOB,

Customer Country, Mobile Phone, EmailID etc. TCV MI has built the data model which

will be used to create different reports like report on Customer - Product relation based

on management requests.

Task:

Requirement gathering and requirement Analysis.

Analysis on business rules provided by BA.

Preparing Requirement and design documents.

Creation of flow charts using Microsoft Visio.

Creation of mappings, mapplets, task, workflows.

Developing Informatica mappings, Sessions and Workflows.

Preparation of parameter files for Informatica workflows.

Creation and execution of test cases of Informatica workflows.

Debugging of mapping while Unit Testing.

Copying of affected components in Deployment groups.

In Teradata, Creation of tables, collection statistics, Partitioning of tables,

Creation BTEQ scripts, maintaining history of tables, writing queries, checking

query plans.

Writing shell scripts for housekeeping.

Reviewing test cases prepared from other team members.

Carrying out code review.

Coordinating with SIT and OAT team for next phases.

Raising proper request for Code migration.

Project - III

Project Name: Internal Trade Activity Reporting Applications-Extract Transform

Load- Data Mart (ITARA-ETL-DM)

Client: Morgan Stanley

Domain: Banking and Finance

Duration: April 2012 to June 2013

Solution Environment: Windows XP, UNIX, Informatica 8.6.1, Sybase, Perl, UDB DB2.

Tools: DBArtisan, Hummingbird Connectivity 10, Rapid SQL, Power Center,

Putty, Syts, db2ts, Autosys/Batchmon.

Role: Developer, Onsite Coordinator

Project Description:

Project ITARA-DM contains many data marts like Order Execution Data mart (OEDM),

Hop Data mart (HDM). These data marts are databases that hold historical trade data

which is used by front-end application. The data mart is global in nature for London,

New York, Hong Kong, Asia, Budapest, Tokyo region. The HDM is having information

about Morgan Stanley's different desks/engines through which trade flows. Project

populates these Data Marts so that these can be used for analyzing business and

providing dashboard for other teams.

Task:

Requirement gathering and requirement Analysis.

Preparing Requirement and design documents

Resolving data issues of business users of application.

Developing Informatica mappings, Sessions and Workflows

Creation of test cases of Informatica mappings.

Creating Autosys jobs for scheduling workflows

Creating and enhancing database objects i.e., Stored Procedures, Views and

Tables.

Enhancing Perl scripts used in application.

Reviewing test cases prepared from other team members.

Project - IV

Project Name: Internal Trade Activity Reporting Applications-Equity Reporting

(ITARA-ER)

Client: Morgan Stanley

Domain: Banking and Finance

Duration: Sept 2009 to March 2012

Solution Environment: Windows XP, UNIX, Sybase, Perl, UDB DB2, Template Toolkit, BI.

Tools: DBArtisan, Hummingbird Connectivity 10, Rapid SQL,

Putty, Syts, db2ts, Autosys/Batchmon.

Role: Developer

Project Description:

Project handles real transactional data which provides market and non-market risk positions to

the Institutional Equity Division (IED) and Operations.

ER enables traders and risk managers to view risk, exposures, limits and hosts of other

parameters that help them monitor trading activities as well as make analytical decisions

that directly impact business. ER also helps operation units to confirm all details about

trade done under Morgan Stanley. This project have carried out DB hygiene and

application remediation as well.

Task:

Analysis of the business specifications to technical requirements provided by the

client/user, desk users.

Analysis on new trade flow, change in existing trade flow information and attend

report impact meetings to change reports accordingly.

Creation and scheduling new reports for Users using Perl, shell, Template

toolkit, BI (Crystal Reports etc).

Creation of new reports based on product, client, equities information.

Enhancement of existing reports as per client requirement.

Debugging/Bug Fixing/ Unit testing in Sybase/DB2/Perl code.

Optimization of the Sybase/DB2 stored procedures or queries.

Performing the turnover/deployment by raising the requests.

Performing syts/db2ts/BCP/defncopy operations.

Interacting with the clients, Business Analyst, desk users and help the team to

resolve data/report related issues and queries.

Work on ad-hoc requests from Operation Units on stocks, equity trades

confirmation and provide proper information from database.

Verification & Validation Process improvement (Under Six Sigma).

Supporting the application in case of any production issues.

Project - V

Project Name: ITARA-ER Athena – Sybase to DB2 Stored Procedure migration

Client: Morgan Stanley

Domain: Banking and Finance

Duration: Aug 2011 to January 2012

Solution Environment: Windows XP, Linux, UNIX, Sybase, UDB DB2, Perl, template toolkit.

Tools: DBArtisan, Rapid SQL, Putty, db2ts.

Role: Developer

Description: This is sub-project of ITARA-ER project (Project-III), which involves migration of

stored procedures owned by our team from sybase/DB2 mainframe databases model

(ETSDB – Equity traded system DB) to DB2 UDB database model (ATHENA).

This initiative was taken place to enhance efficiency and use advantages of DB2

UDB over Sybase. Athena is the Commerce Model database implementation of Cash

Equity, Listed Derivatives and Cash FID trading data. Project involves deep

understanding of both models and expertise in Sybase & DB2 concepts.

Task:

Create project plan and meet deadline of migration of each procedure.

Analyze stored procedures written in Sybase model and find out exact business

requirement.

Understand and study new DB2 UDB model created by modeling team.

Create procedures in DB2 UDB model which will have same functioning as per

existing Sybase procedures.

Performance enhancements of new DB2 procedures.

Change in Perl, template toolkit code to use new procedures.

Unit and Integration testing of stored procedures and Perl scripts.

Migration of objects to production or prod-parallel environments using db2ts

tool.

Responsible for project documentation, status reporting and presentation.

Contact this candidate