Candidates About

 

Jacques Makhoul

More than 15 years of  IT experience in systems analysis, design, development, testing and project management experience. Extensively worked on ORACLE Tools and ORACLE Applications in various business areas. Proficient in application development methodologies and phases.

Expertise includes:

Ø  2 years of Oracle Fusion Cloud (Financials, Procurement, Fulfillment & Human Capital Management) experience. Worked on version 13 and 12 related to Enterprise Resource Planning, Supply Chain Management, HCM and Talent Management.

Ø  12 years of ORACLE Applications (Distribution, Manufacturing, Financials, Sales & Service) experience. Worked on EBS versions 12 and 11i related to ERP/CRM.

Ø  Managed functional, technical development, support and maintenance, related to customizations and performance of Oracle Applications suite and Salesforce.

Ø  Lead in customizing modules ASO, OM, QP, WSH, AR, and PO.

Ø  Functional/Technical lead in setup, customization, system administration, data conversion and interface programming and generating Reports and concurrent programs in Oracle applications.

Ø  Expertise in Functional analysis, establishing business rules and process flows, design Flexfield structures, segments, value sets, GAP analysis, configuration setups and validations.

Ø  Proficient in developing or modifying forms/reports using Oracle Forms/Reports and written Oracle Alerts.

 

Hardware:  Sun SPARC/Solaris, HP-UNIX, IBM PC/Compatibles

 

Software: HCM Data Loader, HCM Extracts, Web Services, REST APIs, Application Development Framework (ADF), Business Process Execution Language (BPEL), Fusion Middleware, Service-Oriented Architecture (SOA), Weblogic, JDeveloper, Salesforce, Oracle 11g/10g/9.x, Developer 10g/9i/6i/ (Forms, Reports), PL/SQL, Toad, SQL Developer, SQL*Plus, Workflow Builder, BI Publisher, SQL*Loader, Java, Oracle Application Framework (OAF), Oracle Flexera, Discoverer, Clearcase, Visual Source Safe, Kintana, TestDirector, Sharepoint, HPQC

 

Oracle Fusion Cloud: Release 13 / 12, General Ledger, Procurement, Order Management (Distributed Order Orchestration), Product Management, Supply Chain Planning, Payables Invoice to Pay, Receivables Credit to Cash, Revenue Management, Assets, Expenses, Subledger Accounting, Order Promising, Shipping, Receiving, Global Human Resources, Benefits, Absence Management, Time and Labor, Goal Management, Performance Management, Talent Review, Workforce Compensation, Taleo Recruiting, Taleo Onboarding

 

ORACLE Applications: Release 12(12.2.6/12.1.3) / 11i(11.5.10), Order Management, Quoting, Advanced Pricing, Inventory, Shipping, Receivables, Purchasing, iProcurement, Service Contracts, Installed Base, Bill of Materials, Work-in-Process, Costs, Material Requirements Planning, Advanced Supply Chain Planning, Product Information Management, Engineering, Global Order Promising, Warehouse Management System, iStore, Depot Repair, Payables, General Ledger, Cash Management, Fixed Assets

 

Programming Languages: PL/SQL, SQL*Loader, SQL*Plus, Oracle Application Framework (OAF), Oracle Application Development Framework (ADF), Business Process Execution Language (BPEL), Web Services, JDeveloper, Java, Applet, Servlet, JDBC, C/C++, C-Shell, Bourne Shell, Korn Shell, Awk, Unix Cron, ftp, HTML, XML

 

Operating Systems: Sun Solaris, HP-UX, Unix, Linux, Microsoft Windows

 

 

Work Experience:

 

Jun. 2015 –Present

Fabrinet, Santa Clara, CA

Sr. Oracle Cloud Consultant/Architect

Involve in different Cloud processes related to Order to Cash, Procure to Pay, Demand to Build and Human Capital Management along with Oracle EBS Customization, Extension and Integration in an Electronics Manufacturing environment.

 

