Manager Data

Amit Verma

847-***-**** (Cell)

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

Summary of Experience:

. About 6 years of extensive experience in Information Technology SDLC

(Software Development Life Cycle) with a strong background in Database

development and Data warehousing and more than five years of experience

in Data Integration, Migration and ETL process using Informatica Power

Center 8.x/7.x/6.x/5.x.

. Good knowledge of Data warehouse concepts and principles (Kimball/Inman)

- Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De

normalization.

. Experience in integration of various Operational Data Source(ODS)s with

Multiple Relational Databases like Oracle, SQL Server and Worked on

integrating data from flat files like fixed width and delimited.

. Have extensively worked in developing ETL for supporting Data Extraction,

transformations and loading using Informatica Power Center.

. Experienced in integration of various data sources like DB2, Mainframes,

SQL server, Teradata, Oracle and flat files into EDW and datamarts.

. Knowledge of Advanced Programming for data transformation (JAVA, C++, C).

. Well acquainted with Informatica Designer Components - Source Analyzer,

Warehouse Designer, Transformation Developer, Mapplet and Mapping

Designer.

. Worked extensively with complex mappings using different transformations

like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union,

Unconnected / Connected Lookups and Aggregators.

. Strong Experience in developing Sessions/tasks, Worklets, Workflows using

Workflow Manager Tools - Task Developer, Workflow & Worklet Designer

. Experience in using the Informatica command line utilities like pmcmd to

execute workflows in non-windows environments.

. Experience in designing and developing the Informatica IDQ environment.

. Extensively used Informatica Repository Manager and Workflow Monitor.

. Experience in debugging mappings, Identified bugs in existing mappings by

analyzing the data flow and evaluating transformations.

. Hands on experience in Performance Tuning of sources, targets,

transformations and sessions.

. Worked with Stored Procedures, Triggers, Cursors, Indexes and Functions.

. Strong Knowledge in optimizing database performance.

. Experience in UNIX shell scripting, CRON, FTP and file management in

various UNIX environments.

. Good experience in SIT - System Integration Testing - post integration of

all the modules/components of the application and UAT - User Acceptance

Testing to verify whether the business requirements have been met.

. Highly Motivated to take independent responsibility as well as ability to

contribute and be a productive team member

Education: Bachelor's degree in Computer Science.

Technical Skills:

ETL Tools Informatica 8.x/7.x/6.x/5.x (Power Center/Power

Mart/Power Exchange) (Designer, Workflow

Manager, Workflow Monitor, Server Manager, Power

Connect), IDE and IDQ

Data Modeling Erwin 4.0/3.5, Star Schema Modelling, Snow Flake

Modelling

Databases Oracle 11g/10g/9i/8i, MS SQL Server 2005/2000,

DB2, MySQL, Sybase

OLAP Tools Cognos 7.0/6.0, Business Objects XI R2, SSRS,

SAS

Languages T-SQL, PL/SQL,Perl, Unix Shell Script, Visual

Basic, COBOL, XML

Tools MS Visio, Toad, SQL* Loader, Autosys, UC4,

TWS(Tivoli)

Operating Systems Windows 2003/2000/NT, AIX, Sun Solaris, UNIX,

Linux

Work Experience:

Client: Abbott Vascular Devices, Red Wood City, CA

Jan 2010 - Till Date

Position: Sr. Informatica Developer

Responsibilities:

. Extracting and loading of data from flat file, Oracle sources to

oracle database (target

warehouse) using transformations in the mappings.

. Used Erwin for data modeling.

. Extensively used Router, Lookup, Aggregator, Expression, Sequence

Generator and

. Update Strategy Transformations.

. Created Pre and Post Session Scripts for checking file existence.

. Created the worklets as per the business requirements and also

integrated all the worklets into a single workflow.

. Profiled customer data and identified various patterns of the phone

numbers to be included in IDQ plans.

. Used Built in Informatica Scheduler to schedule the process on a daily

basis.

. Improved the performance of sources, targets, mappings and sessions

considerably.

. Performed Unit testing and Integration testing on the mappings and

documented the entire ETL process.

. Created stored procedures using PL/SQL and implementing them through

Stored Procedure Transformation.

. Setting of Error Logic for streamlining and automating the data loads

for cleansing and

trapping incorrect data on staging servers and then loading it to the

Oracle 8i data warehouse.

. Analysis of certain existing mappings, which were producing errors and

modifying them to produce correct results.

. Created and developed a series of mappings for handling different

cases of input data in the same source table.

. Created PL/SQL procedure producing flat files on a different server

