JOSEPH FRED RANKIN
617 Montgomery Lane
Maryville, TN 37803
 [Send email to request phone number] 83-9853 Home
 [Send email to request phone number] 17-5759 Cell
[Send email using form at bottom]

Platforms/Skill Set
 AS/400, Sys/36, MAPICS, MacPac, RPGLE, SQLRPGLE, CLP, SQL, Cobol, Excel, Word,
Access, ODBC, Java, HTML, Code400, Perigrine Trusted Link EDI
 
EXPERIENCE
Feb 2002 – Present
 SALTON/Toastmaster - Job Title - Consulting Programmer/Analyst

·         Provided support for Perigrine Trusted Link EDI software to allow
migration of another ERP Package

·         Created, Tested and helped implement new EDI formats formats, user
file definitions and trading partner relations.

·         Automated inter-company purchase order/sales order process for new
company structure.

·         Migrated essential files need for conversion from Mapics to MacPac
environment. 

Jul 2001 – Dec 2001
 Erico International - Job Title - Consulting Programmer/Analyst
·         Create and support programs for accounts payable staff
·         Automate  Monthend Processes 

Apr 2000 – Jun 2001
 Ceco Door Products – Job Title - Consulting Programmer/Analyst
·         Applications Manager for MAC PAC 
·         Project Leader on Nomenclature Project for IT group 
·         Developed realtime Interactive Bookings/Sales program
·         Converted from Paymax Paryroll System to ADP

Oct 1999  -  Feb 2000
 Erico International - Job Title - Consulting Programmer/Analyst
·         Verify Y2K compliance for MAC PAC and legacy systems
·         Developed Sales Order Backlog Reporting System
·         Developed system to improve AP match of receipt to invoice
·         Revamped the process of NEMRA Transmissions from distributors
 
Sept 1998 – Feb 1999
 BEA Aerospace – Job Title - Consulting Programmer/Analyst 
·         Converted a system to create BOM and routings from MAC PAC to JDE
·         Converted a system to configure seat trim and finish from MAC PAC to
JDE
 
January 1998 – Sept 1999
 Gilbarco – Job Title - Consulting Programmer/Analyst
·         Implement Year 2000 compliance for all of Gilbarco’s legacy systems as
well as 
   MAC PAC systems. 
·         Develop Accounts Payable three way match from EDI transmissions.
·         Implemented new Version of VERTEX for Y2K compliance
·         Supported the manufacturing apps and provided support for all others. 

 
April 1997 – January 1998
 Erico International - Job Title - Consulting Programmer/Analyst
·         Implemented Year 2000 compliance for MAC PAC systems.  
·         Implementing global compliance for all divisions of ERICO.
·         Implemented automatic fax capability for PO’s, Sales Order Ack and
Invoice.
·         Developed system to search database for all fields containing a
particular set of data 
       (for instance find all fields that contain product class data)
 
Sept 1996 - March 1997
 The McKinley Group     Job Title - Consulting Programmer/Analyst
 GLOBE BUSINESS FURNITURE in Henderson, TN.  
·         Designed detailed history inquiry screen/report.
·         Provided daily support for users in all areas of MacPac.
·         Created configured costed Bill of Material program.
·         Reduced Automatic Order Release from 2-hour runtime to 12 minutes.
 
May 1995 - Sept1996 
 Robertshaw Tennessee      Job Title -  Mac Pac Programming Coordinator. 
·         Responsibilities for the Manufacturing environment of Mac Pac.
·         Responsible for all upgrades of Mac Pac and participate in all phases
of MIS. 
·         Developed system to move Routings, Product Structures and Workcenters
from One manufacturing plant to another. 
·         Upgraded from Version 8.2 Mac Pac to 9.5.

June 1994 - May 1995
 Nippondenso Tennessee  Job Title - Information Systems Specialist.  
·         Design new Domestic Order System for North American Affiliates of
Nippondenso. Nippondenso is the world's largest manufacturer of electronic
automotive parts.  
 
May 1990  - June 1994
 MTD Inc.   Job Title - Systems Manager.  Responsible for all computer
operations in two plants in West Tennessee (80 end-users) Both plants are MAPICS
shops.  Have experience with bar-coding, and I have written many bridge programs
to interface with MAPICS.  Very proficient with PC Support and most of the major
products for the PC (DOS applications as well as Windows).  Very proficient with
Operations within the AS400 such as Communications, Configuration, Security,
Disaster recovery and Backup frequency.  AS400 programming skills include Control
Language , Screen Design Aid, Sub-File Programming within AS400 RPG, use of
externally described files and printer files within AS400 RPG, but have
experience programming in Pascal, COBOL, Basic, and Assembler Language.  From Oct
1993 through Jan 1994 successfully converted both facilities completely from the
System 36 to Native AS400 code.  Also was instrumental in converting the two MTD
plants in Mississippi. 
 
January 1988 - April 1990
 MTD Inc.,   Job Title -  Purchasing Expediter/Buyer  Responsible for the
purchase of over 2500 items for assembly of outdoor power equipment.  Mainly
making sure the flow of inventory was timely.

EDUCATION
September 1989 - May 1992
Lambuth College   Degree - Bachelor of Science in Computer Information Systems  
Transferred from University of Tennessee to finish my degree
 
September 1978 -  May 1985
 University of Tennessee at Knoxville-  Major areas of study were Computer
Science, Psychology, and Accounting.