SUMMARY

• Demonstrated leadership in a wide variety of projects, and substantial experience in software architecture / data design, development and testing at all stages, and SQL Development. He has worked in over a dozen different government environments over the years, as well as a number of companies, with a proven track record of success.
• Oracle, Natural, technical communication and others, and has taken Java / MySQL classes, as well, to continue expanding skill set.Learned to develop software with the Pascal language; Skills have always been structured, object oriented, and with solid SDLC.

TECHNICAL SKILLS

SDLC Methodology: Natural Adabas C, Java, JavaScript, PHP Oracle COBOL, 370 Assembler Pascal DB2

Web applications: HTML XML, Python

Operating System: Windows, MSDOS HP - UX Unix, AIX Linux Warp DOS/360 VSE MVS, CICS AS400 iSeries OO

Design / /Development: Clarion Visual BASIC Delphi Security software

Hippa Req., NCIC: Project Management Microsoft SQL Server Visual Basic Script SAS, SQL State Health, Pharma

PROFESSIONAL EXPERIENCE

Confidential, Sacramento CA

Lead Developer/Data Management Services

Responsibilities:

• Pivotal to conversion and stewardship of the critical data, in the conversion to a new system. This included determining what software to use, conversion, interfacing, and testing role work, with some development. This work involved data analysis, insuring all data is defined, and converted correctly as needed.
• The legacy systems are made up of Natural/ Adabas, IS400 RPG, JCL, and utilities. DB/2, Java, and SAS software are being used on the new environment. They were being converted to AWS environment for intermediate testing, then later for production. Testing software, CONNX (ETL), SDLC software, Microsoft Office, Visio, QA Software, DB/2 and more.Assuring the data of the system are preserved and understood, while interfacing conversion to the new systems.

Confidential, Carson City NV

Mainframe Developer/Programmer

Responsibilities:

• Involved in the Conversion to new system, including oversight and testing role work, with some development as well. This work is split pretty evenly between data conversion and extraction; and extracting, creating business and flow rules and diagrams for the new systems, while analyzing the legacy software.
• The legacy systems are made up of Natural/ Adabas, COBOL, JCL, DB/2, Java, and SAS software. They are being converted to Linux, Interfaces, Java, JavaScript, Angular, Jenkins / Selenium, Visual Studio and Dot .Net, Helix Core/ Helix ALM, MCI, BPM, with Testing software, SDLC software, Microsoft Office, Visio, QA Software, DB/2 and more. Mr. Cline has a pivotal role in assuring the critical elements of the system are preserved, while enabling progression to the newer technologies available today.

Confidential, Sacramento CA

Mainframe Developer/Programmer/Analyst/Support

Responsibilities:

• Providing transitional support as new software is installed, and updating old software to handle new cannabis tax rules. He has developed a number of ETL processes (data conversion), and executed them to keep the new software project on track for State mandated changes.
• Improved and standardized the processes for testing if the new software can handle the business rules that have been newly developed as well as the Mainframe operations that have gone on for decades. Dave repaired longstanding bugs and issues with new, and legacy mainframe software.
• Since worked with this (CDTFA) office before, he was able to answer many open questions and solve issues as SME.
• The allocated hours). He improved the departments’ testing protocol, and repaired some longstanding problems, for which they had no trained personnel. Creating some long-needed enhancements to the accounting GL, AR, Billing system (Java / INFORMIX / Natural / Adabas), and as resident SME for all things Natural / Adabas
• Dave was the ‘go to’ person for interfacing to the newest software developments. Maintained software to gather background checks on Health Workers, connected to CGIS, getting NCIC reports and state Justice Department records, as well as county court records.
• State Healthcare and Pharma (Medi-CAL) Mainframe, z/OS, Natural / Adabas, TSO/ISPF, PAC, Rexx, CLIST JCL, Green screen and SPOD, Natural/ONE, Construct (similar to APS), CICS, Testing (Unit, User/ usability, regression), Web Services, UNIX, Windows 7, Microsoft Office (Word, Excel, Access, Visio). ( Waterfall methodology). NIEM, NCIC, Hippa rules, JSON, INFORMIX, N2o, Entire-X, Com-plete, COBOL, CICS. Some Agile / Scrum methodology.

