SUMMARY:

• Over twenty years of extensive experience in Data Processing. Responsible for analysis, design, coding, testing, implementation, maintenance, and database conversion of financial application systems in Banking, Brokerage, Insurance, and Accounting.

TECHNICAL SKILLS:

HARDWARE: IBM Mainframe, IBM PC

SOFTWARE: COBOL, COBOL II, CICS, DB2 UDB Stored Procedures, MQ Series, DB2 Connect, CWS (CICS WEB Support), MDI Gateway, Static and Dynamic SQL, SPUFI, QMF, PLATINUM, JCL, VSAM, C, PL/1, ASSEMBLER, ADABAS, NATURAL2, IMS, MVS, BMS, SDF, SYNCSORT, EXPEDITOR, INTERTEST, CHANGEMAN, LIBRARIAN, TSO/ISPF; JAVA 2, JSP, JavaServlets, EJB, JavaBeans, Swing, JDBC, DB2 SQL, JSDK 2.0, XML, HTML, JavaScript, WEBLOGIC, ASP, MS SQL, MS Access, MS Excel.

PROFESSIONAL EXPERIENCE:

Confidential, Wayne, NJ

Senior Programmer / System Analyst

Responsibilities:

• Responsible for enhancement, maintenance, and support of Payroll Daily Cycle for Enterprise Enablement Department.
• The system was written using COBOL, CICS, DB2 Stored Procedures, MQ Series, VSAM, FTP, and JCL and provided payroll transaction reconciliation daily process support.

Confidential, New York, NY

Senior Programmer / Analyst

Responsibilities:

• Responsible for system analysis, design, coding, testing, implementation, maintenance, support, database design, and data modeling (SDLC) of NSCC Financial Activities Reporting System (FAR).
• The system was written using COBOL, DB2 Stored Procedures, MQ Series, CICS, VSAM, JCL under MVS/ESA and performed business processing for Financial Department:
• Daily transactions exchange with investment institutions; Portfolio verification based on Transaction, Security and Position DB/2 Tables; Free funds management and control.

Confidential, New York, NY

Senior Programmer / System Analyst

Responsibilities:

• Created DB2/IBM390 8.0, COBOL LE stored procedures for Case Management System (CMS) used by the Law Department. The system is a .NET WEB client and DB2 UDB, DB2 Connect server - based application migrated from COBOL, CICS, IMS, DB2, MDI Gateway environment and comprised of the following subsystems:
• File Room/Library - to keep track of all files maintained by the Law Department;
• Docket management - to record documents served by parties in a lawsuit;
• Case Tracking - to keep track of claims, suits and memo bills.

Confidential, Jersey City, NJ

Senior Programmer / Analyst

Responsibilities:

• Responsible for system analysis, design, coding, testing, implementation, maintenance, support, of Managed Accounts Trading Analysis System (MATA) for Product Management Department.
• The system was written using COBOL II, DB2, CICS, VSAM, JCL and provided:
• Customer & Financial Representative levels on-line overview;
• Real time trading commissions and flat fees comparison;
• Daily extract and load RBC Dain’s account information into MATA database.

Confidential, Morristown, NJ

Senior Programmer / Analyst

Responsibilities:

• Responsible for system analysis, design, coding, testing, and implementation of Custom Brokerage View Subsystem of Customhouse Brokerage e-Services System (BeS).
• The system utilized Java front-end applications, Unix-based Web Server, COBOL II, DB2/IBM390-based stored procedures, DB2 Connect 8.0 and provided Web customers with the following capabilities:
• Access, download, and filter brokerage data; E-mail event-triggered alerts using MQ Series technology; Support request/response functionality using Dynamic SQL and Global Temporary Tables.

Confidential, Montvale, NJ

Senior Programmer / Analyst

Responsibilities:

• Responsible for Customer database conversion to comply with new Data Transaction Standard and privacy requirements of the Health Information Portability and Accessibility Act (HIPAA) for Account Receivable Department. The system was written using COBOL II, CICS, DB/2, VSAM, and JCL and provided:
• Uniform Customer ID generation;
• Active and transferred customers separation.

Confidential, Whippany, NJ

Senior Programmer / Analyst

Responsibilities:

• Participated in maintenance and enhancements of Fixed Income Corporate Securities Trading System. The system was written using COBOL II, CICS, DB/2, VSAM, JCL, and provided the Corporate Bonds Department with the following online capabilities:
• Trades Processing allows the user to enter new transactions and verify, correct or reconcile current trades;
• Account Maintenance allows the user to open new accounts and modify data related to existing accounts;
• P&L Reporting based on Position Master pricing and status of Security Master.

Confidential, Jersey City, NJ

Senior Programmer / Analyst

Responsibilities:

• Responsible for database design, data modeling and coding of Joint Ventures Marketing System conversion to extract, transfer, and load (ETL) database after the Mainframe night cycle update into the WEB site. The system was written using COBOL II, CICS, DB/2, QMF, VSAM, JCL and provided:
• Two-levels management support (Customer level & Financial Advisor level);
• International Marketing planing process and analysis;
• World geographical regions, districts, and offices levels reporting.

Confidential, Brooklyn, NY

Senior Programmer / Analyst

Responsibilities:

• Participated in maintenance of Cage Reporting System. The system was written using COBOL, CICS, JCL, DB/2, and VSAM under MVS/ESA and performed processing which supports the basic business procedures of the Cage (Cashiers) Department:
• Interface with Money Market, Foreign Exchange, Commercial Loan Systems;
• Send/receive of bookkeeping and journal entries and transactions as interfaces with DTC, Reserve Fund, SIAC, Lehman Br., Dreyfus Fund.

Confidential, Morristown, NJ

Senior Programmer / Analyst

Responsibilities:

• Responsible for design, programming, testing, and implementation of Bill Reprint Subsystem of Online Billing System (OLB) for Billing Department.
• The system was written using COBOL, CICS, and DB/2 under MVS and performed:
• Select information from history files by customer’s requests;
• Load DB/2 tables and set up CICS region for on-line bill.