We provide IT Staff Augmentation Services!

Resume

Oracle Cpq Cloud Big Machines Developer Consultant San Diego, CA

SUMMARY:

Confidential is an ERP/CRM consultant and has over 20 years of consulting experience in the distribution, manufacturing industries including 5 years of software development, and 18 years with Oracle applications.

EXPERTISE:

  • Applications Implementation
  • Applications Development
  • Pre - sales Consulting
  • Business Process Reengineering
  • Project Lead

TECHNICAL SKILLS:

  • Oracle Purchasing
  • Oracle Order Management
  • Oracle Inventory
  • Oracle Bills of Material
  • Oracle WIP
  • Oracle Support
  • Supply Chain
  • Oracle CRM
  • Oracle Quoting
  • Configurator Developer
  • Java Developer
  • Configure To Order (CTO/ATO/PTO)
  • Oracle Configurator
  • Oracle Advance Pricing
  • Oracle iStore
  • Internet Procurement (iProcurement)
  • Oracle Service Contract
  • Oracle Workflow
  • Advance Planing & Scheduling
  • Oracle DRP/MPS/MRP
  • SQL Developer
  • Workflow Developer
  • Oracle Applications Implementation (AIM) Methodology, R2I, OTCx
  • Oracle Workflow, Oracle Report, SQL*Plus, COBOL, PASCAL, PROMODEL, PROCESSMODEL, POWERWAY 9000, @RISK

HE SPECIALIZES IN THESE AREAS:

CRM & Cloud Computing: Oracle CPQ Cloud (Big Machines), iStore, Configurator, Quote - to-Order, Oracle Service, Service Contract

ERP: Order Management, Configure-To-Order, Advance Pricing, iProcurement, Purchasing, Inventory, BOM, WIP, ENG, Costing, Supply Chain Planning, PLM/PIM, Install Base, CMRO, etc, As a business consultant, Confidential involved in architecting Quote-to-Order, Configure-to-Order solutions utilizing Oracle eBusiness Suites for various industries.

PROFESSIONAL EXPERIENCE:

Oracle CPQ Cloud (Big Machines) Developer & Consultant

Confidential, San Diego, CA

Responsibilities:

  • Gathered business requirements from multiple client sources e.g. Sales and Marketing teams, product managers and IT teams
  • Translated business requirements into CPQ development projects
  • Rebuilt CPQ Configuration Models for multiple product lines included BML codes for various rules
  • Rebuilt CPQ Commerce (web-pages) with multiple of product specific actions and approval rules
  • Built CPQ Configuration Models and CPQ Commerce to accommodate EMEA requirements i.e. multi-currencies, multi-language of user interfaces and Pricing scenarios
  • Performed Configurations, Commerce, Data migration from Development db to Test db
  • Integrated CPQ Commerce with Salesforce and SAP
  • Performed UAT for each product family before go live
  • Brought to live two CPQ product families to Production system
  • Supported roll-out by business units

Oracle CPQ Cloud (Big Machines) Developer & Consultant

Confidential, Austin, TX

Responsibilities:

  • Designed and implemented of Oracle CPQ cloud and its integration with legacy ERP system
  • Configured/setup CPQ Configuration, Commerce, Document Engine and its integration with Pricing, Inventory, Item Master modules
  • Built CPQ Configuration Models for multiple product lines included BML codes for various rules
  • Built CPQ Commerce (web-pages) for multiple type of quotes for each product line included BML codes for various rules

Oracle CPQ Cloud (Big Machines) & EBS Consultant

Confidential, Silicon Valley, CA

Responsibilities:

  • Realigned CPQ SAP Item Master to be compatible with Oracle EBS Item Master
  • Modified/Adjusted CPQ Configure Models (Attributes, Rules) to meet EBS Configurable BOM’s
  • Modified/Adjusted CPQ Commerce (Attributes, Actions, Functions, Approvals, Rules) to meet EBS Integrated SOA Gateway requirements
  • Created, Updated, Compile BML Library Functions for generating Web Services
  • Generated EBS-OM Web Service or SOAP Endpoint and WSDL
  • Modified/Adjusted CPQ Commerce (Attributes, Actions, Functions, Approvals, Rules) to meet EBS Order Fulfillment requirements for Order Creation, Order Update and Cancel Order
  • Data Table map between CPQ SAP Sales Order tables to Oracle Order Management tables
  • Data Table map between CPQ Pricing tables to Oracle Pricing tables
  • Constructed and generated SOAP Web Services to establish integration between CPQ and EBS OM

