SUMMARY

• Over 8 years of total IT experience with strong background in Analysis, Design, Development, Implementation of Data Warehousing in ELT process using ODI 11g/10.1.3.4/10.1.3.5/Sunopsis.
• Experienced in all phases of System Development Life Cycle (SDLC).
• Experienced in building/customizing ELTs from Source Systems such as PeopleSoft, EBS to Data Warehouse.
• 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 ELT.
• Used Oracle Data Integrator Designer (ODI) to develop processes for Extracting, cleansing, transforming, integrating and loading data into Data Warehouses.
• 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 understanding on Data Warehousing concepts such as Star and Snowflake schemas.
• 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

ERPOracle Applications: Oracle Financials (GL, AP, AR), PO (Oracle Purchasing) and AOL (Application Object Library).Internet JDBC, Java Script, HTML, XML.

Languages: SQL, PL/SQL, C

Databases: Oracle 9i, 10G, SQL Server, and MS Access 97 OSUNIX,, Windows 98/NT/2000, MAC

OLAP Tools: Oracle Data Integration 11g (ODI)DEVELOPMENT

TOOLS: XML Publisher, TOAD, SQL* plus, sql*loader, SQL server

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton, CA

ODI Integration Lead

Responsibilities:

• Gathered ELT requirements from Business team and designed its high level documents.
• Involved in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
• Worked as ODI Consultant to integrate and consolidate all Payroll, Financials, Human resources, operating and Capital Expense Budgeting Operations data to one system.
• Performed ODI Tasks such as Establishing ODI Development Standards, Created ODI Repositories, Agent, Contexts, Data Server, and both of Physical & Logical Schema in Topology Manager, created both of source and target models folders, models and data stores
• Created Project, Project Folder, and Packages, imported required Knowledge Modules.
• Created Interfaces, defined optimization context and staging area, performed source and target data store mapping and defined property, defined the Flow’s LKM & IKM option and value.
• Defined filter and constraints as require, run execution and working with Operator if there is error occurred, Migration of ODI Repositories.
• Designed Interfaces to load data from Sql server, SharePoint as source in to staging area (Oracle) and load in to Oracle Data warehouse.
• Utilized Knowledge Module Adapter to build planning application structure from Oracle, GL, load the metadata, data and load smart list to Hyperion planning application.
• Worked on Migration process to migrate all the database views and tables tied to a model.
• Migrated Models and Projects to different environments. Used LCM to migrate all the Hyperion artifacts to different environments.
• Worked with ODI contexts to load data into Hyperion target systems which are in different environments from single ERP source system.
• Automated ODI interfaces to email a status log and error report after the interfaces run every night.
• Worked on ODI user security to provide limited access to users.
• Worked with Oracle to apply ODI Patches.
• Performed source to Staging and staging to target mapping specifications and developed ELT ODI code for the same.
• Worked in importing data from heterogeneous data sources like database, flat file, XML files, excel.
• Designed Interfaces to load data from Flat files, CSV files in to staging area (Oracle) and load in to Oracle Data warehouse.

Confidential, Cherry Hill, NJ

ODI Developer

Responsibilities:

• Worked as ODI consultant. Developed batch and rules files to load data from financial system’s database to Essbase cube.
• Created and scheduled batch jobs using ODI for complete automation processes for nights and weekend’s application refresh and backup.
• Worked with data administrator and ELT team to share the data using Oracle Data Integrator (ODI).
• Implemented calculation engine that includes robust mathematical functions for computing derived data.
• Implemented Success and Failure Notifications into ODI Packages.
• Created load plans to run the scenarios in a hierarchy of sequential and parallel steps.
• Created test cases for end to end and rated testing of ELT Packages.
• Performed unit and system testing of ELT Packages.
• Utilized Knowledge Module Adapter to build planning application structure from Oracle, GL, load the metadata, data and load smart list to Hyperion planning application.
• Worked on GUI to provide ODI web based access to end users.
• Worked with Business Users to identify functional tasks and convert them to technical designs.
• Worked with ODI contexts to load data into target systems which are in different environments from single source system.
• Automated ODI interfaces to email a status log and error report after the interfaces are run every night.
• Worked on ODI user security to provide limited access to users.
• Worked with functional analyst for technical requirements, design specifications and developing testing strategies.
• Worked on ODI to load data to Classic Planning and managing the module within ODI.
• Provided ODI user training and security to end users.
• Develop Hyperion Financial Reports for quarterly and monthly financial reports. Developed Batch Scripts and Rules files to dynamically upload dimensions and data from Legacy System to Essbase Cubes. Also developed Rule files for multi-dimensional databases.

Confidential, Fort Lauderdale

