We provide IT Staff Augmentation Services!

Consultant Resume

Freeport, ME

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

Consultant

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

Consultant

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

Consultant

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

Consultant

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

Consultant

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

Consultant

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

Consultant

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

Consultant

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

Consultant

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.

Hire Now