Oracle CPQ Cloud (Big Machines) Developer & Consultant

Confidential, Pittsburgh, PA

Responsibilities:

  • Designed and implemented of Oracle CPQ cloud and its integration with legacy ERP system
  • Configured/setup CPQ Configuration, Commerce, Document Engine and its integration with Pricing, Inventory, Item Master modules
  • Converted Product Specs and Price books to become Oracle CPQ Configuration rules and database
  • Built CPQ Configuration Models for multiple product lines included BML codes for various rules
  • Built CPQ Commerce (web-pages) for multiple type of quotes for each product line included BML codes for various rules
  • Customized components for Quote (Commerce) Integration (with Salesforce)
  • Set up a CPQ Cloud site object so that Salesforce will know how to connect with CPQ Cloud and placed the CPQ Cloud quote object on the Salesforce Opportunity page layout
  • Setup CPQ Integration Center to integrate with DocuSign
  • Modified HTML Homepage and CSS
  • Built Interface between Oracle CPQ Cloud with Oracle Advance Pricing, Oracle Order Management, Oracle BOM
  • Established new sales order fulfillment process
  • Established new pricing Configure-to-Order (CTO) process
  • Unit tested of the developed product lines
  • Ensured the quality of the configured delivered through leading/managing Quality Assurance (QA)

Oracle EBS Consultant

Confidential, Houston, TX

Responsibilities:

  • Solution Architect for Configure-Price-Quote (CPQ), Quote-to-Order, Order-to-Cash, Configure-to-Order
  • Convert legacy BOM’s into Oracle Configure-to-Order BOM’s
  • Established new sales order fulfillment process
  • Established new pricing CTO process
  • Built new configurable production models (four family/line of products) utilizing Oracle Fusion Configurator, Advance Pricing, and Quoting
  • Implementing Smart Part/Product Numbering of the Configurator Extension to generate strings of selected ordered features of the configurable motors and drives
  • Implementing Smart Product Description via Configurator Extension (Java programs) to generate strings of selected customer ordered features (motors and drives)
  • Implementing Configurator Pricing Attributes with Oracle Advance Pricing Attributes to price configurable motors and drives
  • Configured Oracle Order Management, Advance Pricing, Quoting, iStore, Fusion Configurator, BOM modules
  • Designed and implemented Oracle Form Personalization to display new Descriptive Flexfields and to default OM fields
  • Trained client Oracle Fusion Configurator Developer to build new configurable product model which includes developing new user interface web pages (OA Framework), product logic rules (CDL/Java like language) and debug errors
  • Performed models migrations from CRP instance to SIT instance to UAT instance and finally to PROD instance
  • Utilized HPQC to manage data QC, log defect
  • Utilized Agile/SCRUM Project Development Methodology
  • Utilized OUM Implementation Methodology
  • Conduct/leading Conference Room Pilot sessions, System Integration Testing sessions, User Acceptance Test

Oracle EBS Consultant

Confidential, San Bernardino, CA

Responsibilities:

  • Solution Architect for Configure-Price-Quote (CPQ), Quote-to-Order, Order-to-Cash Configure-to-Order
  • Convert legacy BOM’s into Oracle Configure-to-Order BOM’s
  • Established new sales order fulfillment process
  • Established new pricing CTO process
  • Built new configurable production models (four family/line of products) utilizing Oracle Configurator, Advance Pricing, and Oracle Negotiation/Quoting
  • Implementing Smart Part/Product Numbering of the Configurator Extension to generate strings of selected ordered features of the configurable pumps
  • Implementing Smart Product Description via Configurator Extension to generate strings of selected customer ordered features
  • Implementing Configurator Pricing Attributes with Oracle Advance Pricing Attributes to price configurable pumps
  • Configuring Oracle Order Management, Advance Pricing, Quoting, Configurator, BOM modules
  • Designed, mapped and implemented interface between Microsoft Dynamic (CRM) to Oracle order processing
  • Designed and implemented Oracle Form Personalization to display new Descriptive Flexfields e.g. pricing attributes, configurator user defined attributes
  • Trained client Oracle Configurator Developer to build new configurable product model which includes developing new user interface web pages (OA Framework), product logic rules (CDL/Java like language) and debug errors
  • Utilized Waterfall Project Development Methodology
  • Utilized OUM Implementation Methodology
  • Data mapping between legacy system - Progress database to Oracle EBS schema
  • Conduct/leading Conference Room Pilot sessions, System Integration Testing sessions

