Mario Sanchez - Oracle Financials Functional Lead
Executive Summary
• 13+ years of solid functional Oracle ERP experience. Areas of interest and strength include Oracle Applications Implementation and its Interface/ Integration with 3rd Party Software, leading projects, designing and developing information systems and implementing business processes and integrated systems within an ERP environment including Manufacturing modules, and recently migration from 11.5.7 environment to R12.04 EBS Suite.
• Completed several live Oracle Applications full life cycle implementations.
• Team Leader for Supply Chain and Purchase To Pay whole cycles including Order Management, Purchasing, iProcurement, Contracts, Property Manager, Sourcing, Enterprise Asset Management, Project Accounting, Inventory, Quality, Accounts Payable, iSupplier, iExpenses, Fixed Assets and General Ledger modules, and Implementer for Purchasing, Inventory and Accounts Payable.
• Responsible for APPS and Reports Development from functional designs and specifications to test solutions delivered by technical teams.
• Solid background with high caliber consulting companies as a full time employee of Oracle Corporation, Cap Gemini and Bearing Point.
• Country experience including US, Mexico, Honduras, El Salvador, Dominican Republic, and Venezuela.
• Excellent communication, team building and project management skills.
Skills Summary
• Oracle Applications Modules: GL, AP, FA, PO, INV, OM, iProcurement, Property Manager, Enterprise Asset Management, Sourcing, Quality, iSupplier and iExpenses.
• Oracle Application Releases: 10.5, 10.7, 11.0.3, 11.5.4, 11.5.5, 11.5.8, 11.5.9, 11.5.10.2 and 12.04
• Methodologies & Documents: Oracle’s Applications Implementation Methodology (AIM), Oracle documents including: BP040, RD010, RD020, CV010, BP080, RD050, BR010, BR020, BR030, MD020, BR100, BR110, MD050, CV040, CV060 and TE020.
• Productivity Applications: MS Office, MS Visio and MS Project.
• Deep Accounting and Business Process knowledge.
Oracle Apps Skills and Tools
• Study of Current Business Processes, Future Business Flow and identification of GAP / workaround.
• Business Requirements Mapping for PO, INV and AP modules.
• Designing Oracle Applications Financial and Operating structure of client organizations-Multi-Org Setup and Multiple Set of Books.
• Testing modules’ setup for inconsistencies and missing steps-Test scripts and User Acceptance Tests (UAT).
• Log, view, access, monitor, follow up and close Technical Assistance Requests (TARs) online-Oracle MetaLink and Oracle Applications Patch Management.
• Setup of Accounts Payable, Fixed Assets, Purchasing and Inventory.
• Data Migration from Legacy systems to Open Interfaces.
• Oracle EBS Migration Process to R12 from Functional perspective.
Oracle Applications Project Experience
Client: OXXO (FEMSA Commerce and Retail Division), Mexico
Industry: Retail and Maintenance
Description: OXXO is the largest convenience store chain in Mexico, with more than 6,300 points of sale all over the country and now they are on an expanding strategy which includes the purchase of brands and companies on Colombia and South America
Project: Oracle Applications Migration from 11.5.7 to R12.04 February 08 to Present
Role: Supply Chain-Maintenance Leader and Implementer.
Description: EBS Migration to R12
• Migration of Oracle EBS from 11.5.7 version to R12 RUP04 (PO, INV, EAM and PN).
• Weekly Status Reports, Issue Log and Plan updates to WIPRO (Project Owner).
• Leading the efforts of an 8 SME from the client and 8 6 developers.
• Making Actual State Analysis focusing on very complex customizations over EBS and interfaces (INCOME – OUTCOME) with Legacy systems.
• Planning and Design on Training strategy for more than 80 end users.
• Training to SMEs.
• Planning and Design Development tasks and delivery of 370 customized programs (Forms, Reports, Procedures, Triggers, etc), in order to migrate very complex customizations focusing on the changes from 11.5.7 to R12.
• Plan and Design of several testing rounds to certify the integrity of all data, developments and integrations with 3rd part software.
• Log, view, access, monitor, follow up and close Technical Assistance Requests (TARs) online-Oracle MetaLink and Oracle Applications Patch Management.
• Analysis, design and implementation of seamless integration between 3rd Parties Inventory-Purchasing and Payables with Oracle Applications modules of Oracle PO, INV and AP.
• Assisting in developing and testing software applications.
• Provided Training & Conducted Practice & Additional Business Requirements sessions.
• Carrying out Conference Room Pilots (CRP) and User Acceptance Tests (UAT), go-live activities and Post implementation support.
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems.
Environment: HP-UX PA-RISC (64 bits) 11.11; Modules: PO, INV, EAM and PN and numerous other 3rd Parties’ Software
Client: COMEX, Mexico
Industry: Manufacturing and Retail
Description: COMEX is the largest painting and covering products in Mexico, and now they are on an expanding strategy which includes the purchase of brands and companies on the US and Canada like General Paint, Parker Paint, Kwal-Howells, Frazee, ColorWheel and Duckback. COMEX is dedicated to manufacture and sell their products.
Project: Oracle Applications 11i Implementation 11.5.10.2 June 07 to February 08
Role: Procurement Leader and Implementer.
Description: Full Cycle Oracle Applications Implementation.
• Implementation of Oracle Applications 11i version 11.5.10.2 (PO, INV and AP).
• Weekly Status Reports, Issue Log and Plan updates to Oracle US (Project Owner).
• Leading the efforts of an 8 people team of super users from the client.
• Designing Oracle Applications Financial and Operating structure of vendors, items, inventory organizations, Multi-Org Setup and Multiple Set of Books with different currencies.
• Study of Current business processes, future business flow & identification of GAP/Workaround in order to provide an integrated information system solution to meet the business needs of the company.
• Business Requirements Mapping for Purchasing and Global Procurement Model.
• Testing modules Sessions facilitator and test scripts creation for CRPS and User Acceptance Tests (UAT).
• Log, view, access, monitor, follow up and close Technical Assistance Requests (TARs) online-Oracle MetaLink and Oracle Applications Patch Management.
• Data Migration from Legacy systems and Open Interfaces.
• Review Functional Specifications, Test and Quality Assurance for developments defined to fulfill GAPS identified.
• Analysis, design and implementation of seamless integration between 3rd Parties Inventory-Purchasing and Payables with Oracle Applications modules of Oracle PO, INV and AP.
• Assisting in developing and testing software applications.
• Provided Training & Conducted Practice & Additional Business Requirements sessions .
• Carrying out Conference Room Pilots (CRP) and User Acceptance Tests (UAT), go-live activities and Post implementation support.
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems.
Environment: Sun Solaris 10; Modules: PO, INV and AP and numerous other 3rd Parties’ Software
Client: PEMEX Petrochemical Division, Mexico
Industry: Petrochemical
Description: PEMEX Petrochemical is a Division of the Mexican, Government owned Oil Company. They are dedicated to manufacture petrochemical products from oil and sell them to the public in general.
Project: Oracle Applications 11i Implementation 11.5.10.2 (So called 10.7 to 11i Migration) July 06 to May 07
Role: Purchase To Pay Track Leader and Implementer.
Description: Full Cycle Oracle Applications Implementation.
• Implementation of Oracle Applications 11i version 11.5.10.2 (PO, Sourcing, Contracts, INV, AP and iSupplier).
• Weekly Status Reports, Issue Log and Plan updates to Steering Committee.
• Leading and coordinating the efforts of a 12 people team between consultants, super users and developers.
• Designing Oracle Applications Financial and Operating structure of vendors, items, inventory organizations, Multi-Org Setup and Multiple Set of Books with different currencies.
• Study of Current business processes, future business flow & identification of GAP/Workaround in order to provide an integrated information system solution to meet the business needs of the company.
• Business Requirements Mapping for Purchasing and Global Procurement Model.
• Testing modules Sessions facilitator and test scripts creation for CRPS and User Acceptance Tests (UAT).
• Log, view, access, monitor, follow up and close Technical Assistance Requests (TARs) online-Oracle Metalink and Oracle Applications Patch Management.
• Data Migration from Legacy systems and Open Interfaces.
• Review Functional Specifications, Test and Quality Assurance for developments defined to fulfill GAPS identified.
• Analysis, design and implementation of seamless integration between 3rd Parties Inventory-Purchasing and Payables with Oracle Applications modules of Oracle PO, INV and AP.
• Assisting in developing and testing software applications.
• Provided Training & Conducted Practice & Additional Business Requirements sessions .
• Carrying out Conference Room Pilots (CRP) and User Acceptance Tests (UAT), go-live activities and Post implementation support.
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems.
Environment: HP Tru64 UNIX; Modules: PO, Sourcing, Contracts, INV, AP and iSupplier and numerous other 3rd Parties’ Software
Employer: Cap Gemini
Position: Freelance and Associate Senior Consultant
Client: BIMBO, Mexico
Industry: Manufacturing, Supply Chain and Retail
Description: BIMBO is the largest bread company in the world with a very aggressive expanding strategy worldwide. They have designed Global processes already so they implement Oracle Software on all their purchased Companies quickly and efficiently always with the support of CG which has the outsourcing contract with them since the first implementation.
Project: Oracle Applications 11i Implementation 11.5.9 Oct 05 to Jun 2006
Role: Purchase to Pay Implementer.
Description: Rollout Implementation
• Implementation of Oracle Applications 11i version 11.5.9 (PO, INV and AP).
• Weekly Status Reports, Issue Log and Plan updates to Steering Committee.
• Leading the efforts of a 15 people team of super users from the client.
• Implementation of Global Solutions defined for Purchasing and Global Procurement Model.
• Log, view, access, monitor, follow up and close Technical Assistance Requests (TARs) online-Oracle MetaLink and Oracle Applications Patch Management.
• Data Migration from Legacy systems and Open Interfaces.
• Assisting in developing and testing software applications.
• Provided Training & Conducted Practice & Additional Business Requirements sessions .
• Go-live activities and Post implementation support.
Environment: Outsourced DB; Modules: PO, INV and AP and numerous other 3rd Parties’ Software
Employer: Bearing Point Consulting
Position: Oracle Service Line Manager
Client: ALSEA, Mexico
Industry: Manufacturing, Supply Chain and Food
Description: ALSEA is the Master Franchise owner of the 95% point of sales of Domino’s Pizza in Mexico, Master Franchise and only owner of all Starbucks Coffee shops, Popeye’s and Burger King fast food stores in Mexico. They own another company (DIA), which is the one in charge of all supply chain matters from all this brands and stores, gathering all goods in one central location to issue them on to 6 Distributions Centers all around Mexico.
Project: Oracle Applications 11i Implementation 11.5.9 Sep 2004 to Oct 2005
Role: Mexico Supply Chain team Leader and Implementer.
Description: Full Cycle Oracle Applications Implementation.
• Implementation of Oracle Applications 11i version 11.5.9 (PO, iProcurement, OM, INV, Discrete Manufacturing and Quality).
• Weekly Status Reports, Issue Log and Plan updates to Steering Committee.
• Leading the efforts of an 8 people team, 4 consultants and 4 super users from the client.
• Designing Oracle Applications Financial and Operating structure of vendors, items, inventory organizations, Multi-Org Setup and Multiple Set of Books with different currencies.
• Study of Current business processes, future business flow & identification of GAP/Workaround in order to provide an integrated information system solution to meet the business needs of the company.
• Business Requirements Mapping for Purchasing and Global Procurement Model.
• Testing modules Sessions facilitator and test scripts creation for CRPS and User Acceptance Tests (UAT).
• Log, view, access, monitor, follow up and close Technical Assistance Requests (TARs) online-Oracle MetaLink and Oracle Applications Patch Management.
• Data Migration from Legacy systems and Open Interfaces.
• Review Functional Specifications, Test and Quality Assurance for developments defined to fulfill GAPS identified.
• Analysis, design and implementation of seamless integration between 3rd Parties Inventory-Purchasing and Payables with Oracle Applications modules of Oracle PO, INV and AP.
• Assisting in developing and testing software applications.
• Provided Training & Conducted Practice & Additional Business Requirements sessions.
• Carrying out Conference Room Pilots (CRP) and User Acceptance Tests (UAT), go-live activities and Post implementation support.
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems.
Environment: Oracle On-Demand; Modules: PO, IProcurement, OM, INV, Discrete Manufacturing and Quality and numerous 3rd Parties’ Software.
Client: GRUPO POSADAS, Mexico
Industry: Hospitality
Description: POSADAS is the Largest Hospitality group in Mexico with brands like Fiesta Americana Grand, Fiesta Americana and Fiesta Inn.
Project: Oracle Applications 11i Implementation 11.5.8 May 2003 to Aug 2004
Role: Procure To Pay team Leader and Implementer.
Description: Full Cycle Oracle Applications Implementation.
• Implementation of Oracle Applications 11i version 11.5.8 (PO, iProcurement, INV, AP and iSupplier).
• Weekly Status Reports, Issue Log and Plan updates to Steering Committee.
• Leading the efforts of an 8 people team, 4 consultants and 4 super users from the client.
• Designing Oracle Applications Financial and Operating structure of vendors, items, inventory organizations, Multi-Org Setup and Multiple Set of Books with different currencies.
• Study of Current business processes, future business flow & identification of GAP/Workaround in order to provide an integrated information system solution to meet the business needs of the company.
• Business Requirements Mapping for Purchasing and Global Procurement Model.
• Testing modules Sessions facilitator and test scripts creation for CRPS and User Acceptance Tests (UAT).
• Log, view, access, monitor, follow up and close Technical Assistance Requests (TARs) online-Oracle MetaLink and Oracle Applications Patch Management.
• Data Migration from Legacy systems and Open Interfaces.
• Review Functional Specifications, Test and Quality Assurance for developments defined to fulfill GAPS identified.
• Assisting in developing and testing software applications.
• Provided Training & Conducted Practice & Additional Business Requirements sessions.
• Carrying out Conference Room Pilots (CRP) and User Acceptance Tests (UAT), go-live activities and Post implementation support.
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems.
Environment: Oracle On-Demand; Modules: PO, iProcurement, INV, AP and iSupplier.
Employer: Cap Gemini Ernst & Young
Position: Oracle Service Line Manager
Client: MATTEL, US
Industry: Manufacturing and Retail
Description: Mattel is the famous brand of toys part of Fisher Price dedicated to manufacture, distribute and sell their products all over the world.
Project: Oracle Applications Implementation Jan 2003 to May 2003
Role: Mexico Rollout Leader and Implementer.
Description: Rollout Implementation.
• Implementation of Oracle Applications (PO, AP, INV, iProcurement, iExpenses and AR).
• Weekly Status Reports, Issue Log and Plan updates to CGEY US (Project Owner).
• Leading the efforts of an 8 people team of super users from the client.
• Testing modules Sessions facilitator and test scripts creation for CRPS and User Acceptance Tests (UAT).
• Log, view, access, monitor, follow up and close Technical Assistance Requests (TARs) online-Oracle MetaLink and Oracle Applications Patch Management.
• Data Migration from Legacy systems and Open Interfaces.
• Provided Training & Conducted Practice & Additional Business Requirements sessions.
• Carrying out Conference Room Pilots (CRP) and User Acceptance Tests (UAT), go-live activities and Post implementation support.
Environment: Sun Solaris 10; Modules: PO, AP, INV, iProcurement, iExpenses and AR.
Client: GIS (Grupo Industrial Saltillo), Mexico
Industry: Manufacturing, Supply Chain and Retail
Description: GIS is one of the largest industrial groups in Mexico with different processing to sell companies like, Vitromex which produces and sales porcelain bathroom furniture, coverings, tiles and steel faucets, Calorex which produces and sale water heaters, Codexo which produces car monoblocs for the automotive industry, etc.
Project: Oracle Applications 11i Implementation 11.5.10 Feb 2001 to Dec 2002
Role: Mexico Purchase To Pay team Leader and Implementer.
Description: Full Cycle Oracle Applications Implementation.
• Implementation of Oracle Applications (PO, iProcurement, INV, Discrete Manufacturing, Quality and AP).
• Weekly Status Reports, Issue Log and Plan updates to Steering Committee.
• Leading the efforts of a 12 people team, 3 consultants and 8 super users from the client.
• Analyze and Design the scope, procedures and agreement levels for the Competencies Center developed for this project and the subsequent rollouts and support activities.
• Designing Oracle Applications Financial and Operating structure of vendors, items, inventory organizations, Multi-Org Setup and Multiple Set of Books with different currencies.
• Study of Current business processes, future business flow & identification of GAP/Workaround in order to provide an integrated information system solution to meet the business needs of the company.
• Business Requirements Mapping for Purchasing and Global Procurement Model.
• Testing modules Sessions facilitator and test scripts creation for CRPS and User Acceptance Tests (UAT).
• Log, view, access, monitor, follow up and close Technical Assistance Requests (TARs) online-Oracle MetaLink and Oracle Applications Patch Management.
• Data Migration from Legacy systems and Open Interfaces.
• Review Functional Specifications, Test and Quality Assurance for developments defined to fulfill GAPS identified.
• Assisting in developing and testing software applications.
• Provided Training & Conducted Practice & Additional Business Requirements sessions.
• Carrying out Conference Room Pilots (CRP) and User Acceptance Tests (UAT), go-live activities and Post implementation support.
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems.
Environment: Sun Solaris; Modules: PO, IProcurement, INV, Discrete Manufacturing, Quality and AP.
Employer: Oracle Corporation
Position: Senior Consultant
Client: Oracle Venezuela
Industry: Values Carrier and Energy
Description: Subcontracted by Oracle Venezuela in order to fulfill several projects with the implementation methodology “Fast Forward” which includes a set of pre-configured applications like calendars, SOB, Accounting Flexfield, Accounting Flexfield values, etc, designed for fast track implementations. Accomplished two different implementations with the Oracle methodology and products.
Project: Oracle Applications Implementation Jan 2000 to Feb 2001
Role: Fast Forward Implementer.
Description: Rollout Implementation.
• Implementation of Oracle Applications (PO, AP, INV, FA and AR).
• Weekly Status Reports, Issue Log and Plan updates to Oracle Venezuela (Project Owner).
• Leading the efforts of a 6 people team, 2 Consultants and 4 super users from the client.
• Testing modules Sessions facilitator and test scripts creation for CRPS and User Acceptance Tests (UAT).
• Log, view, access, monitor, follow up and close Technical Assistance Requests (TARs) online-Oracle MetaLink and Oracle Applications Patch Management.
• Data Migration from Legacy systems and Open Interfaces.
• Provided Training & Conducted Practice & Additional Business Requirements sessions.
• Carrying out Conference Room Pilots (CRP) and User Acceptance Tests (UAT), go-live activities and Post implementation support.
Environment: Spark Solaris; Modules: PO, AP, INV, FA and AR.
Client: NEXTEL
Industry: Communications
Description: Implementation of FA module and training to key and end users.
Project: Oracle Applications FA module Implementation and training Jan 2000 to Feb 2001
Role: FA Implementer.
Description: FA Implementation.
• Implementation of Oracle Applications FA module.
• Weekly Status Reports, Issue Log and Plan updates to Oracle’s PM.
• Leading the efforts of a 2 people team, 1 key user and 1 developer.
• Current State Analysis.
• Requirement Gathering and Analysis.
• GAP analysis
• Interface Functional Design from Legacy system to Oracle DB.
• Test scripts creation.
• Log, view, access, monitor, follow up and close Technical Assistance Requests (TARs) online-Oracle MetaLink and Oracle Applications Patch Management.
• Data Migration from Legacy systems and Open Interfaces.
• Provided Training & Conducted Practice & Additional Business Requirements sessions.
• Go-live activities and Post implementation support.
Environment: Spark Solaris; Modules: FA.
Client: PEPSI (GEMEX)
Industry: Bottling
Description: PO Rollout Implementation for the biggest Pepsi bottling group in Mexico. This project has been defined in two phases: one for National design and the second for all the rollouts in all their bottling plants all over Mexico.
Project: Oracle Applications PO module Rollout May 1999 to Jan 2000
Role: PO Implementer.
Description: PO Rollout Implementation.
• Rollout of Oracle Applications PO module once the national design has been defined on a previous project.
• Weekly Status Reports, Issue Log and Plan updates to Oracle’s PM.
• Interface Functional Design from Legacy system to Oracle DB.
• Test scripts creation.
• Log, view, access, monitor, follow up and close Technical Assistance Requests (TARs) online-Oracle MetaLink and Oracle Applications Patch Management.
• Data Migration from Legacy systems and Open Interfaces.
• Provided Training & Conducted Practice & Additional Business Requirements sessions.
• Go-live activities and Post implementation support.
Environment: Spark Solaris; Modules: PO.
Client: CETECO
Industry: Retail
Description: Analysis and design a Global Solution for one of the biggest retail selling companies in Central and South America with presence in more than 12 countries like Argentina, Brazil, Chile, Guatemala, El Salvador, Dominican Republic, Nicaragua, etc.
Project: Oracle Applications PO and Inventory modules Implementation Sep 1998 to May 1999
Role: PO and Inventory Implementer.
Description: PO and Inventory Global Implementation and Rollout.
• Analysis and design a Global solution and the procedures for the world wide Rollout.
• Rollout strategy and planning.
• Weekly Status Reports, Issue Log and Plan updates to Oracle’s PM.
• Rollout tasks for Honduras, El Salvador and Dominican Republic Head quarters.
• Interface Functional Design from Legacy system to Oracle DB.
• Testing modules Sessions facilitator and test scripts creation for CRPS and User Acceptance Tests (UAT).
• Log, view, access, monitor, follow up and close Technical Assistance Requests (TARs) online-Oracle MetaLink and Oracle Applications Patch Management.
• Data Migration from Legacy systems and Open Interfaces.
• Provided Training & Conducted Practice & Additional Business Requirements sessions.
• Carrying out Conference Room Pilots (CRP) and User Acceptance Tests (UAT), go-live activities and Post implementation support.
Environment: Spark Solaris, Modules: PO, and INV.
Employer: Multisistemas Consulting
Position: Consultant
Clients: Sabritas, BANCOMEXT, XEROX
Industry: Food, Banking, Manufacturing and Retail
Description: First contact with Oracle Applications working with several clients in small impact projects.
Project: Oracle Applications Implementation Feb 1996 to Aug 1998
Role: PO Implementer.
Description: PO module Implementation.
• Implementation of Oracle Applications PO module.
• Weekly Status Reports.
• Testing modules Sessions facilitator and test scripts creation for CRPS and User Acceptance Tests (UAT).
• Log, view, access, monitor, follow up and close Technical Assistance Requests (TARs) online-Oracle MetaLink and Oracle Applications Patch Management.
• Provided Training & Conducted Practice & Additional Business Requirements sessions .
Environment: Spark Solaris, Modules: PO.
Other Experience
Mexican Stock Exchange, Mexico Financial Analyst June 94 - Jan 96
• Financial Analysis on Financial Statements for Companies looking to subscribe values on the stock exchange.
• Follow up on client’s financial obligations fulfillment.
• Elaboration of financial reports for Mexican Exchange Administration Committee.
• Inscription procedures and tasks.
Mexican Stock Exchange, Mexico Accountant Analyst June 93 - May 94
• Accounting tasks and procedures.
• Bank Conciliation and Cash Flows analysis.
• Financial Statement and budgetary variance analysis and elaboration.
Price Waterhouse, Mexico Junior Audit June 92 - June 93
• Policies and Procedures Analysis.
• Financial Statements Analysis.
• Audit Informs elaboration.
• Audit Dictum elaboration for clients.
Education
• Chartered Accountant, Anahuac University 1988-1992
Member number:10313
Additional Contact information is available on the Information Page.
Software Contractors' Guild (www.scguild.com)
Copyright(c) 1995 - 2006 Mario Sanchez and Software Contractors' Guild,
3 Country Club Dr., #303, Manchester, NH USA 03102