Gilberto Lombard - Oracle Financials Functional Consultant

 

Executive Summary
•	15+ years of experience in Information Technology Management and end-user support.
•	6+ years of functional and setup experience in Oracle Applications (AR, INV, OM, QP, Advanced Collections and eBusiness TAX R12i). 
•	3+ years of systems security auditing and systems risk analysis, using COBIT standards and ISO-17799.
•	Strong in analysis, issues resolution, reports improvement and create new reports.
•	Easy adaptability to new technologies and new systems environments.
•	Excellent communications, good performance and experience working under pressure.
•	4+ years of experience as a systems functional consultant.
•	2+ years of experience in physical and logical systems security.
•	Leadership, analytical thinking, problem solving, and great communication skills.
•	Experience creating material training and providing training to end-users.

Skills Summary
•	Oracle Applications. Modules: AR, Inv, OM, QP, Advanced Collections for R12i, eBusiness TAX for R12i.
•	Oracle Applications. Releases: 10.7, 11.5.9, 11.5.10.2, 12i
•	Oracle Database. Releases: 7.5, 8 and 9i.
•	Languages:  SQL, PL/SQL.
•	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.
•	Capability Maturity Model Implementation (CMMI) methodology.
•	Productivity Applications: MS Office, MS Visio, and MS Project.
•	Systems Audit Standards: COBIT, and ISO 17799.

Oracle Apps Skills and Tools
•	Business Requirements Mapping for AR, INV, OM, QP, eBusiness TAX and Advanced Collections modules.
•	Designing Oracle Applications Financial and Operating structure of client organizations - Multi-Org Setup.
•	Logged, viewed, accessed, monitored, followed up, and closed Service Requests (SR) online - Oracle MetaLink.
•	Setup of Account Receivables, Inventory, Advanced Pricing, Order Management and eBusiness TAX and Advanced Collections.
•	Data migration from legacy systems - ADI and Open Interfaces.
•	Reports performance improvement in the modules AR, INV, and OM.
•	Designing and creation of new reports.
 
Oracle Applications Project Experience
Client: Grupo Comercio Siman, Barbados, BVI		
Industry: Retail.
Description: Grupo Comercio Siman is a group of Retail stores like Unicomer, Siman and Regal Forest Holding that have branches in Central America, USA and BVI.

Project: Oracle Applications Implementation 11i	Jun 08 to Jan 09
Role: Senior Functional Consultant
Description: After the fusion of Grupo Comercio Siman and Regal Forest Holding it was necessary design and creates a new intercompany model in the existing Oracle Applications setup y order to add the new 11 countries of the BVI where Regal Forest Holding has branches.

As Oracle EBS Consultant:
	Analyze and Design the new operating model for integration of new branches from 11 Caribbean countries.
	Create documents with all information regarding with implementation process of modules AR and Inv.
	Setup AR and Inv according the new operating model.
As Project Manager:
	Coordinate the activities of development team for new reports of implementation process.
	Report and coordinate activities with customer project manager.
As Trainer:
	Create material for training of key users.
	Give training of new operating model to key users of Receivables and inventory.

Environment: modules: AR & Inventory.

Client: Grupo HOMEX, Culiacan, Mexico		
Industry: Construction.
Description: Grupo HOMEX is one of the most important companies in Mexico in construction industry.

Project: Oracle Applications Implementation 12i	Apr 08 to Jun 08
Role: Senior Functional Consultant
Description: Design new intercompany transaction model in AR. Improve Collection process for intercompany transactions using new features of Advanced Collections 12iR and design a new model for Commercial Collections transaction.

As Oracle EBS Consultant:
	Analyze and Design the model for Receivables and collections for intercompany transactions as first wave of the Project.
	Just design the new model for intercompany transactions as first project wave with AR and Advanced Collections and for the second wave, let the model for commercial operation.
	Let ready the BR.100 setup document for eBusiness TAX R12i for AR R12i
	Let Ready the GAP analysis and BP.080 documents with at least 3 solutions with pro’s, cons and risk analysis of the model proposal.

Environment: Oracle On Demand, modules: AR, eBusiness TAX & Advanced Collections.


Client: Grupo Avante, Cancun, Mexico		
Industry: Wheels and Tires Sales.
Description: Grupo Avante is an enterprise that import and sale tires and wheels in north-west and south-west of Mexico.

Project: Oracle Applications Implementation R12i	Aug 07 to Apr 08
Role: Senior Functional Consultant
Description: Design and Implement OM with QP modules as POS system in 60 branches of Grupo Avante.

As Oracle EBS Consultant:
	Analyze and Design the new model for sales using Oracle EBS Order Management and Advanced Pricing in more than 60 branches.
	Install and setup the modules Order Management and Advanced Pricing.
	Create the documents with all the information regarding install, setup, unit test and future process model of the project.
