SUMMARY:

An accomplished IT professional with over thirty years of diverse experience in the design, development, and implementation of IT systems on a cost effective basis. This extensive and varied experience has provided a unique insight into the ways in which the mainframe application development/modification effort can be streamlined and thereby made more efficient leading to significant gains in developer productivity.

TECHNICAL SKILLS:

HARDWARE: IBM Mainframes, IBM PC Compatibles

SOFTWARE: Enterprise COBOL, DB2, DB2/SQL, DB2 Stored Procedures, CICS, XPEDITER, INTERTEST, CA - Erwin, MQSeries, IBM RDz, IDMS, IDMS/ADSO,VSAM, IMS, OS/MVS/JCL, VM/CMS, REXX, ISPF DIALOG MANAGER Applications, TSO CLIST, FOCUS, RAMIS II, MS EXCEL, MS WORD, MS ACCESS, MS WINDOWS,, MS VISUAL BASIC, MS/DOS, HTML, DHTML, XHTML, XML, JAVASCRIPT, VBSCRIPT, MYSQL/PHP, AJAX

EXPERIENCE:

Confidential, Weehawken, New Jersey

Senior Consultant

Responsibilities:

• Designed and created REXX/ISPF Dialog Manager automated procedures to define and populate hundreds of data stores, including DB2 tables, VSAM files and GDGs, for a newly created QA region.
• Conducted class to instruct technical personnel in the use of solely developed ISPF Dialog Manager enhancements (commands, panels, macros) that greatly improved their efficiency.
• Created, tested and implemented numerous changes and enhancements to the ICS Trading (ICST), Monitoring Detection and Control (MDC), and Managed Account Billing (MAB) systems. Created BRDs, technical specifications and managed database modifications as well as the efforts of technical staff in the development of several projects for these COBOL/DB2/CICS/JAVA based systems.
• Solely designed and wrote turnkey procedures to allow management to extract customized reports from CHANGEMAN, thereby allowing management to accurately supervise the turnover process.
• This subsystem was written in SAS and REXX.
• Independently designed and created database that contained metadata reflecting the inter-relationships of various mainframe components; e.g. jobs, procs and programs, as well as job scheduling relationships.
• Created all database load procedures as well as numerous adhoc reports that allowed technical staff to more accurately view these relationships.

Confidential, New York, New York

Senior Consultant

Responsibilities:

• Created technical design documents as well as designed, wrote, tested and implemented the major DB2 portions of the Concentration Letter project, an effort that reduced the firm’s vulnerability to client litigation.
• Solely designed and wrote procedure to extract SQL from DB2 programs and evaluate this code for efficiency. This sub-system was comprised of several REXX execs. This use of procedure became a pre-requisite for DB2 programs implemented into production.

Confidential, Jersey City, New Jersey

System Designer and Lead Programmer

Responsibilities:

• Solely designed all interfaces between Confidential and Confidential ’s Global Plus, composed design documentation, and directed technical efforts of programming staff.
• Designed and coded transmission verfication subsystem, using MQSeries. Additionally created major portions of Confidential ’s feed to Confidential ’s Invest 1 system.
• Designed and wrote the Confidential Quality Control system, including Data Scrubbing and Security Locking.
• Exclusively responsible for logical design of the DB2 tables required in this effort.
• Independently created the DB2 interface between Confidential and the Financial Services Data Exchange (FSDX), the firm’s centralized financial data exchange vehicle.
• As an integral member of the team that reengineered the Confidential workstation for the Intranet, designed and created numerous DB2 stored procedures, including Security Search. This component was the central entry point to the new system, and allowed for multiple parameter entry in order to efficiently find qualifying securities among the almost five million stored in Confidential .
• Automated many database related functions, including vendor security feeds. Designed and created system to generate standardized VS COBOL II/DB2 programs for Confidential through a DB2/ISPF Dialog Manager interface, resulting in significant cost reductions.
• Inititiated the use of MS Excel as a valuable reporting tool for QA data verfication.
• Created MS Visual Basic subsystem which enabled users to upload crucial security pricing data entered in MS Excel, thereby allowing for timely portfolio valuations.
• Using MS Visual Basic, was solely responsible for the design, coding and implementation of enhancements to the workstation portion of Confidential .
• Independently designed new way to balance accounts in the firm’s Stock Record Database. Subsequently coded, tested and documented the new system using this new design.
• Conducted complete impact analysis of the firm’s proposed migration of the Stock Record Database from IMS to DB2.
• As Team Leader and System Designer, designed on-line portion of the Securities Information System (SIS), the firm’s repository for all indicative data for its traded securities. This DB2 database represented a complete re-design of the system, formerly based in IDMS. Independently designed the CICS commarea, was instrumental in a design which allowed for dynamic navigation of the on-line system, and created the high level modules used throughout the system required to implement this design. Designed and coded many of the more complex CICS/DB2 programs in the system.
• Solely prototyped portions of SIS, using MS Visual Basic and MS ACCESS, for management review.

Confidential, New York, New York

Project Leader

Responsibilities:

• Due to their real time editing features and ease of use, these front-ends were expanded to replace the existing PC upload procedures.
• As Senior Programmer/Analyst, designed, coded, and tested numerous CICS/DB2 and batch DB2 programs as part of the development of the Management Reporting System.
• Enhanced the Budget Report Selection Facility, through which users made on-line requests for DB2 data through a FOCUS interface.
• As Lead Programmer, developed program specifications and designed, coded, and tested VS COBOL II/CICS/VSAM programs for the redesign of the corporation's on-line Payroll System.
• Led project team in the design of a methodology to convert the firm's Confidential System from DMS/CICS to CICS/BMS.
• Independently created automated subsystems to effect DMS panel/BMS map and associated program conversions, resulting in a 60% savings in time/manpower.

Confidential, Nutley, New Jersey

Project Leader

Responsibilities:

• designed IDMS database system to monitor the return of pharmaceutical products, thereby streamlining inventory control and minimizing duplication in government reporting requirements.
• Created functional as well as external specifications, and developed logical database design.
• Coded and implemented system for data update and retrieval using IDMS/ADSO.
• Designed and coded many IDMS/CICS programs in the redesign of the firm's Order Processing System.
• Revamped and improved invoicing, including accommodation of additional data, while reducing the number of copies required.
• Responsible for full analysis of the Record Day Accounting function of the Securities Dividends and Interest System.
• Subsequent to user interface, analyzed requirements, reviewed and documented current system, and designed and coded program enhancements.

Confidential, New York, New York

Senior Programmer/Analyst

Responsibilities:

• Enhanced and maintained the Account Executive Registration System using IDMS/CICS.
• As internal consultant, provided CICS/VSAM expertise in the design and coding of various corporate applications, including Employee Pensions and Telephone Voice Billing.
• Developed a CICS system for data input, update, and browse of journal entries for input to the firm's General Ledger.