Developer Data
Resume:
Bhanu Gudipalli
******@****************.*** / *****.*********@*****.***
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
• 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
5
Contact this candidate