SUMMARY:

• COBOL CICS DB2 professional programmer with extensive experience in Mainframe environment systems design, development and implementation high - level complicity applications with operation of highest volume of data in a market.
• Over 17 years of experience in COBOL, over 12 years in DB2 (V8, V9, V10) batch and on-line, and over 5 years on MQ Series with transmission flat files and XML data.
• Experience in new database logical and physical design, using new data types to store XML data in DB2 as well as creating stored procedures and performance tuning.
• Experience in performance monitoring and run time improvement using BMC utilities.
• Long-standing experience operation in production environment and production support.

TECHNICAL SKILLS:

Hardware: IBM 390, IBM 370, IBM PC.

Software: CICS (Command level), DB2 (MVS), VSAM, Oracle (UNIX/NT), MQ Series, SPUFIFILE-AID, FILE-AID for DB2, Xpediter, Syncsort, QMF, Proedit, Strobe, IBM Utilities, IBM Debug, IBM StarTool, File Manager, TSO/ISPF, CMS, Intertest, ZEKE, SysVew, Panvalet, Endevor, Change Man, Micro Focus Revolve, Smart TS, NDM, FTP, SFTP, MSOffice (Excel, Access, Word, Outlook, Visio), Erwin, Lotus Notes, Infoman, BMC MAINVIEW.

Languages: COBOL, COBOL2, COBOL3, JCL, DML, DDL, DCL, SQL, FOCUS, SAS, PL/SQLHTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, Pennington, NJ

Sr. Programmer Analyst, Consultant

Responsibilities:

• Defined new client table for supporting expiration date of Acknowledgement document.
• Created new stored procedure for insert and delete rows in the table when document is expired.
• Updated the process in Document Tracking System to be able to handle new client document in on-line and batch environment with ability to approve it and store the date until it will be expired.
• Established connectivity and processing data required for other related systems.
• Implementation able to perform approval new client document from traditional CICS screen as well as from front-end system using scanned documents.

Environment: Z/OS, TSO/ISPF, Cobol 3, DB2(10.1), CICS, VSAM, MQ Series, XML, Endevor, IBM Debug, File Manager, AIRS, Harness, BMC Mainview and Catalog manager.

Confidential, Franklin Lakes, NJ

Sr. Programmer Analyst, Consultant

Responsibilities:

• As a part of the team participated in implementation Confidential project for obtain Confidential number by Drug number and location.
• Worked on conversion TOLAS ESI replenishment reports system using Confidential facility into EIW (Enterprise Integrated Data Warehouse) for Confidential client. Responsibility includes: data mapping existing ESI system against Confidential database of inventory system; creation System and Technical Design documents; build new programs to obtain data from Confidential database to delivery it into Enterprise Integrated Data Warehouse; testing and implementation new process for Confidential client using Confidential DB2 database instead of using old TOLAS file system.
• Participated in Fiscal to Gregorian conversion project for Inventory system.
• Performed production support of online inventory system and fixed several production BUGs.
• Worked on Integration Multiple Credit Cards project for NRX system. Performed and implemented changes to transfer Multiple Credit Card data request from front end ALPHA system to MAR system.
• Lead creation and implementation NRX exception reports procedures integrated into POLAR JCL Generator project.
• Extended for NRX online system length of description of compound in a screen using XML transmission existing process.
• Worked on improvement of DB2 performance for ORT (Open Refill) system.

Environment: Z/OS, TSO/ISPF, Cobol 3, DB2 9, CICS, VSAM, MQ Series, XML, Endevor, Intertest, File Manager, Smart TS

Confidential, Warren, NJ

Application System Engineer Lead, Consultant

Responsibilities:

