SUMMARY:

• Confidential has over 20 years’ experience as an Oracle E - Business Suite (EBS) consultant with implementations in Manufacturing, Asset Attributes, Cost Management, Procure - To - Pay, Supply Chain Planning, Order - To - Cash, Service and Finance. On a majority of his projects, Confidential has been the sole consulting resource with project management, functional and technical responsibilities.
• Developed and managed project plans, tasks and resources.
• Documented and communicated project status via status reports, weekly meetings and presentations.
• Created instructor presentations and student workbooks; conducted and evaluated training sessions.
• Created requirements questionnaires; conducted and evaluated interview sessions
• Analyzed questionnaire responses and mapped into EBS requirements
• Evaluated EBS requirements and configured EBS applications
• Created business policies, processes, procedures in support of EBS solutions.
• Created pilot workshop scripts; conducted and evaluated workshop sessions; based on workshop results, refined EBS configurations and / or business policies, processes and procedures.
• Identified, analyzed and documented gap functional and technical specifications.
• Created desktop and online user guides (Snagit / UPK).
• Created CRP / SIT / UAT scripts; conducted and evaluated test sessions; based on test results, refined conversions, GAP extensions and user guides.
• Identified, investigated, documented and resolved user, process, EBS and data issues.
• Opened, tracked and responded to Oracle Support’s Service Requests recommendations with logs, trace files, patches and regression testing.
• Identified, analyzed and documented conversion fields; created functional and technical specifications
• Developed programs incorporating EBS APIs, triggers, views, PL/SQL packages, SQL*Plus, Discoverer, JDeveloper, Forms, OA Framework, Reports, Workflow Builder, Alerts, XML Publisher, CUSTOM.pll, TEMPLATE.fmb, SQL*Loader, DataLoader, System Administrator, Application Object LibraryOracle EBS Applications (10.7, 10SC, 10NCA, 11.0, 11.5, 12.0, 12.1, 12.2):

SKILLS:

Manufacturing

Engineering (ENG)

Bills of Material (BOM)

Work In Process (WIP)

Quality (QA)

E-Records (EDR)

Project Manufacturing (PJM)

OPM Product Development (GMD)

OPM Process Execution (GME)

OPM Financials (GMF)

Mobile Supply Chain Applications

Procure To Pay (P2P)

Approvals Management (AME) iSupplier Portal (POS) iProcurement (ICX)

Purchasing (PO)

Inventory (INV)

Cost Management

Cost Management (CST)

Subledger Accounting (XLA)

Order To Cash (O2C)

Product Information Management (PIM)

Advanced Pricing (QP)

Order Management (ONT)

Shipping Execution (WSH)

E-Business Tax (ZX)

Service

Install Base (CSI)

Service Contracts (OKS)

Service (CS)

Depot Repair (CSD)

Asset Attributes

Enterprise Asset Attributes (EAM)

Supply Chain Planning

Master Scheduling / MRP (MRP)

ASCP (MSC)

Financials

Payables (AP) / Payments (IBY)

Assets (FA)

Receivables (AR)

General Ledger (GL)

PROFESSIONAL EXPERIENCE:

Confidential

Functional / Technical Lead Consultant

Responsibilities:

• Investigated and resolved user, process, application and data issues.
• Opened, tracked and responded to Oracle Support’s Service Requests recommendations with logs, trace files, patches and regression testing
• Extended functionality for functions, menus, responsibilities, request groups, flexfields, and personalization. configure, maintain, repair, cost and capitalize plant and transmission assets (stations, lines and vehicles). Map asset data fields into user defined asset groups. Import manufacturer parts list into asset BOM structure process work requests for asset maintenance.
• Assign approved requests to EAM work order. Systematically create work order with abnormal reading in EAM completion’s collection plan.
• Manage maintenance processes with work orders for materials, operations, resources, quality results replenish plant, warehouse and transmission stations with sourcing rules, min-max, move orders, internal requisitions / sales orders, purchase requisitions. Receive and issue stock from purchase orders and work orders / discrete jobs. Audit inventory with ABC codes and cycle counts process project’s department and expenditure costs from collection of work order, purchase order, inventory and project transactions. Enabled evaluation of budget versus actual calculate project’s supply with hard / soft pegging, common / project group reservations, service part planning. calculate item costs from purchase order (material, material overhead, PPV and IPV variances). Map subinventory, alias, accounting class, resource and overhead distribution accounts.
• Create Accounting for Accounting events. track EAM Asset Definition / Maintenance work order costs with material, employee labor@actual rate, employee overheads, expense direct items, other expenses, AP tax, freight and IPV track COOP transmission assembly with rollup of BOMs (items) and routings (departments, resources and overheads). Track standard discrete job element costs with material, material overhead, labor resources, OSP, overheads. Track WIP value and variances via Discrete Job Value Report track COOP transmission assembly costs for engineering units with assembly item and accounting classes as they transition from development to end-delivery. Process includes items, standard cost updates, OSP negotiations, minimum buy requirements, initial tool up costs, scrap allocation. Track WIP value via Discrete Job Value Report
• Cost Management / Project Manufacturing - calculate project’s cost (cost group) with discrete job assembly completion and purchased component costs. calculate forecasted outage demand with planning bills and minimum / maximum quantities, fixed lot size, purchasing / stocking UOM conversions; route planned orders to suppliers and warehouses with sourcing rules and approved supplier lists; release planned orders within release time fence. process procurement approvals with requestor’s job approval group and group’s authorization limits; auto-create purchase orders (requisitions), auto-release (blanket agreements); auto-transmit supplier email / fax. Systematically create subcontractor purchase orders with release of subcontractor discrete jobs. Enable complex fixed price complex purchase orders for retainage.
• AME - enabled supplier invoice approval with job’s approval authority and authority’s rules
• Order Management - process build-to-order and pick-to-order orders for cooperative customers. Calculate product availability for customer’s requested quantity and date with ATP rules. Qualify customer / products for discounts / special pricing with pricing attributes
• Service - process service requests for cooperative customers requesting assistance, sales, returns, repair, replacement and advanced replacement of parts. Import repair orders from customer service requests. Import discrete jobs from approved repair orders. Calculate repair costs by contract billable hours, repair routing standard hours or employee timecard actual hours
• Financials (AP, AR, GL, FA) - process supplier and customer invoices, supplier payments and customer receipts, asset depreciations, subledger postings to General Ledger, GL batches and journals, period closings. developed views and associated Discoverer business areas, folders and reports for maintenance, supply chain, and accounting applications.
• OBIEE - OBIEE repository database (RPD) for physical, business model / mapping and presentation layers, migrating Discoverer reports to OBIEE analysis and reports.

Confidential

Functional Lead Consultant

Responsibilities:

• Calibration and maintenance via EAM work requests / work orders of Confidential / customer owned assets, equipment and tools used in manufacturing of Confidential products.
• Calibration, maintenance and tracking via EAM work requests / work orders of assets, equipment and tools used in their facilities.
• Tracking via WIP work orders material issues of equipment and tools used in manufacturing of Confidential products.
• Executed and verified application pre and post upgrade steps.
• Evaluated EBS requirements and configured EBS applications for 12.2.6.
• Created test scripts for 12.2.6 functionality.
• Investigated and resolved user, process, application and data issues.

Confidential

Functional / Technical Lead Consultant

Responsibilities:

• Maintenance (EAM, Property Manager, BOM, WIP ), Purchasing (iProcurement), Inventory, Quality, Cost, Projects, Project Manufacturing, Time and Labor, OM, Service, Financials (AP, Payments, AR, FA, GL.
• Executed and verified application pre and post upgrade steps.
• Migrated, executed and verified custom reports, interfaces and extensions.

Confidential

Functional / Technical Lead Consultant

Responsibilities:

• Implemented plant asset preventive maintenance; facilities help desk service requests; prototyped EAM’s linear asset and EBS mobile applications.
• Reviewed audit findings for contract invoice / billable cost and impact on EBS.
• Reviewed AS-IS with Project, Sales Order, Planned Order, Purchase Order, Inventory, Work Order, Component / Assembly Cost, Shipment and Invoice
• Evaluated TO-BE with planned order project pegging and supply reservations.
• To fulfill audit requirements, recommended options for hard / soft project pegging and project / common group supply reservations.

Confidential

Functional / Technical Lead Consultant

Responsibilities:

• Executed and verified application pre and post upgrade steps.
• Migrated, executed and verified custom reports, interfaces and extensions.

Confidential

Functional Lead Consultant

Responsibilities:

• Implemented product configurations / versions with recipes, formulas (products, ingredients) and routings (operations, activities & resources); production scenarios with validity rules (production output).
• Implemented lot quality control with parent / child attributes, concentrations (technical parameters), test targets (in / out-of-specification), test samples (plan, frequency, count, size), test result required actions (material status control).
• Implemented production processes with batch processing for recipes.
• Implemented customer and FDA regulations enforcement (CFR Title 21 Part 11) with business events and subscriptions (EDR).
• Implemented product costing with items, recipes and overheads; generation of transaction distributions from Accounting Pre-Processor / Create Accounting Events from SLA application accounting definitions.
• Implemented supply chain planning with minimum shelf-life, variable ingredients, validity rules, sourcing rules and approved supplier lists.