Executive Summary
•	9+ years of techno-functional experience supporting, implementing and customizing Oracle ERP applications, like:  MRP/MPS, APS (Advanced Planning and Schedule), INV, BOM, WIP, OM, Purchasing, GL and Receivables.
•	6.5+ years total experience as Techno-Functional Project Leader for implementing Oracle MRP/MPS in Alcoa AEES and for customizing MRP/MPS in GEAE (General Electric Aircraft Engines).
•	Excellent knowledge of Oracle Planning modules (MPS/MRP).
•	Very strong knowledge of Oracle Standard Interfaces for:   Inventory Items, Forecast and Demand.
•	Very strong in using Oracle Applications foundation: System Administration (Users, Responsibilities, Menus, Functions), Profiles, Concurrent Programs and Executables, reports in XML format for Excel (spreadsheets with format) directly from Oracle Applications  (no need for reporting 3rd. party or extra tool).
•	In process of getting Oracle Certification: Oracle E-Business Suite 11i Supply Chain certified Professional Consultant.
•	Process Improvement thru the use of Six Sigma DMAIC Methodology to reduce costs and cycle times.
•	Country experience including USA, Honduras and Mexico.
•	Excellent communication, team building and project management skills.


Skills Summary
•	Oracle Applications Modules: MRP/MPS, APS (Advanced Planning and Schedule), INV, BOM, WIP, OM, WMS, Purchasing, GL and Receivables.
•	Oracle Applications Releases: 11.0.3 and 11.5.10.
•	Functional Tools:   Applications Desktop Integrator (ADI), Financials Statement Generator (FSG), Data Load, Web Intelligence / Business Objects.
•	Technical Tools:   Forms, Reports, SQL*Plus, TOAD, AppWorx.
•	Languages: SQL, PL/SQL, Visual Basic, Delphi.
•	Methodologies & Documents: Oracle’s Applications Implementation Methodology (AIM), Oracle documents including: BP040, BP060, BP070, BP080, RD050, BR010, BR030, BR100, BR110, MD040, MD050, MD060, MD070.
•	Productivity Applications: MS Office, MS Visio and MS Project, MS Office


Oracle Apps Skills and Tools
•	Analyze current business processes, design future business flows, perform business requirements mapping, and identify gaps, impact, workarounds and reporting needs.
•	Design Oracle Applications Manufacturing Planning structure and process for single and multiple orgs.
•	Design, Development, Proof of Concept and Implementation of:   Forms, Reports, Triggers, Stored Procedures, Packages, Scripts, Menus, Responsibilities, Profiles, Concurrent Programs, etc. to customize the application based on the requirements.
•	Testing modules (unit and integration testing) and perform User Acceptance Tests (UAT).
•	Log, view, access, monitor, follow-up and close Technical Assistance Requests (TARs) online -Oracle MetaLink.
•	Setup Oracle MRP/MPS, APS (Advanced Planning and Schedule), INV, BOM, WIP, OM, Purchasing and GL.
•	Train users and generate training documentation.
•	Work actively with the IT department (specially DBA’s) to solve issues with Oracle Applications.
 
Oracle Applications Project Experience

Client:	ALCOA AEES
Locations:	San Antonio, TX, USA
	various cities in Mexico
	San Pedro Sula, Honduras
Industry:	Automotive Harnesses
Description:	ALCOA AEES is an organization dedicated to the manufacture and supply of electrical harnesses for the auto industry for customers like Ford, GM, Volkswagen, Toyota, Polaris, Freightliner and others.


Jun 2007 to Present
Project:	Oracle Applications, MRP/MPS 11i (11.5.10) implementation
Description:	Implementation of the Oracle Applications MPS/MRP modules for production planning.
Role:	Techno-Functional Project Leader.

