IBM Infosphere Datastage, Oracle,Unix

S atish Babu Narra

IBM Certified Solution Developer-

IBM InfoSphere DataStage v9.1

Tel. no.:+91-996*******

Email: narra.satishbabu@ outlook.com

Professional Summary:

Having three years of Experience on Data Warehouse projects and database solutions.

Worked on Data warehousing tools such as IBM InfoSphere DataStage 8.5 using

Oracle9i/10g and IBM InfoSphere DataStage V9.1 and V8.7 using Oracle 10g and

Netezza.

Develop processes for Cleansing, Transforming, Extracting and Loading data with use

of Data Stage.

Experience in Designing, Developing, and Monitoring of Data Stage parallel jobs.

Extensively worked on the DataStage client tools such as DS Designer, DS Director.

Extensive knowledge on Data Warehousing concepts like Star Schema, Snow Flake

Schema, Dimension and Fact tables.

Experience in handing the different types of Slowly Changing Dimensions like Type1

and Type2.

Knowledge in Informatica 9.1 for creating mapping's, Sessions, Worklets based on

client requirement.

Having Experience on server maintenance and Performance techniques.

Experience in integrating of various data sources like ORACLE and Sequential files.

Good knowledge in Writing SQL and PL SQL Queries.

Having enough exposure on Basic UNIX commands and Shell Scripting concepts.

Thorough knowledge in complete life cycle of an Enterprise Data Warehouse.

Effective Documentation of the Development Process like Low Level Design

Documents and Unit Test Case documents.

Professional Experience:

Working as ETL developer at Bodhtree Consulting Limited, Hyderabad from July2013

To till Date.

Working as software engineer at IBM, Hyderabad from March 2012 To July 2013

Education Qualification:

Master of Computer Applications from JNTUK in 2012.

Bachelor’s of Science from Acharya Nagarjuna University in 2009.

Technical Skills:

Business Intelligence Tools IBM DataStage (V8.7,8.5,8.0.1,9.1)

Database Oracle, MS-SQL Server

Operating systems Windows 2000/XP/7,UNIX

Languages C,SQL

Packages MS-Office

Project Summary:

Project#1:

Project Title : STAR-HEALTH Insurance

Client : SATR-HEALTH,Chennai.

Duration : Aug 2013 to Till date.

Role : ETL Developer

Environment : IBM Information Server v9.1, Oracle 10g.

Description:

• Star Health and Allied Insurance Co Ltd is a joint venture between Oman Insurance Company UAE,

Leading NRIs and an Indian company being a special purpose vehicle formed by a group of business tycoons.

• In February 2013, Tata Capital invested in Star Health Insurance [2] thereby increasing the company`s

total capital base to 5.49 billion (US$89 million).

• In April 2013,Star Health Insurance became the first Insurance company to launch a specialty policy for

people suffering from Cardiac ailments, Star Cardiac care the one of its kind policy for persons who had

undergone Heart Surgeries(Angioplasty and Bypass).

•

• The aim of the project is to build a DataMart with the required dimensions and facts to

support the business intelligence system capable of analyzing the policies information and the status of

different claims, etc...

•

Responsibilities:

•

• Performed major role in understanding the business requirements and designing and loading the data into data

warehouse (ETL).

• Designed and developed ETL jobs using various stages like Join, Aggregator, Lookup, Transformer,

surrogate key generator, funnel, Sort, Remove Duplicates.

• Involved in resolving Production issues.

• Design the jobs with a SCD Type2 to keep track of historical data.

• Involved in taking regular backup of Datastage jobs.

• Worked with UNIX commands.

• Involved in Unit Testing of jobs.

• Extensively worked with flat files. Have Good Knowledge in Fixed width and Delimited Files.

• Co-coordinating work with the other team members.

•

Project#2:

Project Title : OSU (Ohio State University)

Client : IBM

Role : ETL Developer

Environment : IBM Information Server v9.1, Oracle 10g.

Project description

The Ohio State University (OSU) is a sprawling school with seemingly endless

opportunities for students to get involved. It offers a wide variety of graduate programs

through its highly ranked colleges. A datawarehouse for OSU is built using Ascential

Datastage V 7.5.2 and Oracle 10g Database. The main objective of OSU is now to improve

jobs performance by migrating server jobs with Oracle data to parallel jobs Netezza. The

process involves three steps, running server jobs and populating the target tables in oracle.

Moving all the data (source, staging and target) from oracle to netezza. Running parallel jobs

against the moved source data and loading target tables in a different schema in Netezza.

Validating the data loaded by server jobs and parallel jobs in Netezza

Roles, Responsibilities:

Effectively handling new/change requests from clients by proposing and

•

implementing cost and effort efficient solutions. Ensuring that all the requests are well

documented and are deployed as per plan.

Using ETL Code review tool primarily to help in the analysis of the jobs.

•

Understanding the project domain and working of the same.

•

Successfully migrated jobs for Payroll project from DataStage 7.5 to DataStage 9.1.

•

Providing technical and functional support for team members involved in the project.

•

Ensure that the project deliverables adhere to the company guidelines and satisfy the

•

client with adherence to timelines and quality of code

Designed a run job script that can be used to trigger any number of jobs. Designed

•

change data capture logic to reduce load time of jobs from 12 hrs. to less than 15

minutes.

Single point of contact for all DataStage support and enhancement activates.

•

Awarded two “Outperform Award” for exceeding client expectations.

•

Received numerous appreciations for developing value additions which significantly

•

increased performance

Platform & Skills:

Ascential Datastage 7.5x2, Data Stage 9.1, Oracle 10g, Netezza 6.0. IBM/AIX, Sql

Developer, Aginity, Flat files, Dataset, WinScp, Putty and Windows Server 2003...

Contact this candidate