Manager Project

RUKMINI KATTA

MOB NO: +91-995*******

CAREER OBJECTIVE

To pursue a challenging and satisfying career and to be a part of a

progressive and growth oriented Organization that give me scope to enhance

my knowledge and skills to explore and work on the latest technological

changes.

Summary of Experience

. Having 4+ years of experience in Data Warehousing. This includes analysis

and development of mappings using Informatica tool. Used most of the

transformations.

. Good experience in analyzing the business requirement and preparing

design documents.

. Good experience in understanding business applications, business dataflow

and

data relation.

. Experience in the Data Warehousing using Data Conversion, Data

Extraction,

Data Transformation and Data Loading.

. Interacting with Relational data base like SQL Server, DB2, Oracle.

. Good team player with excellent interpersonal and communications skills

EDUCATION: M.C.A from Osmania University

technical Skills:

ETL TOOLS: INFORMATICA 9I / 8X / WTX (TRAINED), ODI, DAC, AND OBIEE.

Relational Databases: Oracle 7.x/8i/9i, SQL Server 2000/2005

Programming languages: SQL, PL/SQL

Operating Systems: Windows NT/95/98/2000/XP

Querying/other tools: Toad, PL/SQL developer

Experience:

. Working with Fujitsu Consulting India from March 2011 to Till

Date.

. Worked in Mphasis an HP company from April 2010 to Feb 2011.

. Worked in Philexin Data Solutions from March 2009 to April

2010.

Client: Parker Hannifin, USA

Project: Parker Hannifin OBIEE11g Up gradation

Duration: May 2012 to Till Date

Role/position: Sr.IT.Consultant/Developer

Project Description - Parker Hannifin is the world's leading

diversified manufacturer of motion and control technologies and

systems, providing precision-engineered solutions for a wide variety of

mobile, industrial and aerospace markets. The company employs

approximately 58,000 people in 47 countries around the world.

Roles and Responsibilities -

. Designed and developed transformation rules to support the business

functionality using Informatica Power Center.

. Gather requirements from the Client for design purpose .

. Designed LLD and HLD docs as per the Client Requirement.

. Experience in designing and developing complex mappings from varied

transformation logic like Unconnected and Connected lookups, Source

Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update

Strategy, Union, Sequence Generator, Sorter, Rank, Normalizer etc.

. Involved in validation of data and mappings.

. Used Session parameters and Mapping variable/parameters.

. Involved in up gradation from Informatica 8.6 to 9.0.

Client: KOYO Corporation

Project: KOYO (USA)

Duration: Jan 2012 to April 2012

Role/position: Developer

Project Description - Koyo Seiko Co., Ltd. and Toyoda Machine

works, Ltd. merged and have a new start as JTEKT Corporation.

JTEKT Corporation stands at the forefront, as a technology leader

in the U.S and World Bearing industry. The major objective of this

application is to extract data from SAP ERP and load it into Data

warehouse (Oracle) which is used for business optimization rather

than business updates.

Roles and Responsibilities -

. Configured OBIA 7.9.7.1 environment which includes installation of

OBIEE 11.1.1.6, ODI 10.1.3.6.1 and OCM.

. Created new security repository connection for connecting the

Master repository using Topology Manager.

. Configured physical and Logical connections in Topology manager by

creating Physical Data stores, Physical schemas and Logical

schemas.

. Defined listener and Scheduler agents as windows services and

configured them in Topology manager.

. Configured different contexts (Development, Quality and Production)

in Topology manager.

. Created new security repository connection for importing the Work

repository using Designer tool.

. Customized the mappings and packages to meet the business

requirements.

. Customized variables using OBIEE admin tool.

. Customized Reports/Dashboards as per the business requirements

Oracle Business Intelligence Presentation Services.

Client: Municipality of Abu Dhabi, Abu Dhabi

Project: ADM DW BI

Duration: Nov 2011 to Jan 2012

Role/position: Sr.IT.Consultant/Developer

Project Description - Municipality of Abu Dhabi city (ADM) is the

government administrative department which provides comprehensive