Confidential, Dallas TX

Mainframe Developer/Support Programmer/Analyst

Responsibilities:

• SW in a limited term, to transition from one support team to another team situated in Mexico). Confidential uses a large complex Natural Adabas system, interconnected to a number of other technology tools and systems, to keep track of the (approx.) 1,000 planes they fly daily. Every part, tool, procedure, schedule, and manual is kept and tracked in this system, part of the Engineering and Maintenance Division.
• Involved ‘small’ enhancement projects, and support activities as needed. He created documentation where it is missing, development, testing, some regression testing, interface analysis, knowledge transfer, and liaison activities in a SDLC / (modified) Scrum / Agile environment. Limited DBA work in Adabas.

Environment: Windows 7, MiniSoft mainframe access, VM (for Tele-Working), Jira, C, Java, JavaScript, JSON, Apache Spark 1.5.2, SQL, Natural / Adabas, z/OS, TSO/ISPF, N2o, Entire-X, SAS, Rexx, JCL, CICS, Web Services, Microsoft Office (Word, Excel, Access, Visio). Scrum / Agile methodology used throughout Departments.

Confidential, Los Angeles CA

Development Programmer/Analyst

Responsibilities:

• Software, creating and marketing Tax processing software, billing, marketing, notices subsystems. Some of the software is COBOL and Natural Adabas, other parts are Java and Web designs, in HP Unix and Windows environments. Dave was working on key enhancements to these, interfacing between the disparate systems, and creating new software updating as Tax laws changed and marketing advanced. The COBOL they were using was no longer supported, so he helped re-host a large subsystem onto a Micro Focus COBOL client server environment.
• The lead in setting new quality control standards, SDLC Practices, testing procedures and processes that keep these subsystems from having duplicate efforts and conflicts in data integrity/ versions of modules.

Environment: Windows 7, HP Unix,, Unix Scripting, Java, JavaScript, Python, JSON, AJAX, SQL scripts, commands and extracts, Natural / Adabas, NIEM, Micro Focus COBOL, Testing (Unit, User/ usability, regression), Microsoft Office (Word, Excel, Access).

Confidential, Santa Barbara CA

Mainframe Development/Programmer/Analyst

Responsibilities:

• Virtually everyone who used to work on the Mainframe software either retired or has moved on to projects involving new technologies. Highly critical maintenance and enhancements have been placed 'on the back burner' for years. Leading a small team, Architect of some of these software updates, analyzing user requests for important needs, and creating documentation where it is lacking or missing.
• Architect-ed channels for data to move from the legacy system to warehouse data stores, and bi-direction flow interacting with the new accounting systems as they developed and came online. Working with a remote development team, he made the data ‘fit’ the forms needed by the new systems, and helped load it to those new software packages (ETL / data conversion). New software gradually replaced the Mainframe, but required data mapping and interfaces back to the existing subsystems.
• Created a ‘Call Center’ system similar to ones he has created before, to track problems and store related solutions, simplifying maintenance. Just as the new system, in Java / Oracle based software, so the existing system needed to be maintained, brought up to date, and be robust in function and interface capability as new systems get developed by various departments around the campus. As tech support was often lacking, performed DBA activities such as Trim Natural Monitor, creating / altering tables with SYSDDM, optimizing access, PREDICT,creating backups, Installing SAG and Treehouse components, direct data extraction / duplication, as well as some RACF functions when needed. Provided documentation and data mapping for each subsystem involved with, while performing maintenance and upgrades, Unit / regression / system and user acceptance testing.
• SDLC Methodology, ISO 9001:2008 practices followed, Windows 7, Linux, Rumba terminal emulator and Citrix Access Gateway

Environment: Oracle 11g, Oracle ADF, C, C++, Java, JavaScript, J2EE, Python, SQL, Hippa rules, Natural / Adabas, Install SAG components, z/OS, TSO/ISPF, COMPLETE, N2o, Predict, Construct (simlar to APS), Chart, JCL, Rexx, CICS,, COBOL / 390, DB2, Web Services, NIEM, Assembler (HLASM), SAS reports and file translations, Microsoft Office (Word, Excel, Access, Visio). Agile methodology used on some projects.

