David Dunfield

PO Box 1481

Portage, MI 49081

dunfie@chartermi.net

 

I have thirty-four years experience providing IT business solutions.  My experience includes IT management, project management, systems analysis and design, programming and application support and training.   I have since worked as an AS400 / iSeries development consultant for a many companies in a variety of industries.  Most of my development exposure is working with either clients homegrown applications or my own custom applications. I have worked with some packages (MAPICS, HTE, Frontier, etc), creating custom programming to interface with those packages in both RPG/ILE and LANSA.

 

I have a strong technical and programming background but my real strengths lie in my business knowledge, my ability to understand and adapt to new situations and the way I work with people.  I am honest and realistic in both my solutions to problems and in reporting to management.  I try to bring the most practical and efficient solution to each opportunity without sacrificing quality.  

My accomplishments include:

q       As Data Processing Manager, I designed and programmed in RPGIII a complete manufacturing, accounting, sales and payroll system, including MRP, production scheduling and control and inventory management.

q       Working as a consultant, with my partner developed and implemented a complete Y2K conversion package in ILE RPG that provided scans and cross references of field usage. Using the files generated, I developed a conversion program generator that interfaced with our ILE conversion service programs to generate RPG/ILE conversion programs for over 5,000 files for an insurance client. 

q       Working as a consultant on a team of twenty, designed and developed RPG programs to convert a MVS Insurance Claims system to AS/400. Results saved client over $50,000 per month in software fees alone.

q       As a consultant to a major Pharmaceutical company, served on the team of 200 responsible for implementing a homegrown production and manufacturing control system. Developed and programmed interfaces to other non-AS/400 computer systems at client in RPG ILE, including interface to a DEC Laboratory Management System.  Also worked on Food and Drug Administration compliance documentation and testing.

q       Working for a regional Restaurant Chain, served on a development team of eight programmers. Developed and programmed in RPG III inventory cost system. Also supported homegrown General Ledger and Payroll systems. Responsible for conversion of applications from System/38 to AS/400, planned and managed the upgrade.

q       As a consultant on a team of twenty, developed and programmed in ILE RPG a complete XML Generator, including service programs to transfer real time insurance transactions to a remote Oracle Data Warehouse. XML generator interfaced with AS/400 C service programs to provide access to IFS.  Created fifty trigger programs in ILE RPG to handle transactions.

q       As a consultant designed and developed a Web Site for Vehicle Registration for a Major University. Site allowed Students to register their vehicles. Annual cost savings were over $50,000.

q       Working with my partner, designed and developed in LANSA for the Web and Visual LANSA, a PDA application for Park Rangers to record problems in parks directly into an AS/400 database used to dispatch repair crews. Revised the PDA application to run in Tablet PC’s using LANSA Web Application Modules (WAM’s).

q       Working with my partner, developed a LANSA based scan system to document data file changes for a LANSA client. Using the data file,  I developed an ILE/RPG conversion program generator, using service programs that automatically converted all files identified in the scan.

q       Designed and developed a quote tracing and printing system interfacing with Freedman Frontier manufacturing software, in Visual LANSA for a major manufacturer. Subsequently, developed a new lead tracking system in Visual LANSA and LANSA for the Web.

q       Designed and Developed a Warranty Claim Tracking System in Microsoft Access that automatically pulls Product and Customer information from System I database and also generates XML for posting to data warehouse.

 

 

 

 

SYSTEM ENVIRONMENT SUMMARY:

Computer

Languages

 

Software Applications

IBM AS400 / iSeries

RPG III, IV, RPG/Free,ILE, CL, SQL, COBOL/400,DDS, SDA, DB2,  and many AS400 Utilities including DBU, RDA, Aldon  etc.

LANSA, LANSA for the Web, Visual LANSA, LANSA Web Application Modules

 

I and designed and programmed many custom Manufacturing, Financial, Accounting, Sales, Distribution , Insurance,  Logistics, and other applications.  I have also converted several different systems and applications to the AS400 and upgraded older AS400 code to RPG400 and ILE and instrumental Y2K compliance for several companies.

Have created two different ILE File Conversion Program Generators for two project.

IBM SYS 36,38

RPG, RPG II, RPG III, OCL, SDA DDS, DB2,  + others

 

Custom Programming

HP3000

COBOL

 

Custom Applications

PC Systems

Languages and Tools

Visual Basic, Microsoft Office products including ACCESS, EXCEL, MS Project, FrontPage, Outlook, etc.   I've worked with most Windows operating systems including 3x -95-98, ME, NT, XP, and 2000.    

 