• In Regional Stock Record environment as a tech lead was responsible for technical design, development and implementation new reconciliation process of OCC collateral pledges and reported by DTCC positions determining separately for customer and firm collaterals.
• Establish connectivity to OCC and initiation of daily processing of receiving OCC end-of-day collateral report.
• Created procedure in COBOL 3 to read and converting XML file From OCC into regular file obtaining only OCC EOD collateral pledges.
• Using created file as a source to determine portion of firm and customer collateral positions based on total positions supplied by DTCC by including sequential match of positions from a new file and existing end-of-day DTCC APIBAL file and creating new break report.
• Adjusted reconciliation process between DTCC collateral pledges and Stock Records splitting reconciliation between firm and customer OCC accounts. Entire process implemented with full user satisfaction.
• Performed analysis of production problems and proposed solution to resolve it.
• Using of-shore resources organized creation and scheduling new DTE QA test environment for GSEG 4 Box project for Regional Stock Record applications to put in place business and system process so as to segregate Prime Broker and non Prime Broker activity at Euroclear and various non Confidential . On a daily bases responsible for a cycle run receiving input data from multiple systems depending on Prime Broker activity starting from trade date to settlement date and subsequent cleanups and reconciliations. Monitored system daily cycles run, analyzed results of processing and reported to multiple business users. Operated with hundreds thousand million records of data in a different formats. New environment become reusable for other projects.

Environment: Z/OS, TSO/ISPF, Cobol 3, DB2 8, CICS, VSAM, MQ Series, XML, Change Man, Intertest, FileAid

Confidential, New York, NY

Senior Programmer/Analyst, Consultant

Responsibilities:

• Implemented in production new connectivity for new server for existing banks for BAS system.
• Based on data profile requirement installed new banks for BAS system.
• Analyzed performance of SQL queries using EXPLAIN and modified query bases on results.
• Built native Stored Procedures on DB2 that populates data for front-end application that maintained from Data Studio console.
• Performed analysis of DDM test environment, created job track scheduling by-request in SysView that decrease run test cycle from 8 hours to 1 hour.
• Designed specifications for processing reformat dollar file in front-end environment for ITI banks.
• Participated in re-design BAS ITI mainframe application to integrate with .NET application.
• Created and maintained BURNDOWN Chart for maintenance Agile project.

Environment: Z/OS, Cobol2, CICS, DB2 9, SysView scheduler, Intertest, FileAid, FileAid for DB2

Confidential, Jersey City, NJ

Senior Programmer/Analyst, Consultant

Responsibilities:

• Built new on-line process for Entitlement based on response from Notification system.
• Performed modifications of real time Entitlement application (data pass by MQ, VSAM files and TSQ). Created a program that read XML data stored in DB2 in CLOB format.
• Created test events as a copy of production in Repository in QA environment and process them through Entitlement and Notification applications using modified programs.
• Responsible for monitoring and keeping running QA environment using BMC MAINVIEW utility to run through events and fixed problems when occurs. Monitored MQ running splits.
• Researched production problems when assigned by analyzing backup, log and error files/tables, reproducing events in QA and analyzing Repository and Election database.
• Fixed production problem and improved Election Setup Plan Type processing related to create new, update and delete symbols. Improved performance by creation direct access to Security Master Database to obtain current security data for current event.
• Performed QA test all changes, prepared packages in Endevor and implemented changes to production. Performed post implementation analysis.
• Communicated on a daily bases with front-end and offshore co-workers
• Analyzed old TEST region, defined CICS missed resources (PPT, PCT, FCT) allocated missed VSAM files and re-compiled, re-bound idle DB2/CICS programs.
• Established requested connection to QA and TEST databases using TEST CICS region.

Environment: Z/OS, COBOL 3, DB2 9, CICS, VSAM, MQ Series, Endevor, Intertest, FileAid, XML.

Confidential, New York, NY

Senior Programmer/Analyst, Consultant

Responsibilities:

• Extended existing on-line Mainframe programs according to functional specifications related to New Business, New Questionnaire, Investments and Review Adjustment of Investment in COBOL/DB2/CICS environment with Java front-end screens.
• Collaborated with off-shore team to efficiently allocate resources.
• Performed debugging modified on-line programs using GUI/XI debugging tolls for XML and Xpediter.
• Improved DB2 query performance using Explain.
• Updated in batch on a daily DB2 tables according to new requirements.
• Analyzed problem identified by QA, fixed them.
• Together with Release Manager promoted all project changes to PRU QA preproduction region.

