Resume of Roy Campbell
Summary of Qualifications
Business professional with extensive management and technology experience gained over career. Exceptional skills as an innovator that continually provides new technology based solutions, providing a positive impact to the profitability of an organization. Highly capable and meticulous in understanding business problems, undertakes an approach that is highly energetic in resolving. Proven expertise in strategic planning, process reengineering, change management, project management, software application development, and systems integration.
|
IT Director - "Hands on Technical" Warehouse Manager AS/400 Senior Software Developer |
IT Manager - "Hands on Technical" Inventory Control Manager |
Payroll Manager Cost Accountant |
|
Logistics / 7 Years Financials: AR, AP, GL, PR / 5 Years Distribution / 10 Years Data Conversions / 3 Years EDI B2B - 1 Year |
Manufacturing / 15 Years Order Fulfillment / 8 Years Operations Support / 8 Years Business Intelligence / 2 Years Decision Support Systems / 5 Years |
Data Warehousing / 3 Years Manufacturing / 15 Years Executive IS / 4 Years E-Commerce B2C / 2 Years Project Manager / 8 Years |
April to current CompBenefits Senior Developer
Dental / Vision Insurance - Contract engagement
Maintenance Existing Applications
Platforms AS/400, Languages: AS/Set Case Tool, RPGILE, RPG Free, Embedded SQL, Aldon Change Control
- Modified existing application, which allowed CSR personnel the ability to save delivery cost of materials to subscribers if not required.
- Modified existing application, which allowed CSR personnel the ability to flag a Subscriber address as not being deliverable.
- Review of multiple Company databases and isolation of corruption from several programs, which caused data corruption within the Hyperion Essbase Data Cube.
- Creation of new application, which allowed variable selection criteria to be processed by a Database Trigger process for correction of Company Number.
September 2004 to March 2005 LeasePlan USA Senior Developer - Fleet Services
Fleet Management - Contract engagement
Billing Enhancements
Platforms AS/400, Languages: RPG/400, RPGILE, RPG Free, Embedded SQL, Turnover Change Control
- Technical implementation of Material Replacement Billing and Interface to Miscellaneous Billing.
- Administrative & technical assistance in re-definition of quantity from 2.0 to 6.0 in over 60 files and 100's of programs.
- Database modifications in re-definition of level reporting codes for over 1000 files.
- Provide systems related assistance as needed to support other team members for modifications of 500 + programs
May 2004 to Jan 2005 LeasePlan USA Data Warehouse Interface Consultant
Automobile / Truck / Equipment Leasing - Fleet Management - Contract engagement.
Data Warehouse - Interfaces USA to Corporate Netherlands
Platforms AS/400, Languages: RPG/400, RPGILE, RPG Free, Embedded SQL, MQSeries, Turnover Change Control
- As the only internal / external assigned resource - provided administrative & technical design / implementation for initial phase of Data Extraction from USA Leasing and Fleet Management databases.
- Technical design and implementation of data cleansing of extracted data prior to transmission.
- Redesign of Corporate provided control procedures that were utilized by 25 other countries to work with USA applications; due to the fact that USA uses custom applications where most other countries use the standard NOLS application.
- Utilized MQSeries for transmission of data from USA AS/400 to Corporate Windows based server.
May 2003 to May 2004 Polycor / Georgia Marble Senior IT Consultant / Manager
Dimension Stone / Quarry Products - Contract engagement.
Estimate / Order Entry / Invoicing Systems
Platforms AS/400, Windows Server 2000, Windows Server 2003, Novell Netware 5.1
- Administrative & Technical Support for 4 Server Platforms
- Administrative Support of MS SQL Server 2000 - including additional creation of Windows 2000 SQL Database in a test environment running on an actual AS/400
- Administrative Support for Power Builder ERP package utilizing MS SQL Server 2000
- Administrative & Technical support for LAN Infrastructure consisting of CAT5, Fiber Optics and Twinax cabling utilizing multiple Bay Network 250 & 350 Hubs, Lancast - Media Conversion to Ethernet, Madge Hubs, Nbase 401TFiber Optic to Twinax Media Conversion. Cisco WAN Routers, VPN Internet Tunneling
- Provide as needed Technical help for 40 Laptops and Desktops running on Win 95, Win98 and Windows 2000 Professional
- Continued Support of all AS/400 Applications sold to Polycor
- Set up an AS/400 at Datacamp Offices to provide mirrored offsite protection for onsite AS/400 that's leased to client by Datacamp.
- Recommend IT Hardware and Software requirements per User request and Purchase when Authorized by President or Controller
- Provide multiple in depth Management Reports to the President relating to IT Platforms as well as Short Term, Long Term requirements.
- Negotiated new T1 Circuit with combination of PBX Access - 1st ever in Georgia by local Telecom. Combined cost of broadband and voice reduced by two- thirds of prior cost.
- Successful cutover from Imerys WAN Network to Georgia Marble Network
- Installed Cisco Pix 515 Firewall and Virtual Private Network.
- To support client - as owner of Datacamp Systems; purchased, installed and administration of 3 additional AS/400s
March 2002 to May 2003 Imerys / Georgia Marble Senior AS/400 Consultant
Dimension Stone Division / Quarry Products - Contract engagement.
Estimate / Order Entry / Invoicing Systems
Platforms AS/400, Novell Netware 5.1, HP/Unix
- Maintain AS/400 Custom developed Order Entry System written in RPG IV
- Automated AS/400 to Lotus Notes "Impact System" for Order Tracking written RPG ILE
- Provide Data Base extracts for audit purpose of Invoicing System, as Data Base was not maintained in the past.
- Conversion of Programs / Data & separation of applications utilized by new International owners of Georgia Marble per sales agreement with Imerys without assistance.
- As Divisional Senior IT Consultant for Imerys set up a Development / QA AS/400 as Security Officer and created an automated FTP System to transfer Production data to the Development / QA AS/400 on a daily basis.
Aug. 2001 to February 2002 Datacamp Systems Owner / Senior Architect / Developer
Custom / Package Software Firm (Founded in 1992)
AS/400 Package Software Multi Channel - Internet - Catalog
Platforms AS/400, NT, Languages: RPG/400, RPGILE
- 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.
1998 to Aug. 2001 Williams Sonoma /Pottery Barn Senior Technical Architect / Developer
Multi Channel - Internet - Catalog - Brick & Mortar Retailer - Order Fulfillment Projects Distribution Center Contract engagement.
Shipment Planning System (SPS) - Warehouse Management Systems (WMS)
Platforms AS/400, NT, OS/2 Languages: RPG/400, RPGILE, C, CPIC, Aldon Change Control
- Provide high-level workflow documents working with user departments or internal Williams Sonoma IS staff.
- Provide written detail technical design specifications with budgeted cost for approval by client management.
- Maintenance support of several hundred RPG/400 or RPGILE programs that were initially written by myself and two 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.
- 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.
- Ability to support client in Memphis and San Francisco 90% of the time from my location utilizing several in house AS/400's and LANs based on both Token Ring and Ethernet hardware for development work and QA testing work prior to sending to client location.
Jan. 1994 to Dec. 1997 Kurt Salmon Associates Senior Developer / DBA
Top 5 Management Consulting Company - Logistics Group - Contract engagement.
Williams Sonoma - 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 over 400 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 personally developed Code Control System for several years prior to Aldon Change 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 Kurt Salmon Associates Project Manager / Developer
Top 5 Management Consulting Company - Information Technology Group - Contract engagement.
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 Omega Software Conversion Data Mapper
Software Sales and Systems Integrator - Contract engagement.
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 RaceTrac Petroleum JDEdwards Programmer
Convenience Store Retailer / Gas / Video / Other - 300 Locations 1992 - Contract engagement.
Platforms: AS/400, System /38 Languages: RPG/400
- Designed, programmed an automated an 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 Manufacturing - Software Package Development - Riveredge and Wildwood - Contract engagement.
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 GoldKist Headquaters Senior Programmer/Analyst
Farm Co-Operative / Poultry processing / Retail Farm / Garden Supply - Contract engagement.
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 Manufacturing - Software Package Development - Riveredge - Contract engagement.
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.
Current name: Industrial Distribution Group
Platforms: System/38 Model 700 Languages: RPGIII
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 Boring Smith 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 (5) months after being with the company The move, including leased communications, was completed without interruption to business.
- 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.
Current name: BarcoView
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 5 weeks.
- Converted from IBM MAPICS software to DATA 3 MRP II manufacturing and JD EDWARDS 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.
- As an external project to regular duties: designed, programmed & implemented a micro/System 38 interface system between System 38 data bases and Visi CaIc, LOTUS, and dBASE, with complete security control.
- As an external project to regular duties: designed, programmed and implemented an interactive spreadsheet and color business graphics system for the IBM System 38 in RPG III and CL.
January 1969 to Sept 1980 Bobs Candies Inc DP/Inventory Control Manager / Payroll Manager / Cost Accountant
Food Processor - Candy Manufacturing
Platforms: System/32 and System /34 Languages: RPGII
Duties and Responsibilities:
- Manage DP, Order Processing, Payroll and Warehouse personnel ranging between 15 to 50 employees on a seasonal basis.
- Long range forecasting of manufacturing requirements for seasonal Christmas merchandise.
- Weekly production scheduling of 22 production lines for 3 shifts for several hundred employees.
- Responsible for Order fulfillment and control of finished goods inventory for sales distribution from 6 regional warehouses.
- Communicate with user departments in defining new systems, and user training on existing software.
Major Accomplishments:
- Systems design, coding and implementation of all systems for an IBM System 34, in RPG II, including: Accounts Receivables, Incentive Payroll, Order Entry / Invoicing, Master Production Scheduling, Production Batch Scheduling.
- Installed IBM MAPICS accounting and inventory modules.
- Determined direct / indirect / overhead cost via computerized payroll and materials cost interfaces.
- Reduced non-seasonal inventory by 50%, while maintaining a greater on time shipment percentage.
|
AS/400 /16 Years PC / AT / 8088 / 80586 /19 Years LAN / WAN /8 Years |
System 38 Model 700/ 7 Years Ethernet / 7 Years |
System 34 / 36 / 4 Years Token Ring / 3 Years |
|
RPG - RPG ILE IV Programming / 20 Years CPF 16 Years OS/400 SQL / 2 Years HTTP Server / Websphere 2 Years PRMS / 1 Year Lotus Domino 4.6, 5.05 1 Year Aldon Change Management / 4 Years Visual RPG / 1Year MQSeries / 2 Year |
OS/400 System / 14 Years TCP/IP - FTP 3 Years JD Edwards WorldSoftware / 5Years ACS Apparel Systems / 1 Year KSA - DCMS / 2 Years Data Queues / 8 Years Operations Navigator / 2 Year C / C++ / Limited RPG Free 1 Year |
CL Programming / l4 Years COBOL / 1 Year MAPICS / 5 Years Global Systems / 1 Year Robot Scheduler / 1 Year Hawkeye Pathfinder / 2 Years Linux / Limited IBM Visual Age Java / Limited Turnover 1 Year |
|
DB2/400 / 10 Years MS SQL - 2000 - 1 Year |
UDB/DB2 / 6 Years | MS Access 97 /2000 4 Years |
|
MS NT 4.0 Server / 6 Years IBM OS/2 / OS/2 Warp / 3 Years TCP/IP (Telenet) - FTP 5 Years Lotus Notes 5 & 6 - 3 Years Novell Netware 5.1 - 1 Year |
MS NT 4.0 Workstations / 2 Years IBM DOS / 6 Years MS Office 97 / 2000 / 6 Years Windows Server 2003 2 Years Lotus Domino 6.0 1 Year |
MS Windows 3.1 / 95 / 5 Years MS Front Page / 1 Year MS Outlook / Exchange / 5 Years Windows Server 2000 / 1 Year |