We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume Profile

Worcester, MA

SUMMARY:

  • 6 Years of experience in design, development, testing and maintenance of huge Data Warehouse and Integration environments for clients in manufacturing, financial and health care sectors.
  • More than 3yrs of ODI expertise and 1.5yrs on OWB in integration and ETL environments.
  • Strong knowledge of reporting using OBIEE 10g Answers and repository rpd .
  • Expertise in database programming using SQL, PL/SQL, DB Links, Stored Procedures, Functions and Triggers with Oracle.
  • Worked on creating and implementing physical databases and objects from relational and dimensional logical data models.
  • Sound knowledge of ODI, OWB and OBIEE architectures.
  • Experience of designing and implementing ETL loads for huge DW systems using ODI and OWB.
  • Experience of working on real time data warehouse environment using ODI.
  • Worked on customizing knowledge modules using jython substitution methods.
  • Expertise in implementing data lineage for environments where ETL-BI combination is ODI-OBIEE respectively.
  • Worked on integrating Oracle EBS data into Fusion Applications using ODI.
  • Expertise in loading data using Oracle SQL Loader.
  • Proficient in using UTL FILE and other Oracle supplied packages like DBMS APPLICATION INFO, DBMS CDC PUBLISH etc.
  • Experience in understanding the relational database concepts with strong SQL skills.
  • Worked on capturing changes in real time using CDC feature of Oracle.
  • Experience of working on POC, solution documents and effort estimates for client proposals.
  • Experienced in working with business users and top level management.
  • Excellent communication, interpersonal, Time management and presentation skills with results-oriented attitude.
  • Proficient in technical documentation containing high level as well as detailed level design considerations and best practices.
  • Proven track record of successful implementation of all projects from design, development and enhancements.
  • Experience of working in a product development environment.
  • Highly adaptive to a team environment and proven ability to work in a fast paced team environment.

TECHNICAL SKILLS:

  • ETL : Oracle Data Integrator ODI ,Oracle Warehouse Builder OWB
  • BI : OBIEE
  • Programming : Shell Scripting, PL/SQL
  • ERP Tools : Oracle E-Business Suite11i, R12
  • RDBMS : Oracle10g
  • Tools : Developer2000, Toad, PVCS, Kintana, Autosys, Microsoft Office System, SQL Developer
  • Platforms : Windows 98/NT/2000/XP/7, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Oracle PL/SQL Developer

The goal of Confidential project is to implement data warehouse solution for its core business administration system QNXT . This includes member, provider, network and claim management systems, enabling end users to pull reports for various analysis. In addition to this there are some feeds into EDW from vendor systems and some Oracle File extracts are being implemented to send the provider/member/claims data on monthly/weekly basis to the providers in/outside the network.

Responsibilities:

  • Installed and configured ODI in various environments.
  • Configured and administered ODI repositories, and Agents etc.
  • Worked on scenario migration from dev- Development Work Repository DWR to Test/ UAT -Execution Work Repository EWR environments.
  • Worked on different types of variables in ODI.
  • Worked extensively on configuring and capturing changes at source using JKMs.
  • Trained end users on ODI operator and Metadata Navigator on job schedules.
  • Creating physical table structures as per the data model.
  • Creating Facts and Dimensions for the Star schema design.
  • Handling administrative tasks like housekeeping of operator for better performance and taking back up of Master and Work repositories at regular intervals.
  • Configured and administered security mechanism for authentication and authorization of users to ODI repositories, Agents and other ODI objects.
  • Worked on interfaces for reading messages from JMS queues and XML sources.
  • Extensively worked on customizing the ODI Knowledge modules.
  • Monitored ODI Administration tasks such as: versioning, repository creation and backups, ETL monitoring, troubleshooting failures, and scheduling.
  • Reviewing source to target mappings and ETL flows.
  • Participating in ETL design walk throughs.
  • Generating extracts and sending provider/member/claims data to other health insurance companies.
  • Generating scenarios to feed files from vendor system to Oracle.
  • Implementing Type2 SCD on the required data stores.
  • Developing technical documents, implementing best practices in project.

Environment: Oracle Data Integrator 10g, Oracle 10g, Business Objects, UNIX, Autosys.

