Muhammad

ab3b10@r.postjobfree.com

248-***-****

PROFESSIONAL SUMMARY

7+ years of strong Data Warehousing experience using Informatica

PowerCenter 9.x/8.x/7.x

. Extensive knowledge in Banking, Insurance, Energy, Manufacturing and

Healthcare domains

. Experienced in complete life cycle Implementation of data warehouse.

. Excellent capabilities in integration mappings including dynamic cache

lookup, shared, and persistence mappings for Type I, Type II, Type III

slowly changing dimensions.

. Experience in implementing update strategies, incremental loads and

change Data capture.

. Developed mapping and workflows with parameters and variables.

. Developed Complex mappings from varied transformation logics like

Unconnected /Connected lookups, Router, Filter, Expression,

Aggregator, Joiner, Union, Update Strategy and more.

. Experience in creating Reusable Transformations (Joiner, Sorter,

Aggregator, Expression, Lookup, Router, Filter, Update Strategy,

Sequence Generator, Normalizer and Rank) and Mappings using

Informatica Designer and processing tasks using Workflow Manager to

move data from multiple sources into targets.

. Hands on experience working with various databases including Oracle,

SQL Server, Sybase, DB2.

. Exposure to Data modeling using Dimensional Data Modeling techniques

like Star Schema Modeling, Snowflake Modeling.

. Very strong in writing SQL Joins, Nested Queries, Unions, Multi-

table joins.

. Implemented Slowly Changing Dimension methodology for accessing the

full history of accounts and transaction information.

. Experience in identifying Bottlenecks in ETL Processes, improving the

Performance of the production applications using Database Tuning,

Partitioning, Index Usage, Aggregate Tables, and Normalization /

Denormalization strategies.

. Scheduling jobs using Tidal, Autosys.

. Experienced in database development using PL/SQL stored

procedures/packages, Functions, Triggers, Synonyms and all type of

Oracle Objects

. Strong Knowledge in Relational Database Concepts, Entity Relation

Diagrams, Normalization and De normalization Concepts.

. Expertise in using UNIX and executing UNIX shell scripts.

Databases SQL Server 2008/2005/, Oracle 11g/10g/9i, DB2

DB interface Tools Sql Server Management Studio, TOAD, SQL*PLUS, SQL

Developer, SQL Assistant, PL/SQL

ETL Tools Informatica PowerCcenter 9.x/8.x/7.x/6.x

Operating Systems Windows XP/2000/Win 7,Win NT, AIX, Red Hat Linux,

Solaris

TECHNICAL SKILLS

WORK EXPERIENCE

Coventry Health Care, Richmond, VA

Feb 2012- Till Date

ETL Developer

Project Description: Coventry Healthcare is an experienced health insurance

company in the state, providing people with comprehensive and affordable

health plans and publicly funded healthcare programs. It provides group

health plan members and their dependents with secure online access to

benefits summaries, claim status, provider information and valuable health

tips. It had a considerable amount of information and had to face many

problems eg: quality of data, missing codes, heterogeneous sources,

frequent updates for a large amount of information.

Responsibilities:

. Involved in complete understanding of business requirement and

involved in analyzing the sources to load data in target database.

. Involved in design, development and testing phases of ETL.

. Developed Complex transformations, Mapplets using Informatica to

Extract, Transform and load data into Datamarts, Enterprise Data

warehouse (EDW) and Operational data store (ODS).

. Developed Mappings Involving Type 2 and Type 1 slowly changing

dimensions.

. Created mappings using Lookup transformation, Parameter and Variable

for Incremental Data load to fact tables.

. Make changes in existing mapping when business requirements change.

. Fixed bugs in existing mapping if there is a data quality issue,

missing values.

. Created and Configured Workflows, Worklets, and Sessions to transport

the data to target warehouse tables using Informatica Workflow

Manager.

. Created various tasks like Event Wait, Event Raise, Decision, e-mail.

. Used session logs, workflow logs and debugger to debug the session and

analyze the problem associated with the mappings and generic scripts.

. Autosys was used to schedule the job whenever it was needed.

. Addressing the production failures as and when necessary.

. Migrated Mappings, Sessions and Common Objects from Development to

Test and to Production.

. Close coordination with various functional teams and DBAs to perform

assigned duties.

. Working closely with the offshore team to meet the requirements as per

the schedules.

Environment: Informatica 9.1, SQL assistant, Oracle 10g, SQL server 2008

R2, UNIX, Toad, Putty, Agile methodology

Ameren Energy Corp, St. Louis, MO

Nov 2010 - Jan 2012

Informatica Developer

Project Description: The Data Warehouse Project took the database of its

customers as its prime database. This project had Oracle and flat files as

sources and Oracle was the warehouse database. CRM data mart was built from

the warehouse. The modern trends of data warehousing and relational

database management were methodically adopted for developing an efficient

query and reporting system. The resulting improvements in product quality

will translate directly to increased customer satisfaction, significantly

and improved profit margins.

Responsibilities:

. Emphasis on identifying the source and source data validation,

developing particular logic and transformation as per the requirement

and creating mappings and loading the data into different targets.

. Interacted with business representatives for Need Analysis and to

define Business and Functional Specification

. Created mappings that involved transformations like Lookup,

Normalizer, Aggregator, Expression, Update Strategy, Filter, Router,

Joiner, Sorter, XML parser, Union transformations.

. Worked on different data sources like Relational Tables, Flat Files

and XML Files.

. Created user defined functions for reusability.

. Used SQL overrides in source qualifiers with appropriate schema names

for extracting only the required rows for optimal performance.

. Created Parameters and Variables for incremental loading.

. Tested the queries thoroughly for integrity and identifying data

errors.

. Used Debugger to test the mapping and data.