•	Implementation of Oracle Applications MRP/MPS modules ver 11.5.10.
•	Integration with Oracle EDI SO’s and Forecasts to get a consolidated demand picture.
•	Design customizations to fulfill the requirements and provide the best approach.
•	Test modules (unit and integration tests) and perform User Acceptance Tests (UAT).
•	Log, view, access, monitor, follow-up and close Technical Assistance Requests (TARs) online - Oracle MetaLink.
•	Development of custom Reports in XML format for Excel (spreadsheets with format) directly from Oracle Applications (no need for reporting 3rd. party or extra tool).
•	Analyze current business processes, design future business flows, perform business requirements mapping, and identify gaps, impact, workarounds and reporting needs to meet the business needs of the company.
•	Provided end user training, conducted user practice and additional business requirements sessions.
•	Carrying out Users Acceptance Test (UAT), go-live activities and Post implementation support.
•	Analyzing user needs, conferring with users to improve procedures and identifying and solving problems.
•	Reporting the project status to responsible managers on a daily and weekly basis. Daily tasks included attending meeting with other team managers; also trained users understand different application modules

Environment: 	Solaris, Unix, Oracle Modules: MRP/MPS, INV, BOM, WIP, PO, EDI.
Tools:	Oracle Forms, Reports, PL/SQL, TOAD, XML for Excel, Microsoft Project, Microsoft Visio, Microsoft Office

 

Client:	GEAE (General Electric Aircraft Engines)
Locations:	Cincinnati, OH, USA
	Aguascalientes, Mexico
Industry:	Aircraft Engines (commercial and military turbines)
Description:	GEAE is an organization or the General Electric Group dedicated to the manufacture and supply of turbines for commercial and military aircrafts.


Jun 2004 to Jun 2007
Project:	Oracle Applications, MRP/MPS 11i (11.5.10) implementation and customization
Description:	Implementation and customization of the Oracle Applications MPS/MRP modules for production planning.
Role:	Techno-Functional Project Leader.

•	Implementation of MRP/MPS functionality to perform customized planning for specialized turbines and modules
•	Responsible for gathering user requirements, design solution, development, assigning work schedules and deliverables to developers, and testing.
•	Modules setup (MRP/MPS, INV), configuration and implementation involved all the mandatory and optional steps.
•	Reporting the project status to responsible managers on a daily and weekly basis. Daily tasks included attending meeting with other team managers; also trained users understand different application modules
•	Supported production environments and users on a daily basis by responding to emergency requests 
•	Deliverables included need analysis, functional mapping, gap analysis, business process re-engineering, finding solutions, setup and prototyping & testing

Environment:	Solaris, Unix, Oracle Modules: MRP/MPS, APS (Advanced Planning and Scheduling), INV.
Tools:	AppWorx, HP Service Desk (HP Open View), Oracle Forms, Reports, PL/SQL, TOAD, Microsoft Project, Microsoft Office



Apr 2002 to Jun 2004
Project:	Techno-Functional Support and enhancements of Oracle Manufacturing Applications (APS, INV, BOM, WIP, Engineering) 11i (11.5.10), and interfaces to legacy systems.
Description:	Provide Functional and Technical support to users of the Oracle Manufacturing Applications and develop enhancements and minor customizations.
Role:	Oracle System Analyst Sr.

•	Impact analysis, design, development, implementation, testing, user training, management reporting, process improvement, Green Belt coaching, techno-functional mentoring.
•	Solve application issues, fix application bugs, production support, job monitoring, enhancements.
•	Process improvement using Six Sigma methodology to reduce cycle time and quality of the IT processes for supporting day to day and month-end processes.
•	User requirements gathering, design solution, development and testing.
•	Reporting the project status to responsible managers on a daily and weekly basis. Daily tasks included attending meeting with other team managers.
•	Supported production environments and users on a daily basis by responding to emergency requests  (24x7)
•	Developed Forms, Reports, Triggers, Stored Procedures, Packages, Scripts, Menus, Responsibilities, Profiles, Concurrent Programs, etc. to customize the application based on the requirements.
•	Monitor Oracle APS Netchange overnight to load back and forth data from Oracle Manufacturing Applications to Oracle APS (where consolidated Planning is performed for multiple sites/orgs)
•	Log, view, access, monitor, follow-up and close Technical Assistance Requests (TARs) online -Oracle MetaLink.

