|
|
 |
      |
|
REFERENCES and RELATED EXPERIENCES:
QEP Roberts Ireland - Portlaoise, Ireland
Apr 2005 - Present
· Assist controller with setup and training of V9.2 PRMS General Ledger application.
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.
Bumble Bee Tuna - Santa Fe Springs, CA
Aug 2000 - Present
· 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.
QEP, Inc. - Boca Raton, FL
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
· On-going PRMS support, training, custom applications
· Setup ROBOT to automate daily/nightly/backups for 8 companies, 24x7
· 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
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 - Santa Fe Springs, CA
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 custom interfaces between PRMS and WMS application.
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