Work Experience by Client

Click Picture to see my Favorite References:

Beatles

 

 

 

QEP Homelux – Ashbourne, UK   Jun 2013 – Present
  • New V10 PRMS Implementation, setup and configure PRMS, local hardware, user-training
  • Designed and developed a PHP/iSeries Scanning solution for Shipping, fully integtrated with PRMS
  • Designed and write VB.NET Sales Analysis App allowing multi-views of sales by customer/product attributes and date/fiscal period
  • Design/Write VB.Net app to Upload EXCEL AR Remittance to PRMS AR Remittance Batch processing applications.
  • Design/Write VB.Net app to print pro-forma Customer Invoices

 

QEP Roberts UK – Lytham-St.Anne, UK   Apr 2005 – Present
  • Convert a server-based ERP system to V9.2 PRMS Financial, Mfg, and Distribution.
  • Provide all training, data-conversion, PRMS environment setup, start-up and on-going support.
  • Follow-up implementation of Planning System, providing setup, training and startup.

 

QEP New Zealand – Auckland, NZL   Jun 2004 – Present
  • Convert PC-DOS system to V9.2 PRMS Financial, Mfg, and Distribution.
  • Provide all training, data-conversion, PRMS environment setup, start-up and on-going support.

 

QEP/Virtrx – Lytham-St.Anne, UK   Feb 2004 – Present
  • Convert AS400 ERP system to V9.2 PRMS Financial, Mfg, and Distribution.
  • Provide all training, data-conversion, PRMS environment setup, start-up and on-going support.
  • Implement new PRMS features for Drop Shipments, Auto-Create O/S Operation Purchase Orders, Blanket Purchase Orders and Intra-stat.
  • Write custom application using MS-Access with interface to AS/400 Accounts Payable for On-Line BACS Banking.
  • Follow-up implementation of Planning System, providing setup, training and startup.

 

QEP Australia – Melbourne and Sydney, AUS   Apr 2003 – Present
  • Convert PC-DOS system to V9.2 PRMS Multi-plant, Financial, Mfg, and Distribution
  • Provide all training, data-conversion, PRMS environment setup, start-up and on-going support.
  • Write custom Pricing Application using MS-Access with interface to PRMS Contracts and List Prices.
  • Customize PRMS setup for over-the-counter sales.

 

QEP, Inc. – Boca Raton, FL (Multi-plant/Multi-company-All Domestic Locations)
  Oct 1998 – Present
  • Convert from a PC-DOS based application to PRMS V8.4 multi-plant Financial, Mfg, and Distribution.
  • PRMS implementation included training for personnel in Boca Raton, relocation of the AS/400, integration of EDI, and custom programming.
  • Sep1999 – Setup, Training new company acquisition on PRMS V9.0
  • Oct 2000 – Upgrade QEP-Canada from PRMS V84 to V90
  • Oct 2001 – Upgrade QEP Co from PRMS V84 to V91
  • Mar 2010 – Setup, Training new company acquisition on PRMS V9.1
  • Jun 2011 – Upgrade QEP-New Jersey from PRMS V9.1 to V10.0
  • On-going PRMS support, training, custom applications
  • Setup ROBOT to automate daily/nightly/backups for 8 companies, 24×7
  • Installation of TMA Menu Master Manager application
  • Design/Write MS-Access linking Excel to AS400 for UCCNet file generation
  • Design/Write AP Positive Pay solution integrated with PRMS
  • VB application for order desk/warehouse management of all customer orders
  • VB.NET application consolidating 8 world-wide companies’ product and customer sales into management dashboard of grids and charts, Excel exports.
  • VB.Net application of MRP suggested PORs for vendor forecasting
  • VB.Net application linking 3rd party payroll with PRMS General Ledger
  • VB.Net application, Supply Chain Workbench, summary and detail grids, reporting, and dashboards to manage short and long-range planning of inventory projections.
  • VB.Net application, MRP Planning – Grid view of Suggestions and Exceptions, Drill-downs to Customer Order, Forecasts, Lower-Level inventory, MRP Vertical plan, Open and Historical PO and WO, option to create Work Orders with Point/Click from Grid view.
  • VB.Net application, Customer Order Planning – Grid view by user-defined date periods of customer orders by schedule date with calculated inventory availability per user-entered cut-off date.  Optionally include open WO/PO in availability.
  • Install INFORM Electronic Document application, configure form printing applications, design and install a related report distribution application utilizing forms application for EMAIL and printing of forms and reports.
  • EDI Mapping and PRMS EDI Interface support

 

