DAVID C. GUTHRIE

***** ****** **.

Rockvale, Tennessee 37153

QUALIFICATION SUMMARY

A professional Information Systems Analyst, Programmer/Analyst and Project Leader with a background designing, programming, implementing and supporting manufacturing, distribution, retail, inventory, warehousing, and financial systems. Also has provided hardware expertise by setting up and configuring servers, desktops, and LANs. Personal strengths include strong work ethic, people skills, focused, flexible, detail oriented, quick learner, and good communicator.

Technology expertise includes:

Oracle,Sybase, DB2 SQL/T-SQL/PLSql PC/Server Setup & Configuration

Unix,Windows Business objects Some Oracle & Oracle Discoverer

IBM MVS Dos Mainframe A+, N+, MCP Networking Skills/LAN and WAN

TSO, ISPF, Roscoe, Vi MQ, COBOL, CICS Some VB and Web Development

Database Design Database tuning Microsoft Access, Excel, Word,Visio

DEC/Vax Mainframe Micro Focus Cobol Unix Scripts, XML, Sql Server, HTML

MVS JCL, CA7 VSAM, IMS, DHCP, IIS DFSort, Idcams, Abend-aid

EDI (850,810,856,846) Stored Procedures-Oracle&Sybase

Major Project Accomplishments:

Nissan Powertrain Assembly Plant - Project and Technical Lead over the analysis, design, new development, system enhancements and testing required to bring up the mainframe manufacturing scheduling, parts ordering and inventory control systems to support the Nissan power train assembly plant in Decherd Tennessee

Lifeway Christian Resources Store Systems - Designed and managed the setup, configuration, lockdown and rollout of over 1300 Windows 2000 Professional and Server machines to support the new JDA Win/Dss Retail Store System rollout for all Lifeway Christian Stores which also included: store system software modifications, configuration, and testing; network and subnet configuration including DHCP, IIS, WAN and dial backup setup; and credit card processing including testing and approval.

Genesco Shoes Customer Returns System (Journeys, J&M, Dockers, Keuka/Suregrip) - Project Lead over the analysis, design, development and implementation of a Customer Returns system to allow Genesco customers to return shoes, rate their condition and receive credit for the allowable returns.

PROFESSIONAL

EXPERIENCE

1/2020 Kforce Inc for Change Healthcare

to Nashville, Tennessee

4/2020

EDI Business Analyst

Provided analysis, support and assistance with EDI related projects and issues. Worked with ERA’s and daily investigation of support issues related to ERA processing. Utilized tools such as unix and ftp daily to perform job related tasks.

3/2019 Apex Systems for Dell/Boeing

to Nashville, Tennessee

1/2020

Technical Support

Provided broad international assistance to Boeing, Boeing subsidiary and 3rd party employees which included mainframe, unix and windows computer, phone, account access, travel and expense, printer and application troubleshooting and support.

5/2016 V-SOFT CONSULTING, INC for GE Appliances

to Louisville, Kentucky

6/2017

Programmer-Analyst

Analyzed EDI specifications for new GE customers, made program changes, tested and then implemented new edi customers into production. Environment was UNIX and CICS with programs written in micro-focus COBOL. SQL engine was Oracle.

2008 GENESCO, INC

to Nashville, Tennessee

4/2016

Lead Programmer-Analyst Wholesale Warehousing Systems

Analyzed, designed, developed, installed, maintained and supported a wholesale warehousing system utilizing the OMNIA software package. This also included numerous in-house developed interface systems to support the unique requirements of Genesco’s wholesale shoe business model. Responsibilities included:

Continuous year around implementation of EDI projects to allow new wholesale customers to send edi 850 documents to Genesco that would allow orders to be created in the Omnia system. These orders would then flow through the system and return numerous edi documents to the customer including the 810, 812, 846, 855 and 856 to name a few. Modifications to Cobol programs supporting these documents were required in many instances.

Project Lead over the analysis, design, development and implementation of a Customer Returns system that included online screens and backend modules written in Cobol that were initiated by online powerbuilder screens which utilized MQ in the Unix environment. System also had numerous batch Cobol programs that were initiated using Unix scripts that were scheduled using the Zena scheduling platform.

MQ queue setup and configuration in Unix environment

Responsible for writing SQL that resided in the Cobol programs but also supported SQL written for views and functions using the Oracle database engine

Responsible for designing and defining tables and indexes in both the test and production environment

