| Home | AS/400 Bookstore || Resumes | Thomas | Chris | Brian | Craig | Terry | Mike | Jim | Ken | Roy | Ralph |
Resume of Roy Campbell |
|
|
Information Technology Experience
AS/400 Senior Systems Developer AS/400 Data Base Administrator
Distribution / 10 Years Financials: AR, AP, GL, PR / 5 Years Decision Support Systems / 5 Years Data Conversions / 2 Years
AS/400 Hardware Infrastructure
AS/400 Operations
IT Director “Hands On”
IS Manager “Hands On”
Business Support Areas With Experience
Manufacturing / 8 Years
Order Fulfillment / 8 Years
Operations Support / 8 Years
Data Warehousing / 3 Years
Executive Information Sys / 4 Years
Business Intelligence / 2 Years
EDI B2B – 1 Year
E-Commerce – Web / 2 Years
Professional Experience
Aug. 2001 to Current
Software Vendor Senior Product Developer
·
Technical design and coding for AS/400 – NT intranet
OLAP / DSS Systems using RPGILE, Websphere.
· Build
interfaces to JDEdwards and Mapics Financial DBMS for data extraction for
matrix loading / ODBC.
· Set
up AS/400 LAN and perform duties of Systems Administrator, Security Officer.
Jan. 1998 to Aug. 2001
2 Billion $ Catalog Retailer Senior Technical Architect
/ Developer
Multi
Channel – Internet – Catalog – Brick & Mortar Retailer
- Order Fulfillment Projects Distribution Center
Shipment Planning System (SPS)
–Warehouse Management Systems (WMS) – Platforms AS/400, NT, OS/2
Languages: RPG/400, RPGILE, C, CPIC
·
Provide high -level workflow documents working with user
departments or internal IS staff.
· Provide
written detail technical design specifications with budgeted cost for approval
by client management.
· Initial
coding / maintenance support of several hundred RPG/400 or RPGILE programs
that were initially written by myself and 2 other programmers under a sub
contract.
· System
administration for Business Rules that impact Planning.
· QA
batch testing prior to promoting to Production.
· All
QA testing results by others approved by myself prior to promotion to Production.
· Generate
user requested report Queries via Query or SQL.
· Major
contributor to a software system that is still being utilized twice as long
as client had originally desired.
· On
going enhancements in RPG/400 and RPGILE as primary vendor to the (SPS).
· Continue
modifications to Large Format 11 x 17 Laser generated Pack Slips that contained
several types of Bar Codes and Overlays for Logos and shading.
Jan. 1994 to Dec. 1997 Atlanta
Based Consulting Co. Senior Developer / DBA
Top 5 Management Consulting Company
- Logistics Group
Shipment Planning System (SPS)
–Warehouse Management Systems (WMS) – Platforms AS/400, NT, OS/2
Languages: RPG/400, RPGILE, C, CPIC, MQSeries
·
Database definitions via Data Dictionary and creation /
maintenance of 100's of Physical and Logical files.
· Systems
administration of the AS/400 as needed for creation of sub-systems, memory
pools, time slices and batch routing steps.
· QA
batch testing prior to promoting to Production.
· Control
of major mass system updates through custom developed Code Control System
for several years until Aldon code control system purchased in 1999 to perform
same.
· Technical
design and coding in RPG/400 of 60% of the initial code for the SPS as secondary
vendor.
· Designed
and coded a high transaction processing system on the AS/400 that utilizes
up to 5 copies of 6 RPG/400 server programs and Data Queues to process 100's
of thousands of customer orders a day.
· Created
AS/400 based server programs in RPG/400 and RPGILE that interfaces real time
to applications on PC based NT and OS/2 based platforms via CPIC and MQSeries
for purposes of best-fit cartonization and Routing.
Sept. 1992 to Dec. 1993
Atlanta Based Consulting Co. Project
Manager / Developer
Top 5 Management Consulting Company - Information Technology
Group
Platforms: AS/400 Languages: RPG/400
·
Provided high-level design and project management for ACS
Apparel Software for client project.
· Systems
administration for internal ACS AS/400, including tuning, security relating
to user and object.
· Perform
QA testing for Custom Modifications prior to Client installs.
Jul. 1992 to Sept. 1992 Norcross
Software Co. Conversion Data Mapper
Software Sales and Systems Integrator - Contract based.
Platforms: AS/400 Languages: RPG/400
·
Converted manufacturing and sales data into JD Edwards database
for a FTC controlled merger of 2 large spice companies.
·
After FTC approval – performed final conversion and
QA testing of data for new owner.
March 1992 to June 1992 Atlanta
Petroleum Co. JDEdwards Programmer
Convenience Store Retailer / Gas / Video / Other –
300 Locations 1992 – Contract based.
Platforms: AS/400, System /38 Languages: RPG/400
·
Designed, programmed an automated AP reconciliation System
for Vendor EDI invoices for grocery items, including interface to JD EDWARDS
WorldSoftware Accounts Payables for RaceTrac Petroleum.
Feb. 1991 to March 1992 IBM Development
Labs Senior Programmer/Analyst
IBM Mapics Maufacturing - Software Package Development –
Riveredge and Wildwood – Contract based.
Platforms: AS/400 Languages: RPG/400
·
Front-end high-level technical design of the IBM MAPICS
Multi Currency AP application for AS/400.
· Responsible
for database design, systems logic and coding IBM MAPICS Multi Currency Bank
Reconciliation, Manual Payments and Payment Reversals.
· Responsible
for component QA testing – using predefined test scenarios.
Sept. 1990 to Nov. 1991 Atlanta Headquarters Senior Programmer/Analyst
Farm Co-Operative / Poultry processing
/ Retail Farm / Garden Supply – Contact based.
Platforms: AS/400, System 36 Languages: RPG/400, Cobol – Project overlapped IBM Project – Worked on both daily.
·
Modified Global's Retail Reporting System for GoldKist HQ
that recaps revenues and expenses polled and transmitted from 175 Retail
stores.
Jan. 1989 to Aug. 1990 IBM Development
Labs Senior Programmer/Analyst
IBM Mapics Maufacturing - Software Package Development –
Riveredge - Contract based.
Platforms: AS/400 Languages: RPG/400
·
Responsible for database design, systems logic and coding
of the Schedule Release function in IBM's REPETITIVE module of MAPICS.
·
Designed, coded and implemented new innovative processing
techniques for IBM's REPETITIVE module that utilized a generic OPNQRYF interface.
·
Systems tuning for internal IBM AS/400 used for REPETITIVE
developers.
·
Responsible for component QA testing – using predefined
test scenarios.
June 1986 to Nov. 1988
Industrial Holding Company Director of Computer
Technologies
Wholesale / Retail Distribution
Company owning 5 subsidiary companies.
Duties
and Responsibilities:
·
Overall responsibility for all operational aspects of the
Corporate Information Systems, including personnel, software, hardware, and
outsourcing.
· Communicate
with CEO and other department heads regarding current and planned IT projects
· Develop
and support internal IT staff regarding assignments and objectives.
· Evaluate
new hardware and/or software technologies and recommend to CEO if merited
purchase.
Major Accomplishments:
·
Personally designed, did database design, coded and implemented
a Remote Order Entry System for the fleet of tractor-trailers. This system
consists of remote portable PC's, dot matrix printers, and a host PC base
station attached to the IBM System 38. This system also utilizes bar code
scanning.
· Moved
the corporate IS Center to a new facility located in Tucker five · Designed,
and implemented a Customer Direct Order Entry and Inquiry System via dial
up communications.
· Installed
EDI X. 12 network with several large customers using GE and REDINET telecommunication
services.
· Personally
designed, coded and implemented a Statistical Information System, measuring
critical data such as fill rates and service levels. System further provides
an audit trail of all inventory updates; sales, receiving, stock transfers,
etc.
· Personally
designed, coded and implemented a Cycle Count Inventory System based on A-B-C
analysis.
· Successful
in keeping original staff during a time when support function grew to 12
locations without adding additional personnel.
· Implemented
the usage of bar coding equipment from receiving to entering sales orders
in the field.
· Installed
a UPS Manifest System including downloading & uploading of data between
the System 38 and PC.
April 1981 to May 1986
Chromatics Manager of Information Services
Manufacturer of high-end graphical
processors and monitors.
Platforms: System/34 and System /38 Model 700 Languages:
RPGIII
Duties and Responsibilities:
·
Overall responsibility of all operational aspects of the
company's Information Systems, including over all Personal Computers.
· Work
with management in order to ascertain their departmental needs of the MIS
center.
· Prepare
budgets of all expense and capital items, and control expenditures.
· Evaluate
all hardware, software and communications equipment to be purchased or leased.
· Assign
programming projects and maintain completion schedules, assist in programming
if needed.
Major Accomplishments:
·
Managed the department through a period when both hardware
capacity and on-line terminals grew at a rate of 300% without the addition
of IT personnel.
· Converted
from an IBM System 34 to an IBM System 38 in June of 1983 in less than · Converted
from IBM MAPICS software to DATA 3 MRP II manufacturing and JD EDWARDS WorldSoftware
financials in 2 months. Brought MPS and MRP on-line in 8 months.
· Personally
designed, coded and implemented a master menu & security system, which
allows all users a centralized access path to all systems. Security for the
menu is controlled using an array for each user.
· Installed
communications network combining various hardware etc., including protocol
converters, IBM PCs, CHROMATICS's terminals, and internal digital PBX allowing
voice & data transmission.
· Personally
designed, coded and implemented a payroll direct deposit system through C
& S Banks of Ga. and NACHA using RPG III and CL. System interfaces with
JD EDWARDS payroll system.
|
|
| Home | AS/400 Bookstore || Resumes | Thomas | Chris | Brian | Craig | Terry | Mike | Jim | Ken | Roy | Ralph |