Solutions Architect / Applications System Manager

San Diego, California, United States

o Daily sustaining support of the following Oracle EBS release 12 modules: general ledger, accounts payable, account receivable, iExpense, order management, advance pricing, purchasing, inventory, depot repair, service request & contracts, projects, time and labor, bills of materials and work in process.o Installed, configured and documented the following business intelligence software: Oracle DBMS 12cR1, Oracle Data Integrator (ODI) 12cR2, ODI Java EE agent and Oracle Business Intelligence Enterprise Ed (OBIEE) 12cR2.o Developed ODI topology and document the following procedures: ODI metadata development (includes model folders, models, data stores, projects, mappings, packages, scenarios and load plans), ODI migration from the test instance to the production instance.o Developed OBIEE repository and documented the following procedures: OBIEE repository development, OBIEE repository migration from the test instance to the production instance.o Developed OBIEE analysis and documented the Analysis development guide.o Developed BI Publisher (BIP) reports and documented a development guide to include data model development, Excel template development, report development, BIP migration from the test instance to production.o Developed and documented the procedures in creating a data warehouse using a star schema architecture.o Installed and configured a GlassFish application server.o Developed web applications using the following Java stack: Maven, JavaServer Faces (JSF), PrimeFaces, CSS and XHTML.o Installed and configured Perforce (an enterprise version management system).  Wrote and implemented SDLC (systems development life cycle) using waterfall software development process, Perforce version management system, standard functional & technical development templates, and program development standards.o Implementing Oracle Time and Labor (OTL) to work with Oracle Projects (billable time entries) and HR (non-billable time entries).

Technology Integration Group

Application Systems Manager / Business Solutions Architect

For US sites, responsibilities include the daily support of the following modules: Order Management (OM), Inventory (INV), Purchasing (PO), iSupplier Portal, iProcurement, Trading Community Architecture (TCA) and Incentive Compensation (OIC).  For European sites (France, Italy and Spain), responsibilities include the daily support of the following modules: Accounts Payable (AP), Account Receivable (AR) and General Ledger (GL).

DJO Global

Business System Consultant

