Charles J. Borill, Jr.

- BPCS application experience with Releases 3.x, 4.05CD, 5.x, 6.x (11 years)

 - Implementations

 - Alfa Laval  BPCS 3.0

 - Westvaco Corporation BPCS 5.1 and 6.02

 - Morven Partners BPCS 6.02

- Conversions and Upgrades

- Morven Partners BPCS 6.02 to BPCS 6.10

- Aero Transportation  BPCS 2.0 (Sys/36) to AS/400 BPCS 4.05CD (1999)

- Post Implementation support and customizations

- Interbake Foods BPCS 3.1

- BI Chemicals BPCS 4.0 and 4.05CD

- Westvaco Corporation  BPCS 5.1 and 6.02

- Morven Partners BPCS 6.02 and 6.10

- Module Experience

Order Entry

Outbound Logistics Manager

Billing

Sales Analysis

Accounts Receivable

Accounts Payable

General Ledger

Purchasing

Product Data Management

Shop Floor

Labor Reporting

CimPath

Inventory 

Costing

Forecasting 

Manufacturing Data Maintenance

Master Production Scheduling

Distribution Relationship Planning

Material Requirements  Planning

Capacity

- AS/SET  ( 6 years )

- RPG II/III/400 ILE and OCL / CLP  (23 years, last 13 years on AS/400)

Interactive

Sub Files

Batch

CLP

OS/400

SQL

Application Design

Database Design

Trouble shooting

Security

Performance

Operations

Backup/Recovery

Projects   

Interbake Foods (1991)

Project involved taking customer data (master files, sales and invoice history files) from 3 platforms (S/36, S/38, and AS/400), different applications and merging it into BPCS Rel 3.0 on the AS/400

Developed custom sales reporting system that utilized the existing BPCS databases as well as additional user defined databases

Modified billing update program

Alfa Laval Thermal - Richmond (1991-1994) :p>

Key analyst/programmer for BPCS implementation starting in Nov. 1991

Worked closely with the project manager to create and execute implementation plan with  involvement  in  all aspects of the project

Integrated VERTEX sales tax application into  order entry and billing modules

Converted Computer Associates accounts receivable, accounts payable, and general ledger databases to the respective BPCS databases

Made enhancements to the general ledger module

Converted the MAPICS manufacturing databases into the BPCS manufacturing data bases

Modified order entry process to remember previously selected features and options during the configuration of a heat exchanger along with other modifications

Modified pick release and pick confirmation to allow additional selection filters

Modified ship confirmation process to gather all necessary information and generate the appropriate packing lists, bill of lading, and the necessary documents for overseas shipments

Interface invoicing to the ALGO system

Made changes to the Canadian financial reporting system

Modified the standard cost calculations in the shop order costing program

Modified accounts payable invoice entry to distribute to general ledger

Other modifications and custom development per project specifications

Tredegar Industries (1995)

Developed online project management applications for AS/400

Developed online software change management for AS/400

Modified Pansopic order entry pricing

Analyzed and estimated cost of upgrade Pansopic

A.T. Massey Coal  (1995)

Developed a custom general ledger reporting system on AS/400 in RPG/400 and CLP

Westvaco Corporation (1995 – present)

Implement the order entry and  billing modules for BPCS 5.1. Interfaced the inventory from the legacy systems to BPCS 5.1 and back to the legacy systems via radio frequency data collection and CimPath

Technical lead of BPCS 6.02 implementation at Westvaco in June 1997

Developed radio frequency data collection process and inventory locator system to post inventory transactions collected on shop floor for purchase order receipts, manufacturing production receipts, issues and shipments into BPCS 6.02  purchasing, shop floor, and inventory modules maintaining over 99% inventory accuracy

Developed a radio frequency data collection process to automate the BPCS two step cycle count process providing extensive reporting and visibility of  cycle count  inventory transactions

Conversion of data from the legacy systems (inventory, bill of materials, routings, cost data, item master).   This conversion was performed from two AS/400 platforms. Bill of materials (multi-level) from data that was scattered across the two platforms in legacy systems  were created in the BPCS database as well as item master records. Routings were created from scratch.  Component bill of materials were also generated for scratch

Developed the ability to maintain the location visibility of “prebilled” inventory that has been billed to the customer and not actually shipped and setting the value to zero

Creation of lot master records for lot control processing

Creation of lot master records from ASNs received from vendors

Conversion and creation of inventory from two AS/400 legacy systems into BPCS

Heavy utilization of co-product processing in shop floor module

Developed process to automate two step cycle counts where user collects cycle count data via radio frequency and then selects what to post by simply selecting  the lot/item with and action option.  Also post a memo indicating that cycle count was deleted.

Extensive use of inventory transactions and lot status to control movement and status of inventory

Developed program to allocate lots records to sales orders as they were loaded onto the carrier by RF data collection.  Moved inventory to appropriate warehouse before allocation is performed to ensure that BPCS will ship lot.  Also capability to remove allocated lots from sales order if lots are moved off of the truck.

