Project Data

Email: *****.****@*******.*** Mobile # 998-***-****

Professional Objective

To obtain a demanding and challenging opportunity that will allow me to leverage my technical skill set in conjunction with my proven leadership record to deliver successful Implementations of technology.

Professional Summary

Total 3+ Years of Experience in IT industry on which 3+ years in Data warehousing with application development and Implementation of ETL tool Data Stage.

> Have 3+ years of experience in Data warehousing tool Data Stage 7.5.

> Extensively involved in Development, Testing.

> Documentation, Implementation and support of Data Warehousing.

> Sound knowledge in RDBMS Concepts.

> Have very good communication skills, both written and verbal.

> Have quickly acquired the additional application skills to complete the job.

> Interested to explore my self with new Technologies.

Datastage Developer role

> Worked extensively on Data stage 7.5 ETL tool(Server and parallel edition) as developer Cum Administrator.

> Good understanding of DataStage Architecture.

> Worked in Performance Tuning of DataStage Jobs.

> Sound Knowledge in Data warehouse system and the concepts involved.

> Thorough knowledge on Data warehouse concepts like Data warehouse Star schema, Snowflake schema, Data Marts, Dimension and Fact tables.

> Worked in teams and can be a part of value addition for the Organization.

> Having Good interpersonal skills, and zeal to learn new things.

> Ability to meet critical and work pressure

Datastage Admin Role

> Having 3 years in Data warehousing in various phases of software development including design, development, unit testing & documentation.

> Installed datastage 7.5.1 on windows 2008 server..

> Granting appropriate privileges to users in datastage.

> Established rsh setup by co-ordinating with unix admin.

> Resolved ssh and rsh connectivity(secondary node for effective communication).

> Maintain several versions of DataStage Servers i.e. DS 7.5.1, 7.5,2, 8.0.1, 8.1.1.

> Installation and Configuration of DataStage Client tools on the Windows machines.

> Used DataStage Director to schedule, monitor, cleanup resources and run jobs..

> Shutdown and Start the DataStage Server and Websphere server.

> Created Configuration files for all the environments depending on the available nodes.

> Proficient in datastage admin commands.

> Proficient in datastage architecture.

Career Profile

> Working for Robust designs Pvt Ltd, Bangalore from march’ 11 to till date

> Working for Hr Plus, Bangalore from sep’ 08 to feb’11.

Educational Profile

B.E from V.T.U University (BLDEA’s College Bijapur Karnataka), Belgaum Karnataka.

Technical Expertise

ETL Tool : Ascential DataStage 7.5, cubot

Databases : ORACLE 9i, MS SQL Server

Operating Systems : Windows 95/98, Windows NT,Window 7, UNIX 5.3

Programming Languages : core java, UNIX shells scripting.

Engagement Overview

Project #1:

Project : SMS PLATFROM

Role : ETL Developer

Duration : March’11- till date .

Environment : Cubot, Mysql, windows, Linux(Suse).

Description:

SMS PLATROM is a project help to analysis SMS services provided by comviva to there clients such as At any time user wants to check which LA is eating most the capacity . Report should give %( of total messages and License), Report should show DMSISDN based success/redirect/error counts, All Reports should be based on both MSISDN & IMSI, Reports should show Success and error count of message relayed to different accounts accounts per and various such report

Responsibilities:

> Analysis CDR provided by client .

> Construct fact tables and dimension tables according to requirement.

> Load into cubot ETL tool.

> Designed and Implemented jobs.

> Generate reports according to it.

> Involved in Unit testing and taken responsibility of Peer Reviews.

> Involved in Debugging and helped team members to find root cause.

> Provided Support for UAT, BAT as well as involved in production support..

> Handled exception handling and communicated with source system as and when required.

Project #2:

Project : Multilingual Decision Form

Role : ETL Developer

Duration : December’09-till date.

Environment : Datastage 7.5, oracle 9i, windows.

Description:

Multi Lingual Discussion forum is a one through which the users of the site may share their ideas about a particular vehicle. automotive-related products and services by primarily designing, manufacturing and marketing vehicles, as well as providing communications services and a range of financial services. This project Multilingual Decision Form includes developing Data warehouse from different data feeds and other operational data sources. The project was handled with the level of three areas such as administrator, moderator, and the users. Under a country, under a administrator there are several moderators who may have the rights to create a conference where forums and discussions lies under that. On any rights, the user / moderator has to contact the administrator for confirmation.

Responsibilities:

> Extensively used stages like Sequential File, Look up, sort, remove duplicate, Join, Transformer, Aggregator, and Funnel.

> Designed and Implemented jobs.

> Involved in Unit testing and taken responsibility of Peer Reviews.

> Involved in Debugging and helped team members to find root cause.

> Provided Support for UAT, BAT as well as involved in production support..

> Handled exception handling and communicated with source system as and when required.

Project #3:

Project : Insurance Data Mart

Client : XL Capital Ltd (US)

Role : ETL Developer

Duration : .January 2010- February 2011

Environment : Ascential Data stage 7.5 1 (px), MS SQL Server(Pl/sql), Windows XP, Unix, shell scripting

Description

XL Capital Ltd is an Insurance Agency offering insurance brokerage services for high risk like ships, aero planes ,oil refineries etc. They want to build the data warehouse which allows them to analyze the patterns associated to policy signing status, premium submission and claims claimed till date.

Roles and Responsibilities

* Involved in the extraction, transformation and loading of the source data to the target Oracle database.

* Extensively worked with Data stage Designer for developing various parallel jobs using Sequential file and Transformer stages.

* Worked with the Join, Merge, Lookup and Sort parallel stages.

* Removed duplicate data from the source system by using Remove Duplicates stage to enhance high quality processing of the incoming data.

* Designed Sequencer to automate the whole process of data loading.

* Involved in Unit Testing and System Testing

Contact this candidate