Bhanu Gudipalli

214-***-**** x ***

acphgy@r.postjobfree.com / acphgy@r.postjobfree.com

OVERVIEW

• 8+ years of IT experience in all phases of software development life cycle which

includes analysis, designing, implementation and testing of client/server

applications

• Strong experience on Extraction, Transformation and Loading (ETL) processes

from various sources into Data Warehouse/ Data Marts using Ascential DataStage

8.5/8.1/7.5.1/7.0 (Manager, Designer, Administrator and Director)

• Extensive experience in Data Integration of various data sources like Oracle,

Cobol, flat files, XML files, SQL Server, DB2

• Extensive knowledge in authoring project documents like Unit Test document,

System test Integration test document, ETL Specification document, System design

document, Data sharing agreement document, STM(Source to Target Mapping)

document

• Good experience in building DataStage jobs and sequences

• Experience in UNIX Shell scripting as part of data and file manipulation

• Experience in the Performance Tuning and Optimization of the Data stage Parallel

jobs

• Solid understanding of Star schema, Snow-Flake Schema, Normalization, Physical

and Logical data modeling using Erwin

• Highly driven and self-motivated with sound business judgment and strong work

ethics and Excellent interpersonal and communication skills

• Problem-solving mindset focusing on providing sustainable and flexible solutions to

the customers

• Customer-focus

SKILLS SET

• OPERATING SYSTEMS : UNIX, Windows 2000/2003/NT, Linux and Windows-

DOS

• DATAWAREHOUSE : Data Marts, OLTP, OLAP, Facts, Dimensions, Star

schema,

Snow Flake Schema, slowly changing

dimensions

• ETL Tools : Ascential Data Stage ( 7.5, 8.0, 8.1, 8.5 )

• REPORTING TOOLS : Cognos Report Net, Business Objects

• DATABASES : SQL Server, Oracle, DB2

• Programming Languages : SQL, PL/SQL, Shell Scripting, C,C++,Java

• Data Modeling Tools : Erwin

• Tools : TOAD 8.0, Win SQL, SQL Developer,AQT

• Scheduling Tools : Autosys, Crontab, Control-M

• Ascential Datastage(v8.0) Certified in 2010

EXPERIENCE

Client : TIAA - CREF

Role : Senior Datastage Developer

Duration : MAY 2014 to current

The Enterprise Staging Platform is envisioned as a central staging platform for Enterprise usage to house all

System of Records (SOR’s) data from different Line of Business (LOB’s). ESP platform supports data

acquisition in various formats including but not limited to Flat files, XMLs and Relational databases.

Responsibilities:

• Part of ESP development team which developed generic code using various functionalities of

Datastage, Unix and Oracle

• Developed generic jobs and sequences in Datastage

• Staged about four SORs from source to ESP platform

• Created views for tables that had company’s PII data

• worked on error framework jobs that validates the metadata with that of the SOR COBOL layout and

report the erroneous records

• Implemented Datastage grid general principles to achieve best performance

• Having exposure in scheduling Datastage jobs in Autosys

• Supported production team in issues for the SORs that have been staged in ESP platform

• Developed generic unix scripts for ESP

Client : GENERAL MOTORS GS20, MICHIGAN

Role : Datastage Developer

Duration : FEB 2012 – APRIL 2014

Responsibilities:

• Developed and designed code for the enhancements/requirements of a module in GSC 20

• In charge of collecting and analyzing all the requirements from customers and Management for the

module

• Responsible for the monitoring the production system. Handling production issues on daily basis

• Worked as an acting team lead, managing a team of 4 members.

• Involved in Re-designing the load flow by eliminating the intermediate steps and Optimizations in

order to get significant ETL conversion performance gains

• Used the DataStage Director and its run-time engine to schedule running the solution, testing and

debugging its components, and monitoring the resulting executable versions (on an ad hoc or

scheduled basis)

Client : FTPS (Fifth Third Processing System),

Role : Senior Datastage Developer

Duration : JUN 2011 – JAN 2012

Responsibilities:

• Identified/documented data sources and transformation rules required populating and maintaining

data warehouse content

• Used DataStage as ETL tool to extract data from source systems such as XML files, Oracle, Flat

Files

• Used DataStage Director to execute, monitor execution status and log view, also used in scheduling

jobs and batches

• Preparation of Unit Test cases and Unit test results document and end–end testing of the jobs

