Alejandro Solano - Oracle Functional Distribution and Procurement Consultant

 


Executive Summary
•	15 years of experience related to Information Technology and 5+ years of experience as Oracle functional consultant.
•	Professional with two Bachelor of Science degrees, one in Industrial Engineer and another in Computer Science. This background allows a wide understanding of Oracle Applications from both perspectives: functional (business processes) and technical.
•	Completed 4 live Oracle Applications full life cycle implementation projects.
•	Strong knowledge and experience in Procure to Pay, Order to Cash and Financials business flows.
•	Experience in Oracle Complex Maintenance Repair and Overhaul (Aircraft maintenance).
•	Experience included 3 Inventory implementations, 1 in Account Payables, 2 in Order Management and Warehouse Shipping, and 1 in CMRO.
•	Handling of Key Performance Indicators (KPIs) using Oracle Daily Business Intelligence.
•	Excellent communication, team building and team leader skills.

Skills Summary
•	Strong experience and knowledge in : INV, PO, AP, OM, Shipping, BOM, WIP and cMRO
•	Knowledge in the modules: GL, CE
•	Oracle Application Releases: 11.5.10 and 12.0
•	Tools:  Discoverer, DBI, Toad, OBM, Metalink.
•	Languages: Basic SQL
•	Team work with Key Users, Leaders, Developers, and Project Managers.
•	Wide communication with the customer
•	Methodologies & Documents: Oracle’s Applications Implementation Methodology (AIM), Oracle documents including: RD020, BP080, BR100, BR110, BR120, MD050, BF125, BF015, CV050 BF120, T040 and UAT.
•	Productivity Applications: MS Office, MS Project. 

Oracle Apps Skills and Tools
•	Study of current business processes, future business flows and identification of gaps and workaround.
•	Business Requirements Mapping for INV, PO, AP, OM, WSH and CMRO modules.
•	Designing Oracle Applications Inventory and Operating structure of client organizations - Multi-Org Setup.
•	Setup of Inventory, Purchasing, Account Payables, Order Management and Warehouse Shipping.
•	Oracle DBI: Use of Inventory, Purchasing and Order Management KPI’s 
•	Data Migration from Legacy systems using API’s and Open Interfaces.
•	Customization of functional designs.
•	Functional design of Discoverer Business Areas 
•	Preparation and execution of Conference Room Pilots (CRPs) as well as final users training
•	Testing modules’ setup for inconsistencies and missing steps - Test scripts and User Acceptance Tests (UAT).
•	Log, view, access, monitor, follow-up and close Service Requests (SRs) online - Oracle MetaLink and Oracle Applications Patch Management.
•	Working according to Oracle On Demand Policies.


Oracle Applications Project Experience
Client: Xerox Mexicana, Mexico City, Mexico	
Industry: Document Company
Description: Xerox Mexicana belongs Xerox Corporate US, is the biggest company in offices products and supplies.

Project: New Business Flows implementation.	Nov 08 to Present
Description: Implementation of FA, IB, Service Contract, Field Service, Quoting
Role: Senior Functional Consultant.

•	Inventory Implementation for the new Business Processes
•	OM and Shipping Support 
•	WIP and BOM Support
•	Prepare functional designs, test scenarios, BR100 and BR120 documents
•	Team work with key users, functional manager, project managers, developers  and TI users. Mexico, India and USA
•	Remote team work India and USA

Project: Distribution Business Process.	Jul 08 to Nov 08
Description: Implementation of the new Distribution Business Process 
Role: Senior Functional Consultant.

•	Design New Supplies Distribution Business Process According with the new business requirements and policies
•	Setup update in modules OM, INV, PO, AP and AR according with the new business process
•	Implementation of Drop Shipment process as part of the complete solution
•	Prepare functional designs, test scenarios, BR100 documents
•	Test whole process Supplies Distribution Business Process
•	Team work with key users, functional manager, project managers, developers  and TI users. Mexico and USA
•	Assistance to developers in India and USA. Testing customizations



