Supply Chain Business Systems

Highlights of Qualifications

●Results-driven IT professional with more than 30+ years experience in developing, installing, documenting, and maintaining various systems application software (Supply Chain, Inventory, Finance, Human Resources, Manufacturing, Distribution and more running on IBM mid-size computers, from the System3 to the ISeries

●Expert experience in business systems analysis, design, and programming utilizing several versions of RPG such as RPG II, III, IV, SQLRPGLE, RPG ILE, CLP on I Series.

●Proven ability to learn then be responsible for the maintenance and development of in-house programs including custom or customizations to legacy or system and operating systems. Construct and deliver programs and reports in direct support of customer business needs both legacy and across all internal development platforms.

●Extensive background in business systems analysis and application design with a strong working knowledge of EDI. Develop, maintain and support application interfaces to and from corporate systems, external customers and all customers systems including enterprise warehouse & distribution, sales and operations, marketing & supply chain.

●Strong technical support experience, end user, customer service skills, and problem solving skills to identify, communicate and resolve issues with client and management. Comfortable communicating with employees at all levels of the company and will work intimately with members of management and the IT Team to resolve issues and validate programming requirements within their areas of responsibility.

●Works independently with little or no supervision and as a team player.

●Works remotely

Highlights of Skills

●Language: RPG II, RPG III, RPG IV, SQQLRPGLE,RPG ILE; Structured, Modular Design

●Job Control: OCL Procedures and CL Programming (CLP)

●Arrays, Data Areas, Data Structures, Data Queues

●Subsystems, prestart jobs, job queues

●Relational Database Design and Normalization

●DB2/400: DDS-Physical Files, Logical Files, Join Files, Data Dictionaries

●Screen Design Aid (SDA): Menus, Display Files, Sub-file Programming

●SQL, embedded SQL

●File Transfer Protocol (FTP/FPTS)

●Query/400 and Open Query File (OPNQRYF)

●System Administration-PTFs, System Values, Basic Configuration,

●Security Administration-User Profiles, Authorization Lists, Object Authority

●Operations-Backup & Restore, Print Management, Job Scheduler, Journaling

●MS Outlook, MS Office, MS Access, Citrix, Client Access

●Radio Frequency (Wired and wireless), Intermec Cn3 and Cn3e handhelds

●Barcoding, label design, Printronix and Intermec thermal printers

Highlights of Software:

●Financial (A/P, A/R, C/R, P/R, G/L)

●Sales (Credit, Order Entry, Scheduling, Invoicing)

●Inventory Management, Forecasting, Purchasing, Material Receipts, Shop Floor; Shipping

●Manufacturing and Warehouse Distribution

●VAI, Optimum Solutions H/R, Ross ERP, MAPICS, BPCS ERP (V3.x to 6.2), High Jump Route Administrator, Sage Abra HR/Payroll, Appian logistics, EXTOL Secure, Kronos, Walmart Vendor Portal

●T. L. Ashford Barcoding

●Spoolflex report converter

●IWork DC/Serve

●Asset, Lansa, ACS Sequel, Robot, Turnover, Hawkeye, Synon, Aldon

●Ispirer Migration Utility

●Logicality Freight Rating System

●Ship Soft Shipping System

●Vertex Tax Calculator System

●RDI

●X-analysis

Work History

Sunbelt Rentals Corporate

Mar 2023 - present

Iseries Application Developer(Contract)

●Develop in various version of RPG from RPG IV to RPGILE and free form

●Same as FedEx Ground

●Use RDI, X-analysis and ALDON

Fedex Ground Jan 2022 - July 2022

ISeries Application Developer (Contract)

●Develop in various versions of RPG from RPG IV to RPGILE

●CL development

●SQL, Stored Procedures and Binding

●Modules and Service programs

●Analysis of existing code and make changes based on business requirements

●Support various departments with ad hoc sql data extraction

●Other duties as requested

Aug 2018 – Jan 2022

CEFCO stores

●Cashier/Stocker

Rock Creek Golf Course

●Grounds Keeper

Timber Creek Golf Course

●Grounds Keeper

Sam’s Club

●Member Services

Alegri Farm Market

●Product Clerk

Global Advanced Metals Feb 2018 – July 2018

ISeries Administrator (Contractor)

Boyertown, Pa

●Created ISeries security profiles and application security for new users and managed application profiles

for existing users

●Monitored batch programs for CPF error messages

●Analyzed RPG and CLP programs and performed program fixs/data fixes when CPF error

messages occurred

●Monitored month end processes to assure that all jobs ran to completion and took

corrective action as necessary (running from custom “robot” type job scheduler”

●Supported BPCS manufacturing shop floor and inventory/production batch transaction processing

●Evaluated ISpire migration software, tested and implemented said software to production

●Analyzed entire ISeries user libraries to determine how much data and from where should be

migrated from DB2 to SQL server via ISpire migration software

●Setup remote printers

●Supported physical inventory process

●Other activities as directed by director of information technology

Quincy Compressors

Mfg Software Engineer BPCS 6.2

Bay Minette, Al Jun2016 - Feb2018

●Monitor the performance of the IT systems and operations in global environment consisting of

Of over 90 product companies (manufacturing) and 100 sales company in seven countries

●Monitor and manage error files- Diagnose error messages and system commands

●Correct data problems and notify users

●Evaluate system errors and request program modifications to be made by the business area

●Support new BPCS change request and projects

●Act as liaison between local users and business support to ensure satisfactory results from the users’ point of view

●Cooperate with IS teams in other global regions

●Perform feasibility studies for new requirements

●Spec program change requests

●Manage offshore resources (offshore model)

●Root cause analysis from CLP, RPGIV, RPGLE, RPGILE, RPG Free. Wrote program specifications for bug fixes

and program modifications

CVS Caremark

Sr. Developer, RxClaim, PBM Nov 2015 – May 2016

Plano, Tx

●Design, develop and maintain Rx Claim application using Synon and various versions of RPG

●Developed process using Excel spreadsheet and extracted data via SQL for reporting of psychotic drug usage

over variable period of times and drug classes

●Posted transactions for Atena historical purposes

ITT Corporation

Sr. System Analyst, LANSA Developer, RPG Developer

Palm Coast, Fl Nov 2012 – Sep 2014

●Maintenance and support of Freight Billing system for legacy ISeries and AS/400 software making modifications and developing new business requirements using Lansa and ASC Sequel.

oDeveloped Lansa interactive and batch programs

oDeveloped Lansa for the web

oManaged Lansa program changes via Turnover product

oDeveloped tools with Lansa for personal data and program analysis

●Interfaced with internal users as well as outside customers to mine the database to report their business requirements.

●Re-engineered FTP processes to make them more efficient, parameter driven. RE-engineered processes that were user driven to run automated without user intervention. Analyzed existing code for errors.

●Developed test scripts for testing application and Iseries operating system upgrades.

Maryland & Virginia Milk Producers

Sr. IT Project Manager, Analyst, Designer, RPG Developer

Full Time Employee Jan 2009 – Dec 2011

Contractor RPG Developer Dec 2003 – Dec 2008

Employee

Newport News, Va; New Bern, NC

●Implementation of ERP Software from ROSS to

●VAI System 2000. Managed ISeries purchase, Installation of OS and PTFs, Upgrade to Rel 6.1.

●Managed installation of RF devices for 150 trucks spanning two divisions and 225 trucks routes.

●Interface VAI to High Jump

●Route Administrator in Virginia Dairy.

●Managed external contractors and vendor project managers for various in company initiatives such as EDI, Appian Logistics, High Jump Software, VAI ERP support, maintenance and new development, Sage Abra consolidation of PR and HR.

●Managed system upgrades and PTF installations and all migration of AS/400 systems to ISeries.

●Create specification documents for the purpose of purchasing new ISeries 740 to be used as “hot offsite back“ utilizing ITera software solution.

●Maintenance and support of I Series and AS/400 legacy software and development of new applications in support of business needs. Interfaced with all users to gather requirements for new application development as well as enhancements, changes and fixes to existing software applications.

●Worked with vendors to resolve issues with package software.

●Implemented new VAI System 2000 ERP. Collected and cleansed data from legacy ERP (Ross) application and writing data extraction from legacy system. Loaded extracted data to new ERP (VAI) databases in the areas of items, customers, sales history, manufacturing bills and routings, ship to and inventory history.

●Gathered requirements, designed, developed and implemented user driven requirements for customizations of ERP application in the areas of item maintenance, sales order entry, warehouse picking and shipping, billing, manufacturing material requirements planning, accounts receivable, inventory, job costing and sales analysis reporting

●Gathered requirements, managed, designed, developed and implemented interface from ISeries items, customers, ship to, sales orders, inventory, and routes to High Jump Route Administrator (application to managed delivery trucks inventory, sales orders, routes) and returning to ISeries sales deliveries, return and damaged goods, inventory request for next run day and interfacing that data to the ERP sales order application. 150 delivery trucks, 15 locations within Virginia, North and South Carolina

●Developed interim files and controls for extracted data from sales history for use in creating EDI810 invoice transactions.

●Developed extraction process from EDI850 purchase order and loaded to ERP sales order application and created EDI855 purchase order acknowledgement transaction.

●Developed extraction process from EDI852 point of sale transaction to load to ERP sales order application and forward to the ERP billing process.

●Designed, developed and implemented custom processes to retrieve large customers store order data from their server and drive those purchase orders into the sales order application.

●Designed, developed and implemented custom processes to create customers billing data and place on their servers for various large customers

●Gathered requirements, designed, developed and implemented custom commission reporting for truck drivers.

●Gathered requirements, designed, developed and implemented custom functionality for the posting of cash to accounts receivables and developed custom aging reports.

●Gathered requirements, designed, developed and implemented custom load reports and load sheet maintenance for cuts and add, radio frequency for load sheet cuts and adds and radio frequency for the taking of physical inventories.

●Mined and cleansed payroll data from two ISeries and one PC based payroll systems consolidating the data from the three systems into one set of interface files to be loaded to the Abra Suite Human Resources and Payroll modules.

●Gathered requirements, designed, developed and implemented modifications to the material requirements process to use a different source of data for forecasting. Consolidated raw materials requirements to calculate amount of raw milk to be pasturized to accommodate the current demands (whole milk, 2%, 1%, Skim). Developed custom material requirements reporting.

●Gathered requirements, designed, developed and implemented data extraction from MS-SQL Server 2003 to be uploaded to AS/400 and then used to create various analysis Excel spreadsheets. Sent spreadsheets to users IFS directory for user retrieval.

●Re-engineered process to run more efficiently and with greater accuracy to allow company to increase its service level to large customers.

Iceland Seafood

Contractor RPG Developer 2003

Newport News, Va

●Provided analysis, design and development to integrate APLUS voice activated warehouse picking system with Daily & Walcott sales order processing, inventory allocation and billing.

●This eliminated the manual recording or need to swipe a barcode allowing pickers to speak the items picked for a sales order.

●In addition, this customization automated updating sales order with inventory allocations and flagged the order for billing.

Smith & Nephew Pharmaceuticals

Contractor BPCS RPG Developer 2003

Largo, FL

●Developed Month end job scheduling process

●Variably driven to accommodate BPCS application logic for month end and for legacy systems.

●EDI 852.

●Gathered the requirements, designed, developed and implemented a BPCS month end process to run all necessary programs in a single unattended job stream with no user intervention to specify month ending dates. User processes could also be run in this process.

●Re-engineered the EDI852 (point of sale transaction) process to be more efficient resulting in less processing time.

Tredegar Industries

Contractor RPG Developer 2003

Richmond, Va

●Developed source archive and modification tracking system for RPG, CL, DDS similar to Turnover.

●Interfaced to VAI System 2000 for materials handling, finished goods receipts, production costing driving lot controlled inventory negative for that night’s production.

●Designed and developed from customer’s specifications a source checkout, archive, and installation process. This process allowed only one copy of production source to be moved to a test environment.

●Analyzed Pansophic sales order entry, billing, and manufacturing modules to determine the customizations made to the existing release and developed a cost estimate for retrofitting those customizations into a newer release.

C. Lloyd Johnson

Contractor RPG Developer 2002

Norfolk, Va

●Developed custom interface between legacy OE to Varsity

●Ship Soft shipping applications bask to legacy system for billing

Time Life Inc.

Contractor RPG Developer 2002

Richmond, Va

●Developed routines to be used with interactive maintenance for contracting and tracking network television and cable advertising buys.

Alba Waldensian

Contractor BPCS, ASSET Developer, RPG Developer 2002

Waldensian, NC

●Developed custom RF inventory process to be use with IWork DC/Serv product for BPCS 6.2 cycle counts and physical inventory and for legacy systems physical inventory of work-in-process and yarn on cone allowing cycle counts and physical inventory while manufacturing continues and inventory transactions post. Developed way to count wip cone of yarn by base diameter of cone enabling a very accurate wip inventory as well as raw materials.

Westvaco Corp, Folding Box Division

Contractor BPCS, ASSET Developer, RPG Developer 1995 – 2002

Richomnd, Va; Cleveland, Tn; Newark, DL

●Developed RF inventory system for legacy systems.

●Implemented the order and billing modules for BPCS 5.1.

●Interfaced inventory from legacy system to BPCS using RF.

●Analyst and technical lead of thirteen team members varying from Consultant to junior programmer for BPCS 6.1 implementation. Developed using ASSET case tool.

●Shop floor, production schedule, MRP, finite forward scheduling, product data management, order to case, shipping

Morven Partners

Contractor BPCS, ASSET Developer, RPG Developer 1998 – 2002

Richmond, Va; Bertie County NC

●Developed commodity tracking for the peanut processing industry and interfaced to BPCS 6.2 inventory, accounts payable and GL. Developed analysis programs for same process using ASSET.

●Developed interactive flash reporting for upper executives.

●Installed and maintained RF inventory control process for several distribution centers

Aero Transportation

Contractor BPCS RPG Developer 1999

Independence, Mo

●Y2K conversion BPCS 4.0 to 4.05CD

●Customize Cost Rollup process

●Customized GL and production reporting

Contact this candidate