Tek08077

ODI Developer - 13 + Year


MCA - Computer Science

Highlights

  • Senior Consultant with  around 13 + years of demonstrated expertise in BIAPPS  ,ODI 10g, ODI 12c, 11g  ,OBIA 11.1.1.10.2  AR AP purchase orders manufacturing ,Sales, Service , Finance, Spend and procurement, supply chain management  and Oracle database working with prestigious organizations across industry verticals including  

  • Data consolidation ,Tele Communications, and Inventory Analysis and. He has worked with customers located in the UAE, UK, and Australia and India.Implemented End to End ODI projects on OBIA ,ODI, Development, Admin activities, Support and Enhancements  like  Installation and configuration of ODI and  creation of  Master repository and work repositories , code deployment  in all environments ,

  • Development of Interfaces  and Implementation of business logic  using  ETL/ELT ODI tool.Extensive experience in ETL-ELT Tool Oracle Data Integrator   on ODI studio and console with designer topology, operator and security.

  • Generated load plans and executed as per customer requirement to load interfaces/data.

  • Configured Scheduling using Install / Configuration of Agents in Oracle Data Integrator.

  • Worked with heterogeneous source system and heterogeneous target systems.

  • Implemented error handling methodologies to find out the exact root cause of the issues to and fix.

  • Configured Domain mappings and Hierarchies, source Domains, Warehouse Domains and externally Confirmed Dimensions in BIACM.

  • Implemented changed data capture mechanism and mail notifications in ODI.

  • Extensively worked on ODI creation of Interfaces, packages, agents, scheduling with using transformations,

  • Customization of Knowledge Modules to archive the specific source tables data.

  • Temporary table are implemented in different schema.

  • Created multiple contexts depending on usability of interfaces.

  • Extensively involved in end-user interaction, training and documentation and also on requirement gathering.

  • Managing, leading & guiding teams to deliver projects to clients within specified time frame as per client specifications.

  • Good understanding of enterprise one development cycle, coding standards and best practices of development process.

  • Good exposure on On-site/Offshore model and rich experience in estimates for projects.

  • Capable of working in a group as well as independently.

  • Good leadership and project management skills, Ability to quickly adopt, master and utilize new technology.


Skills
Primary Skills
  • ETL
  • ODI tools

Secondary Skills
  • SQL
Other Skills
  •     Windows, Unix, Linux
  •     OBIA , BIAPPS 11.1.1.10.2 ,ODI Server/ Client, Informatica Server/Client , Oracle database
  •     Oracle, Sql Server, Ms Access
  • Operating System
  • Environment
  • Database
  • Tools
  • Actively involved Project requirement gathering activities and request for proposals on new projects and CR’s .I Had a close working experience with clients on understanding their functional requirements also suggested some best way approaches for the same. Developed those functional requirements technically using the product tools with team. Also Implemented end to end development projects and enhancements and support developed them technically along with team.
  •  
  •     Oracle Data integrator 10g, 11g, 12c , Informatica 8.x,9.x
  • Management and Leadership Skills
  • Training & Development
  • I  Provided Technical Training on ODI to team and superiors on innovative   approach   implemented as part of Project.
  • Conducted end user training sessions on the product   and shared end user documentation also for the same.
  •  
Projects

Project-1 (48 months)

    Responsibilities



     




    • Built Interfaces with transformation logics to achieve client requirements

    • Created ODI interfaces for transforming source data into target format

    • Crated mappings as per business logics and analysis done for new/existing tasks for modifications



    Operating Systems



     Windows



    Software / Special Tools



    : BIAPPS 11.1.1.10.2 , ODI 11g , EBS 1213, 1222,Siebel 8.1.1.  Oracle database



     



     



     




     



Project-2 (6 months)

    Responsibilities



    OBIA End  to end Implementations are done on  di9fferent offerings .



    As per Customer requirement customizations are performed on out of box interfaces.



    Created new Warehouse customization Interfaces to achieve customer needs on project.



    Created BIACM,FSM parameters load plans for execution .



    Scheduled and configured mail notifications to get the data load alerts on customer mail.



    Worked on End to end Installation and configurations  on different instances like Development, Stage, QA and Production.



    Worked on Migration to move the complete code form one environment to another with higher environment database source/Target  connections.



    Built Interfaces with transformation logics to achieve client requirements



    Created ODI interfaces for transforming source data into target format



    Crated mappings as per business logics and analysis done for new/existing tasks for modifications



    Operating Systems



    :  Windows



    Software / Special Tools



    :  ODI 11g , Oracle database



     



     



     




     



