Seemala.Prathap

Email:j0puy2@r.postjobfree.com

Mobile: 888-***-****

Professional Object:

To associate with an organization where my skills can be utilized for the progress of the organization and simultaneously update my knowledge and skills.

Professional Summary:

Having 3+ years of IT experience in Software Development, with specialization in Data Warehousing (ETL) using Informatica, Oracle

Good exposure in Data Warehousing concepts .

Responsible in Extraction, Transformation and Loading process of Informatica.

Good at developing mappings, sessions and workflows using Informatica Power Center.

Extensively used Informatica Client Tools – Designer, Workflow Manager and Workflow Monitor.

Good in understanding business processes/requirements and translating them into technical Requirements.

Good at SQL,PL/SQL and Unix Commands.

Work Experience:

Working as an ETL Developer in Ness Technologies Limited, Bangalore from

Aug -2010 to till date.

Worked as an ETL Developer in Tetra Soft India Pvt. Ltd , Hyderabad from

June -2008 to July-2010.

Educational Qualification:

Bsc from Andhra University in 2007.

Technical Skills:

Operating Systems : Windows 2000 XP/NT,Vista,Windows7,Unix,Linux

ETL-Tools : Informatica PowerCenter 7.1/8.6.0

Languages : C,HTML

RDBMS : Oracle,Teradata

Projects Handled:

Project #1

Project Title : Critical Data Mart

Client : OTP Bank, Hungary

Environment : Informatica PowerCenter8.6, Oracle 9i,Windows NT, Unix

Duration : Aug 2010 to till date

Description:

OTP Bank is the biggest commercial bank in Hungary, operating in Central and Eastern Europe. The bank provides universal financial services for more than 13 million costumers, through nearly 1500 branches in 9 countries.The project aims to build a data warehouse solution for business people at their business, by integrating the business data from various source systems. The solution will use a Dimensional Model to providing a multidimensional view and allow analytical and ad-hoc reporting. The data from various sources systems is loaded into the Critical Data Mart where the data is stored in the form of a Dimensional Model. The source of the source data would be daily feeds from the Source Systems.

Responsibilities:

Studied the schema used and the structures of source and target tables. (Facts and dimensions).

Based on the design document that were created, developed mappings, mapplets, tasks, sessions to populate the target data warehouse.

Created mappings to extract data from OLTP to staging.

Created mappings to extract data from flat files to staging.

Built logics to cleanse data during stage load.

Created mappings to load data from staging area to dimensions and facts.

Involved in data verification and validation.

Created reusable mappings with mapping parameters.

Created the mapplets to reuse the transformation logic.

Created the stored procedures.

Involved in creation of tasks, worklets and workflows and scheduling the workflows.

Project #2

Project Title : Guardian Insurance

Client : Guardian Life Insurance Company of America

Environment : Informatica PowerCenter8.5, Oracle 9i,Windows XP

Duration : May2009-June2010

Description:

The Guardian Life Insurance Company of America is a Fortune 300 company founded in New York. It is the fourth largest mutual life insurance company in the United States. The Guardian Life Insurance Company of America and its subsidiaries sell life, long term care insurance, disability income, group medical and dental insurance products, and offer 401(k), annuities and other financial products. The project aims to build a data warehouse solution for Insurance types, policies, vendors and providers, by integrating the business data from various source systems.

Responsibilities:

Interpret transformation rules for all target data objects and developed mappings to support the transformation.

Translated Business processes into Informatica mappings using ETL mapping specifications.

Involved in Code review and Unit testing.

Debugging the data whether it is loaded correctly in target.

Involved in testing of mappings, maplets and sessions.

Writing documentation for Review the mappings.

Project #3

Project Title : Banking System

Client : South Trust

Environment : Informatica PowerCenter7.1, Oracle 9i, Windows XP

Duration : June 2008- April 2009

Description:

South Trust is a banking company which offers various banking services like savings accounts, personal loans, checking accounts, mortgage loans, credit cards and safe deposit boxes. It has branches allover India. As a part of Banking Services they provide Saving Account, Checking Account, Mortage Loan and other loans. The main reason for the Client to go for Data Warehousing is improve his business by providing various facilities to his customers. By using necessary transformations extracting the data from the respective databases, transformed and loaded in to the target database by using Informatica.

Responsibilities:

Involved in understanding user requirements, design ,development and documentation for ETL mappings.

Designed and developed mapping from varied Transformations like Source qualifier, Aggregator, Expression, Rank, Router, Filter, Update Strategy and Joiner.

Importing Source and Target tables from their respective databases.

Developed Informatica Mappings, Mapplets and Transformations for migration of data from existing systems to the new system using Informatica Designer.

Optimizing performance tuning at mapping and Transformation level.

Involved in designing the mapplet and reusable transformation according to the business needs.

Involved in Performance tuning at various levels including Target, Source, and Mapping.

Contact this candidate