Mario Lopez - Oracle Financials Functional Consultant
Executive Summary
• 14 years of functional experience including 7+ years of solid Oracle ERP experience. Areas of interest and strength include Oracle Applications Implementation and its Interface/ Integration with 3rd Party Software, Audit, and Finance Accounting. Completed 2 live Oracle Applications full life cycle implementations and 1 upgrade/support project to R11i and one upgrade/support project to R12.
• Implementation and support for Cash Management, General Ledger , Account Receivable, Purchasing , Inventory and Payables.
• Strong in using Oracle Apps tools including Oracle Workflow Builder,, PL/SQL, Oracle Reports
• Excellent communication, team building and project management skills
• 7 years of MFG/PRO ERP functional and technical experience , implementing and supporting, upgrades and development in Progress 4GL
Skills Summary
• Oracle Applications Modules: GL, AP, AR, CM ,PO
• Oracle Application Releases: 11.5.5,11.5.8 and 11.5.9, and R12
• Tools: Oracle Workflow, Oracle Discoverer , Oracle Reports,Dataload Classic,Dataload Professional.
• Languages: SQL, PL/SQL, Progress
• Methodologies & Documents: Oracle’s Applications Implementation Methodology (AIM), Oracle documents including: BP040, RD010, RD020, BP080, RD050, BR010, BR020, BR030, MD020, BR100, BR110, MD050, etc.
• Productivity Applications: MS Office, MS Visio and MS Project
Oracle Apps Skills and Tools
• Study of Current Business Processes, Future Business Flow and identification of GAP/Workaround
• Business Requirements Mapping for GL, AP,AR, PO and CM
• Testing modules’ setup for inconsistencies and missing steps-Test scripts and Users Acceptance Test (UAT)
• Log, view, access, monitor, follow up and close Technical Assistance Requests (TARs) online-Oracle Metalink and Oracle Applications Patch Management
• Setup of Cash Management, General Ledger ,Account Receivables, Accounts Payable, Purchasing and Cost Management.
• Data Migration from Legacy systems and Open Interfaces.
• Customizations and Client extension.
Oracle Applications Project Experience
Client: Cadena Comercial Oxxo S.A de C.V – Wipro Technologies
Industry: Retail
Feb 08 to Present
Role: Oracle Functional Consultant
Description: Oracle upgrade to R12
• Work with a offshore team in India.
• Upgrade Assessment of current business process in R11 (GL,AR and Cash Management)
• Impact analysis in current business process due upgrade changes/enhancements.
• Business process Mapping with all standard and customized modules.
• Design test scripts of all sub-process identified in assessment phase.
• Unit testing execution for each business process.
• Analyze and test integration with 3rd Parties and legacy systems.
• Full CRP1,CRP2 testing cycles, with issue trackers and SME’s sign of.
• Full UAT testing Cycles, with issue trackers and SME’s sign of.
• Assisting in developing and testing software applications.
• Provided Training & Conducted Practice & Additional Business Requirements sessions
• Supported production environments and users on a daily basis by responding to emergency requests
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems
• Post go-live support.
Environment: HP , GL,AR, CM,AP,PM,PO ,INV
Client: NovoCast S.A de C.V
Industry: automotive
Feb 07 to Feb 08
Role: Oracle Sr. Consultant
Description: Oracle implementation of new features and support.
• Implementation and support of Oracle Applications 11i Ver. 11.5.8 (GL,AP,AR and Cost Management)
• Testing modules’ setup for inconsistencies.
• Customizations using oracle client extensions.
• 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 General Ledger, Accounts Payable modules, Accounts Receivable and cost management modules.
• Analysis, design and implementation of seamless integration between 3rd Parties’ General ledger, Purchasing and Work in Process.
• Assisting in developing and testing software applications.
• Provided Training & Conducted Practice & Additional Business Requirements sessions
• Supported production environments and users on a daily basis by responding to emergency requests
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems
Environment: Sun Solaris, GL, AP, AR, PO, INV, OM.
Client: Metalsa S. de R.L. (Heavy Trucks Business)
Industry: Automotive
Project: Oracle Applications 11i Implementation 11.5.9 Aug 04 to Feb 07
Role: Functional consultant
Description:
• Implementation of Oracle Applications 11i Ver 11.5.9 (AR,AP,OM and Cost Management)
• Testing modules’ setup for inconsistencies and missing steps-Test scripts and Users Acceptance Test (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
• Customizations using oracle client extensions and Oracle workflow builder.
• 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 Account Receivables, cost management, work in process and Accounts Payable modules..
• Assisting in developing and testing software applications
• Provided Training & Conducted Practice & Additional Business Requirements sessions
• Carrying out Users Acceptance Test (UAT), go-live activities and Post implementation support.
• Supported production environments and users on a daily basis by responding to emergency requests
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems
Environment: Sun Solaris, GL,AR,AP ,WIP, CM, OM..
Client: Metalsa S. de R. L. (Financial SBU)
Industry: Automotive
Project: Oracle Applications 11i Implementation 11.5.5 May 02 to Jul 04
Role: Functional Consultant
Description:
• Implementation of Financial modules (GL,AP, AR and PO) in a team
• Responsible for gathering user requirements, data conversions, customizations and testing.
• Suggesting the best practices in the industry in conjunction with local requirement.
• Tight and primary integration between various modules was extensively tested and verified. Unit, System, Integrated Testing for GL,AP, AR and PO modules during CRP1 and UAT
• General Ledger, Accounts Payable and Account Receivable and Purchasing Cycles Flow was thoroughly and extensively tested as part of ‘Accounting To Financial Reporting’ during CRP and UAT phases.
• Supporting daily operation for all Financial Modules
• Guiding for Customized Report, Interfaces etc
• Deliverables included need analysis, functional mapping, gap analysis, business process re-engineering, finding solutions, setup and prototyping & testing
• Provided Training & Conducted Practice & Additional Business Requirements sessions
• Carrying out Users Acceptance Test (UAT), go-live activities and Post implementation support.
• Defined Value Sets, Descriptive Flex fields, and Custom Profile Options
Environment: Sun Solaris, Modules: GL,AP,AR,PO,INV,OM.
Other Experience
COPAMEX Corporative offices Apr 98 - Oct 99
• Analysis and design of production planning ,shipping and logistic systems
• Develop audit programs , schedule and supervise audits
Cydsa Corporative Feb-98 – Abr-98
• Analysis and develop of Purchasing and Inventory in-house system.
• Develop of suplier management system.
• Implemetation and support of an in-house asset management system.
World Software Services Co. Aug-96 – Mar-97
• Analysis and develop of in-house systems for Industias ALEn S.A de C.V. using Progress V8 software.
• Analysis and develop of in-house systems for Valenciana de Cementos in Madrid Spain.
•
Consultoria en Informatica Ejecutiva S.A de C.V Jul-94 – Aug-96
• Analysis and design of in-house systems (Progress v6 and v7.5)
Education
• Lic. En Ciencias Computacionales, Facultad de Ciencias Fisico Matematicas ,Universidad Autónoma de Nuevo León 1994.
• Oracle PL/SQL course, Facultad de Fisico-Matematicas.
Member number:10314
Additional Contact information is available on the Information Page.
Software Contractors' Guild (www.scguild.com)
Copyright(c) 1995 - 2006 Mario Lopez and Software Contractors' Guild,
3 Country Club Dr., #303, Manchester, NH USA 03102