SUMMARY:

• Senior Programmer/ Systems Analyst, Architect with over fifteen years of experience in data processing and with excellent analytical skills. The expertise is within the IBM mainframe arena utilizing Cobol, CICS, DB2, MQ Series, JCL, VSAM, XML, and utilities. The industry experience includes Heavy Brokerage (Asset Management, SWIFT Messaging, Global Custody,
• Clearing, Wealth Management/Portfolio Management, Global Securities, Trading, Foreign Exchange, Securities Transfer, Fixed Income, Mortgages, Retail Brokerage, Tax Withholding, 1099, 1042, Mutual Funds, Statements, Margins, Dividends, Corporate
• Actions, Reorg, Check Processing, Investor Communication Services, Capital Markets, Post - Sale Fulfillment, Tax Lots, TEFRA,
• Volatility, etc.), Banking (Check Processing, Same Day Reconcilement, Retail Banking, Account Processing, DDA, MMDA,
• General Ledger, Billing, etc.), and Insurance (Health Insurance, Claims Processing, Third Party Liability, etc).

TECHNICAL SKILLS:

SOFTWARE: COBOL 390, COBOL ENTERPRISE, COBOL LE, CICS/VS, OS/MVS/JCL, UTILITIES, TSO/ISPF, VSAM, MQ SERIES, EDIBMS, INTERTEST, XPEDITER, DB2, SQL, SPUFI, CASE TOOLS (APS), QMF, SWIFT, FTP, CHANGEMAN, STORED PROCEDURES, PROEDIT, VISTA, FORTRAN, ASSEMBLER, IDMS, EASYTRIEVE PLUS, NDM, LU6.2, ENDEAVORMOBIUS, BMC, OPC, PLATINUM, QUIKJOB, SAR, PDX, TRACE MASTER, GTB, EXCEL, XML, DATA STUDIO

HARDWARE: IBM MAINFRAME

METHODOLOGY: WATERFALL, AGILE, SCRUM

PROFESSIONAL EXPERIENCE:

Confidential, Edgewood, NY

Senior Programmer/Analyst, Architect

Responsibilities:

• For Statement Development Group was responsible for analysis, design, coding, creating documentation, unit and system testing, user interface, implementation, maintenance, production support for multiple batch/on-line systems for a number of Broadridge clients: Cetera Financial Group, International Group of Capital Market Associations (ICMA), Piper Jaffrey, LPL Financial, and AXA Advisors. The systems utilized COBOL ENTERPRISE, JCL, VSAM files, CICS, DB2 tables, DB2 External Stored Procedures, MQ Series, DB2 utilities, XML, OPC, SAR, used multi-platform application systems, and GUI screens. The named Systems are described below:
• For Money Market Income/ Income Summary Statement System introduced changes for calculation of Money Market and Taxable Interest for household and non-household accounts. A number of programs and copybooks were changed. Testing required all phases of statement creation. The system used batch jobs, and online transactions.
• Was responsible for implementation of Statement Message enhancement initiative. That enhancement allowed printing statements messages in bold and/or underlined font, printing longer messages and multiple messages. The changes were made to a lot of programs, copybooks, procs, and jobs. The created files were further used in processing by EXTREAM software. The testing required close collaboration with EXTREAM group. The system used batch jobs, online transactions, DB2 External Stored Procedures, and MQ Series.
• Was responsible for implementing the initiative of introducing processing of data of a new client ICMA into Broadridge statements processing. That included changing existing programs and creating new programs, also creating many necessary new jobs, procs, and control cards for all changes.
• For Cost Basis Statement System introduced changes for proper calculation and display on statements Market Value, Gain or Loss, Purchase and Adjusted Cost, Purchase and Adjusted Price, Buy/Sell Quantity, etc. The system used batch jobs and online transactions..
• For Gain/Loss Summary and Detail Statements Systems was responsible for modernization changes. That included changes to existing programs, procs, jobs, creating new programs. That modernization allowed utilization of EXTREAM software to manage both electronic and print deliverables to customers and clients.

Confidential, Jersey City, NJ

Senior Programmer/Analyst, Architect

