CAREER SUMMARY

Thirty years experience in the IT industry as a programmer, database administrator, and systems analyst. Extensive government experience working at the Confidential Departments of Human Services and Michigan State. My greatest non-technical skill is remaining calm in a crisis.

EXPERIENCE

Confidential

Systems Analyst

• Senior Database Administrator responsible for Database Management System DMS and Relational Database Management System RDMS design and maintenance, programmer assistance, troubleshooting, and problem resolution.
• Reorganize hierarchical and relational databases.
• Monitor and maintain the DMS schemas: DDL, SDDL, expands DMU, DRU , reorganizations COBOL, DRU, IQU to prevent problems and ensure timely response to programmer needs.
• Maintain RDMS databases, ensuring space needs are addressed in a timely manner.
• Troubleshoot programmer problems. Explain, assist with, and perform technical fixes for problems. My TIERS and SAVERR system knowledge of has been a great advantage during the customer's transition from the mainframe to the server system. Streamlined the Audit Trail Security Reporting System used to track and report non-standard database updates. Also train junior DBAs.
• Completely redesigned and automated backups of the Generic Worksheet intake documents database of over 400 DMS areas. Data storage revolves through the database areas several times a week, which are eventually written to tape. My process determines which areas are currently being used and dumps just those areas. I had to incorporate this process into the redesign of the entire database dump process.
• Key participant in the redesign the database dumps over 100 to standardize and consolidate scattered ECL with a myriad of application dependencies. This project ended the legacy 'figure out the dumps' situation that existed.

Confidential

Consultant Systems Analyst

• Senior programmer with the TIERS system responsible for data conversion from the legacy SAVERR mainframe system to the TIERS server system. Responsible for maintaining all programs.
• Created specifications for legacy programs to enable their functionality to be reproduced in the new TIERS system
• Designed, programmed, implemented, and monitored the Master Client Index system using RDMS, COBOL and MQ to maintain a common client index for the legacy SAVERR system and the TIERS system.
• Involved in initial implementation of Oracle/Unix systems with HHSC.

Confidential

Consultant Database Administrator

• Responsible for the maintenance of the DMS/RDMS databases. Including reorganization of the databases and support for the programming staff.
• Trained staff in the use of IQU.

Confidential

Consultant Database Administrator

• Designed and implemented strategies to convert legacy DMS databases to use millennium compliant dates.
• Coded and ran database reorganizations using IQU and COBOL.
• Assisted with development of data standards.
• Trained staff in the use of IQU and COBOL.

Confidential

Consultant Database Administrator

• Worked on the Michigan ASSIST Project, responsible for designing and coding APS/COBOL interface programs to accept data from State Medicaid legacy system and load it into a new DMS database structure.
• Provided Unisys 2200 and IQU support to staff

Confidential

Consultant Database Administrator

Provided DMS database support, including the creation of IQU scripts for loading data, for a project to convert an existing legacy system to a new DMS database system.

Confidential

Consultant Database Administrator/Programmer

• Provided database support for RDMS, DMS, and LINC. Supported programming staff in use of RDMS in ACOB and UCOB programs.
• Advised others on design and implementation of new RDMS databases.
• Maintained existing and designed new batch and online programs.
• Wrote IPF procedures and SSG skeletons to generate ECL for database maintenance.
• Designed and implemented automated transfer process to move database file across machines.

Confidential

Consultant Database Administrator/Programmer

• Hired to undertake a range of computer activities, including providing high-level IT advice, guidance, analysis, and programming tasks.
• Designed and programmed an automatic archive/retrieval process for a LINC system using SSG, IRU, UREP and IPF procedures. The process generated RDMS database structures for storage and retrieval of purged data.
• Liaison between users and technical staff.
• Assisted A-Series LINC programmers learn 2200 concepts and syntax.
• Performed varied analysis and programming tasks.

Confidential

Consultant Programmer/Database Administrator

• Oversaw the design, maintenance, and integrity of DMS and RDMS/MAPPER database systems, providing support and guidance to programming staff.
• Generated LINC systems on an A-Series machine and implemented them on 1100/1200 machines, including LINC coordination. Also arranged conversion of the 1100/2200 LINC systems from version 14R1 to 14R4A.
• Designed and programmed a system to monitor growth and usage of RDMS database files using DBE and MAPPER
• Designed and programmed a monitoring system for COBOL programs interfacing with DDS/UREP.
• Developed report programs with IQU.
• Responsible for database dumps and reloads.
• Developed DBE macros to analyze RDMS table structure and contents.
• Served as part time MAPPER Coordinator.
• Developed software using MAPPER/MRI interface software
• Oversaw development and implementation of National Lifetime Driver Licensing and National Fines Accounting and Enforcement systems.
• Supervised and provided technical support to ten programmers in the design and development of 72 online and 100 batch programs. Monitored the writing of new programs for quality and standards.
• Created and presented training programs on DPS software and associated programming standards. Developed and set programming standards for implementation of DPS screen handling software.
• Designed and implemented automatic interface between the Court Case Monitoring system and the Custodial system.
• Designed and implemented modifications to online Network Travel Reporting and Network Information System.
• Oversaw central software routines, copy text, and other common banked routines.
• Maintained and supported batch and online COBOL programs