QEP Roberts Ireland – Portlaoise, Ireland   Apr 2005 – Feb 2009
  • Assist controller with setup and training of V9.2 PRMS General Ledger application.

 

Roberts Consolidated – City of Industry, CA Jul 1994 – Oct 1998
  • Implementation of PRMS V8.2 multi-plant Financial, Mfg, and Distribution.
  • Provided on-going assistance for all PRMS applications and support for MIS operations.
  • Integration of new parent company (QEP, Inc.) onto PRMS system.

 

Roberts Canada – Bramalea, Ontario   May 1993 – Present
  • Implementation of PRMS V8.4 Financial, Mfg, and Distribution.
  • Oct 2000 – Upgrade PRMS V84 to V90
  • Provide on-going assistance for all PRMS applications.

 

ITW/CIP – Gallatin, TN   Feb 1995 – Present
  • Provide on-going assistance for all PRMS V8.4 applications.
  • Support MIS Operations with job scheduling and backups.
  • Configure and customize PRMS AR Letters and Follow-up Reminders
  • Installed TMA On-Line GL Summary Rebuild
  • Installation of TMA Menu Master Manager application
  • Design/Write MS-Access application for customized Manufacture Quotation System
  • VB application to print 2-sided Work Order direct from PRMS
  • VB.Net application presenting PRMS Costing data in interactive grid, excel download
  • VB.Net application linking AS400 budget Sales/Cost in interactive grid, excel download
  • VB.Net application in process for Customer Quote System
  • Design/Write AP Positive Pay solution integrated with PRMS
  • Reconfiguration of PRMS for company changes, remove custom code, training
  • Design/Write VB.NET custom interfaces between PRMS and WMS application for daily inventory management.
  • Design/Write VB.NET custom PRMS/WMS WIP Inventory Physical Inventory application.
  • Install INFORM Electronic Forms application.  Setup form design and distribution for Shop Floor WO/Routing form.
  • Design/Write VB.NET Vendor PO Delivery Performance APP report and chart based on Requested and Calculated Lead-Time Dates
  • VB.Net application lined to iSeries DB for managing Customer Quality Complaints

 

Simplicity Patterns (Wilton Industries) – Antioch, TN Feb 2008 – Present
  • Provide on-going HelpDesk Support for PRMS user training and program changes.
  • Support US and facilities in UK and Australia
  • Wrote custom PRMS add-in to allow for multiple price lists
  • Manage data conversion and system conversion to new fiscal year after acquisition by Wilton Industries
  • Assist with on-going conversion of PRMS to JD Edwards

 

T. Christy Enterprises – Anaheim, CA   Sept 2008 – Present
  • MS-Excel/MS-Access/VBA Application to electronically auto-apply customer checks to open Accounts Receivable and track commissions earned by salesman
  • MS-Access/VBA Fixes Asset Application
  • MS-Access/VBA Application to build General Ledger reporting files for use with Crystal Reports
  • MS-Access/VBA Customer Rebates Application. Includes multi-level discount tracking by quantity breaks, customer groups, and product groups. Tracks accruals and payments. Variety of reports. Integrated with PDF/EMAIL to send Rebate reports directly to customers and salesman
  • MS-Access/VBA Customer Score Card Application to chart and graph customers purchase patterns in a “score card” type presentation for salesman, customers, and management
  • Assist with investigation and analysis of alternative business software applications, leading to the acquisition of INFOR’s Syteline product.

 