Responsibilities:

• For Tax Lot Group was responsible for analysis, design, coding, creating documentation, system/unit testing, user interface, implementation, maintenance, production support for a new batch/online Complex Bonds Cost Basis Calculation System for the clients Edward Jones, APEX, and RB Dain. That system exchange data with Wall Street Concepts - a company that performs complex bonds cost basis calculation. Also the system integrates data received from WSC to Broadridge Tax Lot Engine System.
• Was responsible for the changes of multitudes of batch/online existing Tax Lot Systems in order to in corporate processing of Complex Bonds data related to WSC processing.
• Those systems utilized COBOL ENTERPRISE, DB2 tables, JCL, VSAM files, CICS, MQ Series, DB2 Stored Procedures, DB2 utilities, NDM, XML, OPC, SAR, and used multi-platform application systems, and GUI screens.

Confidential, Florham Park, New Jersey

Senior Programmer/Analyst, Architect

Responsibilities:

• For Global Margin Group was responsible for analysis, design, architecture, coding, drafting of specifications, STD’s, TDD’s, creating other documentation, system/unit testing, user interface, implementation, maintenance, production support for a number of systems that introduced processing of Goldman Sachs Margin data into BNYM/Pershing processing. Those systems utilized COBOL Enterprise, DB2 tables, VSAM files, CICS, MQ Series, DB2 Stored Procedures, DB2 Utilities, XML, and SAR. Used Trace Master debugger, GTB screen painter for testing, and EXCEL spreadsheets with formulas for test results verification. The named Systems are described below:
• Applying Volatility-based Margin Requirement batch/online System that accumulates prices for securities from Pershing Security Master data, Goldman Sachs Price Server and uses Corporate Actions data to adjust prices for stock splits. Price Volatility is being calculated daily. Uniformly weighted and Exponentially weighted volatilities are being calculated for every CUSIP using recursive methods based on current price and named above volatilities for previous business day. Based on Goldman Sachs House Margin Rules volatility grid Margin loan percentage is calculated for long and short positions and for derivatives (calls and puts). The process uses all rules overrides defined for any position to assign correct rule margin calculation.
• Auto Stock Release System and S&P Rating Override System are on-line systems that allow overriding of house margin eligibility criteria for equities and subsequent requirements on derivatives with equity underlier. These systems allow a user to change Margin rules manually for any account/security combination.

Confidential, Jersey City, New Jersey

Senior Programmer/Analyst

Responsibilities:

• For Tax Lot Group was responsible for analysis, design, coding, creating documentation, system/unit testing, user interface, implementation, maintenance, production support for a number of following new and existing Tax Lot Systems for multiple clients (Edward Jones, APEX, RB Dain, Ridge, etc.). Those systems utilized COBOL ENTERPRISE, DB2 tables, JCL, VSAM files, CICS, MQ Series, DB2 Stored Procedures, and used multi-platform application systems, GUI screens, DB2 utilities, NDM, XML, OPC, SAR:
• For Wash Sale System introduced changes in recalculation of Gain/Loss and Cost Basis for partial SELL for long and short accounts. The Wash Sale processing defers the losses occurred onto eligible BUY lots to adjust the cost basis and gain/loss. The system used batch jobs, online transactions, and DB2 Stored Procedures.
• Was responsible for changes to batch/online Gain/Loss Calculation System. The System performs computation of capital gain and loss that occurs due to security dealing across a variety of portfolio positions (Wealth Management information was used). It primarily computes Realized and Unrealized gain/loss at each account level. The System utilizes DB2 Stored Procedures and MQ Series.
• Was responsible for new Edward Jones Fixed Income Reporting System that retrieves from data base information (Cost Basis, Adjusted cost on a bond due to Accretion / Amortization, trade date, close date, balances, etc.) of processed Opened and Closed tax lots. System also creates Delta files that contain information for tax lots that have changed from posting of daily transactions or via user input. The System is being executed daily and annually and utilizes batch jobs, NDM, and MQ Series.

Confidential, Orangeburg, NY

Senior Programmer/Analyst

Responsibilities:

