Comprehensive experience in the commercial data processing field as a Programmer/Analyst and Software Administrator. Strong analytical, design, programming and testing skills for financial, brokerage and insurance applications including the full project life cycle development, COBOLII, DB2/SQL (V7), CICS, ORACLE PL/SQL, Stored procedures design and QA testing, EDI, Gentran, MQ Series.
Hardware: IBM MAINFRAME, IBM PC.
Software: COBOL II, CICS, BMS, VSAM, DB2/SQL, DB2I, IMS, MQ Series, OS/MVS/JCL, SAS, UNIX AIX, ORACLE PL/SQL,
CHANGE MANAGEMENT, ENDEVOR/MVS, INFOPAC-
RDS, INTERTEST, FILEAID, XPEDITER/TSO, EMC2, INFO/ MGMT, QMF, PLATINUM, MS SQL Server 2000, Windows
NT, CA7/CA11, DOCUMERGE, DAP9.0 (FSI), Lotus Notes, MS OFFICE XP(MS WORD, MS EXCEL, MS
ACCESS), .NET, IDCAMS, MVS/JCL, TSO/ISPF,
AMERICAN INTERNATIONAL GROUP, Livingston, NJ.
Lead Associate, Programmer /Analyst;; Mainframe Software Administrator October 2007- March 2018
InfoPac (MOBIUS ViewDirect), DocumentDirect, Endevor, INFO/XE, Jobscan, DOCU/TEXT, CA/Dispatch, Changeman, CA7/CA11. Responsibilities:
Perform DataBase Administration functions for MF Software InfoPac (View Direct and CA/Dispatch). Tasks include:
• Apply report distribution changes (add, deletes, changes) recipients, reports, online viewing, hard copy etc... (InfoPac and CA/Dispatch)
• Responsible for maintaining and upgrading functional IT group software in order to provide optimal service and availability to business client.
• Configure / customize new and existing software products (Report Distribution, Source Control).
• Create and maintain software/ file security.
• Develop automatic routines to enhance production tasks – eliminating manual intervention / tasks.
• Modify, maintain, improve, and troubleshoot existing software.
• Work with vendor to customize new software.
• Provide information, support and consultation for IT organizations.
• Generate and maintain reports and documentation.
• Provide direct liaison with the customer for all technical discussions and issues.
• Review system performance measure.
Loss Management System (LMS)
The LMS is a claims processing system. LMS was developed to provide a more efficient means of accessing policy information and entering claims. Specific responsibilities included:
• Coding, testing, debugging and maintenance of COBOLII/CICS programs with DB2/SQL and VSAM files; Created reports. Conversion (moving data from VSAM and DB2).
• CodingbDB2 STORED PROCEDURES with MQ Series; Model and Unit testing; QA testing, production support; Production Scheduling. COBOL II, DB2, CICS, VSAM, IDCAMS, MVS/JCL, TSO/ISPF, FILEAID, EXPEDITOR, DB2 Utilities, DB2 Connect, FTP, MQ Series, CHANGEMAN/MVS, CA7/CA11.
UBS, Weehawken, NJ
Lead Associate, Programmer /Analyst on UBS Unit Trust Systems December 2006 – June 2007
IT- MCDONALD INTEGRATION project
• Trader or Operation has the capability to add securities on the TRUST file.
• Trader or Operation has the capability to perform maintenance functions to securities on TRUST file.
Online process – include a new field on the New Trust Entry screen to determine whether a trust is a non-proprietary / non-underwritten. Batch process:
• Maintain trust data integrity by including the underwritten field indicator.
• Process specific blotter trades as agent.
• Process proprietary and non-proprietary underwritten trades as principal.
• Process non-proprietary/non-underwritten trades as agent COBOL II, COBOL III, DB2, CICS, VSAM, MVS/JCL, TSO/ISPF, CHANGEMAN/ MVS, EXPEDITOR
CITIGROUP (SALOMON SMITH BARNEY), Warren, NJ
Lead Designer / Programmer /Analyst
August 2005 – November 2006
Recon Plus development project
The scope of this project is to create new system that will process brokerage financial information and produces reports that will show activity and balance information of USD and currency accounts activity. COBOL II, COBOL III, DB2, CICS, VSAM, IDCAMS, MVS/JCL, TSO/ISPF, CHANGEMAN/MVS, EXPEDITOR, CA7/CA11
BANK OF AMERICA, Albany, NY
April 2005 – August 2005
The Legacy Fleet Image Statements System project
The scope of this project is to update system modules based on Bank of America standard and move the NE Image Statement application from the Albany Mainframe to the BAC environment prior to Albany mainframe being decommissioned. Specific responsibilities included: Coding new and update existing modules; Model and Unit testing; System conversion; QA testing; Production Scheduling.
COBOL II, DB2, CICS, VSAM, IDCAMS, MVS/JCL, TSO/ISPF, CHANGEMAN/MVS, EXPEDITOR, CA7/CA11
UNITED PARCEL SERVICE, Morristown, NJ
July 2004 –October 2004
UPS TradeAbilityTM Project, a PMG-charted project designed to increase UPS’s international package market share and generate new, profitable non-package services and revenue streams. System uses Java as a front end. Specific responsibilities included: System architecture and design; Creating specs, project coordination; Coding DB2 STORED PROCEDURES with MQ Series; Model and Unit testing; QA testing, production support; Production Scheduling. COBOL II, DB2, CICS, VSAM, IDCAMS, MVS/JCL, TSO/ISPF, FILEAID, EXPEDITOR WLM, DB2 Utilities, DB2 Connect, FTP, MQ Series, JAVA.
NEW YORK LIFE INSURANCE COMPANY, New York, NY
February 2004 –June 2004
Support NCAA Policy and NCAA Marketer production batch cycles and handle customer change requests. Support the nightly batch cycles for NCAA Policy system and NCAA Marketer system as well as work on change requests as needed. Specific responsibilities included: Coding, debugging and production implementation of the SYSTEM; Modifying existing programs; Create specific reports per user’s requests using SAS and DB2; Model and Unit testing; QA testing, production support; Production Scheduling.
DB2, SQL, COBOL II, MQ Series, Syncsort, Fileaid, Nyllms, DB2 Utilities, FTP, JCL, Endevor, Platinum, CICS, CA7/CA11
CITIGROUP (SALOMON SMITH BARNEY), New York, NY
Sr. Programmer / Analyst
July 2000 – January 2002
Large Options Reporting System/ Settlement System
Maintain the system that processes securities transactions and updates
“stock record” information. Provide financial and brokerage information
(using CUSIPS) for Salomon Brothers clients. The front-end of the system dynamically updates securities (accounts) information during the day trade session, the back-end of the system provides last business day updates. Specific responsibilities included: Writing new application programs in COBOL/DB2 and CICS for the project; Modifying existing COBOL/IMS programs per user’s requests; Front-end and back-end system preparation for future “NEXT DAY CLEARANCE” project which included database redesign (DB2, IMS), source code analysis of ‘stock record’ system and test region allocation; Debugging DB2 STORED PROCEDURES in CODE/370 using PWS and XPEDITER/TSO; Coding and testing DB2 STORED PROCEDURES for system usage; Coding SAS programs that produce specific reports (like Fails - items that did not settle by their settlement date, Breaks - security activity that does not balance at the end of the night etc) based on users requests; Creating reports using ORACLE SQL and PL/SQL coding; Support of the QA environment of the system; QA testing, production support. COBOL II, DB2, CICS, IMS, VSAM, MQ Series, UNIX AIX ORACLE and MS OFFICE XP
TEFRA - Salomon Tax Reporting System. Analyze, document and upgrade TEFRA tax reporting system for Salomon Brothers Inc. Consolidate functions into subsystems that handle the following tasks:
“TEFRA/General Ledger to compare withholding of Original Issue Discount Calculation Master Limited Partnership Reporting Non-resident Alien Reporting Client 1099s and 1042s”. Revise client and IRS 1099 and 1042 reporting for yearly changes. Specific responsibilities included: Development and maintenance of COBOL II/CICS / DB2 programs; Coding FTP procedures to support Internet IRS reporting; Support of 1042 processing using laser (flash) printer; Special JCL “in stream” text coding and FTP; PC conversion using special Salomon tools; QA, EDI, Parallel testing and Production Scheduling.
COBOL II, DB2, VSAM, MS EXCEL and MS ACCESS
MERRILL LYNCH & CO., INC, New York, NY
November 1997 – July 2000
GLOBAL CUSTODY Financial System
System provides different kinds of financial and brokerage (security processing) information such as transaction activity, dividends, clearing etc. for Merrill Lynch clients. Specific responsibilities included: Maintenance and development of the new part of the system including coding, testing and debugging; Spec preparation for “NEXT DAY CLEARANCE” projects; All development and maintenance was done using COBOLII/DB2/, COBOLII/CICS programs; Creating reports using SAS and Easytrieve; QA testing and Production Scheduling; QA test plans and test cases.
OASIS/GENERAL LEDGER Financial System
System process Last Business Day (LBD) stock market activity and produces different reports based on user requests. Specific responsibilities included: Production support and maintenance of the system; Making specific changes in source codes, JCL and PROC based on user requests; OASIS/GENERAL LEDGER Financial System MQ Series conversion; Participated in Year 2000 conversion of the system. Expanded existing files to include the new century in date fields and modified on-line and batch modules. Expanded control cards for utilities to accommodate amended files and to include century in the date calculating routines. Designed and coded various management reports, showing the Year 2000 solution; Developing EURO currency exchange on Financial System. Modifying module calls from IMS Data Base to DB2 database. Involved in COBOL-to-COBOL II conversion; QA test plans and test cases; QA testing Production Scheduling and Database design of the system after each upgrade. COBOL II, CICS, DB2, and VSAM AMERICAN INTERNATIONAL GROUP, New York, NY
October 1994 – October 1997
Underwriting Processing System (UPS)
The use of UPS mainly involved issuing policies in various coverage and different lines of business, such as commercial auto, general liability etc. It also involved usage of an image processing system called DOCUMERGE for EDI purposes. Specific responsibilities included: Coding, testing, debugging and maintenance COBOLII/CICS programs with DB2/SQL and VSAM files; Coding stored PROC on MS SQL Server for PC part of UPS project; ENDEVOR was used for moving jobs to productions; XPEDITER and INTERTEST was used as a testing facility. The system was developed and implemented in a multi-platform environment of LAN PC and OS/ MVS. C
OBOL II, CICS, DB2, and VSAM
A fully integrated on-line report distribution facility that sorts and collates reports in end-user order to expedite distribution. Specific responsibilities included: Creating new reports, recipient ID’s, and updating AIG users IINFOPAC database; INFOPAC production support.
DB2 and relational data base concepts, NYU, School of Continuing Education, New York.
MS in Science
Polytechnic University, Kiev.