Paul Fry,
CPIM
|
|
|
|
|
This consultant offers over seventeen (17) years experience in all
phases of project management from analysis of client requests through
specification approval, development, testing, implementation and user
training. He is known for excellence in
all fields of endeavor and is highly commended for performance and
professionalism. In addition to being a
capable project leader, he is a first-rate team player, an insightful business
and technical analyst, an excellent project manager and an effective
communicator.
SKILL-SET
Consultant has acquired and demonstrated expertise
or a high degree of experience with the following applications and
technologies.
Database
Environments:
Progress RDBMS (17 years experience), Informix, SQL Server 7, MSDE,
Access.
Application
types:
Financials (AR, AP, GL), Sales Order, Distribution, EDI, Customer
Service, Manufacturing, Inventory, Data Collection, Purchasing, MRP, MPS,
Costing, Engineering, Quote Generation, CRM (Customer Relationship
Management).
Application
Software (ERP):
QAD MFG/PRO
(7 years experience, versions 7.x, 8.x, 9.0, eB), Endura Enterprise,
Other Software:
StreamServe,
Optio DCS/FAX-FX, Sterling EDI, STX EDI, Trinary EDI, Frontstep eBusiness
Suite, CRM, Robocom RIMS, Integral Enterprise Viewer, MS Office.
Languages
and Protocols:
Progress 4GL Version 6, 7, 8 and 9, SQL-92, Visual Basic,
Operating
Systems:
SCO UNIX, HP-UX (10 & 11), AIX, SunOS, Windows
XP/2000/NT/98/95/DOS, VMS.
Hardware:
HP: 9000 & L1000 series, SUN Sparc,
Dec:
PDP-11 & VAX.
Certification:
CPIM
(Certified in Production and Inventory Management)
Certified
for Microsoft Retail Management System (RMS)
WORK EXPERIENCE
ERP IMPLEMENTATION AND SUPPORT – Served on a working committee which
implemented MFG/PRO eB with customizations for an international multi-site
corporation. Responsibilities encompassed both technical and functional roles.
After implementation, provided support and ongoing process and technical
improvements (Oct 02-Mar 05)
- Trained client’s users in both standard MFG/PRO functionality and
customization for client’s repair shop.
- Tested customizations against particular site’s
requirements.
- Developed forms specification and implemented form for Findings
Report, FAA Certification and Invoice via Stream Serve forms software.
Provided for specific document needs for sites in three (3)
countries.
- Performed custom data conversions and loads for Product
Configuration, Customized Routing Schemes, A/R, A/P, Vendor master and
Global Tax Management using CIM functionality.
- Developed custom reports and troubleshot post-implementation
problems.
- Developed, implemented and supported forms using Stream Serve
software for international standardized forms project.
- Oversaw development of external application interfaces using ASCII
and XML protocols with FTP transport.
PHYSICAL INVENTORY CUSTOMIZED FORMS DEVELOPMENT – Served as the sole IT
support on a team with a new controller determined to improve inventory
accuracy and the physical inventory-taking process. This team achieved both
goals and eliminated the need for temporary hires by using improved forms and
faster, more precise reporting. (May 05)
- Developed user friendly, easy to read inventory tag forms via Stream
Serve forms development. Forms contained one section for WIP and one for
finished goods.
- Developed “WIP Inventory Tag” program to print inventory tags for
repair items in WIP, sorted by milestone to make them easier to locate on
the shop floor. Modified MFG/PRO-standard Finished Goods tag code to work
with Stream Serve tag form.
- Stream Serve tag forms could be called by either tag generation
program (Finished Goods or WIP.)
- Set up archive of tag forms so that any lost tags could be
re-printed immediately.
- Designed “Inventory Valuation” reports for accounting to determine
“carcass costs” of repair items in the Asset Management
site.
STREAMSERVE FORMS DEVELOPMENT AND SUPPORT – Served as the sole
Streamserve developer and on-call support person for a major manufacturer and
SAP user. Provided excellent communications needed for a successful
telecommuting contract (Aug 05-Sep 05).
- Setup native Streamserve PDF-writer for invoice
form.
- Added fuel surcharge, segregated from total freight per
output.
- Integrate
SOFTWARE PROJECT MANAGEMENT
– In the following projects, consultant had the role of Project Manager or
Project Lead:
·
Estimation
System – Led project to develop
and implement a GUI-based Estimation System in Progress V8. Was in charge of
status meetings and testing sessions. Later managed project to upgrade to
Progress V9 and roll out to 2nd division of Client Company. (Mar
99-Oct 99)
·
Built to
client’s specification. Formulas adapted from client’s spreadsheet models into
modular Progress function calls. Screen flow built around engineer’s manual
estimation processes to provide an intuitive user-interface.
·
Fully
integrated with client’s Symix ERP system. Estimation system uses data from
Symix tables (item, cost, work center, customer, etc.) as input and creates new
items and product structures with costs in Symix from generated
quotes.
·
Features
maintainable parameter screens to control formulas for machine operations,
materials, packaging options, user access, pricing categories and pricing
strategies.
·
Template-driven
for rapid development of quotes. Prints
quote letter ready to send.
·
Internet Data Harvester System – Proposed, designed and
developed a Progress-based system for client to automate information retrieval
from internet sites. (May 03)
·
Implementing
this system reduced the amount of time to download data at least six-fold and
eliminated all errors.
·
Client
realized a direct monetary savings of over $3,000.00/month.
·
Features of
system: Custom-built to address client’s needs, multiple session capability (up
to 5 simultaneous sessions per client computer), recognized and prevented
duplicate data, output interface to Excel spreadsheet format.
·
Six Sigma Initiative: DSO reduction – Problem: users were forgetting to send Advanced Ship Notices to
customers causing administrative errors and non-payment. Worked with Sales
Department and Six Sigma Black Belts to determine best way to increase accuracy
in ASN delivery ad streamline the user process, thus reducing Days Sales
Outstanding. Led project to automate Advanced Ship Notice documents (EDI-856)
sent at time of shipment. Tested project and rolled out to user base. (Jun
02-Aug 02)
·
Data
Extract Project – Built a data
extract interface which delivered information to client’s largest customer from
MFG/PRO. Developed roll out plan for four (4) sites encompassing four (4) time
zones in three (3) countries. System delivered exception report and was
automated to send data at the close of each work day. System was later modified
to also send XML files to a B2B site. (
·
Integrated
FAA Certification Project – Oversaw the development of a repair certification
system which pulls data directly from MFG/PRO work orders, requests more
information from component inspectors and generates certifications for multiple
aviation authorities (FAA, JAA, CAAC, etc.). Developed for use in three (3)
countries. Provided ongoing support and enhancements for system. Used Stream Serve
forms generator for output. (Sep 03-Feb 04)
·
Payroll System Integration – Built a CIM interface in MFG/PRO eB to load data
from client’s payroll system (PDS) reports. Interface included accounts and
format error checking. Saved client between 6-10 hours per month of
controller’s and payroll department’s time. (Apr 03)
·
JIT
Initiatives – Worked with
Engineering, Material Management, Purchasing, Operations and a contracted
programmer to develop and implement application programs designed to increase
productivity, efficiency and accuracy. Examples include:
·
ASME Shop
Traveler – Designed, developed and
implemented a custom Shop Traveler system into MFG/PRO’s Work Order module
using Optio DCS forms generation software.
Also created product bar code identification label and stocking label to
be output simultaneously on Zebra printers. Traveler and labels were designed
to promote ASME standards. (Apr 99-Jun 99)
·
Automatic
Backflush – Developed an automatic
backflushing and serial number barcode labeling system in MFG/PRO. Serial
number entered is verified against open work orders for 100% accuracy. (Aug
99-Sep 99)
·
Automatic
·
Database Audit Trail System – Managed project to design and develop a
comprehensive Audit Trail system for table updates using database triggers in
Progress V8. System tracked record creation, modification and deletion in
specified tables recording user ID, date, time, current and former value of
fields, etc. (Mar 02-Jun 02)
·
MFG/PRO 9.0
Upgrade – Led project to upgrade
MFG/PRO from 7.4i to 9.0 SP4. Ported entire system from HP-9000 box to an HP
L1000 series. Tuned kernel on new box for Progress. Designed automatic UNIX FTP
scripts and Progress code to aid in dump and reload process. Reapplied
modifications (200+ programs). (Feb 02-Jul 02)
SOFTWARE DEVELOPMENT (Other) – In the following projects consultant had the role of lead developer or
was a member of a team of developers:
·
EDI
Integration – (Lead) Developed and
integrated EDI software into Symix ERP system for transmission and receipt of
Purchase Order documents, Customer Orders, Invoices, Advance Ship Notices and
Motor Carrier Information to multiple trading partners. (94-95)
·
Order Entry System – (Lead) Designed, developed and
implemented a GUI (graphical user-interface) based Customer Order Entry System
in Progress V7, which was integrated into the client’s Symix ERP system.
(95-96)
·
Service Charge Invoice System - (Lead)
Designed, developed and implemented a fully integrated “service charge invoice”
sub-system in MFG/PRO whose function was to break out service charges from
sales orders into separate invoices. (Dec 01-Feb 02)
·
Wiring List
Database – (Lead) Designed and
developed a complete Wiring List System for use by Engineering in the design of
circuit connections. (1993)
·
Municipal
Permit Tracking System – Developed
and debugged maintenance and inquiry screens for Progress-based permit tracking
system in a major
·
Receipt
“Roll-up” System – (Team member)
Developed and tested an inventory receipt rollup processing module to combine
separate stock receipts from the warehouse system (Robocom RIMS) into the ERP
system (QAD MFG/PRO). Purpose was to correct sample size calculations within
the quality assurance system (Pilgrim Q*MIS). (Jul 01-Sep 01)
·
Data
Collection – (Team member)
Modified and debugged a three-processor client-server Data Collection system
utilizing an Intel-based controller connected to the production machine and the
Progress Windows client. (Apr 96-Jun 96)
·
Analysis
and Testing – (Team member) Performed various tasks related to analyzing processes and
testing modifications and solutions to problems. Became proficient with all
forms of testing including regression testing. Proposed creative solutions to
long-standing problems such as reducing DSO, reducing purchasing administrative
lead-time and increasing accuracy and timeliness in EDI Advanced Ship Notices.
(Jun 02-Aug 02)
Application Modifications and Reports
·
Modified many
MFG/PRO financial reports to import directly into Excel cutting down time for
the accounting department.
·
Made modifications
to Trinary EDI package interfaced with MFG/PRO.
·
Completed a
backlog of MFG/PRO report modification requests including: Shipping Report, Purchase Order Print,
Inventory Comparison Report, Inventory Evaluation Report, Work Center Loading
Report, Sales by Group Report, Work Order Cost Report, Promotional AP Reports, Physical Inventory Tag Quantity vs. System Quantity report.
·
Designed and
developed multiple system enhancements for multiple companies related to the
following business application systems: Engineering, Customer Order Processing,
Inventory, MRP, Accounting, Purchasing, Warehouse Management and Production
Control.
·
Developed
budgetary estimates and detailed specifications for programming projects.
Advised clients on feasibility of ERP projects and most efficient directions to
pursue.
DATABASE ADMINISTRATION (DBA):
·
Performed
Progress database administration and system configuration services for clients:
single to multiple volume database conversions, index rebuilds, database dump and
reload processes, backup management, archive and delete proposals, resource
needs assessments, etc.
·
Improved a client’s system performance to be roughly 10 times faster by
utilizing Progress database tuning techniques. (Aug 00)
·
Upgraded
MFG/PRO from 7.4f to 7.4i. Reapplied
modifications (100+ programs). (Oct 99-Apr 00)
·
Created data
translation maps to convert data in an IBM System 38 file structure to
appropriate Symix database fields. (1995)
·
Orchestrated a
data merge between two MFG/PRO systems (Versions 7.4i & 8). Developed custom replication system to
transport and transform data. (Oct 99-Jan 00)
·
Set up a
custom data replication system between MFG/PRO and OnContact Sales Quote system
running on MS-SQL server via ODBC connection across a network. Developed software to synchronize the data
between the Progress database and the SQL server database. (Oct 99-Jan
00)
·
Assisted with
the implementation of a Central Database Management (CDM) Data Replication
System. (Oct 99-Jan 00)
·
Have written
many “one-time” scripts to transform data from one format to another on an
“as-needed” basis.
Training:
·
Trained
clients in Progress V6 and V7, Progress system administration and Symix
administration. (1994-1997)
·
Conducted
client training in V8 windows GUI development. Designed curriculum for this
class. (1996)
·
Conducted code
reviews explaining logical operation and data flow.
·
Conducted user
training in the development of Progress data-mapping routines.
·
Acted in a
mentoring role as senior developer and resident Progress expert for several
clients.
E-business
and web:
·
Installed Frontstep eCRM for company’s internal use. Performed import of
ACT! Contact database and Harris database via Excel spreadsheets. Modified
database and screens to handle custom fields. (Nov 00-Apr 01)
·
Developed Intranet pages with resources for ERP consulting
group.
·
Acted as pre-sales technical analyst during sales calls.
Other
qualifications:
·
Member of APICS. Certified in
Production and Inventory Control (CPIM).
·
Member of the
International Who’s-Who of Information
Technology.
·
Technical
advisor to investment firms.
·
Officer-at-large
of the Ohio Progress Users Group.
·
Training
courses: QAD Product Training Course, Progress Tuning Seminar.
·
Associate
Member of the Midwest MFG/PRO User Group.
·
Member of the
·
Member of the
Better Business Bureau.