Confidential

Senior ODI Developer

The goal Confidential project is to implement real-time data warehouse solution for its Global Banking and Markets division. In addition to this there are some feeds into ODW from upstream systems and some Oracle File extracts are being implemented to send the details of transactions at the end of each day to few downstream systems.

Responsibilities:

  • Installed and configured ODI in dev and test environments.
  • Configured and administered ODI repositories, and Agents etc.
  • Monitored ODI Administration tasks such as: versioning, repository creation and backups, ETL monitoring, troubleshooting failures, and scheduling.
  • Worked on scenario migration from dev- Development Work Repository DWR to Test/ UAT -Execution Work Repository EWR environments.
  • Worked on different types of variables in ODI.
  • Worked extensively on configuring and capturing changes at source using JKMs.
  • Trained end users on ODI operator and Metadata Navigator on job schedules.
  • Creating physical table structures as per the data model.
  • Creating Facts and Dimensions for the Star schema design.
  • Handling administrative tasks like housekeeping of operator for better performance and taking back up of Master and Work repositories at regular intervals.
  • Configured and administered security mechanism for authentication and authorization of users to ODI repositories, Agents and other ODI objects.
  • Worked on interfaces for reading messages from JMS queues and XML sources.
  • Extensively worked on customizing the ODI Knowledge modules.
  • Reviewing source to target mappings and ETL flows.
  • Participating in design walk throughs.
  • Generating extracts and sending files to downstream systems for reconciliation.
  • Generating scenarios to feed files from upstream system to Oracle.
  • Implementing Type2 SCD on the required data stores.
  • Developing technical documents, implementing best practices in project.

Environment: Oracle Data Integrator 10g, Oracle Business Intelligence Enterprise Edition 10g, Oracle 10g,UNIX, Autosys.

Confidential

ODI Developer

This project involves migrating data from Oracle EBS to Fusion Apps for Oracle Projects module. Interfaces generated in ODI are executed, to migrate the data from EBS to Fusion apps.

Responsibilities:

  • Created interfaces from mapping documents for integrating data from EBS to Oracle Fusion Apps.
  • Created complex packages to group a set of interfaces, generating scenarios and scheduling jobs for each sub module of the Oracle projects module.
  • Created packages which call the sub modules' scenario and loading targets in sequence or in parallel considering the target dependencies.
  • Setting the execution areas, context, flow and controls for the interfaces for data quality and data validation both at source and target areas.
  • Used RKMs for Reverse engineering the model to fetch the required tables from database to model.
  • Choosing appropriate KMs for loading the target data stores.
  • Used CKMs for validating constraints on the data flowing into the target data store.
  • Generating Interfaces, packages and scenarios.
  • Extensively worked on creating ODI packages for executing scenarios both in synchronous and in asynchronous mode.
  • Executing the interfaces and packages and validating the data that is migrated.
  • Worked on implementing pre-migration and post-migration procedures and populating audit tables with the status of loading for each of the target data store.
  • Worked on generating diagnosis report on the status of execution of a source table including the exceptions.
  • Responsible for implementing a template scenario which takes source table and validation table as input and populates audit tables accordingly.
  • Developing technical documents on the approach for migrating particular source table to a particular target.

Environment: Oracle 10g, Oracle Data Integrator 11g, Windows, MS- Excel

Confidential

ODI Developer

Confidential is one of the largest manufacturers of electric motors in the world. The company has manufacturing, sales, and service facilities throughout the United States, Canada, Mexico, Europe and Asia. This project involved in design, development and maintenance of a data warehouse enabling users to analyze, budget, plan and forecast their sales across regions and periods to align strategic objectives to organizational goals.

