Uploaded File
add photo
David
dbond@airmail.net
972-276-8972
4526 Lawler Road
Garland, TX 75042
CONSULTANT - PROGRAMMER ANALYST
40 years experience W2
0
Recommendations
Average rating
4
Profile views
Summary

Experience
CONSULTANT - PROGRAMMER ANALYST
Information Technology
Mar 2020 - present
Working remotely from home in Texas, participated in project to convert RMS files on VAX OpenVMS system to Micro Focus COBOL and Oracle on Linux. Modified COBOL programs that were migrated from VAX VMS COBOL to Micro Focus COBOL by removing references and reads of RMS and replacing them with embedded Oracle SQL. Converted VAX OpenVMS batch DCL to BASH shell scripts for batch processing.
Cobol Linux Oracle
Remove Skill
Sep 2010 - present
Participated in an effort to convert thirty Sybase stored procedures into DB/2 stored procedures. Stored procedures were COBOL programs with embedded SQL. Endevor was used as version control/compilation tool. Used MicroFocus Mainframe Express as a debugging too. Participated in daily scrum sessions as part of the Agile methodology.
No skills were added
Remove Skill
Information Technology
Jan 2018 - Dec 2019
Participated in a project to migrate the Department of Human Services from the IBM Mainframe to the Linux server. Helped the operations staff convert the batch schedule from the CA-7 scheduler to ESPBatch/ESPAuto which was developed by Software AG and Cronus. Acted as a technical liaison between the operations staff and the developers at Cronus, which is based in South Africa. Helped convert a Microfocus COBOL based system that accessed four duplicate DB2 databases (based on an old system architecture), to one that accessed only one DB2 database. Wrote stored procedures in SQL Server, using Microsoft SQL Server Management Studio 17 as the interface/editor.
No skills were added
Remove Skill
Information Technology
Jun 2016 - Dec 2017
Using DB2 for Linux/Unix/Windows (LUW), wrote native stored procedures in a Unix environment for the purposes of cleaning claims data for Medicare/Medicaid and private insurance companies, the purpose of which is to insure no duplicate claims be paid and that Medicare/Medicaid are the last payors of record. Toad was used as the database interface and CA Harvest was used for version control.
No skills were added
Remove Skill
Jun 2014 - Jun 2016
Using COBOL, DB2, IMS, MQ Series and CICS made enhancements to and supported several existing EDI and online systems for the purpose of exchanging and maintaining rate, station, junction and embargo information within the railroad industry. ChangeMan was used for version control. Used SPUFI, QMF, BMC and File Aid for DB2 for DB2 queries. Used Xpediter for debugging. Maintained jobs and catalogued procedures with JCL. Used ISPF for text editing.
No skills were added
Remove Skill
Nov 2013 - Jun 2014
Using COBOL, Micro Focus Cobol, IMS and DB2, supported a part number subsystem of a larger materials management system while an SAP materials management system was being implemented to replace the existing system. Endevor was used for version control. Used SPUFI and QMF for DB2 queries. Created jobs and catalogued procedures with JCL. Used TSO/ISPF for text editing.
No skills were added
Remove Skill
Oct 2012 - Aug 2013
Using COBOL and DB2, performed maintenance and enhancement tasks on a system to track subsidies for adoptive and foster parents. Wrote new programs to create letters for purposes of annually reviewing who was eligible for continued guardianship subsidies. Used SPUFI for queries/mass data updates. Wrote programs to track children who were removed from homes and still in the court system. Used CA Gen to create a system to allow users in the field to maintain security (passwords, etc.), thereby saving expenses related to a third party product which they used only once a month. Created jobs and catalogued procedures with JCL. Used TSO/ISPF for text editing.
No skills were added
Remove Skill
May 2012 - Oct 2012
Using COBOL, DB2, CICS and VSAM, performed maintenance and enhancement tasks on a property and casualty system that was used to force place coverage on auto liens and mortgages. Created jobs and catalogued procedures with JCL. Used TSO/ISPF for text editing. Used SPUFI and QMF for queries/mass data updates.
No skills were added
Remove Skill
Sep 2011 - May 2012
Coded COBOL/DB2/CICS Webaware programs in support of contracts between Child Services and foster/adoptive parents and other child services providers. Used Dreamweaver to lay out web page design and then translated the Dreamweaver generated HTML to HTML that was actually usable in the application. Also modified COBOL/CICS Webaware applications. Used TSO/ISPF for text editing. Created jobs and catalogued procedures with JCL. Used SPUFI and QMF for queries/mass data updates.
No skills were added
Remove Skill
Information Technology
Feb 2011 - Sep 2011
Participated in an effort to convert a COBOL/ADABAS system to COBOL/DB2. Developed COBOL/DB2 programs that interfaced with Software AG's EntireX communication broker, which, in turn, communicated with web pages developed in Java. Was involved in performance tuning of DB2 cursors that were used for search queries. Used BMC to run Explains in order to determine best use of table indexes. Used Desktop QMF, Endevor and Endevor QuickEdit.
No skills were added
Remove Skill
Jan 2009 - Sep 2010
Using Cool: Gen 7.6, maintained a licensing and registration system. Tasks included changing server applications and generating Java EAR files/WAS servers. Worked with Component Based Development (CBD). Also made changes to COBOL programs and analyzed the system for changes resulting in detailed program specifications. Used GuardIEn and Access Gen for accessing the CSE. Specifically used GuardIEn for subsetting and model compares. Worked with Control-M for maintaining job schedule.
No skills were added
Remove Skill
Jun 2006 - Dec 2008
Using Cool: Gen 6.0, Advantage Gen 6.5 and Oracle, made changes to an existing cost accounting system used to track and allocate costs to various truck, plane and ship bound shipments. Using Kornshell and Perl scripting along with PL/SQL and ESP, I automated a previously manual batch process. Also was responsible for generating and testing the system in Advantage Gen 6.5 in anticipation for conversion from Cool Gen 6.0 to Advantage Gen 6.5. Toad and SQL Developer were used as the database interfaces . Sun Solaris Unix was the operating system.
No skills were added
Remove Skill
Mar 2006 - Jun 2006
Using Cool: Gen 6.0 wrote both GUI and batch programs to support a supply chain management system that interfaced with a.NET application through Websphere MQ. Wrote COBOL/DB2 programs. Also used FMDB2.
No skills were added
Remove Skill
Sep 2005 - Mar 2006
Made enhancements and performed maintenance duties with an existing Temporary Assistance and Food Stamps system. Analyzed and wrote specifications for development of new Medicaid interface Modules while also writing those new modules. Programming was done in Cool: Gen 6.0, COBOL DB2 and CICS under the MVS operating system. Used SPUFI and QMF along with Xpediter, Fileaid and Platinum as debugging tools.
No skills were added
Remove Skill
Apr 2004 - Sep 2005
Supporting a credit card promotions system, wrote DB2 stored procedures for table maintenance that were called via several Cobol conversion programs to take existing DB2 tables and QSAM files, convert record layouts and write the new format record to the Websphere MQ Queue for further processing in the job stream. Used MVS, ISPF, COBOL, DB2 and Websphere MQ Series on an IBM mainframe under an MVS operating system. Used COBOL, DB2 Stored Procedures and Websphere MQ to write applications that interfaced with a Java rules engine that calculated points available to credit card customers as rewards for using their credit cards. Endevor was used for version control.
No skills were added
Remove Skill
Sep 2003 - Apr 2004
Using Cool: Gen 5.1, I made enhancements to a membership system to allow for flexibility in enrollments (e. g., higher deductible and lower premium or higher premium and lower deductible) of new customers. This was an effort to make the company more competitive in the market place. A mix of block mode and GUI were used. The target was CICS/MVS on an IBM Mainframe. I also coded native COBOL/DB2 programs.
No skills were added
Remove Skill
Apr 2003 - Sep 2003
Using Cool: Gen 6.0, I made enhancements to an existing inventory replenishment system. This was a GUI/Client Server and web based system. Component based development was used. I generated ASP and VB com proxies. OCX and OLE controls were used extensively. The server was an IBM mainframe operating in a CICS region.
No skills were added
Remove Skill
Sep 2002 - Apr 2003
Using Cool: Gen 5.1, I made changes to an existing block mode system which runs under MVS on an IBM mainframe. My specific duties were to make changes to the advertisement planning and pagination systems so that the marketing department could track more closely the effect on sales of certain national advertisement campaigns. Other duties included writing COBOL programs to extract data from the DB2 tables for loading to the Teradata tables. Writing specifications, designing DB2 tables and testing were included in all these tasks.
No skills were added
Remove Skill
Jan 2002 - Sep 2002
Using Cool: Gen 5.1, I worked on the team that rewrote the titling and registration system of the State of Wisconsin Department of Transportation. My specific duties included the writing of the subsystem that calculated all fees for titling and registration. Part of my duties included training and assigning tasks to a person who was new to Cool: Gen. The environment was GUI/Client Server and batch on an IBM mainframe under an MVS operating system using DB2 and CICS. I wrote both batch procedures and GUI clients, along with servers. UDB 7.0 was used for data manipulation and testing. I wrote JCL for executing batch procedures. TSO/ISPF, SPUFI and QMF were used for interfacing with and testing on the mainframe.
No skills were added
Remove Skill
Jul 2001 - Jan 2002
Wrote COBOL/DB2 programs to extract data from an IBM mainframe legacy system and providing interfaces to an SAP system. The environment was Windows NT and 200, IBM/MVS, using JCL, TSO/ ISPF, Fileaid and Xpediter.
No skills were added
Remove Skill
Feb 2000 - Jul 2001
Using Cool: Gen 4.1, performed maintenance/enhancement tasks on existing State of New Mexico Child Support System. Target was IBM mainframe with CICS/DB2. As part of my tasks, I created my own aggregate sets and migrated my own code changes from model to model.
No skills were added
Remove Skill
Jan 1999 - Feb 2000
Using component-based development with the Cool: Gen (version 5.0) tool, I helped in the development of the Claims processing system for Texas Medicaid. I was specifically responsible for the analyis, development and user support of claims processing for the Nursing Facilities subsystem. The environment was GUI, Client/Server and Tandem. Used GuardIEn for subsetting.
No skills were added
Remove Skill
Banking/Financial
Sep 1998 - Jan 1999
Performed testing of banking applications for an internal customer in Des Moines, Iowa to insure Y2K compliance. Part of the application interfaces were in COBOL and VSAM.
No skills were added
Remove Skill
May 1998 - Sep 1998
Performed QA/Testing functions during final phase of Y2K project. COBOL/DB2 were used.
No skills were added
Remove Skill
Banking/Financial
Mar 1998 - May 1998
Worked on system to allow for direct withdrawals from bank accounts as a means of allowing customers to pay for services such as travel and auto clubs. This was a GUI -Client/Server application developed with Cool: gen, with COBOL/CICS/DB2 as the target server platform and C /Windows NT as the target Client platform.
No skills were added
Remove Skill
Nov 1997 - Mar 1998
Worked on eligibility subsystem of larger billing system, making changes to allow for the recoupment of several millions of dollars in unpaid bills. System was developed in IEF/Composer with COBOL/DB2/CICS as a target environment.
No skills were added
Remove Skill
Feb 1997 - Nov 1997
Worked as part of an integration test team for the development of the National Crime Information Center upgrade/rewrite for the FBI. System was written in IEF/Composer with COBOL/DB2/CICS/CICSPLEX in an MVS SYSPLEX environment as the target.
No skills were added
Remove Skill
Sep 1996 - Feb 1997
Worked as part of a team to make fixes to the State of Missouri Automated Child Support System as a result of integration testing and in preparation for final user acceptance testing. Used IEF/Composer 5.3 with COBOL/CICS/DB2 as a target environment.
No skills were added
Remove Skill
Mar 1996 - Sep 1996
Coded functional prototypes in support of analysts for Asset Management and Audit Trail subsystems of a greater Welfare Reform system. Also wrote the actual code for those applications. Environment was IEF Composer Windows Client/Server. Windows were operated under OS/2 and Server applications were targeted to DB/2 on an MVS server under a CICS region. Also attended a week of training in building client/server applications with GUI. This training was performed by Texas Instruments at one of their remote training sites.
No skills were added
Remove Skill
Jan 1996 - Mar 1996
Coded online screens in a CICS/DB2 environment, the purpose of which was to automate a paper-based fuel accounting system.
No skills were added
Remove Skill
Information Technology
Oct 1995 - Jan 1996
Involved in a pilot project to determine the efficacy of I/O routines. Included in this task was the rewrite of the server side of a previously written IEF Composer Windows Client/Server application, The purpose of this task was to compare SQL calls generated by IEF Composer with IEF Composer External Action blocks that called ORACLE stored procedures. Testing was done on an OS/2 workstation accessing ORACLE databases on the HP/9000 via ORACLE SQLNET.
No skills were added
Remove Skill
Apr 1995 - Oct 1995
Performed many maintenance tasks to existing IEF-based systems. Primary duties were making enhancements to the Mainframe-to-PC sales/marketing interface. IEF 5.3 Composer was used in this task.
No skills were added
Remove Skill
Information Technology
Jan 1995 - Apr 1995
Using IEF 5.3 Composer, made major improvements/enhancements to the Conversion/BAA Data Model. Also created and refined Activity Hierarchy Diagram. Acted as technical advisor to a team of coders/developers with limited IEF experience. Assisted the Central Encyclopedia Administrator.
No skills were added
Remove Skill
Professional/Consulting Services
Mar 1994 - Jan 1995
Using IEF 5.2, MS Windows, MS Word, and MS EXCEL, wrote functional and detail specifications for the Materials subsystem of the larger Outside Procurement and Construction Materials (OSPCM) system. Tasks included work on the data model, user interviews and documentation of those user interviews with the end-result being functional specifications and detail specifications. A Local Area Network and Mainframe COBOL/CICS/DB2 were the target environments. Also coded in IEF 5.2 for a Buyer Contract Performance system and for a network system which provided data to the billing system.
No skills were added
Remove Skill
Information Technology
Jan 1994 - Mar 1994
Using IEF 5.2 on the Local Area Network and OS/2 2.1 and OS/MVS/ESA operating systems, worked in conjunction with Texas Instruments to create online Purchase Agreement transactions as part of a larger Order Processing System for a third-party client. Target online environment was IMS and DB2, which included manipulation of MFS for transaction switching. All code generation and testing was on the LAN prior to generating and testing on the mainframe. SQL on the LAN via OS2 used extensively. Functions included subsetting and scoping the model in the encyclopedia action diagramming in the BSD and Construction. Extensive use of the debug facility of IEF. All project documentation and standards were kept on Lotus Notes.
No skills were added
Remove Skill
Nov 1993 - Jan 1994
Using IEF 5.1 under the OS/2 2.1 and OS/MVS/ESA environments, worked in conjunction with Perot Systems to develop a meter lot/testing tracking system for Northern States Power of Minneapolis, Minnesota. Coded online applications to track lot jobs and tasks. Functions included subsetting and scoping the model in the encyclopedia action diagramming, dialogue design and screen design in the BSD and Construction. Extensive use of the debug facility of IEF.
No skills were added
Remove Skill
Chemicals/Pharmaceuticals
Apr 1993 - Nov 1993
Using IEF and DB2, provided major enhancements by modifying transactions to track whether or not hazardous materials being handled by the chemicals division of the semi-conductor operations were permitted. Extensive use of external action blocks included. Also included was the use of SPUFI along with DB2/SQL calls in COBOL II programs. IEF functions included subsetting and scoping the model in the encyclopedia action diagramming in the BSD Technical Design Construction. Extensive use of the debug facility of IEF.
No skills were added
Remove Skill
Feb 1993 - Apr 1993
of Kansas Documented and made user requested changes to the claims processing system. This included the use of COBOL, COBOL II, IMS, DB/DC and DB2. Extensive use of SPUFI and QMF along with embedded DB2/SQL calls in COBOL II programs.
No skills were added
Remove Skill
Dec 1992 - Feb 1993
Participated in coding of online system for tracking refunds of customers who overpaid their freight bills. This was done in COBOL II, DB2 and IMS DB/DC. XPEDITER and FILE-AID were used extensively as debugging tools.
No skills were added
Remove Skill
Oct 1992 - Nov 1992
Logic Designed and wrote a system for computer time usage (VSAM, TSO, ORACLE) of several partners in an RTC service contract. Used COBOL II and VSAM in this effort.
No skills were added
Remove Skill
Senior Programmer/Analyst
Information Technology
Jun 1989 - Oct 1992
Responsible for the analysis, development and support of Manufacturing and Transportation Systems for chemical plants and terminals in the U. S. and Canada. These systems were written in PLI, COBOL, DB2, IMS DB/DC and CICS on the IBM 3090 mainframe and the PS/2/PC. Was a user of a Local Area Network. Specific subsystems included a Tracking System for the tracking of shipments of methanol from Canada to the U. S., a Barge/Ship Scheduling and Tracking Subsystem, an Employee Health and Safety Reporting System and a PC-based Certificate of Analysis System. Using POSE (Picture Oriented Software Engineering), created data model of the new Ship/Barge Scheduling System to be developed in DB2. Used this tool to normalize resultant database, to generate DDLAs for DB2 and to write pseudo-code from which the program logic could be coded.
CICS Cobol DB2 IMS Software Engineer
Remove Skill
Mar 1989 - Jun 1989
AMERICA
No skills were added
Remove Skill
Information Technology
Mar 1989 - Mar 1989
of North America, Forth Worth, Texas. Programmed online OSHA product testing form using ADF. ARCO Alaska, Inc., Anchorage, Alaska. Made user-requested modifications to a materials processing system purchased from American Software Incorporated.
No skills were added
Remove Skill
Mar 1989 - Mar 1989
Analyzed Capital Reporting System in order to identify and change programs to include multi-company processing.
No skills were added
Remove Skill
Chemicals/Pharmaceuticals
Mar 1988 - Mar 1989
Created programs to download Human Resources data from the Oil CorporationAs IMS databases to QSAM files that could be used by Mobil Chemical Corporation
No skills were added
Remove Skill
ARCO Oil and Gas
Jun 1987 - Mar 1988
Performed Programmer/Analyst duties on a backlog of maintenance requests in Crude Oil Marketing System.
No skills were added
Remove Skill
Jan 1986 - Jun 1987
PROFESSIONAL SERVICES GROUP Chrysler Electronics, Huntsville, Alabama. Worked on large team converting materials processing system from Honeywell COBOL/IDS to COBOL IMS DB/DC.
No skills were added
Remove Skill
Information Technology
Nov 1985 - Jan 1986
Using ADF, developed a security database system for use by marketing departments.
No skills were added
Remove Skill
SENIOR PROGRAMMER/ANALYST
Information Technology
Mar 1985 - Nov 1985
Implemented marketing systems developed by Canadian Tire, the parent of White Stores. Made enhancements to inventory control and product maintenance systems. System was composed of fifty to one-hundred batch and online programs. Extensive use of DLI calls. Environment was IMS DB/DC. (The Company closed in Bankruptcy.)
IMS
Remove Skill
PROGRAMMER/ANALYST
Information Technology
Mar 1983 - Mar 1985
Responsible for maintenance of the customer accounting system, especially the employee time tracking system. Transferred to development of new Customer Information System. Specifically served on conversion team, using ADF, PLI and COBOL in this effort. Developed new processing for changing mailing address street names to conform to postal service standards.
Cobol
Remove Skill
PROGRAMMER/ANALYST
Information Technology
Feb 1981 - Mar 1983
Maintenance of wide range of applications. Major area was customer accounting system. Original coding of PCB Oil Samples System. Environment was PLI, CICS, VSAM and MVS and Easytrieve.
CICS VSAM
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Political Science
Northwestern State University 1980
Minor: Computer Science
Record has not been verified.
Six additional hours of Computer Science
not provided
Record has not been verified.
Fifteen hours toward
University of Texas at Dallas
Record has not been verified.
Skills
CICS
1992
5
Cobol
2021
5
DB2
1992
3
IMS
1992
3
Software Engineer
1992
3
VSAM
1983
2
Linux
2021
1
Oracle
2021
1