Executive Summary

Don is an intuitive problem solver who applies SDLC principles with a passion to create more efficient business environments with minimal operational impact on current practices. His career provides consistent evidence of applying a balanced approach in consulting to sensitive technical and complex environments. Don has over 10 years of experience in Mainframe, and he is well-versed in TSO/SPF, JCL, Excel, DB2, SQL and SPUFI.

Project Experience

President/Owner

Confidential

Co-founded and managed independently owned consulting company that specialized in project management and software application development in full life cycle environments for major corporations. Recent experience at financial institutions included major enhancements to a trust accounting system with real time securities trading interfaces, payment processing, and account reporting and asset management.

Mainframe Consultant

Confidential

• Designed coded and implemented automated customer account transfer system ACATS for PNC bank to NSCC interface. The system consisted of a batch component to receive multiple daily transmissions and updated DB2 tables. These tables were available for viewing online using many CICS screens.
• Took part in the re-engineering of AMtrust account and asset master files and their conversion.
• Designed coded and implemented online option block trading system to allow investment officers to buy, sell, or exercise option trades.
• Edited JCL jobs and resolved errors when necessary.
• Created programs to receive and send MQ trade messages to simulate high trade volume. This was used to stress test existing programs, identify shortcomings and recommend efficiency enhancements Built JCL for production jobs and utilities.
• Maintained and made enhancements to AMtrust base system.

IT Environment: DB2, MQ, JCL, COBOL, CICS, VSAM, SPUFI, QMF, SQL

Mainframe Consultant

Confidential

Provided enhancements to insurance health administration systems and provided day-to-day support. Areas of responsibility included customer billing and rate quoting.

Long Term Care Rate Increase project.

• Designed and created client/server to Mainframe interface that used files of generated rates to feed mainframe databases.
• Built JCL for production jobs and utilities.
• Automated Actuarial department rate load process.
• Heavily involved in Endevor source code management implementation. Coordinated identification of current Source and Object modules. Assisted in employee training.
• Designed, coded, tested, implemented customer service screens to display available downgrade options.
• Completed certification in DB2 application performance and tuning.

IT Environment: zOS, COBOL, CICS, VSAM, JCL, SPUFI

• Designed, programmed and implemented a data extract process from the Trust Accounting system to a common data repository data warehouse .
• Developed and tested COBOL, MVS, CICS and VSAM .
• Created a message interface to receive and upload trades in SWIFT format from external brokerage companies to the Trust Accounting system.
• Created reports in Excel.
• Built JCL for production jobs and utilities.
• Edited JCL jobs and resolved errors when necessary.
• Analyzed test results and determined defects.
• Maintained the system, resolved issues and created enhancements when necessary.

IT Environment: MVS, COBOL, CICS, VSAM, JCL, SPUFI

Mainframe Consultant

• Customized and installed the AMTrust Accounting system.
• Designed, programmed and implemented a number of major enhancements, including several inquiries, data entries and update screens, and an interval control subsystem that triggered trading cutoff deadlines using COBOL, MVS, CICS and VSAM.
• Built JCL for production jobs and utilities.
• Edited JCL jobs and resolved errors when necessary.

IT Environment: MVS, COBOL, CICS, VSAM, JCL, SPUFI

Mainframe Consultant

• Created a message interface to receive and upload trades in SWIFT format from external brokerage companies to the Trust Accounting system.
• Built JCL for production jobs and utilities.
• Edited JCL jobs and resolved errors when necessary.

IT Environment: MVS, COBOL, CICS, VSAM, JCL

• Created a message interface to receive and upload trades in SWIFT format from external brokerage companies to the Trust Accounting system.
• Built JCL for production jobs and utilities.
• Edited JCL jobs and resolved errors when necessary.

IT Environment: MVS, COBOL, CICS, VSAM, JCL

Mainframe Analyst

• Designed and wrote the interface to a client server-based portfolio management system. The client server system created trades that were uploaded to the mainframe where stock and mutual fund trades were executed. The results were downloaded to the server.
• Performed programming, testing and implementation of various enhancements to the AMTrust Accounting system.
• Designed, specified, coded and tested a mutual fund trade aggregation system where trade creation and reporting were initiated by the fund cutoff time and used CICS interval control.
• Converted and implemented AMTrust from an in-house trust accounting system..
• Enhanced and maintained DB2 programs.
• Conducted production support, testing and maintenance of daily activity.

IT Environment: MVS, COBOL, CICS, VSAM, DB2, JCL