RPG Programmer Analyst
Resume:
Dennis M. Davenport
Email: *******@*****.***
LinkedIn: www.linkedin.com/in/dmdpgmr
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
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