Work Experience by Client

Click Picture to see my Favorite References:

ITW Shakeproof – Elgin

Jun 2014 – Present

Support AS400 PRMS V8.4 Financial Modules
Designed and developed a VB.Net GL Application for viewing and extracting GL data
Designed and developed a VB.Net AP Application for check reconciliation
Designed and developed a VB.Net AR Remittance Application for uploading customer remittance from Excel spreadsheets
Designed and developed a VB.NET GL Journal Entry Upload from Excel application
Created an AS400 application to pull data from remote AS400 systems and reformat into a PRMS JE with auto-posting
Setup a Positive Pay process integrated within PRMS AP
Support multiple AS400 cost systems
Provide remote helpdesk support

ITW Shakeproof – Elk Grove

Jun 2014 – Present

Support AS400 Thomas-Friedman Manufacturing/Inventory/Purchasing System
Designed and developed a VB.Net Planning Application, integrating information from multiple AS400’s and an MS-SQL server
Provide remote helpdesk support

QEP Homelux – Burton, 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
Implement and Support Phocas BI Software, include Datatables and Dashboards for Sales, Inventory, Purchasing, AR, and AP

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.
Support Phocas application interface to PRMS
Implement and Support Phocas BI Software

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.
Implement and Support Phocas BI Software

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 3^rd 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
Use HelpSystems SEQUEL View Point and Crystal Report to design and create a Financial Reporting writing package integrated with the PRMS GL, including international and domestic GL Consolidations.

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 – Mar 2014

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
VB.NET 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.
VB.NET Application for extracting sales data from different manufacturing representatives in various formats of excel spreadsheets into a common MS-SQL table
Assist and design multiple Phocas applications for Manufacturer Sales, AP, Purchasing and Inventory.

Agave Energy Company – Artesia, NM

Jul 2014 – Jan 2019

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 – Dec 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