SUMMARY

• A Programmer/Analyst with 25 years experience in Information Technology.
• Responsibilities have included involvement in all phases of computer systems development and maintenance, primarily in the program design/analysis/specification phase through to the implementation phase.
• Industry experience includes pharmaceutical, accounts payable/receivable, supply chain, insurance, and brokerage.

TECHNICAL SKILLS

HARDWARE: IBM Mainframes, IBM Compatible PCs

MAINFRAME SOFTWARE: DB2, VSAM, QMF, ORACLE, DB2 utilities, MVS utilities, XPEDITER, INTERTEST, JCL, TSO/ISPF, FTP, ZEKE, Hiperstation

PC SOFTWARE: MICROFOCUS WORKBENCH, XDB, WINDOWSMS Office Suite, Lotus Notes, Manugistics Freight Pay System

PROGRAM LANGUAGES: COBOL II, DB2/SQL, CICS, REXX, MS ACCESS, VISUAL BASIC, JAVAHTML, JAVASCRIPT, JQUERY

TRAINING: Structured Programming, DB2/SQL, DB2 Stored ProceduresCICS, Performance Tuning, Systems Analysis & Design, MS AccessWeb Publishing, Client Server Concepts, Project LeadershipRelational Database Design, Java

ORAL/WRITTEN SKILLS: Prepared Impact Analysis reports, design specificationscomprehensive test plans, and Statements of Work utlining project requirements, costs, development strategies, risks, and limitations for mainframe batch & n - line systems Presented application overviews to end-users and business analysts

PROFESSIONAL EXPERIENCE

Confidential, Erie, PA

Mainframe Programming Consultant

Environment: CICS, DB2, COBOL II, Z/OS

Responsibilities:

• Evaluate needs, submit recommendations, and implement cost - effective technological solutions to help minimize overhead costs and maximize operational efficiency
• Meetings with business analysts and senior management to understand business processes and functionality in details.
• Design and development of systems using three-tier application structure that includes DB2 Stored procedures/Cobol batch, Java/JSP and HTML/JavaScript

Confidential, Raleigh, NC

Programming Consultant

Responsibilities:

Environment: CICS, DB2, COBOL II, Z/OS, JAVA

• Part of development team responsible for analyzing and maintaining large - scale Client Information System applications that incorporate the following technologies: CICS, DB2 SQL, COBOL, JAVA, Stored Procedures
• DBA functions which included performance tuning of applications, creation/normalization of DB2 tables, and analyzing EXPLAINs for SQL queries
• Conduct application overviews to end-users and business analysts

Confidential, Edison, NJ

Programming Consultant

Environment: CICS, DB2, COBOL II, TSO/ISPF, JAVA

Responsibilities:

• Designed, developed, tested, installed and maintained business applications that incorporated the following technology: CICS, DB2 SQL, COBOL, Oracle, DB2 Stored Procedures, Java, Unix, Manugistics Freight Pay (3rd party software), EDI/Gentran, Metafile software, and Microsoft Access. Some of the business applications developed consisted of the following: Freight Payment System - process to monitor/track shipments from vendors to Wakefern warehouses and Shoprite stores using Manugistics Freight Pay software. In addition, the process calculated freight costs, generated freight bills and payments to freight carriers, and provided the necessary data to the Accounts Payable General Ledger interfaces. Purchase Order/Invoicing System - process to allow vendors to enter invoices via Java/Web technology or via EDI. Once invoices are loaded into Wakefern s system, a reconciliation process is performed to accomplish the following: compare purchase orders to vendor invoices, perform complex calculations to determine if deductions/adjustments should be made against the vendor s invoice, book to the appropriate general ledger accounts, generate checks for vendor payment. Purchase Order Receiving Correction System - process to allow warehouse clerks to correct inventory counts that were previously entered into the system erroneously. Once the corrected counts have been entered, the process recalculates on-hand inventory, discounts, contracts, and generates adjustments to general ledger accounts. Metafile System process developed to store all paper documents (i.e., purchase orders, invoices, credit memos, adjustment memos, etc.) used by the Accounts Payable department. Allows users to view online and/or print all documents related to a vendor, purchase order number, or other search criteria.
• Performed DBA functions which included performance tuning of applications, creation/normalization of DB2 tables, and analyzing EXPLAINs for SQL queries
• Prepared Impact Analysis reports, design specifications, comprehensive test plans, and Statements of Work outlining project requirements, costs, development strategies, risks, and limitations for mainframe batch and on-line systems
• Presented application overviews to end-users and business analysts
• coordinated testing procedures and standards for large volume mainframe applications
• created testplans and test scripts for regression, unit, and integration testing of large mainframe applications
• Provided 24/7 production support as needed