Provided maintenance and support of handhelds utilized for physical inventory counting purposes and also for designing barcode applications for printing using the Bartender and PCmate applications

Created XML file interfaces when necessary utilizing an xml generating software tool and schema setup

Provided day to day systems maintenance and support

2007 SYMPHONY SERVICES, INC

to Nashville, Tennessee

2008

Sr. Programmer-Analyst / Client Services Technician

Multi-faceted/hybrid position providing both technical and customer interfacing support responsibilities. Technical support skills included analysis, design, and development of COBOL programs in a DEC/Vax environment, writing SQL queries in a SQL server environment and providing technical expertise to non-technical staff. Customer interfacing support provided front-line technical support to clients utilizing Symphony’s telecom management/rating systems.

2007 DELL

to Nashville, Tennessee

2007

Gold Tech Support Analyst

Provided P/C and Server support to Dell customers who purchased Dell’s top of the line technical support services. Consistently ranked in the top 10 out of 280 analysts for proper issue diagnosis and resolution. Left because of Dell’s plan to outsource our department.

2000 LIFEWAY CHRISTIAN RESOURCES

to Nashville, Tennessee

2006

Systems Analyst

Designed and managed implementation of PC and network setup to support new JDA Win/Dss Retail System in all Lifeway Christian Stores which included:

Server and client O/S (windows) and retail software configuration and desktop lockdown

Designing, writing and implemented an automated system to apply retail system patches and upgrades chain wide to servers and clients

LAN setup in each store and connection to WAN

Credit Card processing which included WAN communication to Credit Card Company and dial-backup capability in each store in the event WAN is down

Phone support to stores on system issues

Provided analysis, design, programming and support for an inhouse written warehouse distribution system residing on both Unix and Windows platforms utilizing Sybase transact SQL, VB and Unix scripts and assisted in the implementation of IRISTA, a rating, routing and manifesting system package by designing and writing the Sybase and Oracle stored procedure interfaces required for the systems to communicate.

Provided business objects and warehouse support to Logistics end-users.

1999 IBM for NMMC

to Smyrna, Tennessee

2000

Project Leader over Financial Systems

1990 NISSAN MOTOR MANUFACTURING CORPORATION

to Smyrna, Tennessee

1999

Project Leader over Manufacturing and Financial Systems

Analyzed, designed, developed, installed, maintained and supported Manufacturing, Inventory Control and Financial Systems. This included:

Project Lead over the new development and system enhancements required to bring up the manufacturing systems to support the Decherd power train assembly plant

Project Leader over Financial Systems

CICS (electronic communication) and batch applications, Micro Focus Cobol

IBM mainframe systems-COBOL, CICS, MVS, DB2, IMS, VSAM, JCL, TSO, Checkpoint/restart

Engine/Transaxle scheduling, parts gross, parts ordering, container tracking, receiving, vehicle usage, blank production, stamping production, bill of material, scrap resale, and bulk usage applications

Served as I.S. representative for Quality Month and United Way

Served as coordinator for Technical Vehicle Evaluation Program

Provided systems maintenance and support

1989 COM-DATA NETWORK, INC.

to Nashville, Tennessee

1990

Programmer/Analyst

Developed and maintained CICS applications that verified customer numbers and printed checks for truck drivers at truck stops across the United States.

1987 BRIDGESTONE U.S.A. (for Econo-Com Consulting Services, Memphis, Tennessee)

to Lavergne, Tennessee

1988

Programmer/Analyst

Designed, developed, and installed IBM S/36 applications in a manufacturing environment

1984 INGRAM DISTRIBUTION GROUP, INC.

to Lavergne, Tennessee

1987

Programmer/Analyst

Designed, developed and maintained numerous COBOL batch and CICS systems/applications on both and IBM OS/VS2 MVS 3083 and IBM S/36. Configured, cabled and genned two remote S/36’s and assembled and attached up to 15 terminals and printers.

1983 AMERICAN SYSTEMS, INC.

Nashville, Tennessee

Programmer

Maintained a homeowner insurance rating system, developed on micro-computers, using the CP/M operating system.

EDUCATION Trevecca Nazarene College, Nashville, Tennessee

B.A.; Management and Human Relations

GPA: 3.9

Nashville State Technical Institute, Nashville, Tennessee

A.S.; Business Data Processing

GPA: 4.0

Middle Tennessee State University, Murfreesboro, Tennessee

Dale Carnegie Course Graduate

Contact this candidate