Responsibilities involved:

·         Work on currency processes in Oracle Financials Cloud such as Conversion, Revaluation, and Translation which includes an automatic process bypassing the spreadsheet loader and loading coversion rates directly from the conversion rates feed into the open interface table.

·         Define group of accounts that require evaluation and specifying which account to use to record Unrealized Gains and Losses.

·         Automate the entire journal processes and by definining a formula within the browser and then scheduling this formula to run as needed in order to handle allocations and Recurring Jounals in Oracle General Ledger Cloud.

·         Integration with other external systems related to tax and conversion rates, payroll processing and bank statement reconciliation in Oracle Cloud.

·         Perform historical data conversion for all legal entities and business units related to procure to pay, financial control and reporting and fixed assets functions including setup of enterprise structures, reference and transaction data in order to migrate to Oracle Financials Cloud.

·         Work with business users on closing the books during period-end and resolving any issues with Oracle ERP Cloud application modules.

·         Configure invoice image routing rule using Oracle BPM Worklist Application for the BPEL task to assign Payables invoices to a user group based on    supplier by leveraging the integrated invoice imaging solution for Oracle Cloud in order to import scanned supplier invoices into Oracle Fusion Payables.

·         Configure invoice approval rules using the Oracle Business Process Management (BPM) Worklist Application by leveraging the Approval Management Extensions (AMX) of the Oracle SOA Suite and Oracle Human Workflow.

·         Perform Setups related to the asset procurement process flow which includes Requisition and Procurement, Receive and Inspect, Deploy Assets and Utilize Assets in Oracle.

·         Configure an order capture system such as Price and Quote Cloud to send source orders to Order Management Cloud that includes nonconfigured items, pick-to-order configured items, or kits.

·         Setup and configure Oracle Fusion Cloud HCM related to Core HR, Employee & Manager Self Service, Taleo Recruiting, Taleo Onboarding and Offboarding, Goal Management, Performance Management, Talent Review, Workforce Compensation, Time and Labor and Absence Management.

·         Perform complex data transformation as part of the Workforce Structure Conversion which includes Locations, Organizations, Grades, Grade Rates, Job Family and Jobs, Position, Personal, employment, Contacts, Salary, Payroll, Benefits and Beneficiaries leveraging HCM Data Loader and HCM Extracts.

·         Configure Profile management related information such as competencies, licenses and certificates.

·         work on Integrations by designing Interfaces using web services related to Locations and HR Organizations as part of the Workforce Structure including User IDs and Payroll File Numbers in order to integrate between Oracle EBS and Fusion Cloud HCM via Fusion Middleware.

·         Provide Functional Specifications and Design Specifications in support of financials, human resources, procurement, ordering, forecasting and planning processes.

·         Configure and set-up various Oracle Applications modules such as Order Management (OM), Advanced Supply Chain Planning (MSC), Inventory (INV) and Advanced Pricing (QP).

·         Work on Oracle and SFDC integration of customers, orders, invoices, product catalogs and price books in support of end-to-end CRM processes for different flows such as opportunity-to-order, order-to-cash and procure-to-pay.

·         Purchasing setups related to Employee P-Cards, Supplier P-Cards, Global Agreements and customization of workflows for routing information according to business rules.

·         Implement AME Approvals for a Position Hierarchy approval structure to use in iProcurement.

·         Work on the integration of iProcurement items associated with contract purchase agreements to reference complex pricing rules in Oracle Advanced Pricing so that the item’s price can be considered during checkout.

·         Develop Web Services and Orchestration using BPEL for Oracle EBS integration.

·         Work on different integration interface types such as PL/SQL APIs, Business Events, Open Interface tables using Application Adapter and Integrated SOA Gateway while leveraging Oracle Integration Repository.

