Bert den Hartog
Paris,Ontario
Summary
I would like the opportunity to demonstrate my analytical skills and logical thinking. I am an enthusiastic, adaptable and resourceful EDI developer accustomed to researching issues and analyzing data.
Overview
36
36
years of professional experience
Work History
iSeries RPG 400 Senior Programmer / Analyst
Challenger Motor Freight
04.2004 - 02.2023
- Created and maintained EDI trading partners, 204, 210 and 214 layouts using Cleo software
- Handled issues with fuel processing, the WISL rating package using the IFS and the lane scheduler
- Developed and implemented the hourly miles process, pending orders process, truck dwell time monitor, driver stat holiday pay calculation, driver termination screen, estimated revenue, Toyota lane scheduler and IFTA charges to payroll
- Created the Fuel Download and Reporting Process, significantly reducing the amount of time taken to error check the fuel purchase transactions of our drivers and improving the precision in data processing
- Created fuel download and fuel tax export automations using UIPath automation software
- Gained a basic knowledge of SQL, stored procedures and views
AS400 RPG Contract Programmer / Analyst
Lumsden Brothers Ltd
02.2001 - 04.2004
- Created and implemented a program to create and print order guides to be sent out to customers
- Automated the Cash & Carry charging process, resulting in reduced lost revenue by 37%
- Implemented an order hold system to ensure customer orders are not below specified minimum order quantities
AS400 RPG 400 Contract Programmer / Analyst
Babcock & Wilcox
05.1998 - 01.2001
- Developed an automated process to convert AS400 document control system files, reducing task time by 30% and providing successful downloads and loading into a new software package on new hardware
- Identified and updated all objects which required Y2K attention on an application by application basis, ensuring quality and accuracy of all data
AS400 RPG 400 Senior Programmer / Analyst
Contrans Corp
11.1997 - 05.1998
- Redesigned and developed the NTS fuel system to incorporate yard fuel and Shell card transactions, eliminating the existing yard fuel and Shell download and reporting procedures
- Implemented two releases of EMS trucking maintenance software and applied custom modifications
AS400 RPG 400 Senior Programmer / Analyst
The Cambridge Towel Group
07.1995 - 11.1997
- Installed a stock locator system to improve the accuracy and visibility of finished goods inventory and decrease order pick time by approximately 4 hours per week
- Wrote procedures to allow 'Put Up', 'Pull', and 'Transfer' of inventory to and from a stock location system using radio frequency scanners
- Converted data from Systemetrix AR, AP and GL financial systems to J.D. Edwards integrated financial package
- Created real-time data interfaces from the existing invoicing system to J.D.E
- Developed an application to enable inventory to be conducted using RF scanners
System 38 RPG III Contract Programmer / Analyst
The Agnew Group
12.1991 - 05.1995
- Designed and coded an Air Miles reporting system for 320 retail stores
- Assisted in the design and implementation of Point-of-Sales Polling Stations, streamlining the process for faster responses
- Created files from the existing System 38 Item Master files, downloaded onto a PC and loaded into a new package on new hardware
System 38/AS400 RPG III Programmer / Analyst
The Cambridge Towel Group
06.1987 - 12.1991
- Involved in the migration from System 38 to AS400
- Provided guidance, directions and instructions to junior programmers
- Installed hardware and trained two remote sites on proper usage and operation
- Designed and coded the initial system to receive purchase orders using EDI and incorporated into existing order system
Education
SQL Beginners Course -
Conestoga College Institute of Technology And Advanced Learning
Doon Campus, Kitchener, ON12-2010
Computer Programmer / Analyst Program -
Conestoga College Institute of Technology And Advanced Learning
Doon Campus, Kitchener, ON06-1987
Data Processing Concepts -
Conestoga College Institute of Technology And Advanced Learning
Cambridge Campus, Cambridge, ON01-1985
O.S.S.D. High School Diploma -
Galt Collegiate Institute & V.S.
Cambridge, ON06-1979
Skills
- EDI Management
- AS400 RPG Programming (III, 400, IV, ILE, Free)
- SQL/Embedded SQL in RPG
- Creating reports using scripts & views within Helpsystems Sequel Viewpoint
- CLP, DDS, SEU, SDA, QRY, DFU, DBU
- Excel
Timeline
iSeries RPG 400 Senior Programmer / Analyst
Challenger Motor Freight
04.2004 - 02.2023
AS400 RPG Contract Programmer / Analyst
Lumsden Brothers Ltd
02.2001 - 04.2004
AS400 RPG 400 Contract Programmer / Analyst
Babcock & Wilcox
05.1998 - 01.2001
AS400 RPG 400 Senior Programmer / Analyst
Contrans Corp
11.1997 - 05.1998
AS400 RPG 400 Senior Programmer / Analyst
The Cambridge Towel Group
07.1995 - 11.1997
System 38 RPG III Contract Programmer / Analyst
The Agnew Group
12.1991 - 05.1995
System 38/AS400 RPG III Programmer / Analyst
The Cambridge Towel Group
06.1987 - 12.1991
SQL Beginners Course -
Conestoga College Institute of Technology And Advanced Learning
Computer Programmer / Analyst Program -
Conestoga College Institute of Technology And Advanced Learning
Data Processing Concepts -
Conestoga College Institute of Technology And Advanced Learning
O.S.S.D. High School Diploma -
Galt Collegiate Institute & V.S.