Dean Hatch Email & Phone Number

Bethesda, Md, Us

Washington, Dc, Us

Support the Economic Programs Directorate (ECON) of the Census Bureau, including:• Laying the groundwork for the ECON Directorate advancement to SAS Viya• Utilizing SAS Viya API to integrate existing assets with new applications• Providing Linux SAS Intelligence Platform administration and application support• Guided migration of several applications from SAS 9.2 to SAS 9.4• Ensuring continuous operation of applications during Red Hat Enterprise Linux (RHEL) upgrades• Automated configuration monitoring and administration across numerous systems and environments• Troubleshooting system, software, configuration, and infrastructure issues• Provided continuity during various restructurings• Representing application interests and tech support interests throughout security and architecture planning activities• Provide ongoing SAS expertise to the ECON Architecture Review Board (eARB)

Washington, Dc, Us

• Designed and developed an application system for generating the Federal Reserve’s weekly H.4.1 Statistical Release in SAS/AF 6.12 on Windows NT. Subsequently ported the system to Linux, replacing significant SAS functionality with Linux C-shell scripts, and made other major enhancements.OS/Languages/Software: Windows NT, Linux, SAS V6 & V8 (Base, Macro, AF)• Identified accessory H.4.1 system requirement and developed the process, executed in Ruby, XML, and PostScript, to maintain release templates. Templates and data values were merged to produce final weekly H.4.1 Statistical Release with identical content in various formats, including Section 508 compliant HTML and a PostScript version which was then converted to PDF. Old labor intensive process was prone to discrepancies between the formats. Later expanded new process to produce related releases. OS/Languages/Software: Linux, Ruby, XML, PostScript, HTML• Reverse engineered and rewrote a C++ monetary projection system in support of the Federal Reserve’s Open Market Operations. Pair-programmed the rewrite in Smalltalk and R on Linux with PostgreSQL.OS/Languages/Software: Linux, Smalltalk, R, C++• Designed DB2 tables for the Board’s Financial Data Repository rewrite, which replaced the existing tape-based retrieval with DB2-based data storage and access. Designed and wrote the SAS PROC for retrieving data in a meaningful manner. PROC was written in SAS/C and also made extensive use of SAS Data Step Views and SQL queries. Upgraded/validated PROC through SAS Version 9.3. OS/Languages/Software: z/OS, SAS V6, V8 & V9 (Base, Macro, Toolkit), SAS/C, DB2• Maintained Financial Data Repository Data Load (ETL) software, a mainframe-based (z/OS) system in SAS, XML, DB2, SQL, JCL, and ISPF with source controlled by ENDEVOR ENDEVOR. OS/Languages/Software: z/OS, SAS V9 (Base, Macro, Access), DB2, ENDEVOR

Washington, Dc, Us

• Designed and developed SAS/AF and Excel system for reporting regional banking data. System provided Excel formatting, graphing, and reporting of mainframe database data on a quarterly production basis. See https://www2.fdic.gov/qbp/index.asp for examples of how the results were used.• Provided analysis and design of prototype interdivisional Data Mart logical and physical data

Princeton, Nj, Us

Provided NDA submission support, including data listing and statistical report table programming, data validation, summarization and graphics, as well as utility Macro and program library contributions.

Projects included:• Implemented SAS/AF-based Statistical Process Control system which utilized shared "real time" data in a networked UNIX environment. (StorageTek)• Provided consumer marketing research SAS and PL/1 programming support in a VM/CMS and Windows environment. (National Demographics & Lifestyles)• Provided SAS/GRAPH programs for storage device subsystem performance display to large manufacturer of computer peripheral devices. (StorageTek)• Tested and analyzed performance of IBM’s Advanced Function Printing software in networked OS/2 environment. (IBM)• Installed, maintained and supported SAS and other software products in a VM/SP HPO 5 environment. (IBM)

Chicago, Illinois, Us

Designed, implemented, tested, revised application systems in NOMAD2 under VM/CMS. Responsibilities included all aspects of project development including design specifications, security planning, user interfaces, database design, and system and user documentation.

Abbott Park, Illinois, Us

Responsible for installation, maintenance and support of operating system and other vendor-supplied software (e.g. SAS, NOMAD2, VMSECURE) on a VM/SP HPO system running on an IBM 3090-200. Managed system resources and provided technical support to individuals and groups. Provided support to operations staff and to security, chargeback and network administration groups. Participated in Disaster Recovery Project. Led effort to plan and implement conversion from VM/SP to VM/XA. Provided support for SAS and VM/CMS to departments throughout the company.

Abbott Park, Illinois, Us

Provided lead system and programming support to Clinical Trials Management System (CTMS) team in implementation of in house entry and data management system, written in NOMAD2 under VM/CMS. Designed, coded, tested, and documented several components of the system, including SAS interface PROC written in PL/1.

Abbott Park, Illinois, Us

Provided SAS clinical trial data programming support, including data listings, data validation programs, and ad-hoc requests from biostatisticians and regulatory affairs personnel. Provided support for SAS, JCL, and MVS to data processing and statistical departments.