Client: Mexicana de Aviacion, Mexico City, Mexico	
Industry: Airline
Description: Mexicana de Aviacion is one of the most important airlines in Mexico. The companies in this business group provide commercial flights and Aircraft Care (Maintenance, Repair and Overhaul services) to their aircrafts and third party aircrafts. They own offices in USA, Latin America, Europe, Canada, and Asia.

Project: Oracle Applications Release 12.	May 07 to Jun08
Description: Full Cycle Oracle Applications Implementation, including HR, Financials, SCM and CMRO (Complex Maintenance Repair and Overhaul). 
Role: Senior Functional Consultant.

•	Follow up to Engineering in the CMRO module. (Strong knowledge in Document Index, Routes Management and Fleet Maintenance Program) 
•	Implementation of Outside Service Processing in cMRO (Repair, Exchange, Borrow and Loan Processes). Implementation of Oracle OM and its integration with Install Base.
•	Knowledge of Configuration, Planning and Execution in cMRO module
•	Conference Room Pilot (CRP1, CRP2, CRP3) execution according with Oracle’s AIM
•	Study of current business processes, future business flow & identification of gaps and workarounds in order to provide integrated business flows.
•	Functional Design of Discoverer Business Areas.
•	OM, WSH and OSP setup, configuration and implementation involved all the mandatory and optional steps. Implementation is pointed to extract the maximum benefit available in the Oracle Applications functionality.
•	Define user responsibilities, set up custom menus and request sets based on user responsibilities
•	Working according to On Demand policies.
•	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 - API and Open Interfaces.
•	Responsible for gathering user requirements, functional design, assistance to developers and testing customizations.
•	Deliverables included User Acceptance Tests (UAT), need analysis, functional mapping, gap analysis, finding solutions, setup and prototyping & testing, based on Oracle’s AIM.
•	Wide analysis of the modules’ functionality in order to avoid gaps. All of them were handled with customizations when the functional solutions or workarounds were not available.
•	Analyzing user needs, conferring with users to improve procedures and identifying and solving problems
•	Working with Oracle University in order to propose the content of the end-user training manuals.

Environment: Windows XP, Modules: OM, CMRO, Tools: Discoverer


Client: PEMEX Petroquimica, Coatzacoalcos, Mexico		
Industry: Petrochemical
Description: Pemex Petroquimica is the largest petrochemical industry in Mexico. It is a government enterprise dedicated to manufacture, market and distribute petrochemicals for national and international markets. Pemex Petroqumica has 8 manufacturing plants and a large number of distribution centers in Mexico.

Project: Oracle Applications 11i Implementation 11.5.10	Aug 06 to May 07
Description: Implementation of HR, Procure to Pay, Order to Cash, and Accounting to Financials Reports business flows.
Role: Senior Functional Consultant

•	Implementation of Oracle Inventory (and assistance in WSH) in the Procure to Pay and Order to Cash business flows.
•	Team work with OM, WSH, INV key users and consultants in order to design inventory organizations structure according with the business group (distribution centers, branches, warehouses).
•	Analysis, design and implementation of seamless integration between 3rd Party Maintenance Software with Oracle Inventory.
•	Log, view, access, monitor, follow-up and close Service Requests (SRs) online - Oracle MetaLink and Oracle Applications Patch Management.
•	Data migration from Legacy systems - APIs and Open Interfaces.
•	Study of current business processes, future business flows and identification of gaps and workarounds in order to provide the best solution in Inventory Management.
•	Business Requirements Mapping for Inventory.
•	Prepare End User Guides and provided training to the end users.
•	Go-live activities and post-implementation support. Supported production environments and users on a daily basis by responding to emergency requests
•	Responsible for gathering user requirements, functional design, assistance to developers and testing customizations.
•	Inventory setup, configuration and implementation involving all the mandatory and optional steps. Implementation is pointed to extract the maximum benefit available in the Oracle Applications Functionality, and all the gap was handled with customizations when the functional solutions were not available.
•	Deliverables included need analysis, functional mapping, gap analysis, finding solutions, setup and testing.
•	Integration between WSH and INV modules was extensively tested and verified before go live.
•	Use of Oracle DBI in order to show and analyze how to use and interpret Inventory KPI’s
•	Implementation of some inventory management tools like Cycle Counting, Physical Inventory ABC Analysis, Max-Min Planning.
•	Defined Value Sets, Descriptive FlexFields, and Custom Profile Options.
•	Define user responsibilities, set up custom menus and request sets based on user responsibilities.

