Phone: (419) 666-7190 extension 351
Epitome
Bob has been active in the IBM midrange environment since 1988 and is an
IBM Certified AS/400 RPG IV Developer.
During that time, his knowledge and skills have progressed from entry
level technical skills, through Information Services management, and into
consulting to his current status as an expert and leader in IBM AS/400
technology, system design and development, RPG programming, security
administration, data modeling, EDI, and project management. Bob’s versatility is demonstrated by his
exposure to various industries (Manufacturing, Distribution, Retail, Services,
AEC, etc.). This broad exposure
provides Bob with a capability to quickly adapt to any business requirement,
communicate effectively to various business audiences at different technical
levels, and deliver unique solutions to complex business opportunities. Bob takes an active role in the IBM
environment having served as vice-president and currently as president of the
Northwest Ohio Midrange Users Group.
Employment History
January 2003 thru Present
– Adjunct Professor
·
Using The AS/400
·
Introduction To The AS/400
·
Introduction To Cobol
·
Introduction To RPG/IV
·
Advanced RPG/IV
·
Introduction To The Internet
·
Introduction to X/HTML
·
Visual Basic.Net
·
MS SQL Server
January 1992 thru Present
– IBM AS/400 Senior Consultant and Staffing Coordinator
·
Corporate Management
·
Staff Training and Supervision
·
Requirements Planning and Budgeting
·
Project Leadership and Management
·
Systems Design and Documentation
·
Security Administration
·
Data Modeling
·
Training
·
Systems Programming
·
Dynamic Subsystem Generation
·
Dynamic Program Generation
·
Command Interfaces
·
Programming
·
RPG II, III, IV/LE, SQL, VisualAge
·
CL, CLLE
·
Application Experience
·
BPCs
·
IPNet BizManager
·
J. D. Edwards
·
JBA
·
Kronos
·
Load Pro
·
PKMS
·
T/L Ashford
·
Premenos / Harbinger / Peregrine / Inovis
·
Sterling Commerce – Gentran
·
TL2000
·
Electronic Data Interchange (EDI)
·
X.12 Standards 3060, 4010, 4030
·
Documents Include (810, 812, 820, 830, 850, 856,
864)
·
Software – Spec Builder, Gentran and Trusted/Link
400
May 1989 thru April 1996
– Information Services Manager
·
Department Management
·
MIS Staff Training and Supervision
·
Requirements Planning and Budgeting
·
RFP Administration
·
Vendor Selection
·
Senior Level Programming and Systems Analysis
April 1988 thru May 1989
– Programmer Analyst
·
Systems Design and Documentation
·
Programming
·
RPG II, III
·
CL
Education
IBM
Certification - October 2002
AS/400 RPG IV Developer Exam - Certified
Hope
College
Bachelor of Business Administration, Computer Science Emphasis
Skills
|
·
RPG II; III; IV; ILE; SQL; VisualAge ·
Sterling Commerce Gentran ·
Websphere Application Development |
·
J.D. Edwards World ·
Inovis Formerly Harbinger/Peregrine ·
Kronos |
Technology
Solutions Incorporated
Major Projects and Experience
Bay Corrugated, Inc. - May 2005
thru May 2005
J. D. Edward’s Upgrade/Support
Upgrade Client to
A7.3.16. Included applying of paper
fixes upon completion of the upgrade, and supplying client with ongoing
support.
Technology utilized:
·
RPG III
·
SVR
·
Dream Writers
·
World Writers
·
Processing Options
Libbey Glass - March 2005 thru Current
JD Edwards/PKMS Interface
Developed multiple
interface programs to communicate data synchronization between JD Edwards World
and Manhattan Associates PKMS
Technology utilized:
·
RPG/LE, Embedded SQL
·
Manhattan Associates PKMS
·
JD Edwards World
Salter Housewares - August 2004 thru January 2005
EDI Interface from PKMS
Developed an EDI
interface into Inovis Trusted Link, utilizing the information from Manhattan
Associates PKMS software
Technology utilized:
·
RPG/LE, Embedded SQL
·
Manhattan Associates PKMS
Mennel Milling Company - January 2004 thru April 2004
iSeries & BPCs Programming Support
Providing remote
programming support, assisting client with custom modifications, in a BPCs
environment.
Technology utilized:
·
Constraints
·
RPG/LE
·
CL
Huffy Bicycle Company - August 2003 thru March 2004
JD Edwards World/Load Pro Programming Support
Providing remote
JDE support and assisting client with custom modifications and debugging of JD
Edwards and Load Pro programs predominately in the Shipping modules.
Technology utilized:
·
RPG/LE
·
CL
Mafcote - November 2002 thru Present
EDI Support
Providing remote EDI
support for trading partner implementations utilizing Inovis Trusted/Link.
Technology utilized:
·
IPNet BizManager
·
Inovis Trusted/Link
·
850, 810, 856 EDI Documents
Tranztec - November 2002 thru November 2003
EDI Support
Providing remote
EDI support for trading partner implementations utilizing TL2000 in conjunction
with Sterling Commerce:Gentran Server for the AS/400 and Inovis
Trusted/Link.
Technology utilized:
·
Inovis Trusted/Link
·
Sterling Commerce: Gentran Server for the AS/400
·
TMW TL2000
·
Choice EDI
·
204, 210, 990 EDI Documents
MCPC -
August 2002 thru Present
JD
Edwards World Programming Support
Providing remote JDE support and assisting client
with custom modifications and debugging of JD Edwards programs predominately in
the EDI & Sales Order Processing modules.
Also provided development support for new applications to enhance the JD
Edwards system for their specific requirements.
Technology utilized:
· RPG
III, RPG/LE, SQLRPG/LE
· CL
· OPNQRYF
· SVR
· Dream
Writers
· Sterling
Commerce:Gentran Server for The AS/400
Upham’s Corner Health Center - July 2002 thru July 2003
Electronic Data Interface
Remotely designed
and developed an interface to extract data and format it per the Massachusetts
state requirements for unclaimed fund reporting.
Technology utilized:
·
RPG/LE, SQLRPG/LE
·
Rejbi:MS – Menu System
Choctaw Nation Housing Authority - July 2002 thru August 2002
Commercial Development of Rejbi:HA Module
Worked with CNHA
to develop a scope outline for an AS/400 based housing authority software
package. In charge of the development
of the technical specifications, budget, and project time line. Assisted in the coding and controlled all
project interactions with the CNHA.
Technology utilized:
·
RPG/LE, SQLRPG/LE
·
Rejbi:DM – Database Maintainer
·
Rejbi:MS – Menu System
Homedics Corp. - April 2002
thru July 2002
Harbinger Support
Assisted the
client in the implementation of EDI, with customers in a retail environment. Design and modification of translation
formats, user exit programs and data file mapping programs.
Technology utilized:
·
Peregrine Trusted Link
·
PKMS
·
RPG/LE, SQLRPG/LE
Technology Solutions Inc. – January 2002 thru February 2002
“Client Liaison” Development
Redesigned the
existing “Client Liaison” to utilize Net.Data macros for retrieval of client
project information.
Technology utilized:
·
Websphere Application Server
·
Net.Data
·
RPG/LE, SQLRPG/LE
·
HTML
Libbey, Inc. - January
2002 thru April 2002
Electronic Document System Design
Designed and
assisted with the coding of a new electronic document middleware to create a
bridge between JD Edwards/CASE and Sterling Commerce Gentran applications. The system design is vertical in nature
providing the flexibility to define additional fields, without programming or
redesigning file layouts. The system
allows for the dynamic generation of data through formulas, field mappings,
constants and some program defined variables.
The system is designed to handle all EDI standards and documents
including XML. The rules processing is
completed in a cooperative processing environment utilizing multiple batch
servers and information transferred via data queues.
Technology utilized:
·
Sterling Commerce:Gentran Server For the AS/400
·
T/L Ashford
·
RPG, RPG/LE, SQLRPG/LE
·
CL
·
SVR
·
Dream Writers
·
Microsoft Project
·
Visio
Training on T/L Ashford
Designed a
training course for developing barcode labels using T/L Ashford. Instructed the course for several of their
programmers and support staff. Oversaw
initial barcode designs.
Technology utilized:
·
T/L Ashford
Northwest Ohio Midrange Users Group - December 2001thru January 2002
Website
Design Utilizing Net.Data
Worked with the users group to develop their
website http://www.nwomug.org. Features include: Online Reservations;
Dynamic map link based upon meeting location; Online Surveys; and Feed back
processing. Additional administrative
tools include for pre-printing attendee receipts and attendance tracking.
Technology
utilized:
·
Websphere Application Server
·
Net.Data
·
RPG/LE, SQLRPG/LE
·
HTML
· Java
Script
Homedics Corp. - January
2001 thru December 2001
Harbinger Support
Assisted the
client in the implementation of EDI, with customers in a retail
environment. Design and modification of
translation formats, user exit programs and data file mapping programs. Assisted in the upgrade and testing of
Harbinger E-Version 5.0 from Version 2.3.
Working with Trading partners and third party testing organizations with
implementation issues. Setup
communication file transfer utilizing send net file to automate the transfer of
data for testing purposes.
Technology utilized:
·
Peregrine Trusted Link
·
PKMS
·
RPG/LE, SQLRPG/LE
Lafayette Steel, Inc. - May 2000
thru April 2001
Harbinger Support
Assisted the
client in the implementation of EDI, with vendors and customers, in a
steel-processing environment. Design of
translation formats, user exit programs and data file mapping programs. Troubleshooting of their EDI system, working
with trading partners on implementation issues. Trained staff in using the software and assisted them with
questions and problems.
VisualAge RPG – Purchase Order Prototype
Designed,
developed and demonstrated a prototype client/server Purchase Order system
written utilizing VisualAge RPG. System
prompted users upon entry for login and generated the password file to
eliminate multiple login requests, and deleted it upon exit to insure system
security. Complete with cursor sensitive
help and dynamic menu system.
Technology utilized:
·
EdiFec’s Spec-Designer
·
Peregrine Trusted Link
·
RPG IV
Technology Solutions Inc. - December 1999 thru April 2000
VS/400 Sales Order Processing Software
Design, develop,
and test a commercial grade sales order processing software, with e-commerce
capabilities, for resale purposes. The
software has a GUI front end to the IBM AS/400 data; dynamically created SQL
statements allow clients to save selection criteria for master files.
Technology utilized:
·
RPG IV/SQL/VisualAge RPG
·
CLP
·
Triggers
·
Constraints
Bay Corrugated, Inc. - December
1999 thru April 2000
J. D. Edward’s Upgrade/Support
Upgrade Client
from A7.3.10 to A7.3.11 to achieve century compatibility. Included applying of paper fixes upon completion
of the upgrade, and supplying client with ongoing support.
Technology utilized:
·
RPG III
·
SVR
·
Dream Writers
·
World Writers
·
Processing Options
Harbinger/Premenos Support
Provide ongoing
remote support to I.S. Department for their EDI transactions. Setting up new Trading Partners, Documents
and Document Types. Design and write
generic reporting program for documents.
Assist in identifying and resolving PRRs issued from the automobile
industry.
Technology utilized:
·
RPG IV
·
Harbinger (Premenos)
Porcelain Products, Inc. - October 1999 thru December 1999
Payroll Century Compatibility Changes
Make changes to
the specified programs, by client, to utilize a long julian date in
substitution for a MDY date format, and write associated data conversion
programs for the related files. These changes allowed the file structure to
remain static while making the clients programs century compatible.
Technology utilized:
·
RPG III/IV
·
CLP
Libbey, Inc. - May 1998 thru December
1999
Hourly Payroll Gross Up
Redesign, Development,
programming and documentation a soft coded, rules based, union payroll gross
calculation module to interface with J. D. Edwards World Payroll Module. The modular system was designed to have
heavy integration into J. D. Edwards utilizing Action Code and Business Unit
Security; J. D. Edwards Menus; J. D. Edwards Utilities for lookups; etc. After calculating the gross payroll, the
system writes out records to the J. D. Edwards World Payroll transaction file. The system utilized a rule interpreter,
which was designed to work on a multi-iterative basis such that each
employee/day/rule type combination could run concurrently through different
threads (reducing the overall processing time required). To optimize the system for speed a database
server was designed to receive the output transactions from the interpreters
and write the transactions out to disk.
The rule interpreter and server programs were designed from a “BLACK
BOX” concept where the base structure of the system, once stabilized would never
have to be changed. The design provided
for modifications and additional rule values through the use of “Stored Value”
exit programs, which were called on a soft coded basis as required. Each stored value extension calculates a
single value and that result is placed into a user index for future retrieval
by the system. The new design provided
an easier and more manageable approach to a system, which inherently requires
maintenance at each contract change.
In many instances the payroll department will be able to handle the new
changes without I.S. involvement. I.S.
involvement is limited to writing simple stored value exit programs.
Technology utilized:
·
RPG III/IV/SQL
·
CLP/CLLE
·
OPNQRYF
·
Data Queues
·
Security Design
·
User Indexes (User Space)
·
Database Triggers
·
SVR
·
Dream Writer
·
World Writer
·
Processing Options
·
Dynamic Subsystem, Job Queue, Job Description
Creation
·
Dynamic Program Generation
·
Microsoft Project
·
Visio
Faxability
Design and
implement program modifications to the J. D. Edwards Order Confirmation
system. These changes allowed for the
faxing of shipping documents (Packing Slips and Bills of Lading). These changes utilized the use of the Who’s
Who phone numbers and FAX401 software, which when put together established a
strong base to build the fax capabilities.
Technology utilized:
·
RPG III
·
CLP
·
SVR
·
Dream Writers
·
Processing Options
·
FAX/401
Year 2000 - SARs
Apply J. D.
Edwards paper fixes to A7.3.9 release to maintain century complacency.
Technology utilized:
·
RPG III
·
CLP
·
SVR
·
Dream Writers
·
Processing Options
Kronos Time & Attendance
Assisted in the
implementation and customization of Kronos.
Involvement included the development of a custom-posting interface
between Time and Attendance and the clients custom payroll system; the
customization of Kronos to allow temporary badges along with restricted clock
usage; and the customization of various screens.
Technology utilized:
·
RPG III/IV
·
CLP
International Total Services, Inc. -
December 1997 thru May 1998
Service Billing System
Design,
development and document a Service Billing and Contract Administration System
to interface with J. D. Edwards World Accounts Receivable Module. The client had reviewed J. D. Edwards
modules and determined that they were insufficient to their needs. The new modules utilized a soft coded
approach to resolving the varied report and contractual obligations
imposed. When entering the contract the
reports required would be selected from a soft list. These soft selections and contract types would then determine how
the system generated invoices. The system utilizes triggers to update the labor
billing information from the historical payroll database when an addition is
performed, allowing the labor to be billed in a timely manner.
Technology utilized:
·
RPG III/IV
·
CLP
·
OPNQRYF
·
SVR
·
Dream Writers
·
Database Triggers
Cole National Corporation -
October 1997 thru March 1998
Remake Reporting System
Convert the Remake
Reporting System, for the vision products division. This conversion was from an
IBM System 3090 to a series of AS/400s.
The systems tracked and reported on various inventory and quality
control issues surrounding the manufacturing of contact lenses, frames and
lenses. This project required extensive documentation including Function and
Technical Specification, Unit and Integration Test Specification, Training and
User Manuals, along with promotional documentation.
Technology utilized:
·
RPG III/IV
·
Cobol
·
JCL
·
CLP
·
JBA
·
OPNQRYF
Unisys Corporation/Cole National Corporation - July 1997 thru October 1997
Store Physical Inventory
Conversion of a
store physical inventory system, from an IBM System 3090 to a series of
AS/400s. This project required
extensive documentation including Function and Technical Specification, Unit
and Integration Test Specification, Training and User Manuals, along with
promotional documentation.
Technology utilized:
·
RPG III/IV
·
Cobol
·
JCL
·
CLP
·
JBA
·
OPNQRYF
Lear Corporation - April 1997 thru July 1997
System 36 to AS/400
Conversion
Perform a
conversion from IBM System 36 to an AS/400, along with switching their EDI
software from Lewis/Wright to Harbinger (Premenos) and writing new interface
programs for ASNs, POs and Text Documents.
Technology utilized:
·
RPG II/III/IV
·
CLP
·
OPNQRYF
·
Harbinger (Premenos)
·
Hawkeye
American Identity (Formerly Osterman API) - May 1996 thru January 1997
Various AS/400 Program Modifications
Systems included
warehousing/distribution, third party data conversions and minority vendor
reporting.
Technology utilized:
·
RPG III/IV
·
CLP
·
OPNQRYF