Proficient in many PC tools including all MS Office as well as many Web development products, Graphics and Multimedia Tools.  I primarily use the PC as a reporting tool and a link to the main frame but should not be considered as a PC Developer.  I have, however designed and developed Web applications for a number of small businesses and designed Access data base solutions

 


 

 

SUMMARY OF INDUSTRY EXPERIENCE:

Industry

Application

 

Summary

Distribution and Logistics 

Custom Software 

 

Systems Analysis and Programming custom warehouse and distribution applications for Restaurant chain in RPG.

Government

Custom Software development

 

Custom Park Ranger Application

Manufacturing

MAPICS, Custom Software, ASI COPS

 

Project Manager, Programmer   for Restaurant commissary operations.   IS Manager for a shopping cart wheel manufacturer. Developer Quote System.  Costing systems.

Retail

Custom Software

 

Consultant for conversion of shoe retailer data base

 

Insurance

Custom Software

 

Developed XML generator. Y2k Conversion, Many custom RPG/ILE applications.

Financial

All general Accounting and GL and Banking and Finance custom

 

I have worked with various accounting packages and designed complete accounting, Sales, Forecasting, Commissions, Order Processing, and General Ledger. 

Other

Change Control Project Management

Application Design

Web Development

Data Base (DB2 DDS)

 

I am an experienced application designer and programmer and I have worked as a data base administrator and designer.   I have also worked with a variety of Change Control applications and have managed many software rollouts.   I am experienced with MOST PC applications such as Excel, Word, ACCESS, multimedia, etc.

Warranty Tracking

MS Access Database

 

Database integrated with AS/400 Data, including XML extracts.

 


 

 

 

 

    

 

 

 

 

 

PROJECT/CAREER HISTORY

 

Most Recent Client: Tyler Refrigeration

Iseries Contract Developer          Sept 2006- Present

Worked on a variety of manufacturing, engineering and financial applications using RPG ILE RPG/Free and COBOL/400. Designed and Created Microsoft Access Warranty Claims Database, extracting and posting data to AS/400 and generating XML to post to Data Warehouse.

Client: City of Portage

Iseries - AS/400 LANSA Consultant (Contract)                             2001 - 2006

 

Provided design, technical and programming support with all aspects of Lansa Parks and Streets Application built on HTE Government Work Request Application

 

Part of a two-person effort to design and create a custom Interface to HTE application using Visual LANSA including database file sync from Iseries to individual laptops for disconnected data entry of Streets activity. Imported over one hundred fifty files into LANSA. Added Rules, Access Paths, Predetermined Join Fields, and Triggers to files. Created additional Files, fields rules etc. in LANSA and created custom Visual LANSA Applications to maintain files.

 

Designed and created LANSA Integrator application to receive data from Park Ranger PDA Units into LANSA Iseries files.

 

Created Embedded Visual Basic application on PDA using data transferred from Iseries using LANSA for the Web.

 

Upgraded Client to LANSA Version 11.

 

Using LANSA Web Application Modules, upgrade Parks PDA units to Tablet PC’s directly updating Iseries Parks database from field.

 

Tools/Languages used include RPG/ILE, SQL, LANSA for AS/400, LANSA for the Web, Visual LANSA, LANSA Web Application Modules, Visual Basic, Triggers.

 

Client: RPA Process Technologies

 

ISeries-AS/400 LANSA Consultant (Contract)                             2001 - 2006

 

Worked with users and designed, created and built Visual LANSA based Quotation System that extracts data from Freedman Frontier Data base to create Microsoft Word Quotations. Also has follow up and management of open quotes. Imported thirty files into LANSA. Created 10 additional files in LANSA. Added rules, Access Paths, Predetermined Join Fields, and Triggers to files. Provided file maintenance and display in Visual LANSA. Extracted complex data elements from Friedman, including parsing of a 1500 byte string into various data elements with various positions and lengths based upon other fields defined in Freidman using LANSA. Built Visual LANSA component to interface with Microsoft Word to create Quotes based upon above extracted elements. Created a Quote Follow Up system in Visual LANSA.

 

Designed and created LANSA for the Web & Visual LANSA Application for capturing Employee Absentee Information, including e-mailing to supervisor for approval.

 

Designed and created LANSA for the Web and Visual LANSA application for tracking new sales leads.

 

Tools/Languages used include LANSA, Visual LANSA, and LANSA for the Web, HTML.

 

