Carlos Gomez - Oracle Sr. OPM/ASCP/Manufacturing Consultant

 

Executive Summary
•	13+ years of functional and technical experience including 9+ years of solid Oracle ERP experience. Areas of interest and strength include Oracle E-Business Suite Implementation and its Interface/ Integration with 3rd Party Software.
•	Completed Five full life cycle Oracle Implementations: Two Oracle OPM, one OPM/ASCP/INV/QC, one Purchasing/ iProcurement/Inventory and one Oracle Costing Projects 
•	Completed Three upgrade/support Oracle projects: one Discreet Manufacturing and two OPM (Oracle Process Manufacturing) Upgrades.
•	Experience as Team Leader. Improvements in the integration and data transferring between Legacy Systems and Oracle E-Business Suite (MDG, Manugistics and GPRS). Functional/technical upgrade for Discrete Manufacturing. Implementation and data conversion of Procurement and Inventory.
•	Working experience in the role of Analyst for Inventory, BOM, Routings, Formulator (OPM), Quality (OPM), WIP, Costing and Procurement.
•	Strong in using Oracle Apps/Developer tools and Discoverer.
•	Country experience including USA, Canada, UK, Germany and Mexico.
•	Excellent communication, team building and project management skills.
•	8+ years of functional and technical experience in OPM, Discrete Manufacturing, Inventory, CDOA and the legacy interfaces and API’s usage.


Skills Summary
•	Oracle Applications Modules: ASCP (Oracle Advanced Supply Chain Planning), OPM (System Admin, Inventory, Cost Management, Formulator, Process Execution, Logistics, Product Development, Quality Management), Inventory, BOM, WIP, Costing, Purchasing and CDOA.
•	Oracle Application Releases: 11.0.3, 11.5.10 and R12.
•	Tools: Oracle Developer Tools, TOAD, SQL Navigator, Discoverer and Appworks.
•	Languages:  SQL, PL/SQL, C++, XML (basic), Java (basic)
•	Productivity Applications: MS Office, VSS.


Oracle Apps Skills and Tools
•	Study of current business processes, future business flows, and identification of gap / workarounds.
•	Business Requirements Mapping for Projects, ASCP, OPM, QC, Costing, INV, BOM, WIP, PO and CDOA modules.
•	Testing environment setup - Test scripts and User Acceptance Tests (UAT).
•	Log, view, access, monitor, follow up and close Service Requests (TARs) online - Oracle Metalink and Oracle Applications Patch Management.
•	Setup of ASCP, OPM, Inventory, Purchasing, WIP, BOM, and CDOA.
•	Data conversion from Legacy systems using Open Interfaces and/or SQL loaders.
 
Oracle Applications Projects Experience

Client: KOCH Industries Inc., Wichita, KS. US		
Industry: Refining and chemicals
Description: Koch Industries owns companies involved in refining and chemicals; process and pollution control equipment and technologies; minerals and fertilizers; polymers and fibers; commodity and financial trading and services; and forest and consumer products.

Project: Oracle Applications implementation R12	Sep 08 to Actual
Role: Sr. Functional Consultant
Description: Implementation of OPM, ASCP, Inventory and Quality Management.

•	Analysis of current business processes and definition of new processes within Oracle Application.
•	Business requirements gathering, mapping, gap identification and workarounds.
•	Responsible to trainee IT personal and implementers within modules of ASCP, OPM, Inventory and Quality Management (Process Manufacturing).
•	Data conversion mapping and support to technical team for requirements.
•	Business processes definitions to be implemented within new environment.
•	Definition of custom process to have pending forecast at the end of the month for planning.
•	BR100 and MP050 documentation.
•	Environment configuration and scenarios preparation, documentation and proof of concepts.
•	Setup, Test and training on Internal Sales Orders functionality.
•	Inventory Items configuration for OPM, ASCP, Forecast, ISO and Quality capable.
•	Organizations configuration to allow ISO between them.
•	Inventory Plan configuration for OPM functionality
•	Formula and Recipe configuration for Batching within OPM to allow ASCP and custom code create batches to drive Production Plan
•	Quality Specification configuration and QC business definitions.
•	ASCP souring rules configuration to allow ATP and OM’s SO scheduling process to define “source from” calculation based on customer site’s region
•	Patching and bug research, implementation requests, test and delivery.
•	Task and Cutover listing.
•	Diagram and nightly routings (Planning) definition and documentation.
•	Post Go-live production support