Agave Energy Company – Artesia, NM Jul2014 – Present
  • Initial Support was to setup new operations on Agave’s own iSeries, migrating applications and data from the parent company system
  • During system setup, instituted a number of changes, replacing PC-Sequel apps with native iSeries apps resulting in a significant initial and on-going cost savings.
  • Set-up new process for electronic forms processing, program payroll connectivity to 3rd party application, and programmed a new windows app to replace a 3rd party Sequel label and filing system.
  • Provide on-going HelpDesk Support for user training and program changes.

 

Bumble Bee Tuna – Santa Fe Springs, CA   Aug 2000 – December 2005
  • Convert PRMS data and reconfigure for a fiscal year change.
  • Custom application to toggle between new and old fiscal year data.
  • Write program in MS-Excel VBA to extract AS/400 General Leger data for automatic update to Bumble Bee’s existing set of MS-Excel Financial Reports.
  • Setup and provide user training for specific AS/400 file transfers applications, including: PRMS/MS-Excel AP1099 data analysis, PRMS/MS-Word AP1099 mail merge forms, PRMS/MS-Excel Graphs of Utility Expenses/Consumption, PRMS/MS-Excel GL Departmental Expense Graphs.
  • Setup and install PRMS Financial Analysis Workbench.
  • BPCS/MS-Access application to view/print General Ledger data.
  • BPCS/VB.Net application to present inventories in graphs and grids.
  • VB.Net/MS-Access Labor Cost Analysis in grids, charts, reports.

 

Delta Technical Coatings – Whittier, CA Jun 1997 – May 1998
  • Provide education and training for PRMS shop floor and cost accounting
  • Provide user training on AS/400 file transfer
  • Design/Write MS-Excel upload to PMRS General Ledger Budget
  • Installation of TMA Menu Master Manager application

 

United Can Company – Hayward, CA Jul 1978 – Oct 2001

Jun 1994 – Oct 2001

  • Contracted to assist in various technical and training support of CA-PRMS software.
  • Conversion of PRMS V8.0 to V8.4.
  • Implemented CA-PRMS software and provided training for new plant in Tennessee.
  • Installed Robot Scheduler and integrate with CA-PRMS month-end processing.

 

Jul 1978 – Feb 1990

  • Assistant Controller and Director of MIS.
  • In 1982, purchased an IBM System 38 and PRMS software
  • Implement PRSM V6.5, providing all training and support
  • Work with PRMS to beta test V8.0.

 

La Tapatia – Compton, CA Mar 1996 – Jun 1996
  • Evaluate business software and hardware alternatives.
  • AS400 housekeeping to AS/400, install new operating system, install Client Access, and document in-house applications.

 

Allergan Medical Optics – Irvine, CA Aug 1993 – Mar 1996
  • Provide PRMS training for Financial, Distribution, and Manufacturing.
  • Installed TMA On-Line GL Summary Rebuild
  • Provide user training in FUSION and File downloads to end-users
  • Design changes to PRMS SF costing, implemented by AMO and Baxter, adopted by PRMS

 

Specialty Brands – San Francisco, CA Jul 1993 – May 1996
  • Installed TMA On-Line GL Summary Rebuild
  • Reverse engineer in-house forecasting, document, interface with PRMS
  • Implement GST/PST taxes in Canadian company, provide training and documentation

 

Baxter Paramax – Irvine, CA Jun 1992
  • Classes on the implementation of FUSION, basic and advanced retrieval creation, integration with PRMS Menu master.

 

Allergan Medical Optics – Anasco, Puerto Rico Feb 1990 – Nov 1991
  • Provide on-site training for all PRMS applications
  • Classes in Fusion retrieval design and Excel downloads from PRMS
  • Provide remote support from Irvine facility for all PRMS applications

 

Baxter Fenwal – Maricao, Puerto Rico Apr 1991 – Apr 1991
  • Provide on-site training for PRMS SF Cost Accounting and General Ledger

 

Anthem Electronics – San Jose, CA Apr 1990 – May 1990
  • Provide training and support on PRMS Physical Inventory
  • Classes in Fusion retrieval design and Excel downloads from PRMS
  • Design/Write custom application for WIP Physical Inventory
  • Classes in Fusion retrieval design