Datastage with 3+ years of experience

Email: **************.**@*****.***

Mobile No: 991-***-****

Suresh

ETL Developer

Experience Summary

Currently I am an associate with Accenture with 3.3 years of work experience in Data analysis, design, development and implementation of Data warehousing applications using IBM DataStage (ETL) in DW/BI Technologies. My main area of experience has been project delivery of various sizes. I have worked primarily in the domain of Banking, Manufacturing.

Having 3.3 years of Technical exp in design and development of the ETL jobs and processes to support the business requirements for an enterprise data warehouse.

Good Experience on DataStage Parallel Extender (EE) using various stages with designer component.

Exposed to various Domains of Data warehouses like Banking, Manufacturing.

Good Knowledge on Data Warehousing Concepts.

Has the ability to develop and maintain good, long lasting client relationships.

Enjoy challenging and thought provoking work and have a strong desire to learn and progress (motivated enough to self learn) Ability to pick up new technology independently.

Technology

Application/Functional areas/Packages worked on Banking, Manufacturing

Types of projects worked on Development, Enhancement

Environments worked Data Warehousing( IBM DataStage),Oracle 9i

Languages/Tool worked on DataStage Designer (Parallel jobs), SQL.

Operating System Windows 2003 Server/XP/UNIX

RDBMS Oracle 9i

Career Profile

Dates Organization Role

Jun 2010 to Till Date Accenture, Bangalore ETL Developer

Jan 2009 to May 2010 Patni Computers,Bangalore ETL Developer

Qualifications

Degree and Dates

M.C.A from St.Martin’s Engineering College ,Hyderabad affiliated to JNTU(2009)

Work Experience

Project #2

Client : MASHREQ BANK

Domain : BANKING

ROLE : ETL DEVELOPER

LOCATION : BANGALORE

Jun 2010 – Till Date

Description:

Mashreq Bank is the leading private bank in the United Arab Emirates (UAE) with a growing retail presence in the region including Egypt, Qatar and Bahrain. It has provided banking and financial services to millions of customers and businesses since 1967.

As per current practice, each line of business manages data and risk measurements themselves, and as a result, it is difficult to standardize the methodology across different line of businesses. Business Unit risk managers currently present analysis on as-requested basis, hence it is difficult to standardize and to audit the methodology used as well as it is impossible to do on-demand analysis.

Responsibilities:

• Understanding the business functionality & Analysis of business requirements

• Design and developed ETL jobs using various Active and Passive stages in parallel jobs using Designer.

• Extracting data from sources like oracle, flat files and transforming them using business logic and loading the data to the business tables.

• Extensively used processing stages like sort, aggregator, transformer Stages in developing jobs.

• Performing unit testing on the jobs developed.

• Preparing the Test Case Document and capturing the test results.

• Monitoring the Datastage jobs using crontab.

Environment: IBM-DataStage-8.1(Parallel Jobs), Oracle 9i, Windows XP/UNIX.

Project #1

Client : FORD MOTORS

Domain : MANFACTURING

ROLE : ETL DEVELOPER

LOCATION : BANGALORE

Jan 2009 – May 2010

Description:

QIS2 is a global quality application that is used to perform analysis of diagnostic data from Powertrain and Vehicle Control Modules to reduce the detection-to-correction time for Ford Motors. FM would like to further enhance QIS2 to report on propulsion battery measurement data.

The purpose of this project is to create additional reports to analyze the battery measurement data captured in the propulsion battery assembly plants. This will allow FM Battery and Volt Engineers to identify issues using measurement data including volt and temperature readings.

Responsibilities:

• Understanding the business functionality & Analysis of business requirements

• Design and developed ETL jobs using various Active and Passive stages in parallel jobs using Designer.

• Extracting data from sources like oracle, flat files and transforming them using business logic and loading the data to the Data warehouse.

• Extensively used processing stages like sort, aggregator, transformer, join Stages in developing jobs.

• Performing unit testing on the jobs developed.

• Preparing the Test Case Document and capturing the test results.

• Monitoring the Datastage jobs using Autosys scheduler

Environment: IBM-DataStage-7.5.x2 (Parallel Jobs), Oracle 9i, Windows XP/2003.

Contact this candidate