System Project

IRINA SPEKTOR

** *** **** **** ********, NJ, ****6

732. 462. 2812 home

908. 208. 7407 cell

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

HARDWARE: IBM System 370, 390, 309X, 43XX, Z/0S, BM PC

SOFTWARE: COBOL II, CICS, DB2 (SQL, SPUFI, QMF, PLATINUM, BMC/IBM DB2

Utilities) DB2 Stored Procedures, WinSQL, Stored Procedures

Builder, OS MVS/JCL, SAS, CA7, OPCA, CA11, TSO/ISPF, VSAM,

INTERTEST, XPEDITER, IBM Debug Tool, FILE-AID, XML, Advanced

Function Printing (AFP), PANVALET, LIBRARIAN, ENDEVOR,

ChangeMan, Star Tools, SYNCSORT, FTP, NDM, OS/2, WINDOWS,

MQSERIES, MS OFFICE, MS Project, EXCEL, VISIO, WinRunner,

LoadRunner

EXPERIENCE: @ Bank of America/Merrill Lynch, New Jersey

June 09 - Present

Sr. Programmer/Consultant

. Participating in the Bank of America/Merrill Lynch conversion

for the Branch Office Security System (BOSS).

. Developing, testing and implementing new Jobs, Programs and

Stored Procedures utilizing COBOL,DB2/SQL, APIs, CICS, JCL

. Created Documentation of the system after reviewing/analyzing

the code

. Prepare Inventory of the programs

. Provide high level design documents of this system

Environment: COBOL II, CICS, BMS, DB2/SQL/SPUFI, VSAM,

JCL, DB2 Stored Procedures

UBS Financial Services, New Jersey

May 05 - April 09

Wealth Management

Sr. Programmer Analyst

. Rewrite of the Managed Account Billing system (BIL):

Participated on the coding and testing of some of the new

modules needed to support the new Managed Account Billing

system and the passing of performance data to the IS Toolset

Front End.

. Managed Account Billing (MAB). Participated on the analysis,

coding, testing and production implementations of the

following projects:

- Bill Other Account project: New functionality to allow the

charging of the managed account wrap fee to an alternate

account. It entailed changes to the front-end and existing

Bookkeeping process as well as providing (via MQ)

notification to the FA.

. Design, development, testing, implementations and support of

PACE System.

. Prepare Analysis and High Level Design for change requests

and Enhancements. Also Test plan Specification and conduct

through SDLC.

. Analyzed and created and enhanced Monthly GIM2 Performance

Portfolio Feeds which calculate/display Rate of Return,

Target Allocation, Current Allocation, Subclass Allocation as

well as Recommended Allocation

.

. Created new and enhance existing job schedules using OPCA.

. Asset Consulting and Evaluation System (PACE) combines UBS

ability to evaluate Client's investment objectives and risk

tolerance with professional investment advice and the

convenience and cost effectiveness of a broad array of mutual

fund investment portfolios, rebalancing and Security/Fund

Transfers, Options and Futures, Fixed Income.

. The project involved migration of all existing PACE

functionality, including profiling, account opening, trading

and client reporting.

. Improving of DB2 performance includes recreation of Indexes

and SQLs

. Wrote functional and program specifications, programming and

communications with clients.

. Worked on data modeling, created test plans, Testing,

Debugging and Implementation

. The reporting mechanism was developed to replace the Non-

Sales reports using IBM Stored Procedure Builder.

. Created several Client Letters utilizing Advanced Printing

Function (AFP).

. Prepared system documentation, specs and Job Flow

descriptions

. The system operated in both online and batch modes.

. Web-based test management tool Mercury Quality Center was

utilized to manage defects and issues

Environment: COBOL II, CICS, MQ Series, DB2/SQL, DB2 STORED

PROCEDURES, AFP, VSAM, XPEDITER, IBM Debug Tools, JCL,

CHANGEMAN, Star Tools, BMC/IBM DB2 Utilities

@ Pershing, Florham Park, NJ

Sept 04 - Apr 05

Senior Programmer/Consultant

. Participated in the re-design and development of the new

Architecture for the Rules Engine system which was created to

automate the order approval process.

. The rules address a variety of regulatory, compliance, and

business issues.

. Responsibilities include: Specs preparation, Data Mapping and

Research, Flow Charts, Performance tuning and troubleshooting

of the existing system, Coding, Testing, Debugging and

Implementation.

Environment: Cobol II, JCL, DB2, Triggers, CICS, VSAM, MQ Series

@ Morgan Stanley, New York NY

Jan 04 - Aug 04

Senior Programmer/Consultant

. Involved in the development of the Statement Linking project

for CPS (Customer Profile Systems) area.

. The responsibilities included Data analysis and design of

databases, Development and modification of Batch, DB2 Stored

Procedures and On-line modules as well as performance tuning.