services to the public and ensures proper planning of the developing

city, with regularized road networks, maintenance services, sewerage,

lighting works, and bridges, launching the Agriculture Development

Plan in the Emirate and establishing public markets in various areas

of Abu Dhabi city.

Roles and Responsibilities -

. Involved in requirement gathering from the Business Users and

Designing Data Model for 10 data models.

. Worked on extracting data from databases like Oracle, SQL Server

2008, DB2, and Flat Files

. Involved in requirement clarification meetings with the end users

and converting the requirements into designs.

. Used workflow manager and workflow monitor extensively to create

tasks, worklets, and workflows and execute the tasks & also monitor

the workflows.

. Developed reusable Mapplets, Transformations, Sessions and

Parameterized DB connections.

. Customized repository (.rpd) by using OBIEE admin tool's physical

layer, business model & mapping layer, presentation layer according

to the business requirements.

. Imported the required objects (Physical Tables) with integrity

constraints into the physical layer using Connection Pools and

defined the relationship by identifying the facts and dimensions.

. Created Business Models in the BMM layer by defining the logical

joins between the logical tables.

. Implemented business logics (setting aggregation rules) for the

facts and created hierarchies for the drill-down functionality.

. Created new calculation measures and level based measures and

implemented Time-Series functions (Ago, To Date) using the business

model and mapping layer of admin tool.

Client: Principal Finance Group, USA

Project: SBD (Specialty Benefits Division)

Duration: Mar 2011 to Oct 2011

Role/position: IT.Consultant/Developer

Project Description - SBD warehouse new architecture - Warehouse

strategy starts with staging layer which is responsible for data

cleansing & data scrubbing for operational source.

Roles and Responsibilities -

. Designed and developed transformation rules to support the business

functionality using Informatica Power Center.

. Gather requirements from the Client for design purpose.

. Designed LLD docs as per the Client Requirement.

. Experience in designing and developing complex mappings from varied

transformation logic like Unconnected and Connected lookups, Source

Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update

Strategy, Union, Sequence Generator, Sorter, Rank, Normalizer etc.

. Experience in debugging and Performance tuning of targets, sources,

mappings, Workflows and system.

. Involved in validation of data and mappings. Created test cases and

prepared PCM docs.

. Created Partitions to improve the performance of the long running

Sessions.

. Used Session parameters and Mapping variable/parameters.

Client: BSC, USA, California

Project: BSC (Blue Shield of California)

Duration: April 2010 to Dec 2010

Role/position: IT.Consultant/Developer

Project Description - Blue Shield of California is a health plan based

in San Francisco, California.

There are two main segments which are covered under this project

a) Data loading into ODS

b) Population of data into EDW from ODS.

Roles and Responsibilities -

. Developed ETL mappings, transformations using Informatica

Powercenter.

. Designed and developed transformation rules to support the business

functionality using Informatica Power Center .

. Experience in designing and developing complex mappings from varied

transformation logic like Unconnected and Connected lookups, Source

Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update

Strategy, Union, Sequence Generator, Sorter, Rank, Normalizer etc.

. Involved in validation of data and mappings. Created test cases and

prepared deployment docs.

Client: Pfizer Pharmaceutical LTD,USA

Project: Pharmaceutical Information System

Duration: Mar 2009 to April 2010

Role/position: Developer

Project Description -Pfizer is a Pharmaceutical company.

Pharmaceutical information system plays a key role in any pharmacy-

oriented organization. It deals with different product types used in

developing products under various Batches transactions.

Roles and Responsibilities -

. Designed and developed transformation rules (business rules) to

generate consolidated (fact and summary) data using Informatica

PowerCenter tool.

. Developed various mappings to load data from various sources using

different transformations like Router, Aggregator, Joiner, Lookup,

Update Strategy, Expression and Sequence Generator to store the

data in target table.

. Created mappings with PL/SQL procedures/functions to build business

rules to load data.

. Developed and tested all the Informatica mappings involving lookups

and update Strategies.

. Created Sessions and Workflows for carrying out test load.

Contact this candidate