SUMMARY

• Expert Mainframe and SAS Senior Programmer / Analyst. Subject matter expert on COBOL, CICS, DB2, SPUFI, QMF, VSAM, JCL, SORT, MQSERIES, COBOL DB2 STORED PROCEDURES, NATIVE SQL STORED PROCEDURES, SAS, SAS MACROS, IBM ASSEMBLER LANGUAGE, REXX and CLISTS, ISPF DIALOG MANAGER, ORACLE, and UNIX.
• Full SDLC developer in the Finance and Global Wealth Management and Accounting and General Ledger and Payroll and Book - Keeping and Data WareHouse and Tax and Balance and Control and Government Operations and Brokerage/Investment-Banking and Securites Processing and Capital Markets and Taxlots and Cost Basis and Corporate Actions and Healthcare and Life Insurance spaces.
• As part of Onshore-Offshore group, worked on financial software issues and performed production support and root-cause analysis 24/7/365.

TECHNICAL SKILLS

Software, Tools, Languages: All dialects of COBOL; CICS; VSAM; DB2 and SPUFI and QMF and DB2 Utilities; JCL; SORT; SORTJOIN; ICETOOL; MQSERIES; COBOL DB2 STORED PROCEDURES; NATIVE SQL STORED PROCEDURES; SAS; SAS MACROS; REXX and CLISTS; ISPF DIALOG MANAGER; IBM ASSEMBLER LANGUAGE; Endevor; Changeman; INTERTEST and EXPEDITER and IBM DEBUG TOOL; FileAid and COMPAREX; ESP (aka CA Workload Automation) and CA7 and OPC; FTP and SFTP and NDM; Microsoft Office. Light experience with PL/SQL; SQLPLUS; SQL DEVELOPER; UNIX, UNIX Shell Scripts.

Databases: DB2; VSAM; ORACLE; CINCOM’S TOTAL; IDMS

Operating Systems: MVS/ESA and z/OS; WINDOWS 9x/7/10; UNIX

PROFESSIONAL EXPERIENCE

Confidential

Senior Programmer/Analyst

Responsibilities:

• Worked on a syndicate allocation and trading system using Mainframe COBOL DB2 Stored Procedures and Native DB2 Stored Procedures and CICS and COBOL; XML; XSD Schema; QMF Procedures; SPUFI; JCL; SORT; DB2 Utilities; FILEAID; MQSERIES.
• Used FILEAID’s XMLGEN Utility.
• Conducted impact analysis; documented programs, processes, flows in Microsoft WORD and Microsoft POWERPOINT.

Confidential

Senior Programmer/Analyst

Responsibilities:

• For Managed Accounts Billing and Client Billing Reporting:
• Enhanced an error detection system that creates and sends early warning email alerts to our group and to our users whenever the count and/or quantity and/or amount variance from yesterday to today exceeds parameters that we setup/defined in our DB2 table (and our created email attachment contains a detailed report).
• Added email protocol called RFC 2045 to COBOL programs so that emails with attachment lines greater than 998 bytes can be sent via SMTP to our EXCEL Spreadsheets without being truncated.
• For entries that had no history, added variance entries to our data (this required an extensive enhancement to our COBOL programs) so that this data will be consistent when it is populated into our EXCEL Spreadsheets.
• Used COBOL, DB2, VSAM, JCL, SPUFI, INSYNC, SYNCSORT, SORT, SORTJOIN, ENDEVOR, SAR, ESP.

Confidential

Senior Programmer/Analyst

Responsibilities:

• For TAX Department (Financial Services) for Confidential Insurance Company’s regulatory requirements:
• Modified IBM Basic Assembler Language Programs and batch COBOL programs and online CICS COBOL Programs that read DB2 tables and VSAM files and that delivered/received messages into MQSERIES queues via queue manager.
• Worked on JCL/Utilities (i.e., SORT and FILEAID) and Jobs/Procs. Modified COBOL DB2 Stored Procedures and Native SQL Stored Procedures that were triggered by JAVA and that transmitted Tax Forms to the Stored Procedure via utilizing Global Temporary Tables and Host Variables.
• Put programs into production using ENDEVOR.
• Used IBM DEBUG TOOL to debug programs.
• Passed LOMA 281 exam. Passed LOMA 291 exam.
• Used IBM BASIC ASSEMBLER LANGUAGE, COBOL, COBOL DB2 STORED PROCEDURES, NATIVE SQL STORED PROCEDURES, CICS, DB2, VSAM, MQSERIES, JCL, JCL/Utilities, SORT, FILEAID, IBM DEBUG TOOL, ENDEVOR.

Confidential

Senior Programmer/Analyst

Responsibilities:

• For a Fixed Income Project within the Capital Markets space which required adding Bank Custody data to files that contained Brokerage data:
• Specified, modified, tested, implemented (via ENDEVOR), supported Batch and Online COBOL Programs with VSAM and DB2 and MQSERIES.
• Worked extensively with JCL and PROCS and SYNCSORT and INSYNC.
• Wrote numerous SPUFI’s and SQL prior to placing them into the DB2 program and for data analysis.
• Used CICS and Batch TRACEMASTER to test programs.
• Wrote test plans for several programs.
• Used SAR for job output display and ESP for job scheduling.
• Applications allowed display of, data-entry of and reporting of check batches. Used BMS/GT and BMS to modify CICS screens.
• Used COBOL, CICS, BMS/GT, VSAM, DB2, MQSERIES, JCL, SYNCSORT, INSYNC, TRACEMASTER, ENDEVOR, SAR, ESP.

Confidential

Senior Programmer/Analyst

Responsibilities:

• Improved the Reconciliation Process by adding a clearance report for the EPAY Vendor; and by pulling data from this report and from the cashed report so as to create a new report containing correct certified opening and closing balance for all vendors.
• For Accounts Payable and General Ledger and Payroll and Accounting Departments and within ASI Mainframe Vendor Package: Designed, created, tested, implemented and supported COBOL Batch Programs (some contained an internal SORT) that created reports and EXCEL Spreadsheets and extract files (copied to website).
• Wrote REXX utilities for team members that automated repetitive tasks.
• Corrected the spelled-out check amount on the checks.
• Used COBOL, JCL, FTP, REXX.