Confidential, Austin TX

Documentation/Support Programmer/Analyst

Responsibilities:

• This position was cut short due to an illness in family). This project was to understand and document major segments of the Workforce Commission software, mapping and exposing data, interfaces and programs in an environment where several people had retired, and others are near retirement.
• Created an innovative style of 'web-like' documentation, and easy procedures for users to add their own documentation without disrupting the structure of and access to the information needed to operate and enhance / maintain the existing Mainframe subsystems. This style and procedures are still in use today, being expanded upon by the state personnel.

Environment: Windows XP, Linux, Java, SQL, Natural / Adabas, z/OS, TSO/ISPF, JCL, CICS, Microsoft Office (Word, Excel, Access, Visio).

Confidential, Ft. Meade MD

New Development Programmer/Analyst

Responsibilities:

• With a Top-Secret clearance, he performed in a critical role, a major Reverse Engineering / rewrite to Java / SQL from a Mainframe Natural Adabas subsystem at a pivotal government agency. Dave architected data flow pathways enhancements to and from Mainframe software for warehousing and setting up new software.
• Creating and updating 'generic' documentation from existing code, then leading and working with the offshore Java team as they created the new software which now maps to and accesses the Adabas files directly, then will be modified to access the converted data in SQL. ETL processes were created to help migrate the important data in a form usable by the new systems. Existing software was scattered across about 5000 modules, and very large, mission critical, high security database.
• Maintenance and upgrades, unit and regression testing to each module he documented and touched in this process. SDLC methodology used, and following ISO 9001:2000 practices, in all processes and documentation,

Environment: Windows (7 and XP), Linux, Oracle 11g, Java, Python, SQL, Natural / Adabas, Endevor, z/OS, SAS data extracts and reports, Hippa rules, NCIC connections, TSO/ISPF, JCL, Rexx, CICS, Testing (Unit, User/ usability, regression), Microsoft Office (Word, Excel, Access), Top Secret Clearance.

Confidential

New Development Programmer / Analyst

Responsibilities:

• Dave developed an interface subsystem for Broward College, Ft. Lauderdale FL, connecting and mapping their Unix (Natural / Adabas) Accounts Payables and Student ID systems to the Oracle system used by the College Association. Dave helped Hachette Book Group Boston MA, moving Natural Adabas data off the mainframe (data conversion), interfaced and mapped to a LINUX Oracle based system.
• He has also been involved with several contracts and sub-contracts, helping COBOL, Natural / Adabas developers in state organizations, upgrades to Welfare / Medicaid and Child Support subsystems, in Louisiana and Arizona developing and implementing new systems, including COBOL, Java, JavaScript, PHP, Web development.

Environment: Windows (7 and XP), Linux, J2EE, SQL, Natural / Adabas, SAS utilities, Natural 6.2 for Windows, SPOD, OPX, Microsoft Office (Word, Excel, Access), ULEAD video production software.

Confidential, Reno NV

New Development Programmer/Analyst

Responsibilities:

• The accounting system to new GL software and structure, upgrading and creating Accounts Payable / Receivable, Payroll, HR software, new reports. he also provided software support for existing legacy software in production environment, while creating next year's software in a completely new system. Extensive system and regression testing for all new work and revisions.

Environment: Linux, i5-570, and HP-UX Unix, Unix scripting, Java, C#, SQL extracts/table maintenance, JavaScript, PHP, Perl, XML, Micro Focus COBOL, INFORMIX database, 4GL, UniBasic, Visual Basic Script, VB .Net, Business Rules software, Work Flow Software, Report software, Clarion v6.3 Developer, Bi-Tech (SunGuard) accounting software, WinXP, Microsoft Office (Word, Excel, Power Point, Access).

Confidential, Baton Rouge LA

New Development Programmer/Analyst

Responsibilities:

