Oracle data integrator developer

Experience Summary:

. SIX PLUS (*+) years of total IT experience with strong background in

Analysis, Design, Development, Implementation of Data Warehousing in

ETL process using ODI 12c/11g/10.1.3.4/10.1.3.5/Sunopsis.

. Experienced in all phases of System Development Life Cycle (SDLC).

. Experienced in building/customizing ETLs from Source Systems such as

PeopleSoft, EBS to DataWarehouse

. Experience in performance tuning DataWarehouse to meet Business

Intelligence needs for applications such as Hyperion EPM applications

and OBIEE.

. Hands on experience with the new version ODI 12C.

. Experience in creating ad-hoc analysis and Dashboards using OBIEE

Answers.

. Strong understanding on Data Warehousing concepts such as Star and

Snowflake schemas.

. Used Oracle Data Integrator Designer (ODI) to develop processes for

extracting, cleansing, transforming, integrating and loading data into

Data Warehouses.

. Experienced in Installing and Configuring Oracle Data Integrator (ODI)

software tool in a three-tier environment and performing periodic

upgrades, performing source-to-target mappings, storage capacity

planning and developing ETL.

. Experienced in setting up ODI standalone Agents and J2EE Agents on

WebLogic server based on requirements.

. Experienced in provisioning users (Security Manager) and setting

up/manage source and target system connections (Topology Manager) in

ODI.

. Experienced in developing stored procedures, functions, packages and

database triggers using Oracle SQL Developer and PL/SQL to improve

query performance.

. Strong SQL knowledge. Familiar with creating queries, tables, views

and other relational objects, and maintaining the referential and data

integrity.

. Experienced in gathering business requirements developing business

requirement document, data mapping documents.

. Strong communication, organizational and interpersonal competencies

along with detail-oriented and problem solving skills in the

technology arena.

. Established and maintained productive working relationship with

Management, Clients and Team Members. Self-starter, entrepreneurial,

highly motivated team- player with excellent communication /problem-

solving skills. Quick learning ability vis- -vis new technology. Easy

adaptability to new environments.

Technical Skills:

Reporting OBIEE 11g/10g

Tools

ETL Tools Oracle Data Integrator (ODI)

v.12.1.1.1/v.11.1.1.7/v.10.1.3.4,

Informatica V.9

Database Oracle11g/10g/9i/8i, SQL Server, MS Access.

Database Tool Oracle SQL Developer, TOAD, SQL Plus

Languages SQL, PL-SQL, C, C++, JavaScript, Shell

Operating Windows 98/2000/XP/7, Windows NT, Windows

System server 2003/2008, UNIX.

Experience:

LCEC, Fort Myers, FL Jan 2014-

Till Date

Sr. ODI Developer

Responsibilities:

. Worked with business analysts, developers, and management

professionals from various locations to gather requirements.

. Built Data Warehouse in line with Ralph Kimball's Star Schema

methodology for analytic purpose.

. Architected and Implemented ETL routines using ODI.

. Installed and configured (Master and Work Repositories, ODI agents).

. Maintained DEV, TST, PRD environments.

. Maintained Topology connections in all 3 environments.

. Maintained User's security in all 3 environments.

. Worked on migrating all the mappings from ODI 11G to ODI 12C.

. Migrated the packages, scenarios from one repository to another

repository.

. Customized ODI inbuilt KM (Knowledge Modules) to build Interfaces for

complex data requirements.

. Created numerous Interfaces to load data from Flat files, CSV files,

and Oracle tables into staging tables and then into respective

FACT/DIMENSION/Look-up Tables in Data Warehouse.

. Implemented serial vs parallel data loading in ODI.

. Used ODI in-built scheduler to schedule Scenarios/Load Plan's in

production.

. Implemented slowly changing dimensions (SCD) in various Mappings.

. Utilized ODI in-built Journalizing (J$ tables) methodology to manage

and maintain Change Data Capture (CDC) from source data.

. Analyzed Session log files in operator navigator to resolve errors in

mapping and managed session configuration.

. Created numerous data validation scripts using SQL, which were used by

the Team (post ODI data loads) to validate the data brought into DW.

. Conducted UAT session with Business Users.

. Created numerous Views, Materialized Views, Stored Procedures and

Functions which were used in ODI (during data load) and OBIEE (post

ODI data loads and while building BI Reports).

. Conducted training session for both Administrators as well as End

Users.

. Other tasks included were documenting ODI Installation and

Configuration process, Design and Technical documentation for the

developed ETL processes.

Environment: Oracle Data Integrator (ODI) v.12.1.1.1/v.11.1.1.7, Oracle

11g, OBIEE v.11.1.1.7, SQL*Plus, TOAD, Windows 2008.

Wellington Management, Marlborough, MA

May 2012-Dec 2013

Sr. ODI Developer

Responsibilities:

. Developed, Supported and Maintained ETL (Extract, Transform and Load)

processes using Oracle Data Integrator (ODI).

. Translated business requirements into technical specifications to

build the Data Warehouse.

. Created and Maintained data base objects (Tables, Views, PK keys,

Indexes, Partitions, Triggers, and Sequences, etc.).

. Developed numerous ODI Interfaces, packages, scenarios to extract data

