Datastage Developer

Synopsis: Having around * years of experience in Dataware housing

development and maintenance projects Primarily used datastage as ETL tool

.Have worked in Design, Development and testing phases of SDLC. Have good

successful rate in tuning ETL codes both in datastage and SQL.

EXPERIENCE SUMMARY

Have 6 years of experience in DW software development and Maintainence

projects

> Have good development and implementation experience in Dataware

housing projects using Datastage 8.X(server and Parallel) and SQL

codes

> Have strong experience in creating and testing parallel jobs in

datastage 8.X versions

> Have good experience in creating and testing server jobs

> Have strong knowledge in designing sequencer and reusable objects in

datastage environment

> Have Strong knowledge in using SCD stage to implement SCD2 dimension

> Have good knowledge in tuning Oracle SQL's

> Have involved in Unit testing and system testing as part of my project

> Have good understanding of data warehousing concepts.

QUALIFICATION

Degree Institute Grade

P.R Engineering college / 8.4

BE(ECE) Anna University

St. Isabels Girls Higher 8.7

XII Secondary School

St. Isabels Girls Higher 8.7

X Secondary School

WORK EXPERIENCE

Project Name : Electronic Data Interchange(EDI)

Role : Team Lead

Environment : SQL Server 2008 R2,Windows server

2008

Duration : Jan 2012 to Aug 2013

Tools Used : IBM Web sphere Data stage 8.5,IBM IS

Manager

Description: A Health care client migrating 3 of its existing legacy

operation systems to a common ICS platform. The Eligibility and Claims

files that are currently sent by the legacy platforms to external trading

partners need to be re-created from the ICE environment.

Datastage 8.5 is used to create claims and Eligibility file for external

trading partners which are essential data for the end users to get their

Medical insurance claims. All the member details and their insurance

eligibility are captured from the ICE Environment and sent as Universal

standard 834 files and vendor specific proprietary files to trading

partners

Roles and Responsibilities:

> Verifying the existing As400 code with the requirements from business

users and Making the final version of requirement document and walk

through with business

> Creating design document for Datastage process

> Developing datastage jobs and sequencers specific to the requirement

> Preparing unit test cases for the developed objects

> Supporting UAT for the project and ensuring error free code for

production

> Supporting production issues

> Responsible for the maintain the version of jobs and building packages

through IBM IS Manager during Job deployment

> Preparing release notes for the deployment

Achievements:

. Created Framework for EDI834 jobs because of this development time for a

single 834 file reduced from 7 days to 2 days

Project Name : Performance Management

Information(PMI)

Role : Team Lead

Environment : AIX UNIX, Oracle 10g

Duration : Oct 2011 to Jan 2012

Tools Used : IBM Web sphere Data stage 8.5

Description: PMI(Performance management index) is a vital tool and a single

window for the accounting team to get to know about the performance of bank

in terms of revenue, Transaction volume etc and with the provision of

viewing risk associated with that asset against the revenue generated by

the same. It also provides information on the revenue generated by each

sales person across geographies and in turn helps in assessing the

performance of sales persons. As part of this project,Datastage and SQL is

used as ETL tool to collect data across various sources and loading the

same into oracle database with Business transformation applied to it. OBIEE

is the reporting tool which delivers user with a a full range of analysis

and reporting capabilities

Roles and Responsibilities:

> Understanding the Change request for existing functionality in production

from business Analysts

> Creating design document as per the business requirement

> Developing datastage jobs and Modifying existing jobs specific to the

requirment

> Preparing unit test cases for the developed objects

> Analyzing the reporting requirements and creating objects in datamart

layer which aids reporting query performance

> Supporting system testing for the project and ensuring error free code

for delivery

> Responsible for the maintain the version of jobs and building packages

through IBM IS Manager during Job deployment

> Preparing release notes for the deployment

Achievements:

. Tuned SQL code to bring down the execution time from 4 Hours to 15

minutes for number of jobs in a process which significantly reduced the

load time from 28 hours to 7 Hours

. Recreated existing object as reusable objects which significantly reduces

the job count in repository and helped in maintenance

Project Name : Customer link