and using this flat file as a source to an Informatica mapping.

. Development of a template to be used as a Mapping Specification

Document.

. Used Reject Loading utility of Informatica to load rejected data.

. Created ad-hoc reports in query studio and custom reports in Report

Studio to meet different user's requirements.

. Created various drill through reports from report to report.

. Created calculated columns into the report to display dynamic values

as well as summary

calculation.

Environment: Informatica PowerCenter 8.1, MS Visio, Erwin, Oracle 11i,

PL/SQL, UNIX, Win NT, IDQ, Cognos 8 (Report Studio, Query Studio, Framework

Manager and Connection).

Client: ALD Automotive, WI

Feb 2009 - Nov 2009

Position: Sr. Informatica Developer

Responsibilities:

. Worked closely with business analysts to understand the requirements,

needs, technical

metadata and use cases for Synchronization of data.

. Involved in functional and technical ETL design specifications as per

requirements. Worked with data modeler to design and develop

Dimensional modeling using Erwin 4.2.

. Used Informatica 8.1 to extract, transform and load data from multiple

input sources like XML, Flat files and loading into Oracle.

. Created Complex mappings in Powercenter Designer using Lookup,

Aggregate, Expression, Joiner, Sequence generator, Sorter, Filter,

Router, Update Strategy and Normalizer transformations for populating

target table in efficient manner. Implemented slowly changing

dimensions (Type II) using date-time stamping.

. Profiled customer data and identified various patterns of the phone

numbers to be included in IDQ plans.

. Used pmcmd utility to create and control workflows tasks and sessions.

. Developed and Implemented UNIX shell scripts and scheduled different

Informatica jobs using AutoSys. Monitored sessions that were

scheduled, running, completed or failed.

. Configured and used Debugger to troubleshoot mappings.

. Performed extensive performance tuning by determining bottlenecks at

various points like targets, sources, mappings, sessions or system.

. Wrote SQL scripts, PL/SQL stored procedures, functions and triggers

for implementing business rules and transformations. Also involved in

query optimization.

. Performed migration of Informatica 7.1 to 8.1.

. Production support and Bug fixing.

. Communicating with Offshore teams and resolving development and

testing issues.

. Involved in preparing test cases, test plans and test data.

. Performed Unit testing and Integration testing on the mappings. Worked

with QA Team to resolve QA issues.

. Involved in Code reviews, gap analysis and prepared technical

documentations as per

standards.

Environment: Informatica PowerCenter 8.1/7.1, Oracle 10g R2, SQL, PL/SQL,

XML Spy, Erwin 4.2, TOAD 6.3, IDQ, RUP, Windows NT and UNIX(HP), Cognos 8.

Client: Alltel Communication, Little Rock, AR

Jul 2007 - Dec 2008

Position: Data Warehouse/Informatica Developer

Responsibilities:

. Worked closely with business analysts to understand and document

business needs for decision support data.

. Worked on Dimensional modeling to Design and develop STAR Schemas,

used ER-win 4.0, identifying Fact and Dimension Tables.

. Assisted the team in the development of design standards and codes for

effective ETL

procedure development and implementation.

. Extensively used Flat files and Oracle Sources. Imported various

heterogeneous and

homogenous sources using Informatica source analyzer.

. Creating mappings and different kind of transformations like Source

qualifier, Aggregators, lookups, Filters, Sequence, Stored Procedure

and Update strategy. Created and used Reusable Transformations and

Mapplets to improve maintainability of the mappings.

. Created, launched & scheduled tasks/sessions. Setting up tasks to

schedule the loads at

required frequency using PowerCenter. Configured email notification.

. Created BT Queries in Teradata. Worked on M-load, Fast-load and T-pump

loading to

. migrate data from Oracle to Teradata.

. Performed developing & testing of Informatica mappings, workflows and

sessions.

. Participated in testing in preparation of test plans and test cases to

ensure the requirements are testable.

. Involved in extensive Performance Tuning by determining bottlenecks at

various points like targets, sources, mappings and sessions.

. Developed Universes using Business Objects Designer - Universe

Methodology involving the creation of underlying database structure,

resolving the loops, creating classes and Objects, conditions and

joins and finally testing the integrity of the Universe.

. Designed and developed extensive Business Objects reports like

Master/Detail, Cross Tab using multiple queries, Prompts, Combination

chart and tables.

Environment: Informatica PowerCenter 7.1, Oracle 9i, Teradata V2R5.0,

Business Objects 6.5, SQL, PL/SQL, TOAD, PVCS Tracker, UNIX.