Designed and solely developed a hotel meeting bidding system for San Diego county hotels and resorts.  This web application called iLead won the 2013 Pillar Awards for San Diego.  Refer to the Prevue website (<a href="http://www.prevueonline.net/visionaryawards/nominee-san-diego/">http://www.prevueonline.net/visionaryawards/nominee-san-diego/</a>) which explains the system:The San Diego Tourism Authority listened to what meeting planners wanted and they delivered. Its innovative and highly successful iLead tool, specifically for single property meetings, allows its National Sales Directors to easily match specifications for any meeting or group that requires 10 or more sleeping rooms from among 125 hotels and resorts throughout San Diego County.The results are delivered in real time allowing meeting planners to get the information they need to make fast and accurate decisions for clients who want immediate answers.Furthering the interactive tool, San Diego hotels respond in real time using an electronic proposal template that includes a valuable list of the most important information with the planner's priorities listed first. The information is also linked to the original CVB lead, hotel websites, Google maps and the San Diego Tourism Authority digital meeting planner guide.

Prevue Magazine Award Winner

2013 Pillar Award Winner (iLead)

Solely provide daily and period end support the following modules: General Ledger (GL), Receivables (AR), Payables (AP), Cash Management (CM), Fixed Asset (FA), iExpense, Cost Management (CST), Inventory (INV), Order Management (OM), TeleSales (TCA), Purchasing (PO) and Marketing.Developed Java EE websites.

San Diego Tourism Authority

Oracle EBS Consultant

Successfully managed the selection and implementation of Oracle EBS (Release 12) from RFP stage to go-live.  Accomplishments include:*  Wrote a request for proposal (RFP) document that identifies the short-term and long-term business requirements of the company.*  Managed the bidding process and worked with senior management to select the EBS software supplier based on the RFP responses and software demonstrations.*  Defined the implementation plan to include the following stages and their deliverables*  Responsible for implementing Oracle Inventory, Order Management, Purchasing, TeleSales, Marketing and iExpense.

Project Manager

Successfully implemented an Oracle Applications (version 11.5.10) system for an infomercial company.Accomplishments:*  Responsible for implementing Oracle Inventory, Order Management and Oracle Cost Management.  This involved developing the following documents: Future State Design, Gap Analysis and Resolution, Setup Documents and Training Documents.*  Wrote functional requirements documentation for pricing and warehousing extensions.

Guthy - Renker

Supply Chain Consultant

Successfully supported, upgraded and implemented Oracle Applications for a Fortune 500 company who is also a member of the S&P 500 index.Accomplishments:*  Performed sustaining support for all the following implemented Oracle modules: Inventory, Purchasing, Receiving, Bills of Materials, Forecasting and Advanced Supply Chain Planning.*  Developed OracleBI Discoverer Reports for the Purchasing, Planning and Accounts Payable departments.*  Responsible for upgrading from 11.5.9 to 11.5.10 for the following modules:  Inventory, Bills of Material, Forecasting, Advanced Supply Chain Planning, Purchasing, Receiving and Quality.*  Wrote functional and technical documentation that satisfies SOX requirements.*  Enhanced Qualcomm's supplier owned inventory and quality applications.

Qualcomm

Oracle Procure To Pay Consultant

Successfully implementing Oracle Applications release 11i (11.5.9) from a custom legacy system for Aramark Uniform Services, a $1.4 billion division of Aramark Corporation (a $9 billion managed services provider of food, facility and uniform services).  Responsible for the following modules: Order Management, Shipping, Inventory, Cost, Purchasing, Receiving and Advanced Pricing.

Aramark Uniform Services

Successfully implemented Oracle Applications release 11i (11.5.9) from a legacy system for a biotechnology company dedicated to the Autoimmune Disease Diagnostic Technology.  Implementation involved the following Oracle modules: supply chain suite (INV, OM and PO) and manufacturing suite (WIP, BOM, Cost, Quality, and Planning).

Inova Diagnostics

Successfully implemented Oracle Applications release 11i (11.5.8) from a legacy system for a $130 million direct to consumer catalog company that sells apparels and accessories for running and walking.  In addition, the company sells via retail, internet and corporate owned retail store.  Implementation involved implementing a custom order management and accounts receivable, and also the following Oracle modules:  Inventory, Cost Management, Advanced Pricing, Marketing Online, Warehouse Management and Purchasing.*  Letter of recommendation states “We found Francis to be highly professional, skilled and efficient in putting solutions in place.  He worked well with the end users to fully define requirements and test solutions.  He clearly went beyond the norm to provide an optimal outcome for us, the end client.”*  Another letter of recommendation states “Many times Mr. Andres’ suggestions were radically different than what our ideas would have been.  He opened our eyes to a better way of designing the system so that we could capture the needed information and yet keep degradation of the system performance to a minimum… Mr. Andres was more than willing to go the extra mile to ensure that Road Runner Sports was delivered a product that not only met our current and short term future needs, but he also designed the system to accommodate future growth for the next decade.”

Road Runner Sports

Oracle Consultant

Successfully implemented Oracle Applications release 11i (11.5.6) from a legacy system for a worldwide open market electronic component distributor.  Implementation involved the following modules: Inventory, Cost Management, Order Management, Advanced Pricing, Shipping Execution, Purchasing, Purchasing Intelligence and TeleSales.

Advanced MP Technology

Effectively implemented Oracle Applications release 11i (11.5.6) from a custom, legacy system for a high-end, leading manufacturer of power amplifiers, signal processing, digital signal transport and computer control systems for the professional audio markets worldwide.  Implementation involved the following modules:  Advanced Planning and Scheduling (APS), Inventory, Cost Management, Engineering, Bills of Material, Order Management, Advanced Pricing, Shipping Execution.

QSC Audio Products LLC

Successfully implemented Oracle Applications release 11.0.3 from a legacy system for a configure-to-order, high-end furniture manufacturer.  Responsibility included implementing Inventory, Bills of Material, Purchasing/Receiving, Cost Management, Work in Process and MS/MRP.

Tropitone Furniture Company

Oracle Manufacturing Consultant

As a consultant for a wholesale petroleum products distributor, successfully implemented Oracle Applications release 10.7 SC from a legacy system, including Purchasing, Order Entry, Inventory, Cost Management and Receivables.  *  In addition, developed custom reports (including bill of lading, sales order acknowledgement, invoices and credit memo forms) in Oracle Reports 2.5, custom forms in Oracle Forms 4.5 and interface programs to meet business requirement specifications.  *  Letter of Recommendation stated “during the implementation of Oracle modules, he again showed a quick understanding and assessment of how Oracle could address our problems.  He came up with solutions that have worked for us…Francis was always patient with my staff.  He processed the information he heard very quickly.  He asked excellent questions.  He acted upon his solutions and always provided good results in a timely manner.  He adhered to a priorities list and set due dates.”

Farstad Oil Inc.

Oracle Functional/Technical Consultant

As a consultant for the US Department of Energy which is responsible for the operations and maintenance of the Nevada Test Site, successfully upgraded Oracle Purchasing, Inventory and Order Entry from release 10.4 character to 10.7 character. Accomplishments:*  Documented all set up steps that included key flexfields, descriptive flexfields, system profiles, alerts, user responsibilities and user menus.*  Developed user and training documents for the Procurement department. Trained users to understand Oracle Purchasing, Inventory and Order Entry, which included the purchasing cycle, internal requisition to internal order/shipping, Request for Quotation (RFQ), inventory replenishment and periodic item/purchasing purge process. Praised for "an ability to talk to the users at their level."*  Identified functional gaps between the business requirements and the software. Implemented the following prioritized, approved gaps: Procurement Date (flexibility to define the actual purchase order date), Request for Quotation (redesigned a new motif RFQ form), inventory replenishment and internal requisition to internal sales order process.*  Generated numerous user-friendly reports using Oracle Reports.*  Successfully supported users with their daily business activities.

Bechtel Corporation

Set up Oracle Engineering and Bills of Material for a major airline navigation provider. Additional responsibilities:*  Documented Oracle Engineering and Bills of Material set up steps.*  Trained users on Oracle Engineering and Bills of Material vanilla functions. *  Documented, analyzed and advised improvements on how to manage the end user tracking of airline navigation chart revisions.*  Created functional and technical specifications for an IBM legacy to Oracle Manufacturing item interface program.

Jeppesen

Revision Control Systems (RCS) Oracle Consultant

Matamoros Division, Matamoros, MexicoAs a project leader for Motorola’s cable and satellite communications division in their main service and repair facility, implemented Oracle Applications 10.7 character from a legacy system for the following modules: Purchasing, Inventory, Work in Process, Cost, Bills of Material and Engineering. Nogales Division, Nogales, MexicoSuccessfully implemented Oracle Applications (10.7 character) for the company’s main manufacturing facility.  Implemented modules included Oracle Master Scheduling/MRP, Purchasing, Inventory, Work in Process, Cost, Bills of Material and Engineering.San Diego Division, San Diego, CAAs a manufacturing and engineering track project lead in the company’s main satellite facility, implemented Oracle Applications 10.7 SC16.1 from a legacy system. Modules included Oracle Master Scheduling/MRP, Purchasing, Inventory, Work in Process, Cost, Bills of Material and Engineering.

Motorola

Manufacturing & Engineering Project Lead

Employed by a high-speed communications provider (which uses existing copper telephone lines) to design, develop and implement a contract-manufacturing enhancement to their installed Oracle Applications 10.5 character system:*  This system sent an EDI signal to the contract manufacturers based on Oracle Planning releases. During subassembly receipt through bar code from the contract manufacturers, the corresponding purchase order, work order, inventory and accounts payable transactions were updated. Upon payment of the contract manufacturer receipt, an EFT transaction was generated to the bank for automatic posting of contract manufacturing labor/material payments. An EDI transaction was also sent to the contract manufacturer to notify them of the subassembly receipt and bank payment. This automation attained a "$13 million yearly savings in component materials alone because the contract manufacturers now owned and maintained subassembly components." Users claimed "I delivered their 5 year old dream."*  Implemented an EDI system and bar code printing function in all of the contract manufacturer sites.*  Designed, developed and implemented PairGain bar code receiving using Intermec bar code printers and scanners.

PairGain Technologies Inc

Project Leader

Employed by a major oil refinery where I successfully designed, developed and implemented a Visual Basic and Access based Employee Training Tracking system that complied with the U.S. Environment Protection Agency guidelines.

Union Oil Company

Sr Systems Analyst

As an I.T. Manager, managed and provided I.T. support and development to AST Canada, United Kingdom and Ireland subsidiaries. Contributions included:* Designed, developed and implemented a distribution, A/R, A/P, F/A, G/L, credit, receiving, shipping, reconfiguration, purchasing and inventory management system in AST United Kingdom and AST Canada.* Automated the AST Canada system using Symbol Radio Frequency (RF) bar code readers in shipping, receiving, inventory management, cycle count and reconfiguration. Review stated, "this integrated system supported AST Canada’s 150% growth rate with a 15% decrease in warehouse staff."* Designed, developed and implemented a 3 site (Ireland, Canada and Texas) redundant radio frequency bar code system that included shipping, receiving, inventory management, reconfiguration, cycle count and physical inventory. Component part inventory count accuracy of 99% was achieved due to the radio frequency bar coded cycle count system.* Designed, developed and implemented a project tracking, forecasting, trade show tracking and data warehouse using the Oracle database and tools.* Designed and implemented an executive management tool that displayed net sales and inventory counts every minute.* Administered a company-wide Electronic Data Interchange (EDI) department that allowed for 40% of all new demand to be entered through the EDI system. Implemented 850 (new sales orders), 860 (change sales orders), 823 (lock box) and 810 (invoice) EDI transactions with strategic partners.* Proficient in creating entity-relationship database models using ERwin ERX.* Successfully served as a DBA to support Oracle, MS SQL Server, MS Access and Informix OnLine DSA 7.1 databases.* Supervised 17 direct reports to support AST subsidiaries plus AST USA domestic import, export, traffic, shipping and distribution departments.

Francis A.

Francis A.