Role : Team Lead

Environment : Datastage 8.5, Oracle 10g,UNIX

Duration : July 2010 to Sep 2011.

Tools Used : Toad,Sql Developer,CVS

Description: This Project is about implenting two tasks, one is building

an operational data store for a web application which will be used by

Pfizer Field force exclusively for customer related tasks and the second

one is to keep the newly created Operational data store and existing

Operational data store in sync

Roles and Responsibilities:

> Design and Development of Data Stage job and PL/SQL Codes as per

requirements.

> Validation script preparation.

> Preparing unit test cases for the developed objects

> Supported system testing and UAT

> Checking the codes into CVS(Version control system)

> Preparing release notes for the deployment

Project Name : European customer

Role : Team Lead

Environment : Datastage 7.5, Oracle 10g,UNIX

Duration : Dec 2009 to Jun 2010

Tools Used : Toad,Sql Developer,CVS

Description: This Project will derive European customer specialty and type

for all Oncology and specialty customer as per their local attributes and

load the data in a Datamart layer which will be used by Cognos reporting

.This project is done to improve the performance of cognos reporting.

Role and Responsibilities:

> Preparation of requirements specification

> Preparation of ETL mapping document and Technical Design

document.

> DB Script preparation

> Developing oracle objects and user interface in apex

> Guiding team members in jobs development.

> Review of Datastage jobs, test cases and logs.

> Preparation of Deployment document and SOP.

> Maintaining the DS jobs and oracle objects version.

Project Name : UK Supply Monitoring

Role : Team Lead

Environment : Datastage 7.5, Oracle 10g,UNIX

Duration : Mar2008 to Dec 2009.

Tools Used : Toad,Sql Developer,CVS

Description: The client's medicines are increasingly being targeted by

Traders for wholesaling and "selling on", rather than for direct dispensing

to the patients of the pharmacies they have been sold to. This project will

list the customers who fall in the above mentioned category.

Role and Responsibilities:

> Preparation of requirements specification

> Preparation of ETL mapping document and Technical Design document.

> DB Script preparation

> Developing oracle objects and Datastage jobs

> Guiding team members in jobs development.

> Review of Data stage jobs, test cases and logs.

> Preparation of Deployment document and SOP.

> Maintaining the Ds jobs and oracle objects version.

Project Name : Global Budget Forecasting

Role : Team Member

Environment : Datastage 7.5, Oracle 10g,UNIX

Duration : July 2007 to Mar 2008.

Tools Used : Toad,Sql Developer,CVS

Description: Global Budget Forecast, as its name suggests will help in

budget forecasting process. Lat two years sales data at national level (for

countries involved in GBF roll out) in EDW/EDMR will be aggregated for the

Pfizer products and competitors as requested by the countries.

The data will be provided by individual country and/or country data

provider and loaded in to the EDW Atomic layer and subsequently extracted,

transformed and loaded in to the Data Mart. The transformed data will be

exposed through views in Data Mart and GBF team shall extract data directly

from the views.

Role and Responsibilities:

> Interacting with onsite counterpart for requirement analysis and

design

> Developing Datastage Jobs

> Developing Materialized views,tables and other oracle objects

> Developing user Interface in APEX(Oracle GUI)

> Performance tuning

> Developing Deployment Scripts and doing Test deployment

Project Name : KPI(Key Performance Indicator)

Role : Team Member

Environment : Datastage 7.5, Oracle 10g,UNIX

Duration : Feb 2007 to June 2007.

Tools Used : Toad,Sql Developer,CVS

Description: KPI is used to measure the effectiveness of Pfizer field force

and this project will calculate KPI for 23 countries (EUROPE and CANADA)

and store it in a new data mart layer. This KPI value will aid Pfizer in

understanding their current market across business units and making some

strategic decisions in order to promote their products.

Role and Responsibilities:

> Interacting with onsite counterpart for requirement analysis and

design

> Developing Datastage Jobs

> Developing Materialized views,tables and other oracle objects

> Developing user Interface in APEX(Oracle GUI)

> Performance tuning

> Developing Deployment Scripts and doing Test deployment

Contact this candidate