Dennis M. Davenport

Email: adw00b@r.postjobfree.com

LinkedIn: www.linkedin.com/in/dmdpgmr

972-***-****

Summary:

Senior Programmer Analyst with 42 years of experience programming in RPG and performing EDI functions up to and including EDI Coordinator on IBM mid-range computers, including 30+ years on AS400 / iSeries. I have worked extensively on ERP systems over the years using various software products and other homegrown solutions. Proven ability working with users to gather requirements for new systems or enhancements to existing applications, then condensing those needs into requirements and technical specification documents. An accomplished programmer, creating well organized, documented, and easy to read code. Proven ability to work independently or in a team, as a leader or a team member.

Hardware Experience:

iSeries/AS400 (32 years), System 36 (10 years), System/34 (5 years), System/32 (1 year)

Tools Used:

WSDC/RDi, DB2/400, DDL, Stored Procedures, SEU, PDM, Query, Query Manager, RDA, RLU, Hawkeye, X-Analysis, Abstract, Turnover, MKS Implementer, Aldon CMS/LMI, Agile development techniques (SCRUM/Sprint, Kanban)

Language Experience:

RPGILE (ILERPG) – Fixed and Free Form (29 years) / RPGIII (2 years) / RPGII (12 years)

CL (29 years) OCL (11 years)

Embedded SQL (16 years)

Software Experience:

Packages: BPCS, CMAS, SW2000, extensive custom system design and development.

EDI: Extol (3 years), Trusted Link (2 years), Gentran (11 years), Preminos (6 months),)

Applications: AR, AP, GL, Invoicing, Shipping, Pick/Pack, Receiving, Service Scheduling, Job Costing, Fixed Assets, Amortization, BOMs, MRP, MIMIX Global

Other Areas of Knowledge:

Familiar with the architecture of web services and using stored procedures to process data received through them. Able to read XML on sight.

Professional Experience

July 2022 – September 2022 (100% remote)

Artech, LLC Morristown, NJ

Contract for Prime Therapeutics, Eagan, MN

Performed general programming tasks using RPGILE and new client set up using iSeries hardware.

Contract terminated early due to shifting budgetary priorities.

May 2021 – May 2022 (100% remote)

Quinnox, Inc. Chicago, IL

RPG Team Lead (contract)

Worked as a project lead for Waste Management in a remote mode, shepherding projects from request through discovery, planning, development, and unit testing before handing off to the QA/QE team. Also participated in development and publishing of team technical standards using iSeries hardware.

November 2019 - May 2021

Pandemic

July 2019 – November 2019

TEK Connexion, Pittsburgh, PA

Senior RPG Consultant

Fedex Ground, Moon Township, PA

Performed code modernization tasks in the scheduling / routing group, including analysis, coding, unit testing, and integration testing using iSeries hardware.

October 2018 – July 2019

Vacation

May 2017 – October 2018

Mentour Corp.

Edison, NJ

RPG/SQL Developer – System Support Programmer – System Administration principal

Analysts International Inc.

Sub-Contracted to Mayo Health Systems – Rochester, MN

Primary System Support and Admin resource with additional backup duties on the claims management team. Performed various maintenance and small development projects as well as taking over system support from a staff member who was retiring.

Successfully planned, led, and implemented a High Availability solution involving 2 pairs of Lpars (Production and Data Warehouse) using iSeries hardware.

August 2016 – April 2017

Derex Technologies

Harrison, NJ

Client: Estes Express Lines, Richmond, VA.

Data/Analyst on Metadata creation project; Sr, RPGLE developer using iSeries hardware.

Worked on a project to analyze existing thirty (30) year legacy database, identifying primary keys, foreign keys, creating metadata, and converting to third normal database standards.

Also spent about 20% of my time on a development project, creating file maintenance programs for a new sales goals metrics system. The programs used an I/O service program through which all file I/O was performed using SQL using iSeries hardware.

Was 3rd level EDI support resource dealing with EDI issues and analyzing and modifying home grown EDI programs / processes.