Modifications to shop order creation program and auto generation of shop orders from order entry to include phantom items w/o inventory and the attachment of phantom components to appropriate routing operation on printed shop packet.  Also rounded items with stocking unit of measure to next whole number.  Add shop order notes using existing BPCS note functionality.

Incorporated BPCS notes capablilty in shop floor labor posting transactions.

Created an automated shop order close program

Modified inventory month end processing to decrease processing time

Automated the month end process to run appropriate month end programs

Modified inventory inquiry to show transactions in descending date/time sequence rather than transaction sequence and eliminated locations that contain no inventory

Modified update IIM from ILI to run for specific item or all items in a batch mode

Modifications to allocation programs to not allocate lot control items during pick release and shop order creation

Modifications to pick confirmation to only allow entry of lot number to be shipped and automatically retrieve location and quantity of lot

Modification to finite forward scheduling to allow alternate sequences in which to present shop orders and to start scheduling based on simulated date and time rather than BPCS shop calendar and midnight

Custom parameter controlled shop order schedule report generation

Implemented Master production scheduling, distribution relationship planning and material requirements planning

Modified CimPath and INV500 to execute a list of programs before or after an inventory transaction is posted based on the inventory transaction effect to allow processing to take place based on specific transaction

Modified CimPath to automatically allocate inventory from an item class specific location for the purpose of backflushing raw materials that are used on a “consignment” arrangement with the vendors

Modified CimPath to not allow the single issuing of  materials that are not found on the bill of materials without  authorization by the inventory control manager or production personel for that specific material

Modified CimPath to allow posting of manufacturing receipt to a warehouse other than that of the shop order

BPCS to SAP interface for material add/change/deletes, purchase requisitions, purchase order receipts, inventory, labor utilizing APPC and then MQ Series

Morven Partners (1998 – present)

Modifications to the BPCS billing update program to accommodate a special freight calculation.

Modifications  to pick confirmation to automatically generate an invoice based on a warehouse with printer control, prompting for load information before packing and bill of lading reports are generated

Modifications to billing update to allow alternate bank numbers to be feed to the accounts receivable, calculation of special fuel surcharge

Developed a commodity buying system that interfaces to BPCS inventory modules via CimPath.

Dynamic creation of fuel surcharge item on sales order based on weight of quantity shipped during pick confirmation process.

Developed  over the counter order processing front end that works mostly like an auto parts store, customers get in and out very quickly.  This application utilizes the BPCS inventory lot control and consigns inventory to a customer location and prints delivery/return tickets until a settlement date is established at which time the consigned inventory is automatically allocated to a sales order reducing inventory and generating invoices

Aero Transportation (1999)

Converted a System/36 BPCS Rel 2.0 to AS/400 BPCS 4.05 CD.  This was a complicated conversion process because the System/36 BPCS  release and the conversion software release did not match.  A 1500 page job log had to be analyzed to determine where errors occurred in the conversions of the data.

Added net sales cost to sales history

Added project number to order header

Added lookup by project number to order inquiry

Modified item class maintenance to allow additional general ledger accounts for cost of goods sold and consumable materials calculations

Modified item type maintenance to allow additional general ledger sales accounts

Create program to generate additional general ledger entries for multiple issue with receipts transaction

Modify INV920 to break out cost of goods and sales per requirements

Create bill of lading and shipping papers programs.

Modify invoice program to select by bill of lading number.  This allowed multiple shipments against the same order per day with separate invoice generation.

Modify account payable checks and invoice forms

Modify shipping papers generation to allow entry of carton dimensions with the automatic weight calculation of cartons

Interface hand held data collection devices to cycle count and physical inventory

Created program to calculate overhead cost and labor for specified period of time and update to cost records

Modify average cost calculations in CST920

Manipulate MRP parameters to improve planning

Professional History

Independent Consultant (1991 – Present)

Project management, requirement studies, application/database design, progamming, trouble shooting

Project Manager, Heilig Meyers (1989-1991)

Managed development projects for corporate AS/400

Analyst, Harris Data Service 1988-1989

Analysis and development of applications for manufacturing, distribution, and accounting Installation and support of  applications for manufacturing, distribution, and accounting

Vice President, Virginia Software Specialists, Inc. (1984-1988)

Supervised and directed the technical services of seven employees. Developed custom software applications for S/38 and AS/400 installations  in distribution, manufacturing,retail, engineering, health care, hotel/motel management, and food service environments. Installed IBMs S/36, S38, AS/400 hardware and related peripheral equipment under an IBM Business Partner program.

Applications Developer, A. T. Massey Coal Co.  (1981-1984)

Developed custom financial software on S/38 for in-house use and converted applications from System3 model 15D to System/38

Programmer/Analyst,  J.T. Mcleskey Co. (1979-1981)

Developed and supported financial software for S/32 and S/34 client base

Education

Old Dominion University - 1976-1979

Information Systems

Professional References

Available upon request