JOHN W. GRAHAM
239 Stonebridge Drive
Myrtle Beach, SC 29588
Home phone: [Send email to request phone number] 93-2953
Cell phone: [Send email to request phone number] 02-0618
Fax: (408) 668-1610
E-mail: [Send email using form at bottom]
******************************************************************
QUALIFICATIONS SUMMARY:
Senior Programmer/Analyst possessing extensive experience with IBM midrange
computers, including RPG programming of the AS/400. Wrote custom programs and
altered/adapted/integrated pre-existing custom programs. Worked with packages
such as LAWSON, LIMS and JDA. Worked with POS systems and EDI. Experience with
bar coding programming and handling hardware issues including those involving bar
code printers and scanners. PC experience with connectivity, LAN/WAN and server
issues, Windows, Lotus Notes, and the Microsoft Office suite including Excel.
Hardware experience includes:
* Assembly, upgrade, and repair of PCs and peripherals.
* Installing Ethernet switches and hubs.
* Installing, terminating, and testing CAT-5 Ethernet cabling.
* Installing industrial wireless networking hardware.
Software experience includes:
* Systems analysis and database design on IBM midrange computers.
* Design, write, and maintain packaged and custom IBM midrange applications in
a variety of industries (predominantly manufacturing).
* Configuring cabled and wireless PC networks.
* Establishing connectivity and enhancing interfaces between PCs/PC peripherals
and IBM midrange computers.
* Establishing interoperability between point-of-sale platforms and base
systems.
* Configuring and maintaining EDI, both packaged and custom.
* Installing and repairing Windows operating systems and PC office productivity
applications.
* Maintaining user profiles and security in both Windows Server and IBM midrange
operating systems.
* Static HTML.
August 2008 - Present
Hudson Law Offices - Myrtle Beach, SC
IT Consultant
An independent contractor working with scanning systems and coordinating the
firm's transition to fully integrate the "Office" suite of products with a law
management package - Time Matters or Practice Advantage (Lexis) and a billing
package, PC Law and spearheading the firm's move to a more "paperless"
environment. Also handle web site issues, e-mail issues, and troubleshooting of
the firm's Windows Server network.
March 2008 – July 2008
Manpower / CSI Technology – Myrtle Beach, SC
Field Engineer
Hired by Manpower Services for an assignment with CSI Technology (computer
consulting firm based out of Easley, SC). Prepared client PCs and printers in
several Horry County School schools for a switchover from Novell to Microsoft
Exchange, allowing for simplified logins and improved remote troubleshooting.
Changed teacher profiles over to new network scheme and ensured they could get to
their e-mail and old data.
March 1997 – January 2008
3V Chemical Inc. – Georgetown, SC
Senior Programmer/Analyst
Primarily hired for maintenance and enhancement of several commercial and custom
software packages on the IBM AS/400 in RPG/400 and CL:
* Lawson Technologies Accounting.
Wrote and continually enhanced interfaces between custom inventory, purchasing,
and order processing applications and Lawson’s A/P, A/R, and GL. Designed and
wrote custom forms, like A/P checks and A/R labels, with enhanced flexibility.
Maintained user profiles, security, and menus. Oversaw Y2K upgrades.
* LIMS Chemical Quality Assurance.
Designed and wrote inquiries to allow the production department better and
faster visibility on chemical sample testing progress. Tightened integration
between QA testing, production processes, and shipping procedures to
significantly reduce customer returns and resultant shipment costs. Designed and
wrote batch processes to summarize testing data for import into Microsoft Excel
spreadsheets for more flexible reporting. Modified analysis reporting to maintain
compliance with industry standards.
* Custom Production and Inventory Management.
Made extensive modifications to “homegrown” production and inventory management
applications to meet 3V’s international business needs and growing logistical
demands. Designed, wrote, and continually enhanced a versatile barcoding
application that overlaid the initial version of the inventory management system
that had depended heavily on manual entry. Expanded this barcoding application
later to improve production tracking and packaging, track products in bulk
storage, and track spare parts for equipment maintenance, allowing 3V to decrease
costs in personnel time, storage space, and product shelf life.
* Custom Order Processing and Shipment.
Made extensive modifications to “homegrown” order processing and shipment
applications to streamline a previously inefficient and inflexible set of
processes. Increased order entry speed of customer service personnel by
incorporating more default values into customer records and pre-loading them at
entry time, thereby allowing 3V to increase sales volume. Automated much of the
bill-of-lading and invoicing processes that had been largely manual. Integrated
picking and shipping document printing with an AS/400 faxing package to
automatically send relevant documents to customers and third-party warehouses.
Designed and wrote a supplementary labeling application that consolidated product
safety and shipment data and replaced numerous preprinted labels for each
package. This eliminated mislabeling of outgoing products and thus substantially
reduced customer returns and product liability concerns for 3V. Later expanded
labeling application to incorporate a variety of customized shipping labels for
customer logistical needs, with optimum flexibility to allow additional package
and pallet label formats to be added for any customer as quickly as possible with
minimum further programming.
* Custom Requisition and Purchasing (Procurement).
Wrote inquiries and modified reports to make procurement budgets more visible
and comprehendible to all departments. Designed and wrote year-end processing for
the application that had been overlooked by original software authors. Interfaced
with inventory barcode application for equipment spare parts replenishment. Wrote
a notification program to alert supervisors when requisitions for crucial
purchases needed their attention.
Other duties at 3V included configuring PC networks and related equipment
(wireless and cabled), pulling and terminating CAT-5 Ethernet cable, upgrading PC
hardware, light PC and peripheral repair, help desk support, and occasional
managerial duties. Other accomplishments included single-handedly modifying over
130 programs to comply with Y2K and writing new programming standards
documentation to conform to IBM Common User Access guidelines.
October 1996 – March 1997
Planet Hollywood International, Inc. – Orlando, FL
Senior Programmer/Analyst
Primarily hired for implementation and enhancement of the JDA merchandising
package. Additional duties included: writing detailed weekly status reports;
reviewing functional specifications for some system enhancements; writing
technical specifications for all system enhancements before coding; drawing
flowcharts of system enhancements (with Visio); assisting with business case for
JDA implementation by demonstrating certain reports and inquiries to upper
management, and researching some JDA implementation costs.
Wrote interfaces on AS/400 for Micros point-of-sale systems and lightly modified
Perl scripts for same; designed FTP scripts to transfer data through Planet
Hollywood's WAN. Also wrote conversions for Lotus spreadsheet and Microsoft
Access data into JDA inventory data.
October 1992 – October 1996
Waccamaw Corporation – Myrtle Beach, SC
Programmer/Analyst
Primarily hired for RPG/400 work on JDA merchandising package. Job duties were
expanded to include: Electronic Data Interchange (Premenos EDI/400, with General
Electric as VAN) and writing of subsequent interfaces; point-of-sale systems (IBM
4680 and ACR 2000) and writing of subsequent interfaces; establishing TCP/IP
connectivity between AS/400, Microsoft Windows NT, and PCs (mostly needed for ACR
point-of-sale systems); Waccamaw's webmaster. Applications most frequently dealt
with in JDA:
* Automatic replenishment.
Performed overhaul in 1994 and complete redesign and rewrite in 1996. Wrote
extensive specifications for application before coding as well as training
documentation.
* EDI.
Took over as a pilot project after initial assignee left the company. Designed
and wrote all the initial interfaces from JDA to Premenos, mainly for
transmission of purchase orders. I subsequently acted as an EDI supervisor,
managing a junior programmer/analyst who then was assigned as EDI coordinator.
Wrote technical and training documentation for EDI processes.
* Point-of-sale.
Wrote AS/400 interface and Windows batch programs to automatically transmit SKU
data to over 40 stores.
* Reporting.
Introduced new spreadsheet style of AS/400 reporting (wrap-around, softcoded
number of columns) to Waccamaw by first designing and writing one such report,
then training other programmers to emulate style. Also designed and wrote several
print utilities that allowed central report printing management, automated
distribution lists, and spool control. Retrofitted all crucial reports to take
advantage of utilities. Documented these utilities to ease report programming
tasks of coworkers.
Other accomplishments include being awarded the Sales Support Executive of the
Month in May 1995 for overhauling the replenishment processes and optimizing
sales entry to eliminate system slowdowns.
June 1986 – October 1992
Taylor Data Systems, Inc. – Florence, SC
Programmer/Analyst
Wrote and maintained a variety of manufacturing, accounting, services, and
retail applications for over 15 client companies. Languages used: RPG II, RPG
III, RPG/400, and BASIC. Hardware platforms used were IBM System/34, IBM
System/36, and DOS PCs.
Software designed and/or written for clients included:
Accounts Payable Raw Materials Inventory
Accounts Receivable Retail Point-of-Sale
Payroll / Personnel Work-in-Process Tracking
Quality Assurance Tracking
Software maintained for clients included:
General Ledger Order Processing
Inventory Management Textile Manufacturing
Municipal Utilities Steel Manufacturing
Custodial Services Nursing Services
September 1985 – May 1986
Florence-Darlington Technical College – Florence, SC
Student Computer Lab Assistant
Trained other students on IBM System/34 operations and programming. Performed
minor System/34 operations, computer housekeeping duties, and low-level hardware
maintenance. Wrote software for school tasks in RPG II, BASIC, and COBOL.
EDUCATION:
Associate's Degree in Computer Data Processing from Florence-Darlington
Technical College in Florence, SC, received August 27, 1986.
PERSONAL:
Non-smoker, married for 20 years with two sons, ages 17 and 11.
Extracurricular activities relevant to field: assembly and repair of home PCs;
amateur digital video production and editing; experimentation with Ubuntu Linux
operating system in regards to video/audio home entertainment.
REFERENCES:
Available upon request.
|