·         Provide Price Book program by integrating with the Oracle API QP_PRICE_BOOK_PUB.CREATE_PUBLISH_PRICE_BOOK to generate a price book showing list and net prices for a specific customer and then published the output as XML and email messages.

·         Implement dynamic pricing calculations using Formula for Price Break Lines based on Unit Price Application Method.

·         Work on adding different operating units to use Internal Requisitions / Internal Sales Order  flow and set up the cascading of date through a profile option POR: Sync up Need by date on IR with OM.

·         Work on the design of different Oracle Workflow Function Activities as part of the Oracle Workflow customization related to various order to cash and procure to pay processes.

·         Work with end users on gathering business requirements and determine the best solutions that meet business needs.

·         Conduct Document Deliverable reviews and obtained the business approval.

·         Provide Test Plans and Test Cases in support of Quote-to-Cash (Q2C) and Procure-to-Pay (P2P) processes and load them into HPQC for different testing environments.

·         Coordinate Integrated Testing and User Acceptance Testing and signoff.

·         Application performance during development and modification.

 

Environment: Unix, Windows7, Linux GNU, Oracle 11g/10g/9i, Oracle Fusion Cloud 13/12, Oracle Applications 12.2.6, ASO, OM, QP, BOM, INV, EGO, WSH, AOL, TCA, AR, PO, AP, OKC, OKS, CSI, GOP/ATP, IBE, SOA, OAF, ADF, Weblogic, JDeveloper, Oracle Workflow, Forms/Reports 10g/6i, PL/SQL, Toad, SQL Developer, SQLPlus, Packages, Flexera, PVCS, Kintana, HPQC.

 

 

Jun. 2013 –May. 2015

Google, Mountain View, CA

Sr. Applications Consultant/Architect

Involved in the drumbeat planning project focusing on the coordination of all the forecasting and planning activities to ensure the output of Oracle ASCP is synchronized and accurate along with  Oracle EBS Customization and Integration related to Order to Cash.

 

Responsibilities involved:

·         Provided Business Process Architecture, Functional Specifications and Design Specifications in support of forecasting and planning processes.

·         Developed a PL/SQL API which generates a list of user defined activities mapped to Oracle concurrent programs and returns the data to a JAVA GUI so that the user can select a particular planning activity in order to perform the setups of flow activities.

·         Provided a PL/SQL API which accepts a particular setup flow from the GUI and returns the setup header and lines data related to the forecast and planning activities to allow the user to update the required setup header or line records.

·         Worked on an Oracle Concurrent program which reads different run time log data from  different Oracle Instances based on a user setup rules and constraints for certain identified activities during a particular planning cycle and then generates the planning snapshot data.

·         Created a PL/SQL API which returns planning activities related information such as overall flow status and activity detail status for a particular setup flow based on the concurrent program generated snapshot data in order for the GUI to display a subway map to the user.

 

Environment: Unix, Windows7, Linux GNU, Oracle 11g/10g/9i, Oracle Applications 12.1.3/11.5.10, ASO, OM, QP, BOM, INV, EGO, WSH, AOL, TCA, AR, PO, AP, OKC, OKS, CSI, GOP/ATP, IBE, SOA, OAF, ADF, Weblogic, JDeveloper, Oracle Workflow, Forms/Reports 10g/6i, PL/SQL, Toad, SQL Developer, SQLPlus, Packages, Flexera, PVCS, Kintana, HPQC.

 

 

Sep.  2012 –May. 2013

Cisco Systems, San Jose, CA

Sr. Oracle Applications Consultant/Architect

Involved in the Quote to Cash process design related to Oracle EBS Release 12/11i Customization and Integration.

 

Responsibilities involved:

·         Provided impact assessment on Cisco Commerce Workspace (CCW) Quoting and Ordering related to the migration of existing SJPROD Oracle database(9i) to Oracle database (11g) CG1PRD.

·         Created high level diagrams depicting the existing SJPROD and proposed CG1PRD related processes impact on the Quote-to-Order (Q2O) process flow. 

