SUMMARY

• Over 6 years of Oracle experience related to analysis, design, development for Oracle SOA and Oracle Applications R12/11i Implementations
• Expertise in the design and development of RICE (Reports, Interfaces, Conversions & Enhancements) programs
• Experience in implementing Service Oriented Architecture using Fusion middleware components such as Oracle BPEL Process Manager and Oracle ESB layers
• Working Expertise in Human Workflows, File Adapters, AQ Adapters, OA Adapters and DB Adapters in BPEL processes
• Expertise in Oracle Applications Framework(OAF) and Application Development Framework(ADF)
• Expertise in Development of Reports using XML and BI publisher
• Expertise in deploying and monitoring the Fusion middleware components using Oracle BPEL console and Oracle ESB console
• Expertise in AIA ( Application Integration Architecture) and B2B ( Business to Business) integration methodologies
• Technical development experience in Order Management, Oracle Receivables, Inventory, Oracle Projects, Accounts Payable and Purchasing modules of Oracle Applications 11i
• Expertise in design and development of Interfaces to external systems using Oracle Applications open interface API’s
• Auditing, Configuration and Performance Tuning for BPEL processes at the Domain and Process Level
• Experienced in Developing Technical Specification and Design Documents using Oracle’s AIM methodology
• Excellent understanding of System Administration, database architecture and performance tuning
• Experienced in supporting testing events (CRP, UAT and QA), performing post go - live stabilization and providing extended maintenance support
• Excellent communication and inter-personal skills with the ability to thrive in a team oriented environment

TECHNICAL SKILLS

ERP: Oracle Applications Release 11i and Release 12 (OM, Inventory, PO, AR, AP, GL, PA, SYSADMIN, AOL)

RDBMS: Oracle 8i/9i/10g, MS Access

Middleware: Oracle SOA Suite 10g/11g Oracle BPEL Process Manager, ESB Controller, Business Activity Monitoring (BAM)

Tools: Reports, Forms, Workflow Builder, BI PublisherSQL*Plus, SQL*loader, Discoverer 4i, 10g, TOAD, XML Publisher, SQL Developer, JDeveloper 10g/11g, soap-UI 2.0.

Operating Systems: UNIX, Linux, Windows 2000/NT/XP, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. Oracle Applications Developer

Responsibilities:

• Upgrade from SOA Suite 10g to 11g - Migrated all the SOA components from 10g ( 10.1.3.4) to SOA 11g (11.1.1.5.0 )
• Design and Development of SOA process for the Oracle Inbound Purchase Orders and Payables Invoices
• Developed Application Development Framework page to view the Global Logging Data for all the Interfaces in the system
• Worked with form personalization to personalize oracle standard forms to meet the business requirements
• Developed Item Create, TCEEN, Item Update and BOM Report processes in Oracle SOA to interface Oracle EBS with Team Center
• Designed and Developed Item attributes update workflow to send email notifications to users upon Item creation and update
• Designed, developed and customized Oracle Reports and XML Publisher Reports
• Designed and Developed Custom Forms to enter the Customer Operations and Rebates as the clients requirements
• Developed various Interface Programs to Create Debit Memos, Cash Receipts and Invoices and applying Credit Memos
• Developed Workflows to send notifications to the users about the statuses of the Rebates and the Users can approve/reject the Rebates
• Designed and developed custom form to enter product, location, contacts and partner master data as per the end user requirements
• Developed Workflows to Send Notifications to users and Workflows for Account Generation in AP, PO and AR modules
• Worked with Kronos Project Hours and WIP jobs Interfaces to Interface Kronos and Oracle EBS to send Project Hours to EBS
• Developed French deductible VAT declaration report in XML Publisher
• Prepared Technical Design Documents (MD70) for all the objects developed

Environment: Oracle EBS 12.1.3, SOA 10g/11g, Workflow, XML Publisher

Confidential, Palo Alto, CA

Integration Analyst

Responsibilities:

• Design and Development of middleware solution for EDI 810 Outbound Invoice Interface with integration between Oracle EBS and other vendors
• Design and Development of middleware solution for EDI 820 Payment Order /Remittance Advice, an Inbound Interface into Oracle EBS
• Designed and Developed an Oracle form to assign a new collector or to change customer/region parameters
• Design and development of several interfaces using Oracle Fusion Middleware components to interface Oracle and Fieldglass
• Expertise in Human Workflows, File Adapters, AQ Adapters, OA Adapters and DB Adapters in BPEL processes.
• Create Validation Packages to validate the item attributes, lot details that are transferred through interfaces to various systems.
• Create triggers to raise custom business events where in the ESB process captures the business event the routes to the appropriate BPEL process
• Developed Receivables Invoice Summary Report using BI Publisher to get the year/quarterly Invoice Summary
• Developed BI publisher reports to query the Service contract data from Oracle EBS
• Prepared Technical Design Documents (MD70) for all the objects developed
• Migrated Code and Maintained versions using Perforce and HP PPM tool