. Interaction with other systems and departments to assure

proper implementation of changes. Implemented modification of

various edits throughout the system for de-linking groups of

accounts.

. Creation of wires and triggers going out with notification to

FA (Financial Advisor) of the changes, giving FA the ability

to maintain the links for Compulsory Alert System.

. Performed Margin requirements and money line calculations,

feed information to other systems, such as Customer Ledger,

General Ledger (M&D), Stock Record, Segregation and Cash

Management Accounts, etc. Utilize of all business

requirement

. Organize and monitor integration and regression system

testing. Support the new application and ensure the

successful operation of the existing applications.

Environment: Cobol II, JCL, DB2, Stored Procedures, CICS, VSAM,

MQSeries

ADP, New Jersey

Mar 02 - Nov 03

Senior System Engineer

. Created batch and on-line functions to facilitate security

maintenance and company code handling jobs for ADP 401(k)

Retirement System; coding, testing and debugging new and

existing programs (heavy DB2/CICS).

. Developed plans and coordinated several sub-projects (New

401K Lpar/region implementation, Full data base reload, User

Requirements Release). Performed System Administrator

functions.

. Participated in creation of Fixed Income High Net Worth

Report and Processing System.

. 24/7 production support of existing Recordkeeping Retirement

and 401(k) System. Heavy user interface.

. Responsible for testing the multiplatform Sponsor and

Participant Websites as part of a customer support team.

. Wrote test plans and test cases. Involved in the analysis and

trouble shooting of the problems to provide a preliminary

assessment for the development team.

. Performed Functional and Regression testing of applications

due to operations system upgrades and changes.

. Created reports utilizing SAS

Environment: COBOL II, CICS, BMS, DB2/SQL/SPUFI, VSAM, JCL, SAS,

Data Warehousing, OMNI/SUNGARD, Java, WinRunner, TeamTruck, Test

Director, Recovery

@ Bank of Tokyo-Mitsubishi

Apr 01 - Feb 02

Senior Analyst/Consultant

. Participated in development of BTM Advance Commercial Banking

System (ACBS). The process creates L/Cs and Standby extracts

files for AS/400.

. Responsible for analysis, testing and coding of various

COBOL/DB2 Extract programs, DB2 Store Procedures, Developed

COBOL/CICS programs. Conducted unit and system acceptance

testing, have very extensive user interface.

Environment: COBOL II, CICS, BMS, DB2/SQL/SPUFI, VSAM, JCL

Merrill Lynch, New Jersey

Feb 96 - Apr 01

Programmer/Analyst

. Engaged in support and enhancement of Retirement Statement

System that includes over 4000 401K and other retirement

plans using OMNI/SUNGARD formats.

. Developed and implemented on-line inquiry and data entry

functions, as part of Statement Control System, which enables

user to get and update necessary information.

. Designed user-friendly screens proposed and developed on-line

update facility as well as DB2 Store Procedures.

. Was extensively involved in the analysis, design,

development, testing and implementation of new format

Millennium Statements as well as modifications of the

existing Classic Statement System.

. Was responsible for transmission jobs that are used to pass

files from and to Mainframe environment.

. Participated in the development and maintenance of the CLIENT

BOOKKEEPING SYSTEM. Personally responsible for reformatting

of the STANDARD TRANSACTION processing which is used by the

General Ledger and on-line transaction that displays the

client information of Money Line and Security Position

Environment: COBOL II, CICS, BMS, DB2/SQL/SPUFI, VSAM, JCL, DB2

Store Procedures, IMS, IMS/DB

@ AT&T, New Jersey

Feb 95 - Feb 96

Consultant

. Participated in the system analysis, design, development and

testing phases of BUSINESS CARRIER SELECTION MANAGEMENT

SYSTEM conversion project for an AT&T. COBOL II, DB2/SQL,

and CICS were used for the system development.

@ Merrill Lynch, New Jersey

Feb 94 - Jan 95

Consultant

. Participated in the extensive maintenance of the

INSTITUTIONAL STANDING INSTRUCTION SYSTEM for MERRILL LYNCH.

. Developed on-line update facility designed user-friendly

screens. Implemented management requests for maintenance and

improvements of batch and on-line programs. All work was

done in CICS, COBOL 2, VSAM using TSO/ISPF and BMS.

@ AIG, New Jersey

1992 - 1994

Consultant

. Took part in the development and maintenance of the ATTORNEY

ACTIVITY MAINTENANCE SYSTEM for AIG. Solely responsible for

on-line Retrieval programs that manage and report CICS

transaction

. activity. Created on-line and batch programs in the LAN

environment using Microfocus COBOL 2, XDB, CICS.

EDUCATION: CITY COLLEGE OF CIVIL ENGINEERING, MOSCOW

BS Degree in Accounting

Contact this candidate