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