Scott Johnson Consulting LLC
Clemmons,NC 27012
Tel:
Cell:336-***-****
Email: ***************@*****.***
SCOTT JOHNSON
Summary
I have been working with RPG and JD Edwards World software my entire carrer. I have 20+ years of creating and modifying most of the JDE modules (Distribution, Manufacturing, Inventory, S/O, P/O, G/L, A/R, A/P, F/A, EDI, Advance Pricing). I was an employee and senior technical consultant for JDE for over five years and have extensive training and hands on expertise. I have a proven track record for being ahead of schedule and below budget with an emphasis of getting it right the first time.
Since 2003 I have also been writing programs using .Net
Programming Languages: JDE Enterprise One, RPGIII, RPGIV, RPG ILE, CLP, Cold Fusion, JavaScript, Visual Basic, C#.
Distribution
With 20+ years experience modifying and using the distribution system I have made complex and simple modifications through out the module. Which include but not limited to:
Advance Pricing including getting and feedng external pricing. S/O P4211 processing additional fields through the user index, splitting G/L entries for items with select criteria. Simple and complex changes to IT-Inventory Transfers (P4113).
Manufacturing
With RJ Reynolds I was responsible for all modications through out the implementation and world wide roll-out.
Experience
Electrolux, Anderson, SC 06/18-05/19
Software Engineer
Software: JD Edwards World A7.3
Electrolux manufactures redrigarators at this plant. Another programmer and I created a
complete production line replenishment system. Part of the process was to read all of
the work orders that were scheduled to be produced based on the production line
schedule. Then the program had to read the bill of material and determine if the
component quantity was available. If the item was available at the production line (ie.
The place in the line where it was needed,) then check the next component in the bill. If
not then check and identify if it’s available in transit, in a stageing location or elsewhere
in the warehouse. If the quantity was available check the next component else, write to
the shortage report.
Modify all the scrap programs to allow scrapping down to the production line level. The
user would enter the item and location on the line where it was scrapped. The program
had read all the item components down to the level entered creating G/L cost entries for
each component,
Programming was in RPG, RPGLE, RPG SQL.
Turner Industries 08/16-05/18
Software Engineer
Software: JD Edwards E1 9.2, World A94
Upgrade from JDE World to E1. Maintain the existing World applications while
Incorporating World modification into E1. Modify dozens of interfaces to work with E1.
Create new and modify existing UBE applications.
Japan Tobacco International, Geneva, Switzerland 02/16 – 04/16
Project Manager / Programmer
Software: Microsoft Visual Studio C#, ASP.Net, SQL, JD Edwards, Progress, Sun
EFAS
This is a short term project to upgrade and test multiple visual studio C#
and SQL applications.
Rollins, Inc. Atlanta, GA 10/15-12/15
Software Engineer
Software: JD Edwards
Follow-up to the initial A73 to A93 JDE upgrade. Ensured programs, queries, menu options, etc. were upgraded and worked in A93. This was a short term project to support them going live.
Larson-Juhl GA 07/15-10/15
Software Engineer
Software: JD Edwards
JDE World A73. WMS modifications and support. Added additional functionality to a new WMS implementation. Create custom functionality to generate suggestions from request. Create new video and report programs. This was short term project to help achieve their scheduled go-live date.
Rollins, Inc. Atlanta, GA 12/14-05/15
Software Engineer
Software: JD Edwards
Retrofit JDE World A73 to A93. Incorporated all their existing modifications into A93.
PBD Worldwide, Alpharetta, GA 04/14-08/14
Software Engineer
Software: JD Edwards
Retrofit JDE World A73 to A93. Incorporated all their existing modifications into A93.
Added additional functionality to A/B, Name Search, Sales Orders and others.
Synthes, West Chester, PA 10/13 – 02/14
Software Engineer
Software: JD Edwards
This is a short term contract to help Synthes catch up on their backlog. Wrote inventory valuation reports, modified existing programs, created video and server programs. All projects are developed using SDLC methodologies and Aldon CMS (Source control, Change Management process)
NAPA, Atlanta, GA 08/13-10/13
Software Engineer
Software: JD Edwards
Develop sales and inventory reports. Write programs for data extraction. Programs were written using RPG IV, RPG Free and RPG SQL.
Electrolux, Anderson, SC and Charlotte, NC 08/12 – 06/13
Software Engineer
Software: JD Edwards
Backfill 90% Responsible for gathering requirements, create, modify and manage all JD Edwards development.
Material Cost Analysis 10% Gather system requirements identify and map files and fields for a new EDW cost analysis system.
Japan Tobacco International, Geneva, Switzerland 01/09 – 07/12
Project Manager / Programmer
Software: Microsoft Visual Studio C#, ASP.Net, SQL, JD Edwards, Progress, Sun
EFAS, SharePoint
Archive old legacy data and reports. This entailed converting and migrating databases to MS SQL. Identified, ran and migrated all reports and converted them to PDF format in SharePoint. The reports could be easily retrieved with SharePoint & FAST search. The database is accessible by a query tool wrote in C#. Also wrote RPG, Progress and C# programs to automate and verify most of the processes.
Turner Industries, Baton Rouge, LA 05/08 – 12/08
JD Edwards Consultant
Software: JD Edwards, RPG
JD Edwards A7.3 to A9.1 upgrade. Retrofit thousands of base and custom RPG programs to A9.1. Create custom programs as needed.
Japan Tobacco International, Geneva Switzerland 03/07 – 04/08
Contract Programmer
Software: Microsoft ASP.Net and JD Edwards
Migraded their AS/400 JD Edwards inventory system to a Microsoft SQL database, created a multitude of ASP.Net forms to query the information. Created a comprehensive bill of materials and where used functionality into the system.
Alemite (Robert Half), Ft. Mill, SC 06/06 – 02/07
Contract Programmer
Software: JD Edwards A7.3
Created several custom forms which could be printed, emailed or faxed. I created programs to extract and upload data to ASP.Net. I created and revised programs to enhance MRP functionality.
Entertainment Distribution Co. (Robert Half), Kings Mountain, NC 03/06 – 04/06
Contract Programmer
Software: JD Edwards A7.3
Create interface programs to merge files from a JDE system in Indiana to a JDE system in Kings Mountain. Systems merged: General Ledger, Accounts Receivable, Accounts Payable, Purchase Orders, and Sales Orders. Analyzed and setup JDE-DRP for corporate evaluation. The company wanted to see if JDE-DRP could handle their planning requirements.
Murphy-Brown, LLC, Warsaw, NC 03/03 – 03/06
Contract Programmer
Software: JD Edwards A7.3
Modify and/or create programs using JD Edwards’s tools and programming logic.
Designed, programmed and tested dozens of report and video programs. Made several modifications to the Inventory system. Modify and/or create programs for inventory and sales analysis. Day-to-day support.
Alon, USA, Dallas, TX 02/01 – 11/01
Contract Programmer
Software: JD Edwards A7.3 with ECS
Modify and/or create programs using JD Edwards’s tools and programming logic. The areas of modifications include Advance Pricing, ECS Sale Order Entry, Invoicing, Inventory Management and Interfaces. Extensive enhancements were made to S/O Entry and Advance Pricing. Most of the enhancements were creating new videos and reports. ECS modifications included PetroEx and TopTek data interfaces to JDE “F4211xZ” files. Error reports, Platts and Opis interfaces to JDE Advance Pricing. Modifications to Exchange Agreement Management System.
Guardian, Greenville, SC 08/00 – 02/01
Contract Programmer
Software: JD Edwards A7.3
Modified and/or created programs using JD Edwards’s tools and programming logic. The areas of modification include Advance Pricing, Purchasing, Sales Order Entry, Inventory Management and Sales Analysis. Extensive enhancements were made to PO Generator, S/O Entry and Check Price and Availability. Most of the enhancements were creating new videos and reports.
Toyota America, Inc., Lexington, KY 01/00 – 08/00
Contract Programmer
Software: JD Edwards A7.3
Most of the work with Toyota was in EDI, Inventory Management and Shop Floor Control utilizing bar coding and DCLink. Responsibilities included designing specifications, programming, unit testing and creating user testing scripts.
Cameron Ashley Building Products (CABP), Dallas, TX 03/99 – 01/00
Contract Programmer
Software: JD Edwards A7.3
Modified and/or created programs using JD Edwards’s tools and programming logic.
The areas of modification include Advance Pricing, Purchasing, Sales Order Entry, Inventory Management and Sales Analysis. Extensive enhancements were made to PO Generator, S/O Entry and Check Price and Availability. Most of the enhancements were creating new videos and reports.
RJ Reynolds Int’l, Winston-Salem, NC & Geneva, Switzerland 03/95 – 03/99
Contract Programmer/Senior Application Consultant
Software: JD Edwards A6.2
Made extensive modifications to the Manufacturing and Inventory Management Systems. Analyze, Design, Program, Test and Implement changes in America and Europe. Build several reporting views using Cold Fusion.
JD Edwards & Company, Atlanta, GA (Head Quarters Denver, CO) 02/90 – 03/95
Senior Technical Consultant
Software: JD Edwards A4 – A6
As a JDE employee I had application training and made modifications to most of the JDE verticals. General Ledger, A/R, A/P, Fixed Assets, Payroll, Human Resources, Inventory, Logistics and Manufacturing.
Moody-Price, Inc., Baton Rouge, LA 12/83 – 01/90
Programmer/DP Manager
Software: JD Edwards F
Extensive work in Sales Analysis, Inventory Control, Purchasing, EDI and Sale Order Processing.
Education
Louisiana State University, Baton Rouge, LA, Computer Science