Confidential, Piscataway, NJ

Programming Consultant

Environment: ORACLE 7.x, SQL, SQLPLUS, PL/SQL, SQLFORMS, COBOL II, TSO/ISPF

Responsibilities:

• Designed, developed, and implemented a system which allows J&J to electronically transmit (via EDI Technology) product price listings to outside distributors who buy and sell products. Benefits: significant reduction in paper waste and in mailing costs incurred as a result of generating hardcopy price listings.
• Developed online and batch applications for marketing representatives to assess the location and volume of products sold domestically and internationally.
• Prepared & presented design proposals which outlined project requirements, development strategies, security issues, project costs, risks, and limitations

Confidential, Paramus, NJ

Programming Consultant

Environment: DB2, SQL, CICS, COBOL II, DB2 Utilities, TSO/ISPF

Responsibilities:

• Member of development team responsible for designing, developing, and implementing a system to track the delivery of UPS packages and transmit (via email, fax, or mailing) package detail information to UPS subscribers and customers.
• Developed a user - friendly system (using REXX language & REXX Panels) which allowed the program development team to build & store sufficient test data, execute jobs, compare previous and current test results, and to review output reports and files in a more structured manner. Benefits: decrease in the amount of time and effort spent creating test conditions and verifying expected test results, easier to track and troubleshoot problems.
• Designed and developed generic modules (e.g., modules for Online Help and Error Processing) that were shared by various online and batch applications. Benefits: redundant code minimized, applications conform to similar standards, DASD costs reduced.

Confidential, Woodcliff Lake, NJ

Programming Analyst

Environment: DB2, SQL, CICS, COBOL II, TSO/ISPF

Responsibilities:

• Designed, developed and implemented DB2/CICS batch and on - line applications for a Mail-Order Prescription system.
• Monitored production jobs and recommended performance enhancements.

Confidential, Roseland, NJ

Programming Analyst

Environment: DB2, SQL, CICS, COBOL II, TSO/ISPF, IDMS, QMF, SPUFI, PROEDIT, CMS

Responsibilities:

• Member of development team responsible for converting Client Portfolio & Marketing applications from IDMS to DB2 database systems.
• Designed, developed, and implemented a process which standardizes client names and addresses used for mass mailings. Benefits: reduced the amount of mail returned from the post office due to invalid name and address formats, saved millions of dollars annually in returned - mail costs.
• Created a library of SQL queries designed to check database integrity, to ensure database info conformed to business rules, and to gather statistics that were used by marketing reps to target clients for certain products and services.
• Served on cost containment task force which evaluated various department expenses and inefficiencies. Reduced DASD costs by 40%, improved performance for online and batch systems, setup a central library which stored information for all ongoing projects, systems changes, and future systems enhancements.
• Project leader for various administrative and technical projects. Responsible for writing Statements of Work, tracking projects using Lotus Notes, delegating various tasks, and coordinating production releases.

Quality Assurance Tester

Environment: DB2, SQL, DB2 Utilities, TSO/ISPF, IDMS, Rexx, CMS

Responsibilities:

• Conducted regression, unit, system, and integration testing for DB2/CICS/IDMS batch and on - line applications.
• Participated in the analysis and justification of software and hardware purchases
• Developed quality assurance guidelines and procedures for the area
• Designed and developed a panel-driven system (using REXX language) to track projects assigned to each tester and to log outstanding issues and problems associated with each project.
• Prepared comprehensive test plans and test scripts for DB2/CICS/IDMS batch and on-line systems

Clerk Typist

Responsibilities:

• Performed secretarial work for Claims Department
• Drafted and typed letters and memos
• Performed general typing of policies and procedures
• Recorded and transcribed minutes for departmental staff meetings and various committee meetings.