BORIS AVERBUKH

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

Brooklyn, NY **229

Cell: 917-***-**** Email: adak6f@r.postjobfree.com

SUMMARY:

Full life cycle application development (SDLC.)

Development and support of applications for utilities, engineering, Human Resources and construction.

Development and support of applications using Oracle and PL/SQL.

HARDWARE/SOFTWARE:

Programming Languages: COBOL, PLI, Assembler, REXX, Clist, Pl/SQL, Smalltalk, Visual Basic, VBA, JAVA, Coldfusion.

IBM Mainframe: IMS, DB2, CICS, XPEDITOR, MARK IV.

SUN Workstation: UNIX, Sybase.

Windows: Oracle, MS Access.

Multi-platform: Gemstone, MqSeries, FTP.

PROFESSIONAL EXPERIENCE:

NEW YORK CITY DEPARTMENT OF FINANCE, New York, NY

2/11/2019 –6/30/2019

Consultant

Creating Oracle stored procedures for new reports.

Using common table expressions instead of PL/SQL when necessary.

Using Oracle utilities(SQLplus, SQLloader, dbExport), VBScript, and MS Access Excel macros for user-friendly output for various tasks (e.g. file comparison)

WIPRO/IBM/ PRO UNLIMITED for National Grid, Brooklyn, NY

1992 – 2018

Senior Software Engineer

Lead support role for engineering applications – Leak Management System, Paving, Permits, Services (pipe) Information System, Contractor Charges, Geographic Information System.

Created interfaces between legacy applications and SAP.

Improved the interface between Customer and Services information systems by updating all the online modules written in Assembler and BMS.

Maximized the potential of the IMS database by converting the file maintenance modules to use bits in Assembler, which allowed for storage of dates spanning from 19th to 21st centuries.

Automated start up and initialization of the test CICS regions using QWS3270 Scripting language.

Improved performance of IMS database street names query from 8 hours to 10 minutes by automating the procedure for submitting the query using REXX.

Developed and maintained applications in IMS, CICS, PLI, COBOL, Assembler, and MARKIV in MVS Z/OS IBM environment.

Reduced problem fixing time by using XPEDITOR to debug both online and batch Mainframe application modules.

Maintained TCP/IP interfaces (including MqSeries and FTP) between mainframe, Windows, and UNIX servers.

Supported Geographic Information System - procedures, modules, reports, menus, database tables (Arc/Info, Sybase.)

Administered UNIX server and client workstations in five locations - installed and upgraded Solaris operating system, designed and implemented automatic login procedures to the application, trained clients and promptly reacted to their demands.

Administered Sybase database - created and implemented backup and recovery procedures, improved database performance.

Initiated and completed a 5 version upgrade of Solaris operating system and Sybase database to preserve data integrity during Y2K conversion.

Created Crew Scheduling application using Pl/SQL and Coldfusion. Designed the database and wrote stored procedures and UNIX scripts to run them.

Enhanced a single user PC DOS application to a multi user format to meet the client’s needs.

Maintained applications on Smalltalk platform using Gemstone database – made numerous enhancements including automated data input from spreadsheets, improvement of data integrity, and creation of numerous reports for clients.

Enhanced and rolled over a VBA Damages Tracking system to three geographic regions exceeding clients’ expectations.

Created and supported Windows applications using VBA, JAVA, Access, and Oracle.

Converted Palm Pilot application from Access to Oracle database. Learned and implemented C interface in 3 days to meet the rollover deadline.

Implemented Tesseract HR (Compensation and Benefits) Package System including the design, code and testing of Tesseract modules, screens and tables using DB2, PLI, Assembler, REXX, Clist, MARKIV.

Administered DB2 database. Created a tool for data transfer between DB2 databases using Clist.

Simultaneously worked on several platforms and supported multiple applications.

Crossed-trained programmers to support applications using new languages, databases and platforms.

On call 24 hours a day.

Moscow Software Development Company, Moscow, Russia

Project Manager 1985 – 1992

Responsible for design, development, and installation of proprietary software application for mounting oil holders on PC platform.

Developed broad concept and main algorithms for the system.

Designed, developed, and maintained the graphics sub-system for the oil plant pipe network: menu structures, database of notation conventions, and installation service.

EDUCATION:

Moscow Electronics College, Moscow, Russia

M.S. in Computer Science/Mathematics

Railway Transportation Institute, Moscow, Russia

B.S. in Electronic Engineering

Contact this candidate