SUMMARY

• Having 10 years of total experience in Oracle Fusion Middleware specializing in SOA suite, BPEL, OSB, ODI, and AIA and Oracle Applications specializing in Financial modules (AP, GL, FA, AR) and also PO,OM,INV Modules and PL/SQL procedures.
• Having extensive 4+ years of experience working with Fusion middleware technologies in developing interfaces using SOA/BPEL, OSB and AIA standards.
• Strong Technical skills in Oracle Reports 6i/9i/10g, Forms 6i/9i/10g, SQL, PL/SQL, SQL*LOADER, BI Publisher, ODI, and SOA/BPEL/OSB/AIA. Knowledge of OBIEE and OAF.
• Involved in the development, customization of forms & reports (Forms 6i & Reports 6i), Conversions and interfaces.
• Good Knowledge on AOL and functional knowledge on financial modules. Also involved in creating and updating patches; Preparation of MD070’s and development of RICE components.
• Expertise in RICE (Reports, Interfaces, Conversions, Enhancements) Components.
• Good understanding of sub ledger architecture (SLA) and Accounting Sequencing.
• Experience in Creation of the Interfaces to external systems. Creation of Conversion programs to transfer data from a legacy system to the new system.
• Expertise in Enhancements (or extensions) to the existing system to add additional functionality to
• Existing System without disturbing the core software functionality of the system.
• Good working experience in Forms 4.5/6i, Reports 6i, PL/SQL, Oracle Database and RDBMS
• Concepts. Experienced in Reports Customization using XML Publisher.
• Extensively worked on Data Conversion, Migrations and Interface Programs (Outbound/Inbound).
• Worked with System Administrator and AOL modules for creating Concurrent Executable, Concurrent
• Programs and Setting Profile Options as per the requirements.
• Experience in Developed Technical Design Documents (MD120, MD70 and CV40) based on
• Functional Design Document (MD50, BR100) using Application Implementation Methodology (AIM).
• Experience in all phases of Software Development Life Cycle (SDLC) including Analysis, Specification, Development, Maintenance, Testing and Documentation.
• Have good exposure in Functional Modules like Account Payables, Account Receivables, Fixed Assets, General Ledger, Purchasing Order and Order Management.
• Good exposure to Procure to Pay (P2P) and Order to Cash (O2C) cycles functionally as well as technically.
• Experience in designing, developing Inbound Interface, Outbound Interface in Oracle Applications.
• Worked on the legacy information system to Release 11i which includes AP, PO, OM modules using PL/SQL, SQL* Plus and SQL* Loader.
• Involved in the development of interfaces/ Conversions to import the data from Legacy system into oracle application base tables.
• Experience in Creation of BI Publisher Reports that are not available as standard reports in the oracle apps modules.
• Worked on UTL PACKAGE and SQL*LOADER for the interfaces and conversions.
• Good understanding of Application Object Library (AOL) and Application Implementation Methodology (AIM).
• Excellent communication, organizational and interpersonal skills with an ability to perform
• Individually or as a team and as well as leading the teams and handling the clients.

TECHNICAL SKILLS

ERP Modules: Oracle Applications 11i, E - Business Suite R12, Application Object Library (AOL), General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Purchasing (PO), Order Management (OM), Inventory (INV),Fixed Assets (FA).

Fusion Technologies: SOA/BPEL, OSB, AIA, Web logic.

Middleware Tools: Oracle Data Integrator (ODI).

Oracle Tools: Developer 6i/9i/10g, Discoverer 9i, XML/BI Publisher, OBIEE, SQL*Loader, TOAD, SQL Developer, isqlplus, SQL*Plus.

Database: Oracle 9i, 10g, 11g.

Operating Systems: Windows NT/2000/2003 Server, Windows XP.

PROFESSIONAL EXPERIENCE

Confidential, Belmont, CA

Technical Architect/Senior SOA Developer

Environment: SOA/BPEL 11g, Web logic, OSB, Integrated SOA Gateway, JMS, Oracle EBS 12.2.4, SQL, PL/SQL, SQL Developer, XML.

Responsibilities:

• Worked on design patterns using Visio and POC's to support integration between systems like MDM, Maximo, and Oracle EBS.
• Worked on design, development, and testing Supplier Services to integrate between MDM and Oracle EBS System.
• Worked on design, development, and testing Chart of Account Services.
• Worked on Integrated SOA Gateway PoC's to integrate between MDM and Oracle EBS system; Maximo and Oracle EBS system.
• Worked onmultiple PoC's to support and validate the Architecture and design a)
• A common error handling approach forSOA Interfaces b) Logging and Auditing Services - SOA and EBS c) Involved in preparing mapping sheets for transformations
• Worked on Purchase Requisition integration between Maximo and Oracle EBS system.
• Worked on Purchase Orders integration between Oracle EBS System and Maximo.
• Worked on configuration of JMS Queues to support the design and architecture for the integrations between MDM and Oracle EBS system.