• For Business Continuity/Production Support Group was responsible for Reconciliation Project that had to solve problem of unmatched rows of 3 frequently used related DB2 tables (Customer table, Products table, and Features table). DB2 referential integrity was not established. The corrupted data - unmatched rows of those tables caused ABEND’s on daily basis.
• For solution of this problem more than 300 programs (a lot of them were performing billing) and associated with them jobs were analyzed. Programs and jobs that caused data corruption were found and fixed. A Conversion Reconciliation System for fixing corrupted data was created. That System included jobs and batch programs. The System ether removed unmatched data or created matching data depending on situation. That System utilized COBOL, DB2 tables, and JCL.
• Analyzed systems utilized COBOL, DB2 tables, JCL, VSAM files, CICS, MQ Series, DB2 Stored Procedures, CHANGEMAN, used multiplatform application systems. DB2 utilities (LOAD, UNLOAD, EXPLAIN, REPAIR, etc.) were heavily used for analysis.

Confidential, Edgewood, NY

Senior Programmer/Analyst

Responsibilities:

• For Post-Sale Systems Group was responsible for analysis, design, coding, creating documentation, system/unit testing, user interface, implementation, maintenance, production support for the following new and existing subsystems of the Post-Sale Systems that utilized COBOL ENTERPRISE, QUIKJOB, DB2 tables, JCL, VSAM files, CICS, MQ Series, DB2 Stored Procedures, and used multi-platform application systems, DB2 utilities, NDM, XML, OPC:
• Created a new batch/on-line Post-Sale Postage Billing System that receives and/or calculates meter, full, billing, and discount billing rates for the local and foreign customers. That System updates the Postage Rate Table and uses information of this table for calculation of billing amounts for the mailings of prospectuses and other trade related information on behalf of financial intermediaries to their investors. The System also produces annual, semi-annual, and other reporting information.
• For the TD Ameritrade Client System introduced Auto Close process that matches CUSIP /Account file to the client incoming file and closes the trades, so the prospectuses would not be sent to the account owners with closed trades.

Confidential, Jersey City, New Jersey

Senior Programmer/Analyst

Responsibilities:

• For CitiChecking and Same Day Reconcilement Group worked on the project of Migration/Conversion to ORACLE/Flexcube of accounts and multiple Citichecking Systems and was responsible for full Systems development lifecycle - business and technical analysis, design, architecture, coding, creating documentation (Business Requirements Documents, Functional Requirements Documents, Technical design documents that include specs, pseudo codes, flowcharts), for unit/system/QA testing, user interface, implementation, maintenance, production support of the following Systems that utilized COBOL 390/ COBOL ENTERPRISE, DB2 tables, JCL, VSAM files, CICS, MQ Series, DB2 Stored Procedures, used multi-platform application systems, DB2 utilities, NDM, XML, OPC, CHANGEMAN:
• New Citichecking Balances/Check Accumulators end-of-day and intra-day update System that handles multiple balances (Ledger, Available, Issuance, Paid Without Issuance, Outstanding, Stop Item, Credit Amount, Debit, Matched Paid, Noncheck Credit/Debit, outstanding Adjustment, Interest, etc.). These balances are received from Flexcube using NDM, MQ Series, and Stored Procedures. This information is processed using batch jobs, on-line transactions, and DB2 stored procedures. System validated information and updated Citichecking Balance table.
• New Account Emergency Recovery System restores 18 different VSAM files and 10 DB2 tables if it is found that the integrity of Account information that resides on these files and tables was violated. The input information for this system is being received from Flexcube. It is being validated, splat, and manually adjusted. The system loads that information to various VSAM files (Master Account Index files, Plan files, Subaccounts files, etc.) and DB2 tables (Common Account table, Transactions Table, Reports Table, etc.) that belong to Delaware, New YorkFinancial, and Same Day Reconcilement regions. The Processing begins in batch but may turn on CICS processing EXCI utility and then control returns to batch. The System heavily utilizes DB2 utilities (LOAD, UNLOAD, RUNSTATS, REPAIR, etc.) and jobs that execute dynamic SQL.
• Was responsible for modifications to Citichecking Billing System. These changes enable the system to process accounts migrated to Flexcube as well as Citichecking accounts. That system generates billing charges for all Citichecking billing products (overdraft fees, transfer related charges, transactions, payments, wire charges, etc.).

