Summary

Over 25 years online and batch systems analysis and design experience in financial, insurance, retail, and medical applications.

• Experienced in COBOL, DB2 SQL, SPUFI, QMF, Stored Procedures , CICS Easytrieve, Infor Geac/DBS DB2 Software applications General Ledger, Accounts Payable, Fixed Assets .
• Experienced in supporting and troubleshooting critical applications with constantly shifting priorities where quick problem resolution was necessary.
• Experience with Sarbanes-Oxley SOX requirements.
• Experience with SDLC methodologies.
• Projects included development and support of both online and batch DB2 mainframe applications.

Software COBOL, z/OS, CICS, DB2 SQL, QMF, SPUFI, DB2 utilities, Stored Procedures , CA-Datacom, VSAM, IDMS, TSO, MVS JCL, MQSeries FTP, NDM, IBM utilities, Infor Geac/DBS financial applications. Tools include Fileaid, Intertest, Expeditor, Endeavor, EZTrieve, Changeman. PC application experience includes Microsoft Office, Lotus Notes, Microsoft Outlook, ASP.NET, C and Visual Basic .Net.

Experience

Confidential

• Changes to numerous COBOL programs to accommodate credit card tokenization scrambling of credit card numbers .
• Extensive testing of multiple CICS screens to determine if additional changes needed.
• Used z/OS, CICS, COBOL, DB2, SQL, Datacom.

Confidential

• Maintenance and support of Infor Geac/DBS DB2 and VSAM software applications General Ledger, Accounts Payable, Millennium, Accounts Receivable, and tools such as SDT and PDL .
• Working on project to reinstall and test all Infor/Geac applications as part of DB2 upgrade to version 10.
• Used z/OS, DB2 SQL, SPUFI, QMF, SQL/PL Stored Procedures , CICS, COBOL.

• Confidential Systems analysis, design, and development on project replacing VSAM files with DB2 tables, including batch and online components.
• Developed SQL/PL native stored procedures to be used as services to access and update various DB2 tables.
• Used z/OS, DB2 SQL, SPUFI, QMF, SQL/PL Stored Procedures , CICS, COBOL.

Confidential

Systems analysis

• , design, and development of CICS screens and programs to replace existing process for applying grocery item cost corrections to customers. New process reduced time needed to complete cost corrections by 90 .
• Detailed design, development, and documentation of application to resolve inventory discrepancies between central C S systems and warehouse systems.
• Used z/OS, CICS, COBOL, Datacom.

Confidential

• Analyzing over 100 existing jobs to create replacement methods for Fileaid.
• Debugging and correcting deficiencies in PNC Bank applications prior to migration to BNY Mellon mainframe.
• Mentored less experienced colleagues.
• Used z/OS, DB2 SQL, SPUFI, QMF, Stored Procedures , CICS, COBOL.

Confidential

• Online and batch support for Lehman Bros. general ledger post-bankruptcy.
• Created and executed batch and online regions for court-ordered financial closes.
• On-call support for ledger production batch cycle. Considered critical application, so problem resolution necessary within 2 hours before escalation to management.
• Completed a large number of requests for data extracts for bankruptcy court and Lehman entities, using both COBOL and SQL.
• Used z/OS, DB2 SQL, SPUFI, QMF, Stored Procedures , CICS, COBOL, Infor/Geac Millennium General Ledger.

Confidential

• Maintenance and enhancements to IAS, a securities accounting and custody application.
• Analysis and development to provide seamless financial reports merging data between Bank of New York and Mellon applications.
• New application was also to be used for any new clients that BNY Mellon would be servicing.
• Used z/OS, DB2 SQL, SPUFI, QMF, Stored Procedures , COBOL.

Confidential

• Analysis and design of enhancements to merchandise buyer purchase order application for highly visible European expansion project.
• Creating and enhancing online CICS screens and COBOL online and batch programs, using DB2.
• Projects included enhancements necessary for expansion into Germany and for new shoe store chain in Canada, using z/OS, DB2 SQL, SPUFI, QMF .
• Debugging and resolution of online abends.

Confidential

• Supporting and enhancing 4 Geac General Ledgers, along with other applications.
• Part of project porting existing Travelers Insurance applications to spin-off company. Responsibilities included managing group of off-shore consultants.
• Responsible for intensive testing, bug-fixing, and problem-solving.
• Conducted two Sarbanes-Oxley SOX audits of general ledger.
• Extensive contact with users.
• Used z/OS, CICS, COBOL, MQSeries, Infor/Geac Millennium General Ledger.
• Small projects involving Visual Basic .Net.
• Confidential Analysis, design, and development of enhancements to online system providing patient benefits information to healthcare providers.
• . Used z/OS, DB2, CICS, COBOL II, SPUFI, QMF, MQSeries.
• Confidential Consultant position: support of Geac General Ledger.
• Responsible for bug-fixing, problem-solving, and routine tasks.
• Had a great deal of user interaction, as users were relatively unfamiliar with application.
• Solely responsible for providing data extracts for conversion from Geac General Ledger to Peoplesoft ERP environment.
• Extensive use of SQL for data analysis and data scrubbing.
• DB2, CICS, COBOL II, SQL, SPUFI, QMF.