Client: SMART Technologies Inc., Ottawa, ON, Canada		
Industry: Technology
Description: SMART Technologies is both the industry pioneer and market-segment leader in easy-to-use interactive whiteboards and other group collaboration tools.

Project: Oracle Applications implementation R12	Dec 07 to Jun 08
Role: Sr. Functional Consultant
Description: Implementation of PO/iProcurement/INV.

•	Analysis of current business processes and definition of new processes within Oracle Application.
•	Business requirements mapping for PO.
•	Super users training and documentation for end users training.
•	Discussion moderator to get agreements on scope and reachable implementation steps for Procurement and Inventory modules.
•	Team lead for the implementation and definition of requirements for PO/INV modules (2-3 members).
•	Requirements assessment Analyst.
•	Team Lead for PO and Implementer for INV. 
•	Organization structure mapping from scratch for Inventory and Purchasing purposes.
•	Moderator and guide for CRP’s, UAT and go-live processes working with SMART Purchasing and Inventory teams.
•	Deliverables: MD050, BP080, Cutover listing, BR100 documentation and Workflow diagramming.
•	Oracle SR holder.
•	Agreements on customizations and scope within Oracle Standard Functionality.
•	Data conversion coordinator for Supplier, Locations, Organizations, Carriers and ASL.
•	Categories and Catalog definitions.

Client: GE Transportation, Erie, PA		
Industry: Transportation
Description: GE Transportation is the world’s leading manufacturer of diesel-electric locomotives with more than 15,000 locomotives operating around the globe. At the same time, they are a chief provider of on-board and wayside signaling, communications, control and information systems. GE Transportation is also the industry leader in service, maintaining an installed base of more than 8,000 locomotives worldwide.

Project: Oracle Manufacturing and Distribution 11.5.10	May 07 to Nov 07
Role: Functional Team Lead and QA Management
Description: New Organizations implementations for Inventory/WMS, Manufacturing, OM and Distribution modules.

•	Responsible for the clearance process of the interface transactions, allowing closing of inventory periods.
•	Definition of processes during GE-Rail Organizations setup. Assessment, documentation, and identification of new requirements, including WMS setup and configuration steps including OM and Distribution aspects.
•	Review specifications and definition of new requirements or enhancements with the end users.
•	Responsible to review and migration code related to Manufacturing and Inventory.
•	Responsible for the training of new team members whenever they are required to work with manufacturing modules.
•	Functional documentation.
•	Oracle TAR handling.

Project: Oracle Manufacturing Application 11.5.10	May 06 to May 07
Role: Team Lead and QA management
Description: Implementation of improvements for manufacturing modules.

•	Team Lead for Inventory/Manufacturing/WMS modules.
•	Lead for Inventory Interfaces Transaction resolution. 
•	Leading costing interface maintenance and improvements.
•	Support team members to achieve resolution of issues, requests and enhancements.
•	Librarian role to promote and validate the use of standards, and assure change accuracy for code corrections.
•	Knowledge transfer handling for documentation and expertise purpose with the GE Analysts.
•	Onsite Lead Analyst and data collector to pass and lead corrections and fixes with the Offshore Team.
•	Onsite 24x7 support and mediator for Oracle TAR processing, testing and implementation.
•	Quality Assurance responsible for discreet manufacturing modules.

Project: Oracle Applications migration from 10.7 to 11.5.10	May 05 to May 06
Role: Team Lead
Description: Full life cycle Upgrade, including customizations and migrations.

•	Team Lead for the migration of Oracle Costing, WIP, BOM, MRP, Planning and OM to version 11.5.10.
•	Table mapping identification and registration.
•	Custom objects control and classification into a repository.
•	Custom objects migration for WIP, BOM, Costing, MRP, Planning and Order Management modules.
•	Design, analysis and development of enhancements and new features, including customized reports, procedures and forms, in order to adapt Oracle solution and meet customer requirements.
•	Responsible for tuning and continuous performance improvements.
•	Coaching of team members in Planning, Inventory, WIP, BOM, Costing, OM and MRP modules.
•	Development of migration documentation, including issues detected and improvements implemented during the Go Live.
•	Onsite Analyst for the requirements during the upgrade process. Coordination of the Offshore Team (5 members) to accomplish and meet time and scope agreements to complete the required migration.