January 2016 – July 2016

Medical Leave of Absence

October 2015 – December 2015

KForce Consulting

Addison, TX

Senior Programmer/Analyst developing data mapping/handling applications for Dell Services client Tenet Health Care. Unfortunately, I had to cut this contract short due to some medical issues.

Tools used:

All work was performed using iSeries hardware.

ILE RPG (Free Form)

Embedded SQL

RDi

DB2/400

DDL

February 2015 – October 2015

Infovision Consulting

Richardson, TX

Senior Programmer/Analyst performing maintenance and development projects for Frontier Communications using ILE RPG (Free Form) and embedded SQL. Projects involved a major effort to automate assignment of physical network resources for new or upgraded service

March 2013 – February 2015

21st Mortgage Corporation

Sr. Programmer / Analyst

620 Market Square

Knoxville TN 37902

Tools Used:

iSeries hardware.

Free Form and Fixed Format ILE RPG

CLLE

Embedded SQL

DB2/400

DDL

Aldon LMI

IBM Rational Developer.

Involved in all aspects of mortgage applications and servicing. Lead programmer for Variable Rate Loan processing.

Assisted in design of and performed all programming for a new system to administer variable rate mortgages, which were a new business paradigm for 21st Mortgage. This system was created using DDL to create all database tables, ILE RPG and CLLE for all programs. All file I/O was performed using SQL.

June 2012 – March 2013

Prime Therapeutics, Inc.

RPG Programming Consultant

1305 Corporate Center Drive

Eagan, MN 55121

Tools Used: Free Form and Fixed Format ILE RPG, CLLE, Embedded SQL, Hawkeye, MKS Implementer, iSeries hardware.

Applications: Prescription Notification System.

Designed and re-engineered system to accept comma delimited extract files from mail order prescription system, process, and format comma delimited files for transmittal to internal email server and to an external automated phone call vendor. System also received data back from the vendor and passed it back to the pharmacy system. Functions programmed were Refill Reminders, Order Received, Order Shipped, Order Exceptions and “Dispense as Written” modules.

January 2012 – May 2012

Wolters Kluwer Financial Services

RPG Programmer Analyst

6815 Saukview Drive

Saint Cloud, MN 56303

Tools Used: Free Form and Fixed Format ILE RPG, CLLE, Embedded SQL, DB2/400, DDL, Hawkeye

Applications: IRA Accounting.

Consolidated three related files into one, including all related analysis and programming.

July 2011 – December 2011

RPG Programmer Analyst

Green Tree Credit Solutions

345 St Peter Street

Saint Paul, MN 55102

Supervisor: Maureen Atherton

Tools Used: Free Form and Fixed Format ILE RPG, CLLE, Embedded SQL, MKS Implementer, Abstract

Applications: Credit Reporting, Loan Processing, Bankruptcy Processing. Data conversions of payment history for loans purchased from other credit providers.

Performed general system maintenance and enhancement tasks using ILE RPG and heavy SQL and iSeries hardware.

February 2011 – March 2011

RPG Programmer Analyst

Computer Guidance Corporation

15035 N 75th Street

Scottsdale AZ 86272

Supervisor: Ken Kopal

Tools Used: Free Form ILERPG, CLLE, Embedded SQL, WDSC/RDi (Websphere), Aldon CMS

Performed various programming tasks for CGC's construction management software package (eCMS) using iSeries hardware.

September 2009 – October 2009

Contract Programmer

Crescent Solutions

17871 Mitchell N

Irvine CA 92614

Supervisor: Derek Berger

Tools used: RPG4, RPG3, RPG2, CL, SDA, RDA, DBU, iSeries.

Performed a field size expansion project for Island Pacific of Irvine CA. Project entailed analysis of assigned programs for usage of the expanded fields, and modifying programs, displays and printer files, and unit testing the modified elements.

April 2007 – May 2009

Sr. Programmer/Analyst

Copart Auto Auctions, Inc. (NASDAQ: CPRT)

