PROFESSIONAL EXPERIENCE

Confidential

Unisys Database Specialist

• I migrated 7 production databases along with about 15-20 databases from 54.1 to 55.1 DMSII
• Installed patches in an ALGOL program that reads the AUDIT and creates a report base on the Dataset items
• Wrote three COBOL programs to estimate how long it would take to delete of three million records.
• Wrote XGEN programs to verify that the databases created gave the same information as DM INQUIRY.
• I added addition code for an ALGOL online EDITOR program using DMSII Audit files.
• Responsible for DMSII related issues with respect to yearly MCP upgrades.
• I recovered and rebuild a database that got corrupted. This was done outside the normal std. recovery methods.
• I used DBATOOLS to create growth charts and Limit Error reports.
• Created a TEST database so that state could test procedure about elimination of dead records.
• Reduce the size of two databases for the customer so that reduction of pack space can occur.

Confidential

Senior Unisys Database Specialist

• Upgraded the disaster recovery procedures completed 1st successful disaster recovery and managed customer expectations regarding disaster procedures.
• Modified a third party SQL server database, DBATOOLS, to extract data for specific dates during this project found out that dates where not extracted the same in 2003 and 2008 SQL server.
• Created an SQL Procedure to determine what databases where not being backed up.
• Fixed over 14 jobs that were used to back up the databases both online and offline creating a more stable environment for client data.
• Performed various offline reorganizations of databases and added to new data items and structures.
• Used DBA Tools to monitor databases, which was used to detect LIMIT ERRORS.
• Assisted in the migration of Unisys Systems to an SQL platform learning the differences how SQL stores data compared to Unisys
• Converted Unisys COBOL to Micro Focus COBOL.
• Wrote ALGOL programs to assist in data migration and migration of database to the test machine.

Confidential

Senior Systems Programmer

• Partnered with management for upgrade of MISER Releases and all database changes for MISER upgrades.
• Created a WFL to do mass compile of all programs creating a great time savings.
• Created batch programs COBOL85 to meet management adjectives accessing the MISER database.
• Created Applications programs to convert various letter files eliminating a time consuming manual process.
• Converted a Micro Focus COBOL application to COBOL 85 on the Unisys platform by writing an ALGOL program to convert the file into a COBOL 85 format allowing the client to abandon an outdated server platform saving a considerable annual expenditure.
• Wrote COBOL85 batch programs for multiple financial regulatory requirements on CLEARPATH machine.
• Wrote COBOL85 online program for incident reporting using COMS.

Confidential

Unisys Database Architect

• Migrated database from older Unisys Disk pack to EMC 8730 disk units leading to cost savings and creating a more reliable disk storage environment.
• Performed analysis and made performance recommendations for the LX5220 NX6830 EMC Disk Array leading to more efficient use.
• Modified a COBOL application program to analyze a database standard sets only

Confidential

Unisys Systems Consultant

• Provided Tech Support for a Unisys machine managing two tech support personal, 7 operations staff and responsible for resolving all operations issues printing, performance, job scheduling, network issues, disaster recovery, and an outage issues
• Assisted developers in resolving COBOL74 programming issues.
• Upgraded DMSII databases and operating system MCP from MCP versions 42.2 to 47.2 on the A11-422 and A7-311 Unisys machines.
• Implemented the first successful disaster recovery plan in cooperation with SunGard.
• Used DBATOOLS for performance analysis in DMSII and Unisys package called BARS and SMFII to monitor performance of the MCP.
• Utilized Viewpoint and SMFII to determine discover bottlenecks and to see if the City of Jacksonville Unisys CLEARPATH NX5800 had the capacity to handle JEA A12-1222 and to increase job flow and run times.

Confidential

Unisys Consultant

• Performed analysis of a COBOL Program, discovered and corrected a major flaw in the Y2K EDITDATE routine.
• Wrote major code changes to over fifty COBOL74 programs for Y2K including screens, online programs and batch programs.

Confidential

Unisys Systems Consultant

• Developed benchmarks to determine if improvements were needed in various stages of SWIFT software.
• Performed regression testing to examine the product or program for potential weaknesses that discovered a transaction code that when modified, increased the speed of bank transfer of funds.
• Developed programs to test new applications and new SWIFT codes
• Wrote ALGOL and COBOL programs to test system security and identify potential capacity failures.

Confidential

Unisys Database Architect

• Worked with a three-member team responsible for upgrades of Unisys MCP and DMSII software, including Remote Databases, and general maintenance to the Unisys A17 and A19 multi processor systems .
• Used Team Quest SMFII to create year-end report and usage of system by categories to assist clients to determine the need for additional processors for the peak Christmas season.
• Performed Regression testing on new EMC disk and Storage TEK Tape drives to determine the best of breed to purchase and implement.
• Supported team member responsible for insuring databases were mirrored and all redundancy aspects were fulfilled including creating mirrored packs and adding or reducing pack families.
• Assisted developers in resolving COBOL failures and issues