from different source systems such as Oracle EBS (AR, AP, GL, OM

Modules), Legacy Systems such as Mainframe, Flat files and Load into

ODS/EDW.

. Validate the Data which was brought into ODS/DW using SQL/PL-SQL

scripts.

. Responsible for setting up ODI in all the environments (DEV, UAT and

PROD) which includes all the tasks from Installing and configuring ODI

to releasing the environment to users (assigning security, client

installations and other related tasks).

. Installed the J2EE ODI Agents on WebLogic server as part of ODI set

up.

. Responsible for setting up/administering source and target connections

in ODI.

. Responsible for scheduling the Scenarios to execute in serial/parallel

modes to meet the data load requirement.

. Monitor the scheduled ODI jobs in PROD and apply fixes for failed

ones.

. Huge experience in fine-tuning complex ODI processes for better

performance.

. Migrate the ODI scenarios across different environments (from Dev to

UAT and then to Prod) using PPM packages.

. Experience in customizing ODI Knowledge Modules, writing custom codes

using Jython to meet the complex business requirements.

. Experience in designing Mini Schemas/Data Models/Data Marts for Legacy

Systems in Oracle and develop Reports out of OBIEE answers, dashboards

as per business requirement.

. Experience in building ad-hoc reports in OBIEE answers and design some

mid level dashboards as per user requirements.

. Experience in building and maintaining database objects (Tables,

Views, Procedures and Functions etc) used in the Data Models.

. Responsible for creating Test plans and co-ordinate with Testing Team

in executing test plans for the ETL Interfaces.

. Responsible for project documentation (documenting functional,

technical documents, preparing test cases/test plans and KT plans).

Environment: ODI v.11.1.1.3/v.10.1.3.5, OBIEE v.10.1.3.4, Oracle 10g/9i,

SQL, PL/SQL, SQL Loader, Toad, Oracle SQL Developer, Shell Programming, Sun

Solaris, Windows 2008.

AT&T, Waterbury, CT

Nov 2011-Apr 2012

Hyperion/ODI Support Analyst

Responsibilities:

. Created ODI Scenarios to extract Metadata and Data from OLTP system

and Load cum Transform data in a suitable format to feed the

Applications developed in Hyperion Planning and Hyperion Essbase

respectively.

. Created separate packages for loading Metadata into Hyperion planning

apps and loading data into respective Essbase cubes.

. ODI was used to load Incremental Metadata into Hyperion planning apps

through Flat files provided by system analysts.

. Created data load Interfaces using Sql queries as source and load the

transformed data into respective Essbase cubes.

. Responsible for performance tuning data load Interfaces.

. Experience in developing write back Interfaces to write back

aggregated data (designing interfaces using report script as source)

from Hyperion system into Oracle Tables or .csv files based on the

requirement.

. Experience in developing complex Interfaces to call Maxl/Calc scripts

or batch jobs in ODI to meet the data load requirements.

. Responsible for migrating ODI code (Scenarios, Projects, Models,

Topology connections) across different environments.

. Responsible for ODI executions in PROD and apply quick fixes in case

of failed ones.

. Validate the Data which was loaded into Hyperion system using SQL and

Excel add in Templates.

. Provide user support in resolving data/configuration/process issues in

the system.

. Responsible for Maintenance and Support of Oracle Data Integrator

(ODI) interfaces between Hyperion systems (Planning and Essbase) and

external systems.

. Involved in ODI architecture, documenting, code reviews and change

migration.

. Train End-Users on process control, Hyperion Automation and using

Oracle Data Integrator.

. Other responsibilities included were Business Requirements gathering,

reviewing the FDD's and documenting the Design documents and other

misc tasks related to the ETL and Automation part of the Application

Development.

Environment: Oracle Data Integrator (ODI) v.10.1.3.4, Hyperion Planning

v.9, Hyperion Essbase v.9, OBIEE v.10.1.3.4, Oracle 10g, SQL developer,

Windows Server 2003.

Kakatiya Solutions Pvt Ltd, India Jan 2009-

Oct 2011

Oracle Developer

Responsibilities:

. Responsible for analyzing the Business Requirements and prepared the

detail Technical Specification document.

. Determined the facts and dimensions, worked on identifying the data

granularity in facts and data consistency across dimensions.

. Worked on creating the design document, facts and dimensions,

hierarchies for logical columns, reports and dashboards.

. Prepared the analytics report by importing the required tables into

the physical layer using the connection pool.

. Worked on creating the Repository in the Administration tool and

applied hierarchies, created logical columns and also implemented the

time functions on the logical columns depending on the user's

requirement.

. Created as many as 40 reports on the answers page and worked on

building the dashboards.

. Applied the appropriate security model for different users,

authenticated with session variables and object level security for

different web groups.

. Worked on setting up groups and providing privileges to the users on

the Web Catalog Page.

. Viewed SQL query log and used SQL developer to run and debug the SQL

query issued during report execution.

. Used different unions and case statements in developing reports.

. Scheduled i-bots to deliver report contents to all users through

different devices on various locations.

. Performance tuning of Dashboards and made the required changes by

implementing the views and by re-building the indexes.

Environment: Siebel analytics 7.X, OBIEE 10.1.x, Oracle 10g, SQL Developer.

Contact this candidate