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.

TECHNICAL SKILLS:

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, Freeport, ME

Responsibilities:

• 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, Sparks, MD

Responsibilities:

• 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, Bloomfield, CT

Responsibilities:

• 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, Keene, NH

Consultant

Responsibilities:

• 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, Westborough, MA

Responsibilities:

• 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, Jersey City, NJ

Responsibilities:

• 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, Everett, MA

Responsibilities:

• 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, Westborough, MA

Responsibilities:

• 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, Hartford, CT

Responsibilities:

• 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, Middletown, CT

Responsibilities:

• 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, Boston, MA

Consultant

Responsibilities:

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