4665 Business Center Drive

Fairfield CA 94534

Tools used:

iSeries

Websphere Development Environment (RDI)

ILERPG, Free Form RPG, RPG4

DB2/400

DDL

CL

SDA

DBU

SDLC Full Lifecycle (Home Grown)

Home grown Change Management System.

Member of the Web Services application team. We designed, wrote, and maintained web services applications using Sun Resin servers. Stored procedures were used to communicate with the iSeries back-end database where all processing was performed. All back-end core programs were written in Control Language or ILE/RPG. Internal and external procedures, free form RPG, imbedded SQL, C language runtime libraries and service programs were utilized. Web Services utilized XML, WSDL, and SOAP.

Served as the EDI technician and Coordinator, responsible for all EDI research, problem solving, mapping, and trading partner contact. I maintained all maps and Trading Partner relationships using Extol EDI software package and was responsible for the daily operation of all EDI functions and audited the integrity of all transactions.

Designed and wrote a generic ACH spreadsheet system to configure EDI ACH customers for automatic generation and sending of custom spreadsheets with the details of the EFTs sent. The system resulted in approximately 95% reduction in MIS effort to meet trading partner needs in this area.

February 2006 - April 2007

On Sabbatical. Spent the year overseas in the Philippines with my new wife.

November 2005 – January 2006

Contract Programmer/Analyst Position

NBC - Universal Home Entertainment Retail Ops

Universal City, CA

Tools used: RPGILE, RPG4, DBU, Turnover

Assisted in a conversion of data feeds from Mainframe Legacy applications to SAP. Data was fed into AS/400 E3 Sales Forecasting system and multiple custom sub-applications. Project included database changes, program changes, and re-writing the Item Master and Customer Master interface programs. Tools used were RPG/ILE programs, bound modules, internal and external procedures, service programs, and imbedded SQL using iSeries hardware.

April 2003 – October 2005

EDI Coordinator / Programmer/Analyst

Corona Clipper

Corona CA 92883

951-***-****

Supervisor: Kevin Howe

Skills, Software, and tools used:

BPCS, Extol (EDI), RPG400 (fixed format), RPG/ILE (Free format), Embedded SQL, Complex CL procedures and CL/ILE modules. Interactive subfile and single panel select prompts,.

Accomplishments and responsibilities:

Responsible for the administration of the company’s EDI operations and technical development, including all new and existing trading partner relationships and transaction sets using Extol software. Trading partners included Home Depot, Lowes, AAFES, Ace Hardware, Wal-Mart, Sam’s Club, and Target.

Selected and installed an AS2 server and developed AS400 RPG programs, AS400 FTP scripts, and PC scripts used to trade documents with Wal-Mart. Execution of programs and scripts were scheduled on both the AS400 and network servers to automate receipt and integration of orders and extraction and transmission of invoice data.

Performed maintenance and enhancement of the AS/400 BPCS enterprise software.

Maintained and created custom reports using RPG/ILE and RPG400 with embedded SQL.

Maintained the plant PC network and label printers and barcode readers.

April 1992 – April 2003

Independent Information Systems AS/400 Consultant

Hardware: iSeries

Systems: RPG400, C/L, Client Access, ILE/RPG, ILE/CL EDI, General Accounting (SW2000, A/P, G/L, Purchasing). Design, program and implement custom systems and modify existing systems. Forms overlays using AFP/400 and IPDS printers. Provide general I/S advice to clients.