Oracle EBS Consultant

Confidential, Philadelphia, PA

Responsibilities:

  • Convert legacy BOM’s into Oracle Configure-to-Order BOM’s
  • Established new sales order fulfillment process
  • Established new pricing CTO process
  • Built new configurable production models (four family/line of products)
  • Convert legacy configurable products into Oracle EBS configurable models
  • Utilized Oracle PIM/PLM to manage new items and ICC
  • Utilized Oracle WIP to complete CTO work order generated
  • Utilized OUM Implementation Methodology

Oracle EBS Consultant

Confidential, Iowa

Responsibilities:

  • Restructured and re-implemented the crane product family including:
  • De-nested very large BOM’s into small sales BOM’s and production BOM’s based on orderable products
  • Readjust the Costing structure to support the new BOM’s
  • Readjust the Pricing structure to support the new configurable models
  • Rewrote configurator rules to support the de-nested BOM structures
  • Redesigned the sales model user interfaces (CZ UI) to fit the new refined product offerings
  • Created new UI Content Control templates and new UI Master templates
  • Re-adjusted CX to accommodate the pricing for the de-nested models
  • Utilized Oracle PIM/PLM to manage new items and ICC
  • Utilized Oracle WIP to complete CTO work orders generated
  • Built/wrote 20 complete configurator models
  • Implemented Order-to-Cash process for these new Configure-to-Order products
  • Brought three configurable crane product families to live.

Oracle EBS Consultant

Confidential, Research Triangle Park, North Carolina

Responsibilities:

  • Mapped out solutions for Confidential Configurable POS system
  • Designed new Oracle Configurable structures out of Confidential legacy configurator
  • Conducted Proof of Concepts to validate the proposed configurator models & rule structure
  • Worked with the Sales team to design and prototype several Web UI layouts, navigation methods, product content controls, displayed images and various text descriptions (notes, warning, error messages)
  • Conducted Conference Room Pilot
  • Setup and prototyped Intercompany Transactions
  • Designed and Published configurable product models to iStore, HTML Quoting for commercial transactions
  • Oracle R12 Modules: Configurator Developer, iStore, Order Management, Inventory, Bills of Material, Quoting, Advance Pricing, PIM (Product Information Management), Purchasing, Oracle Service, Order-to-Cash, Quote-to-Order.

Oracle EBS Lead Consultant

Confidential, Colorado Spring, Colorado

Responsibilities:

  • Restructured very large BOMs, Configurator models and Rules to significantly reduce the configuration times (eliminate sales order back logs)
  • Conducted several Proof of Concepts to validate the proposed configurator model & rule restructuring
  • Built an automated pre-Configured-to-Order solution - including auto pre-configured new BOM’s, re-price new pre-config item, re-assigned pre-config item categories, re-cost pre-config item and re-adjust on-hand inventory. This process should be completed within a few hours to accommodate configurable EDI orders. This process was built to fix pre-config BOM’s and to overcome the pre-config item in open sales order or purchase order or work order or flow schedule
  • Built solution foot-prints for four types of Request-For-Quotation (RFQ) - Hard RFQ, Internal Soft RFQ, Part RFQ and NPD RFQ. Custom Matching SQL package and Custom Output Attribute CX were required to achieve these solution foot-prints.

Oracle Consultant

Confidential, Quantico, VA

Responsibilities:

  • Tier-2 Support to fix various stages of Service Request orders/entries that got stuck in the database
  • Configured OM, Inventory, Purchase, Install Base modules for Logistic and Order Fulfillment transactions
  • Configured O.Service and Service Contract modules for warranty assets and serviceable assets
  • Generated Service Requests (SR), Assigned SR’s, Assigned Tasks, Performed Work and Debriefed Tasks, and closing SR
  • Built Knowledge Base from the resolved Service Requests
  • Generated Warranty Contracts, entered pricing information, routed for approval and created Preventive Maintenance Schedule for some categories of assets

Oracle EBS Lead Consultant

Confidential

