Philip Barton
7095 Hollywood Boulevard • PMB 822
Los Angeles, California 90028-8903

Phone: 323.876.7123
Fax: 323.850.5302
Email: pbarton@worldnet.att.net
Webpage: www.bartonworks.com

A highly knowledgeable manufacturing database programmer/analyst, with 23 years’ experience in all phases of the MultiValue operating systems (UniData, UniVerse, Pick, Mv/Base), and DataFlo manufacturing/ERP software. Author of more than 45 modules and two full applications systems used in manufacturing, inventory control, accounting, distribution and management reporting.

Expertise includes programming skills in all phases of manufacturing databases; developing new applications to user specifications, and establishing criteria for productivity improvement. Outstanding communications, documentation and analytical skills.

I have written Custom software to allow Excel generation, in addition to paper reports, for any data within DataFlo, for any DataFlo release level. This adds the ability to create Excel, in addition to "paper" reports, for many of the baseline reports, as well as Custom reports created in-house by the customer, or provided as third-party.

The implementation of World-Class Measurement techniques for trend analysis, to allow management to achieve improved real-time control of business activities.

Demand Planning and Forecasting, to connect Marketing and Manufacturing, to improve the Supply Chain.

I am keenly interested in B2B and Supply Chain, and Customer- and Vendor-Facing Web pages utilizing XML. I am also interested in accepting and transmitting Purchase and Sales Order schedule changes in XML format

I have received a Certificate in Training, and have taken Project Management courses, at www.langevin.com.

I authored a column in Database Trends, beginning with the August 2001 issue.

A long-term contract with a large division of a major U.S. corporation, to provide consulting and programming services for over 180 users on a Dataflo database. This will involve a completely new Field Services module, to handle multiple repair depots and their restocking needs, and migrating them to a Multiplant environment for manufacturing.

The successful migration of a Dataflo customer to Oracle, and writing of custom Dataflo software to automate the procedure. This involved mapping the major Dataflo files to Oracle Templates as determined by the Oracle consultants, and other issues in terms of definition of the Dataflo database. This project was successfully completed in November 2002.

A completely integrated Demand Planning and Forecasting System for a Dataflo account, including complete analytical reporting using Pareto analysis, to determine largest/most critical Customers and Parts. Demographic slicing capabilities are included.

A complete Commercial Invoice Module, allowing for pre-store of records for Shipper, Consignee, Bank, FOB’s, and document boilerplate, for rapid generation of new Commercial Invoices.

Last Cost Rollup, with Last Costs drawn from Purchase and Work Orders. Reports are provided for tracing of variance to existing Cost-Versions. This includes reporting of root causes of Costing problems throughout the product structure.

Mass Re-pricing of Contracts and Parts, optionally by Product Categories, with Pareto analysis of key Finished Goods, and Profit Margin analysis to pre-analyze the impact of price or cost changes.

EXPERIENCE

• Provided Consulting, Training, and Custom Software, both to customer specification, and from existing third-part Custom Software Modules for DataFlo. The following are brief descriptions of some of the software projects performed, and Modules provided:

• Purchase and Sales Order Detailed History for management, marketing, and buyers, for rapid reporting by Part, Supplier, Customer, Order, etc. These Modules, as well as many others, now have provision for direct reporting to Excel, as well as "paper" output.

• Available-to-Promise display using real-time data, rather than the output of the last MRP, with PO/SO/WO detail.

• Customer Service Call billing using "Batch" Statements, adding ability to include customer disputes of Service Calls.

• Field Service Contracts Module, with fully integrated Configurations/Sales Orders/Contracts.

• High-speed Supply Chain, in lieu of conventional MRP, which increased the customer’s turns from 6 to 14. Designed and developed a Min-Max inventory Order Point system, which enables the customer to utilize a "pull" system, based on actual usage by manufacturing, versus the traditional ordering via straight MRP. Also allows for Supplier-manager inventory.

• Last-Cost Rollup technology, to determine standard costs based on current Purchasing, OSP, and WIP activity, to compare to existing Standards.

• Wall-to-Wall Summary Reporting for the Physical Inventory, as well as a Daily Cycle Count Module for continuous use.

• Indented BOM structure within custom database files, for reporting of Indented Routings, and determination of Indented Shortages. There is a supplemental Module for customers using JOBS costing, which can perform Indented Shortage Reporting against many Work Orders at one time.

• Weekly Status Reporting, and various forms of World Class Measurement, including Sales Order Linefill, and Supplier On-Time Analysis by Commodity Code and Supplier.

• UniData or UniVerse File Statistics.

Please note a more complete listing of Custom Modules on my Web site, www.bartonworks.com.

• Rewrote the physical inventory module to record a company-wide inventory consisting of 8,000 SKUs, valued at $4 million.

• Authored a cycle-count module that insured that all parts were counted over the span of a year by predating the parts in count sequence, by product line.

• Created an MRP planning what-if real-time environment that permitted buyers to determine component requirements from their own assembly schedules; this saved more than $50,000 per year.

• Wrote nightly-weekly-monthly job streams that provided more than 150 management reports.

• Added the capacity to build seven financial journals nightly, by product line, by material-labor-overhead. This saved two accounting days every month-end.

• Created an annual cost roll-up module that permitted simultaneous maintenance of standard, current and new costs that enabled future standards to be rolled in advance of the new year. This included reports of inventory at existing and future costs.

• Developed a module that isolated and analyzed obsolete and inactive inventory. This assisted in eliminating $600,000 in obsolete inventory.

• Upgraded system software to approve incoming receipts for specific part numbers, by vendor, bypassing the need for receiving inspection.

• Eliminated the need for work orders by back flushing directly against the master production schedule.

• Prepared a vendor delivery schedule that included MRP requirements by time period, on-hand inventory, open purchase order scheduled deliveries, and past receipts.

• Put together a project tracking module that showed estimated hours and completion dates, and permitted user ranking of projects.

• Set up a control system to track incoming customer cores for credit against rebuilt sales, and designed an order system to deal with groups of similar cores for rebuilding with corresponding yield information.

• Developed an application that analyzed the company’s model prices against competition by part number to maximize profitability, and created a catalog of part numbers that permitted sales of company products to replace competitive parts.

• Developed a costing model to generate current actual costs on production to assure that the company was selling its rebuilt products profitably.

• Wrote a sales quotation system that showed detailed gross margins at the line item and order level to permit management to maximize its sales/profitability.

For ten years, was an institutional trader for a large money manager with $7 billion under management and an institutional trader for a market maker in international securities and arbitrage. Began career on the floors of the New York and American Stock Exchanges.

California State University, Northridge, California

Certificate in Production and Inventory Control, 1982-1984

New York Institute of Finance, New York, New York

New York University Management Institute, New York, New York

Took courses in COBOL and systems analysis and design.

Hunter College, New York, New York

Completed two and one-half years of a pre-engineering program.

Other Courses:

Advanced "proc" Procedural, "Access" Reporting, and Programming Concepts courses.

New York Army Reserve National Guard, E5, Personnel Specialist

American Production and Inventory Control Society, San Fernando Valley Chapter.

Board member from 1982-1987.

Los Angeles PICK Users Group (LAPUG), founder and board member.