Data Manager

Over Eight years of experience in system analysis, development,

implementation, maintenance and support of software applications along with

excellent troubleshooting, communication and interpersonal skills

< Extensive experience with Data migration, Extraction, Transformation and

Loading of data from Multiple Sources to Data Warehouse.

< Experience in implementing complex business rules by creating reusable

transformations, developing complex Mapplets and Mappings, PL/SQL Stored

Procedure and Triggers.

< Experienced in Performance of Mapping Optimizations in Informatica.

< Extensive experience in error handling and problem fixing in Informatica

< Excellent skills in retrieving the data by writing simple/complex SQL

Queries

< Outstanding experience in using SQL, PL/SQL, Indexes, Functions,

Procedures, Packages, Triggers, Materialized Views, Pivot, Cursors and

Reference Cursors.

< Understanding in writing Test plans, Test cases, Unit testing, System

testing, Integration testing and Functional testing.

< Worked with various sources like Oracle10g, SQL Server, IBM Redbrick and

Flat files.

< Excellent Knowledge in Dimensional Data Modeling (Star Schema, Snow-

flake Schema, FACT and Dimension tables), Logical and Physical Data

Modeling using Erwin 4.2.

< Extensive experience with Data migration, Extraction, Transformation and

Loading of data from Multiple Sources to Data Warehouse.

< Experience in developing Stored Procedures, Packages & Triggers using

Oracle.

< Excellent command over developing UNIX shell scripts.

< Experienced in the Analysis, Design, Development, Testing, and

Implementation of business application systems for Pharmaceutical,

Financial, Insurance, Telecommunication and Manufacturing Sectors.

< Experienced in using the Oracle SQL*Loader & External Table features for

loading the data from Flat Files to Database tables for Bulk Loading.

< Involved in Relational database design and development of data warehouse

data feeds.

< Strong in Relational Databases (RDBMS), Data Modeling and Design and

build the Data Warehouse, Data marts using Star Schema and Snow Flake

Schema for faster and effective Querying.

< Involved in full life cycle development of Data Warehousing

< Extensive experience in developing logical and physical models &

implementing them.

< Excellent ability to quickly master new applications

TECHNICAL EXPERTISE:

Database and Oracle 11g/10g/9i/8i/7.1, Oracle Developer Suite, MS

related tools SQL Server 2000/7.0/6.5, MS Access, PL/SQL, Transact

SQL, SQL Loader, TOAD 8.5.1/7.5/6.2, sql Developer,

dBvisualize, Golden, Putty, SQL Navigator, PVCS, IBM

RedBrick, IBM DB2, Teradata, AutoSys, MS Visio, control

M, UC4

Programming: SQL, PL/SQL, Unix Shell Scripting, C/C++, Perl

ETL Tools PowerCenter 8.6/8.1/7.x/6.x/5.x, Informatica,

PowerConnect, PowerExchange and Informatica PowerMart

Operating Systems Microsoft Windows XP/NT/2000/98/95, UNIX, Mac OS X

Data Modeling Erwin 4.x/3.x

Tools

Pacific Gas & Electric (PG&E),

San Ramon, CA Feb 2010 -

Aug 2010

Sr. Programmer Analyst

Responsibilities:

< Responsible for solving complex data design and data

retrieval/integration issues. Analyzing the data model and

Identification of heterogeneous data sources

< Involved in both technical and functional applications of Relational

Databases, Data Mapping, Data management, Data transportation, and Data

Staging.

< Engaged in analysis, design, development, testing, implementation and

documentation. Preparation of Requirement Specs and Design Document

< Worked closely with business users and reporting team to optimize

performance of long running queries.

< Developed several complex Mappings, Mapplets and Reusable

Transformations to facilitate one time, Weekly, and Monthly data load

< Development and maintenance of UNIX Shell scripts, backend Packages,

Stored Procedures, Triggers, Functions in PL/SQL. Creation of Views,

Materialized Views, Indexes, Index and table partitions, Synonyms,

Database Links as per the requirements

< Responsible for data Extract, Transform & Load from Oracle, Flat files

to Data warehouse.

< Optimized the performance of Mappings, Workflows and Sessions by

identifying and eliminating bottlenecks.

< Experience loading data from sources like XML and excel files.

< Performed Independent testing on other developers work.

Environment:

Informatica PowerCenter 8.6/8.1, Oracle 11g/10g/9i, PL/SQL, Flat Files,

FTP/SFTP, Toad, sql Developer, Unix, Perl, Golden 6.0, Putty, UC4, XML,

PVCS, VPN, PPMC, BRIO,

Magellan Health Services,

Richmond, VA Oct 2009

- Jan 2010

Sr. Programmer Analyst

Responsibilities:

< Technical Lead for application rewrite. Current application is coded in

PL/SQL, rewrite using Informatica.

< Work on Informatica Power Center tools-Source analyzer, Warehouse

Designer, Mapping Designer and Transformation developer to verify the

functionality of existing PL/SQL procedures.

< Develop several complex Mappings, Mapplets and Reusable Transformations

to facilitate one time, Weekly, Monthly and Yearly data load