Responsibilities:

  • Restructured very large BOMs and Configure-to-Order (CTO) workflows to meet customer demand for a few seconds of configuring and order entry time.
  • Customized Configurator Extensions CX’s and rules to support output attributes for pricing, manufacturing and shipping
  • Built new Configurator models with CDL rules
  • Utilized PIM to define, categorize and catalog all finished products and raw materials base on the User Defined Attributes created and assigned to these inventory items
  • Utilized PIM searching functionality to define and standardize product search/look up
  • Designed and implemented Configurator Attribute Pricing for complex configurable cabinets
  • Configured Advance Pricing Modules, part of Order Management module and Configurator
  • Built Pricing extensions for price lists, modifiers, qualifiers, attribute mappings, etc.
  • Setup, built and prototyped Intercompany Transactions
  • Prototyped solution to price complex configurable products (attribute pricings) for
  • Regular manual entry Sales Order transactions (real time or batch mode)
  • EDI orders transactions
  • Inter-company invoice pricing for multi-currencies transactions
  • Supported and led CTO CRPs for configurable cabinets
  • Trained users and developers with various Configurator and Advance pricing setups and documentations
  • Worked with the Marketing team to design and prototype several Web UI layouts, navigation methods, product content controls, displayed images and various text descriptions (notes, warning, error messages)
  • Designed new CZ UI Master and Content Control templates to accommodate corporate logo and images, background color, navigation style, product image layouts and displayed.

Oracle EBS ERP/CRM Lead Consultant

Confidential, Ann Arbor, Michigan

Responsibilities:

  • Prepared and performed data cleaning (repair BOM’s, Item/PIM attributes) for Second Phase Go Live
  • Supported customize OM migration
  • Wrote new Configurator Extensions - CX’s (in java)
  • Modified existing CX’s to accommodate new rules for different products
  • Wrote new programs (SQL scripts) to support data migrations
  • Utilized PIM to define, categorize and catalog all finished products and raw materials base on the User Defined Attributes created and assigned to these inventory items
  • Designed pricing build up by selected product features
  • Utilized Oracle PIM to design a data hub to support various items, products, BOMs in various databases
  • Utilized PIM to manage parts and products imports from non-Oracle database
  • Utilized PIM searching functionality to define and standardize product search/look up
  • Utilized PLM to control and manage life cycle of all sellable products
  • Utilized Oracle WIP to complete CTO work orders generated
  • Brought the 2nd phase configurable product families into Live (Production system) including the Quoting, Configuring, Order Management, Pricing, and iStore
  • Supported data preparations and validation for the 3rd phase of the largest configurable product families to go live.

Oracle ERP/CRM Lead Consultant

Confidential, Hartford, Connecticut

Responsibilities:

  • Architected solution for porting legacy web-store to Oracle iStore
  • Architected solution for web ordering of gun components and accessories by leveraging Configurator Guided selling features
  • Architected solution for web configuring firearms by integrating Oracle Configurator and iStore
  • Developed project plan, monitored progress and communicated to the steering committee
  • Setup/configured iStore, Configurator, BOM (include PTO/ATO), OM, Advance Pricing, Inventory and CRM
  • Built web-stores & eCommerce
  • Configured iStore for maintaining B2B customers and handling B2B transactions
  • Configured iStore for maintaining B2C customers and handling B2C transactions
  • Prototyped Click-to-Order, Configure-to-Order and Order-to-Cash solution footprints
  • Setup several Order Management transaction types/scenarios for fulfilling iStore orders
  • Implemented Available to Promise from several order fulfillment centers and ATP for different type of customers
  • Utilized PL/SQL for data loading, CZ, QP tables adjustments, dblink constructions, CZ servers adjustments, products/item loadings
  • Worked with the Marketing team to design and prototype several Web UI layouts, navigation methods, displayed images and product text descriptions for configurable products in CZ UI and non-configurable products in iStore
  • Designed new CZ UI Master and Control templates to accommodate corporate logo and images, background color, navigation style, product image layouts and displayed
  • Customized iStore Notifications, emails and Order-to-Cash workflows
  • Integrated with iPayment for handling credit card transactions

Oracle ERP/CRM Lead Consultant

Confidential

Responsibilities:

  • Architected the Order to Cash, Procure to Pay, and Inventory to Fulfillment processes
  • Established the CRM/ERP Application Foundation integration points with other applications
  • Assisted client product managers to use the appropriate kind of Configurators for various family products.
  • Assisted client PMO to decide and prioritize of which family products to go live.
  • Provided roadmap, roll-out plans and contingency plans for various configurable products to go live.
  • Architected solutions for complex configurable products to fit iStore-to-Order and Order-to-Cash.
  • Designed and built complex configurator panel models, writing advance Configurator rules and Web-User Interface
  • Utilized various CX’s (Java programs) to send output attributes for product pricings, capacity planning, purchasing documents and work instructions.
  • Utilized spn CX’s to generate string of parameters for XML interface to export and import data/attributes/properties from third-party configurators.
  • Utilized XML for interfacing with non-Oracle system
  • Designed and lead the implementation of the database CZ architectures from phase to phase including building db links, Items and BOMs loading and and published data synchronizations.
  • Provide step-by-step implementation flows for the application foundation modules
  • Modified components of Oracle Workflow to generate new BOM (configured bill), item number, Purchase Requisitions, Final Assembly Work Order and/or Final Assembly Flow Schedules
  • Utilized ASCP to manage material planning from four manufacturing plants and suppliers
  • Implemented Rough Cut Capacity Planning to calculate manufacturing and shipping capacities
  • Logged TARs/SRs to Oracle Metalink for bugs fix supports
  • Successfully knowledge transfer to client teams to carry on that project.