Responsibilities:

  • Involved in the overall design of data warehouse using ODI.
  • Designed common frame work for integrations of Metadata and Data from various source systems which include Oracle and flat files.
  • Defined standards and procedures and refined methods and techniques for data extraction, transformation and loading ETL using ODI.
  • Developed critical interfaces to load multiple similar targets for data loads.
  • Extensively worked on customizing the ODI Knowledge modules to enhance performance of the loads.
  • Trained Test and Support Teams on ODI operator and Metadata Navigator on scheduling jobs.
  • Responsible for implementing OBIEE-ODI data lineage.
  • Responsible for the end-to-end migrations of Master, Work repositories and other ODI objects.
  • Responsible for all the technical design documents, Test cases and mapping documents.
  • Generating ODI mappings to populate lineage tables with ODI metadata.
  • Generating the web catalog in text format from OBIEE answers and populating the metadata of OBIEE into Lineage tables using ODI interfaces.
  • Generating OBIEE reports to enable admin users to do report-ETL source impact analysis and interface-report impact analysis.
  • Developing technical documents on the approach for achieving the lineage.

Environment: Oracle Data Integrator 10g, Oracle Business Enterprise Edition 10g, Oracle 10g, Windows.

Confidential

OWB Developer

This project includes development of data warehouse to extract data from various source systems, legacy and core applications systems on Oracle, using OWB and enabling users to create/view reports pertaining to the performance of various loan products using OBIEE.

Responsibilities:

  • Expertise in using Designer with Oracle Warehouse Builder.
  • Made use of DB Links for accessing data across different databases.
  • Configuring source Oracle database to capture changes using CDC feature of oracle.
  • Extracting data from various sources using MV Log or Asynchronous Hot log method depending on the source.
  • Loading change data into staging tables using OWB mappings.
  • Creating, deploying and executing the mappings in OWB using control centre.
  • Created complex mappings and process flows to load targets with incremental data.
  • Created Materialized View for loading the data into targets.
  • Coordinating ETL and BI teams for data gaps if any.
  • Worked on complex master detailed reports in OBIEE.
  • Implementing calculations at both rpd and answers.
  • Developed different kinds of Reports pivots, tabular .
  • Creating technical design documents, mapping and test cases documents.

Environment: Oracle 10g, Oracle Warehouse Builder 10g, OBIEE 10g, Windows, MS- Excel

Confidential

Oracle PL/SQL Developer

Confidential leading supplier of various devices ranging from Network systems, Security devices, mobile and wireless devices for communication and data centers and collaboration and video devices.Confidential includes integrating many legacy applications used for ordering into one Oracle iStore application allowing its partners to book orders at the same time applying any deals if applicable for that particular partner in a very user friendly environment.

Responsibilities:

  • Responsible for implementing change requests and bug fixes using Advanced plsql on Oracle iStore
  • Developing technical specifications from the change request document.
  • Implementing functions, procedures and functions using PL/SQL table types.
  • Coding and Unit Testing of the components using wrappers and from iStore front end.
  • Involved in code merge activities for production migration.
  • Played the role of configuration manager and Defect Prevention activities for this implementation.
  • Taking up production and post support activities during go-live.
  • Using PVCS and Kintana for version control and code migration respectively.

Environment: Oracle 10g, Oracle iStore , PVCS, Kintana, HP Quality Cetre

Confidential

Oracle PL/SQL Developer

Confidential customers reduce plant maintenance cost, reduce capital requirements, reduce cost of regulatory compliance, and increase process availability. This is enabled by world class products such as Fisher control valves, instrumentation and performance services, which are the most reliable in the process control industry.This project includes converting the existing legacy system for Order management into Oracle E-Business Suite 11i and implementing other extensions for export compliance, interfaces and reports for one of its sites.

Responsibilities:

  • Responsible for implementing many RICE components cutting across various functional modules like OM, WIP, Inventory, Quality, BOM, PO and GL.
  • Understanding and converting the functional requirements into technical specifications.
  • Worked extensively on PL/SQL and workflow customization.
  • Worked on Interfaces both inbound and outbound to Oracle using UTL FILE package.
  • Implementing packages, procedures and functions for export compliance checks and cost addition depending on the manufacturing area.
  • Developed Reports using Oracle Reports6i and XML publisher.
  • Extensive knowledge in data migration using SQL Loader.
  • Used File Transfer Protocol FTP tool to transfer files from one server to other.
  • Experience in application and database fine-tuning using Explain Plan and TKProf.
  • Using PVCS and Kintana for version control and code migration respectively.

Environment: Oracle 10g, Oracle E-Business Suite 11i, UNIX, Windows, MS Excel.

Hire Now