Environment: Windows NT, Modules: INV and WSH, Tools: Discoverer, DBI.

Client: Aeropuertos del Sureste, Cancun, Mexico		
Industry: Airport Management
Description: ASUR administers and operates approximately 9 of the principal airports in the southeast of Mexico, some of them are Cancun, Cozumel, Merida. Their income is based on fees from passenger traffic and the use of commercial spaces.

Project: Oracle Applications 11i Implementation 11.5.10	Jun 06 to Aug 06
Description: Oracle Applications 11i Implementation of Procure to Pay and Treasury business flows. 
Role: Senior Consultant

•	Implementation of Oracle Account Payables (AP) ver 11.5.10 and its integration with PO, CE and GL.
•	Study of current business processes, future business flows and identification of gaps and workarounds in order to provide an integrated Procure to Pay business flow to meet the business needs of the company.
•	Conference Room Pilot (CRP1, CRP2, CRP3) execution according with Oracle’s AIM.
•	Log, view, access, monitor, follow-up and close Service Requests (SRs) online - Oracle MetaLink and Oracle Applications Patch Management.
•	Budget control was used in AP implementation.
•	Prepare an integral Accounting Close Cycle procedure including the standard reports to reconcile sub-ledgers (PO, AP, INV) with GL. Provide training in this topic to the key users.
•	AP integration with PO, CE and GL modules was extensively tested and verified (accounting and budget control) before go live.
•	Provide assistance to PO consultants during the implementation (business requirement mapping and setup for accounting and budget control).
•	Data migration from Legacy systems - APIs and Open Interfaces. Detailed mapping of legacy data elements, conversion and testing.
•	Business Requirements Mapping for Accounts Payable and Purchasing modules.
•	AP module setup, configuration and implementation involving all the mandatory and optional steps. Implementation is pointed to extract the maximum benefit available in the AP module functionality.
•	Deliverables according with Oracle’s AIM including need analysis, functional mapping, gap analysis, finding solutions, setup and prototyping & testing.
•	Wide analysis of the module functionality in order to avoid gaps. They were handled with customizations when the functional solutions or workarounds were not available.
•	Define user responsibilities, set up custom menus and request sets based on user responsibilities.
•	Provided training and conducted practice and additional business requirements sessions.

Environment: Windows XP, Modules: AP and PO.


Client: Tango Operadoras, Monterrey, Mexico		
Industry: Entertainment
Description: Tango Operadoras is a growth company dedicated to administer cash-paying slot machines clubs.

Project: Implementation of Oracle eBusiness Suite Special Edition (EBSE)	Feb 06 to May 06
Description: Implementation of Procure to Pay, Customer Invoice to Cash and Accounting to Financial Reports standard business flows.
Role: Team Leader

•	Team Leader for the implementation of Oracle EBSE modules GL, AP, PO, AR, FA and INV, with a team of 5 consultants.
•	Designing Oracle Applications Financial and Operating structure according with current client organizations and its growth expectations - Multi-Org Setup.
•	Reporting the project status to responsible managers on a daily and weekly basis. Daily tasks included attending meeting with other team manager; also understand different application modules.
•	Responsible assigning work schedules to consultants.
•	Implementation of standard EBSE business flows.
•	Define user responsibilities, set up custom menus based on user responsibilities.
•	Methodology: Rapid Start.

Environment: Windows XP, Modules: GL, AP, AR, PO, FA and INV.


Client: INTERMEX (Televisa Group), Mexico City, Mexico		
Industry: Media
Description: Intermex is the publications and magazines distribution network of Televisa business group, being a leader in Mexico and Latin America. In Mexico distributes more than 67% of the largest circulation magazines. It offers distribution, logistics, administration and marketing to take the product to the point of sale.

