We provide IT Staff Augmentation Services!

Oracle Fusion Technical & Integration Service Consultant Resume

4.00/5 (Submit Your Rating)

Eden Prairie, MN

PROFESSIONAL SUMMARY:

  • 14 Years of total IT experience in Oracle EBS (R12) and 11i applications.
  • 3+ Y ears of experience with Oracle Fusion(Cloud) Applications and Oracle Integration service (ICS/OIC) .
  • Working on Oracle Integration service (ICS/OIC) with SOAP services, REST API’s and Agents.
  • Worked on Adapters like REST/SOAP/File/FTP/Database/Oracle ERP Cloud/Oracle E - Business Suite.
  • Oracle Fusion (Cloud) Financials as Techno Functional consultant involving in implementations and support as financial cloud consultant in the BI reports/OTBI reports/OTBI Analysis/ FBDI/ADF DI.
  • Worked on Data Migration (AP Invoices/Suppliers/Customers/Banks & Branches/ Purchase Orders/GL Journals/Fixed Assets data) through FBDI/ ADF DI Templates.
  • Experienced Procurement Cloud offering (Purchasing, Supplier Portal, Self Service Procurement)
  • Involved troubleshoot procurement functional issues in Production and provide quick resolution
  • Guide the users for any navigational and training issues in Oracle Procurement Cloud
  • Excellent Knowledge on defining ESS jobs for custom BI Publisher Reports in various modules.
  • Having well exposure on code migration from one instance to another instance by using ARCHIVE and UNARCHIVE the files in Oracle Fusion.
  • Experience in SmartView and FRS (financial reporting studio) Reports.
  • Knowledge on WebCenter for Image Processing through OCR/ODR
  • Worked (EBS) on BPEL process activities, Decision Service, Partner Links and Adapters (File/ FTP/ Database/ AQ/ JMS Adapters ) for developing custom business processes to integrating with different systems.
  • Good experience on Fusion Middle products APM, IDM, BPM.
  • Defining Chart of Accounts, Ledgers, Data Access Sets, Business unit.
  • Created users and assign appropriate roles to user and Custom roles creation in fusion.
  • Define Value sets and creation of data models.
  • Responsible for day to day issues related to accounting, schedule process, Transactions.
  • 10 Y ears of experience in EBS (R12), 11i applications and Oracle SQL/PLSql .
  • W ith specific exposure to Implementation, R12 Upgrade, enhancement, testing and support projects in Oracle Application (11i/R12).
  • Expertise in preparing a Technical Design documents and Unit Test Plan documents for RICE and WebADI’s.
  • Expertise in BI Publisher (XML Reports) with Barcoding and registered FONT in the application.
  • Developed BI reports for Oracle Projects with XML Data definition file and template in the .xls file .
  • Expertise i n development of interfaces (Inbound and Outbound), Conversions, Reports Development and Customization and Alerts and I have good knowledge of Oracle SQL/PL-SQL.
  • Expertise in generating outbound files in XML standard format with UTL Utilities.
  • Expertise in c reating Event Alert and Periodic Alert to send mails, submit programs and etc.
  • Good knowledge of AOL (System Administrator, Application Developer) components and creating AOL components like value sets, lookups, concurrent programs and etc.
  • Experience with Oracle Utilities: TOAD, SQL-Developer, SQL*Plus & SQL*Loader and other tracking tools like BMC Remedy, BMC, PPM, SNOW, WINSCR3, MAXIMO, RAT, RPM, PVCS and Service Now .
  • Created PO’s, Invoices, Payments and posted to GL (P2P Cycle) for testing the new reports and outbound interface data and Good knowledge on Order to Cash(O2C) Cycle.
  • Download/Upload ldt files using fndload for Reports, Alerts, Interfaces programs & AOL components.
  • Technical expertise in RICE objects for Financials & Procurement modules using Oracle’s AIM/OUM methodology.

TECHNICAL SKILLS:

ERP: Fusion Finance (Oracle Cloud) & ICS/OIC, Oracle Applications 11i, R12(EBS)

Functional Modules: Fusion Finance (AP, AR, GL) and PO, GL, AP, AR, CM, and OM

Database: Oracle 9i, Oracle 10g, 11g and 12C

Programming Languages: SQL, PL/SQL and Shell Scripting

Development Tools: Oracle Reports Builder 6i/9i and 10gOracle Forms Builder 6i/9i and 10g, OAF, Oracle Alerts, Toad, SQL*Plus, Confidential Maximo, Confidential Rational Portfolio Manager, Alfresco, PPM, BMC Remedy, Reflections X, Reflections FTP, XML Publisher Reports, ALM, Service Now and Web ADI