Confidential, Brooklyn, NY

Senior SOA Developer

Environment: SOA/BPEL 11g, Web logic, JMS, SQL, PL/SQL, SQL Developer, XML.

Responsibilities:

• Worked on design, development, and testing Fleet Inquiry Services to integrate between iPayments and Oracle System.
• Worked on design, development, and testing Water Inquiry Services.
• Worked on Installation of EM Cloud Control 12c on server.
• Working on Supporting ECB Billing and Payment integrations with fixes.
• Working on Support tickets of ECB and providing fixes.
• Working on design, development, and testing of Heart Beat Services.

Confidential, Miami, FL

Senior Lead Oracle SOA/Technical Developer

Environment: SOA/BPEL 11g, OSB, B2B, Rosetta, Web logic, JMS, Oracle E-business suite 12.1.3, (GL, AR, AP, OM, INV, PO, BI Publisher, SQL, PL/SQL, SQL Developer, XML.

Responsibilities:

• Worked on Order services and Organization services for Tracfone OFS team.
• Worked on OSB services for Order and Organization Services for Ecommerce to interact with Integrated SOA Gateway Services and SOA Services.
• Involved in designing the internal flow of EBS Ship Confirm Orders between EDI and EBS systems.
• Worked with GIT control hub to check-in code units.

Confidential, Pittsburgh, PA

Oracle SOA/ODI/Report Lead Developer

Responsibilities:

• Involved in development of various integrations using SOA from Discuss system to Oracle CC&B and MDM.
• Integrations like LIHEAP, Residential billing, Customer, Bad debts, Cap delinquencies, late payment charges dataEtc.
• Used adapters like File Adapter and FTP Adapter, Fault handling (catchall) and Transformations.
• Involved in audit team to validate the data migrations from Discuss system to Oracle CC&B and MDM.
• Also involved in design and development of various BI Publisher reports for Utility industry.

Confidential, Grand Rapids, MI

Oracle SOA Lead

Environment: SOA/BPEL, OSB, Web logic, AIA 2.0, ODI, JMS, Oracle E-business suite 12.1.3, (GL, AR, AP, OM, INV, PO, BI Publisher, SQL, PL/SQL, SQL* Loader, SQL Developer, XML, SVN.

Responsibilities:

• Developed Customer Interface between JDE and Oracle E-business suite.
• Developed Product Unit interface between Red prairie system and Oracle E-business suite.
• Developed Product Status interface between Red Prairie system and Oracle E-business suite.
• Developed Product Update interface between Red Prairie system and Oracle E-business suite.
• Developed Item interface between JDE and Oracle E-business suite which also involves a PLSQL call.
• Developed Enterprise Business service for Warranty Contracts.
• Developed Statistical Payments BI publisher report for AP payments.
• Involved in development of integrations for Procure to Pay cycle.
• Involved in supporting Supply Chain interfaces like Customer order lines to Red Prairie
• Shipment Confirmation, Create Purchase Order auto receipt
• Purchase Order Inbound interface, Purchase Order outbound interface, On-hand Balance interfaces.

Confidential, Chicago, Illinois

Oracle SOA Lead

Environment: SOA/BPEL, OSB, Web logic, AIA 2.0, ODI, JMS, Oracle E-business suite 12.1.3, (GL, AR, AP, OM, INV, PO, BI Publisher, SQL, PL/SQL, SQL* Loader, SQL Developer, XML

Responsibilities:

• Involved in design and development of various interfaces using SOA, BPEL and AIA standard.
• Involved in BPEL process Orchestration for integration of ERP, Databases, legacy systems and Flat Files.
• Involved in developing and deploying BPEL Processes using technology adapters (Oracle Applications, DB
• Adapter, File Adapter and FTP Adapter), Fault handling (catchall) and Transformations.

Confidential, Chicago, Illinois

Oracle SOA Developer

Environment: SOA/BPEL, OSB, Web logic, AIA 2.0, ODI, Oracle E-business suite 12.1.3, (GL, AR, AP, OM, INV, PO, BI Publisher, SQL, PL/SQL,SQL* Loader, SQL Developer, XML, SVN.

Responsibilities:

• Involved in design and development of various interfaces using SOA, BPEL and AIA standard.
• Involved in BPEL process Orchestration for integration of ERP, Databases, legacy systems and Flat Files.
• Involved in developing and deploying BPEL Processes using technology adapters (Oracle Applications, DB
• Adapter, File Adapter and FTP Adapter), Fault handling (catchall) and Transformations.
• Check-in code to SVN.

Confidential

ODI Senior Middleware consultant

Environment: Oracle Applications 11.5.10 and R12(AR, OM, GL, AP, AOL, and PO, Oracle Data Integrator(ODI), SOA, AIA, Web logic, SVN.

Responsibilities:

• Developed ODI interfaces to migrate web logic code to Oracle Applications system from Super system to AP Invoices.
• Developed ODI interfaces to migrate web logic code to Oracle Applications system from Vision 21 system to AP refunds.
• Migrated Bank information to Oracle AP using ODI interfaces.
• Migrated V21/FIDO system to Oracle AP refunds using ODI Interfaces.
• Developed EDI matched invoices interface where EDI is the source system which is migrated to Oracle AP invoices.
• Developed VST/SANINCO to AP inbound interface.
• Developed Employee interface to migrate web logic code to Oracle Applications system from PeopleSoft to Oracle Financials.
• Check-in code to SVN.

Confidential

Oracle Apps Developer

Environment: Oracle Applications 12.0.6 (GL, AR, AP, OM, INV, PO, Procurement), Oracle 10g, UNIX, XML Publisher, SQL, PL/SQL, Forms and Reports 10g, OAF, SQL* Loader, SQL Developer, SVN.

Responsibilities:

• Assigned as Oracle Applications Technical consultant to design, develop, implement and customize Oracle Applications 12.0.6 and R12 (GL, AP, AR, PO) by understanding customer requirements; Implemented Order to Cash and Procure to Pay Life Cycles.
• Involved in Implementation and Customization of various Financials Modules (GL, AP, AR, PO and INV). Successfully Interacted with Functional Consultants, QA team, DBA team and development teams. Developed Technical MD70 specification.
• Customized the menus, added new concurrent requests, registered the custom applications, value sets etc. using System Administrator Module.
• Developed Concurrent Programs to interface Customer data from Legacy Systems to AR.
• Customized AP Check report in accordance to clients check printing stationary. Customized Report for Cash/Bank Book Report.
• Implemented the complete life cycles of Order-to-Cash and Procure-to-Pay.
• Developed Various Reports in GL, AP and AR Modules and customized them using XML Publisher.
• Involved in writing the Conversion Documents of GL and AP for data conversions from the Legacy.
• Worked on item conversion in INV.
• Developed and Customized Forms, Reports, PL/SQL Procedures, Triggers and Functions.
• Wrote complex SQL queries, Control files, Procedures, Triggers and Packages.
• Coordinated knowledge transfer to technical team and guided them on prevailing technical issues and general Oracle Applications issues.
• Defined value sets, concurrent programs, request sets, registering reports and PL/SQL Procedures and Packages.
• 11i and R12 ER on AP Purchasing Ledger Report and AR Sales VAT Register.
• Resolved issue with AP Payables Translation Package Loss-Cash pairing.
• Resolved issue with AP foreign Currency Payments.
• Resolved issues with AP Invoices that have more than one line with offset tax on it are not properly translated.
• Credit Memo transaction in foreign currency that have Exchange Loss are not properly translated.
• ER on Account Analysis Report to show the concatenated segments in the report.
• Handled many other SR’s as per the client Requirements.

Confidential

Oracle Apps Developer

Environment: Oracle Applications 11.5.10 (GL, AR, AP, OM, INV, PO, Procurement), Oracle 9i, UNIX, XML Publisher, SQL, PL/SQL, Developer 6i, SQL* Loader, SQL Developer.

Responsibilities:

• Assigned as Oracle Applications Technical consultant to design, develop, implement and customize Oracle Applications 11 (GL, AP, AR, PO) by understanding customer requirements.
• Developed GL Inbound Interface to import the Journals data from Legacy to Oracle applications GL base tables using the standard program ‘Journal Import’.
• Developed AP Inbound Interface to load data from legacy system to Oracle Base tables.
• Developed Supplier Balances Report.
• Developed Consignment Delivery Note Report using XML Publisher.
• Customized Pick Slip Report.
• Developed Packaging and Weight List Report using XML Publisher.
• Developed Inventory Issue Order Report.
• Customized PO Requisition form and PO form as per client requirement.

Confidential

Technical Developer

Environment: Oracle Applications 11.5.10, Oracle 9i, PL/SQL, Forms 6i, Reports 6i.

Responsibilities:

• Worked in Oracle technologies SQL, PL/SQL, Forms 6i, Reports 6i both development and support.
• Developed PO Conversion to import the Purchase Orders data from Legacy to Oracle applications PO Base Tables.
• Developed Outbound Interface to upload the payment data to Legacy system by using the UTL FILE Package.
• Developed material on-hand Quantity transaction details outbound Interface to extract the data from Inventory base tables to legacy flat files.
• Personalized AR Transaction form as per client requirement.
• Development of interfaces for Procure to Pay cycle.
• Preparing the MD070 and MD0120 Documents after completion of the component.
• Developing Reports, Customization of forms & Reports and Developing of Interfaces.
• Created the executables, Concurrent Programs, Defining Parameters and Value sets.
• Created Control Files for SQL Loader to load data from Text Files.
• Followed the coding and development standards to debug the code rapidly.