< Extensively use Source Qualifier Transformation to filter data at Source

level rather than at Transformation level. Created different

transformations such as Source Qualifier, Joiner, Expression,

Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy

and Sequence Generator

< Creating sessions using Workflow Manager to load the data into the Data

Warehouse.

< Create UNIX shell scripts to accomplish pre and post session tasks.

< Train ETL Team in Informatica (Development, & Maintenance)

Environment:

Informatica PowerCenter 8.1, Oracle 10g/9i, PL/SQL, SQL Server, Flat files,

Toad, Unix, Perl, Putty, Control M

CVS Caremark / Longs Drugs

Walnut Creek, CA Jan 2007 - July

2009

Sr. Programmer Analyst

Responsibilities:

< Developed several complex Mappings, Mapplets and Reusable

Transformations to facilitate one time, Weekly, Monthly and Yearly

Loading of Data

< Optimized the performance of Mappings, Workflows and Sessions by

identifying and eliminating bottlenecks

< Utilized the Aggregate, Join, Router, Look up and Update transformations

to model various standardized business processes

< Extensively used Source Qualifier Transformation to filter data at

Source level rather than at Transformation level. Created different

transformations such as Source Qualifier, Joiner, Expression,

Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy

and Sequence Generator.

< Worked with Scheduler to run the Informatica session on daily basis and

to send an email after the completion of loading

< Conducted Unit testing and Integration testing along with conducted code

walkthroughs.

< Creating sessions using Workflow Manager to load the data into the Data

Warehouse.

< Created UNIX shell scripts to accomplish pre and post session tasks.

< Uploaded the data in incremental fashion by using batches & sessions on

Informatica Server Manager

< Worked on Informatica Power Center tools-Source analyzer, Warehouse

Designer, Mapping Designer and Transformation developer to verify the

functionality of new PL/SQL procedures.

< Development and maintenance of backend Packages, Stored Procedures,

Triggers, Functions in PL/SQL. Creation of Views, Synonyms, Database

Links and UNIX Shell scripts as per the business requirements.

< Experience in using Oracle Collections, bulking techniques.

< Performed SQL Tuning using Explain Plan, Optimizer Hints, TKPROF

utility, Indexes.

< Worked on Performance tuning of data load Procedures extract from

External Tables

< Worked on tuning Oracle procedures & Packages for fast data retrieval

by creating indexes, using hints.

< Excellent knowledge of SQL*Loader, UTL_File & External tables to load

flat files to Oracle tables.

< Worked with Ref Cursors to return data to GUI.

< Knowledge of FTP and SFTP to transfer files from one box to another box

< Implemented row-level access control using Oracle's built-in row level

security (RLS) mechanism (also known as fine grained access control or

FGAC).

< Developed and updated SQL, PLSQL procedures for the UAT phase

< Worked with DBAs to port code from development to production databases

on Oracle10g.

< Provided technical support for Oracle Applications upgrade (9i to 10g)

< Worked as Production Support Personnel, involved in 24hrs Support

< Encrypted sensitive data using PGP and GPG encryption.

< Knowledge of PVCS Source Control to track code changes.

< Created Data Bridges to transfer historical and on going data to CVS

system

Environment:

Informatica PowerCenter 7.1, Oracle 10g/9i, Oracle Developer Suite, SQL,

Teradata, IBM DB2, PL/SQL, Flat files, Toad, IBM RedBrick, dBViusalizer 4,

Unix, JDK 1.4, Tomcat 5.5, Golden 5.9, Putty, Reflection, Control M

Dean Foods, Dallas, TX Aug

2005 - Jan 2007

Sales Information System

Sr. Developer

Responsibilities:

< Worked on Informatica Power Center tools-Source analyzer, Warehouse

Designer, Mapping Designer and Transformation developer

< Created necessary Repositories to handle the metadata in the ETL process

< Created the Source and Target Definitions in Informatica Power Center-

Designer

< Designed and developed Informatica Mapping for data load and data

cleansing

< Extracted, transformed data from various sources such as Flat files, MS

SQL Server and transferred data to the target data warehouse Oracle9i

and Flat files

< Used update strategy and Lookup transformation to insert, delete, update

or reject the records based on business requirements

< Designed and developed complex aggregate, join, look up transformation

rules (business rules) to generate consolidated (fact/summary) data

identified by dimensions using Informatica ETL tool

< Developed several complex Mappings, Mapplets and Reusable

Transformations to facilitate one time, Weekly, Monthly and Yearly

Loading of Data

< Utilized the Aggregate, Join, Router, Look up and Update transformations

to model various standardized business processes

< Developed the Informatica scripts in order to populate the Global

repository from the local repository

< Worked with Scheduler to run the Informatica session on daily basis and

to send an email after the completion of loading

< Conducted Unit testing and Integration testing

< Analyzed the reliability, hypothesis and restriction in documentation of

the Functional, Technical and Architecture which are confidential

< Creating sessions using Workflow Manager to load the data into the Data

Warehouse.

< Created UNIX shell scripts to accomplish pre and post session tasks.

< Engaged in analysis, design, development, testing, implementation and

documentation. Preparation of Requirement Specs and Design Document.