Environment: Solaris, Windows XP, Test Director, Visual Source Safe, Kintana Tools. Modules: BOM, WIP, Costing, Planning, MRP, OM and INV.


Client: Kellogg Company of UK, Manchester, UK and Bremen, Germany.		
Industry: Foods
Description: Kellogg Company is the world's leading producer of cereal and a leading producer of convenience foods, including cookies, crackers, toaster pastries, cereal bars, fruit snacks, frozen waffles and veggie foods. Kellogg products are manufactured in 17 countries and marketed in more than 180 countries around the world.

Project: Oracle Applications 11i Implementation 11.0.3	Nov 03 to Jan 04
Role: Sr. Functional OPM Consultant 
Description: Full cycle implementation, Oracle OPM Costing solution for Germany.

•	Business requirements collection and mapping to Oracle standard functionality.
•	Definition of bespoke requirements due to integration with Legacy systems.
•	Implementation of OPM Costing.
•	Analysis, design and development of integration interfaces between Legacy systems and Oracle OPM.
•	Designer of integration interfaces for Oracle OPM Costing.
•	Developer of custom code to use API’s and integrates data between Oracle and legacy systems.
•	OPM Costing account setup and rules definition (MAC).
•	Analyst/Developer/Implementer to integrate Master Item’s within OPM Inventory from Customer’s GPRS system (Custom program).

Environment: Unix Solaris, Window XP, Windows NT, VPN, Citrix, Modules: OPM, Costing, GL and CDOA

Project: Oracle Applications 11i Implementation 11.0.3	Oct 02 to Jan 03
Role: Sr. Functional OPM Consultant 
Description: Full cycle implementation. Oracle OPM Costing solution for UK.

•	Business requirements collection and mapping to Oracle standard functionality.
•	Definition of bespoke requirements due to integration with Legacy systems.
•	Implementation of OPM Costing.
•	Analysis, design and development of integration interfaces between Legacy systems and Oracle OPM.
•	Designer of integration interfaces for Oracle OPM Costing.
•	Developer of custom code to use API’s and integrates data between Oracle and legacy systems.
•	OPM Costing account setup and rules definition (MAC).
•	Analyst/Developer/Implementer to integrate Master Item’s within OPM Inventory from Customer’s GPRS system (Custom program).

Environment: Solaris, Window XP, Windows NT, VPN, Citrix, Modules: OPM, Costing, GL and CDOA


Client: Kellogg from Asia-Pacific, Provided from Queretaro, Mexico		
Industry: Foods
Description: Kellogg Company is the world's leading producer of cereal and a leading producer of convenience foods, including cookies, crackers, toaster pastries, cereal bars, fruit snacks, frozen waffles and veggie foods. Kellogg products are manufactured in 17 countries and marketed in more than 180 countries around the world.

Project: Oracle Applications 11i migration from 10.7 to 11.0.3	Jun 01 to Mar 02
Role: Sr. Functional Consultant
Description: Oracle Upgrade including Oracle OPM, Inventory, CDOA and development of Integration interfaces for Kellogg Asia Pacific.

•	Oracle upgrade of OPM, Inventory and legacy interfaces.
•	Migration and amendment of integration interfaces within legacy systems.
•	OPM issues solution and setup corrections as required.
•	Migration of interfaces from GPRS systems (master items and formulas define tool) to CDOA, OPM (Routings, Formulas and version control) and Inventory.
•	Documentation of enhancements required for migration purposes.
•	Training and handover to team members during and after migration.
•	Analysis, design and development of new functionality on legacy systems required to work according to new Oracle definitions on new version.
•	Oracle adjustments made to have OPM running according to business needs (routing deactivation and version control)
•	Improvement on Oracle resource demand regarding integration data between OPM and Purchasing.
•	Definition of legacy and custom solutions and interfaces for OPM and INV

Environment: Solaris, Windows NT, VPN, Citrix, Modules: OPM, Costing, GL and CDOA

Client: Kellogg de Mexico, Queretaro, Mexico		
Industry: Foods
Description: Kellogg Company is the world's leading producer of cereal and a leading producer of convenience foods, including cookies, crackers, toaster pastries, cereal bars, fruit snacks, frozen waffles and veggie foods. Kellogg products are manufactured in 17 countries and marketed in more than 180 countries around the world.

