Owner
Pearl Computer Services Inc
1998-03 - Pågående
Partner/Owner
KelMar Inc
1998-03 - Pågående
JDE Analyst Developer
Eat 'N Park
2016-09 - Pågående
• 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 - Pågående
• 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 - Pågående
• 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 - Pågående
• 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.
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
• 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
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
• 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