ODI Consultant

Responsibilities:

• Worked as ODI Integration consultant to integrate their legacy budgeting system with Oracle Hyperion Planning.
• Performed and automated the task of dimension building and Data loading process using ODI. Extensive work on Oracle Data Integrator (ODI) to load the Human Resource (HR) metadata and data to planning application and managed the incremental dimension building
• Worked with ODI Web services tool to execute a scenario using an http URL.
• Created new Data Server, Physical Schema, Logical schema as part of the setup between ERP source system and Hyperion Planning Target System.
• Based on user requirement Automated ODI interface to run every night by Generating ODI Scenarios and scheduling them to interface to run every night.
• Created ODI admin tasks like Creating users, Assigning Profiles to users.
• Worked with ODI OsCommand to call windows and UNIX batch scripts.
• Worked on Migration process to migrate all the database views and tables tied to a model. Migrated Models and Projects to different environments.
• Created Views, Functions, Procedures and Packages in PL/SQL for ODI process.
• Identified and fixed bottlenecks and tuned the complex ODI Interfaces for optimized performance.
• Worked with Oracle to apply ODI Patches.
• Created ODI jobs to replicate the existing process of Shell scripts and SQL scripts

Confidential, CA

ODI Developer

Responsibilities

• Worked as ODI consultant. Developed batch and rules files to load data from financial system’s database to Essbase cube.
• Created and scheduled batch jobs using ODI for complete automation processes for nights and weekend’s application refresh and backup.
• Worked with data administrator and ELT team to share the data using Oracle Data Integrator (ODI).
• Implemented Success and Failure Notifications into ODI Packages.
• Created load plans to run the scenarios in a hierarchy of sequential and parallel steps.
• Created test cases for end to end and rated testing of ELT Packages.
• Performed unit and system testing of ELT Packages.
• Worked with functional analyst for technical requirements, design specifications and developing testing strategies.
• Worked on ODI to load data to Classic Planning and managing the module within ODI.
• Provided ODI user training and security to end users.
• Develop Hyperion Financial Reports for quarterly and monthly financial reports. Developed Batch Scripts and Rules files to dynamically upload dimensions and data from Legacy System to Essbase Cubes. Also developed Rule files for multi-dimensional databases.

Confidential, CA

Oracle Apps/ODI Consultant

Responsibilities

• Developed ODI Interfaces to load data files to Oracle Staging.
• Design, Documented and developed Conversion routines, Custom PL/SQL API’s for Purchase Orders (Headers, Lines, Distributions) from legacy mainframe applications.
• Design, Documented and developed Conversion routines, Custom PL/SQL API’s for Item Conversion and successfully loaded the items.
• Design and Developed Detail Payment reports with reference to Salesperson, Branch Level Transaction report and Customer’s outstanding report.
• Customized the Backorders Detail Report, Backorder Summary Reports in O2C Process.
• Designing of Conversion/Interface project’s Implementation Strategy for Accounts Payable and Accounts Receivable and General Ledger
• Designing and developing Proto Type Data Migration Process to test load legacy sample data.
• Design and development of migration scripts for all activates of GL and sub ledger migration.
• Researching and analyzing the AP and AR legacy volume transactions and possible impact on one time Conversion Process under existing data transport mechanism.
• Developing Generic Packages using PL/SQL to build flat files to manage transmissions across Legacy and Oracle Systems.
• Developing Flexible PL/SQL Scripts/Packages for Data Objects Creation such as Tables to store legacy data and to maintain data for staging interim phase.
• Developing SQL Loader control scripts to process the legacy data and to load them into Temp Staging Area.
• Developed PL/SQL Scripts/Packages for Payables Invoice Import, AR Auto-Invoices Interface
• Wrote MD70, CV40 documents forProject Transactions.
• Designed and developed conversion routines, Custom API’s forProject Transaction Import

Confidential

Oracle Technical Consultant

Responsibilities

• Responsible for importing data from numerous sources for companies acquired by client, into Oracle AR.
• Defined the new customers, address information including the EDI location codes and imported the legacy customer info into customer tables using the standard customer interface program.
• Developed multiple interface programs to convert legacy data from external sources. This included converting customers and their related transactions (invoices, payments, etc.)
• Wrote custom Oracle Financial reports to meet client specifications.
• Developed custom forms for use in custom billing system.
• Partially involved in the design of custom billing system that was interfaced into Oracle AR.
• Used AOL & Sys Admin to register new reports, forms, functions, menus and created validation sets, request sets and concurrent programs.
• Work closely with functional and development team to implement Oracle Financial Modules (AP, GL, AR), create Applications Users, Responsibilities, Report Sets, Menu and Functions.