System Manager

ARIEH BOBROW

** ********* **

Great Neck, NY ****1

516-***-**** 516-***-**** mobile

******@*********.***

SUMMARY

Senior Programmer/Analyst to project leader and project manager experienced in banking back office systems, money transfer and wire, international deposit accounts, letter of credit, commercial loans, securities processing, margin accounts, credit card systems, advertising and marketing systems for a publishing company, inventory and order entry processing. Clients include Citibank, Chemical, MHT, Morgan Stanley, Lehman Brothers, Smith Barney, American Express Bank, Paine Webber, Bank of New York, CMSS, Prudential Securities, PCH, Medco and ConEdison.

TECHNICAL SKILLS

Hardware: IBM 30XX, 43XX, 370/168, Sun, IBM PC.

Software: CICS/VS, LU6.2 COMMUNICATIONS, SDFII, ENDEAVOR, SQL, NATURAL, NATURAL2, QAHIPERSTATION, FILEAID, LIBRARIAN, OS/MVS XA, VM/CMS, DOS/VSE, MS/DOS, OS/VS1, OS/VS2, VRX, SMARTEST, INTERTEST, EDF, TSO/SPF, ISPF, JCL, SYNCSORT, VOLLIE, ROSCOE, EDGAR, ICCF, EXPEDITER, MQ SERIES, ALLTEL (SYSTEMATICS) BANKING PACKAGE, CHANGMAN, NDM, SOLARIS 8., CSF, EZTRIEVE.

Database: DB2, ORACLE, MS ACCESS, IDMS/DB DC, ADABAS/NATURAL, Model 204, IMS.

Access Methods: VSAM, ISAM, QSAM, BDAM, BPAM.

Languages: SQL, PL/SQL, ADS/O, DMLO, OLQ, NATURAL, NATURAL2, SAS, COBOL, COBOL II, Microfocus Cobol, PL/1, BAL, ASSEMBLER, FORTRAN, C, RPG, APL, C, JAVA, Shell, PERL.

EXPERIENCE

IBM-Express Scripts Franklin Lakes, NJ 5/13 to 12/16

Maintained the benefit and enrolment system for a pharmaceutical company (PBM).

Analyzed and fixed problems with loading historical client data in separate databases of two merged companies. Participated in design sessions with business analysts to create new business requirements and translate them into detail programming documentation for offshore developers using SDLC methodologies. Analyzed problems with missing claims and reloading them to vendors of a CDH (Consumer Driven Health) system. Worked on production support of the retail network management system (RNM). Used Cobol, CICS, DB2,Teradata, Oracle DB and Assembler.

ACS – XEROXTarrytown, NY 2/11 to 2/13

Maintained and upgraded an online and batch COBOL II/ADABAS EMS health billing and collection system for various municipalities throughout the USA. Worked with EDI transfer protocols X12, claims printing

on HCFA forms and with HIPAA regulations, for Medicare, Medicaid and insurance companies. Used Natural 4 for adhoc reports and access to the database, Xpediter and Intertest debug tools. Wrote design documents for converting the front-end to JAVA/Unix and DB2.

Used Share Point and Jira to track user requests and problems.

CTG Inc. – NYPD NY, NY 10/08 to 7/10

Analyzed and programmed various legacy modernization systems. Upgraded the systems to COBOL/LE with ADABAS/NATURAL 4, CICS and DB2 stored procedures. Converted applications from ADABAS to DB2. Also wrote user manual and testing documentation. Used IBM Debug tool and file manager.

The systems are DARP (Directed Accident Report Program), Converted the following applications from Pl/1 to JAVA, CACS (Court Appearance Control System) and OLBS (Online Booking System) and online complaint system. Maintained Assembler programs on an old system.

Keane Inc. – TIAA-CREF NY, NY 03/07 to 09/08

Maintained a differed annuity online and batch system with tax lot and cost basis reporting.

Written in ADABAS/NATURAL.

Responsible for corporate workflow project and Natural 4 upgrade.

TSR Consulting Con Edison New York NY 10/05 to 02/07

Converted various systems from PL/1 to COBOL with IMS, CICS and from RAMIS to COBOL/DB2.

The systems were: clients’ Name and Address. Portable electronic terminals for reading electric usage.

Tracking of transformer repairs. Financial systems, used CSF to print customers’ statements.

Publisher’s Clearing House Port Washington, NY 11/04 to 08/05

Converted a marketing system from SAS to COBOL/DB2. This improved the performance and execution of the system from 24 hours to 6 hours running time. It also allowed the user more flexibility accessing customer data for marketing purposes and to increase the company’s revenue by at least one million dollars a year.

Medco Health Montvale, NJ 1/04 to 10/04

Sr. Programmer/Analyst.

Developed a drug alert system to warn and avoid problems with prescriptions like early refill, adverse reaction to simultaneous prescriptions that may be contra indicated. The system uses COBOL II, DB2, CICS.

Citibank NY, NY 4/02 to 12/03

Incorporated an old system into the main bank’s system so that the old one could be decommissioned saving millions of dollars each year in maintaining both systems. Worked with CSF customer statement formatter and Systematics banking package.

The system is an online overdraft back office system to accommodate accounts with high balance limits. Used COBOL II/CICS, VSAM, ADABAS/NATURAL.

Smith Barney NY, NY 12/00 to 12/01

SYSTEM AND PROGRAMMER ANALYST stock options department.

Upgraded the domestic stock options system to help the company increase sales of managing employees’ stock options of international companies that trade their stock in foreign and domestic stock exchanges. Responsibilities included creation of the system’s infrastructure to maintain the country and multi currency tables, new international sub-menus and printing welcome letters for customers to give them access to their accounts via the internet.

Used COBOL II/CICS, VSAM, SAS, DB2 stored procedures, MQ series and NDM. Duties also included gathering information from the user and analyzing the system to design the new functionalities required to allow foreign companies to offer their employees stock options.

Morgan Stanley NY,NY 8/99 to 2/00

PROGRAMMER/ANALYST fixed income securities systems (TAPS).

Maintained the back office mortgage backed security application written in online/batch ADABAS/NATURAL. Maintained programs to send and receive data from the clearinghouse DTC. Wrote programs to transfer data between a mainframe and Unix machines using MQ Series.

Worked on enhancements of the human resources payroll system. Wrote programs to calculate company and individual employees' contributions to a 401K-pension plan. The system was written in ADABAS/NATURAL. Responsible for enhancements of the securities system.

EDUCATION

BS, Computer Science Technion Haifa, Israel.

12/02-4/03 Intensive course in Unix (Linux, Solaris) system administration and Oracle DBA.

In depth study and hands on experience working with Linux and Solaris operating system installation and system administration. Shell and Perl programming.

Installation of Oracle database, SQL and PL/SQL programming.

2007 Java course – Hofstra University.

Contact this candidate