Windsor, Ontario Phone:
Consultant with over twenty years experience offering on and off-site
development services to AS400 based clients. Well versed in conversation
work, readily adapts and succeeds in rapidly changing environments. With
exposure to all tiers of manufacturing giving experience in financial and
manufacturing based applications. Looking for contract and/or traditional
employment, hoping to utilize recent education in developing AS400 web
based applications.
Technical Background
ISeries/AS400 OS/400 PHP Microsoft
Office
CMS Software RPGLE/RPG400 HTML/XML VPN Client
JBA Software CLLE/CL400 Java Client Access
BPCS DB2/SQL400 JavaScript IBM S38
J.D Edwards DBU/DFU NetBeans COBOL
Software 2000 FTP Visual Basic 5.0 Unisys System 80
TechServe, Inc. 2007-Present
Four years developing and supporting corporate wide implementations of JBA
Financial Software. Developed endless FTP interfaces for importing,
validating and consolidating financials to corporate ledger.
Responsibilities include supporting daily help desk issues, developing
interfaces for new plant and software implementations. Environment included
multiple divisional AS400's, each having dozens of plants with their own
flavor of AS/400, JBA and/or supporting applications software.
CMS Applications Experience 2002-2007
Five years exclusively developing and supporting custom CMS software based
applications. Taken responsibility for over a dozen CMS based clients
gaining knowledge and understanding of CMS core applications and software
policies and controls.
Data Take-on and Conversions.
Involved in several conversion projects helping clients migrate to CMS
software. Uploaded and imported raw data parsing ASCII and comma separated
variable files. Resourced FTP and ISeries Distribution services, uploaded,
parsed, massaged, and validated incoming data.
Common updates...
Customer Master Vendor Master Part/Item Master
Pricing files Costing files Stockroom/Bin Inventory
Open Customer Orders Open Purchase Orders Master/Mixed labels and
history
Warranty files LOT Master files Bill of Material
Consolidated part/item inventory to single stockroom/part assignment based
on stock policies and CMS setup. Generated CMS inventory issue and receipt
transactions providing history for re-assigned stock.
Reports, Overlays, and Email Utilities
Modified report layouts for CMS Standard reports, custom overlays and forms
printing. Touching on all applications created an array of useful reports
and utilities. Custom reports offer email/fax options. Parsed and created
ASCII, .CSV and .PDF files.
Created FTP and Polling routines to intercepting EDI files. Uploaded,
massaged and validated against CMS setup files. Pre-validated and
downloaded for input to Trusted Link EDI software.
RF Solutions
Created and modifying countless inventory utilities for hand held and
vehicle mounted RF devices. Solutions supported scanning 2D labels and
subfile processing.
KanBan Picking Utility
Created hand held RF utility allowing scanned input of KanBan parts and
required pick quantities. Subfile display presented all locations available
allowing inventory picks from multiple locations. Completed picks initiated
transfers to user designated shopfloor stockroom for consumption. Pick
violations notified supervisors via program generated emails.
Building and Transfer of Mixed Load Labels
Streamlined existing RF utilities for building mixed load labels. Created
and built mixed loads keying PORCH for unique receiving log and Pallet ID.
Provided separate utility to transfer mixed load labels automating manual
break down of inventory items.
Fred Adamcryck 2 of 2
CMS Applications Experience
continued...
Label Creation and Printing
Accessed CMS controls to yield next available inventory tracking number.
Routines created labels updating variable length fields for printing user
defined label data. Created and printed non-serial labels recycling label
formats through reserved blocks of tracking numbers.
Created mixed load label routines that built, printed, and performed
stockroom transfers. Automated manual breakdown and re-building of labels
streamlining stockroom transfers.
Event Code Production Reporting
Streamlined existing routines to minimize user required input.
Modifications included automation of shift in/out procedures, defaulting
event codes and creating supporting subfile pop-ups. Existing applications
screens were re-designed to run on MPX devices.
Custom Add-on Applications
Production Reporting
Create production reporting applications collecting end of line production
scanning 2D labels. Keying and validating work orders and job setup in CMS.
Automating interface importing PC document files meeting GL reporting
requirements for production and labor.
CMS - Physical Inventory
Developed complete physical inventory control sub-system. Complete with tag
control and tag count sheets. Part quantities for selected stockrooms are
collected, reported and counted. Calculated net differences are used to
create +/- issue transactions to reflect counted quantities. Reporting
offered multiple views of quantity and cost variances.
Other related experience...
TechServe, Inc., Troy Michigan 2007-
Present
Midrange Custom 400 Solutions, Inc., Farmington Michigan
1997-2007
Custom Software Services, Inc., Troy, Michigan
1995-1997
Working with JIT based manufacturing company, implementing JBA financial
and manufacturing software applications. Modified existing JBA applications
and developed RF solutions to meet industry demands.
Ross Roy Communications Canada Limited, Windsor, Ontario
1992-1994
Developed marketing based applications and an edge in productive
programming. Supported and developed for incentive administration, customer
retention, direct mail, and telemarketing applications. Developing AS/400
applications.
Crown Cork & Seal Inc., Concord, Ontario 1991-
1992
Supported and developed applications in a mixed environment, AS/400, S/38,
and UNISYS system 80. Programmed in both RPG/400 and COBOL.
Redpath Sugars, Inc., Toronto, Ontario
1987-1991
Developed solid business solutions programming COBOL based applications in
a Unisys system 80 environment.