Environment: Z/OS 1.8, COBOL 3, DB2 8, CICS, VSAM, MQ Series, Change Man, Xpediter, FileAid, XI, XML.

Confidential, Jersey City, NJ

Senior Programmer/Analyst, Consultant

Responsibilities:

• Designed new MUNI database for MSD system.
• Re-designed batch intra-day process to on-line processing.
• Rebuilt browsing processes listing of Cusips by referencing DB2 tables instead of VSAM file.
• Created stored procedures to insert data of new securities into DB2 tables.
• Restructured single Cusip inquiry process on multiple detail screens referencing to some of 21 new tables instead of one entire file.
• Created QA programs in COBOL for compare data in VSAM file and DB2 tables.
• Revised MSD application to be able to process upcoming Fannie Mae alphanumeric pool number representation, instead of numeric, and implemented changes in batch and on-line.
• Established new communication SFTP process for MSD system to deliver files from MVS system to remote UNIX server through local OMVS IBM Unix server using two types of identification: Remote ID/Password and Authentication keys.
• Communicate daily with front-end users on MQ and Sybase data compatibility issues.

Environment: Z/OS 1.6, TSO/ISPF, COBOL 3, DB2 8, CICS, VSAM, MQ Series, Change Man, Intertest, FileAid, SDF2

Confidential, Jersey City, NJ

Senior Programmer/Analyst

Responsibilities:

• Responsible for correctness of on-line Funds Available calculation based on current government regulation.
• Implemented on-line free cash amount calculation process (in addition to on-line Funds Available) to fine tune the rules of appropriate routing to the Margin department, supplied an additional data for Margin Calculator for Workflow.
• Created new system for daily management reports based on high level user requirements obtaining data from multiple DB2 tables and delivered by e-mail as text attachments.
• Enhanced flexibility of Delta process for Guarantee/Grantor and synchronized Guaranty/Risk file finding different way of accessing data, which eliminated duplicates.
• Synchronized Batch Message Controller verification process controlling 69 log files and revised predecessors to prevent usage previous day GDG using LISTCAT file created in BATCH.
• Revised and reinstated purge jobs for backup files of 16 tables in PROD & QA according to new regulations
• Based on REGT regulation changed Margin Liquidity Calculation and redesigned Funds Available on-line calculation and screen.
• Substituted Platinum “Fust Unload” utility to BMC unload utility as part of IBM Platinum Elimination project.
• Substituted usage of DB2 variable length image copy as a data source for Batch processing to usage simple unload files.
• Created multiple jobs to load/unload data from DB2 tables, MQ and VSAM files and FTP transmit ions. Reset tablespaces pending statuses.
• Responsible for reporting semi-annually to Federal Reserve Bank about domestic and foreign securities holders.
• Analyzed FRB request documentation and created list of changes in existing process, implemented changes. Obtained data from other systems and performed test runs.
• Converted test results into EXCEL reports and supplied to auditing group for review.
• After corrections performed semiannual production runs and converted results into EXCEL reports. Created Fluctuation and TIC comparison reports.
• Automated process of creating reports by considering standard format of files received from PC.

Environment: Z/OS 1.6,TSO/ISPF, Cobol 3, DB2 8.1, CICS 3.1, VSAM, MQ Series, Change Man, IBM Debug

Confidential, Montvale, NJ

Programmer/Analyst, Consultant

Responsibilities:

• Participated in system design, programming, unit, regression and QA system testing.
• Prepared release documentation, packaging, and graphical documentation for entire project.

Environment: Z/OS, COBOL 3, DB2 9, CICS, VSAM, MQ Series, Endevor, Intertest, FileAid, XML.

Confidential, Orangeburg, NY

Senior Programmer/Analyst, Consultant

Responsibilities:

• Production support I2K billing system according assigned schedule.
• Modification SMS billing program according to price changes for billing corporate and single clients. Analysis and optimization of SQL statements to improve performance.
• Coding, testing and implementation enhancements related to passing error messages through multiple CICS programs. Post implementation support

Environment: MQ, COBOL II, DB2, CICS, VSAM, JCL, Xpediter, FileAid, BMC unload.