Francis A. Email & Phone Number

San Diego, Ca, Us

Marlborough, Ma, Us

Marlborough, Ma, Us

• Supported the United States commercial business requirements using the following EBS modules: order management, advanced pricing, shipping, service contract, and installed base.• Core team member that upgraded EBS to 12.2.10.

San Diego, California, Us

• Responsible for leading the functional / technical staff, and working closely with stakeholders to design effective solutions by leveraging on standard ERP functionality for new initiatives and for sustaining support needs.• Toughen Oracle-stack servers’ security using Sophos for malware, ransomware, and virus protection; Alert Logic to manage/alert detection and response (MDR) against breaches and threats.• Drafted change management policies to streamline introductions of new software, processes, and systems: Navisite EBS migration and clone hosting, Avalara tax system and returns, multiprotocol label switching (MPLS) / virtual private networks (VPN) redundant connection between TIG and Navisite, and PCI compliant Fiserv systems.• Designed Oracle-stack backup and data retention policies, including a disaster recovery (DR) solution with a 24-hour recovery time objective (RTO; time to restore the application) and a 4-hour recovery point (RPO; amount of data that can be lost).• Wrote standards for application development (PL/SQL standards, software development life cycle (SDLC) development method, Oracle Business Intelligence (OBI) report publisher and analysis standards, star schema standards, application development foundation (ADF) development standards, server standards (includes server setup, EBS instance & cloning standards, network standards), OBIEE administration (shutdown, restart, user maintenance) standards, WLS administration, and ODI administration standards.• Created business proposals related to software initiatives (business efficiency / process improvements, and technology upgrades) and presented them to Senior Management. Streamlined Oracle EBS modules by simplifying setups, security, and business process procedures for the following: order to cash, procure to pay, inventory and time / labor.

Dallas, Tx, Us

• Implemented the supplier payment processing via ACH (Automated Clearing House) using CCD Plus with Wells Fargo Bank.• Implemented an inbound ASN (Advanced Shipping Notice) EDI to improve the procurement communication and accuracy. PO (ANSI X12 850) transactions are sent initially to suppliers. ASN (ANSI X12 856) are received from suppliers prior to shipments to DJO. Subsequent Application Advice (ANSI X12 824) are sent to the supplier for any errors encountered in the ASN process.• Documented period end VAT reporting procedures for Italy; documented iStore business procedures using Oracle User Productivity Kit (UPK).

• 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 (http://www.prevueonline.net/visionaryawards/nominee-san-diego/) 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.

San Diego, Ca, Us

• Solely provide daily and period end support of 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, Ca, Us

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.

El Segundo, Ca, Us

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.

San Diego, Ca, Us

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.

Burbank, Ca, Us

Successfully implemented 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.

Bedford, Ma, Us

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).

San Diego, Ca, Us

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.”

Mission Viejo, California, Us

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.

Costa Mesa, Ca, Us

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, and Shipping Execution.

St Augustine, Florida, Us

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.

Minot, Nd, Us

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.”

Reston, Virginia, Us

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.

Denver, Colorado, Us

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.

Chicago, Illinois, Us

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.

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.

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.

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.