Stan Dunn

ac4ocp@r.postjobfree.com 972-***-****

GENERAL SUMMARY

Over 30 years of experience in Designing, Developing, Analyzing, Debugging, Converting and Testing RPG Centric applications, Including AP, AR, GL, INV(raw, wip & finished goods), manufacturing, distribution, Oil & Gas and auditing (internal and PCI).

Expertise in RPGII, RPGIII, RPG/400, RPGILE, SQLRPGLE, RPGFREE, Full **FREE, CL, CLLE, DB2, SQLQM.

15+ years managing a team of programmers and operators, 15+ years operating my own consulting firm in the AS/400 thru IBM i server arena.

Strong knowledge of system functions, system tuning, and system APIs

Strong communication skills in both the technical realm and with clients and customers.

Self-imposed standards to continue my education and training on new technologies.

Excellent ability to both learn from others and assist others.

EXPERIENCE

November 2017 – Current AMS Staffing Solutions

Senior RPG Developer Chicago, Illinois

Client in Irving, TX

Design and deploy EDI software to feed web interfaces.

Support operations for payment of third party contractors.

Train/Support of programming staff on use of RDI, iACS, DBeaver, Snagit and other productivity utilities.

October 2016 – October 2017 ASAP Consulting

Senior RPG Developer Atlanta, Georgia

Client in Irving, TX

Design, write and promote EDI interface to web services in OilDex

Develop new programs using RPG III, RPG IV, RPG ILE, Free-RPG, Full-Free RPG CL, and SQL to support various company-wide applications

Re-wrote/converted older RPG code into Full-Free RPG

Create Stored Procedures utilizing embedded SQL for data-extraction and used static and dynamic (prepared) sql statements for various report functions.

Gather Business requirements to bridge technical and business resources

Utilized sub-files both SFLPAG=SFLSIZ and SFLPAG<>SFLPAG for edits, updates and deletes in RPG

Production support in a 24/7 environment

Maintain Current system as the iSeries is sunset

Coordinate with Oracle DBAs on DB2 to Oracle transition

Configuration of iSeries, Apache servers, PHP, MariaDB and MYSQL on the IBM I with SSL and PCI audits

Knowledgeable in IFS, SSH and PASE environments.

Managed QA testing efforts for pre-existing but modified and new RPG programs.

Extensive iSeries experience, including but not limited to Power HA, IASPs and Red Hat Enterprise running in a partition on an iSeries communicating thru web services between them.

Integrated GIT and other open source initiatives from IBM with RDI for code collaboration in a team environment.

March 2012 – September 2016 Speed Commerce (previously known Speed FC)

RPG Developer Richardson Texas

Research and assist in implementation new programming techniques including full free format and declare statement features, service programs, and SQL stored procedures

Re-wrote pre-existing RPG III, IV, ILE in free format and full-free format (**free)

Created driver and handler programs to integrate external systems with internal AS400 systems

Maintain and enhance Manhattan and Associates WMS system, including modifying multiple monitors, carton tracking, creating multiple web service programs to send/receive data to/from client systems (eg: tracking information as soon as an order was cartonized)

Gather Business requirements, writing functional requirements, and leading all initiatives as It pertained to RPG Development

Utilized FTP AND SFTP for scripting file transfers.

Developed support tables and utilized green screen interfaces to maintain them, including sub-files for account maintenance.

Supported management with SQL queries of selected data exported to excel in required formats utilizing navigator, iAccess and iACS for export/import from external data sources.

Perform batch programming to communicate data across systems and for reporting purposes

Strongest PKMS areas, inventory, picking, packing, shipping labels, packing slips/invoices, manifesting, tracking, domestic & international shipping requirements

Design, Develop and Test SQL Stored Procedures for internal and external requests

Integrate ProShip external server shipping model into iSeries WM system using XML and MS-SQL

Support and Train QA department on all facets of testing PKMS systems

Installed configured and coded support of PHP environment with an IBM i as the server running Zend server

March 2011 – March 2012 Maintain Systems

RPG Developer Dallas, Texas

Research and assist in implementation new programming techniques including full free format and declare statement features, service programs, and SQL stored procedures

Re-wrote pre-existing RPG III, IV, ILE in full-free format

Performed iSeries upgrades both OS and Hardware

Designed MS SQL data bases for clients wanting customized reports from the DB

March 2009 – March 2011 Speed FC

iSeries operations and production support. Dallas, Texas

Capacity planned using Performance Tools. Then documented need for management, procured hardware and software including sizing and installing an IBM i model 740 with 2 active processors, 512 GB memory and 3 TB disk

Provided Production support and third party QA for programs written to speck

Provided programming functions but was not my main assogmemt

1992 – March 2009 SID CONSULTING, INC.

Dallas, Texas

Independent contracting firm that I owned, providing custom code and conversion services.

These services not only were iSeries/AS400, but Windows and Linux as well

Maximum Number of employees 5

PKMS and Custom inventory/OMS/shipping support, modifications, and operations

AFP for Billing/shipping/packing slips

Y2K conversion for Private Real Estate Management company including GL/AP/AR/Job Cost

Multiple conversions both to and from S/38-AS/400-eServer-iSeries-IBM I to windows

Pre 1992 Folsom Investments, inc.

Addison, Texas

Director of Information Services.

Managed staff of 6 maintaining in house AP/GL/JC/AR/OG/Mortgage Management and others

Reed Mining Tools, inc.

Arlington, Texas

Staff Programmer in S/38 MAPICS shop

DAYCO, Corp.

Ocala, Florida

Staff Programmer for in house Manufacturing Including raw material/in process/finished goods/distribution

EDUCATION

Attended Baylor University - Accounting 105 hours did not graduate, details if needed.

Contact this candidate