We provide IT Staff Augmentation Services!

Oracle Fusion Middleware Consultant Resu

ME

Professional Summary: Over 6+ years of IT experience with emphasis and expertise in Oracle Fusion Middleware including three years of implementation experience in Oracle Applications 11i modules (INV, BOM, OM, PO, AR, AP, GL, AOL, SysAdmin) Oracle SOA Suite

  • Expertise in developing and deploying BPEL Processes using technology adapters ( Oracle Applications, DB Adapter, File Adapter, FTP Adapter, JMS Adapter), Fault handling(catch and catchall), Messaging and Alerts , Transformations and Sensors
  • Excellent understanding of Service Oriented Architecture (SOA) with the middleware technologies and using Oracle AS and BPEL PM for application integration
  • Very good experience with Web Services, XML, XSL, XSLT, XPATH, XQuery, WSDL, Java, BAM and Oracle Business Rules Engine
  • Expertise with JDeveloper, PL/SQL Developer, Toad, SQL*plus and Eclipse
  • Good experience with implementing Human Workflow into BPEL orchestration, creating Business Rules, Rule sets, Dictionary of rules and rules Repository
  • Very good knowledge in Canonical Models and Application Integration Architecture (AIA)

Oracle Applications

  • Extensive experience in Implementation, Customization, Production and Support of Oracle Applications 11i Financials modules(AR, AP and GL, AOL and System Administration)
  • Expertise with Oracle Developer 2000 (Forms6i and Reports6i), Workflow and PL/SQL
  • Extensive experience in developing Interface/Conversion programs to import data from legacy systems to Oracle Applications using PL/SQL, SQL Loader and UTL Files
  • Extensive experience in customization of standard forms, customization of reports, defining concurrent programs, defining value sets, defining form functions and functional setups
  • Strong programming experience in creating Procedures, Packages, Cursors, Functions, Triggers and other database objects using SQL and PL/SQL
  • Proficient in writing and tuning complex SQL statements
  • Expertise in development, implementation and customization of Workflows Experienced with Full Project life cycle and well versed with AIM and SDLC methodologies

Technical Skills:

ERP:Oracle Applications 11.5.10(11i), 11.0.3, Oracle Financials (GL, AP, AR), Oracle Manufacturing (INV, OE/OM, PO, WIP, BOM), SysAdmin, AOL Fusion Middleware:Oracle SOA Suite (10.1.3.1/10.1.3.3), Oracle Application Server OC4J, Oracle BPEL Process Manager, OWSM, ESB, BAM, UDDI, B2B Adapters:Oracle Apps, File, FTP, JMS, DB Adapter Software Tools:Oracle JDeveloper, PL/SQL Developer, Toad, SQL* Plus, UML Languages:BPEL, PL/SQL, SQL, Java, C++, C, HTML, XML, XSD, XSLT, XPath, WSDL GUI Tools:Forms 6i/4.5, Report 6i/2.5, BI Publisher, Workflow 3.0 Databases:Oracle 10g/9i/8i, SQLServer7.0/2000 Operating Systems:Linux (RedHat, Fedora, CentOS), Unix(Solaris), Windows(All Flavors) Others:AIM Methodology, SDLC, CMMI

Work Experience:

Confidential, ME Jun '10 to Present Oracle Fusion Middleware Consultant Fusion Middleware

  • Design, develop and deploy Business Processes Orchestrated in BPEL and ESB using Oracle JDeveloper and SOA Suite 11g
  • Fully designed and developed a BPEL process to integrate Oracle Applications 11i (E-Business Suite) The deployed BPEL process used Oracle Applications Adapters, File Adapters, FTP Adapter. This Orchestrated BPEL Process had process activities like data conversion, transformation and fault handling
  • Developed and deployed BPEL processes to import sales order and add lines to the sales order imported from external sources (Files and Databases) into Order Management (OM) Module. Used the OM Sales Order Open Interfaces and Oracle Applications Adapter
  • Developed and deployed BPEL process to create sales order within OM module using the Oracle Public API: OE_ORDER_PUB.PROCESS_ORDER. The deployed BPEL process uses Oracle Apps Adapter
  • Used DB Adapters and Oracle ESB to integrate between Oracle database 10g and Microsoft SQL database in order to transfer data from MS SQL to Oracle database on specific table changes
  • Upload file into/from ftp location to Oracle Database. FTP and DB adapters were used with Oracle ESB
  • Extensively used Fault and Error handling capabilities (Catch and Catch All), Synchronous and Asynchronous processes, Transformations, XSD, XSLT and XPath
  • Expertise in using PL/SQL API's, Open Interfaces and custom coding of PL/SQL Packages and using them within the BPEL using Oracle Applications Adapter
  • Created dictionary of business rules containing rules and rule sets within the Business Rules Repository
  • Installation of Middle tier application server (SOA Suite 10.1.3.x), configuring and deploying application adapters and integrating with E-Business Suite
  • Mentoring the client team in developing BPEL processes, and communicating with the business teams regarding integration with external PeopleSoft System

