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. 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 Confidential . 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.