Manager Developer

Mobile: +918*********

Shaik Sadiq Email:

*************@*****.***

Professional Summary:

> Over all 3+ years of IT experience in Data warehousing Technologies as

a team member for various Data warehousing & Data Marts projects as an

ETL Developer using Informatica 9.x and Oracle 9i and Sqlserver

> Good knowledge of Data Warehousing Concepts.

> Extensive experience in creation of ETL mappings and transformations

to reflect business rules using Informatica power center to move data

from multiple sources into target.

> Extensively Worked on Informatica Designer Components - Source

Analyzer, Warehousing Designer, Transformations Developer, Mapplet and

Mapping Designer

> Extensive work in ETL process consisting of data transformation, data

sourcing, mapping, conversion and loading.

> Vast experience in developing complex mappings from varied

transformation logic like Unconnected and Connected lookups, Router,

Filter, Expression, Aggregator, Joiner, Update Strategy etc.,

> Vast Experience on Workflow Manager Tools - Task Developer, Worklet &

Workflow Designer.

> Experience in Performance tuning of targets, sources, mappings and

sessions.

> Involved in improving performance of the Server Sessions by

identifying and eliminating the Performance Bottlenecks.

> Used Debugger to test the mappings and fix the bugs.

> Responsible for creating business solutions for Incremental and Full

loads.

> Efficient team player with excellent communication skills,

Presentation Skills, Interpersonal Skills and ability to quickly

adopt to Technical Environment and Good interaction with users.

> Excellent written and verbal communication skills that has been put to

use to understand clients business requirements and converting the

same into systems fulfilling business needs

> Well-organized, self-motivated and hard working. Skilled in problem

solving and communicating.

Professional Profile

> Working as an ETL Developer with TCS, Hyderabad from Aug' 2012 to till

date.

> Worked as an ETL Developer with StratApps Solutions Pvt Ltd, Hyderabad

from Sep'2010 to Jul'2012

Academic Profile

> Master of Computer Applications.

> Bachelor of Computer Science.

> Board of Intermediate Education.

> SSC.

Technical Skills:

ETL Tools : Informatica 9.x/8.1

Databases : Oracle 10g/9i, Sqlserver 2005

Languages : C, C++, SQL, PL/SQL

OS/Environment : UNIX, Windows XP

Projects Profile:

Project #3:

PROJECT NAME Agent Data Mart

Industry Insurance, policies and premium

Client Emirates NBD Bank., Dubai

Duration Aug 2012 to Till date

Role ETL Developer

Project Specific Skills Informatica9.1,Oracle10g,SQL,

PL/SQL, Windows NT

Team size 4

Location Offshore Team

EDW Agent Data warehouse is aimed to assist $3b property. There are

multiple sources of information about the Company's customers, coverage's,

covered items and policies. The core processes in the value chain of

insurance are policies, premium payments and processing claims. It begins

with a variety of policy transactions and premium revenues associated with

each policy. This data warehouse allows the Management for effective

decision-making and to transform product centric approach to customer

centric approach to gain competitive advantage by combining data from

different sources. This enables the management to measure profit over time,

coverage, covered item, geographic and policy distribution channel

characteristics.

Responsibilities:

> Created and Imported/Exported various Sources, Targets, and

Transformations using Informatica Power Center Designer.

> Worked on complete SDLC from Extraction, Transformation and Loading of

data using Informatica Power Center 9.1.

> Extensively used ETL to load data from Flat files, which involved both

fixed width as well as Delimited files and also from the relational

database.

> Developed standard and re-usable mappings and mapplets using various

transformations like expression, aggregator, joiner, source qualifier,

router, lookup, and filter.

> Developed and tested all the Informatica mappings involving lookups

and update strategies.

> Extensively used workflow manager to create Tasks & Workflows.

> Created, updated and maintained ETL technical documentation.

> Successfully Implemented Slowly Changing Dimensions Used Type 1 & 2

dimension to keep the history changes.

> Extensively used workflow manager to create Tasks & Workflows.

> Used Star schema to populate data into target warehouse, using

dimensions and fact tables.

> Configuring sessions in a batch and scheduling them through

Informatica Workflow Manager.

> Mappings were designed to the utmost performance by optimizing

expressions in expression editor of transformation, filtering

source data at the source qualifier, and applying transformation

logic.

> Used Debugger to test the mappings and fix the bugs.

> Responsible for creating business solutions for Incremental and Full

loads.

> Optimizing the mappings by changing the logic to reduce run time.

Project #2:

PROJECT NAME Deluxe Inc, MN

Industry Finance

Client Private Banking Sector., USA

Duration Aug 2011 to Jul 2012

Role ETL Developer

Project Specific Skills Informatica9.1,Oracle9i, SQL,

PL/SQL, Windows NT

Team size 6

Location Offshore Team

Deluxe Corporation is a Financial Organization in US and Canada which has

products like Paper cheques, Electronic cheques, ATM and small business for

the Banks and Organizations. The data warehouse maintains the client

information like Client Name, Client Address and the details about which

programs the client has been enrolled.

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 shell 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.

> Successfully Implemented Slowly Changing Dimensions Used Type 1 & 2

dimension to keep the history changes.

> 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.

> Worked with pmcmd to interact with Informatica Server from command

mode and execute the shells scripts.

> Optimizing Query Performance, Session Performance.

> Unit and System Testing of developed mapping.

> Documentation to describe program development, logic, coding, testing,

changes and corrections.

Project #1:

PROJECT NAME Abbot Laboratories, IL

Industry Pharmaceuticals and Hospitals

Client Private Hospital Sector., USA

Duration Sep 2010 to Jul 2011

Role Trainee Cum ETL Developer

Project Specific Skills Informatica8.1,Oracle9i, SQL,

PL/SQL, Windows NT

Team size 3

Location Offshore Team

This Data Warehouse is constructed to stage the Sales & Distribution and

Inventory related data for Abbott Pharmaceuticals (Pharmaceuticals and

Hospital related products). Informatica is used to Extracting data from

source system to target systems. There are numerous sources of data coming

into the warehouse including flat files and Excel spreadsheets.

Responsibilities:

> Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping

Designer & Mapplet, and Transformation Developer.

> There were two kinds of data loading processes (Daily and Weekly)

depending on the frequency of source data.

> Imported data from various sources transformed and loaded into Data

Warehouse Targets using Informatica.

> Fixing invalid Mappings,Unit and Integration Testing of Informatica

Sessions, Batches and Target Data.

> Extensively used Transformations like Router, Aggregator, Source

Qualifier, Joiner, Expression, Aggregator and Sequence generator.

> Scheduled Sessions and Batches on the Informatica Server using

Informatica Server Manager/Workflow Manager.

> Worked with different sources such as Oracle, flat files,.

> Successfully Implemented Slowly Changing Dimensions Used Type 1 & 2

dimension to keep the history changes.

> Developed number of Complex Informatica Mappings, Mapplets and

Reusable Transformations for the Sales and Marketing Systems to

facilitate one time, Daily, Monthly and Yearly Loading of Data.

Contact this candidate