Cardinal Health

 

ISeries-AS/400 Consultant (Contract)                                                     2005 – 2006 

 

Created process to analyze systems for Sarbanes-Oxley compliance. Working with application developers and auditors, performed evaluation on Credit and Re Bill Chargeback system. Analyzed and created Business Rules documents based upon RPG and CL Programs.

   

PFIZER

 

ISeries-AS/400 Consultant (Contract)                                                     2005 – 2005 

 

Part of team installing Pfizer MAPS (Manufacturing and Production System). Develop Custom RPGLE Interfaces between Lab applications and MAPS. Develop Custom RPGLE Label Programs to interface with T.L. Ashford. Create Compliance documents for FDA and SOX. Served as code review team leader assuring compliance with FDA and SOX documentation.

 

Tools/Languages used include RPG/ILE, SQL, T. L. Ashford.

 

 

Famous Footwear/Brown Shoe Company

 

ISeries-AS/400 LANSA Consultant (Contract)                             2004 – 2005 

 

Developed LANSA cross-reference tool & Project Control Tool for use in conversion of LANSA database and programs.

 

Managed and implemented conversion over 400 LANSA functions with over 200 file name changes and over 11000 field name changes.

 

Created Automatic RPGLE Conversion Program Generator that using above database generated over 300 conversion programs to reform client files.

 

Tools/Languages used include RPG/ILE, LANSA for AS/400.

    

 Client: Cooperative Elevator

 

 ISeries – AS/400 LANSA Consultant (Contract)                             2002 – 2003

 

Provided LANSA mentoring to client programmer. Taught LANSA RDML, tutoring on files, fields, rules, triggers and Visual LANSA. Helped client with several Visual LANSA projects.

 

Tools/Languages used include RPG/ILE, SQL, LANSA for AS/400, LANSA for the Web, Visual LANSA.

 

Client: Ameriwood

 

ISeries – AS/400 RPGLE (Contract)                                                     2002 – 2002

 

Worked as developer and senior RPG programmer on several RPG projects supporting MAPICS.

 

Tools/Languages used include RPG/ILE, SQL.

  

Client: CBCA Inc.

 

iSeries – AS/400 Consultant (Contract)                                         2002 – 2004

 

Working with client and client customer, designed and programmed special file transfer to Blue Cross.

 

Designed an RPG ILE XML process to send real time insurance claims data from AS/400 claims system transactions to Oracle Data Warehouse.

 

Tools/Languages used include RPG/ILE, SQL, XML, HTML, Triggers and Oracle.

 

Client: Interkal, Inc.

 

ISeries – AS/400 Consultant (Contract)                                         2002 – 2005

 

Researched, planned and implemented OS/400 V5R3 Upgrade. Trained Client staff in how to upgrade OS.

 

Researched, planned and implemented OS/400 V5R1. Trained Client staff in how to upgrade OS.

 

Client: Western Michigan University

  ISeries – AS/400 and LANSA Consultant (Contract)                 1999- 2005    

 

Lead  two person team. Designed and created Web site for Student Vehicle Registration using LANSA for the Web. Imported over one hundred files into LANSA. Added Rules, Access Paths, Predetermined Join Fields, and Triggers to files. Created LANSA for the Web site for Student Registration of Vehicles. Created Student Parking Sticker Pick up Process, printing receipts using LANSA.  Provided LANSA for the Web interface for Parking Tickets.

Planned, managed and executed Y2K conversion of Parking System application.

Trained client manager to manage web site, and program using LANSA.

Tools/Languages used include RPG/ILE, SQL, LANSA for AS/400, LANSA for the Web, Visual LANSA, HTML..

 

Client: Health Risk Management

 

ISeries – AS/400 Consultant (Contract)                                         1994- 2001

 

Planned, Managed and executed Y2K conversion of Insurance Claims Processing System including expansion of other fields in database to enhance application for future growth. Over 3000 fields in 6000 files and 3000 RPG programs were changed, many using our home built Visual Age RPG and RPGLE Code generator. Client development team continued new programming during conversion effort. Developed synchronization processes to keep changes updated during conversion. Actual automated file conversion was completed successfully over one weekend.

 Designed and Programmed RPGLE Phone tracking System

Managed, developed and programmed conversion of ERISCO Claims system from Mainframe to AS/400 system saving client $20,000 per month.

Managed and Programmed many other RPG Insurance Projects

Tools/Languages used include RPG/ILE, and SQL.

 Client: Crown Vantage Inc.

 

