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.)