·         Developed a PL/SQL package invoked by a concurrent program to create Bill Of Materials (BOM) models, classes and options using the vanilla BOM Process API (process_bom).

·         Worked on a PL/SQL program in order to update BOM components by integrating with the BOM process API (process_bom).

·         Worked on a PL/SQL program to compare the assembly’s delivery type to the component’s delivery type using different business rules.

·         Created Oracle Form Personalization in order to alter the behavior of the vanilla BOM Define Form to meet various business rules by changing properites, executing built-ins and displaying messages.

·         Worked on the migration of custom forms (6i) in the R11i environment to forms (10g) in the R12 environment.

·         Developed a PL/SQL program to compare the setups of different BOM header and line attributes in different environments such as R11i and R12 and generated an Excel file showing the differences in the BOM setups.

·         Provided queries related to User–Defined Attributes (UDA) by accessing tables in the Oracle EGO schema corresponding to Product Information Management (PIM).

 

Environment: Unix, Windows7, Linux GNU, Oracle 11g/10g/9i, Oracle Applications 12.1.3/11.5.8, ASO, OM, QP, BOM, INV, EGO, WSH, AOL, TCA, AR, PO, AP, OKC, OKS, CSI, WMS, GOP/ATP, IBE, SOA, OAF, ADF, Weblogic, JDeveloper, Oracle Workflow, Forms/Reports 10g/6i, PL/SQL, Toad, SQL Developer, SQLPlus, SQLLoader, Views, Packages, Triggers, PVCS, Kintana, Cisco Docs, HPQC.

 

 

Jan.  2011 –Aug. 2012

Oracle Consulting / NetApp, Sunnyvale, CA

Sr. Applications Consultant/Architect

Involved in the NetApp’s Everest project focusing on end–to-end Quote to Invoice (Q2I) process design related to Quoting Portal UX and Oracle EBS Release 12 Customization and Integration of pricing, discounting and promotion along with Salesforce CRM integration.

 

Responsibilities involved:

·         Designed the Quote-to-Cash (Q2C) processes by providing Business Process Architecture Document Deliverables (BP080).

·         Provided Functional Specifications (MD050) and Design Specifications (MD070) in support of different Quote-to-Cash (Q2C) processes.

·         Application Setup Document Deliverable (BR100) related to Order Capture (ASO), Order Management (OM) and Advanced Pricing (QP).

·         Created a Qualifier/Pricing Attributes extension PL/SQL API package in order for the automatic eligible discount to be applied based on certain partner, customer/end user and quote attributes.

·         Developed a custom Tier2 pricing call extension to determine the Tier2 eligible discounts when the Apply Reseller Discounts button in the custom quoting tool pushed by the end user.

·         Calculated Tier2 Reseller Total Discounts, Suggested Discount and Additional Discount and updated a quoting custom table.

·         Created an Unlocking Fixed Discounts extension in order to enable authorized users to unlock all fixed discounts on a quote.

·         Created an API to lock all fixed discounts on a quote after every pricing call if the quote had any lines with a discount applied that had the discount Descriptive Flexfield (DFF) where the fixed discount was set to 'Yes' and the line quantity was less than or equal to the volume threshold number.  

·         Developed a Custom Ignore Pricing extension used to skip pricing calls for items that had zero price such as model options based on PIM (Product Information Management) attributes by using the seeded package qp_custom_ignore.

·         worked on a Promotion Lookup Extension to search for a requested Promotion Code entered on the Manual Promotions/Special Pricing Rules Entry form and if found check if it was active and whether it was flagged as Competitor Information Required.

·         Developed an Applied Promotions Extension to retrieve and summarize all automatically and manually applied promotions on a given quote for display on the Applied Promotions region of the Manual Promotion/Special Pricing Rules Entry form.