. Designed Source to Target Mapping specification Documents.

. Worked on Repository Manager to create and manage user profiles.

. Worked with Oracle SQL Developer to analyze and test the target data.

. Provided my inputs to Informatica administrator, DBAs, and network

team when there is a bottleneck/performance issue.

. Handled issues when the files were late on FTP servers.

Environment: Informatica 8.6, SQL server 2008, MS Visio, Windows, SQL

server, Oracle, UNIX.

Hospira Inc., Lake Forest, IL

Jun 2009 - Nov 2010

ETL /Informatica Developer

Hospira Inc. is the world's leading provider of injectable drugs and

infusion technologies.

Project Description: The project was to build a data warehouse for

operational and strategic reporting. The project was to design, develop and

maintain Enterprise data warehouse. The objective is to integrate different

source systems into homogeneous environment to build Enterprise Data

Warehouse. The goal of the project is to achieve better decision making

with appropriate data views.

Responsibilities:

. Interpreted logical and physical data models for Business users to

determine common data definitions and establish referential integrity

of the system.

. Used ETL Technical Specification Document in Informatica to develop

mappings as per requirements.

. Analyzed the sources, transformed the data, mapped the data and loaded

the data into targets using PowerCenter tool

. Created Mappings on Star Schema methodology.

. Used unconnected lookup for populating date-time entered field in the

target tables.

. Involved in Data transfer from several OLTP systems to the DWH.

. Executed Oracle PL/SQL Procedures and shell scripts.

. Created mapping that stores historical data.

. Used stored procedures that would kick start the Informatica workflows

when the source files are available on the FTP servers.

. Created reusable Sessions and Commands in the Workflow Manager.

. Involved in performance tuning of the process at mapping, session,

source level and at target level.

Environment: Informatica 8.6, Oracle 10g, TOAD, UNIX shell scripts, SQL

Server 2008

Houlihan Lockey, Chicago, IL

Aug 2008 - May 2009

ETL Developer

Houlihan Lokey is a global investment bank, provides M&A, Capital Markets,

Financial Restructuring, and Financial Advisory services.

Project Description: This project involves design, development and testing

of scripts and Informatica mappings. As part of the development, the ETL

process loads data from the source files to Staging Area which will be

logically separate from the target database. The staging area was in Oracle

database and has table structures as replica of the source files. While

loading data from source to staging basic validation checks on source files

are done. Based on this loaded data the reports are developed and delivered

to the client.

Responsibilities:

. Worked on Top down data warehouse architecture environment.

. Developed mappings and workflows using Informatica power center 8.1.

. Involved in design, development, testing phases of ETL

. Defined Target Load Order Plan for loading data into different Target

Tables.

. Implemented Slowly Changing Dimensions Type II for the Change Data

Capture Process

. Conducted Performance Testing of the Mappings and Performance tuning

with Informatica tool

. Used Autosys on HP UNIX to schedule Informatica jobs.

. Used TOAD for to analyze the data.

. Analyzed Session Log files in case the session fails in order to

resolve errors in mapping or session configurations. Designed and

developed end-to-end ETL process from various source systems to

Staging area, from staging to DWH.

Environment: Informatica 8.1, UNIX, Cognos, TOAD, Oracle 10g

Lake Trust Credit Union, Detroit, MI

Apr 2007- Jul 2008

ETL Developer

Project description: Company provides a complete range of financial

services and products, from personal banking to investment to corporate

financing. The Sales Data Warehouse is for analyzing customers and their

transactions, accounts, balances, payments, funds transfer between accounts

of its customers and also between this bank and other institutions. This

project is developed for Sales & Marketing and Finance Departments to

assist them in their business analysis.

Responsibilities:

. Involved in creating end to end ETL process using Informatica power

Center tools.

. Used workflow Manager for Creating, Validating, Testing and Running

the sequential and concurrent Batches and Sessions, and scheduled them

to run at a specified time.

. Modify existing mappings as per new requirements.

. Implemented slowly changing dimension Type 1 and Type 2 for Change

data capture.

. Debugged the mappings using Debugger

. Created reusable transformations and mapplets based on the business

rules to ease the development

. Responsible for Defining Mapping parameters and variables and Session

parameters according to the requirements and performance related

issues.

. Created various tasks like Event wait, Event Raise and E-mail

. Tested and validated the mappings.

Environment: Informatica 8.1, Oracle 9i, SQL*Plus, UNIX Shell Scripts,

Sun Solaris, TOAD

Grange Insurance, Columbus, OH

Sep 2006-Mar 2007

Informatica Developer/ Consultant

Project description: This project is aimed at the implementation of Top -

down data warehouse Architecture. Data of various OLTP's was extracted from

mainframe using Eztrieves and converted to flat files and finally loaded

the data into the oracle database using ETL process as per the business

requirements.

Responsibilities:

. Involved in requirements analysis, process design, data design,

development, testing and implementation of Data warehouse load

processes and Data transformation processes.

. Implemented CDC in oracle databases to capture latest updates from

source to destination.

. Extensively worked on Informatica Power Center - Designer, Workflow

Manager and Workflow Monitor.

. Created Technical Specification documents using MS Visio and

maintained technical specification documents throughout development

lifecycle.

. Extensively used ETL processes to load data from various source

systems such as Oracle, Sybase, Flat Files and XML into the target

Oracle database by applying business logic on transformation mapping

for inserting and updating records when loaded.

. Extensively used Informatica Workflow Manager and Workflow Monitor to

develop, manage and monitor workflows and sessions.

. Extensively worked in the performance tuning of the programs, ETL

Procedures and processes.

Environment: Informatica Power Center 7.1 MS Visio, Oracle 9i, Sybase, SQL,

PL/SQL, Flat Files, XML, UNIX

Contact this candidate