Client: Sankyo Pharma, Parsippany, NJ

Apr 2006 - Jun 2007

Position: Informatica Developer

Responsibilities:

. Worked with the Business analysts and the DBA for requirements

gathering and project

co-ordination.

. Performed extraction, transformation and loading of data from

different sources like Flat Files, SQL Server, Sybase tables into

Oracle in accordance with requirements and specifications.

. Extensively used various transformations Lookup, Update Strategy,

Expression,

. Aggregator, Filter, Stored Procedures and Joiner etc in Powercenter

designer to develop various mappings.

. Used Debugger to debug the mappings. Examined sessions, event, and

error logs and analyzed for trouble shooting mappings and sessions.

. Performed Unit Testing and tuned the mappings for better performance.

. Extensively used SQL*Loader to load data from flat files to database

tables in Oracle.

. Used Workflow manager for session management, database connection

management and scheduling of jobs to be run in the batch process.

. Configuring sessions in a batch and scheduling them through Autosys

job scheduler.

. Documentation of existing mappings as per standards.

Environment: Informatica PowerCenter 6.1, Erwin, Oracle 8i, SQL Server

2000, Windows NT, Flat files, Sybase, SQL, PL/SQL, SQL*Loader, UC4, PVCS,

UNIX, UNIX Shell Scripts.

Client: CNA Insurance, Edison, NJ

May 2005 - Mar 2006

Position: ETL Developer

Responsibilities:

. Worked closely with Development managers to evaluate the overall

project timeline.

. Performed ER Modeling using Oracle designer. Closely worked with DBA

to implant the

model.

. Involved in converting data stored in Mainframes, COBOL files and DB2

tables into Oracle using PowerCenter.

. Actively contributed in framing the Data Warehouse SDLC standards,

methodologies and best practices.

. Worked on Informatica PowerCenter tools- Mapping Designer, Repository

Manager,

Workflow Manager and Workflow Monitor.

. Developed the Informatica Mappings by usage of Aggregator, SQL

overrides usage in

Lookups, source filter usage in Source qualifiers, and data flow

management into multiple targets using Router.

. Used various transformations like Filter, Normalizer, Expression,

Sequence Generator, Update Strategy, Lookup, Router and Aggregator to

create robust mappings in the Informatica PowerCenter Designer.

. Mapplets and Reusable Transformations were used to prevent redundancy

of transformation usage and maintainability.

. Scheduling the session task's comprising of different mappings for

data conversion and

extraction in order to load data into target database.

. Migrated mappings, sessions, and workflows from Development to testing

and then to

Production environments.

. Monitor; troubleshoot batches and sessions for weekly and Monthly

extracts from various data sources across all platforms to the target

database.

. Tuned performance of Informatica session for large data files by

increasing block size, data cache size and target based commit

interval.

. Involved in tuning the mappings and SQL Query to perform maximum

efficiency.

. Involved in ad-hoc query and reporting using Brio 8.

Environment: Informatica PowerCenter 6, Oracle 8i, PL/SQL, DB2, XML, COBOL,

UNIX, Windows NT, Brio 8.

Client: Alcatel Research & Innovations, France (Final Client)/ Bangalore,

India

Oct 2004 - Mar 2005

Position: Oracle Developer

Responsibilities:

. Estimating Table sizes, Table spaces. Identifying integrity

constraints for tables.

. Performance monitoring and tuning of Oracle database servers.

. Wrote Database Triggers. Analyzing tables and indexes for performance

tuning.

Optimizing database objects and streamlining applications.

. Creation, maintenance, backups and restoration of databases.

. Creation of logins and user ids and setting up privileges and

procedures for protection of data.

. Job responsibilities include developing on-line screens using SQL

Forms, creating database objects like tables, indexes, views etc.

using SQL Plus, import and export of data using SQL Loader.

. Reports were developed using Oracle Reports 2.5.

. Worked on Informatica PowerCenter tools- Mapping Designer, Repository

Manager,

Workflow Manager and Workflow Monitor.

. Performed extraction, transformation and loading of data from RDBMS

tables and Flat File sources.

. Developed the Informatica Mappings by using various transformations

like Filter, Expression, Sequence Generator, Update Strategy, Lookup,

Router and Aggregator to create robust mappings in the Informatica

PowerCenter Designer.

Environment: Oracle 8.x, Informatica Powercenter 5.1, Developer 2000, SQL

Forms 4.5, SQL plus, SQL Loader, Import/Export, Oracle Reports 2.5,

Designer2000, PL/SQL.

Contact this candidate