SANDY GOFORTH
PROFILE
Expert AS/400 Support with 20 years’ experience, plus fifteen years’ experience with JD Edwards World 7.3.
Background includes leading numerous projects to provide technical solutions that enhance business operations.
Well versed in technical issue resolution. Also worked on JDA and JBA softwares.
TECHNICAL SUMMARY
Hardware: I Series(M25 9408), AS/400(720), IBM Risc 6000, HP 9000, Dell PCs, Magstar
3570, Ultrium LTO 3581, Ultrium LTO 3573
Applications: JDA, JBA, JDE World 7.3, JDE World 2.2, Softlandings, Computer Keyes,
ProData, Interlink/Whselink, Kronos, DCLINK, BRMS, PFSweb, MS Word, Excel
EXPERIENCE
THERMADYNE/VICTOR
CONTRACT
JDE BUSINESS ANALYST – 03/12 Present
Supported 3 locations under Victor Technologies Company. Heavy user support in Accounting,
Distribution and Manufacturing in JDE. Worked with the Dell offshore programmers and EDI business analysts to
implement new programs within JDE. Instrumental in putting together Kronos project to apply 4 new Service Level
Packs to Kronos software. Also worked with the Network and AS/400 Support to find solutions for users with
AS/400 issues. Ran SQL statements to fix errors within files in JDE when needed. Attended Project Management
meetings every Tuesday to go over projects within the Application Department. Assisted in Warranty Web project,
for the JDE side to find solutions for the Web customers as well as users in Tech Services in New Hampshire.
Worked closely with St. Louis Buisness Analysts to find solutions for our Customer Care Dept.
Worked with Dell’s helpdesk software(Opas), to take on problems and find solutions for all the JDE users in the
Company. Worked with JDE World 7.3 – Qume 11
PFSWEB 07/ 11 03/12
CONTRACT
IT ACCOUNT MANAGER –
Supported 5 companies under the Liz Clairborne Account. Heavy user support with the Accounting Users.
Worked with 2 platforms in JDE, JDE 7.3 and JDE 2.2 – Responsible for Web Orders coming down from
Demandware, then through EDI. Worked with Sales, Distribution, Purchasing, and Inventory modules in JDE, and
customized programs for Warehousing. Worked with EDI Purchase Orders, EDI Sales Orders, and EDI Item
Master issues. Heavily involved with Demand Ware programmers and JDE programmers, to find solutions for
problems for our Accounts. SQL fixes for data issues, and Iseries queries to troubleshoot data problems. Helped
solve issues with gift cards for customers. Created menus and updated UDC tables when needed. Tested issues
or problems in the Development environment. Attended Change Control meetings with developers every
Tuesday.
ALCON LABS, FT. WORTH, TX 04/ 11 07/11
CONTRACT
Business Analyst –
Support 13 countries(Latin America, including Canada) for JDE World 7.3, Qume 11. Troubleshoot JDE software
problems within Sales Order Management, Purchasing, Inventory, A/R, A/P, and Security. Write Test scripts for
changes made within JDE model software, for the Affiliate to test. Write documentation along with screen shots for
QA to test and approve. Test all changes made in software before sending it to affiliate. Move all changes through
Implementer software for production control to promote to production. Attend weekly developer meetings to set
priorities for country specific projects. Update Magic software to assign tickets to team members to solve issues.
Run SQL statements or AS400 queries to find problems within JDE. Create Change Control Request for affiliate
and managers to sign for completed projects. Work on 2 I Series, one for user testing/Q/A testing, and one for
production. Work closely with development team, as well as production control and Q/A with all projects.
PIZZA INN, INC., The Colony, TX
09/97 12/10
AS/400 Analyst & JD Edwards World Analyst –
Fully administer JDE World for the corporate office which chiefly encompasses utilizing the address book, SO
management, purchasing, A/P, A/R, general accounting, and inventory modules. Manage all programming and
operations projects for JDE on the I Series(AS/400), and hold senior responsibility for data security. Responsible
for IBM Scheduler and JDE Scheduler on the I Series. Develop reports for accounting, sales, purchasing, and
inventory through World Writers. Generate SQL statements for adds or changes in production and test
environments. Upgrade Softlandings(Turnover), Computer Keyes, ProData, as well as upgrade IBM OS 400 with
PTF’s. Responsible for all backups, saves, and offsite storage Conduct extensive diagnosis and repair on all
systems, and provided user support to approximately 40 employees.
PROJECTS COMPLETED:
Launched InterLink, to upgrade warehouse operations by incorporating barcoding technology.
Collaborated with InterLink programmers to interface the application with JD Edwards. Identified
additional hardware requirements, and purchased hardware so the system would effectively manage data
capacity. Ensured all files populated the new system correctly. Provided comprehensive user training.
Led a project to establish 4 new business unit warehouses, which primarily involved building new order
activity rules as well as general ledger accounts within JD Edwards. Performed comprehensive testing of
the system, and resolved technical issues prior to the successful launch.
Instrumentally contributed to an online ordering project, by leading the integration of PFSWeb with JDE.
Provided key guidance in redesigning Pizza Inn’s Internet portal, building more graphical user interfaces
to facilitate online ordering.
Contributed to team from in house distribution center to outsourcing to 4 distribution centers. Worked with
3 programmers on utilizing the JDE EDI programs. We currently outsource all distribution for Pizza Inn.
Manage the EDI reports daily for sales and Purchase Orders.
Tested the new mods for Pizza Inn Store Sales in JDE. All customized programs pull information from the
IFS folder on the I Series and put in new JDE files. Refresh the test environment and help end users
understand the new mod.
ADDITIONAL SKILLS IN JDE – WORLD
JDE Support – User Support
Support Users and Technical issues within JDE from the following:
Setup and maintain User Profiles
Setup and maintained JDE menus
Setup Library Lists in JDE
Setup Environments in JDE
Changed and updated World Writers
Setup and maintained new UDC tables
Setup/Changed Activity Rules
Setup/Changed JDE Screen Security
Setup and changed World Writers
Setup or changed Version List(Dream Writers) within JDE for users
Tested new modifications in JDE
Updated and maintained Next Numbering in JDE
Ran AS400 queries to verify data
Ran SQL statements when needed for file changes in JDE
Review History Logs on AS400 for any program errors in JDE
Responsible for EDI error reports in JDE
Trained Users for new or changes in JDE
Update Sleeper and IBM scheduler for job changes
Called Oracle and escalated problems for users
Called IBM for any AS400/Iseries software or hardware problems