Project: Oracle Applications 11i Implementation 11.5.10	Jun 05 to Sep 05
Role: Sr. Consultant
Description: Oracle Applications 11i Implementation of Order to Cash (INV, OM, WSH, AR, Advanced Collections) and Procure to Pay business flows (PO, INV, AP).

•	Implementation of Oracle Inventory (INV) in Order to Cash business flow.
•	Business Requirements Mapping for INV and its integration with WSH, PO and GL modules.
•	Applications setup for INV module.
•	Data migration from Legacy systems - APIs and Open Interfaces. Detailed mapping of legacy data elements, conversion and testing.
•	Define user responsibilities, set up custom menus based on user responsibilities.
•	Study of current business processes, future business flow and identification of gap / workaround in order to provide an integrated order to cash business flow to meet the business needs of the group.
•	Liaison between the Key Users and Headquarters in order to understand corporate requirements.
•	Deliverables included need analysis, functional mapping, gap analysis, finding solutions, setup and prototyping & testing.
•	Methodology: R2I (Bearing Point methodology).
•	Data migration from Legacy systems - APIs and Open Interfaces.
•	Responsible for gathering user requirements, functional design, assistance to developers and testing customizations.
•	Wide analysis and functional design in customization about company’s inventory cost method.

Environment: Windows XP, Modules: INV


Client: TFM (Transportacion Ferroviaria Mexicana), Mexico City, Mexico		
Industry: Railway Transportation
Description: TFM is one of the four railway transportation companies in Mexico. They provide railway freight services and logistics management.

Project: Oracle Applications 11i Implementation 11.5.10	Oct 03 to Mar 05
Description: Oracle Applications 11i Implementation of Procure to Pay, Customer Invoice to Cash, Material Management and Accounting to Financials Reports business flows.
Role: Junior Consultant

•	Functional Consultant for the implementation of Oracle Material Management business flow (INV).
•	Study of current business processes, future business flows and identification of gaps and workarounds in order to provide an integrated Material Management business flow to meet the business needs of the company.
•	Conference Room Pilot (CRP1, CRP2, CRP3) execution according with Oracle’s AIM.
•	Because INV is not a MRC module it was necessary to analyze business requirements and design big customizations to solve this gap.
•	Log, view, access, monitor, follow-up and close Technical Assistance Requests (TARs) online - Oracle MetaLink and Oracle Applications Patch Management.
•	Working according to On Demand polices.
•	Working with Multiple Reporting Currencies (MRC).
•	Define user responsibilities, set up custom menus and request sets based on user responsibilities.
•	INV integration with PO and GL modules was extensively tested and verified before go live.
•	Data migration from Legacy systems - APIs and Open Interfaces.
•	Go-live activities and post-implementation support. Supported production environments and users on a daily basis by responding to emergency requests.
•	Business Requirements Mapping for Oracle Inventory.
•	Carrying out User Acceptance Tests (UAT).
•	Deliverables included need analysis, functional mapping, gap analysis, finding solutions, setup and prototyping & testing.
•	Methodology: Oracle’s AIM.
•	Inventory module setup, configuration and implementation involved all the mandatory and optional steps.
•	Implementation is pointed to extract the maximum benefit available in the INV module functionality
•	Prepared End User Guides and provided training to the end users.
•	Wide analysis of the module functionality in order to avoid gaps. Those gaps were handled with customizations when the functional solutions or workarounds were not available.
•	Responsible for gathering user requirements, functional design, assistance to developers and testing customizations.

Environment: Windows XP, Modules: INV.


 
Other Experience

Textiles Centenario, Puebla, Mexico	Industrial Engineer	Jan 98 – Mar 03

•	Responsible of Planning and Production Control department

Bonanza Textil, Puebla, Mexico	Computer Systems Engineer	May 91 - Oct 97

•	Design, development and maintenance of financials and manufacturing systems. 


Education
•	Industrial Engineer, Technological Institute of Puebla, Mexico				
•	Computer Engineer, University of Puebla, Mexico					


Certifications and Continuing Education
•	Negotiations, Karras Consulting, Oracle de Mexico
•	Financial Diploma, Americas University of Puebla, Mexico
•	Accounting Diploma, University of Puebla, Mexico




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