< Development and maintenance of UNIX Shell scripts, backend Packages,

Stored Procedures, Triggers, Functions in PL/SQL. Creation of Views,

Synonyms, Database Links as per the business requirements

< Develop outbound and inbound interfaces using PL/SQL procedures,

packages and functions in Oracle Applications

* Tuned SQL queries and PL/SQL code by profiling and reviewing code

* Developed complex queries using PL/SQL for efficient data access.

< Developed and updated SQL, PLSQL procedures for the UAT phase

< Created and/or modify Oracle stored packages, procedures, functions,

tables, indexes, etc., using PL/SQL, SQL, SQL+ and 3rd party GUI

Environment:

Oracle 9i, SQL, PL/SQL, Flat files, MS SQL Server, Informatica PowerCenter

7.x, Erwin 3.5, UNIX Shell Script, Perl,

Cenex Harvest States, Inver Grove Heights, MN May 2004 -

June 2005

Informatica Developer

Responsibilities:

. Interacted with business representatives for Need Analysis and to define

Business and Functional Specifications. Participated in the Design team

and user requirement gathering meetings and documentation.

. Involved in planning, building, and managing successful large-scale Data

Warehouse and decision support systems.

. Involved in both technical and functional applications of Relational

Databases, Data Mapping, Data management, Data transportation, Data

Staging and Client Server architecture.

. Responsible for solving complex data design and data

retrieval/integration issues. Analyzing the data model and Identification

of heterogeneous data sources.

. Developed ETLs for Data Extraction, Data Mapping and Data Conversion

using Informatica PowerMart/PowerCenter 7.1/6.2.

. Designed automated ETL procedures to transform non-relational sources to

relational data structures. Involved in regular ORACLE Developer

activities.

. Worked on Informatica PowerCenter 7.1/6.2 - Used Source Analyzer and

Warehouse designer to import the source and target database schemas and

the Mapping Designer to map the sources to the target, Mapplets and

Transformation Developer.

. Extensively used Source Qualifier Transformation to filter data at Source

level rather than at Transformation level. Created different

transformations such as Source Qualifier, Joiner, Expression, Aggregator,

Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence

Generator.

. Involved in Data Loading Sequence and Populated Data into Staging Area

and Warehouse with Business Rules. Loading data to staging area (Oracle

9i) using Informatica PowerCenter 7.1/6.2, worked with pre and post

sessions, and extracted data from Transaction System into Staging Area.

. Extensively used ETL to load data to TeradataV2R using Informatica

PowerCenter 7.1/6.2. Worked with pre and post sessions, and extracted

data from Transaction System into Staging Area.

. Extensively worked on UNIX and shell scripts.

. Uploaded the data in incremental fashion by using batches & sessions on

Informatica Server Manager.

Environment: Oracle 9.1/8i/7.3, SQL, PL/SQL, SQL*Plus, Teradata, T-SQL,

ERwin, TOAD, Informatica Powercenter 7.1/6.2, Unix Shell Script, Windows

2000/NT

Meridian Bank, UK July

2002 - Dec 2003

Bank Loan System

ETL Developer

Responsibilities:

< Responsible for Extracting, Transforming and Loading data from Oracle,

Flat files And placing it into Data warehouse

< Design, Development and Testing of Mappings, Mapplets using informatica

PowerCenter 5.1.

< Worked on Informatica tool Source Analyzer, Data warehousing designer,

Mapping Designer & Mapplet, and Transformations.

< Created Informatica mappings to build business rules to load data. Most

of the transformations were used like the Source qualifier, Aggregators,

lookups, Filters & Sequence.

< Configured Repository Manager, created folders and managed objects in

repository manager of Informatica. Assigned Permissions and Privileges

to Objects.

Environment: Oracle 8.0, SQL, PL/SQL, TOAD, Informatica (PowerCenter 5.1)

and UNIX

British Telecom, London, UK June 2001 - May

2002

One View Analytics

Responsibilities:

< Designing LLD's, developing mappings, preparing Data Quality documents

for Unit Testing.

< Developing ETL mappings in Informatica taking care of functionality.

< Creation of new workflows and sessions in Informatica Server Manager to

incorporate the new mappings into the Full and Incremental loads.

< Performed Unit Testing of the reports.

< Taking the backup of repository on regular intervals depending on the

amount of work done.

< Created the mappings using transformations such as the Source qualifier,

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

< Designed and developed ETL process using Informatica.

< Configuring ETL tasks, Tables, Table groups, Subject Areas, Their

Dependencies sources & Targets.

< Monitoring Incremental & Full load through DAC.

< Maintaining the loads of Full and Incremental through DAC on different

environments like Development and Test environment.

< Importing the metadata tables from the database to the Siebel Analytics

Physical Layer.

< Creating the Logical and Physical joins in Business Layer.

< Creating hierarchies and new logical columns as per the business

requirements.

< Creating the Interactive Dashboards, Pages and the requests.

< Performing the unit testing and reviewing the test cases.

Environment: Oracle 8.0, SQL, PL/SQL, Toad, Flat files, Windows 2000,

Informatica 5.1, Unix

Contact this candidate