Narasimha

Mobile: +91-770*******

Email: acekix@r.postjobfree.com

Summary of Skills and Experience

. Having 3.6years of data warehousing experience using Informatica

Powercenter 9.x, 8.x.

. Strong Experience on informatica power center client Tools - Mapping

designer,

Workflow Manager, Workflow Monitor and Repository Manager.

. Extensive experience in extraction, transformation and loading of data

directly from different source systems like flat files, Oracle, SQL

Server,DB2,SAP Database.

. Hands on experience on transformations like Unconnected and Connected

lookups, Router, Aggregator, Joiner, Update Strategy, Expression,

Filter and re-usable Mapplets, transformations.

. Having good experience on different tasks like session, email,

command, and assignment tasks.

. Worked on different types of transformation logics like SCD Type1 &

2.

. Working experience in using Oracle 11g/10g, SQL, SQL Server, DB2 and

SAP Database.

. Having good knowledge in UNIX scripting and deployment activities.

. Excellent skills in understanding business needs and providing

technical solutions on time.

Professional Experience

* Working as a Senior Software Engineer for TCS, Hyderabad from Sep

2011 to Till Date.

* Worked as Software Engineer for Accenture, Bangalore from SEP 2010

to Aug 2011.

Education

* B.Sc from Sri Venkateshwara University in the year 2009.

IT Skills

ETL Tool :

Informatica Power Center 9.x/8.x

Relational Database : Oracle 11g.

Operating Systems :

Windows Server 2003/2000/XP, UNIX.

Languages : SQL,

Reporting Tool :OBIEE

11g

Work Experience

Project 1# : Automation Control Solutions Central Processing System.

Client : Honeywell

Project Specific Skills : Informatica Power Center 9.x/8.x,

Oracle 11g, SQL Server 2008, DB2,

SAP Database

Role : Data Acquisition Analysts.

Duration : Sep 2011 to till date.

Synopsis:

The Honeywell CPS Data team to be extract and load the data from the

various sources like Oracle, SQL Server, DB2, SAP Database. The CP/S

program is so large running 14 super tankers and 20+ projects at any time

it is very important that we have a common reporting structure for the data

management of all projects within the program. We leverage the same utility

database as with the data processes and centrally locate all project plan

details in a central set of tables and provide reporting to the deployment

leads, data fil's, data leads and full data team for activity management,

follow-up, and issue resolution.

Responsibilities:

. Build the Acquire and Localize processes based on mapping documents

and direction from Data Leads, Super Users.

. Involved in new object development we have never loaded before by

developing Informatica Mappings and Workflows.

. Add new data cleansing rules, Bug fix to localize based on data action

inputs from data leads and Super users inputs.

. Working Informatica PowerCenter client tools like Source Analyzer,

Warehouse Designer, Mapping Designer and Transformation Developer.

. Using most of the transformations such as the Source Qualifier,

Application Source Qualifier, Expression, Aggregator, Connected &

unconnected lookups, Filter, Router, Sequence Generator, Sorter, and

Joiner.

. Using Developed SQL scripts for business data loads.

. Imported data from various Sources transformed and loaded into Data

Warehouse Targets using Informatica client Tools.

. Using shortcuts to reuse objects without creating multiple objects in

the repository and inherit changes made to the source automatically.

. Using Workflow Manager for workflows and session management, Database

connection management.

. Optimizing Query Performance, Session Performance.

. Delivering objects for client that is correct an on time.

. Prepared the Documentation to describe program development, logic,

coding, testing, changes and corrections.

Project 2# : CEMS (Corporate Event Management System)

Client : Bank of America

Project Specific Skills : Informatica Power Center 8.x, Oracle

10g, SQL

Role : Informatica Developer.

Duration : June 2010 to Aug 2011.

Synopsis:

This project has been developed for the banking industry located in

United States. The main objective of this project is to enable GCIB (Global

Corporate Investment Banking) Events department to manage several events

every year for Debt and Equities lines of business. Events range from small

one-time events to regular large events with several hundred clients.

Responsibilities:

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

Designer, Mapping Designer, Mapplet Designer and Transformations

Developer.

. Used most of the transformations such as the Source Qualifier,

Expression, Aggregator, Connected & unconnected lookups, Filter,

Router, Sequence Generator, Sorter, Joiner, and Update Strategy.

. Used Workflow manager for Workflow and Session Management, database

connection management and Scheduling of jobs to be run in the batch

process.

. Developed SQL scripts, PL/SQL procedures for creating/dropping of

table and indexes of performance for pre and post session management.

. Imported data from various Sources transformed and loaded into Data

Warehouse Targets using Informatica.

. Used shortcuts to reuse objects without creating multiple objects in

the repository and inherit changes made to the source automatically.

. Developing Informatica mappings & tuning them when necessary.

. Optimizing Query Performance, Session Performance.[pic][pic]

Contact this candidate