Oracle ERP/CRM Lead Consultant

Confidential, Orlando, FL

Responsibilities:

  • Reviewed product lines and mapped them to the appropriate level of configurator models needed to meet the business configure-to-order process requirements including user business buy-in, inventory control, pricing and costing.
  • Facilitated change management for branches to adopt new system/processes
  • Architected the Order to Cash, Procure to Pay, and Inventory to Fulfillment processes
  • Established the CRM/ERP Application Foundation integration points with other applications
  • Setup profile options, parameters, and configuration for each SCM module (INV, OM, WIP, COST, PUR, DRP, MRP)
  • Restructured the bills of material of the configurable products to accommodate Quoting, pricing, customer support, Order Management
  • Converted/Translating business/product rules to Configurator rules
  • Built complex configurator models, instantiable models and writing Configurator rules and Web-User Interface
  • Utilized CX (Java Programs/Classes) to send output attributes for downstream applications such as EDI, Pricing formula calculations
  • Worked with the Marketing team to design and prototype several Web UI layouts, navigation methods, displayed images and product text descriptions in CZ UI
  • Published configurator models and UI to Production database
  • Architected the Quote-to-Order and Order-to-Cash for the Garage Door configurable products
  • Outlined steps and guided client to bring the system live including the preparation of the on-hand inventory, open sales order, open quotes, etc.
  • Brought the most complex configurable product families into Live (Production system) including the Quoting, Configuring, Order Management, Pricing, Procurement, Costing, Receiving, Warehousing and Shipping.
  • Implemented and utilized ASCP to manage material planning from various manufacturing plants, suppliers and divisions nation wide
  • Customized workflow components of Oracle Workflow (Workflow Builder and PL/SQL) to meet order fulfillment requirements
  • Logged TARs/SRs to Oracle Metalink for bugs fix supports
  • Oracle Modules: Configurator Developer, Order Management, Inventory, Bills of Material, Quoting, ASCP, Purchasing, Advance Pricing, Order-to-Cash, Quot-to-Order, WIP, WMS, Supply Chain.

Oracle ERP/CRM Consultant

Confidential, Raleigh-Durham, NC

Responsibilities:

  • Restructured the bills of material of the configurable products to accommodate Quoting, pricing, customer support, Install Base
  • Built Configurator models, instantiable models and writing Configurator rules
  • Converted business/product rules to Configurator rules
  • Designed Configurator User Interface to replace Excel form
  • Published configurator models and UI to Production database
  • Supported Live/Production configuration process during Quoting and Sales Order Management.
  • Configurator Developer, Order Management, Inventory, Bills of Material, Quoting, Install Base, Purchasing, WIP, Order-to-Cash.

Oracle ERP/CRM Consultant

Confidential, St.Louis, MO

Responsibilities:

  • Architected, design and implement the Advance Pricing and Costing to integrate with the Configure-to-Order processes
  • Optimized the building of the Configurator models and writing Configurator rules
  • Architected, build and test solution for configurable components replenishment and reservation
  • Designed extensions/customization to Order Management, Advance Pricing and Costing to meet business requirements
  • Facilitated the change management in the regional and national pricing to adapt to Oracle Pricing for the configurable product lines
  • Integrated custom workflows to improve Order-to-Cash processes
  • Designed and implemented extension to calculate profit margin for configurable products during the order entry point
  • Designed and implemented Huttig pricing roll-up extension for configurable products
  • Restructured the bills of material of the configurable products to accommodate the pricing, and product categorizing requirements
  • Designed and prepare various Order-to-Cash scenarios for Conference Room Pilot
  • Prepared various programs for loading legacy data to Oracle database in preparation to go live (price lists, modifiers, Bills of Materials, product categories, product catalogs, etc.)

Hire Now