{"id":254,"date":"2015-03-08T05:17:22","date_gmt":"2015-03-08T12:17:22","guid":{"rendered":"https:\/\/tmainc.net\/?page_id=254"},"modified":"2020-03-30T09:21:48","modified_gmt":"2020-03-30T16:21:48","slug":"references-experiences","status":"publish","type":"page","link":"https:\/\/tmainc.net\/?page_id=254","title":{"rendered":"Work Experience by Client"},"content":{"rendered":"

Click Picture to see my Favorite References:<\/p>\n

\"Beatles\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n\n\n\n
ITW Shakeproof – Elgin<\/strong><\/td>\n  <\/strong> Jun 2014 –<\/strong> Present<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    \n
  • Support AS400 PRMS V8.4 Financial Modules<\/li>\n
  • Designed and developed a VB.Net GL Application for viewing and extracting GL data<\/li>\n
  • Designed and developed a VB.Net AP Application for check reconciliation<\/li>\n
  • Designed and developed a VB.Net AR Remittance Application for uploading customer remittance from Excel spreadsheets<\/li>\n
  • Designed and developed a VB.NET GL Journal Entry Upload from Excel application<\/li>\n
  • Created an AS400 application to pull data from remote AS400 systems and reformat into a PRMS JE with auto-posting<\/li>\n
  • Setup a Positive Pay process integrated within PRMS AP<\/li>\n
  • Support multiple AS400 cost systems<\/li>\n
  • Provide remote helpdesk support<\/li>\n<\/ul>\n

     <\/p>\n\n\n\n
    ITW Shakeproof – Elk Grove<\/strong><\/td>\n  <\/strong> Jun 2014 –<\/strong> Present<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
      \n
    • Support AS400 Thomas-Friedman Manufacturing\/Inventory\/Purchasing System<\/li>\n
    • Designed and developed a VB.Net Planning Application, integrating information from multiple AS400’s and an MS-SQL server<\/li>\n
    • Provide remote helpdesk support<\/li>\n<\/ul>\n

       <\/p>\n\n\n\n
      QEP Homelux – Burton, UK<\/strong><\/td>\n  <\/strong> Jun 2013 –<\/strong> Present<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
        \n
      • New V10 PRMS Implementation, setup and configure PRMS, local hardware, user-training<\/li>\n
      • Designed and developed a PHP\/iSeries Scanning solution for Shipping, fully integtrated with PRMS<\/li>\n
      • Designed and write VB.NET Sales Analysis App allowing multi-views of sales by customer\/product attributes and date\/fiscal period<\/li>\n
      • Design\/Write VB.Net app to Upload EXCEL AR Remittance to PRMS AR Remittance Batch processing applications.<\/li>\n
      • Design\/Write VB.Net app to print pro-forma Customer Invoices<\/li>\n
      • Implement and Support Phocas BI Software, include Datatables and Dashboards for Sales, Inventory, Purchasing, AR, and AP<\/li>\n<\/ul>\n

         <\/p>\n\n\n\n
        QEP New Zealand – Auckland, NZL<\/strong><\/td>\n  <\/strong> Jun 2004 –<\/strong> Present<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
          \n
        • Convert PC-DOS system to V9.2 PRMS Financial, Mfg, and Distribution.<\/li>\n
        • Provide all training, data-conversion, PRMS environment setup, start-up and on-going support.<\/li>\n
        • Support Phocas application interface to PRMS<\/li>\n
        • Implement and Support Phocas BI Software<\/li>\n<\/ul>\n

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

             <\/p>\n\n\n\n
            QEP Australia – Melbourne and Sydney, AUS<\/strong><\/td>\n  <\/strong> Apr 2003 –<\/strong> Present<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
              \n
            • Convert PC-DOS system to V9.2 PRMS Multi-plant, Financial, Mfg, and Distribution<\/li>\n
            • Provide all training, data-conversion, PRMS environment setup, start-up and on-going support.<\/li>\n
            • Write custom Pricing Application using MS-Access with interface to PRMS Contracts and List Prices.<\/li>\n
            • Customize PRMS setup for over-the-counter sales.<\/li>\n
            • Implement and Support Phocas BI Software<\/li>\n<\/ul>\n

               <\/p>\n\n\n\n
              QEP, Inc. – Boca Raton, FL (Multi-plant\/Multi-company-All Domestic Locations)
              \n<\/strong><\/td>\n              		  <\/strong> Oct 1998 –<\/strong> Present<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
                \n
              • Convert from a PC-DOS based application to PRMS V8.4 multi-plant Financial, Mfg, and Distribution.<\/li>\n
              • PRMS implementation included training for personnel in Boca Raton, relocation of the AS\/400, integration of EDI, and custom programming.<\/li>\n
              • Sep1999 \u2013 Setup, Training new company acquisition on PRMS V9.0<\/li>\n
              • Oct 2000 – Upgrade QEP-Canada from PRMS V84 to V90<\/li>\n
              • Oct 2001 – Upgrade QEP Co from PRMS V84 to V91<\/li>\n
              • Mar 2010 \u2013 Setup, Training new company acquisition on PRMS V9.1<\/li>\n
              • Jun 2011 \u2013 Upgrade QEP-New Jersey from PRMS V9.1 to V10.0<\/li>\n
              • On-going PRMS support, training, custom applications<\/li>\n
              • Setup ROBOT to automate daily\/nightly\/backups for 8 companies, 24×7<\/li>\n
              • Installation of TMA<\/em> Menu Master Manager application<\/li>\n
              • Design\/Write MS-Access linking Excel to AS400 for UCCNet file generation<\/li>\n
              • Design\/Write AP Positive Pay solution integrated with PRMS<\/li>\n
              • VB application for order desk\/warehouse management of all customer orders<\/li>\n
              • VB.NET application consolidating 8 world-wide companies\u2019 product and customer sales into management dashboard of grids and charts, Excel exports.<\/li>\n
              • VB.Net application of MRP suggested PORs for vendor forecasting<\/li>\n
              • VB.Net application linking 3rd<\/sup> party payroll with PRMS General Ledger<\/li>\n
              • VB.Net application, Supply Chain Workbench, summary and detail grids, reporting, and dashboards to manage short and long-range planning of inventory projections.<\/li>\n
              • 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.<\/li>\n
              • 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.<\/li>\n
              • 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.<\/li>\n
              • EDI Mapping and PRMS EDI Interface support<\/li>\n
              • 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.<\/li>\n<\/ul>\n

                 <\/p>\n\n\n\n
                QEP Roberts Ireland – Portlaoise, Ireland<\/strong><\/td>\n  <\/strong> Apr 2005 – Feb 2009<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
                  \n
                • Assist controller with setup and training of V9.2 PRMS General Ledger application.<\/li>\n<\/ul>\n

                   <\/p>\n\n\n\n
                  Roberts Consolidated – City of Industry, CA<\/strong><\/td>\n Jul 1994 \u2013 Oct 1998<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
                    \n
                  • Implementation of PRMS V8.2 multi-plant Financial, Mfg, and Distribution.<\/li>\n
                  • Provided on-going assistance for all PRMS applications and support for MIS operations.<\/li>\n
                  • Integration of new parent company (QEP, Inc.) onto PRMS system.<\/li>\n<\/ul>\n

                     <\/p>\n\n\n\n
                    Roberts Canada – Bramalea, Ontario<\/strong><\/td>\n  <\/strong> May 1993 –<\/strong> Present<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
                      \n
                    • Implementation of PRMS V8.4 Financial, Mfg, and Distribution.<\/li>\n
                    • Oct 2000 – Upgrade PRMS V84 to V90<\/li>\n
                    • Provide on-going assistance for all PRMS applications.<\/li>\n<\/ul>\n

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

                         <\/p>\n\n\n\n
                        Simplicity Patterns (Wilton Industries) – Antioch, TN<\/strong><\/td>\nFeb 2008 –<\/strong> Mar 2014<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
                          \n
                        • Provide on-going HelpDesk Support for PRMS user training and program changes.<\/li>\n
                        • Support US and facilities in UK and Australia<\/li>\n
                        • Wrote custom PRMS add-in to allow for multiple price lists<\/li>\n
                        • Manage data conversion and system conversion to new fiscal year after acquisition by Wilton Industries<\/li>\n
                        • Assist with on-going conversion of PRMS to JD Edwards<\/li>\n<\/ul>\n

                           <\/p>\n\n\n\n
                          T. Christy Enterprises – Anaheim, CA<\/strong><\/td>\n  <\/strong> Sept 2008 –<\/strong> Present<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
                            \n
                          • MS-Excel\/MS-Access\/VBA Application to electronically auto-apply customer checks to open Accounts Receivable and track commissions earned by salesman<\/li>\n
                          • MS-Access\/VBA Fixes Asset Application<\/li>\n
                          • MS-Access\/VBA Application to build General Ledger reporting files for use with Crystal Reports<\/li>\n
                          • 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<\/li>\n
                          • 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<\/li>\n
                          • Assist with investigation and analysis of alternative business software applications, leading to the acquisition of INFOR’s Syteline product.<\/li>\n
                          • VB.NET Application for extracting sales data from different manufacturing representatives in various formats of excel spreadsheets into a common MS-SQL table<\/li>\n
                          • Assist and design multiple Phocas applications for Manufacturer Sales, AP, Purchasing and Inventory.<\/li>\n<\/ul>\n

                             <\/p>\n\n\n\n
                            Agave Energy Company – Artesia, NM<\/strong><\/td>\nJul 2014 –<\/strong> Jan 2019<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
                              \n
                            • Initial Support was to setup new operations on Agave’s own iSeries, migrating applications and data from the parent company system<\/li>\n
                            • 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.<\/li>\n
                            • 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.<\/li>\n
                            • Provide on-going HelpDesk Support for user training and program changes.<\/li>\n<\/ul>\n

                               <\/p>\n\n\n\n
                              Bumble Bee Tuna – Santa Fe Springs, CA<\/strong><\/td>\n  <\/strong> Aug 2000 –<\/strong> Dec 2005
                              \n<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
                                \n
                              • Convert PRMS data and reconfigure for a fiscal year change.<\/li>\n
                              • Custom application to toggle between new and old fiscal year data.<\/li>\n
                              • 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.<\/li>\n
                              • 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.<\/li>\n
                              • Setup and install PRMS Financial Analysis Workbench.<\/li>\n
                              • BPCS\/MS-Access application to view\/print General Ledger data.<\/li>\n
                              • BPCS\/VB.Net application to present inventories in graphs and grids.<\/li>\n
                              • VB.Net\/MS-Access Labor Cost Analysis in grids, charts, reports.<\/li>\n<\/ul>\n

                                 <\/p>\n\n\n\n
                                Delta Technical Coatings – Whittier, CA<\/strong><\/td>\n Jun 1997 \u2013 May 1998<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
                                  \n
                                • Provide education and training for PRMS shop floor and cost accounting<\/li>\n
                                • Provide user training on AS\/400 file transfer<\/li>\n
                                • Design\/Write MS-Excel upload to PMRS General Ledger Budget<\/li>\n
                                • Installation of TMA<\/em> Menu Master Manager application<\/li>\n<\/ul>\n

                                   <\/p>\n\n\n\n
                                  United Can Company – Hayward, CA<\/strong><\/td>\n Jul 1978 \u2013 Oct 2001<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

                                  Jun 1994 \u2013 Oct 2001 <\/strong><\/p>\n

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

                                     <\/p>\n

                                    Jul 1978 \u2013 Feb 1990 <\/strong><\/p>\n

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

                                       <\/p>\n\n\n\n
                                      La Tapatia – Compton, CA<\/strong><\/td>\n Mar 1996 \u2013 Jun 1996<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
                                        \n
                                      • Evaluate business software and hardware alternatives.<\/li>\n
                                      • AS400 housekeeping to AS\/400, install new operating system, install Client Access, and document in-house applications.<\/li>\n<\/ul>\n

                                         <\/p>\n\n\n\n
                                        Allergan Medical Optics – Irvine, CA<\/strong><\/td>\n Aug 1993 \u2013 Mar 1996 <\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
                                          \n
                                        • Provide PRMS training for Financial, Distribution, and Manufacturing.<\/li>\n
                                        • Installed TMA<\/em> On-Line GL Summary Rebuild<\/li>\n
                                        • Provide user training in FUSION and File downloads to end-users<\/li>\n
                                        • Design changes to PRMS SF costing, implemented by AMO and Baxter, adopted by PRMS<\/li>\n<\/ul>\n

                                           <\/strong><\/p>\n\n\n\n
                                          Specialty Brands – San Francisco, CA<\/strong><\/td>\n Jul 1993 \u2013 May 1996<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
                                            \n
                                          • Installed TMA<\/em> On-Line GL Summary Rebuild<\/li>\n
                                          • Reverse engineer in-house forecasting, document, interface with PRMS<\/li>\n
                                          • Implement GST\/PST taxes in Canadian company, provide training and documentation<\/li>\n<\/ul>\n

                                             <\/strong><\/p>\n\n\n\n
                                            Baxter Paramax – Irvine, CA<\/strong><\/td>\n Jun 1992<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
                                              \n
                                            • Classes on the implementation of FUSION, basic and advanced retrieval creation, integration with PRMS Menu master.<\/li>\n<\/ul>\n

                                               <\/strong><\/p>\n\n\n\n
                                              Allergan Medical Optics – Anasco, Puerto Rico<\/strong><\/td>\nFeb 1990 \u2013 Nov 1991<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
                                                \n
                                              • Provide on-site training for all PRMS applications<\/li>\n
                                              • Classes in Fusion retrieval design and Excel downloads from PRMS<\/li>\n
                                              • Provide remote support from Irvine facility for all PRMS applications<\/li>\n<\/ul>\n

                                                 <\/strong><\/p>\n\n\n\n
                                                Baxter Fenwal – Maricao, Puerto Rico<\/strong><\/td>\n Apr 1991 \u2013 Apr 1991 <\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
                                                  \n
                                                • Provide on-site training for PRMS SF Cost Accounting and General Ledger<\/li>\n<\/ul>\n

                                                   <\/p>\n\n\n\n
                                                  Anthem Electronics – San Jose, CA<\/strong><\/td>\n Apr 1990 \u2013 May 1990 <\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
                                                    \n
                                                  • Provide training and support on PRMS Physical Inventory<\/li>\n
                                                  • Classes in Fusion retrieval design and Excel downloads from PRMS<\/li>\n
                                                  • Design\/Write custom application for WIP Physical Inventory<\/li>\n
                                                  • Classes in Fusion retrieval design<\/li>\n<\/ul>\n

                                                     <\/p>\n