Confidential, Edgewood, NY

Senior Programmer/Analyst

Responsibilities:

• For Investor Communication Services Group was responsible for analysis, design, coding, creating documentation (specs, pseudo codes, flowcharts, etc.), systems/unit testing, user interface, implementation, maintenance, production support of Class Action Lawsuit System (this is about violation of Capital Market Financial Compliance rules) for Financial Client ( Confidential ). This batch/on-line system determines eligible CUSIP and Class Action time frames from companies Risk Metrics Systems and Class Administrator, receives detailed trading information and client account information for relevant accounts from Confidential, calculates the beginning and ending positions within the
• Class Action timeframe, handles errors, sends and receives information electronically to and from Confidential and Risk Metrics Systems. Worked on database design, heavily used DB2 utilities during testing. Queries of the programs used in stored procedures that performed on-line display and update of database of investors’ financial information.

Confidential, Jersey City, New Jersey

Senior Programmer/System Analyst

Responsibilities:

• For TEFRA/Year-End group responsible for analysis, design, coding, systems/unit testing, user interface, implementation, maintenance, production support of the following systems that utilized COBOL 390, CICS, VSAM files, JCL, DB2 tables, MQ Series, Db2 Stored Procedures, used multi-platform application systems, DB2 utilities, FTP, MOBIUS:
• Batch/on-line Form 1099 Tax Information Statement System that consolidates for the same account Dividend and Distribution, Interest Income, and Miscellaneous Income information to one form. This design required a sophisticated approach to DB2 tables (there were utilized nested table expressions with full outer joins, various scalar functions, also there were used scalar functions to create unique keys for result table, performance tuning was made, etc.).
• Form 1042S Information Statement Systems. These batch/on-line Systems used new form that contained new additional information fields and produced various Statement forms depending on the type of the customer. The System required a sophisticated approach to DB2 tables.
• Batch Systems: 1099 Statements, Reporting, and Accounting Systems, 1042S Statements, Reporting, and Accounting Systems, Income History and NRA Systems, Broker Daily Loading System, Broker Canceling System, Journal History System, etc.

Confidential, Jersey City, New Jersey

Senior Programmer/System Analyst

Responsibilities:

• Was responsible for analysis, design, coding, systems/unit testing, user interface, implementation, maintenance, production support of the following systems that utilized COBOL 390, CICS, VSAM files, JCL, DB2 tables, MQ Series, Db2 Stored Procedures, used multi-platform application systems, DB2 utilities, NDM, PDX:
• For Year-End group - on-line Statements and Tax System. That System allows browsing statements information, 1099 tax information on consolidated 1099 for dividends & distributions income, interest income, and miscellaneous income.
• For Year-End group - Cash management / Check Processing System. That batch/on-line System accumulates and manages information about cash and checks flow for further use in Statements System.
• For Corporate Action, Reorg, Dividends, and Statements group - batch/on-line Voluntary Offers System. That System accumulates through batch, using MQ Series, information, and then allows browsing, adding, updating, and deleting Corporate Action Announcements of voluntary offers. Those offers can be viewed by their Reorg Type, cusip, book or process date, by expiration date for Back Office, or by Cutoff Date for Front Office (Branch Access), or by any combination of named above parameters.
• For Corporate Action, Reorg, Dividends, and Statements group - batch/on-line Auto Wire Dividend System. That System analyses account dividend database and files. When account dividend activity is detected, the appropriate Name and Address information is being selected, and dividend wire notifications are being created.
• For Corporate Action, Reorg, Dividends, and Statements group - Reorg/Workflow Back Office Position On-line System. That background System is triggered by MQ messages, retrieves booking instruction information from those messages, and performs booking of positions globally for all accounts in case of Mandatory Corporate Actions or selectively for individual accounts for Optional Corporate Actions. Booking can be complete or partial (for Optional Corporate Actions) depending on the received instructions. The System reads/updates DB2 tables and VSAM files and sends back a report through MQ message about results of booking.