Client : GENERAL MOTORS BARS, MICHIGAN

Role : Datastage Developer

Duration : AUG 2010 – MAY 2011

Responsibilities:

• Designed and developed reusable jobs for extracting, cleansing, transforming, integrating, and

loading data using Data Stage Designer.

• Analyzed the impact of upgrading the data warehouse with new DataStage jobs

Bhanu Gudipalli

972-***-****

• Designed job sequences to automate the process and document all the job dependencies,

predecessor jobs, and frequencies to help the production support people better understand the job

runs.

• Improved the performance of jobs by using the techniques both at Database and DataStage sides

• Created Integration Test Scripts and performed System Integration Testing

• Performed Unit and Integration testing and validated the test cases by comparing the actual results

with expected results.

• Authored technical documents like technical specifications, unit and integration test cases and

deployment documents

• Supported testing team during code release with code walk through and presentations to support

teams.

Client : GENERAL MOTORS GCOMS, INDIA

Role : Datastage Developer

Duration : APR 2010 – JUL 2010

Responsibilities:

• Analyzed the existing system to upgrade with new source system

• Analyzed raw files which don’t have any field delimiter and prepared the source mapping document

• Worked on Perl Scripting for Transforming Raw data to the standard format

• Prepared the Data Sharing Agreement document

• Performed export and import of data stage components, table definitions and routines using Data

Stage Manager

Client : GENERAL MOTORS VPS, INDIA

Role : Datastage Developer

Duration : DEC 2009 – MAR 2010

Responsibilities:

• Analyzed the existing design specifications

• Involved in understanding the Business Process and Coordinating with Business users, Data

Modelers and DBA's to create Dimension and Fact tables based on the existing Data Warehouse

design.

• Prepared Mapping documents for Source, Staging and Target

• Assigned and Coordinated the tasks among the team members

Client : GENERAL MOTORS GMIA, INDIA

Role : Datastage Developer

Duration : AUG 2009 – NOV 2009

Responsibilities:

• Analyzed the existing specifications and DataStage jobs

• Developed jobs using Datastage Designer and in compliance to already existing DataStage job’s

design

• Used Environment Variables, Stage Variables and Routines for developing Parameter Driven Jobs

• Designed and developed job sequences

• Implemented logic for Slowly Changing Dimensions

Client : IDEA CELLULAR BI, INDIA

Role : Datastage Developer

Duration : Oct 2008 – July 2009

Responsibilities:

3

• Used the Data stage Designer to develop processes for extracting, cleansing, transforming,

integrating and loading data into Target DB2 Database

• Designed and developed job sequences

• Interacted with the client directly for gathering the requirements as part of ETL

• Developed Shell scripts to automate file manipulation and data loading procedures

Client : GLAXOSMITHKLINE GNE, INDIA

Role : Datastage Developer

Duration : JUN 2007 – SEPT 2008

Responsibilities:

• Prepared Mapping document(Source-Staging, Staging-Target), Test case document and ETL flow

documents

• Used the DataStage Administrator to Create the Job parameters

• Used the DataStage Designer to develop processes for extracting, cleansing, transforming,

integrating, and loading data into Oracle Data Warehouse

Client : GLAXOSMITHKLINE DRSF, INDIA

Role : Datastage Developer

Duration : NOV 2006 – MAY 2007

Responsibilities:

• Extensively worked with DataStage Designer, Director and Administrator in the design and

development of DataStage jobs

• Used DataStage Designer for importing table definitions as well as to import, export and package

jobs

• Used DataStage director to run, validate and check job status and log files

• Worked on source data involving sequential files, oracle, and SQL server source systems

• Designed and developed parallel jobs using various stages like sequential file, transformer,

aggregator

Client : GLAXOSMITHKLINE PMAR, INDIA

Role : Datastage Developer

Duration : MAY 2005 – OCT 2006

Responsibilities:

• Worked on DataStage-(Designer, Director, Manager) in the development of DataStage Jobs

• Prepared ETL specification for developing jobs

• Responsible in extracting data from AS/400 and Oracle

• Involved in creating Environment variables in all the Environments

• Responsible for raising Remedy Tickets and Change components as per the requirement

EDUCATION

Bachelor of Engineering.

TRAININGS

• Business objects training

• Cognos reporting tool training

CERTIFICATION

Infosphere Datastage v8.0

•

VISA Status :

• H1B

Bhanu Gudipalli

972-***-****

5

Contact this candidate