SUMMARY:

More than 20 years experience in Mainframe technologies with deep technical proficiency in COBOL/CICS/DB2/VSAM. Senior hands - on developer. Excellent ability to work independently with business analysts, development managers, architects, infrastructure, and other developers to analyze business requirements, propose solutions, and implement those solutions. Strong background with different aspects of Financial Markets. Multi-year experience at large investment banks including Goldman Sachs, Bear Stearns, Deutsche Bank etc.

HARDWARE: IBM3090, IBM PC

SOFTWARE:

• COBOL, OS/JCL, DB2, IMS DB, VSAM, CICS, CICS Web Services, REXX,
• XPEDITER,INTERTEST, ENDEVOR, CHANGEMAN, MICROFOCUS COBOL,
• PLATINUM, QMF, SPUFI, FileAid, MQ Series, FTP, NDM, Comparex, C language,
• UNIX, Java, HTML/XML, Oracle 10i, MS Office.

EXPERIENCE:

Confidential

Senior Programmer/Analyst/Consultant

• Day to day responsibilities: full life cycle development of large batch/online systems with DB2/IMS
• data warehousing within Global Capital Markets/Collector dept. Cash/Fixed Income Trade Management . Doing post-project production support of Collector software.

Main projects:

• Key developer for Intraday Sweep Project designed to dynamically invest prior Fed Closing. Core process interacts with Fund Release and MINT settlement service thru MQ series, making requests, doing calculation, DB2 logging and producing daily/monthly statements. Developed MQ requests modules, main calculation module, module making Statement Master File and Statement Program.
• Developed Collector TBA/ZBA Earnings Participation Full Statement batch cycle: number of modules gathering information about account relationships and money transfers in IMS and DB2 databases, creating interim master file that is used by statement module to create daily/monthly statement reflecting day-to-day money flow account information.
• Developed Liquidity Investment History project designed to provide series of FDIC reports complying with new FDIC rules. Provides daily investment participating amounts for those accounts participating in various Collector overnight investment vehicles. Created number of DB2 tables that contain Investment history and are updated every business day after the end-of-day investments are produced. Based on table information created a dozen of reports that provide information on day/month/quarter investment activity, various statistics and diagrams. All these documents are posted to the OnDemand internal Web.
• Developed on-line Internal Accounts System and incorporated it in existing Account System portal. System allows to monitor and update internal information about client account, easily to spot account's category, business area/business owner, internal business address etc. within the entire Collector department. Created DB2 sub data base incorporated into the Global Account data base. Batch part produces series of reports about system activities.
• Developed Global Log project designed to log all account's property changes are being done on-line within Collector. Developed pattern codes installed into every on-line module responsible for changes. This pattern updates Global Log DB2 table every time change is made. Overnight batch produces reports specialized for every Collector branch. Reports are posted to Intra-Web.
• Systems were developed utilizing COBOLII, DB2, static-dynamic SQL, IMS, CICS, CICS Web Services, MQ Series, XML, Java 2.

Confidential

Senior Programmer/Analyst/Consultant

Responsibilities:

• Developed Correct Net System. The system allows a user to request set of Brokerage Reports and post it to Requests submitted from the Web Site or from CICS panels dynamically form parameters and call DB2 stored procedures that gather information from the core. The information then is transferred back to the Web under dynamically created specific names. Reports are: Unsettled Trades, Realized Gain/Loss, Accrued Income, Cash Projection.
• Enhancing, maintaining and supporting Asset Management Portfolio System.
• full life cycle development of large systems with DB2 data warehousing.
• Developed FITS system, which allows a user to post or update Products directly from Corporate Web Site. A user submits populated spreadsheet, which calls CICS module that reformats the request and thru stored procedures posts it to Core Database, sending back a confirmation.
• Developed Cayman batch cycle, witch processes daily activity done by Cayman User Bank into set of files like Positions, Transactions, Products, Tax Lots, Forwards etc. with subsequent transmission to Unix boxes for User Client reporting. The cycle has 5 stages:
• 1st stage: CICS modules build Cayman Group account from Web based Sub-accounts posted by Portfolio Administrators 2nd stage: outbound messaging service where stored procedures gather information from core Data Base and thru interim batch modules populate MQ Series 3rd stage: batch modules input MQ series and using business rules compose batch files and compress them 4th stage: batch modules thru FTP transfer files to Unix boxes 5th stage: CICS modules gather dynamics about 2nd stage of the process allowing support staff to monitor processing of the core.

