Oracle Fusion Middleware Developer
Resume:
SUMMARY:
• Over ** years of experience in providing cost effective solutions by using Oracle ERP and related technologies, my experience spread across Implementations, data migrations, Interfaces, conversions, Enhancements of Oracle Application to ensure business needs are met. Strong technical experience in Oracle Applications 11i modules (Financials & Supply Chain ),(AR, AP, GL, FA, INV, OM, PO, AOL, HRMS, SysAdmin) and Oracle Energy of which most recent 2 year of experience is also with BPEL Process Orchestration and Oracle SOA Suite Fusion Middleware
• Expertise with BPEL process Orchestration and Enterprise Service Bus (ESB) for integrating ERP applications (Oracle Applications, Hyperion, BAAN, D1), Databases, legacy applications, Flat Files and Portals.
• Expertise with JDeveloper, PL/SQL Developer, Toad, SQL*plus. Good experience with implementing Human Workflow into BPEL orchestration, creating Business Rules, Rule sets, Dictionary of rules and rules Repository
• Expertise in developing and deploying BPEL Processes using technology adapters (Oracle Applications, DB Adapter, File Adapter, FTP Adapter), Fault handling (catch and catchall), Messaging and Alerts and Transformations.
• 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.
• Very good knowledge in Canonical Models and Application Integration Architecture (AIA), Oracle Service Bus, SoaSuite 11g, Business Activity Monitor (BAM), Participated in WebLogic/AquaLogic Implementation Boot Camp.
• Good understanding of BEA Weblogic Application Server.
Oracle Applications:
• Extensive experience in Implementation, Customization, Production and Support of Oracle Applications 11i/R12 Financials/SCM modules (AR, AP, GL, FA, INV, OM, PO, AOL, SysAdmin)
• Having good knowledge of System Administrator in defining users, menus, responsibilities, printer set-ups and maintaining concurrent programs.
• Strong experience and expertise in Oracle Application RICE (Reports, Interfaces, Conversions, Extensions) development using the Development Suite/tools (like Forms, Reports, PLSQL, Workflow, SQL*Loader, Jdeveloper etc).
• Strong in PL/SQL coding, stored procedures, Functions, database triggers and Unix Shell scripting.
• Customized and developed reporting strategies as per business needs.
• Main role involved in current project is to support user in day-to-day operational issues in both technical and functional areas related Oracle Financials.
• Involved in developing various inbound and outbound interfaces/API to integrate with other systems data.
• Having very good experience in developing custom process for data conversions.
• Support & Issue Management: Have good exposure in outsourced project environment. Worked with ‘Oracle outsource support team’ to get fixes for issues, patch applications process and system maintenance.
• 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
• Experienced with Full Project life cycle and well versed with AIM and SDLC methodologies
TECHNICAL SKILLS:
ERP\ Fusion Middleware\
Oracle Applications R12 \ 11.5.10(11i), \ Oracle SOA Suite (10.1.3.1/10.1.3.3), \
11.0.3, Oracle Financials (FA, GL, \ Oracle Application Server OC4J, Oracle\
AP, AR), Oracle Manufacturing \ BPEL Process Manager, OWSM, ESB, \
(INV, OE/OM, PO, WIP, BOM), \ BAM, UDDI, B2B\
SysAdmin, AOL\
Software Tools\ Adapters\
Oracle JDeveloper, PL/SQL \ Oracle Apps, File, FTP, JMS, \
Developer, Toad, SQL* Plus, UML\ DB, AQ Adapter\
Languages\ GUI Tools\
BPEL, PL/SQL, SQL, Java, C++, C, \ Forms 6i/4.5, Report 6i/2.5, BI \
HTML, XML, XSD, XSLT, XPath, \ Publisher, Workflow 3.0\
WSDL\
Operating Systems\ Databases\
Linux (RedHat), Unix (Solaris, IBM \ Oracle 10g/9i/8i, SQLServer7.0/2000\
AIX), Windows (All Flavors)\
Others\
AIM Methodology, SDLC\
PROFESSIONAL EXPERIENCE:
PROBUILD, Denver, CO SEP 08 – TILL DATE
Oracle Apps/Fusion Middleware Consultant
Responsibilities:
Fusion Middleware:
• Design, develop and deploy Business Processes Orchestrated in BPEL and ESB using Oracle JDeveloper and SOA Suite 10.1.3.3
• Fully designed and developed a BPEL process to publish legacy data into Oracle E-Business Suite Open interface tables using APPS-Adapter.
• Deployed BPEL Suitcases to a specific domain.
• Implemented BPEL Process Rejection Handler (File system based).
• Performed propagation of E-Business Suits events with Enterprise Service Bus.
• Invoked BPEL Process thru PL/SQL.
• Deployed BPEL Process using ANT scripts.
• Resolved various issues related to seeded BPEL process on OTM (Oracle Transaction Management) side. Implemented Rule based subscription for Multi consumer Queues in AQ Adapters.
• Mapped variables from multiple sources in a transformation.
• Trapped Error Message in the CatchAll branch of BPEL Process.
• Worked of Form Personalization in various modules of Oracle Applications.
Environment:
Oracle SOA Suite 10.1.3.4, BPEL, ESB, BAM, Oracle Applications R12, (PO, AP, AR, GL), Oracle JDeveloper, Oracle AS 10.1.3.4, Oracle BPEL PM 10.1.3.4, OWSM, Adapters (Oracle Applications, DB, File, FTP, AQ), Oracle Database 10g/9i, PL/SQL developer, Toad, Forms 6i, Reports 6i, BI Publisher
FUJITSU, Dallas, TX MARCH 08 - AUG 08
Oracle Apps/Fusion Middleware Consultant
Responsibilities:
Fusion Middleware:
• Design, develop and deploy Business Processes Orchestrated in BPEL and ESB using Oracle JDeveloper and SOA Suite 10.1.3.3
• Fully designed and developed a BPEL process to integrate Oracle Applications 11i (E-Business Suite) Inventory Module (INV) with external applications/Flat Files for inbound material transactions. The deployed BPEL process used Oracle Applications Adapters, File Adapters, FTP Adapter and Oracle Material Transaction Open Interface. This Orchestrated BPEL Process had process activities like data conversion, transformation and fault handling
• 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
• Installation of Middle tier application server (SOA Suite 10.1.3.x), configuring and deploying application adapters and integrating with E-Business Suite
Oracle Applications:
• Worked on data conversion including Customer (TCA), Fixed Asset, General Ledger journal import.
• Customized Positive Pay Report by modifying file layout and data requirements furnished by bank to be sent to them on daily basis
• Customized Fixed Asset Workflow (FA Account Generator)
• Resolved Order Management Workflow Data corruption issues and customized the seeded workflow as per the business needs.
• Customized and created alert to send email when an order ships.
• Worked on HR Employee Conversion using HR_EMPLOYEE_APIs. Interfaced addresses of employees/people in Oracle HRMS.
• Migrated SIT (special information types) into Oracle HRMS using HR_SIT_API.
• Worked on Inbound/Outbound interfaces in Manufacturing Modules specific to Fujitsu Warehouse needs.
• Worked on Stock Locators, Item cost Conversion and Open purchase order conversion.
• Very Well versed with the data flow (Order to Cash) spanning various modules.
• Worked on integration of Vertex Quantum Series and D&B with Oracle Applications which involved setups in Oracle Applications, analyzing its impact on customer conversion, fixed asset and supplier conversion and modifying code accordingly
• Translation of business requirements (MD50s) into technical specifications (MD70s).
• Coordinating and facilitating offshore development.
• Ensuring the implementation adheres to all standards and methodologies.
• Involved in the database design, SQL Loader Scripts for data conversion from Legacy systems into Oracle Systems.
• Implemented the auto lockbox to load the receipts.
• Product Support, Trouble shoot issue and End-User training.
Environment:
Oracle SOA Suite 10.1.3.3, BPEL, ESB, BAM, Oracle Applications(financials & Supply Chain), (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
PETROLEUM PLACE ENERGY SOLUTIONS, Houston, TX JULY 06 - FEB 08
Oracle Apps/Fusion Middleware Consultant
Responsibilities:
Fusion Middleware:
• Design, develop and deploy Business Processes Orchestrated in BPEL and ESB using Oracle JDeveloper and SOA Suite 10.1.3.3
• Developed and deployed BPEL processes to import FLAT FILES from external sources (Files and Databases) into Oracle Energy. Used DB Adapters and Oracle ESB to integrate between Oracle database 10g and various other database sources.
• Upload file into/from ftp location to Oracle Database. FTP and DB adapters were used with Oracle ESB
Oracle Applications:
• Responsible for implementing different energy modules for P2ES Clients such as Hunt Petroleum, Sheridan, Highmount, Swift etc.
• Worked on various modules of Enterprise Upstream Global Solutions, like Authorization for Expenditure, Joint Venture Accounting, Revenue Settlement, Lease Management and Field Operations Involved in coding interface for loading Legacy data.
• Worked on integration of Oracle Energy and Oracle Financials/Supply Chain modules.
• Worked on Customer Interface, used Auto Invoice import program to load legacy data into Oracle Receivable tables.
• Worked on Open Sales Order conversion and On hand quantities conversion.
• Setup financial statements, generator reports and other standard report for periodic and year end accounting.
• Design and developed validation process in PL-SQL to load legacy invoices into AP.
• Developed Application Extension MD070s using AIM methodology by reviewing MD050s and interacted with functional team to build technical extensions.
• Defined customer profiles, customers, payment terms, payment methods and tax structures, including tax exemptions and exceptions in Accounts Receivables
• Extensively used AOL for registering concurrent programs, request sets, creating custom value sets.
• Familiar with various tools like TOAD, SQL Developer, and JDeveloper for coding PL/SQL programs. Also has working knowledge of XML Publisher and OA Framework.
• Involved in writing Technical Specifications
Environment:
Oracle Applications 11.5.8 (Energy, PO, GL, AP, AR, OM), PL/SQL, SQL * plus, Oracle Database 9i, TOAD, Reports 6i, Oracle Workflow Builder 2.6, UNIX
PETROLEUM PLACE ENERGY SOLUTIONS, Denver, CO JAN 05 - MAY 06
Oracle Apps Technical Consultant
P2ES is the Oil & GAS sector’s largest owner and provider of enterprise solutions encompassing financial and operational software, implementation, and integration and outsourcing services, mapping data and storage systems.
Responsibilities:
• Worked on Enterprise Upstream software applications Involved in coding core API’, developed and maintenance of various forms. Also used FOLDERS, SPECIAL triggers in some of the forms extensively coded PL/SQL programs.
• Handled various productions issues related to FORMS & PL/SQL programs. Involved in writing Technical Specifications.
• Extensively used AOL for registering concurrent programs, request sets, creating custom value sets.
• Involved in writing SQL* Loader script and PL/SQL programs for loading, data Mapping, data conversions and validating the data into the staging/target tables from the Legacy source
Environment:
Oracle Applications 11.5.3 (GL, AP, AR, Energy, Supply Chain), PL/SQL, SQL * plus, Oracle 8i, TOAD, Reports 6i, Oracle Workflow Builder 2.6, Solaris, Windows NT
STATE STREET, Boston, MA JULY 04 - NOV 04
Oracle Apps Technical Consultant
Responsibilities:
• Developed various custom conversion processes in purchasing. It includes vendors, New Banks, Bank Accounts, Purchase orders and related attachments.
• Developed custom package to validate this data based on system/client requirements and imported into oracle. Developed custom conversion processes to import Cross Reference Rules for GL code combination in General Ledger.
• Developed interfaces to import payable invoices.
• Entered and processed various transactions such as Invoice, Debit Memo, Credit Memo and Deposit. Worked on Auto Invoice and Customer Interface, Entered Receipts and Receipt Information.
• Creation of SQL*Loader control programs and PL/SQL validation procedures to execute along with Customer Interface (AR), and Order Import Interface (OE) programs to support the interface requirements.
• Completed the Receivables Cycle by running the Concurrent Process to transfer transaction information from Oracle Receivables to Oracle General Ledger.
• Troubleshoot various issues related to customer interface. Extensively coded PL/SQL programs using FND_FILE, FND_MESSAGE, FND_CONCURRENT, FND_REQUEST, FND_GLOBAL.APPS_INITIALIZE and FND_SUBMIT Packages.
• Involved in writing Technical Specifications for AR & AP modules.
• Worked on GL Intercompany Transactions using GL_IEA_INTERFACE tables.
Environment:
Oracle Applications 11.0 (INV, OM, PO), PL/SQL, SQL*plus, Oracle 8i, TOAD, Reports 6i, UNIX
ASHOK LEYLAND FINANCE, INDIA MARCH 98 - APR 04
Oracle Apps Developer/PLSQL developer
Responsibilities:
• Worked on conversions and customizations (Reports) of different modules extensively worked on GL, AR, AP The forms involved Procedures, Record Groups, LOV, Alerts, Parameters, Global Variables, Multiple Canvases, Multiple Windows, Multiple Blocks, Control Block and triggers at various levels.
• Developed new reports to suit Customer needs The Reports involved Matrix, Group Above with complex queries in Data Model, Complex Layouts, Used the functionality of Additional Default Layout, Parameters, Program Units, and the use of Report Triggers, Used Anchors for vertical and horizontal positioning of objects.
• Developed a custom form to create, update and view attribute information for the Account String using the Descriptive Flex Fields.
• Implementation tasks includes; requirements gathering, installation of Oracle database and E-Business application, design of all required fields for Oracle financials, completing the required setup steps for all modules installed, porting of legacy data, developing test scenarios, and end-user training.
• Involved in custom Application development using Oracle Dev2000 and PLSQL.
Environment:
Oracle Applications 10.0, Oracle Dev2000, (PL/SQL, SQL*plus, Oracle 8i, TOAD, Reports 6i, UNIX
Contact this candidate