SUMMARY:

• Having 12+ years of total experience in Oracle Fusion Middleware specializing in Integration Cloud Services, SOA suite, BPEL, BPM, OSB, ISG, ODI, MFT and EMCC. Oracle Applications specializing in Financial modules and PL/SQL procedures.
• Strong Technical skills in SOA/BPEL/OSB/AIA/ISG/BPM, SQL, PL/SQL, ODI.
• Having good expertise on architecting and developing integrations between various systems using SOA suite.
• Good Experience in using Visio, GIT hub, SVN, Putty.
• Involved in development of various POC's and worked with creating and updating XSD's and generating WSDL's for web service development using SOA and OSB.
• Worked on configuration of DB Adapters, Oracle Apps Adapters, JMS Adapters, File Adapters and deployment of integrations.
• Well versed in using WebLogic console, EM console, OSB console and Jdeveloper, Eclipse.
• Having good development experience in SOAP and RESTful web services.
• Worked on documentation as in Solution design documents and Service contracts.
• 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.
• 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.
• 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 Developing 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.
• 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:

Cloud Technologies: Oracle Integration Cloud Services, AWS

Fusion Technologies: SOA/BPEL 11g/ 12c, OSB, AIA, Web logic.

Middleware Tools: Oracle Data Integrator (ODI).

Oracle Tools: TOAD, SQL Developer.

Database: Oracle 9i, 10g, 11g, 12c

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

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).

PROFESSIONAL EXPERIENCE:

Confidential, FL

SOA SME

• In depth knowledge of infrastructure for setting up SOA non-prod and prod servers at State of Ohio.
• Worked on development of POC’s for Oracle Developer Cloud Services which include Maven scripts and Hudson and Jenkins for continuous integration.
• Worked on Restful web services for IVR for Cross Country Home Services.
• Worked on Enabling OWSM policies and making web services secured
• Worked on setting up key stores in Oracle Developer cloud.
• Worked on creating Business rules to fetch ProcId’s for client SEARS.

Environment: Oracle Developer cloud, Oracle ICS cloud, SOA 12c (12.2.1.2.0 ), OSB, MFT, Weblogic, Peoplesoft.

SOA SME/Architect

• In depth knowledge of infrastructure for setting up SOA non-prod and prod servers at State of Ohio.
• Worked on development of POC’s for Oracle Integration Cloud Services which included Connectivity Agent installation, Developing and testing SOAP and RESTFul web services.
• Developed Cloud to On-Premise integrations and Cloud to Cloud Integrations.
• Worked on RESTFul web services for Supplier Portal DX integrations.
• Worked on SOAP integrations between Oracle ICS->SOA->Peoplesoft using integration broker.
• Have been part of various subject matter meetings for Oracle Managed File Transfer POC.
• Generating Trusted Keystores to establish successful secured web connection and configuring SSL in weblogic.
• Worked on Enabling OWSM policies.
• Involved in documenting the best approaches for design.

Environment: Oracle ICS cloud, SOA 12c (12.2.1.1.0 ), OSB, MFT, Weblogic, Peoplesoft.

SOA Developer

• Worked on AWS webservices, Storing files on S3 buckets.
• Worked on various SOA integrations using DB adapters and File Adapters.
• Used JIRA to track progress of development and HP ALM for defects management

Environment: AWS cloud, S3, Redshift, Aginity, SQL workbench

Senior SOA Developer

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

Responsibilities:

• Worked on design, development, and testing to integrate Issuer Management Enterprise services in 12c.
• Worked on design, development, and testing to integrate Issuer Management Salesforce Services in 12c.
• Worked on design, development, and testing to integrate Pool data management services in 12c with Ginemae using REST based web services.
• Worked on design, development, and testing Issuer Management SOAP based web services.
• Worked on Installation of 12c and development of services in 12c.
• Worked on development of services for Issuer Management.
• Worked on development of RSA token services in 11g.
• Working on Supporting and fixing services related to Mismo, Platinum, and Issuer Management projects.
• Participated in requirement meetings and working with various teams.
• Working on Enhancement, support, and fixes of Pool data management and Issuer Management integrations.

SOA Technical Architect

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 Data modeling and extraction of data from MDM, Timberline, Maximo, etc legacy systems to Oracle EBS.
• Worked on Sales Force Cloud integration POC.
• 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 on OWSM policies and OER.
• Worked on multiple PoC's to support and validate the Architecture and design
• 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.

SOA Architect/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.

SOA/OSB Architect

Environment: SOA/BPEL 11g, OSB, 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.
• Participate in design meeting, prepare the Technical Design Documents
• Collate and document the best practices, and ensure the delivery is per the standards
• Map and document the functional high level requirements to low level technical design
• To support real time order integration between Oracle Ebiz and Ecommerce system
• Integration component between Ecommerce and Oracle Ebiz using SOA and ISG to synchronize the data flow between the systems involved.
• Worked on OSB services for Order and Organization Services for Ecommerce to interact with Integrated SOA Gateway Services and SOA Services.
• Work on multiple PoC's to support and validate the Architecture and design
• A common error handling approach for SOA Interfaces
• Logging and Auditing Services - SOA and Ebiz
• Handle multiple complex integration objects/interfaces
• Involving Oracle SOA Fusion Middleware and other in-house systems (Ecommerce, Ebiz)
• Complete development - SOA Interfaces, Ebiz PL/SQL packages
• Unit and Integration testing.
• Mentor and coach the team members on Ebiz - both Technical and Functional
• Involved in peer/lead review for the Ebiz components
• Operational activities - Defect analysis, Status meetings, Issue logs, Time Management.
• Involved in designing the internal flow of EBS Ship Confirm Orders between EDI and EBS systems.

Oracle SOA/ODI/Report Senior 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 data, Etc.
• 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.

Oracle SOA Developer

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.
• Check-in code to SVN.

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.

Oracle Forms/Reports 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.

Oracle Apps Developer

Environment: Oracle E-business suite 12.1.1, (GL, AR, AP, OM, INV, FA, BI Publisher, SQL, PL/SQL, SQL* Loader, SQL Developer, XML.

Responsibilities:

• Involved in design and development of various interfaces using Oracle E-business suite.
• Involved in configuration of Flex fields.
• Involved in design, development, and testing of various BI publisher reports.
• Involved in design, development, and testing of Cash flow reports, Balance sheet reconciliation reports, Net Assets and Liabilities Reports, and State Allocation Fixed Assets reports.

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.
• Inventory Trial Balance Report
• Inventory Month- Year Report
• Inventory Reporting - Ledger Report
• Creation of Localization DFFs and Form Personalization.
• Guarantees

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.

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 Reports like:
• Developed Purchase Receipt Details.
• Developed PO Acceptance Report.
• Developed AP Invoice Report.
• Customized Payment Scheduled Report.
• 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.