Customer Service Development

MARINA AVERBUKH

732-***-**** *** Shoreland Cir.

**************@*******.*** Laurence Harbor,

NJ 08879

____________________________________________________________________________

_____

SUMMARY: Over fifteen years of experience as a programmer/analyst in

diversified financial and industrial applications (brokerage,

banking, insurance, manufacturing).

Hands-on full project life cycle experience. IBM certified DB2

UDB V5 Database Developer.

HARDWARE: IBM 370, 4341, PC/XT

SOFTWARE: COBOL, COBOL II, DB2/SQL, PLATINUM, CICS, MICROFOCUS WORKBENCH,

TSO, ISPF,

VSAM, JCL and UTILITIES, TSO/ISPF, INTERTEST, TGADP, PANVALET,

LIBRARIAN, QMF,

IBM MQ SERIES, CHANGEMAN, VISIO, XPEDITOR, ERwin; File-Aid for

DB2, IMS/DLI.,SPUFI.

DATABASES: DB2/MVS, DB2 UDB V5, XDB, SYBASE, ORACLE

EXPERIENCE:

Senior Programmer/Analyst, Consultant

05/2006 - For United Parcel Service, Paramus, NJ

12/2008 Participated in the development, testing and

maintenance of diversified projects for CAMS and OCAS teams.

Projects stand for:

Objects' Distribution - provide ability to distribute an object

to a single vendor.

The goal of this enhancement - elimination of redundant entering

of data for an object being distributed to multiple or wrong

vendors (for CAMS);

Visibility Enhancements - seeks to improve customer

satisfaction, increase customer usage and

save internal processing cost (for QVN).

Responsibilities included:

. Development and testing objects registration process;

. Development and testing of mailbox deletion process due to

inactivity;

. Development and testing of customer data reports;

. Development and testing of email notification process to

support new exception notifications;

. Development and testing of recalculation RDD for shipments

to support new requirements;

. Create test-cases for Unit, Integration and System test;

. Participation in the integration, QA and UAT testing;

. Maintenance of Quantum View Notification system.

(DB2, CICS, IBM MQ SERIES, COBOLII, VSAM, JCL)

06/2004 - For SONY, Park Ridge, NJ

04/2006 Participated in development, testing and maintenance of

DMPLUS, SAMS integration

development, SOAR projects

Projects stands for Supply chain, Order management and Account

Receivable. System helps

address business objectives of reducing inventory, simplifying

sales and customer service

processes; enable to respond quickly to changing supply chains

and distribution models.

Responsibility included:

. Maintenance of Shipping Database

. Development of cross-reference process for the Product Code

conversion

. Cross-system testing of Inventory and Shipping transactions

. Maintenance of DMPLUS shipping parcel transactions

. Correction of Receipt processing

(COBOLII, DB2, CICS, VSAM, JCL)

05/2001- For ADT / TYCO, Parsippany,NJ

02/2003 Participated in the CARMS E2 System conversion

project.

The new system's performance was improved and cost was reduced

by using

IOSYS access method to database and converting IMS/VSAM data to

DB2.

Redesigned all modules of Credit and Account Receivable

Management System,

which provides:

. Accounts receivable processing;

. Credit and Collection processing;

. Report's activity;

. Real time updates

by using IOSYS/FAMs/SQL/DB2 statements to process data.

IBM MQ SERIES was utilized for communications between front end

and back end.

Participated in the integration, QA and UAT testing, created

Documentations and forms for Mantissa distribution reports.

Provided production support.

(COBOLII, DB2, CICS, VSAM, JCL,IMS, IOSYS, MQ SERIES)

07/1999- For Guardian Insurance Co., New York, NY

04/2001 Involved in the New Business Application (NBAP) project

development.

The new system is to reduce stuff, time and cost by automation

Life

Insurance policies issue and maintenance. NBAP consists of

front-end based on Visual Age Small Talk GUI and DB2 as a back-

end. Communications performed via CYBERLIFE software.

Responsible for the development of following sub-systems:

. Automatic Underwriter Assignment;

. Automatic Policy Number Generation;

. New Supplementary Pending Database update transactions

processing;

. Special Client Search function.

Also provided following services:

. Database design;

. Message formatting for front-end/back-end Data Exchange;

. Testing, documenting issues and defects in Problem Report

Log;

. Production support.

(COBOLII, DB2, CICS, CHANGEMAN, XPEDITOR, Erwin, File-Aid for

DB2)

11/1997- For Depository Trust Company, New York, NY

03/1999 Was involved in following projects:

. Development of Branch Deposit Security System (BDS) to

increase the

process efficiency and reduce the cost. Responsible for

BDS Batching

system, which will be used for wanding of deposits for

credit;

. Security Number Translation Database development project

. Maintenance and testing of diversified brokerage systems

including smooth transition to 21st century dates

processing.

(COBOL II, DB2/SQL, CICS, CHANGEMAN, INTERTEST, JCL,SYBASE,

IBM's MQ SERIES)

03/1995- For Prudential Insurance Co., Roseland, NJ

06/1997 Was involved in Financial Management Cycle (FMC) Re-Engineering

to

improve the system's performance by converting the data

management

from QSAM/VSAM to DB2. Was responsible for:

. Non-Traditional products' Reserves calculating system;

. Financial Examination Monitoring System (FEMS);

. Mortality Lapse System (MLS) to calculate mortality and

lapse exposure;

. Testing diversified insurance systems.

(COBOL II, DB2/SQL, PLATINUM,JCL, TSO/ISPF, CMS)

11/1993- For Merrill Lynch, Somerset, NJ

02/1995 Development and maintenance of (401)K Plan system.

Responsible for development of on-line PIN maintenance

subsystem

for the Chrysler Savings Plan. Provided system's production

support.

(COBOL II, CICS, VSAM, DB2/SQL, JCL, INTERTEST, PANVALET,TGADP)

10/1990 - For Movomatic Manufacturing, Inc. Mahopac, NY

10/1993 Inventory Control System for Order processing and Stock

Information

update. Participated in the development and implementation of

the Check

Books Reorder System. Participated in development of the

Laboratory

Activity Maintenance System and the Account Review System.

( COBOL II, CICS, DB2/XDB, MICROFOCUS WORKBENCH)

1987-1989 MACHINE TOOLS RESEARCH INSTITUTE.

Participated in the development of Local Payroll System.

Developed multi-level inventory system for parts and materials.

(COBOL, CICS, VSAM, JCL, UTILITIES)

Developed software packages for industrial robots and PLC's.

(C, UNIX, Problem-Oriented languages, dBASE III PLUS)

EDUCATION:

1999 Certification in IBM DB2 UDB v.5 development.

1999 Sybase/Oracle The Chubb Institute, North Brunswick,NJ

1990 DB2/SQL/QMF The School of Advanced Software Analysis, New

York, NY

1981 MS in Electrical Engineering and Computer Science Odessa

Polytechnic University, Ukraine

REFERENCE: Furnished upon request.

Contact this candidate