ISeries – AS/400 Consultant (Contract)                                         1994- 1996

 

Helped Client recover from botched V3R1 Upgrade.

Created payroll bank download using bisynchronous communications.

Tools/Languages use RPG/400.

 

Client: City of Albion

 

ISeries – AS/400 Consultant (Contract)                                         1994- 1998

 

Maintained OS/400.Applied PTFs, Performed V2R3 to V3R1 upgrade. Maintained Tax, payroll and other Governmental applications.

 

Client: Allegan County

 

ISeries – AS/400 Consultant (Contract)                                         1994- 1996

 

Trained client Staff to use Office vision.

 

Performed performance tuning and upgrade recommendations for 911 AS/400 system. 

Employer: Bill Knapps Restaurants

 

iSeries – AS/400 Senior Systems Analyst                                              1989- 1994

             

Project Manager for development of product cost accounting, AS/400 save/restore recovery procedures, system utilities, payroll development and programming, Accounts Payable System design and programming, system performance tuning, PC Support/400 and all AS/400 Technical aspects.

 

Project Manager responsible for initial AS/400 installation and migration from System/38, Migration to new releases, and training technical staff.

 

 Planed and Implemented Implement networking of AS/400 Systems.

 

Responsible for Operating System Support.

 

Tools/Languages used RPG/400, SQL, SEQUEL.

 

Client: Stafford Smith Inc.

 

Cobol Consultant (Contract)                                                                 1985-1987

 

Designed and Programmed Accounts Payable, General Ledger, Job Costing, Accounts receivable, and Payroll systems in COBOL on a Hewlett Packard 3000 computer system.

 

Client: International Research and Development

 

RPG and Cobol Consultant (Contract)                                                     1979-1982

 

Worked with Accounting Department of International Research and Development Corporation. Assisted in the installation of Cascade Data Concept I computer. Served as sole developer designing and programming  Payroll, Billing, Accounts Payable, General Ledger, Cost Accounting, and Personnel systems in RPG II.

Managed conversion of  migration from Cascade System to a DEC VAX 11/780 system including manually converting over 100 RPG programs to COBOL. Accounting department staff and two programmers were under direct supervision for the project.

 

 

Employer: Jarvis Pemco

 

Data Processing Manager                                                                    1973- 1989

 

Responsible for all computer services including hardware, software, personnel, supplies and outside services. Also served as backup to the Company Controller. Developed and programmed on-line manufacturing and accounting systems including Material Requirements Planning, Inventory Control and Costing, Bill of Materials, Capacity Planning, Production Scheduling and Control, Preventive Maintenance, Order entry, Project Control, Accounts Receivable, Accounts Payable, General Ledger, Payroll, and Budgeting.

 

Managed and implemented system migrations including from a Cascade Data Concept I to a Honeywell Level 62 and a migration from the Honeywell to an IBM System/38 in October 1982.

 

EDUCATION

 

Attended Kalamazoo Valley Community College from 1969 to 1973. Courses included general business, accounting, and data processing.

 

PROFESSIONAL DEVELOPMENT

Technical classes and seminars attended include RPG III, COBOL, MAPICS, system design, and security planning. Also attended many COMMON Conferences.

IBM Classes include Application Programming and Implementation I&II, AS/400 for the experienced System/38 Implementer, and many local IBM seminars.

LANSA Classes Include LANSA Fundamentals, LANSA for the Web, Visual LANSA, Advanced Visual LANSA, LANSA Integrator and Surround Technologies VL Frameworks.

Attended the Rochester Summit at IBM Rochester, and attended four other sessions at IBM Rochester on Client/Server, Websphere and Year 2000.

 

 

PERSONAL DATA

 

Served two terms as Treasurer and two terms on the Board of directors as Level 62 Project Manager for Computer Management Association. Responsible for the 1980 Computer Management Association Fall Conference held in Kalamazoo with over 100 attendees.

Past President of Honeywell Users Group for Out state Michigan. Also served one term as board member of North American Honeywell Users Group. Was guest speaker twice for Southwest Michigan System/38 Users Group giving presentations on HELP programming and Personal Services/38.

Served Several Years as Board Member of the I-94 Iseries User Group

Currently serves as Tech Roundtable Session Moderator for the I-94 Iseries Users Group and has made several presentations on SQL/400, Triggers and Y2K to that group and to West Michigan System Users Group.

 

Co-authored Text Search Services for News/400, December 1993.