Operating System: Windows XP and UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Eden Prairie, MN

Oracle Fusion Technical & Integration Service Consultant

Environment: s: Oracle Fusion Finance( AP, AR and GL modules), BI Reports, OTBI Reports & ICS/OIC.

Responsibilities:

  • Created Integration service to create AP Invoice Installments through REST API
  • Created ICS service through REST API to load AR Transactions from Navisphere to Oracle in Dev instance
  • Loaded Payable Invoices through REST API from Navisphere to Oracle in Dev instance
  • Imported historic data for Payable Invoices through ICS with SOAP services.
  • Imported historic data for Journals through ICS with csv file.
  • Created Integration service to load Receivables Invoice through SOAP Services.
  • Created Integration service to Create/Update supplier with SOAP Adaptor.
  • Update Installments using Payables Invoice Management SOAP service.
  • Created Oracle Integration service to submit custom ESS Job.
  • Placed report output files in the UCM through Oracle Integration service.
  • Integration issues resolved and updated JSON code and Added parameters in the XXSUBMIT ORACLE ESS JOB integration.
  • Base64 issue resolved while uploading sample files to UCM
  • Worked on Data Migration (AP Invoices/Suppliers/Customers/AR Transactions data) through FBDI Templates.
  • Developed and customized the BI reports, OTBI reports and OTBI analysis as per business requirement.
  • Developed “XXCHR AP Payments Extract” and busted the output to the respective emails
  • Developed “XXCHR AR Cash Applied Extract” and busted the output to the respective emails
  • Created “XXCHR GL Flexi Trial Balance” ESS job for the Trial Balance BIP report in Dev instance
  • Developed the AP Invoice aging report with as of date.
  • Created users and assign appropriate roles to user and Custom roles creation in fusion.
  • Define Value sets and creation of data models.
  • Requirement gathering of this project and act as a technical and functional resource.

Confidential, Cleveland, OHIO

Oracle Fusion Financial Techno- Functional Consultant

Environment: s: Oracle Fusion Finance(PO, AP, AR, CM and GL modules), BI Reports and OTBI Reports.

Responsibilities:

  • Worked on Data Migration (AP Invoices/Suppliers/Customers/Banks & Branches/Purchase Orders/GL Journals/Fixed Assets data) through FBDI Templates.
  • Imported historic data for Payable Invoices and Journals.
  • Requirement gathering of this project and act as a technical and functional resource.
  • Developed and customized the BI reports, OTBI reports and OTBI analysis as per business requirement.
  • Developed sales order details report and created ESS job as per requirement.
  • Customize the Receivable Transaction report
  • Developed the Purchase Order Document Template.
  • Developed the Supplier list reports.
  • Developed the AP Invoice aging report with as of date.
  • Developed the Unpaid check report.
  • Created users and assign appropriate roles to user and Custom roles creation in fusion.
  • Define Value sets and creation of data models.
  • Responsible for day to day issues related to accounting, schedule process, Transactions.

Confidential

Oracle Fusion Techno- Functional Consultant

Environment: s: Oracle Fusion Finance(PO, AP, AR, CM and GL modules), BI Reports and OTBI Reports.

Responsibilities:

  • Involved setups in the Oracle Financials Cloud modules and prepared documents for the further support.
  • Developed data extracts in BI Publisher and setup FTP Connections with third party systems.
  • On call Support end to end business within Oracle Financials Cloud.
  • Followed Oracle Unified Methodology for all the documents in the implementation.
  • Customized AP Check format to cater business requirement.
  • Customized ACH File format to cater business needs.
  • Worked on FBDI template Load for Suppliers and invoice data.
  • Worked on ADF DI Spreadsheet loads for Journal, invoices, Daily rates.
  • Custom DFF and Value Sets Creation.
  • Worked on IDM and APM modules for creation of roles, user maintenance.
  • Raising SR to Oracle to get support on specific issues.
  • Configuring test and production environments using FSM.
  • Production support on Fusion Financial Applications.
  • Developed a custom form in SAAS environment using application composer.
  • PM Customer Statement Report
  • Print Receivables Transactions MD070 v1.0
  • Perform - Further AR Invoice Changes & Bug fixes
  • FBDL-Payable Invoice Import
  • FBDL-Fixed Asset Mass Additions Import
  • Silterra PO Receipt History
  • Req PO report from 11i to Fusion
  • Provide support for issues encountered by end users such as period close issues and provided clarifications of user queries.