• On a small local / remote team, Dave helped architect, and created a seamless, web oriented interface with SOA technology combined with the legacy mainframe database and existing software. Using a JAVA front-end, he used Neon Shadow to interface and map the Databases in the Natural Adabas environment for Ad Hoc inquiries and supplementation software ‘add-ons’ (ETL / data conversion processes).
• Architected /developed several enhancements to the Welfare / Medicaid / Food Stamp system /, and Child Support system, that became necessary due to federal regulation changes. He created a ‘hot fix’ call center tracking program / database. Using SDLC Methodology, and ISO 9001:2000 practices, and involved with eliciting / documenting requirements, user acceptance testing, HTML, Java, SQL Server 2005
• Natural, various documentation, etc. State and Federal Medical and Pharma records. Using Hippa rules, Natural / Adabas, N2O, Neon Shadow, legacy SAS maintenance/reporting, Java, Linux, Eclipse, PHP, XML, PREDICT, Construct (similar to APS), Object Oriented Development, z/OS, TSO/ISPF, JCL, Rexx, CICS, Testing (Unit, User/ usability, regression), Dyl280, Rumba terminal emulator,

Environment: Win XP, Microsoft Office (Word, Excel, PowerPoint).

Confidential, Reno NV

New Development Maintenance Webmaster/Designer

Responsibilities:

• (Short term support contract). This is a small shop operation in Reno, supporting web sites such as passyourdrugtest.com. Working from a pc/ web server system, Dave used Photoshop, FrontPage, editors and utilities to add graphics, design layouts, maintain shopping cart technology, support users, photograph and develop photo layouts for new products for the web sites

Environment: JavaScript, Java, PHP, Perl, HTML, XML, Linux / HP-UX to keep the thriving little business going and secure.

Confidential, Boise ID

New Development Programmer/Analyst

Responsibilities:

• Enhancements project to replace the Welfare / Medicaid / Food Stamp software that was in use; ETL / data conversion - Mapping and interfacing the Mainframe Databases to the new Web oriented systems being developed. He also maintained the existing Welfare and Child Support systems. This was a fast-paced, SCRUM based project, using SDLC practices, and AGILE methods and many of the latest ideas in processes and software tools. State and Federal Medical and Pharma processing. On a scrum team,

Environment: COBOL Java, Natural, user acceptance testing, HTML, Linux, various documentation, etc. Using Hippa rules, Natural (4.1.3)/ Adabas (7.4.3), N2O, Neon Shadow, Java, J2EE, PHP, Eclipse, PREDICT, Construct (Similar to APS), Object Oriented Development, z/OS, TSO/ISPF, JCL, Rexx, CICS, XML, Win XP, Microsoft Office (Word, Excel, PowerPoint).

Confidential, Phoenix AZ

New Development Programmer/Analyst

Responsibilities:

• (Short term, small project). Eliciting / documenting requirements, creating e-Employer (Web interface for Mainframe computer) system enhancements for child support withholding order processing.

Environment: Natural (3.1.04)/ Adabas, Java, Natural Broker, PREDICT, z/OS, TSO/ISPF, JCL, CICS, Win XP, Microsoft Office (Word, Excel).

Confidential, Providence RI

Development/Support Programmer/Analyst

Responsibilities:

• Building upon the Welfare / Medicaid / Food Stamp / Child Care / Child Support subsystems, eliciting & documenting requirements, fielding support calls, enhancing and maintaining the system as changes in procedure, policies, HIPAA requirements, and legal mandates are imposed. State and Federal Medical and Pharma processing, Hippa rules.

Environment: Natural (3.1.04 and 2.2.08)/ Adabas, Endevor, Oracle Forms 6i, Oracle Reports 6i, Oracle 9i, PREDICT, PAC, MVS, TSO/ISPF, JCL, CICS, Micro Focus COBOL, DB2, OS/390, Win 98, Win2000, Microsoft Office (Word, Excel), Netscape. (ISO 9000).

Confidential, South Lake Tahoe NV

DBA/Support /Data Control Analysis

Responsibilities:

• Improving system for credit checks, marker handling, data input / verification. Dave restructured the Oracle database for customers for efficiency and maintenance improvements, and set up a Data Warehouse. Helped coordinate bringing new software online for the casino floor, debugged code, and trained

Environment: Oracle based, client / server software, Win2000, Clarion 6 PC Apps, Delphi Apps, Object Oriented Development, RPG II, DB2 (UDB), AIX, IBM AS400 (iSeries model 840)mainframe.