Legacy Programmer Resume Profile
FloridA
Objective
Confidential is an Information Technology professional with twenty-three years of Confidential mainframe experience, mostly related to database development, implementation, and maintenance. Four years of design experience provided the foundation for fifteen years of hands-on database administration. As Database Administrator and Application Programmer, he has supported tax applications for the Florida Department of Revenue for nine years. His professional experience includes the following:
- HARDWARE:
- UNISYS 1100/2200 SERIES and CLEARPATH DORADO
- SOFTWARE/LANGUAGES/PACKAGES:
COBOL/CDML | FAS | QLP |
DBE | IPF | RDMUTL |
DDL/SDDL | IPF SQL | SSG |
DMU | I-QU PLUS-1 | SUDS |
ECL | IRU | UDSMON |
EDITOR | LOUIS II | UREP |
- DATABASES:
- DMS 1100/2200, RDMS 1100/2200, SFS 1100/2200
- OPERATING SYSTEMS:
- DMS-8, OS1100, OS2200
PROFESSIONAL EXPERIENCE:
Confidential
LEGACY PROGRAMMER
Responsible for maintaining the Intangibles Tax system and assisting in the maintenance of other tax systems on the Unisys mainframe. Perform schema changes, area expansions, and database reorganizations for all Unisys mainframe databases. Provide analysis of mainframe applications to support their migration to other platforms. Install and maintain Tumbleweed client software in support of IRS data transfers of federal tax information. Compress, encrypt, document, and distribute IRS data to authorized recipients. Develop Mobius applications, migrate mainframe historical data to them, and perform administrative functions.
Confidential
SYSTEM ADMINISTRATOR
Migrate Unisys mainframe systems to West Virginia. Document operational procedures. Troubleshoot system and application problems. Provide guidance to the database administrator. Assist the tape librarian with the use of STAR. Guide and support the operations staff.
Confidential
DATABASE ADMINISTRATION SPECIALIST
Responsible for database administration and client support on the Unisys Clearpath IX platform running OS2200. Maintain production databases comprised of Confidential. Recommend data structure modifications to accommodate functional system enhancements. Code schemas and subschemas according to supplied specifications. Code I-QU PLUS-1 reorganization programs and use related utilities to implement schema changes. Troubleshoot and correct database problems correct data when authorized. Write DBE macros to collect statistics for monitoring area sizing and page utilization. Identify problems in clients' ECL runstreams, LOUIS II runstreams, I-QU programs, and DML code, and recommend solutions. Save, reload, and recover databases using IRU. Verify and correct the structural integrity of databases using DBE and DMU. Utilities/Software/Languages used in the completion of assignments include: I-QU PLUS-1, QRYSCH, SCHUTL, PBLD, PFIX, DBE, DMU, CDML, COBOL, IPF SQL, DDL, SDDL, ECL, QLP, EDITOR, IRU, SSG, FAS, LOUIS II, UDSMON, IPF, RDMUTL, SUDS, UREP.
Confidential
DATABASE ANALYST
Support Integrated Accounts Payable and Integrated Paying and Collecting activities Air Force wide. Maintain 16 databases for software developers at the Standard Systems Center, and support up to 114 production databases worldwide. Improve database performance. Design and code schema/subschema modifications to implement new functional requirements. Code special purpose programs to correct database irregularities in the field. Provide technical assistance to programmers, functionals, field assistance specialists, and Base Level database administrators. Reorganize areas using I-QU PLUS-1 and its utilities. Find and repair pointer errors. Save, reload, and recover database areas.
Environment: UNISYS 1100/2200 DMS, RDMS, SFS, TIP, I-QU PLUS 1 and associated utilities, DDL/SDDL, COBOL/CDML, QLP, ECL, DBE, DMU, IRU, SSG, FAS, LA, IPF SQL, LOUIS II, EDITOR, CTS, IPF, UDSMON, SUDS, DD/UREP
Confidential
DATABASE ADMINISTRATOR
Team member working to design and install DMS 1100 databases for Air Force applications including Logistics/Mobility, Accounts Receivable, Payroll, Family Practice Clinic, and Aircraft Maintenance. Provide application developers with instruction and technical guidance in database design, implementation, recovery, and programming. Perform sizing computations. Resolve field problems involving operational Air Force databases and the data processing environment on Standard Base Level Computer systems around the world. Verify sets and fix broken pointers. Write database reorganization programs using COBOL and I-QU Plus-1 products. Supervise and train junior programmers.
Environment: UNISYS 1100/2200, AT T 3B2, SUN workstation DMS, RDMS, TIP, I-QU PLUS 1 and associated utilities, DDL/SDDL, COBOL/CDML, QLP, ECL, DBE, DMU, IRU, LA, IPF SQL, EDITOR, CTS, IPF, UDSMON, SUDS, Data Dictionary, CLIPS, UNIX, UNIFY, ENABLE, AFOLDS, CADKEY, Software Through Pictures.
Confidential
TECHNICIAN
Non-Destructive Inspection Confidential of aircraft structures and components using X-ray, ultrasonic, magnetic particle, dye penetrant, and eddy current testing, as well as spectroscopic oil analysis.