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, Accounts Receivable, 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, Confidential utilities, Infor (Geac/DBS) financial applications.Tools include Fileaid, Intertest, Expeditor, Endeavor, EZTrieve, Changeman. PC application experience includes Confidential Office, Lotus Notes, Confidential Outlook.

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Support and maintenance of vehicle insurance application.
• Projects include enhancements to programs interfacing with state motor vehicle dept.
• Used z/OS, CICS, COBOL, IMS.

Confidential, Canton, OH

Responsibilities:

• Maintenance and support of Infor (Geac/DBS) DB2 and VSAM software applications (General Ledger, Accounts Payable, Millennium, Accounts Receivable, Fixed Assets, and tools such as SDT and PDL).
• Used z/OS, DB2 (SQL, SPUFI, QMF, SQL/PL Stored Procedures), CICS, COBOL.

Confidential, Freeport, ME

Responsibilities:

• Changes to numerous COBOL programs to accommodate credit card tokenization (scrambling of credit card numbers).
• Rewrite programs to directly invoke credit card tokenization web service.
• 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

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 Confidential applications prior to migration to BNY Confidential 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 Confidential and Confidential applications.
• New application was also to be used for any new clients that BNY Confidential would be servicing.
• Used z/OS, DB2 (SQL, SPUFI, QMF, Stored Procedures), COBOL.

Confidential

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 Confidential .
• 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 Confidential benefits information to Confidential providers.
• . Used z/OS, DB2, CICS, COBOL II, SPUFI, QMF, MQSeries.

Confidential, Boston, MA

Responsibilities:

• 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 Confidential ERP environment.
• Extensive use of SQL for data analysis and data scrubbing.
• DB2, CICS, COBOL II, SQL, SPUFI, QMF.