Project: Oracle Applications 11i Migration from 10.7 to 11.0.3 in 7 countries  	Mar 00 to Jan 01
Role: Functional Consultant
Description: Upgrade of Oracle OPM, Inventory, CDOA and Integration interfaces for Kellogg Latin-American.

•	Migration of OPM setups and Inventory modules.
•	Migration and amendment or integration interfaces within legacy systems.
•	Support and handling of data for other systems for operations control and productivity measurement.
•	Migration of interfaces from GPRS systems (master items and formulas define tool) to CDOA, OPM (Routings, Formulas and version control) and Inventory.
•	Documentation of enhancements required for migration purposes.
•	Training and handover to team members during and after migration.
•	Analysis, design and development of new functionality on legacy systems required to work according to new Oracle definitions on the new version.
•	Oracle adjustments made to have OPM running according to business needs (routing deactivation and version control)
•	Improvement on Oracle resource demand regarding integration data between OPM and Purchasing.

Environment: Solaris, Window XP, Windows NT, VPN, Citrix, Modules: OPM, Costing, GL and CDOA


Project: Oracle Applications 11i Support for Kellogg worldwide  	Mar 00 to Jan 05
Role: Techno/Functional Consultant
Description: Kellogg worldwide Improvements and enhancements handling for Oracle Applications including the modules: OPM, INV, Costing, Projects, Purchasing-OPM interfaces and OPM-legacy systems interfaces (ESS, GPRS and Manugistics).

•	Support the issues and enhancements related to OPM, Costing, Purchasing-OPM, Inventory and Legacy related interfaces.
•	Team work to improve Oracle functionality and information accuracy within Oracle internal interfaces.
•	Team training for handover and knowledge transfers to allow team involvement into support and new enhancement or implementations.
•	Delivery of metrics for SLA with the different Kellogg business worldwide.
•	Delivery of control reports and documentation of the improvements and corrections in a monthly basis.
•	Development of new reports and/or improvements of existing ones using Oracle Discoverer and Oracle Reports.
•	Continuous data recompilation to accomplish customer satisfaction  

Environment: Solaris, Windows NT, VPN, Citrix, Modules: OPM, Costing, INV, Purchasing, GL and Manugistics.


Project: Oracle Applications Projects on 11.0.3  	Nov 99 to Feb 00
Role: Techno/Functional Consultant
Description: Implementation of Oracle Costing Projects.

•	Analysis, definition and implementation of Capital, Advertising and Promotions, and Convenience Foods Projects.
•	Projects setup with account mappings and rules.
•	Data cleansing, conversion and loading from Excel files to Oracle projects.
Environment: Unix Solaris, Windows NT, VPN, Citrix, Modules: Projects, GL.


Other Experience

Agroasemex S.A.  
Project Leader, October 1997 – September 1999, Queretaro, Mexico.
•	I made several design corrections to the application we were working on, this contributed to implement the whole project with a month in advance.
•	Constantly I was invited to review and suggest corrections and improvements to other applications. With this participation I achieve an improvement in the delivery time and the number of resources assigned to such projects.

Embotelladora de Occidente S. A. de C. V. (PEPSI).
Programmer Analyst, October 1996 – October 1997, Guadalajara, Mexico
•	I designed, developed and implemented several bespoke applications or traffic control, planning, scheduling and Manufacturing control, MRP, Layout for trailers loads.
•	I researched the fundamental theory and statistical basis in order to know and be able to define and program a good manufacturing planning and scheduling. This contributed to the development of the projects made to Supply Chain area.
•	I improved the estimated time and agreed with IT and Supply Chain Managers, regarding development and implementation times.

Education
B.S. Computational Systems Engineer, 1996
Instituto Tecnologico de Queretaro, Mexico

Master of Science on Industrial Engineering, 2003 (not finished)
Instituto Tecnologico de Queretaro, Mexico



Languajes
English	Fluent
Spanish	Native



Member number:9916
Additional Contact information is available on the Information Page.
Software Contractors' Guild (www.scguild.com)
Copyright(c) 1995 - 2008 Fast Dolphin and Software Contractors' Guild, 3 Country Club Dr., #303, Manchester, NH USA 03102