Environment: Solaris, Unix, Oracle Modules: MRP/MPS, APS (Advanced Planning and Schedule), INV, BOM, WIP, Engineering, OM, Purchasing.
Tools:	AppWorx, HP Service Desk (HP Open View), Oracle Forms, Reports, PL/SQL, TOAD, Microsoft Project, Microsoft Office




 

Other Experience

May 2000 to Mar 2002
Client:	GE Capital (General Electric division)
Locations:	Stamford, CT, USA and Aguascalientes, MEXICO
Industry:	Financials
Project:	Worldwide Oracle HR Helpdesk
Position:	QA and Process Improvement Leader
	2nd. level support (Sr. Oracle Application Specialist)

•	The “Worldwide Oracle HR Helpdesk” provided functional and technical support to HR Users worldwide (US, Hawaii, Puerto Rico, Canada, Brazil, Mexico, UK, Spain, France).
•	Coordinate and/or perform mass data loads to Oracle HR (Human Resources) application.
•	Perform security/access audits.
•	Modify user accounts and security profiles as necessary.
•	Modify and create responsibilities to match security profiles and roles.
•	Be the single point of contact to the users to fix all issues coordinating with other teams to resolve issues out of our hands.
•	Train users in the use of the system.
•	Edit periodical issues to keep the users community informed of new functionality, changes in process, and tips and tricks.
•	Developed custom reports to users in Webi (Business Objects) reporting tool.


Jan to May 2000
Client:	GE Ddemesis (General Electric division)
Locations:	Aguascalientes, MEXICO
Industry:	IT Consulting
Project:	Oracle GL (General Ledger) Implementation
Position:	Oracle Applications Analyst

•	Requirements gathering.
•	Setups: create COA (Chart of Accounts), create and enable SOB (Set of Books), Calendar and Currencies (multiple), enable Dynamic Entry of new accounts, enable multi-companies.
•	Perform and coordinate Data Loads.
•	Modify and create reports using FSG (Financial Statement Generator).
•	Use ADI (Application Desktop Integrator) to enter data and export corporate reports to the web.
•	Train users and provide day-to-day support.


Aug 1999 to Jan 2000 
Client:	GE Capital - Card Services (General Electric division)
Locations:	Atlanta, GA, USA USA  ●  Stamford, CT, USA  ●  Aguascalientes, MEXICO
Industry:	Financials
Project:	Oracle AR (Account Receivables) Implementation
Position:	Oracle Applications Developer

•	Implementation Oracle AR for handling credit card management for SAMS Club and Home Depot customers.
•	Requirements gathering.
•	Development of reports using Oracle Reports.
•	User training.
•	Documentation.


 

Education
•	Master in IT and Computer Technologies			1999
Universidad Autonoma de Aguascalientes (Mexico)



Certifications and Continuing Education
•	In process of getting Oracle Certification:
Oracle E-Business Suite 11i Supply Chain certified Professional Consultant
(Already presented and passed 1 of 3 exams to get the Oracle Certification)

•	Oracle Advanced Supply Chain Fundamentals		2007
by Oracle Corp., Mexico

•	Oracle OM (Order Management)				2006
by Oracle Corp., Mexico

•	Oracle Warehouse Management Fundamentals		2006
by Oracle Corp., Mexico

•	Certified Six Sigma Green Belt				2003
by General Electric Company

•	Oracle MRP (Material Requirements Planning)		2003
by GEAE

•	Oracle INV (Inventory)						2002
by GEAE

•	Oracle Applications System Administrator			2000
by GE Ddemesis

•	Oracle GL (General Ledger)					2000
by GE Ddemesis

•	Oracle HR (Human Resources)				2000
by GE Capital and T&E

•	Oracle Developer (Forms and Reports)			1999
by GE Ddemesis

•	Oracle SQL and PL/SQL					1999
by GE Ddemesis