Might be available
(Updated 2022-01-04)IBMi JDE Developer Analyst
Oakville, Ontario, Canada
Native English, Beginner French
- 30+ years experience on IBM Midrange Languages (RPG, CL)
- 20+ years experience JDE World
- 30+ years experience on IBM Midrange Platform
Skills (67)
Coding Standards
DATABASE ANALYSIS
ISERIES
JDE
EXCELLENT COMMUNICATION SKILLS
AS/400
CODING
CLP
RPG
RPG/400
Data Analysis
Midrange
AS400
SYSTEMS ANALYSIS
INVOICE
Software Training
SALES ORDER
HUMAN RESOURCES
MAINTENANCE
AP
PRICING
ACCOUNTING
Application Support
GENERAL MAINTENANCE
MAPPING
ACCOUNTS PAYABLE
SHIPPING
HR
ORDER ENTRY
DOCUMENTATION
TECHNICAL SPECIFICATIONS
REPORT WRITING
INVOICES
BUYING/PROCUREMENT
PROCESS FLOW
AR
GL
SYSTEM TESTING
BILLING
A/P
FINANCE
G/L
PURCHASING
SCHEDULING
FIXED ASSETS
PRODUCTION SCHEDULING
PRODUCTION PLANNING
JOB Costing
Digital Marketing
Python
Queue
SECURITIES
ADP
C++
SALES REP
C#
HELPDESK
QUEUE MANAGEMENT
Marketing
FABRICATION
Standard First Aid
LASER
BUYER
Role-Playing Game
TOPO
ROBOTICS
RF
Professional Experience
Owner
Pearl Computer Services Inc
1998-03 - Present
Partner/Owner
KelMar Inc
1998-03 - Present
JDE Analyst Developer
Eat 'N Park
2016-09 - Present
• analysis and documentation of current Advanced Pricing setup • maintenance and support of JDE World V9.21 • custom development to work with JDE World V9.2 • automation of interface to/from CrunchTime software • upgrade of JDE A9.2 to A9.4 • AS400/iSeries ◦ RPG, RPGLE, SQLRPGLE, CLP, CLLE ◦ AS400 SQL, AS400 Query, DBU
AS400 Analyst Developer
Domclean Limited
2019-06 - Present
• ADP Migration ◦ Assist with Analysis & programming of ADP front-end migration from PaySpecialist • WorkForceNow ◦ Write new import from WorkForceNow for Employee Profile & Job Costing on AS400 • Ongoing AS400 Support • AS400/iSeries ◦ RPG, RPGLE, SQLRPGLE, CLP, CLLE ◦ AS400 SQL, AS400 Query, DBU ◦ APLUS Software
IBMi Developer
via SI Systems
2021-06 - Present
• Buyer Specific Reporting Project ◦ Member of the team responsible for converting all of the combined Purchasing reports over to being produced at the Buyer level ◦ Printed reports and XLS version are then gathered and email to the buyer • Digital Marketing Campaign Project • PFG 445 Finance Project ◦ Convert existing calendar year finance reports to new 445 calendar reporting
JDE Analyst Developer
via Midrange
2021-09 - Present
• member of the team responsible for A92 to A94 upgrade • custom changes to JDE A92 to be retrofitted to A94 • help with security and setup issues
JDE Analyst Developer
Purdue Pharma
2020-02 - 2021-02
• short term contract to help existing staff with the following projects within JDE World V9.3: ◦ BMO Banking - EFT and Positive Pay * Write new programs to convert Cheque Payment Groups into flat files to be sent to BMO * Write new programs to send Positive Pay data to BMO ◦ 3PL EDI Integration * 940 - Warehouse Shipping Order, Outbound * 943 - Warehouse Stock Transfer Shipment Advice, Outbound * 944 - Warehouse Stock Transfer Receipt Advice, Inbound * 945 - Warehouse Shipping Advice, Inbound ◦ Assist with other support issues as required • Utilities ◦ Aldon CMS • AS400/iSeries ◦ RPG, RPGLE, SQLRPGLE, CLP, CLLE
AS400 Analyst Developer
National Steel Car
2019-07 - 2020-05
• Production Planning Projects ◦ Fabrication Work Orders ◦ Fabrication Product Nesting ◦ Fabrication Production Scheduling • AS400/iSeries ◦ RPG, RPGLE, SQLRPGLE, CLP, CLLE ◦ AS400 SQL, AS400 Query, DBU
Senior Analyst Developer
Bunzl Canada
2017-10 - 2019-05
• Acquisition Conversion Project ◦ Responsible for the custom conversion programs of Bunzl acquisition companies onto inhouse designed ERP system, MyBis ◦ iSeries V7R2 * LANSA, COBOL, CLP/CLLE
JDE Analyst Developer
Purdue Pharma
2017-01 - 2017-03
• short term contract to cover medical leave • JDE World V9.3 support, new development, daily backup support • Utilities ◦ SupportWorks (helpdesk call management) ◦ Aldon CMS • AS400/iSeries ◦ RPG, RPGLE, SQLRPGLE, CLP, CLLE ◦ AS400 SQL, AS400 Query, DBU
JDE Analyst Developer
Nelson Education
2016-08 - 2016-09
• project based contract to make custom changes & new development within JDE World, following all JDE World coding standards • AS400/iSeries ◦ RPG, CLP ◦ Aldon CMS
AS400 Analyst/Developer
via Cartesian
2015-09 - 2016-07
• part of the team responsible for the development of the new Fibre Auto Implementation software module • AS400/iSeries V7R2 ◦ SQLRPGLE, RPG-Free, CLP, CLLE ◦ AS400 Query, SQL, DFU, DBU ◦ Turnover
iSeries & JDE Analyst Developer
via TeamCain
2015-01 - 2015-11
• JDE World 7.3 ◦ Customize of AP/EFT to match Bank's specific requirements ◦ RPG, RPGLE ◦ iSeries Query
AS400 Analyst/Developer
LECO Instruments Limited
2015-04 - 2015-08
• Systems analysis of current software, develop enhancements & custom programming • IBM AS400/iSeries V5R3 ◦ RPGLE, CLP, CLLE ◦ AS400 Query ◦ APLUS software
AS400 Analyst/Developer
Coppley Ltd
2015-05 - 2015-07
• Modify custom (interactive) order entry system to allow for batch feed from website, or directly from customers • AS400/iSeries ◦ RPG, RPGLE, SQLRPGLE, CLP, CLLE ◦ AS400 Query, SQL, DFU, DBU ◦ Hawkeye Pathfinder
AS400 & JDE Analyst/Developer
Purdue Pharma
2014-10 - 2015-06
• JUMP Project (JDE World upgrade 9.1 • 9.3) ◦ New development and enhancements to JDE Manufacturing module • IBMi (AS400, iSeries) V7R1 ◦ RPG, RPGLE, SQLRPGLE, CLP, CLLE ◦ SQL, iSeries Query ◦ SVR & Aldon CMS (Change Management) ◦ RF-Smart
AS400 Analyst/Developer
via Dytrem
2015-04 - 2015-05
• Assist in system conversion from Daffron • Harris NorthStar software • Responsible for data mapping, extract program, edit reports to allow data clean-up • AS400/iSeries ◦ RPGLE, CLLE ◦ AS400 Query
AS400 & JDE Analyst/Developer
New Jersey Resources
2014-03 - 2014-06
• PragmaCAD • JDE Interface ◦ Brought in for a short-term project to assist full-time team, to help with the re-write of the interface from the new PragmaCAD software to JDEdwards World 9.3 WorkOrder module ◦ IBM I (iSeries, AS400) V7R1 ◦ Productivity Tools * TurnOver ~ Change Management * Showcase Query * SalesForce.com (expense & timecard entry)
AS400 & JDE Analyst/Developer
Tyco IS Canada
2013-01 - 2014-02
• AS400/iSeries ◦ RPG, RPGLE, RPGILE, SQLRPGLE, RPG-Free, CLP, CLLE, COBOL ◦ Tools * AS400 Query, AS400 SQL, DBU * Aldon Change Management ◦ Software * JDEdwards World 7.3 * WorkDay
Member
Tyco Canada
2013-08 - 2014-02
project to streamline applications on multiple platforms to common platform ◦ Responsible for applications on the AS400 platform ~ include JDEdwards World (HR, Payroll, GL), homegrown/custom (Sales, Order Entry, Purchasing, Billing, AR, AP, Job Costing, Sales Rep Commissioning) ◦ Provided analysis and documentation of all user reports & interfaces related to the AS400
Member
Tyco GLOBAL project to implement WorkDay
2013-01 - 2013-08
an Enterprise-Class SaaS solution for managing global businesses ◦ Provide technical and analytical support for the Tyco IS and Tyco SP conversion teams ◦ Responsible for development and data analysis from Tyco IS Canada's conversion from JDE World HR Module • WorkDay ◦ All phases of testing unit, UAT, parallel, and WorkDay Release 20 system testing
JDE Consultant/Developer
KIK Custom Products
2010-03 - 2013-01
• AS400/iSeries ◦ RPG, RPGLE, RPGILE, SQLRPGLE, RPG-Free, CLP, CLLE ◦ Tools * AS400 Query, AS400 SQL, DBU * Aldon Change Management ◦ JDEdwards World 7.3 • Harmony Elkhart ◦ Member of the team responsible for converting the Elkhart Indiana Plant from PRMS to JDE World • Harmony Gainsville ◦ Member of the team responsible for converting the Gainsville Georgia Plant from MfgPro to JDE World • Project Plug ◦ One of the 2 developers assigned to create a new Costing & Pricing Application, within JDE World
JDE Consultant
Alcon Canada
2009-09 - 2010-03
• AS400/iSeries * RPG, RPGLE, RPGILE, SQLRPGLE, RPG-Free, CLP, CLLE * AS400 Query, AS400 SQL, DBU * JDEdwards World 7.3 • member of the team responsible for bringing Alcon Japan onto the "Global Model Company" version of JDE World • writing & submission of Technical Specifications for review and user signoff/approval • all programming was done based on Functional Specs and Technical Specs that laid out the the user requirements, and coding details • all code changes and unit testing fully documented and signed off by Team Leads and B.A.
• all programming must meet all JDE Programming Standards and Naming Conventions.
• all programming must meet all JDE Programming Standards and Naming Conventions.
Consultant Functional/Technical
ADT Securities
2006-12 - 2009-06
• AS400/iSeries ◦ RPG, RPGLE, RPGILE, SQLRPGLE, RPG-Free, CLP, CLLE, COBOL ◦ Tools * AS400 Query, AS400 SQL, DBU * Aldon Change Management ◦ JDEdwards World 7.3 • JDE World 7.3 support ◦ functional support & technical maintenance for JDE applications ~ AP, GL, Canadian Payroll, and all Legacy interfaces into JDE * 2006 Canadian Payroll ~ update, user support and running of government forms * 2007 Canadian Payroll ~ update, user support and running of government forms * 2008 Canadian Payroll ~ update, user support and running of government forms ◦ technical member of team responsible for interface of JDE World Payroll to PeopleSoft * Provided functional analysis of existing JDE Payroll to ensure accurate mapping occurred between the 2 systems * Responsible for programming of all interface programs from JDE to PeopleSoft ◦ technical member of the team responsible for the interface of JDE World GL to Oracle GL * functional analysis support to User Community to assist in mapping to new GL * responsible for programming of all interface programs from JDE to Oracle • Legacy support ◦ Support and maintenance of AS400 Legacy Systems written in CLP, COBOL & RPG* ◦ Development of new applications and interfaces to US based systems ◦ Responsible for all functional application analysis for assigned projects
Supervisor, Application Support
National Steel Car
2005-07 - 2007-01
Senior Programmer/Analyst
2003-04 - 2005-07
• member of EnterpriseOne 8.11 implementation team - Phase II ◦ responsible for analysis, programming, testing & implementation of one-time conversion and on-going interface programs for the following: * Human Resources related files * Job/Occupation & Job Rate files • member of EnterpriseOne 8.11 implementation team - Phase I ◦ responsible for analysis, programming, testing & implementation of one-time conversion and on-going interface programs for the following: * Legacy A/P Vendor Master Information • EnterpriseOne * Legacy Open A/R Balances • EnterpriseOne * Legacy A/R Invoices • EnterpriseOne * Legacy Labour Detail • EnterpriseOne G/L • day to day support and maintenance of legacy AS/400 software ◦ Supply Management, Q/A, Finance, Engineering, Manufacturing, Labour/Payroll/HR modules • design and programming of new business application module add-ons • design and programming of system utilities • conversion of System/38 objects to ILE • perform upgrade from V4R5 to V5R2 • involved in database analysis, discovery meetings and process flow identification/documentation required for selection and possible conversion to SAP, GLOVIA, PeopleSoft Enterprise and/or Enterprise One solutions • design & programming of new order costing report • design and programming of new Vendor/Item Pricing module • automate process of Estimate creation by loading part information from BOM
Analyst/Programmer
Grant Forest Products Inc
2000-01 - 2003-04
• AS400/iSeries • AS400 Query, AS400 SQL, DBU • Aldon Change Management • Day to day support & maintenance of the 3 AS/400s and their JD Edwards World A73.11, programming & development using RPG* and CLP for both GFPI & Footner • Responsible for security on the AS/400 and within the JD Edwards application • Responsible for the implementation and maintenance of the DataMirror HA Suite software • Investigation and analysis of Cum 12 • Footner Forest Products • Implementation of new JDE production and CRP environment for sister company • Sales Projects • EDI - 810 Outbound Invoices • Implementation of ADX software, and integration to JDE • Purchasing Projects • Automated Vendor Item Pricing Upload • Implementation and maintenance of PO autofaxing software TLX/Fax/400 • Payroll Project • Customization of Canadian Pay Stubs • EFT of employee pay to CIBC and then to BMO
Vertex tables
2000-01 - 2002-01
• Customization of T4 and T4A slips • Maintenance of Vertex tables • Accounts Payable • EFT of payables to BMO • Maintenance Projects • Automated creation of Journal Entry from uploaded PLC data
Avondale Food Stores
1999-10 - 2000-12
Milwaukee Electric Syntax 8.1 to JDE 7.3 • EDI Purchase Order Receipt (810) Inbound • EDI Purchase Order (850) Outbound
Westburne Industrial Enterprises
2000-01 - 2000-01
Manual corrections of source to correct Y2K issues Westburne Industrial Enterprises Multiple AS/400s (S/36 environments) RPG II/III/400/IV (ILE), COBOL, CLP, OCL • Provide Westburne & Syntax knowledge to the Y2K team • Manual analysis and conversion of technical code affected by Y2K
Samsonite Canada Inc
1999-09 - 2000-01
September 1999 - January 2000 • Y2K "Legacy" Labour Entry and Payroll systems • Full analysis of application system, and identification of Y2K problem related areas • Modification/correction of program source and object • Full application testing and support of production implementation February 1999 - June 1999 • Analysis of "Legacy" Labour Entry and Payroll systems and their interface to the existing GAS Financial Application (Data-3 financials) • "nativize" Labour Entry and Payroll programs (original System3 converted to S/38) to AS/400 system standards and attributes • replace interface to "Legacy" MRP system and GAS Financials with interface to new JDE 7.3
Member of "Pathfinder"
Aluma Enterprises
1998-11 - 1999-01
team - Responsible for conversion/download of JDE F5.1 & A7.2 data to be imported into the new SAP system being implemented • Programming of new financial reports, on demand & maintenance of existing JDE software; release F5.1 and A7.2
Member of Y2K
CGI Information Systems & Management Consultants Inc
1998-03 - 1998-10
team
Member of team to convert
Samuel Manu-Tech Inc
1998-03 - 1998-06
Samuel Acme Strapping to JDE 7.3 • Customization of vanilla JDE to meet specifications • Design and implementation of new laser forms
CGI Information Systems & Management Consultants Inc
1997-06 - 1998-03
Senior on the Y2K
RPG II
1997-06 - 1998-03
III/400/IV (ILE), COBOL, CLP, OCL • Senior on the Y2K team to convert all the Syntax software, all customized software, all user queries, and DFU/DBU applications - to ensure Year 2000 compliance • Design and write Impact Analysis tools to work across multiple boxes and identify all possible date fields
Westburne Industrial Enterprises
1993-04 - 1997-05
12 AS/400s (S/36 env) (IT department outsourced to CGI) RPG II/III/400/IV, CLP, OCL, COBOL
Team Leader - Special Projects
ByteWare Message Plus, Hawkeye Pathfinder
1996-06 - 1997-05
• review & track all projects assigned to special projects team • monitor Special Projects support queue and resolve all issues in a timely manner • member of DASD-Cleanup Committee, responsible for many different DASD related issues • analysis of existing EOD process, to improve performance • software analysis - Robot Scheduler/Alert, ByteWare Message Plus, Hawkeye Pathfinder
Process Owner
Purchasing & Inventory
1996-01 - 1996-06
• member of the "Galaxy" project - to review, learn, and asses the feasibility of replacing the existing Syntax software with JDE 7.2 software • I was to concentrate on Purchasing & Inventory application issues, but needed to have a base knowledge of the entire package • it was decided that the JDE software did not completely fit our business requirements, and so this project was placed temporarily on-hold
Harris Rebar
1996-04 - 1996-06
RPG, CLP • retro-fit their custom modifications of J.D. Edwards 5.1, to the new release 7.1
Senior Programmer/Analyst
1993-04 - 1996-01
• member of "Special Projects" team responsible for design and development of new software, that could be utilized by any applications area within Westburne's 23 Divisions • involved in design and programming of new "automated" EOM/EOD system that included built-in recovery options, job accounting statistical information, and ease of operation for the 23 divisions that had to run their End Of Period process in a very limited time frame • conversion of existing System/36 code, RPG/36 and OCL to native RPG/400 and CLP • general maintenance of existing "Syntax" programs, belonging to any application • Special Projects "Team Deputy" (backup to Team Leader) • help with team administrative work, project/job tracking and distribution • representation of team at different Management meetings
Senior Programmer/Analyst
Hyundai Auto Canada
1990-02 - 1993-04
RPG II/III/400, CL • develop new modules for the Vehicles System, maintain current Vehicles System software, and it's interfaces to other systems (mainly Finance) • responsible for all areas of analysis, design, programming, testing, implementation, and user training • involved with data transfers between other computers; using RJE, DDM files, PC Support, BSC Lines • involved in S/38 to AS/400 conversion
Programmer/Analyst
Clarke Transport Canada
1988-06 - 1990-02
RPG III, CL, COBOL • modification and customizing of the Coles Express Transportation package
Programmer/Analyst
Columbus Computer Business Systems Inc
1986-10 - 1988-05
RPG II/III, CL • customizing the standard DATA-3 Manufacturing software, the Manufacturing Accounting software, the General Accounting System software, and the in-house Payroll software • Client List: • Tridon S/38, Data-3, MAS Burlington, Ontario • Long Manufacturing S/38, GAS Oakville, Ontario • Magna S/38 Milton, Ontario • PPG S/36, GAS Toronto, Ontario • Jacuzzi S/38 Toronto, Ontario • Johnson & Johnson S/38 Guelph, Ontario • Gabrielle Tires S/38 Toronto, Ontario • Samsonite S/3 to S/38 conversion, GAS Stratford, Ontario
S/38 Operator
Shaklee Canada Inc
1986-06 - 1986-09
RPG III, CL • run jobs according to daily schedule, including daily system backups, and daily control balances on inventory, invoice numbers, sales and shipments • documentation and daily logs of all jobs, listings and compiles of RPG and CL programs
Academic Background
Diploma
Mohawk College
2024-04 - 2024-04
MacLeod of Lewis Scottish Art's Centre
MacLeod of Lewis Scottish Art's Centre
2000-01 - 2009-01
Microsoft Virtual Academy
Microsoft Virtual Academy
2022-01 - 2002-01
Holy Family School
Holy Family School
1995-01 - 2000-01
Seneca College
Seneca College
2022-01 - 1993-01
Certifications
Standard First Aid
Learning Tree
CPR