As Project Leader:
	Coordinate and validate new developments of development team.
	Rise new requests from the customer regarding new reports or enhancements in Order Management Module.
	Coordinate meetings and discussion groups about new operation model with key users and customer project manager.
	Give support and help at the project manager of Interem in this project.
	Get the approval and signoff of the customer request regarding new reports or enhancements in to the system.
As Technician:
	Create technical request from customer with data mapping and some pl/sql queries as examples the way as the developer has to get the information regarding customer request.
	Perform unit test of the new developments and report changes or gap of them at my developer team.
As Trainer:
	Create training material in order to make the knowledge transfer to key users of Order Management and Advanced Pricing.
	Give the training at key user of Order Management and Advanced Pricing.
	Give support post production at key users.
	Make the knowledge transfer at IT customer area as the way to setup Order Management in order to make deploy of 55 branches.

Environment: Linux 4.5. Oracle Applications, modules: OM & QP.












Client: GE Nuclear Energy, Wilmington, NC		
Industry: Manufacturing
Description: GE Nuclear Energy is an enterprise that creates bundles for nuclear energy plants and exports their products around the world.

Project: Oracle Applications Rapid Start Implementation 11.5.10	Sep 06 to Aug 07
Role: Senior Functional Consultant
Description: Legacy Systems integration with Oracle 11i.

As Oracle EBS Consultant:
	Implementation and setup of OM, QP, AR, and Inventory.
	Play Moderator role between Oracle ERP Developers and Legacy Systems Consultants.
	Work with the Technical Leader during the integration process of Oracle ERP with the legacy systems.
	Provide support and knowledge transfer to team members regarding Oracle AIM and GE dPMM methodologies.
	Perform Program Manager Activities as Program Manager’s backup.
As Business Analyst:
	Analyze and Design the way to integrate Quality systems of GE Nuclear Energy with Oracle Quality working together with Third Party Consultant Company and keep the export control information.
	Coordinate and watch the activities of other 2 business analyst Jr. making the peer review of their documents and help them with customer meetings in order to help them to get the main information about customer activities using the Quality Systems of GE Nuclear Energy for Oracle Quality Integration.
	Report and create documents regarding legacy systems integration project.
	Help Operational Leader in some administrative activities and reports of the project.
	Review with third party Oracle team the model to be implemented in order to find the way to make the integration with GE Nuclear Energy Quality Legacy Systems integrations and give the information at the other Business Analyst Jr.
	Help to create the documents of testing scenarios of legacy system integration with Oracle Quality.
As Technical Project Leader:
	Rise Technical documents regarding the legacy systems integrations keeping the GENE rules for this activities and review the technical documents of the other 2 Business Analyst Jr.
	Coordinate the activities with the customer in order to create system testing environments and tested for integration process.
	Validate and coordinate developer team for GENE Quality Legacy System enhancements.
	Watch and review the documents update of the new changes or enhancements of the legacy systems.
	Coordinate and participate in unit testing of new enhancements before to make the user acceptance testing.
	Coordinate deploy activities of the new versions of the legacy systems with third party Oracle Consultants teams.

Environment: Unix True 64. Oracle Applications, modules: OM, QP, AR and INV.



Client: GE Aviation, Houston, TX		
Industry: Manufacturing
Description: GE Aviation is the world’s leading producer of large and small jet engines for commercial and military aircraft. They also supply aircraft-derived engines for marine applications and provide aviation services. 

Project: Oracle Applications Rapid Start Implementation 11.5.10	Jun 06 to Sep 06
Role: Senior Functional/Technical Consultant
Description: Design and creation of 9 new interfaces regarding Inventory transactions of the Holland branch, in order to deliver special reports for the Netherlands’ government.
As Oracle EBS Consultant:
	Review Customer necessities regarding a new 11 interfaces in order to get information of Inventory transactions for specific Holland government request.
	Create the future process model document in order to share with Third Party Company that will create the reports the way as the information will be retrieved from Oracle Inventory for Holland Government Reports request.
	Setup and readiness of Oracle Inventory, working with the group of developers in the definition of technical specifications, so they could create the 9 new interfaces to get inventory transactions information, transforming that information into a staging table as defined in the business requirement.
	Apply the knowledge of Oracle AIM Methodology in order to understand the MD200 document.
	Knowledge transfer, couching, and mentoring of other consultants.
As Technical Leader.
	Create the data mapping document and PL/SQL code to be used for 11 inventory transaction interfaces.
	Coordinate the activities of developer assignment and validate the code of the new 11 interfaces.
	Perform unit testing and report gaps or issues at my developer assignment.
	Perform unit testing with Third Party Company and get the approval/signoff of the customer.

Environment: Unix True 64. Oracle Applications, modules: INV.

Client: Universal Productora, Cholula, Mexico		
Industry: Manufacturing
Description: Universal Productora (ZUUM) is a company that manufactures cotton products like applicators, swabs, pads, and different products for hospitals and drug stores. Also provide antiseptic products based on alcohol.