Project-3 (6 months)

    Responsibilities



    Built Interfaces with transformation logics to achieve client requirements



    Created ODI interfaces for transforming source data into target format



    Built OBIEE reports and dashboards with different layout options like charts tables graphs.



     Loaded data based on flattering hierarchical order as per requirements



    Operating Systems



    :  Unix



    Software / Special Tools



     ODI 11g , Oracle database, SVN, Filezilla



     



     



     




     



Project-4 (18 months)

    Responsibilities



    Implemented Creation of new Interfaces to achieve   client



    Created ODI interfaces for transforming source data into target format



    Extensively worked in designing and monitoring ODI packages, Interfaces, Scenarios, sessions and procedures



    Worked closely with business users on odi to full fill their project requirements



    Operating Systems



    :  Unix



    Software / Special Tools



    :ODI 11g , Oracle database, SVN, Filezilla



     



     



     




     



     



Project-5 (11 months)

    Responsibilities



    Implemented Creation of new Interfaces to achieve   client requirements with appropriate business logics.



    ODI Batch interface uploads of customer Integrations of sales, Marketing and Campaign response communications in to Source system from source system to target server for extended systems communicate via phone SMS e mail and mail communications modes members.



    Created new ODI packages, with package tools to achieve specific business logic like sending an email getting files form sftp and loading to other sftp.



    Created new scenarios which hold interfaces and packages with tools.



    Updated Database tables which load the generic flow functionality.



    Updated the code migration activates using SVN versioning across the environments.



     Created/ Updated the MD57 and MD 150 documentation which holds the development process which we used for this project.



    Created Release notes for deployment.



     Scheduled the   interfaces as per the provided client timings.



    Updated the agents to take care about the scheduling part.



    Operating Systems



    :Unix



    Software / Special Tools



    ODI 11g , Oracle database, SVN, Filezilla



     



     



     



     


Project-6 (15 months)

    Responsibilities



    Created topology configuration to establish source and target connection.



    Created Interfaces- Mappings in Designer component of ODI with transformations to load the data in to DWH.



    Importing Source tables/ synonyms/views from source system using reverse engineering for the purpose of creating new Interfaces with transformation rules.



    Customized ODI Interfaces like adding new columns changing join conditions applying new business logic which needs to be reflected in the analytical systems.



    Created custom Interfaces by creating custom folders and created packages and scenarios for execution using load plans.



    Configured domain mappings and hierarchies, source domains, warehouse domains and externally confirmed dements in BIACM.




    Created new load plans and customized the load plans with customized interfaces in the place of Out Of Box interfaces withnew business logic.
    Created and configured Agent  to schedule the load plan at specified  timings

    Operating System
    Windows 2008 Server


    Software / Special Tools



    ODI 11g , Biapps 11g, BIACM,Oracle, SVN, filezilla



     



     



     


Project 7 (12 months)

    Responsibilities



     





     




     


     



    Operating Systems



    Windows 2008 R2



    Hardware



     



    Software / Special Tools



    ODI  ,Oracle ,Sql Server ,Informatica



    Languages



     




     



Project 8 (12 months)

    Responsibilities



     



     




    • Prepared TDD based on requirement using FDD.

    • Designing, Scheduling & Monitoring of ODI Interfaces executions

    • Performed various Performance Tuning techniques to improve the Interface performance.




    • Created new mappings based on Technical Design Document.



     




    • Created and configured topology and work repository and Models to implement interfaces.

    • Created packages, scenarios and variable and executed and loaded the data.

    • Implemented Migration activities in by whole repositories and individual objects.

    •  Configured smtp server and send mail tool in package to send automatic notifications to receive the interfaces execution status messages to the recipients.



     



    Operating Systems



    : Windows



     



     



    Software / Special Tools



    : ODI 11g , Oracle, SVN, filezilla



     



     



     



     


Project 9 (17 months)

    Responsibilities



     



     




    • Extensively used ODI (Oracle Data Integrator) ELT tool to create Data ware Housing OLAP model.




    • Created Interfaces- Mappings in Designer component of ODI with transformations to load the data in to DWH.

    • Created Packages to load sequences of Interfaces with using obi package event tools.

    • Used Journalization Knowledge module to create and configure Changed Data capture mechanism.

    •  Created local agents and configured them in Unix server.

    •  Based on server agent scheduled the interfaces   which needs to be run fortnightly basis.

    •  Created different profiles and users in security.




    • Implemented performance tuning strategies for fast data loads.



    Operating Systems



    : Windows , Unix



     



     



    Software / Special Tools



    : ODI  , Oracle, SVN, filezilla



     



     



     



     


Project: 10

Similar Talent