Resume
Jack Matthews acd6a0@r.postjobfree.com
SUMMARY
• More than 34 years of solid mid range (S/34, S/38, AS/400) RPG development experience engaging in
full life cycle applications design and development, support and maintenance of AS/400 legacy systems,
deployment and customization of software packages (e.g. JDE, MAPICS), and user training.
• Have high degree of technical AND functional expertise in the JDE World software packages (A7.3 &
A9.2.1) as well as MAPICS.
• Have solid business background in Manufacturing, Shop Floor Control, Inventory, Sales Order
Management, Distribution, Warehousing, MRP Planning, Procurement, Logistics, Order Fulfillment,
Financials, Address Book, and EDI.
• Have Global experience in implementing and supporting JD Edwards. (Canada, Latin America, and
Japan)
SKILLS
• ILE RPG, RPG IV, RPG III, CLP, DB2 Referential Integrity and Triggers
IBM i (i5/OS)
•
IBM S/34, IBM S/38, IBM i Series (AS/400)
•
DB2/400, SQL/400, Query/400, SEU, SDA, RLU, DBU, FTP, JDE CASE Tool, Client Access/400,
•
ShowCase, Reports Now, ROBOT, TURNOVER, HAWKEYE, ABSTRACT
JDE World A7.3, JDE World A9.2.1, MAPICS, MAPICS DB, MAPICS XA, NMC A/R Package, DSI dcLINK,
•
Varsity Logistics
Experience
Rawlings Sporting Goods, St. Louis, Mo
1/2012 – 11/2013
Director of Business Applications
Responsibilities:
• Design, implement, and maintain information systems that meet business requirements.
• Perform business and systems process analysis, interact with business users to learn and document
requirements.
• Write functional and technical specifications for various development projects.
• Code, test, and implement RPG ILE programs.
• Provide day to day support for the company’s production JDE A7.3 and A9.2.1 ERP system.
• Managed Development Staff to ensure proper priorities were being maintained as well as project
timelines.
• Collaborate with local Japanese 3rd party entities to complete the Japan Business Model
Highlights:
Resume
Jack Matthews acd6a0@r.postjobfree.com
Configured new environment for Japan office from scratch
•
Developed a complete set of documentation for brand new JDE users
•
Collaborated with Fujitsu to implement Japanese EDI with major customers
•
Collaborated with Toppan (Japanese Premier Oracle Support Group) to implement Japan localization
•
that we could do (or do easily) such as Japan Consumption Tax.
Collaborated with and developed data interface with Japanese 3PL.
•
o Incoming receipts o Inventory transactions
o Arrived receipts o Daily Snap Shot file
o Pick Tickets o Physical Inventory File.
o Shipped orders •
Developed interface from domestic PMM (Product Master Maintenance) to Japanese environment.
•
Once approved by ‘gatekeeper’, the system would automatically load the item into the various master
files, including Supplier/item file. The system would automatically generate a cost roll on this item.
Collaborated with Fujitsu to develop and complete Japanese Big Box EDI
•
Collaborated with Toppan (Japanese 3rd party JDE premier support group) to develop Japanese
•
Consumption Tax logic and reporting.
Completed the domestic Purchase Order approval process that would also autmotacilly generate a
•
digitized signature on an ‘e mail’ purchase order. This would eliminate the paper printing and the
manual ‘touching’ of the PO to be sent to supplier and the subsequent filing.
Closed the loop on item planning. Developed an import to Demand Solutions Planning system with
•
required JDE data (inventory, forecast, demand, bills, routers, scheduled receipts, etc). Once ‘Firm
Planned Orders’ were created in Demand Solutions, export these Firm Planned Orders and loaded them
into JDE MRP files. Buyers would then execute the ‘plan’ schedule in JDE.
Rawlings Sporting Goods, St. Louis, MO
4/2000 – 12/2011
Director of IT
Responsibilities:
• Managing the JDE A7.3 environment. Leverage application development to improve operational
efficiency and productivity.
• Support all Rawlings user base as needed.
• Manage IT budget for proper cost control
• Improve user access to company data needed for them to carry out their job performance
Highlights:
Upgraded JDE A7.3 from cum 4 to cum 9 to cum 15 without lost of any production time.
•
Implemented an Export Pro Forma invoice from our Costa Rica operation that meet US Customs and
•
Costa Rica Customs requirements that saved the company over $1MM.
Integrate Varsity Logistics with JDE
•
Resume
Jack Matthews acd6a0@r.postjobfree.com
Allowed Customer Service to view freight charges, tracking information, best shipping method,
o
less cost routing, etc.
o Interfaced shipments back to JDE in batch Ship Confirmation
Implemented JDE Warehouse Management system in our major Distribution Center.
•
Implemented RF scanning of Inventory movement in our major Distribution Center that resulted in our
•
Physical Inventory Variance to be around .01%.
Developed RF scanning Physical Inventory system that allowed our Physical Inventory to be done in half
•
the time and with half the staff. It completely satisfied Pwc audit requirements.
Designed and coded ATP program that became the core of Customer Service programs/reports.
•
Modified Sales Order Entry (P4211) to utilize true ATP (Available to Promise) to protect existing
•
customer orders.
Expanded ATP beyond stock products to also calculate ATP for:
•
o ‘W’ stock product (Assemble to order)
o Configured product (Make to order)
Integrated 5 different businesses onto our JDE platform.
•
o Review each business
o Develop a GAP analysis for each
o Develop a Project Plan for each
o Monitor the plan for any new development and to ensure it remained on time
o Document the process for the ‘new business SOP’
o Train users on the ‘new business SOP’
o Run CRP (Conference Room Pilot)
o Go LIVE
o Monitor post implementation issues/events
Designed and developed ‘Item Restriction Rules’ that prevented one Division from ordering another
•
Division’s products.
Automated Purchase Order Generation thru approval routes, digitized signature and e mail PO
•
Automated ST/OT creation for orders shipped from USA to Canada thru a virtual warehouse to account
•
for different currencies.
Designed and developed a work flow process to create new items which when approved by ‘gatekeeper’
•
would automatically load into various JDE Master files.
Developed a series of 1Z processes to update item category values, costs, base prices, etc. from a
•
formatted spreadsheet.
Implemented Turnover for our Change Management Control to become SOX compliant.
•
Designed and developed an interface from JDE to Approva to become SOX compliant on controlling
•
user access and authority to the system.
Atlas/Soundolier, St. Louis, MO
3/1986 – 04/2000
Director of IT
Resume
Jack Matthews acd6a0@r.postjobfree.com
Responsibilities:
Managing the MAPICS environment. Leverage application development to improve operational
•
efficiency and productivity.
Support all Atlas/Soundolier user base as needed.
•
Manage IT budget for proper cost control
•
Improve user access to company data needed for them to carry out their job performance
•
Consolidate two Division Headquarters into one Corporate Headquarters based in St. Louis.
•
Highlights
• Converted Atlas’ Labor Reporting system to be based off MAPICS
• Re wrote order entry system front end to use MAPICS data base.
• Implemented Warranty and Return system for Customer Returns and Repairs.
• Implemented an Automatic Freight Rating and Tracking system with an interface to MAPICS Order
Entry. Achieved an annual cost savings of $280,000 on a $25MM business.
• Implement ATP for the business
• Designed and coded an ATO system based upon rate production and live Supply and Demand.
• Converted MAPICS to become Y2K. 100% successful on 1/1/2000.
McQuay/Perfex, Washington, Iowa
5/1978 – 3/1986
MIS Manager 11/1983 – 3/1986
• Upgraded from S/34 5o S/38
• Developed total documentation for Operations, Program Changes, Incident Reports, User Operations,
and MRP II Documentation
DP Manager/Materials Manager 9/1982 – 11/1093
• Supervised the Data Processing Department
• Responsible for supervision of manufacturing, production scheduling, planning and inventory control.
• Responsible for Traffic/Transportation, Shipping/Receiving, plus a secition of the manufacturing
production floor.
• Implemented formal manufacturing systems for issuing shop floor paperwork, monthly sales projections
for production planning.
• Wrote miscellaneous programs in ILE RPG that generated various reports for user community.
Data Processing Manager 6/1980 – 9/1982
• Responsible for implementing an IBM S/34 and 9 modules of MAPICS.
• Responsible for all in house software development.
Quality Circle Facilitator 1/1980 – 12/1980
• Responsible for implementing the Quality Circle program at Perfex.
Resume
Jack Matthews acd6a0@r.postjobfree.com
Expanded the program from the initial 3 pilot groups to 12 circles throughout the entire facility.
•
Ended up with 100% of plant coverage with 70% of the work force voluntarily participating in the
•
program.
Shop Floor Foreman 8/1979 – 1/1980
• Supervised 2 production areas; fabrication department and a section of the Oil Cooler product line –
until 3rd shift was discontinued.
Qualtiy Control Inspector 5/1978 – 8/1979
• Responsible for maintaining records and checking various manufacturing processes at different stages
to ensure quality standards were being met.
• Coverage consisted of all production areas, fabrication department, plus receiving inspection.
•
Education:
Bachelor of Science in Computer Science
University of Iowa, Iowa City, Iowa
Bachelor of Science in History and Physical Education
South Dakota State University, Brookings, South Dakota
Trainings and Seminars:
•
• AS/400 Concepts Oliver Wight Forecasting
•
• RPG Application Programming Oliver Wight MRP Fundamentals
•
• RPG Application Design Oliver Wight Master Scheduling
•
• JDE World Foundation
• JDE World Technical
Other:
Speaker at Quest Collaborate 10 – DSI
Speaker at Quest Collaborate 13 – CDI