Send email to huenger.david@aol.com
Experience/Skill Sets/Bottom of Page/Education
B.S., St. John Fisher College, Rochester, NY, 1976.
Certificate in Data Processing Northeastern University, Boston, MA, 1984.
Extensive coding experience in the following industries; Finance, Transportation, Utilities and Insurance. Experience with relational (MySQL, DB2 & IDMS) & hiercle (IMS) Data Repositories. Creation of application solutions that utilize the strengths of Legacy Programming and WEB technology.
Web: Java 2 on J2EE 1.4 platform and IBM WebSphere Application Server(WSAD) , MySQL, JavaScript & HTML , CSS, Informatica(Data Integration) & Teradata SQL Assistant 6.2., VISIO, Word, IBM's AFP Workbench for Windows NT, & APS(MFEE).Mainframe:
MVS/XA, DOS, DOS Commands, JCL, DB2, IMS/DLI, IDMS, VSAM, COBOL/370, VS-COBOL-II, VS-COBOL, OS-PLI, CICS (COMMAND-LEVEL), TSO/ISPF, 370 ASSEMBLER, AFP (PMF, PPFA, OGL), IDCAMS, SQL, SPUFI, QMF, Expeditor, GDDM/MVS, GDDM-PGF, Abend-Aid, File-Aid, C-LIST, REXX, GAMMA/ADW(Case Technology), APS(Case Technology), SDF2, Dialog Manager, DB2/VSAM Utilities, ChangeMan, On Demand for OS/390, MQ Series Messaging, NearArchive, Xenos Software, Endevor & ISPF Screens.
VSAM File Processing, Dialog Manager Screens and GDDM programming(Main frame graphics).Top of the Page
February, 1989 to PRESENT - INDEPENDENT CONTRACT PROGRAMMER (Point & Click for additional information).
KFORCE/US Air Force , 13850 Hill AFB UT, MVS/DB2/Client Server Project 25*
Long term contract supporting legacy applications i.e., Change Management-ISPF Dialogs/JCL, MicroFocus-MFEEE & home grown GUI(AMB), utility for MFEEE. Integrated various legacy applications with the web via web services• Created called program to extract string & numeric data from XML input.
using various protocols i.e. http & https. Provided 24 X 7 MFEEE support.
• Created CICS programs, employing web services & HTTP servers, for the purpose of exchanging data.
• Created ADHOC CICS server applications, CICS programs functioning as HTTP clients communicating with HTTP
servers. Built green screens to access ADHOC CICS server transactions, extracting data from XML output.
• Additionally created CICS programs that executed in house web services, Binding, WSDL & Description files built via IBM utilities.
• Supported Micro-focus, MFEEE development tools (in-house & vendor supplied) enhancing program development.
• Project Lead, Installation of CA Enterprise Workbench software, providing a bridge Data Studio & ENDEVOR.
• Modified existing CICS Exit program to supply the HTTP Basic Authentication header in CICS TS.
• Final Secret clearance granted 05/07/2013.
Environment: APS/MFEEE Desk top App/DB2 Ver 9/ENDEVOR/ISPF-Dialog Manager.
Click for project history.
Bank of America, 13850 BALLANTYNE CORPORATE PL CHARLOTTE NC 28277, MVS/DB2/Client Server Project 24*
Created batch program & JCL for monthly/weekly Dash Board Reporting System. System extracts measures for Banking Centers and rolled up data of CMM, Team, Area Exec, Region & Channel. Created adhoc queries from MAS DB2 tables, i.e., create DML commands for COBOL batch programs and various DB2 utilities.
Enviroment: COBOL 370/DB2 Ver 9/Changeman.
Click for project history.
Wells Fargo, Technology Dr Charlotte NC 28262, MVS Project 23*
Four to Six month contract to retire & migrate existing main frame systems from Wachovia M/F to Wels Fargo M/F. Stepped in to provide ENDEVOR expertise, creating & populating packages required to populateproduction libraries. Environment: COBOL 370/DB2/Endevor.
Clemson University, 934 Old Clemson Highway Clemson SC 29672, 22*
Six month contract providing production support for the MEDS system.Provided 24X7 on-call support to troubleshoot issues for assigned applications. Environment: COBOL 370/IDMS.
Click for project history.
Colonial Life, 1200 Colonial Blvd Columbia SC 29210, 21*
Designed and coded new Data Warehouse core tables & business views to include paid commission data for both Accrued & Actual Pay transactions. Created & tested table preload & load jobs via INFORMATICA.
- Reviewed primary program (80 % of business ran through this program), uncovering/correcting major existing code/system flaws. This corrective action saved the company approximately 10% in processing time & required corrective man hours.
Environment: COBOL 370/DB2/IMS/INFORMATICA/Teradata SQL Assistant 6.2.
Click for project history.
Blue Cross Blue Shield of SC, I20 Alpine Rd, Columbia SC 29219, 20*
Maintained Legacy Commercial Billing batch/on-line systems that issue user transactions/statements and updates IMS/DB2 Data Bases. Created ADHOC queries &programs to meet user &governmentrequirements. Package Management via ENDEVOR. Training with APS, MicroFocus-MFEEE.
Duke Power, 400 South Tryon, Charlotte, NC 28202 19*
Provided support for the CIBA system, this included enhancements and maintenance on the main frame (CICS & Batch), client server (j2ee/Websphere 5.0) and Java applications. Created SQL queries for embedded selects, stored procedures, QMF reports and ad-hoc table data requests. Server projects ranged from Java code placed directly in JSP pages to MVC architecture which used servlets to extract and forward data to JSP pages. Program editors used Webshere 5.0 & TSO/ISPF.- Modified Customer Billing System using AFP resources (Page & Form Defs) and CTX hex ‘5a’ records (generated by VS COBOL 380). Project enhanced statement readability and provided client with the ability to target a specific audience. Project completed under budget and ahead of schedule. - Designed and developed Java/J2EE based web application for various company reports, using both DB2 data repositories and XML input, (CSS employed to enhance report appearance). - Designed and developed a Java/J2EE based web application that enabled meter personnel to extract meter readings from DB2 tables.Package Management via ChangeMan & Visual Source Safe. Environment: COBOL 370/DB2./Java 2/J2EE 1.4/JSP/Servlets/CSS/HTML.
Click for project history.
1st Contract Extension Click for project history.
2nd Contract Extenion Click for project history.
Emerio, Charlotte NC, 18*
Participated under a work training program in the Building of a Database-Driven Web Site Using PHP and MySQL.
- Involved in design and development of Java/J2EE based online system for company reports.
PHP/JavaScript/MySQL.
Lowe's, 401 Elkin Highway, N. Wilksboro NC 28659, MVS Project 17*
Modified existing financial system to transfer credit card data processing to 3rd party. Created required programs to interface with vendor systems using COBOL II & EasyTrieve. Environment: COBOL II/EasyTrieve/VSAM/DB2/CICS.
Wachovia,Technology Dr, Charlotte NC 28262, MVS/CICS/DB2 Project 16*
Converting on-line Telephone Billing System from OS2 to MVS. Package Management via ChangeMan. Environment: COBOL II/VSAM/CICS/MVS.
Click for project history.
PaineWebber, 300 Lighting way Secaucus NJ 07794, MVS/DB2/AFP Project 15*
Modified check & statement printing system to generate output via CTX hex ‘5a’ records,(generated via VS COBOL II ) electronic overlays (OGL), Form/Page Defs (PPFA used to create page resources) and PIE/Bar Charts (Graphical Data Display Manager (GDDM) used to create graphic charts). Project resulted in cost savings & improved statement readability. Addition of pie/bar charts gave customers a visual view of monthly statements. Package Management via ChangeMan. Provided modifications to existing Java programs to facilitate AFP production modifications. Environment: COBOL II/DB2/CICS/VSAM/GDDM/PPFA.
Duke Energy, 400 South Tryon, Charlotte, NC 28202, MVS/DB2/Client Server Project 14*
Conversion PeopleSoft systems from version 7.5 to 8.3, moving PeopleSoft application to the WEB. Package Management via ChangeMan. Environment: COBOL 370/DB2./PeopleSoft.
Blue Cross Blue Shield of SC, I20 Alpine Rd Columbia SC 29219, 13*
Maintained Legacy Billing/Enrollment batch/on-line systems that issue user transactions/statements and update IMS data base tables.
- Participated in a amulti team project to enhance statement readability and processing reliability via AFP and MQ Code modifications/additions. Project virtually eliminated statement processing errors, enhanced readability and was completed ahead of schedule.
Environment: COBOL 370/APS/DB2./IMS/MQ Series.
Silas Technologies-Wachovia Bank, Winston Salem NC, MVS/DB2/AFP Project 12*
Team Lead - Creation of on-line/batch system to Store, Retrieve and Print both imaged & non-imaged resources. Used MQ Series Messaging to tie the MVS platform to the imaged check statements. Created platforms GUI's via Java to extract data from MQ Series Queues to specified printers. Programs coded in Cobol II in a MVS batch/on-line environment. CTX/Hex ‘5A’ records employed. Package Management via Endeavor. Worked with VTAM protocols to establish networking via socket program. Environment: COBOL 370/VSAM/AFP/MQ Series/DB2.
Guardian Life, Bethlehem Pa, MVS/VSAM/Client Server/AFP Project 11*
Team Lead - Project that transformed legacy paper documents (Annual/Quarterly Statements) into electronic internet ready output. Batch code created dynamic AFP/line data, XENOS Package transformed AFP data stream to a PDF data stream. On Demand 390 used to store/archive capture reports, indexing accomplished via ACIF. Creation of charts (Pie/Bar/histograms) via GDDM software. Project enhanced statement appearance availability to client (electronic & print). Package Management via ChangeMan. Environment: COBOL 370, CICS/VSAM/AFP/DB2/OD 390 .
Click for project history.
First Union, 400 S Tryon St, Charlotte, NC 28202, 10*
Y2K Testing for CAP application, duties include running batch jobs and reviewing results. Additionally responsible for reviewing & upgrading CAP Disaster Recovery Program, DR exercise successfully conducted 11/1999. Environment: APS/MQSeries Messaging/DB2/IMS/CICS/VSAM.
Sea-Land Service Inc., Charlotte, North Carolina, 9*, **
Repaired DB2 tables using online/batch programs and DB2 utilities. Assisted with database design both logical & physical. Implemented code & table modifications(added table triggers & indexes) that decreased application down time by 10%, all projects completed under or on schedule. Package management via ChangeMan.
Environment: COBOL 370/CICS/VSAM/DB2/VB.
First Union, Charlotte, North Carolina, 8*, **
Online and batch coding enhancements to the DM Commercial System. Created transmission files that updated various Disbursement Systems and participated in the CORE State conversion project. Used BAI formatted records and APS, CASE Technology to implement system enhancements. Environment: APS/CICS/VSAM/DB2.
NationsBank, Charlotte, North Carolina, MVS/DB2/CICS Project 7*
Implemented successful software platform migrations from one software environment(Focus) to another software environment(DB2-COBOL 370) on the same machine (i.e. no hardware migration involved). Assisted with Help Desk functions. Optimized imbedded SQL's via Platinum Utilities. Package Management via ChangeMan. Environment: COBOL 370/VSAM/DB2/CICS.
Duke Power, 400 South Tryon, Charlotte, NC, 6*
Designed major system enhancements (online and batch) to Chemical Inventory Management System, resulting in increased marketability. Data was stored in VSAM/DB2 repositories. Used DB2 utilities to insure efficiency of imbedded selects and to load table data. Additions to VB applications, Web page creation via HTML. Package Management via ChangeMan. Environment: COBOL II/PL1/DB2/CICS/VSAM.
Virginia Power Nuclear Division, Richmond, Va, 5*
Implemented major system enhancements. Maintenance of online and batch for Passport & Indus Packages. Environment: COBOL II/CICS/DB2/VSAM.
Financial Data Planning (FDP), Wellesley, Massachusetts, MVS/DB2/CICS Project 4*
Developed and tested systems (On-line and Batch) for commissions and other insurance applications using DB2, COBOL VS II and CICS. Utilized program skeletons to build sub-systems. Environment: COBOL II/CICS/DB2/VSAM.
National Spinning Company, Washington, NC, MVS/COBOL/AFP Project3*
Coded using IDEAL - a shop floor automation project (Batch System). This Project controlled the movement of both finished products and component parts from point of order to point of delivery. Environment: IDEAL.
GTE Sprint, Dallas, Texas, 2*
Implemented an tested program in a DB2 environment for an invoicing project. Coded in Assembler and COBOL VS II. Developed AFP resources to control laser printer output. Environment: COBOL II/AFP.
National Computer Services (NCS), Iowa City, Iowa, 1*
Developed and tested a system (Batch); utilizing AFP resources, to produce standardized student testing reports for the State of Louisiana. Used COBOL and VSAM, Flat files used. Environment: COBOL/AFP.
June, 1987 - February, 1989, GTE Shareholder Services, Boston, Ma.. P/A
Developed, implemented and tested modifications to employee stock options/pension applications (batch/on-line, COBOL/IBM MVS environment) data extracted from IDMS (network database) & VSAM files. Changes included: Addition of AFP resources (i.e. PageDefs/FormDefs & Overlays) to existing batch print jobs, Creation of a File Transfer Subsystem: Implemented system that provided for file transfer between IBM mainframe and PC applications. Additionally responsible for IRS magnetic media reporting requirements. Required interpretation of IRS publications and coordination of IRS user efforts.
June 1986 - February 1987, Travelers Insurance Company, Hartford, Ct.. Programmer
Designed and implemented insurance applications using COBOL in an IBM 3090 MVS/XA environment. Applications made extensive use of DCF, GML, OGL and Script/VS, PMF.
Top of the Page
Chronological Employment History/Additional Data:
25* 09/23 - Current Date, Long term project to support legacy applications and future projected expansion of current system to a client/server-MVS environment (J2EE, .net or VB). Envionment: APS-MFEE/DB2/ENDEVOR/ISPF-Dialog Manager.
goverment
Preparing for next contract, 03/12 – 07/12
24* 10/11 - 3/12, Six month contract to create DB2 objects on demand i.e. SQL code for batch programs interactive queries. COBOL 370/DB2/Changeman.
finance
Physical Therapy, recovering from job(airport) injury. 08/11 – 09/11
23* 03/11 - 7/11, Four month contract to migrate the CX Credit Reporting application from Wachovia Silas Mainframe to the Wells Fargo Shoreview Mainframe Environment. Contract cut due to funding loss, last miniute reprieve extended till 7/07 - Completion of project. COBOL 370/DB2/Endevor.
finance
Travel, Study & Physical Therapy, job injury. Upgrading J2EE/DB2 skills & recovering from job injury. 03/10 – 02/11
22* 09/09 - 02/10, Six month contract, providing production support for the MED System. COBOL 370/IDMS.
Insurance
Preparing for next contract. 01/09 – 08/09
21* 07/08 - 01/09, As a contractor designed, coded and tested new Data Warehouse core tables & business views to include paid commission data for both Accrued & Actual Pay transactions. COBOL 370/DB2./IMS/Informatica.
Insurance/Data Warehousing
Preparing for next contract. 12/07 – 6/08
20* 06/07 - 11/07, Legacy Billing/Enrollment Systems.
Insurance/Billing & Enrollments
19* 05/04 - 05/07, CIBA System Maintenance. Software involved batch COBOL/DB2/Java 2 (J2EE 1.4 platform). & Websphere.
Specific Tasks:
- Redesigned customer billing statement, enhancing statement readability and adding the ability to target a specific audience. - Designed and developed a Java/J2EE based web application that enabled meter personel to extract meter readings from DB2 tables.
- Designed and developed Java/J2EE based web application for various company reports.
- Designed and developed a Java/J2EE based web application that enabled meter personnel to extract meter readings from DB2 tables.
Utilities
18* 02/04 - 04/04, Assisting a Database-Driven Web Site Using PHP and MySQL
Software development.
17* 09/03 - 02/04, Modified existing financial system to transfer credit card data processing to 3rd party.
Retail
Preparing for next contract. 063/03 – 08/08
16* 02/03 - 05/03, On-Line Telephone Billing System, conversion from OS2 to MVS.
Finance Systems
Preparing for next contract. 01/03 – 01/08
15* 08/02 - 12/02, Legacy Check/Confirmation Printing System. Short term project, Modified existing program; landscape to portrait and use of CTX records vice Preprinted forms.
Finance Systems
14* 04/02 - 08/02, Legacy HR Systems. Project involved batch COBOL/DB2/SQR Code modification.
Utilities/HR Systems
13* 10/01 - 04/02, Legacy Billing/Enrollment Systems.
Insurance/Billing & Enrollments
12* 09/00 - 03/01, Creation of Check statement (imaged & non-imaged)system with the following functionality storage,retrieval and printing. Statements extracted from AFP/MVS files, converted to PDF data (via XENOS software) and placed on LAN queue via MQSeries application. Data subsequently retrieved by GUI inter face for print and display.
Banking/Software
11* 03/00 - 09/00, Transformed legacy paper documents (Annual/Quarterly Statements) into electronic internet ready output. Batch code created dynamic AFP/line data, XENOS package transformed AFP data stream to PDF data stream. Added HTML links to PDF data stream dependent on key "littorals".
Insurance/Statements
Preparing for next contract. 02/00 – 02/00
10* 07/99 - 01/00, Primary duties consisted of testing/repairing compatibility of banking financial job stream with the year 2000 date change. Tested DB2 online/batch systems.
Finance/Capital Markets Group
9* 04/98 - 06/99, ** Loaded DB2 tables with both Batch Programs and utility programs (i.e.; Sync-sort, Passport, QMF, and DB2 Utilities). Analyzed imbedded DB2 statements in existing Cobol programs for DB2 efficiency via Explain & Passport Utilities. Analyzed existing screens/programs, ensuring they met minimum standards (i.e. standardized scrn headings, DB2 error trapping). Analyzed DB2 tables relationships, using in-house software to document table relationships. Upgrades modifications to existing Client server applications
Transportation
8* 04/98 - 11/98, ** Designed/Implemented code enhancements for on-line & batch systems, utilized APS code generators. IMS training provided.
Finance
7* 10/97 - 03/98, Optimized imbedded SQL statements using Passport. Tables were newly created DB2 tables (data extracted from existing Focus tables), maximum response time of 20 seconds, achieved via indexes, monitoring imbedded DB2 statements and minimizing data extraction times. Developed/implemented skeleton programs for on-line screens (used by internal staff/including help and bomb screens). Additionally implemented standardized screen headings.
Finance
6* 03/92 - 10/97, Optimized imbedded SQL’s via Explain statements, loaded various DB2 tables via Cobol programs and DB2 utilities (mass inserts using existing DB2 tables as well as flat files created in job stream. Responsible for implementing, testing and scheduling job streams (utilities) to load DB2 tables, i.e. image copies to restores). Additionally insured imbedded selects had maximum response times of less than 30 seconds. Worked with both dynamic and static imbedded SQL's. Extensive use of ADW code generators. Upgrades to client server applications, creation of Web pages via HTML.
Utilities
5* 08/91 - 02/92, created enhancements for on-line/batch DB2 systems. Loaded DB2 tables via Cobol programs and system utilities (tested & implemented JCL, i.e. image copies, repros etc). Implemented 3rd party source code(i.e. PASSPORT & Indus) in addition to own code.
Utilities
4* 10/90 - 07/91, created enhancements for on-line /batch DB2 systems. Worked with skeleton on-line programs & screens.
Insurance/Policy Underwriting
3* 07/90 - 09/90, No DB2.
Manufacturing
2* 11/89 - 06/90, Extensive AFP using PMF.
Telecommunications
1* 03/89 - 10/89, Extensive AFP using PPFA.
Government
** Contracts ran concurrently.
Send email to huenger.david@aol.com
Top of the Page / Experience / Education
Non Word Printer-Friendly Format
Resume PDF