Environment: Oracle SOA Suite 10.1.3.3, BPEL, ESB, BAM, Oracle Applications 11.5.10.2, (INV, OM, PO, AP, AR, GL), Oracle JDeveloper, Oracle AS 10.1.3.3, Oracle BPEL PM 10.1.3.3, OWSM, Adapters (Oracle Applications, DB, File, FTP, AQ, MQ, JMS), Oracle Database 10g/9i, PL/SQL developer, Toad, Forms 6i, Reports 6i, BI Publisher

Confidential, IL Jan '09 to May'10 Oracle Fusion Middleware Consultant Fusion Middleware

  • Fully designed and developed a BPEL process to integrate Oracle Applications 11i (E-Business Suite).
  • Invoked BPEL Process thru PL/SQL.
  • Deployed BPEL Process using ANT scripts.
  • Developed and deployed BPEL processes to import Journals from external sources (Files and Databases) into General Ledger (GL) Module. Used the GL Journal Interfaces and Oracle Applications Adapter
  • Resolved various issues related to seeded BPEL process on OTM (Oracle Transaction Management) side.
  • Used DB Adapters and Oracle ESB to integrate between Oracle database 10g and Microsoft SQL database in order to transfer data from MS SQL to Oracle database on specific table changes
  • Upload file into/from ftp location to Oracle Database. FTP and DB adapters were used with Oracle ESB
  • Extensively used Fault and Error handling capabilities (Catch and Catch All), Synchronous and Asynchronous processes, Transformations, XSD, XSLT and XPath
  • Created dictionary of business rules containing rules and rule sets within the Business Rules Repository.
  • Rules were created/updated using Rule Author GUI provided in Oracle Business Rules.
  • Implemented User Interaction in Business Process using Human Workflow.
  • Expertise in using PL/SQL API's, Open Interfaces and custom coding of PL/SQL Packages and using them within the BPEL using Oracle Applications Adapter
  • Developed Report in Reports 6i to suit the company business requirement to create Debit Memo/Credit Memo when there is a difference with customer agreement rate and unit selling price in the Invoice. This Report extracts data from various base tables within Order Management and Receivables
  • Did setup for attaching workflow process to transaction type header and line type. Defined order number document sequence and attached it to the transaction type
  • Helped testers by canceling various concurrent programs in several occasions from back end
  • Developed technical documentations of work done complying with AIM Methodologies

Environment: Oracle SOA Suite 10.1.3.3, BPEL, ESB, BAM, Oracle Applications 11.5.10.2, (INV, OM, PO, AP, AR, GL), Oracle JDeveloper, Oracle AS 10.1.3.3, Oracle BPEL PM 10.1.3.3, OWSM, Adapters (Oracle Applications, DB, File, FTP, AQ, MQ, JMS), Oracle Database 10g/9i, PL/SQL developer, Toad, Forms 6i, Reports 6i, BI Publisher

Confidential, IN Mar'07 to Dec'08 Oracle Apps Technical Consultant

  • Defined custom responsibility and excluded some of the menu items in order to restrict the user from using them
  • Involved in the development of forms, reports, database procedures, packages, database triggers and interfaces for data exchange
  • Registration of customized reports through creation of concurrent executables, concurrent programs, and assigning them to the request group
  • Developed interface programs for Inventory items and transactions
  • Developed PL/SQL packages, procedures and functions for interface programs to validate the data for the following modules AR, GL, OM, and INV
  • Developed package and triggers to enforce complex business rules using PL/SQL
  • Changed configuration to Shipping, OM, and INV setups as needed to address issues, improve performance, and ensure proper flow of data to 3rd party systems
  • Customized Positive Pay Report by modifying file layout and data requirements furnished by bank to be sent to them on daily basis
  • Customized forms in Service Contracts and Advanced pricing like changing various field names, attaching LOV's, adding fields using CUSTOM.pll. Expertise in developing forms with triggers, alerts, parameters, multiple canvases and multiple windows
  • Worked in the support role, performed the responsibility of system administration tasks like creating users, setting up the user profile, etc
  • Developed UAT plans for all test cases. Documented test cases corresponding to business rules and other operating conditions

Environment: Oracle Applications 11.5.3 (GL, AP, AR, INV, OM, PO), PL/SQL, SQL * plus, Oracle 8i, TOAD, Reports 6i, Oracle Workflow Builder 2.6, Solaris, Windows NT

Confidential, TX Jan '06 to Feb '07 Oracle APPS DEVELOPER

  • Responsibilities included design and development of forms, reports, stored procedures, packages, database triggers and interfaces using PL/SQL
  • Extensively used inbound and outbound interface programs and API's in INV and OM modules
  • Developed PL/SQL packages, procedures and functions to validate the inbound and outbound interfaces
  • Developed packages and triggers to enforce complex business rules using PL/SQL
  • Customized forms and assigned them to Menus within Oracle Applications
  • Customized the Item Quantity Summary report to include the Inventory Org Code and Sub Inventory Columns
  • Registered customized reports through creation of concurrent executables, concurrent programs, and assigning them to the request groups and responsibilities
  • Involved in testing and debugging activities during the development phase

Environment: Oracle Applications 11.0 (INV, OM, PO), PL/SQL, SQL * plus, Oracle 8i, TOAD, *Willing to Relocate

Hire Now