Sales Developer

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

Work History

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

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

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

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

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

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

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

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

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

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

Y2K conversion BPCS 4.0 to 4.05CD

Customize Cost Rollup process

Customized GL and production reporting

Contact this candidate