Confidential, Warren, New Jersey

Senior Programmer/ System Analyst

Responsibilities:

• For Purchase and Sales Group of Information Technology Department responsible for analysis, design, coding, systems/unit testing, user interface, implementation, maintenance, production support of batch/on-line Security Master Account & Pricing System, for conversion of this System from IDMS to DB2.
• The System handles all securities with their attributes (CUSIP number, ISIN, etc.) that Citi Group works with. The System takes in feed from various vendors to get daily pricing, dividend, and interest information, it gets closing market prices with their last trading date from various vendors (IDSI, Bloomberg, Euroclear, etc.), creates firm price from the last trade price of the Citi Group for the same date, updates files and data base with that information, creates reporting information.
• Systems utilized COBOL 390, CICS, VSAM files, JCL, DB2 tables, MQ Series, IDMS, NDM, FTP, CHANGEMAN.

Confidential, NJ

Senior Programmer/ System Analyst

Responsibilities:

• For Quantum View Data Group of Customer Technology Infrastructure Department was responsible for analysis, coding, testing, user interface, maintenance, implementation, performance modeling and tuning, production support of QVD System. This System provides subscribed customers with information about package status data (manifest, origin, exception, delivery, etc.) through internet services. Systems receive information through MQ-s. The data is being validated, added on based on DB2 information, and split up into multiple MQ-s according to the type of data (Alternate Billing, Receiver Address,
• Receiver Locator, etc.). These MQ-s are being processed and appropriate DB2 tables are being updated / inserted. Systems utilized COBOL II, CICS, VSAM files, JCL, DB2 tables, MQ Series, Db2 Stored Procedures, CHANGEMAN, used multi-platform application systems. DB2 utilities and MQ Series CSQUTIL were also used.

Confidential, New York City

Senior Programmer/ System Analyst

Responsibilities:

• Responsible for analysis, architecture, coding, testing, user interface, maintenance, implementation, production support, performance modeling and tuning of Access Line Account Management System and its on-line/ batch Subsystems Work Queue Preauthorization System, and Medicaid Reclaim System. Those Systems processes third party liability (TPL) recovery and revenue enhancement, identify and recover payments for Medicaid services that are responsibilities of private insurance or other sources of funding, analyze insurance and payments information and organize it in any requested sequence for further collection purposes, etc. Performed analysis of the whole TPL Access Line System, modifications to on-line/batch modules, maps, copybooks, procs, jobs, etc. that are part of processing. Systems utilized COBOL II, CICS, VSAM files, JCL, DB2 tables, MQ Series.

Confidential, New York City

Senior Programmer/ System Analyst

Responsibilities:

• For Claims Group of Informational Systems Department was responsible for analysis, architecture, coding, testing, user interface, and implementation of HIPPAA System, on-line/ batch Facility Capitation System, conversion of Provider Contract Data, on-line Manual Pricing Systems for Professional Claims and Facility Claims, on-line/batch Ambulatory Surgical Claims System, EPO/PPO System. That required analysis of the whole QCARE multi-platform application System, modifications to on-line/batch programs, procs, jobs, etc. that are part of claims adjudication process. Systems utilized COBOL II, CICS, VSAM files, JCL, DB2 tables, EDI, MQ Series.

Confidential, New York City

Senior Programmer/Analyst

Responsibilities:

• For Information Systems Group of International & Futures Department was responsible for analysis, architecture, design, coding, testing, user interface, implementation, maintenance, production support of the following systems that utilized COBOL II, CICS, VSAM files, JCL, DB2 tables, MQ Series, NDM, FTP, CHANGEMAN:
• On-line SWIFT Incoming Messages System receives SWIFT Messages MT573(status), MT598 (acknowledgement), MT599(margin) through MQ from SIAC/DTC, checks their validity, creates VSAM SWIFT Message file for batch processing, extracts status information and writes it to MQ. That MQ further is being processed by International Broker Dealers Clearing System WICNET.
• Batch/ on-line Global Brokerage Account Information Interface Clearing System receives trade, non-trade (cash), and subscription acknowledgement transaction information from MQ, retrieves appropriate position and balance data from database, creates transaction, position, and balance records and passes them on as MQ messages to Global Brokerage System.

