ETL Developer

Ashvini Patil

E-Mail: ************.**@*****.***

Contact No: 314-***-****

Location: Saint Louis, M.O.

Summary

Have a total of 5.6 years of experience in Information Technology (IT). Expertise in installation, Designing implementing, customization of ETL (Extraction-Transform-Load) tool oracle data integrator (ODI).

5.6 years of Information Technology Experience with specialization in ETL tool ODI 11g and 12C and PL/SQL

Expertise in Installing and configuring ODI 11g and 12c and ODI standalone agent

Expertise in migration and integration of different type of data and handling all possible issues arising during migration and integration

Hands-on on Designing and developing the complex mappings from Various Transformations

Exposure in handling of different ETL environment like development, testing, pre-production and production

Expertise in ODI administration like maintenance, deployment, user creation, profile creation

Exposure to ELT and ETL Architecture in ODI 11g and 12C

Promotion (Migration) of ODI objects on different environment like development to testing, testing to production etc.

Proficiency in ODI Topology and context Configuration

Agent installation and configuration

Creating ODI users and profiles

Creation and deployment of Master and Work

Apart from technical skills, having Good analytical skills and problem solving ability and possess good communication skills

Hands on experience in various SDLC Methodologies such as AGILE

Expertise in SVN handling to maintain version specific documents and code

Accomplishments

Team Work award for outstanding contribution and on time delivery for the Project

Got customer appreciation for creation of automation tool for ODI.

Experience profile

Worked as Associate Consultant in L&T InfoTech from May 2012 to Nov 2016

Working as Senior Consultant in Tech- Mahindra from Nov 2016 till Dec 2017.

Education

B.E. in ‘Information Technology’ from Bharati Vidyapeeth’s College of Engineering Kolhapur, Maharashtra, India.

Technical Skills

ETL Tools

ODI 11g, 12c and OWB 11g R2

Data Warehousing

Data marts, Facts, Dimensions, Star schema, Snow-Flake schema, Slowly changing dimensions,Change data capture

Database

Oracle 10g, 11g and 12C

Programming Languages

SQL, Java and HTML

Operating System

Windows, Linux.

Career Profile

Project 1

Project

BT (Whole Sale Customer Data store)

Description

The project was based on online order and providing services. It was aimed at migration as well as integration involves data migration and integration from various modules like order and quote to Oracle database.

Main objective was to ensure data quality before migrating into Oracle by verifying various business logics and in minimum time.

Role

ODI Developer

Contribution

Understanding existing business logic implemented and new requirements

Technical research on the new requirements.

Creating delivery kit for live production environment.

Involved in Unit testing and System testing and prepared Test plan documents

Responsible for preparation of technical design documents.

Worked with support its production, test and development environment by solving issues which arises in the loading of data in the data warehouse by the use of tool ODI.

Upgraded of ODI 11g to ODI 12C

Responsible for creation of test plan for migration to 12C

Configuration Of ODI 12C and agent installation of 12C

Duration

10 months

Application /Tools

ODI 11.1.1.6/11.1.1.7

Oracle Database 11.2.0.3.0

Project 1

Project

Lafarge (Data Migration using ODI)

Description

The project was based on Cement factory. It was aimed at migration as well as integration involves data migration and integration from various modules (countries) to Oracle database. Main objective is to ensure data quality before migrating into Oracle by verifying various business logics and checking data quality after integration.

Role

ODI Developer and Administration

Contribution

Technical research on the new requirements.

Worked extensively in data mapping and conversion.

Built a data conversion tool that supports calling ODI, Creation of interfaces, Automatic ODI Mapping and automatic creation to build business rules to load data using transformations like Expression, Lookup, Filter, Group and joins, dataset, procedure, variables, web services.

Configuration of ODI Agent and executing jobs with Agents.

Worked on Change Data Capture requirement using Oracle Golden Gate.

Migration of the ODI code to higher instances with quality data for internal functional testing and business user testing.

Debugging of issues in ODI tool.

Start-up setups

Maintenance and Performance tuning - Improved data load and query performance by query tuning.

Working on change requests.

Involved in Unit testing and System testing and prepared Test plan documents

Responsible for preparation of technical design documents.

Worked with support its production, test and development environment by solving issues which arises in the loading of data in the data warehouse by the use of tool ODI.

Duration

12 months

Application /Tools

ODI 11.1.1.6/11.1.1.7

Oracle Database 11.2.0.3.0

Project 2

Project

Lafarge (Data Migration and Integration using ODI)

Description

The project was based on Cement factory. It was aimed at migration as well as integration involves data migration and integration from various modules (countries) like France, China etc. to Oracle database. Main objective is to ensure data quality before migrating into Oracle by verifying various business logics and checking data quality after integration.

Role

ODI Developer

Contribution

Creation of customized Knowledge modules like LKM in order to use Excel (XLSX) file as a source as per the project requirement

Extraction of data for Excel (XLSX) and CSV File as a Source in ODI

Created multiple mappings using operators such as join and Filter

Development of ODI process flow with all the Variables, Interfaces and Procedures are packaged in a sequence for execution

Ensuring data movement from one environment to another using ODI functionalities

Testing, validation and execution of ODI Package, Procedure, interface and Models on the new environment to ensure successfully committed in ODI

Testing and validation of various ODI Mappings and associated Workflows

Configuration of ODI Agent and executing jobs with Agents.

Debugging of issues in ODI tool if any while development.

Duration

19 months

Application /Tools

ODI 11.1.1.6/11.1.1.7

Oracle Database 11.2.0.3.0/12c

Project 3

Project

Nynas (Data Migration and Integration using ODI)

Description

The project was based on oil factory. It was aimed at migration involves data migration from various modules to Oracle database. Main objective is to ensure data quality before migrating into Oracle by verifying various business logics.

Role

ODI Developer

Contribution

PY Promotion of ODI objects on different environment like development to testing (QA1,QA2), testing to pre-production (QA3), pre-production to production server.

ODI environment creation for development,testing and production

ODI Topology and context Configuration

Agent installation and configuration

Packaging of ODI objects

Creating ODI users and profiles

Creation and deployment of Master and Work repository

Installation of ODI and standalone agent

Duration

12 months

Application /Tools

ODI 11.1.1.6/11.1.1.7

Oracle Database 11.2.0.3.0/12c

Project 4

Project

HDS OBIEE Support – Staffing

Description

Upgrade testing and Issue log analysis and fixing which includes End-to-end implementation of Oracle BI Application for Oracle Spend, Supply Chain & Order management and Human Resources Analytics.

Role

ODI Testing, Issue analysis and development

Contribution

ODI object testing

Analysis on issue

Creating defect and enhancement depend on the issue analysis report

Creating FDS and TDS for defect and enhancement.

Fixing issue

Testing defect and enhancement

Duration

10 months

Application /Tools

ODI 11.1.1.7/12C

Oracle Database 11.2.0.3.0/12c

Certification

Sr. No

Certification Name

Grade/Percentage

1

Oracle Certified Professional, Java SE 6 Programmer

95%

Personal Details

Current Location

Saint Louis, Missouri, USA.

Nationality

Indian

Present Address

12724 Coeur Du Monde Ct. Apd# D, Saint Louis MO, 63146

Gender

Female

Marital Status

Married

Language known

English, Hindi, Marathi

Declaration

I hereby declare that the above information furnished is true, complete and correct to the best of my knowledge and belief.

Date:-16 March 2018 Ashvini Patil

Contact this candidate