Project: Oracle Applications Rapid Start Implementation 11.5.9	Feb 05 to May 06
Role: Sr. Functional Consultant
Description: Implementation of Rapid Start configuration of Oracle Financials 11i.
As Oracle EBS Consultant:
	Analyze and Design the new operation model using Order Management, Advanced Pricing and Account Receivables for sales and receivables activities of the company.
	Create future process model document as result of analyze and design approved by the key user.
	Create setup documents of the new model.
	Perform 1 user unit testing and 2 global operational testing with the key users involved into the project.
As Technical Leader:
	Create technical documents of the request for new reports and enhancements of Account Receivables and Order Management, making the data mapping and analyzing the customer request and necessities.
	Create PL/SQL source code for those requests.
	Coordinate and validate developer activities and perform unit testing of the new developments.
	Report issues and changes regarding those developments.
	Get the approval/signoff of the customer.

Environment: Linux 3AE. Oracle Applications, modules: AR, OM, QP.

Client: Grupo Vianney, Aguascalientes Mexico		
Industry: Textile
Description: Grupo Vianney is a strong player in the home textiles market. Their products include bedding sets, comforters, towels, and bathing sets. The organization has a group of factories that provide different products to the domestic, Canada, and US markets. 

Project: Oracle Applications 11i Implementation 11.5.10	Nov 03 to Jan 05
Role: Oracle Functional Consultant
Description: Implementation of Oracle Financials 11i, and Open Interface set up in order to integrate the legacy systems.
As Oracle EBS Consultant:
	Analyze and Design the way to implement the modules of Account Receivables and Inventory, considering that the company will continued using their legacy systems.
	Create the future process model with the new model and integration process.
	Create scenarios for unit testing of the new operating model.
	Create the documents with the setup and testing scenarios.
As Technical Leader:
	Analyze the way as the legacy systems of the company works with customer developers.
	Create technical documents for interfaces integrations of Purchasing, Account Receivables, Inventory and General Ledger modules.
	Add PL/SQL source code for those integrations.
	Coordinate and validate the development team activities.
	Perform unit testing of the integration programs.
	Perform the user unit testing and report issues at development team.
	Get the approval/signoff of the developments.

Environment: Linux 3AE. Oracle Applications, modules: AR, and INV.









Client: La Curacao, Leon, Mexico		
Industry: Retail
Description: La Curacao is a retail organization specialized in electronics, white line and appliances retail sales, with 35 stores, four distribution centers, and three service centers.

Project: Oracle Applications Implementation ver.10.7	Jun 01 to Oct 03
Role: Oracle Functional Consultant
Description: Implementation of the financial modules and development of a new point of sale system.
As Oracle EBS Consultant:
	Start the training in order to get the knowledge to manage the Account Receivables and Inventory Modules of Oracle R10.7
	Give Functional Support at receivables and inventory users.
	Take the manage and control of POS integrated with Oracle EBS R10.7
	Report Issues and proposal of new enhancements of POS system at development team of Curaçao,
	Give functional support at end users of POS system.
As IT Manager:
	Coordinate the activities of 2 functional consultants and Technical support.
	Help in rollout process for southeast stores in Mexico of la Curaçao.
	Share implementation experience in meetings with other IT Managers from Guatemala, Honduras, El Salvador, Argentina and Miami.

Environment: Unix Sun Solaris. Oracle Applications, modules: AR, INV, and POS


 
Other Experience

Sofftek, Aguascalientes, Mexico.  I.T. Sponsor	May 00 – Jun 01

•	Network maintenance and performance improvement tasks.
•	Management and administration of the PBX.
•	Provided support to local users.
•	First contact with the IT providers, and responsible to evaluate and take actions to improve the network and telecommunications.
•	Worked like a Help Desk in order to solve problems with the access to the systems in different business of G.E. like Commercial Finance, Vendor Finance Services and Costumer Finance Services, always keeping the security and working with the G.E. security systems politics.


Banco del Bajio, Leon, Mexico.  Internal System Auditor	Oct 98 - May 00

•	Create a new area to audit internal systems.
•	Implementation of a risk analysis and vulnerability methodology for the LAN, WAN, and Internet access.
•	Document all system areas processes, and created scripts to keep the risk low in different systems, areas, and processes.
•	Implementation of control rules, helping with COBIT and ISO 17799 standards.
•	Analyze and avoid hacking attacks and reported them to the authorities.
•	Analyze and designed tools to improve the timing of internal audits.



Education
•	Computer Systems Engineer, University of La Salle Bajio, Leon, Guanajuato, Mexico, 1993
•	Diploma in Manager Abilities, Instituto Tecnologico de Estudios Superiores de Monterrey (ITESM) campus Leon, Guanajuato Mexico, 2002



Certifications and Continuing Education
•	Oracle Implementation Champion for Order to Cash, January 2009 (Renewed).
•	Oracle E-Business Suite R12 Financials PreSales Champion, January 2009.
•	Oracle Warehouse Management System, August 2006








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