Confidential

Senior Programmer/Analyst

Responsibilities:

• For Global Custody group of the Global Security Department was responsible for analysis, design, coding, testing, performance modeling and tuning, user interface, implementation, maintenance of the following systems that processed trading information (systems utilized COBOL II, CICS, DB2, VSAM files, JCL, NDM, MQ Series):
• On-line Stock Loan System selects a number of transactions with receives, deliveries, stock loans, stock loan releases, etc. that are initiating a stock loan from respective accounts or returning of the stock loan. These transactions can be verified, settled, finalized, reversed or canceled by this System depending on the received instructions. Processing is taking place in Euroclear Region.
• On-line/batch SWIFT Incoming Messages Processing System which is SWIFT Trade Cancellation Messages and Swift Invalid Trade Messages System, processes in batch incoming Merva File, decodes it, loads extracted information to SWIFT Incoming Files and initiates background on-line program that loads information to on-line Transmission Files. These files are used for Euroclear Transmission Summary and Transmission Detail on-line Systems for displaying extracted transmission information with explanations for further settlement purposes. Transmission is being initiated every 15 minutes and batch and on-line parts of the System may run simultaneously.
• On-line Euroclear Real-time Presettlement Systems that include batch/on-line Unexecuted Transaction Information Systems, accumulates settlement data that is being transmitted from Euroclear (Brussels) and contains bank and counterparty information (Euroclear number, settlement cash amount, counterparty nominal amount, nominal currency, security code, clearing house code, cash amount, cash currency, settlement date, trade price, currency, exchange rate, etc.), extracts BONY Euroclear trading information and compares it to extracted counterparty trading information in order to perform further settlement processing.

Confidential, New York City

Senior Programmer/Analyst

Responsibilities:

• For Fixed Income Group of Information Services Department responsible for maintenance, analysis, design, coding, testing, user interface, implementation to Government Security System and its subsystems Repurchase Trade Reconciliation System, Repo Confirmation Reporting System, Unsettled Trades System, Margin Activity System, Order Processing System, Market Data System, Billing System, etc. These on-line/ batch systems process customers position information, trading information, portfolio type, settlement, trading, and termination dates, purchase and repurchase prices, interest, principal amount, etc., also ADP and DTC information. Systems were enhanced to accommodate processing of new customers Societe Generale and Freddie Mac, were performed changes for Year 2000 and field expansion.
• Responsible for conversion of on-line/ batch Mortgage Backed Security Trading System to DB2. That System enables user to access and update security information on government mortgage - backed securities, change variable rates, and browse new pool records. It provides with capability to add, change or delete security data, view new pools, etc. using Fixed Income Product Database. Information is being displayed depending on category and type of security being entered.

Confidential, New York City

Senior Programmer/Analyst

Responsibilities:

• For Wealth/Portfolio Management Group of Financial Systems Department was responsible for maintenance, analysis, design, coding, testing, performance modeling and tuning, implementation of on-line Asset Management System and its subsystems (Transaction Cancel/Replace System, Stock Dividend/Split Allocation System, Customer Billing System, Mutual Funds System, etc.). These Systems allow unpriced or incorrect priced transactions to be canceled or reentered at the correct price and number of shares or allocated to the correct number of layers. Information was entered through account, cusip, symbol, trade date. Systems were enhanced to accommodate processing of options and futures. Fields expansion changes were also performed.
• Was responsible for the conversion of on-line/batch systems (Option Expiration date Reporting System, Economic P&L Reporting System, Interest System, Asset Information Management System, Haircut Reporting System, Short Stock System, Margin System, Foreign Currency System, Option System, Order Processing System, Market Data System, etc.) from IDMS to DB2, and fields expansion changes. Data (ask, bid, close prices of firm and vendor, security description and type, dividend date, last pricing date, number of shares etc.) was selected trough cusip, symbol, etc.