Manager Data
Resume:
Muhammad
************@*****.***
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