Projects: Associated with Amtech Lighting Services intermittently since November 1982, both on staff and as a consultant. Starting in 1982, programmed on an IBM System/34 using RPGII and OCL. Amtech received one of the first System/36’s in Los Angeles where development continued using RPGII, SDA, DFU, and OCL. In 1991, the hardware was upgraded to an AS/400. All existing programs were converted to RPGIV and CL. When ILE functions were introduced, I began using many of the features (Bound Calls, CL Modules, RPG Modules, etc.) My most recent contract there was for approximately two and one half years during which I served as the lead analyst for the IS department, assigning projects to staff and consultants, and performing the bulk of system testing. Involved with the IS Manager and senior corporate management in the design, development, testing, and implementation of nearly all IS projects. Specifically, continued development and enhancement of the integrated Billing and Job Costing system developed in 1991 and 1992. This system automated much of the billing and job costing process by using an internally maintained customer setup database. Using this database, the system is able to decide what items should be billed and which are covered by the contract and thus should only be costed to the contract. During this project, I was responsible for assigning specific tasks to various staff members and contract personnel. Responsible for developing and implementing an EDI system on the AS/400 using Gentran and Sterling’s Commerce Network, including all customer contact and testing. Additionally, performed maintenance and troubleshooting functions, and provided user support on the MIS help line. Served as the de facto database administrator, approving all changes, additions, or deletions to the custom database. During Amtech’s Y2K conversion process singlehandedly performed all maintenance and development tasks while the remainder of the departmental staff and consultants performed the Y2K work.

Associated with Damon, Inc. for a little over one year, concurrently with position at Amtech. This work was performed remotely from home. Designed, developed, and implemented a custom EDI translator to receive warranty claims electronically and load them into the third party warranty system (WC/FieldS). Most recently, this system was enhanced to organize the claims more in line with Damon’s MIS needs. The original effort was geared more to the specific needs of the claims service department. This project enabled Damon to greatly enhance the level of customer service provided to their dealers by speeding up the process electronically and significantly reduced the effort by claims personnel needed to process a claim.

Other Midrange Software (Van Nuys, CA), DB Services (Long Beach, CA), National Medical

Clients: Systems (Aliso Viejo, CA), Unitek (Monrovia, CA), Stanley Tools (New Britain, CT), Nippon Denso (Long Beach, CA), Dogloo, Inc. (Corona, CA), Fila USA (Baltimore, MD), Technicolor Video Services (Camarillo, CA)

March 1991 – April 1992

Sr. Lead Programmer / Analyst

Amtech Lighting Services

9637 Remer Street

So. El Monte, CA

Responsible for design, programming and implementation of a custom integrated AS/400 Billing and Job Costing system, which is still in use today, user training and support, and system operation. RPGIV and CL were the primary tools used on an iSeries.

September 1989 – January 1991

Sr. Consultant

Integrated Technology Group

Itasca, IL

Provided consulting, analyst, and programming services to ITG’s clients in the greater Chicago, IL area. Clients included Ware Pak Inc., Mannesmann Demag, and Best Kosher Sausage (now Hebrew National). Programming was performed on IBM Systems/36 using RPGII and OCL. Also used a 3rd party RPGIII product for various projects.

June 1988 – September 1989

Programmer Analyst

Avery Commercial Products

Covina, CA – Chicago, IL

Created and maintained a network of five IBM System/36’s. Supported four plants (Oxnard, CA / Waco, TX / Roselle, IL / Rolling Meadows, IL). Aided in the design and programming of a custom bidding and scheduling system for production of special orders (custom sizes, colors, and printing of notebook dividers). Due to the complexity of this system, a 3rd party RPGIII language enhancer was utilized. One major project produced using this system was dividers for the Lotus 1-2-3 version 4.0 manuals. A quote that might have taken thirty minutes to prepare by hand took about four or five minutes using the system.

May 1984 – June 1988

Data Processing Consultant

Provided consulting services, analysis, and programming for companies in the greater Los Angeles Area using IBM System/34 and System/36 computers programmed in RPGII and OCL.

April 1981 – May 1984

Programmer / Analyst

Data Theories Corp.

Burbank, CA

Provided consulting services, analysis, and programming for companies in the greater Los Angeles Area using IBM System/34 and System/36 computers programmed in RPGII and OCL.

November 1979 – April 1981

Programmer

Wildwood Computer Industries

Fresno, CA

Provided consulting services, analysis, and programming for companies in Central California using IBM System/34 computers programmed in RPGII and OCL.

Contact this candidate