Environment: Oracle Applications R12, Oracle JDeveloper 10.1.3.4, SOA Suite 10gOracle Forms 6i, BI Publisher, MKS Version Control, Discoverer 10g.

Confidential, North Wales, PA

Oracle Integration Developer

Responsibilities:

• Design and development of middleware solution for integration and data conversion between Manhattan WMS (Warehouse Management System) and IBM’s TS (Traceability Server) for pedigree generation
• Developed technical specifications for Oracle ERP system product and location Master Data Import, PIX event generations and Shipment Pallet transfers
• Designed and developed custom form to enter product, location, contacts and partner master data as per the end user requirements
• Developed ESB Processes to capture custom business events and route them to different systems depending upon business requirements
• Designed and developed an email notification interface to send email notifications upon exceptions in the BPEL processes
• Design and Development of middleware solution for integration and data conversion between Trackwise and Oracle Applications for pedigree generation
• Used different Adapters like OA adapter, Database adapter, File adapter, AQ adapter, JMS Adapter and Queues like MQ, AQ and JMS Queues in the Interfaces developed
• Designed and Developed middleware solution for Interfaces between Oracle Applications and PROSA to Create/Update Projects, Tasks, Classifications and Key Members in the Oracle Projects
• Designed and Developed BPEL Processes for Interface between Oracle Applications and PROSA for Creation of Invoices and Vendor Master Information
• Responsible for developing several BPEL interfaces for integrating Oracle with Manhattan Associates WM.
• Developed BPEL interfaces for bridging Pick tickets and ASNs (Advanced Shipment Notice) to WM and receive the PIXs for the corresponding ASNs.
• Used a global business event that is triggered from oracle and used an Oracle Apps adapter to capture the event and route the process.
• Designed and developed a methodology to provide the user with the ability to modify the XML message.
• Used Dynamic Entity Forms to parse and load the XML into Oracle Dynamic Entity Forms. The parsed XML would be in flat user friendly form structure.
• The modified fields are then transformed into XML message as per the XML schema.
• Responsible for maintaining the error reprocess OA form.
• Prepared TDS for all the interfaces and its related objects.

Environment: Oracle Applications R12, Oracle JDeveloper 11.1.1.2.0 , SOA Suite 11g, AIA, Oracle Forms 6i, XML Publisher.

Confidential, Delray Beach, FL

Integration Consultant

Responsibilities:

• Interface Peoplesoft HRMS with E-Business Suite to transfer the Employee Information from Peoplesoft HRMS to Oracle
• Developed BPEL process to interface Beeline Invoices to Oracle EBS
• Integration of POS (point of sale) system with E-Business Suite for order process.
• Designed and developed pick release - ship confirm process orchestration which involves the Synchronous and asynchronous BPEL process relating to pick release, cartonization, ship confirmation and Roadnet integration
• Implemented Fault handling logic in BPEL to capture binding faults, remote faults, runtime faults and all custom faults in all BPEL processes developed.
• Designed and developed BPEL Error Report using BI publisher to send emails to the technical and business groups
• Used different Adapters like OA adapter, Database adapter, File adapter, AQ adapter, JMS Adapter and Queues like MQ, AQ and JMS Queues in the Interfaces developed
• Designed and developed Generic Error Handling Interface with systematic notification across Enterprise and legacy applications using Oracle SOA Suite components (BPEL, ESB)
• Prepared Technical Specification Documents using AIM Methodology
• Creation of courseware and laboratory exercises as well as reference cards and job aids.
• Use of Oracle Tutor to create Desk Manuals and Student/Instructor Guides and Creation of scenarios that facilitate integration of business processes/policies with the application

Environment: Oracle Applications 11.5.10, Oracle JDeveloper 10.1.3, SOA Suite 10.1.3, OTM, Oracle Receivables, Payables and Order Management, Oracle Tutor, Kaplan STT

Confidential, Miami, FL

Oracle Technical Consultant

Responsibilities:

• Involved in design, development and support process of integrating the Online Billing System (OBS) with Oracle Applications 11.5.10.2 instance.
• Implemented Invoice import interface process using BPEL (Apps Adapter) for loading invoice information into Oracle Payables base tables.
• Developed BPEL and ESB processes to load the active customers into Oracle API interface tables.
• Worked extensively on XSL Transformations, routing elements in developing BPEL and ESB process.
• Developed BPEL process for reading the source data from an external system using the File Adapter.
• Created BPEL processes using to import project information from legacy systems into oracle projects.
• Involved in import of customer information from the OBS instance to the 11i instance using BPEL processes.
• Developed concurrent programs to allow users to update party information in the 11i instance.
• Developed Dynamic User Interface where in the text printed on the screen is pulled from tables and the check boxes, text items are dynamically arranged per Business rules using Forms 6i.
• Used BPEL processes in Conversion of the existing sales transactions in the AR module of OBS system to AR module in the 11i instance.
• Designed and developed custom reports in Oracle Payables, Receivables, Purchasing and General Ledger Using Reports 6i, XML Publisher
• Preparation and Updating of Technical Requirements Specification Documents for all the objects developed

Environment: Oracle Applications 11i (11.5.10.2) - AP, AR, Purchasing, Oracle 9i, Reports 6i, XML Publisher, TOAD, UNIX, PVCS.

Confidential, Danbury, CT

Integration Consultant

Responsibilities:

• Designed and developed a BPEL process to interface between Mainframe and Oracle Applications using MQ adapter and Database adapter
• Developed a Custom API to get the customer record validated and imported based on the business rules of the Confidential
• A BPEL process has been designed and developed to send response on success or failure of customer creation in Accounts Receivables
• Developed a BPEL interface to E-mail and FAX Oracle applications (AR) invoices to customers
• Designed and developed a database trigger which invokes a BPEL process to send E-mail notifications when Quote status is changed from “Draft” to “Pending Customer Approval”
• Worked on the Customers Conversion and Customers Interface in Oracle receivables using API’s
• Designed and developed Customer Interface in Oracle Receivables using TCA Architecture
• Developed Auto Accounting Function for Revenue Account Extension to generate revenue side of accounting entry based on the expenditure types
• Developed various reports in financials and Project Accounting as per the business requirements

Environment: Oracle Applications 11i, Oracle JDeveloper, Oracle BPEL Process Manager, Oracle Financials and Project Accounting.

Confidential, Reston, VA

Technical Consultant

Responsibilities:

• Developed BPEL Service for AP Invoices to Interface Oracle EBS and all other systems in sync
• Designed and Developed BPEL processes to Integrate point of sale (POS) system with Oracle EBS suite for Order Process and AR Invoices.
• Developed a BPEL Process to fetch EDI Invoices in B2B and generates AP invoice in EBS
• Implemented Fault handling logic in BPEL to capture binding faults, remote faults, runtime faults and all custom faults in all BPEL processes developed
• Prepared XML Schema Diagrams (XSD) for all BPEL processes
• Developed a secure Enterprise BPEL service to retrieve banking data for suppliers
• Utilized the XSLT engine of JDeveloper to transform the XML documents
• Developed various Custom Reports using XML Publisher and Reports 6i
• Involved in the installation of OC4J containers and configuration of the connection pools and data sources for all the adapters on the application server
• Involved in managing concurrent programs, application user setup, defining responsibilities, registering forms and reports
• Prepared MD-050 and MD-070s conforming to the standards of Oracle A.I.M Methodology which cover Sequence, Class and Data Flow Diagrams.

Environment: Oracle Applications 11i (11.5.8) - JDeveloper, Inventory, AR, AP, GL, OM, Reports 6i.

Confidential, IL

Oracle Applications Consultant

Responsibilities:

• Developed data validation programs using PL/SQL package/procedures for various objects for loading transaction data from staging table into interface tables
• Developed custom Reports in GL such as Account Analysis Report, Trial Balance Report and Inter-Company Transaction Register Report to keep track of inter company revenues, assets, liabilities and expenses.
• Designed and developed PO requisition interface to import requisition data from legacy system to Oracle system.
• Worked on Order Import Interface in Order Management by importing data from legacy systems
• Developed interface program to import items from the legacy system to Oracle Inventory.
• Designed and developed a Custom Invoice Report in Oracle Account Receivables using XML Publisher
• Involved in managing concurrent programs, application user setup, defining responsibilities, registering forms and reports.
• Managed code, scripts, and loader files via PVCS
• Prepared Technical Requirement Specifications MD 70 for all the above developed objects.

Environment: Oracle Applications 11i (11.5.8) - Inventory, AR, AP, GL, OM, Reports 6i.