·         Created the logic for an Add/Delete Promotion Extension to add a Promotion Code to all eligible quote lines and initiated repricing of the quote.

·         Involved in the quote creation process where the system would integrate with SFDC, Advanced Pricing, TCA, and Sales Contract Metadata using Oracle SOA for only buying entity on the Quote and would apply it to the Quote according to Defaulting Rules. 

·         Worked on the Modify Quote process that can take updates to existing Quote and process it and send response back to the calling program. Modify Quote program can be called from different sources such as Quoting Portal, Configurator and  Pricing processes for updating an existing single Quote.

·         Created a PL/SQL program to update a profile option for a particular user in order to unlock pricing fixed discounts.

·         Provided Test Plans and Test Cases (TE020 / TE030) in support of Quote-to-Cash (Q2C) processes and load them into HPQC for different testing environments.

·         Supplied Document Deliverables such as Data Conversion (CV040 / CV070) for various conversion elements.

 

Environment: Unix, Windows 7, Oracle 10/11G, Oracle Applications 12.1.3, ASO, OM, QP, AR, BOM, WIP, INV, PO, AP, WSH, OKC, OKS, CSI, WMS, GOP/ATP, IBE, AOL, TCA, SFDC, Siebel, SOA, ADF, OAF, JDeveloper, Weblogic, Oracle Workflow, Forms/Reports 10g/6i, PL/SQL, Toad, SQL Developer, SQLPlus, SQLLoader, Views, Packages, Triggers, PVCS, Kintana, Sharepoint, HPQC.

 

 

Jan. 2010 –Dec. 2010

JDS Uniphase, Milpitas, CA

Sr. Oracle Applications Consultant/Lead

Involved in the Oracle Applications Global Rollout ‘’Passport” Project related to Quote-to-Cash and Procure-to-Pay.

 

Responsibilities involved:

·         Designed the Order-to-Cash (O2C) processes related to different regions such as Asia Pacific (APAC), Europe, the Middle East and Africa (EMEA) and Latin America (LATAM) by providing Business Process Architecture Document Deliverables (BP070 / BP080).

·         Standard Finished Goods Sales Process deals with available / manufactured items within

JDS Uniphase (JDSU).

·         Sale of Parts to Vendor Process required for sales of parts to JDSU vendors.

·         Initial Scheduling Process provides a schedule ship date to the customer for an existing order.

·         Rescheduling Process allows a change to the initial schedule date in the order based on customer’s request.

·         Credit Card, Cash in Advance and Letter of Credit Order Processes help fulfill a customer’s request for payment method such as Credit Card, Cash in Advance and Letter of Credit.

·         Internal Purchase Order(IPR) / Internal Sales Order (ISO) Process followed in order to procure goods between Oracle sites.

·         Vendor Drop Ship Process permits the fulfillment of a customer’s demand by shipping items from External Vendor.

·         Intercompany Order Process allows the fulfillment of a Sales Order by shipping the items from another JDSU site outside the selling operating unit.

·         Business to Business (B2B) for Contract Manufacturers Process followed to fulfill a customer’s demand by sending the order information to a contract manufacturer.

·         Credit Check Process used during the fulfillment of customer’s order to ascertain the credit worthiness of the customer.

·         Trade In Process permits the acceptance of a JDSU item / Competitor item from the customer and then to ship a JDSU item to the customer.

·         RMA to Credit Process allows the customer to return a product to JDSU.

·         Upgrade Process used when customers request an upgrade on an existing JDSU product owned by them.

·         Provided Functional specifications (MD050) and Design Specifications (MD070) in support of all the different Order-to-Cash (O2C) processes.

·         Application Setup Document Deliverable (BR100) related to Order Management(OM), Service Contracts (OKS), Installed Base (CSI), and Purchasing (PO).

·         Integration of Oracle Applications with existing manufacturing local systems by building B2B interfaces in order to support data transmission automatically to eliminate manual and duplicate data.

