Functional Consultant Oracle Ebs
Resume:
ED MATNI
San Jose,CA
******@*****.***
Executive Summary:
Over 18+ years of Oracle EBS techno/functional expertise
Primarily responsible for the development, customizations and production support of the Oracle Financials EBS suite
Completed three Oracle EBS R12 full life cycle implementations
Ability to generate end-to-end complete solutions from business requirements
gathering, detailed functional/technical specifications and technical delivery of
proposed solution.
Excellent analytical and problem solving abilities. Able to exhibit judgment and realistic understanding of issues by prioritizing work and use time more efficiently.
PROGRAMMING / SKILLS
Oracle Tools: SQL, SQL*Plus, SQL*Forms 6i/10g, PL/SQL, AOL, Pro*C, SQL*Net, Sybase SQL, Oracle Application Server, PL/SQL Web Toolkit, Developer 2000, Oracle Workflow, Reports 6i/10g, XML/BI Publisher, XML Bursting
Platforms: UNIX, Linux, IBM, HP
PROFESSIONAL EXPERIENCE
Rimini Street
April 2023-Present
Technical/Functional Consultant
●Responsible for remote application support and advisory services for Oracle customers with an emphasis on Oracle Financials suite modules.
Helen of Troy
September 2023-March 2024
Technical/Functional Consultant
●Created an AR invoice extract that would create an Excel file format and email user
●Modified existing custom form to create a CSV file extract of dataset
●Created custom form personalization to modify the values on the Projects workbench for different statuses
Los Alamos National Laboratory
October 2021-July 2023
Technical/Functional Consultant
●Retrofit custom objects as part of the 12.1.3 upgrade to 12.2.11
●Worked on providing production support for Oracle financials EBS as well as various customizations and enhancement requests
●Created integration between SAP/Ariba to Oracle EBS. Unapproved invoices entered into Ariba would be pulled into Oracle PA to recognize cost
Accenture Federal/Department of Commerce
August 2021-January 2022
Technical/Functional Consultant
●Created interface to load purchase orders from external system into Oracle EBS 12.2.10
●Modified Project Accounting approval workflow to route up to four different levels of approvals
●Created extracts of invoices and suppliers/sites for loading into PRISM
●Modified PO Charge Account Generator based on business requirements
●Created new program to load XML data file and create miscellaneous receipts in Oracle AR using receipts API
GMR (Global Medical Response)
April 2020-June 2021
Technical/Functional Consultant
●Worked on custom integration between Oracle EBS to Basware. Created XML extracts for outbound suppliers, sites, chart of accounts and processed inbound AP invoices XML to EBS
●Created integration between Workday and Oracle EBS to create employees, jobs, assignments, etc.
●Worked on other various reports and interfaces for customization list and production related support
●Created custom ADI integrator for Fixed Assets to update several DFF fields, assignments and units
Expedia
January 2020-December 2020
Technical/Functional Consultant
●Created custom customer facing document (invoice) for cruise ship center. Enabled bursting for email delivery
●Created custom integrator to allow for direct debit banking information upload
●Created new custom AR format program for pre-note authorization sent to customer before debiting their account.
●Create a custom invoice print program with annex details for Egencia customers
●Created custom program to load JSON data into custom staging tables that would then create AR invoices using AutoInvoice for India GST
●Provided production based support on an add needed basis
Department of Energy
June 2020-June 2021
Technical/Functional Consultant
●Retrofit custom objects as part of the 12.1.3 upgrade to 12.2.8
Electronic Arts
September 2020-October 2020
Technical/Functional Consultant
●Retrofit fifteen workflow objects as part of 12.1.3 to 12.2.9 upgrade project
Aerojet
October 2019-January 2021
Technical/Functional Consultant
●Worked on several PA custom reports for an acquisition. Modified reports to add machine hours and cost of money, rather than direct labor.
●Created new custom PA billing extension program to calculate machine hours overhead and cost of money. Cost would be allocated using machine hours as opposed to standard direct labor in accordance to cost accounting standards
City of Las Vegas
March 2019-January 2020
Technical/Functional Consultant
●Developed inbound interfaces to create invoices, purchase requisitions (updates and cancellations) and purchase order updates from Masterworks (city planning department)
●Developed outbound interfaces for suppliers and GL expense related data
Sunrun
September 2018-September 2019
Technical/Functional Consultant
●Implemented NACHA/ACH payment with new bank vendor (Silicon Valley Bank). Created new AP check stub and payment.
●Created new payment process profiles, templates, payment documents, banks and bank accounts
●Implemented Positive Pay with new bank vendor
●Tuned several reports for performance related issues
●Created custom AR ADI template to upload invoice transactions and credit memos
DOI (Department of Interior)/IBC
March 2018-September 2018
Technical/Functional Consultant
●Responsible for Oracle EBS financials upgrade/remediation project from 12.1.3 to 12.2.7. Worked with team for analysis and resolution based on OPCC (Oracle patching compliance) results
Rimini Street
November 2017-February 2018
Technical/Functional Consultant
●Responsible for application support and advisory services for Oracle customers with an emphasis on the Oracle EBS Financials.
●Month end related support issues for payments, period close issues, create accounting, etc.
Department of Defense/Accenture Federal
May 2017-November 2017
Technical/Functional Consultant
●Provide primary Oracle support to Accenture Federal DoD client for standard Oracle (DEAMS application) and client’s customizations across all EBS modules (Finance, P2P, etc.)
City Of Las Vegas
October 2016-February 2017
●Created custom program to load AR adjustments from Excel file
●Created custom AR invoice print report to migrate off of JetForms
NREL
June 2016-Sep 2016
Technical/ Functional Consultant
●Reimplementation project from R12.1.3 to R12.2 for Oracle Financials
DOI (Department of Interior)/IBC
January 2016-June 2016
Technical/ Functional Consultant
●Worked on Oracle CLM module for PDF printing related issues
Envision
October 2015-January 2016
Technical/ Functional Consultant
●Created customer interface from an Envision acquisition company using open interface and standard Oracle Customer Import
●Worked on PA (Projects) interface as well as additional enhancements
DOI (Department of Interior)/IBC
February 2015-October 2015
Technical/ Functional Consultant
●Created XML outbound interfaces for supplier creation and updates on Oracle Federal Financials.
●Create XML outbound interface for invoice status
●Loaded US Bank file into Oracle for create card processing in AP
●Created program to load inbound XML file for invoice import
●Used BPA (Bill Presentment) to create printed AR invoice
●Created custom program to take payroll file and create employees in Oracle HR 12.1.3
Opera
August 2014-February 2015
Technical/ Functional Consultant
●Responsible for new chart of accounts conversion (COA) project. Setup new Ledger, OUs for AP, AR, GL, FA, CE and all the necessary configurations.
●Migrated open AP, FA, and AR transactions from old COA to new COA.
●Migrated open GL balances from old COA to new COA
●Developed scripts to create new supplier sites and customer sites in newly created OUs for AP and AR.
Equinix
February 2014-July 2014
Technical/ Functional Consultant
●Created GL balances program to convert YTD balances from 11i to new R12 re-implementation.
●Created GL interface program to transfer Receivables and RevRec GL journal details lines from 11i to new.
●Developed reconciliation report to tie 11i GL and R12 GL
●Modified Oracle requisitions workflow (IProcurement) to derive custom approval routing
●Modified Oracle FA account generator
●Conversion of banks, branches and suppliers banks from 11i to R12
●Created extract from Oracle GL to Hyperion reporting
●Created other various one time scripts for conversion (create new application users, load expense account rules, load GL elim sets, etc.)
Rimini Street
September 2013-February 2014
Technical/Functional Consultant
●Provide primary Oracle (11i/R12) support to Rimini Street clients for standard Oracle and client’s customizations across all EBS modules (Finance, Manufacturing, etc.)
Hitachi Data Systems (HDS)
January 2013-August 2013
Technical/Functional Consultant
●Developed custom program to automatically approve requisitions that are in existing workflow
●Developed custom program to automate requisition to approved purchase order
●Developed custom alert to notify requestors when goods are received.
●Created custom program to automate AP invoices uploaded from flat file from suppliers
●Various bug fixes to existing EBtax reports
NREL (National Renewable Energy Lab)
May-2012-January 2013
Technical/Functional Consultant
●Lead developer on the 11i to R12 (12.1.3) migration upgrade for complete Oracle financials (AP, GL, FA, SLA, PO, PA costing and billing)
●Created AR/PA invoice print (with multiple templates) that combined both AR related information as well as Projects related information for customer presentation. Created several new project/task setups for testing purposes and user data.
●Generate WRICEP list and analysis of custom components for 11i to R12 migration
●Created new AP check payment template using BI publisher for R12
●Utilized forms personalization to create zoom form from Asset Workbench screen
MICROS May 2012-
November 2012
●Developed a custom GL consolidation process to map an old 11.03 chart of accounts structure to an 12.1.3 chart of accounts. Built several custom forms to maintain the mappings between the different segments of each respective COA.
●Create custom package to derive the mappings and create the respective GL journals in the interface
Solution Beacon/Accelrys June 2012-
October 2012
●Worked on 11.5.10 to 12.1.3 new implementation project. Responsible conversions for FA, AP, CE, PO, SLA and suppliers from 11i to R12
●Created two new AP check printing templates
●Create new AR invoice print template using Oracle BPA
WebEx/Cisco August 2005-
May-2012
Technical/Functional Consultant
●Migrate existing customizations during upgrade from 11.0.3 to 11.5.10
●Implement Oracle R12 Advance Collections
●Using Oracle BPA (Bill Presentment Architecture) to create print AR invoice template
●Working with Oracle AIM methodology to gather requirements and create BR100, MD070, MD050.
●Generate WRICEP list and analysis of custom components for upgrade from 11i to R12 migration
●Worked with users to gather business requirements for custom enhancements
●Enhancement and support of custom revenue recognition engine
●Implemented R12 lockbox functionality
●Develop custom credit-memo monthly write off process
●Developed custom process and reconciliation report to load data files from Paymentech (Chase)
●Using receipt API to upload bank checks to automatically create receipts
●Team lead for the procure to pay side
●Automated R12 credit card refund and chargeback process
●Positive Pay with Cash Management bank reconciliation
●Developed and automated custom AR to GL accruals for month end
●Migrate custom objects from existing 11i instance to new R12 instance
●Test and modify customizations for new COA (Chart of Accounts) conversion project
●Implement Positive Pay customization between WebEx and Comerica bank for A/P
●Developed custom program to sync items between Master org and 8 other inventory organizations within WebEx
●Implemented Oracle’s GL journal approval with customizations
●Implemented Oracle’s invoice approval workflow with customizations using AME
●Provide ad-hoc reports in Excel for SOX compliance and auditors
●Work with auditors (internal/external) SOX (404) team to make sure all processes are compliant
●Design and implementation of IProcurement all US based WebEx employees
●Provide general day to day production support for PO, AR, AP, FA, GL, IExpenses as well as month end / quarter end support
Symantec April 2005 –
July 2005
Technical/Functional Consultant
Worked on integration merger with Veritas. Primarily responsible for fixed assets conversion, bank and vendor conversions.
BLUECOAT June 2004 –
April 2005
Technical/Functional Consultant
●Sole developer for migrating all customizations in 11.0.3 (reports, forms, interfaces, etc.) to 11.5.9
●Created new Order line workflows for BlueCoat order types
●Modifyed standard Oracle workflow for FA Account Generator and OM COGS Generator.
●Lead developer for outsourcing manufacturing/shipping (i.e. drop shipments).
●Implemented Export Compliance for standard Oracle order workflow.
●Continually working with users to gather requirements for new enhancements and customizations.
●Worked on implementation of Oracle EPB.
●Provide general day to day production support for OM, AR, PO, AP, FA, GL, INV, WSH
SYMANTEC April 2001 – June 2004
Technical/Functional Consultant
●Responsible for upgrading current Oracle financials applications 10.7 system to Oracle 11i. Evaluated current 10.7 customizations to determine whether or not any new 11i features could replace existing business functionality. Solely responsible for technical implementation of many finance related customizations within AP, PO, FA and GL.
●Worked on several modifications made to standard Oracle workflow within Oracle 11i applications. Implemented new workflow definition types to meet the users business needs. Worked extensively on customizations and enhancements to Oracle Self Service Expenses (SSE) and Oracle Self Service Requisitions (iProcurement SSP5)
●Provide guidance and recommendations to users as to how to enhance customizations, current and new business processes. Gather requirements from users and prepare documentation to clarify and explain custom business processes.
●Implemented Oracle catalog functionality withing the Iprocurement module. Designed and developed an interface to send electronic purchase orders to CDW (supplier).
Involved in the upgrade project of 11.5.3 to 11.5.6
Involved in the upgrade project of 11.5.6 to 11.5.9
CEPHREN December 1999 – December 2000
Project Lead/Senior Software Engineer
●Worked on several key components of our production based system, ProjectNet, for the AEC industry.
●Responsible for the design and implementation of several new features and enhancement to our web based framework of e-commerce and collaboration services.
●Primarily developing using Oracle PL/SQL and Oracle PL/SQL web toolkit to generate dynamic web pages and forms.
●Worked as a lead for four other developers responsible for developing and maintaining our PrintNet service, which offers a comprehensive set of secure online services for the reprographics and print shop marketplace.
●Responsible for scheduling, prioritization, and proper allocation of resources in order to meet all critical deadlines.
●Responsible for all I18N of our PrintNet product.
●Defined an XML schema to generate a Print Work Order for our PrintNet system.
SYMANTEC November 1997 – October 1999
Senior Systems Analysts
●Responsible for Oracle 10.7 multi-organization upgrade of AP, GL, and FA including all customizations.
●Developed an external vendor web site that allowed any Symantec vendor (via authentication) to view their respective invoicing and payment history. Responsible for all configuration and setup of the Oracle Application Server.
●Developed an application using Developer 2000 and Oracle Web Server to track the life cycle of a software product. Generated reports using the Web PL/SQL toolkit.
●Created program for AP that allows users to automate the process of creating invoices with the capability of matching to Purchase Orders and prorating tax and freight.
●Worked as lead with users for all customizations (reports, shell scripts, SQL scripts, etc.) of AP, GL, and FA. Responsible for implementing all customizations in those respective modules.
SUN MICROSYSTEMS April 1996 – November 1997
Software Engineer
●Working on gathering requirements for AP to upgrade to Oracle version 10.7 character mode.
●Created EDI810 (inbound invoices) custom program to handle invoices received from SunService vendors. Responsible for the analysis and design of the EDI requirements for AP implementation. Gathered all requirements from user community. Responsible for the development, implementation and testing of all interfaces between EDI, Oracle AP, and Sun’s Information Highway application.
●Developed program for Sun’s Tax Department for tax auditing purposes. Created a routine that would run out of each Oracle AP instance as part of Sun’s month end close procedures.
●Created a HR extract program for Oracle AP. Program will load employees as vendors into Oracle Payables. This is necessary for Sun to pay expense requests, so employees are actually setup as vendors.
●Created a custom program to transfer created journals in our “skeleton” GL to Sun’s own production GL system. This was necessary since Sun has several different Oracle AP instances, each with its own skeleton GL, but only one corporate wide GL instance.
●Created a custom program to output all checks issued for a given bank branch, bank account and period. Created a flat file of checks for a given period that was used to send to the bank for reconciliation purposes. The flat file is then sent as an email attachment to the users and that file is sent to the bank. The bank would then call and list any exceptions via the banks own reporting system.
●Responsible for various support issued related questions as well as AP business requirements. Also, handled month end close support for the AP user community.
●Responsible for new development / enhancements for the Athena application. A tool used for quoting and creating new schedules for SunService business.
●Worked with support of the Sun Education group. Supported and worked on requests for the SunEds application. Implemented a new tool to allow users to fax or email confirmation / cancellation letters to students.
●Used Business Objects to create a reporting universe to query off of Athena database (SYBASE)
●Created several different SQL reports for different groups within SunService.
Work Authorization: US Citizen
EDUCATION
Bachelor of Science in Computer Science, San Jose State University
Masters of Science in Engineering Management, Santa Clara University
Contact this candidate