DAVID E. HUENGER P.O. Box 25585 Charlotte, NC 28229-5585 (704) 962-3229 EDUCATION: St. John Fisher College, Rochester, New York B.S. Biology, Chemistry Northeastern University, Boston, MA Certificate in Data Processing SUMMARY: 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. Design/develop J2EE web application that extracted data from DB2 tables displaying/ storing data via JSP/HTML/CSS /Excel DSN’s. SOFTWARE and LANGUAGES: Web: HTML, Java 2 on J2EE 1.4 platform and IBM WebSphere Application Server(WSAD), PHP, MySQL, JavaScript CSS, INFORMATICA(Data Integration) and Teradata. Mainframe: MVS/XA, 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. Other: VISIO, Word, IBM's AFP Workbench for Windows NT EMPLOYMENT EXPERIENCE: Feb, 1989 to Present – Independent Contract Programmer Bank of America Charlotte NC Finance. 10/11 – 03/12 13850 BALLANTYNE CORPORATE PL CHARLOTTE NC 28277. Created batch program & JCL for monthly/weekly Dash Board Reporting System. System extracts meassures 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. Program source/version controlling of components via Changeman Version 4.1.6. Enviroment: COBOL 370/DB2 Ver 9/Changeman. WellsFargo Charlotte NC Finance. 03/11 – 07/11 Six month contract production support for on line & batch production applications. Six month contract to migrate the CX Credit Reporting application from Wachovia Silas Mainframe to the Wells Fargo Shoreview Mainframe Environment. Environment: COBOL 370/DB2/Endevor. Recuperation & Study, Upgrading/training with J2EE & Java skills. 4/10 – 02/11 Occasional ad-hoc work involving PC support and Internet/World Wide Web interface. Clemson University Clemson SC, Insurance. 10/09 – 03/10 Six month contract production support for on line & batch production applications. Creation & maintenance of Stored Procedures. Modified existing data base tables via shop utilities i.e. passport. Participated in analysis of required conversion form MVS/ADSsystem to MVS/DB2/J2EE system conversion. Worked with associated DB2/SQL tools i.e.; QMF/SPUFI/BMC and Main Frame Express. Environment: COBOL 370/IDMS/DB2 Colonial Life Columbia SC, Insurance. 7/08 – Current 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/Teradata. Travel & Study, Upgrading J2EE/DB2 skills. 11/07 – 7/08 BlueCrossBlueShield, Columbia SC, Insurance. 06/07 – 11/07 Maintained Legacy Commercial Billing batch/on-line systems that issue user transactions/statements and updates IMS/DB2 Data Bases. Package Management via Endevor. Received training with APS(MFEE – Desktop Application) Environment :COBOL 370/APS(MFEE)/DB2./IMS/MQ Series. Duke Power, 400 South Tryon, Charlotte, NC, Utility. 5/04 – 05/07 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 enhansed 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 personel to extract meter readings from DB2 tables. - Package Management via via ChangeMan & Visual SourceSafe Environment :Java 2/J2EE 1.4/XML/SOAP/COBOL 370/CICS/DB2/VSAM Emerio Charlotte NC, Software Developement. 02/04 – 04/04 Particapated under a work training program in the Building of a Database-Driven Web Site Using PHP and MySQL. PHP/JavaScript/MySQL. Lowe’s Inc WIlksboro NC, Retail. 09/03 – 02/04 Modified existing financial system to transfer credit card data processing to 3rd party. Created required programs(COBOL II) to interface with vendor systems using COBOL II/EasyTrieve/VSAM/DB2/CICS. Wachovia, Charlotte NC, Finance. 02/03 - 05/03 Converting on-line Telephone Billing System from OS2 to MVS. Package Management via ChangeMan. Environment :COBOL II/VSAM/CICS/MVS.
PaineWebber, Wynsocket NJ, Finance. 08/02 - 12/02 Printing of checks/confirmations outsourced to ADP, modified system to write confirmations/checks via CTX '5A' records vice preprinted forms. CTX & hex '5A' experience with VS Cobol II/PPFA used to create page resources. Duke Energy, 400 South Tryon, Charlotte, NC, Utilities. 04/02 – 06/02 Legacy HR Systems. PeopleSoft conversion , converting from version 7.5 to version 8.3. Project involved batch COBOL/DB2/SQR Code modification & testing. Environment :COBOL 370/DB2./CICS/PeopleSoft. BlueCrossBlueShield, Columbia SC, Insurance. 09/01 – 04/02 Maintained Legacy Billing/Enrollment batch/on-line systems that issue user transactions/statements and updates IMS /DB2 Data Bases. Environment :COBOL 370/APS/DB2./IMS/MQ Series. Silas Technologies, Winston Salem NC, Finance. 9/00 – 3/01 Creation of on-line/batch system to Store, Retrieve and Print both imaged & non- imaged check statements. System creates AFP structured resources and uses MQSeries Messaging to tie the MVS platform to the Lotus and WEB platforms. Created GUI's via Java to extract data from MQSeries Queues to specified printers. Programs coded in Cobol II in a MVS batch/on-line environment. CTX & hex '5A' experience with VS Cobol II. (Command level CICS). COBOL 370/VSAM/AFP/MQ Series/DB2. Guardian, Bethlehem Pa, Insurance/Statements. 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 a PDF data stream. CTX & hex '5A' experience with VS Cobol 370. Environment :COBOL 370, CICS/VSAM/AFP/DB2 . First Union, Charlotte NC, Finance. 05/99 – 02/00 Y2K Testing for CAP application, duties include running batch jobs and reviewing results. Responsible for reviewing/upgrading CAP Disaster Recovery Program, successful DR exercise conducted 11/1999. Trained with MQSeries Messaging. Environment :APS/MQSeries Messaging/DB2/IMS/CICS/VSAM. Sea-Land Service, Inc., Charlotte NC, Transportation. 5/98 – 5/99 Repaired DB2 tables using online, batch programs and DB2 utilities. Used DB2 utilities for loading and maintenance of Sea-Land Corporate Tables and to assist with data integrity. Minor up-grades to VB applications. Environment :COBOL 370/CICS/VSAM/DB2/VB. First Union, Charlotte NC, Finance. 4/98 – 11/98 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. APS (COBOL Code Generator), IMS and DB2 tables employed. Environment :APS/CICS/VSAM/DB2. NationsBank, Charlotte NC, Finance. 10/97 – 4/98 Implemented successful software platform migrations from one Focus application 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. Environment :COBOL 370/VSAM/DB2/CICS. Duke Power, 400 South Tryon, Charlotte, NC, Utility. 2/92 – 10/97 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. Programs coded in COBOL II/COBOL 370/PL1 batch/on-line environment. Environment :COBOL II/PL1/DB2/CICS/VSAM. Va. Power Nuclear Division, Richmond VA, Utility. 8/91 – 2/92 Implemented major system enhancements to on-line/batch Information Systems. Supported implementation & maintenance of third party software Package (Passport Package). Ran/created DB2 Utilities for table table maintenance. IMS training provided. Environment :COBOL II/CICS/DB2/VSAM. Financial Data Planning (FDP), Wellesley Ma, Insurance. 10/90 – 8/91 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, Manufacturing. 8/90 – 10/90 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. IDEAL. GTE Sprint, Dallas TX, Telecommunications. 11/89 – 8/90 Implemented a 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. COBOL II/AFP. National Computer Services, Iowa City Ia, Government. 2/89 – 11/89 Developed and tested a system (Batch); utilizing AFP resources, to produce standardized student testing reports for the State of Louisiana. VSAM & sequential files/COBOL/AFP. June, 1986 - February, 1989 - Staff Positions GTE Shareholder Services, Boston Massachusetts 6/87 –2/89 Programmer/Analyst 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: • IBM Advanced Function Printing (PPFA): Addition of AFP resources (i.e. PageDefs/FormDefs & Overlays) to existing batch print jobs. • File Transfer Subsystem: Implemented system that provided for file transfer between IBM mainframe and PC applications. • Responsible for IRS magnetic media reporting requirements. Required interpretation of IRS publications and coordination of IRS user efforts. Travelers Insurance Company, Hartford Connecticut 6/86 –6/87 Programmer/Analyst 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 (AFP Software). Web Site: WWW.angelfire./scifi/huenger/resws.html/ Email : cobolproger@netcape.net Updated : 01/24/2007 Print this Resume