Data Project

RESUME

Ph no: +91-812******* Email: ******************.**@*****.***

PROFESSIONAL

4+ years of IT experience in Data warehousing with 3+ years of experience in

Oracle Data Integrator and 1+ years of experience in Oracle and 2 more years of

experience as a faculty On artificial intelligence.

EXPERIENCE SUMMARY:

Worked on E LT tool Oracle Data Integrator with Loading the data

f rom different sources to different targets using ODI.

Created inbound and outbound interfaces for loading files to tables

and tables to files.

Maintaining the version control for developed objects like interfaces,

p rocedures, packages, variables and their scenarios.

Having good experience with complex files loading using ODI.

Worked on multiple files to single target using interfaces in ODI.

Created inbound and outbound interfaces for the client

requirements to load the data from source to target systems and

t arget system to files.

Hands on experience with Data Extraction, Transformation and

Data Loading in Data Warehouse environment.

Created load plans parallel and serial jobs in execution

environment.

Worked with multiple sources such as Relational database, Flat

f iles for Extraction Transforming and Loading data into target

t ables.

Scheduling procedures, packages and interfaces as we created for

business requirements to load the data from source to target

systems.

Scheduling ETL jobs for scenarios and load plans in execution

environment.

Develop data extracts from the data warehouse environment using

ODI.

Knowledge in Data warehousing concepts such as dimensional

modeling, Star Schema and snowflake schema, Data marts,

D imensions and facts identification.

Complete knowledge of Data warehousing Development life cycle.

Results oriented, self starter looking for challenges, ability to

r apidly learn and apply new technologies and good interpersonal

skills.

EDUCATION QUALIFICATION:

B.tech from JNT University, Hyderabad.

WORK EXPERIENCE:

Working as O D I Developer i n B OSCH, B angalore f rom July

2010 to t ill date.

Worked as an Software Engineer i n C G I, B angalore f rom Aug

2008 to J uly 2010.

Worked as a faculty on Artificial intelligence at S.K.D Engg.Clollege

anantapur.

Technical Skills:

ELT Tools : Oracle Data Integrator 10g-11g

Supporting Tools : TOAD, SQL Developer

RDBMS : Oracle 10g-11g, MS SQL Server

Languages : SQL,PL/SQL

Operating Systems : Windows 2000/XP.

PROJECT SUMMARY:

Project #3:

: BASFCORPORATION

Project Name

Duration : Oct 2011 – till date

Environment : ODI 11g, oracle 11g, Flat Files, EXCEL and XML Files

Description :

BASF is the world’s leading chemical company. Based in Florham Park, New

Jersey, BASF Corporation is the North American affiliate of BASF AG,

Ludwigshafen, Germany. BASF’s portfolio ranges from chemicals, plastics,

performance products, agricultural products and fine chemicals to crude oil and

natural gas.

Responsibility:

Created Models and data stores for getting files and database

object.

Provide technical support to User Acceptance and Integration

testing environments by researching suspected anomalies and

periodically refreshing the environments.

Created interfaces for loading data from xml files to database.

Created outbound interfaces for loading data from database to CSV

f iles.

Creating several reverse engineering Models as per the

requirements.

Imported and executed master jobs, scenarios in Execution

repository.

Developed packages for file operations using ODI Tools.

Performed Debugging and Tuning of mapping and sessions.

Monitoring the Execution Logs in operator navigator

Imported master job and executed as per the requirements

Debugging the master jobs and packages by using operator

navigator

Loading metadata data from f lat file source system into RDBMS

t arget system

Mapped Logical resources to Physical resources in different contexts

Scheduling the scenarios by using ODI Scheduler

Debug the sessions by utilizing the log of the sessions

Performed unit testing at various levels of ELT flows

Project#2:

Project Name : Matrix Ride

Duration : July 2010 – Sep 2011

Environment: ODI 11g, SQL, PLSQL, oracle 11g, MS-Access, XML

Description :

T he primary objective of this project was to develop a Database

environment to maintain all the operations MRIS(Matrix Ride

I nformation System) was designed to keep a track of all the clients

p icked up and dropped off every day by their drivers,Complete track of

m ileage system, automatic invoice generation, All Drivers everyday log,

A ll employees time table. For MRIS Oracle database is used at the back

end.

Responsibility :

Designed packages for work flow executing interfaces and group of

r elated jobs at a t ime using variables usage types like SET

Variable, Increment, Assignment, Refreshing and evaluate.

Created jobs parallel and serial using Load plans with condition

based using CASE.

Scheduling in terfaces to load the data from inbound and

outbound f iles.

Created mult iple in terfaces for file to file and database to file and

f i le to database operations

Design and development of ODI repository to meet business

f unctionality

Developed different procedures, Packages and Scenarios in ODI

Prepared and review of Low level and high level ELT design

documents

Managed and maintain different ODI Versions using ODI

Solution

Handled the ODI Dev and Test repository using different

r epositories

Used CDC features for Incremental data loads

Performed UAT and data migrations from Dev to Test

Handled the ODI Agent with Load balancing features

Project #1:

Project Name : Sankyo Pharmaceuticals

Duration : Aug 2008 – July 2010

Environment : Oracle Data Integrator, SQL / PLSQL, Oracle 10g, Windows,

Flat Files.

Description :

Sankyo Pharmaceuticals is one of the largest Parma companies, which develops,

manufactures and markets innovative health care products and services from

prevention and diagnosis to treatment and cure. The project involves developing a

Data warehouse which collects data related to medical samples provided to the

doctors, its feedback and finally analyzing the data for those samples

Responsibility:

Extensively worked in the performance tuning process, ETL

p rocedures and processes.

Monitoring the running process using Operator and Metadata

Navigator.

Scheduling packages for human workflow items called like

i nterface, variables and interfaces.

Created sequences for loading the data from source to dimension

t ables.

Error checking and testing of the ETL procedures and programs

using Informatics session log.

Created user functions for business calculations to improve

development speed and reusability.

Worked extensively with central data repository and

pharmaceutical R&D domain.

Worked extensively on Oracle database 9i and flat files as data

sources.

Developed and fine-tuned PL/SQL stored procedures to increase the

performance.

Huge volumes of Data extraction from legacy systems and uploaded

i nto Oracle using SQL*Loader and PL/SQL.

Performed integrated testing for various mappings .Tested the data

and data integrity among various sources and targets.

Contact this candidate