Confidential

Oracle EBS Techno- Functional Consultant

Environment: s: EBS (R12.2.5), PO, AP, AR, CM, GL, INV, OM, Service Contract and PL/SQL, Reports XML publisher.

Responsibilities:

  • Expertise with the following RICEW objects.
  • Prepared R12 GAP analysis doc for the RICE objects in the R12 upgradation projects.
  • Discussion with the Client to understand there technical needs.
  • Creating the PPM#request to migrating the RICE components from Dev instance to QA and QA to Prod environment.
  • Checking the BMC Remedy(Incident Management) tool and manage to assign the support cases to the team members
  • Create and manage SR's with the Oracle support organization as required in order to resolve Oracle functionality or data issues.
  • Validated the code as per the naming standards which is developed by the other team members.
  • Developing the BI Publisher (XML Reports) with Barcode and register corresponding FONT in Frontend.
  • Developing New Conversions and Interfaces for upgradation of R12.
  • Development of New Reports and Customization of Existing Reports and Peer code reviews.
  • Developed in the Sales Order Lines WEB ADI.
  • Creating Event Alert and Periodic Alert to send mails, submit programs and etc.
  • Creation of Technical Specifications, Unit Test Plan Documents.
  • Created various PL/SQL procedures/packages according to the Client requirements.
  • Worked for enhancements and support cases/incidents for the RICE Objects.
  • Preparing data fix scripts for data manipulation and delete the Orfhan records.
  • Helping to the BI team to make them understand the apps data modeling and functionality.
  • KT and training on BMC Remedy, PPM Migration tools and application to the new joiners.

Confidential

Oracle EBS Techno- Functional Consultant

Environment: s: Oracle Applications R12, PO, AP, AR, GL, INV, OM and PL/SQL, BI Publisher Reports.

Responsibilities:

  • Expertise with the following RICEW objects.
  • Review / Analysis / Creation of Technical Specifications, Unit Test Plan Documents.
  • Discussion with the Client to understand there technical needs.
  • Developing New Conversions & Interfaces.
  • Developing Conversions and Interfaces for up gradation of R12.
  • Development of New Reports and Customization of Existing Reports.
  • Developing the BI Publisher (XML Reports) with Barcode and register corresponding FONT in Frontend.
  • Creating Event Alert and Periodic Alert to send mails, submit programs and etc.
  • Created various PL/SQL procedures/packages according to the Client requirements.
  • Managing and delivering the Change Requests (CR) and Incident Records (IR) within the time of SLA.
  • Create and manage SR's with the Oracle support organization as required in order to resolve Oracle functionality or data issues.
  • Trained on BPEL process activities, Decision Service, Partner Links and Adapters (File Adapter, FTP Adapter, Database Adapter, AQ Adapter, JMS Adapter) for developing custom business processes to integrating with different systems using OSB
  • Designed and developed an Payable Invoice Interfaces to the BPEL Process Manager utilizing the Oracle SOA.

Confidential

Oracle Apps Technical Consultant

Environment: Oracle Applications 11.5.10, R12 , PO, AP, AR, GL, INV, OM and PL/SQL, XML Reports.

Responsibilities:

  • Review / Analysis / Creation of Functional Specifications, Technical Specifications, Unit Test Plan Documents
  • Discussion with the Client to understand there technical needs.
  • Developing conversions for up gradation of R12.
  • Developing, supporting and enhancing Inbound/Outbound interfaces, RDF reports, PL/SQL components of almost all modules implemented in the project.

Confidential, Atlanta, Georgia‎

Oracle Apps Technical Consultant

Environment: s: Oracle Applications 11i, PO, AP, INV and PL/SQL, D2K Reports.

Responsibilities:

  • Expertise with the following RICE objects.
  • Development of Technical Specifications.
  • Interaction with Functional Specification owners on various functional issues during development.
  • Developed Conversion, Interface, Report and Alerts.
  • Design, Development and Testing of Database Packages and different Pl/SQL components.

Confidential, Miami, Florida

Oracle Developer

Environment: s: Oracle Applications 11i, PO, AP, GL and PL/SQL, D2K Reports.

Responsibilities:

  • Developed Conversions and Interfaces to upload the various details into the apps base tables from legacy system.
  • Developed outbound interface to extract the data from the Oracle tables into flat file.
  • Writing Packages, Procedures and Functions for developing conversions and Interfaces.

We'd love your feedback!