·         Created and registered Concurrent Programs and Request Sets to handle B2B integration based on appropriate B2B partner code.

 

Environment: Unix, Windows 7, Oracle 8i/9i/10G, Oracle Applications 11i (11.5.9/11.5.10), Oracle Applications(12.1.1/12.1.2), ASO, OM, QP, AR, BOM, WIP, INV, PO, AP, WSH, OKC, OKS, CSI, WMS, GOP/ATP, IBE, AOL, SOA, OAF, ADF, Weblogic, JDeveloper, Oracle Workflow, Forms/Reports 6i, PL/SQL, Toad, SQLPlus, SQLLoader, Views, Packages, Triggers, PVCS, Kintana, Sharepoint, HPQC.

 

 

Feb. 2007 –Oct. 2009

Cisco Systems, San Jose, CA

Sr. Oracle Applications Consultant/Lead

Involved in the Oracle Applications Customization and Integration of pricing, discounting and promotion.

 

Responsibilities involved:

·         Designed the Cisco Pricing and Discounting Engine to provide accurate and consistent pricing and discounting across different tools by integrating with the Oracle Advanced Pricing module (QP).

·         Pricing and Discounting Engine integrates with Oracle Service Contracts and Oracle Installed Base in order to obtain service related information.

·         Provided functional specifications related to the pricing and discounting system and obtained the business approval.

·         Translated the business requirements into a technical design and coordinated with the cross-functional teams to get their signoff.

·         Created the logic of the Pricing and Discounting Engine, using PL/SQL Packages, which used pricing and discounting rules by using different methodologies in order to return the required pricing and discounting information to the calling application such as Quoting, iStore and Order Management.

·         Designed the Quantity-Based Pricing Service by using the Point /Range Price Break type in QP.

·         Created Formula and attached to the Price Break Header level in QP to dynamically calculate the list price.

·         Created Product and Pricing Attributes including Attribute Linking and Mapping to be used by QP to apply to price list lines.

·         Developed the logic of the Get_Custom_Price function to calculate the price based on the price break factor, country uplift factor and quantity.  

·         Developed an Oracle trigger to update the price formula id from the backend by using the QP API Process_Price_List.

 

Environment: Unix, Windows, Oracle 8i/9i, Oracle Applications 11i (11.5.9/11.5.10), Oracle Applications(12.0/12.1), ASO, OM, QP, AR, BOM, WIP, INV, OKC, OKS, CSI, WMS, GOP/ATP, IBE, AOL, TCA, OAF, JDeveloper, Oracle Workflow, Forms/Reports 6i, PL/SQL, Toad, SQLPlus, SQLLoader, Views, Packages, Triggers, PVCS, Kintana, Livelink, TestDirector.

 

 

Jan. 2006 –Dec. 2006

Hitachi Data Systems, Santa Clara, CA

Sr. Oracle Applications Consultant

Involved in the Oracle Applications Customization and Integration of the export compliance process.

 

Responsibilities involved:

·         Designed a new process for integrating EASE, Export Automation Software Essentials, with Oracle Applications to automatically apply/release holds on customer sales orders in OM when a customer denied in EASE.

·         Translated the business requirements into a technical design and coordinated with the cross-functional teams to get their signoff.

·         Set up Systems, Agents, Events and Event Subscriptions using Oracle Advanced Queuing.

·         Developed an Oracle trigger for publishing a hold event from EASE and created an Oracle Workflow for subscribing to the published hold event.

·         Provided PL/SQL packages that placed holds on sales orders for selected customers and sent notifications to the end users using Oracle Workflow.

·         Developed an Oracle form that allowed the users to classify part numbers based upon import/export government rules.

·         Registered the form and report concurrent program in the Oracle Applications Object Library.

 

Environment: Unix, Windows, Oracle 8i/9i, Oracle Applications 11i (11.5.9), OM, AR,