ORACLE PROFICIENCIES:

• Setup and Use Oracle Release 10.2, 10.4, 10.5, 10.7(GUI), 11.0, 11i, R 12
• Oracle Inventory, Purchasing / Projects, Order Entry, Accounts Receivable, Bill of Materials/Routings, Costing, WIP, Oracle Planning Products (Forecasting, MDS, MPS, MRP, ASCP, Capacity, Oracle Quality, Oracle WMS (Warehouse Management System)
• Oracle ATO, ATP setup and use
• HP - UX Administration
• Oracle Applications System Administration
• SQL/SQL Plus
• Oracle Applications DBA
• SQL Loader
• Oracle Reports 2.5

PROFESSIONAL EXPERIENCE:

Site Team Lead - Manufacturing

Confidential

Responsibilities:

• Configure Oracle Rel 11i to support local facility manufacturing, inventory, procurement, kanban, quality, ASCP, and shipping requirements
• Gather current state requirements and business drivers and recommend business solutions to migrate local operations into the global Confidential TMS architecture.
• Developed Business Process diagrams to map current state vs. future state business process and information flow.
• Assist management with understanding business impact of future state design on local resources, daily requirements, process and information flow.
• Configure Oracle R11i to support future state business processes.
• Configure Inventory, WIP, ASCP, Costing, Procurement, Bill of Material, and Routing applications to support client requirements and maintain integration of business processes to the global footprint.
• Develop plan to facilitate and drive data integrity from legacy system for conversion to TMS.
• Train client Super User in Oracle methods to support project and post-go live tasks.
• Evaluate client bar-coding requirements.

Plan to Produce Team Lead

Confidential, Athol, MA

Responsibilities:

• Work with management and end users to gather current business requirements.
• Develop future state process and data flows to support all business activities.
• Develop solution in Oracle R12 to support current operations and integration of legacy systems and business requirements.
• Configure Oracle Rel 12 using Oracle Business Accelerator product.
• Gather current state requirements and business drivers.
• Configure Oracle R12 to support business activities for CRP1 thru Go-Live
• Prepare CRP1 instance using the Oracle Business Accelerator tool.
• Configure Inventory, WIP, ASCP, Cost, Bill of Material, and Routing configurations to support client requirements
• Develop repetitive manufacturing model to support flow manufacturing in different manufacturing facilities.
• Develop legacy data mapping for conversion into Oracle tables.
• Develop test scripts and conversion strategy.
• Train client Super User in Oracle methods to support project and post-go live support.
• Evaluate client bar-coding requirements.
• Assist with the configuration of Oracle MSCA to integrate with the client current barcode systems and labels.

Plan to Produce Team Lead

Confidential

Responsibilities:

• Configure Oracle R12 using Oracle Business Accelerator product.
• Gather current state requirements and business drivers.
• Configure Oracle R12 to support business activities for CRP1 thru Go-Live
• Prepare CRP1 instance using the Oracle Business Accelerator tool.
• Configure Inventory, WIP, ASCP, Cost, Bill of Material, and Routing configurations to support client requirements
• Develop legacy data mapping for conversion into Oracle tables.
• Develop test scripts and conversion strategy.
• Train client Super User in Oracle methods to support project and post-go live support.
• Evaluate client bar-coding requirements.
• Assist client with setup of Oracle MSCA and barcode reader definition and testing.
• Provide go live and post go live support to local and remote facilities.
• Configure Oracle MSCA to integrate with the client current barcode systems and labels.

Process Execution Team Lead

Confidential

Responsibilities:

• OSFM Manufacturing Team Lead for Oracle Manufacturing ASCP, Bills, Routings, Planning, Costing and OSFM.
• Team consisted of 3 external consultants, 3 full time client people, and 6-8 part-time client participants.
• Model client specific business requirements in Oracle 11.5.10.2 Applications
• Define Warehouse Specific information needs to map to Oracle WMS. Define Item attributes, storage location capacities, and inbound logistics.
• Define custom interface and report extensions.
• Develop legacy data mapping and conversion documentation.
• Develop test scripts and supporting documentation.
• Define current and future business requirements and processes.
• Setup and Test Inventory, ASCP, Bill of Materials, Routings, OSFM, Work in Process modules.

Manufacturing Team Lead

Confidential

Responsibilities:

• Manufacturing Team Lead for Oracle Discrete Manufacturing
• Model client specific business requirements in Oracle 11.5.10 Applications
• Define Warehouse Specific information needs to map to Oracle WMS.
• Define Item attributes, storage location capacities, pick rules.
• Define Sourcing Rules and Bills of Distribution.
• Define custom interface and report extensions.
• Develop legacy data mapping and conversion programs
• Define test scripts and develop supporting documentation using Oracle UPK.
• Setup and Test complete ASCP functionality to support business requirements.

Manufacturing Team Lead

Confidential

Responsibilities:

• Develop site-specific project plan with integration into corporate wide IT management objectives and project plans.
• Develop team requirements and project plan to begin plant rollout and implementation of full suite Oracle applications. Both finance and manufacturing
• Develop current state legacy requirements.
• Map current legacy requirements to fit in the Global model.
• Develop Oracle model to support operational functions.
• Map legacy processes to Oracle.
• Develop plan for data mapping and conversion.
• Functional consultant on Quality, Bill of Materials, Routings, Work in Process, Constraint Based Planning, Inventory, Receiving, Shipping, Warehouse Management.
• Team consisted of 5 functional consultants and multiple part time client participants at each manufacturing site.

Site Project Lead

Confidential

Responsibilities:

• Assist in project plan development with time lines and staffing requirements.
• Direct business leaders thru entire implementation phase from solution design thru Production Cut over.
• Map current and future business requirements, gap analysis, and system modeling, and functionality testing.
• Mapped ODM data from current Macola and Agile systems for conversion.
• Trained solution managers and end users.
• Conducted three phase CRP testing
• Lead business leaders thru transition from legacy systems onto the new Oracle manufacturing suite.
• Coordinate ODM warehouse setup and process definition for warehouses in California and Denmark. Performed CRP on Warehouse model but did not fully implement.
• Develop processes to utilize Oracle Process Manufacturing and Oracle Discrete in the same environment across different plants. Location using OPM to supply components and supplies to facility using Discrete Manufacturing.
• Team consisted of 5 full time client participants dedicated to the manufacturing and planning applications.
• Team responsible for setup and implementation of Inventory, Work in Process, Kanban, Receiving, Shipping, Bill of Material, Routings, Costing, Warehouse Management and definition, ASCP, basic barcode integration.

Site Process Owner / Team Lead.

Confidential

Responsibilities:

• Setup Oracle Quality module for new plant implementation.
• Develop all processes and documentation for conversion and go-live support
• Assist during go-live for Quality and general manufacturing support.
• Provide shop floor training and support for manufacturing personnel post go-live.
• Define new Quality processes for Mexico plant.
• Train new Quality manager.
• Work with Corporate Quality group to broaden use and features of the Oracle Quality application throughout the company.
• Work with plant management to define new and better manufacturing processes and data capture capabilities to support corporate functions such as skip-lot receiving.
• Analyze new business requirements and map to Oracle functionality. Setup Oracle process to support requirements, demonstrate to management and develop implementation plan for new functionality at individual plants.
• Performed application setup and implementation for Work in Process, Inventory, Receiving, and Quality.
• Team consisted of 2-3 client participants and myself.

Principal Consultant

Confidential

Responsibilities:

• Modify configuration of existing MRP system to better support needs of material manager. Design new approach with routings to have MRP more accurately reflect the manufacturing processes on the shop floor
• Begin the design work for a sister plant that was not on Oracle. Setup Inventory, Items, receiving process, and Planning processes to work within customer specifications.
• Configure and Assist on going implementation with Oracle Process Manufacturing. Develop recipe and batch control and inventory management processes to support filter paper manufacturing.
• Setup CRP environment and demo processes in Oracle to plant management for gap analysis and process definition.
• Defined requirements and functional setups for Inventory, Work in Process, Routings, Bill of Materials, MRP.

Principal Consultant

Confidential

Responsibilities:

• Develop business plan for purchasing and inventory to support raw material demand thru Oracle MRP to better plan raw material purchases.
• Implement Inventory, Purchasing, MRP, WIP, and Kanban procedures.
• Setup and develop business process to support Oracle WMS

Principal Consultant

Confidential

Responsibilities:

• Provide support for on-going implementation of Oracle Inventory
• Provide manufacturing functional support for planning future implementation of Oracle Manufacturing Applications in other business units.

Principal Consultant

Confidential

Responsibilities:

• Prepare system and client personnel for implementation of Oracle Manufacturing. Develop requirements, conduct training, do setups, and conduct testing.
• Provide support for Inventory, Planning and Purchasing modules
• Design interfaces between Oracle and Seibel CRM product.
• Setup Oracle WMS, test with users thru CRP phase and develop business processes to support WMS system.

Principal Consultant

Confidential

Responsibilities:

• Performed joint role with Colibri Limited Company setting up and defining pre and post sales scenarios in Oracle Release 11i. Scenarios and processes included all areas of manufacturing and purchasing. This position reported to one of the Colibri partners and was performed offsite based on sales and client requirements. Scripts were developed to support requirements and system parameters were defined to support specific functionality as desired by the client.
• Performed detailed business analysis of multiple manufacturing facilities generating business requirements and gap analysis between current and future state needs.
• Team Lead for Release 11 upgrade - Responsible for the Procurement / Receiving team setting up and migrating to Oracle Release 11. Also was a joint participant on Order Entry, Shipping and Manufacturing teams. Implemented Oracle Quality collection plan to capture data on incoming material shipments for reporting purposes. Participated in group decision meetings concerning other integrated functional modules (Inventory, WIP, Bill of Materials, Manufacturing Planning, Capacity and Sys Admin).
• Team consisted of 4 client personnel both IT and general business users.
• Implemented Oracle manufacturing and procurement applications at several of these facilities along with business process design and modifications for streamline use and best fit mapping to the Oracle applications.
• Setup and implement Oracle Purchasing with integration into Oracle Projects.
• Setup and implement forecasting along with consumption rules to track a specific section of the business.
• Setup and trained material managers and material planners on concepts, use and control of Oracle planning tools and processes (MDS, MPS, MRP).
• Develop training material for user community. Training was designed to enhance the general knowledge of Oracle applications and provide a first step in preparing for a Release 11 upgrade.
• Developed transition plan for migrating data and business processes from Release 10.7 to Release 11.
• Developed plans and testing procedures to prepare for Y2K testing and upgrading. Identified and resolved system issues resulting from the date change or application of Y2K patch sets.
• Production Support - Responsible for supporting Oracle Applications in all areas of
• The business from Order Entry, Manufacturing, Planning, Forecasting, Shipping and Inventory Control.
• Train users on best practical methods, forms and reports to support their business processes.
• Troubleshoot all applications when system functionality was in question. Log TARs where appropriate and coordinate with the DBA staff to get patches tested and applied to production.
• Performed setup and implantation for MRP, Costing, Bill of Material, Routings, Inventory, Receiving, Work in Process.

Principal Consultant

Confidential

Responsibilities:

• Team Lead for design and implementation of Asian manufacturing and distribution operations based in Singapore. Design, setup and implement Oracle Applications including Oracle Order Entry, Oracle Inventory, Oracle Purchasing, Oracle Assemble to Order processes, Oracle Manufacturing, Costing and Oracle Shipping.
• Team consisted of 2-3 business users and myself along with several part-time participants.
• Consulting team lead for domestic Oracle Inventory, Receiving and Shipping with design and cross functional solution mapping for other teams (Oracle Order Entry, Oracle Accounts Receivable, Oracle Purchasing, WIP, BOM, Planning, Sys Admin, AOL and DBA roles).
• Performed detailed analysis of different company locations to determine organization structures including subinventories, locator control and business process design and shop floor layout.
• Designed item structures including attribute settings, templates, subinventory and organization controls to support an ATO/ATP environment.
• Consulted on other teams to assist in the development of BOMs, Routings, Backflush controls, WIP and purchasing setups to support the above ATO/ATP environment.
• Supported ALL teams at the Houston, TX facility in a System Administration and troubleshooting role performing SQL*Plus queries and updates and simple report development using Oracle Reports.
• Worked on the data mapping team to design the conversion and interface requirements and specifications for Legacy to Oracle Applications conversions.
• Assisted the Oracle DBA functions in troubleshooting system performance, patch monitoring and patch application activities.
• Comfortable in both Oracle Application functional and Oracle Database technical roles for system design, implementation and solution development for all Oracle Manufacturing Applications including Oracle Order Entry and Oracle Purchasing using facilities found in Oracle Applications Library (AOL) and Application Systems Administration.
• Performed small amount of conversion and data loads using SQL*Loader and SQL*Plus.
• Performed functional setups for Work in Process, Inventory, Receiving.

Confidential

Principal Consultant

Responsibilities:

• Team Lead for Oracle Inventory and Oracle Purchasing on a global project to support the procurement and inventory needs in stockrooms to support a global transportation fleet of ships, trucks, railcars, etc.
• Worked closely on the Organization development teams to best determine the design of the global organization structure to support multi-org activities including multiple currencies.
• Assisted customer with Business Requirements definitions, Current and Future state designs, GAP analysis and solution development.
• Designed custom extensions and performed time estimates to perform the custom development activities.
• Setup and demonstrated base system and Best-Fit analysis for Business Requirements.
• Participated on applications cross-functional team responsible for insuring good application fit between departments and business units.

Principal Consultant

Confidential

Responsibilities:

• Performed a Technical Lead role on this project. Assigned to the corporate headquarters to support the IS department in setting up the UNIX machines with the OFA architecture, installation of the database and applications.
• Performed minimal UNIX system management setting up users and groups, moving instances for space and performance considerations.
• Was the single point of contact for Application troubleshooting and System Administration. Logged calls from functional teams and performed analysis of the problem to determine cause.
• Implemented work-around or worked with Oracle World Wide Support to correct the problems with either SQL or TAR/Patch maintenance.
• Applied and tested patches to the Oracle Applications systems.
• Developed project plans for sub-tasks such as major installations or upgrades.
• Managed other customer employees and consultants to properly time and execute the plan for minimal user downtime.
• Recommended and educated the client on the Oracle Flexible Architecture to support custom development environment using AOL and System Administration facilities.
• Applications supported: Oracle Inventory, Oracle Accounts Payable, Oracle Accounts Receivable, Oracle Purchasing, Oracle Manufacturing, (BOM, WIP, Routings, Costing).