<!– /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:””; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:”Times New Roman”; mso-fareast-font-family:”Times New Roman”;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} –>

Objective:

To utilize my technical exposure, skills and knowledge in the filed of DW Solutions, that offers continuous growth & development and to contribute for the success of an Organization and to cater the needs of the clients.

Professional Summary.

2 years of experience in Data Warehousing solutions using DataStage 7.5.
Good understanding of Data Warehousing Concepts.
Sound knowledge of SQL.
Knowledge of PL/SQL.
Basic knowledge of UNIX .
Knowledge of DataStage server and parallel job.
A team player with good communication and analytical skills.

Technical Skills.

ETL Tool: DataStage 7.5 server,parallel extender
RDBMS: Oracle 9i
Languages: SQL, PL/SQL
Platform Familiarity: Windows 98/XP/NT,Unix

Work Experience:

Currently working as an ETL Developer in A Reputed Company since June 2006.

Educational Qualification:

B.E (Computer Science & Engg.) from Technocrats Institute Of Technology Bhopal (M.P.) with 70.38% in 2006
HSC from J.N.V. HATTA (M.P.) with 63.4%.
SSC from J.N.V. HATTA (M.P.) with 76.6%.

Project #1.

Title: Finance Strategic Information System
Duration; December 07 - Till Date
Environment: DataStage 7.5, Oracle 9i, Windows NT, UNIX
Role: ETL Developer

Responsibilities
: Development of Jobs to Populate Staging Area.
Development of Jobs to load data into Data mart using CDC technique.
Development of UTC.
Testing the Jobs according to UTC.
Tuned the jobs for better Performance on request.

Description: The project is to provide different reports and support adhoc queries for making intelligent financial decision based on data available in various branches across the country collected over period of time. The finance wants to have a tool, Which will help it to analyze the current business trends and to make prediction about the future Business trends. Especially the finance is focused on getting the analytical information about target customer groups, season wise financial analysis and so forth.

Project #2.
Title: Banking Management System
Duration: April 07- November 07
Environment: DataStage 7.5, Oracle 9i, Windows NT, UNIX
Role: ETL Developer

Responsibilities
: Development of Jobs to Populate Staging Area.
Development of Jobs to load data into Data mart using CDC technique.
Development of UTC.
Testing the Jobs according to UTC.
Tuned the jobs for better Performance on request.
Description:
It is being developed to implement business ruled for the existing OLTP System for one of leading banks. This bank is using the traditional banking practices for its functioning and uses the various media for promoting the various schemes. Bank wants to implement information technology for making better business strategies and decisions, in order to have an edge over its competitors. This project is to provide different reports and supports adhoc for making intelligent banking decisions based data available in various branches across the country.

Project #3

Title: Sales Transformation System
Duration: August 06 - Feb 07
Environment: DataStage 7.5, Oracle 9i, Windows NT, UNIX
Role: ETL Developer

Responsibilities:
Development of Jobs to extract data from Source and to Populate Staging Area.
Development of UTC.
Testing the Jobs according to UTC.
Tuned the jobs for better Performance on request.
Description

This project involved the analysis, design and implementation of a data warehouse that collected information about the purchases on an online legal product. I was responsible for the analysis of the database, the extraction, verification, and loading of the data, creation of the data warehouse, the creation of aggregate and summary information, and the creation of the end-user interface. Client is an export-oriented joint venture specializing in designing and manufacturing a series of household furniture. Their main markets are England, France, Spain, Germany, Italy, Sweden, U.S.A, Canada, Australia and New Zealand. The Client needed to have enhancement for the already existing modules.

Personal Details:

Marital Status: Single

Languages: English, Hindi