Confidential

Programmer/Analyst

Developing and maintaining CAMS Customer Automation Messaging Service . Backend: COBOL and C written Mainframe DB2 stored procedures and C functions. Front-end: Mainframe CICS drivers or AS400 or Internet Java-written drivers. Developed 17 COBOL and C stored procedures, dozen of triggers, C-functions, Java and CICS drivers, created specifications for developers of AS400 and Internet-Java drivers. Performed migration of stored procedures from DB2 version 5 to version 6 and from SPAS to WLM environment.Developed Configuration Parameter Distribution System that allows user to distribute and update service parameters for clients' mailboxes event log, statistics, mail threshold and etc. enabling disabling in Single and Mass distribution modes. The System contains CICS screens to directly update DB2 tables for Single distribution and VSAM file for Mass distribution data to update DB2 tables by night batch. Outdated records from VSAM file are put in History VSAM file.

Systems were developed utilizing COBOLII and C languages on Mainframe environment, DB2 version 6, static-dynamic SQL, CICS, MQ Series, Java 2.

Confidential

Senior Programmer/Analyst/Consultant

Confidential, which was a web portal for the entire company. The System consisted of Internet-Java interface on the front end with mainframe DB2 on the back end. Data base information for the front end was delivered by DB2 stored procedures. Created stored procedures: Holdings summary by account, Holdings summary by security, Holdings details by account, Holdings location and dozen another procedures. Procedures functionality included processes: Common day, Intra Day real time, Reclassification user parameter renaming . Procedures were written using static-dynamic SQL and temporary global tables. Neon Shadow software was utilized to test stored procedures.

Performed full production support for the Portfolio System.

Confidential

• full scale testing.
• Field expansion project: conversion of old P2 TIF files into new INTACT ADP format with
• Development and maintenance of interface modules for STP Real Time transaction processing, primarily for Fixed Income systems .
• Key developer for the following projects:
• Real Time / batch reconciliation system: converted data collection files into standard Bear Stearns record layout, developed conversion routines to convert TREP into INTACT for most of the Fixed Income systems streamlined main batch modules so they could be broken apart and used in Batch and CICS environment.
• Alone converted all Fixed Income systems to use decimal instead of fractional price.

Confidential Programmer/Analyst/Consultant

• Developed the 'JOB REQUEST FACILITY' subsystem, which provides automatic submission of batch jobs from CICS region. Main functions included: job scheduling, security access, and history log for submitted jobs.
• Developed a 'REPORT DISTRIBUTION FACILITY', which enables Customer Service Department to directly control report distribution instructions for all of the WAGNER-STOTT's customers. This system allows the users to define, update and to review print destinations, report definitions and to assign a number to a particular report. Then the instructions concerning distribution of reports were used by Customer Service Department to generate individual copies of reports.
• Developed the UNIVERSAL HELP subsystem for the automation project. The system allows the display of pop-up help scrollable information on user's request when the PF1 key is pressed. The function is cursor sensible identifying a specific field in question on the screen.
• Conversion of WAGNER-STOTT CLEARING SYSTEM from DOS/VSE to OS/MVS environment Enhanced old code and designed additional functions such as STARTUP PROCEDURE for the CASC CUSTOMER APPLICATION SYSTEM CONTROL and OCS ONLINE COMPARISON SYSTEM END OF DAY.