Candidates About

Alan Rosen

MAINFRAME ANALYST AND DEVELOPER

Leverages technical and system analytic skills to save cost and time in mainframe development

A highly dedicated Mainframe Analyst and Developer with experience in system analysis, design, coding, testing, debugging and deployment of Brokerage, Banking and Retail applications. Solid knowledge of COBOL II, CICS, DB2, VSAM, JCL, Procs & MVS utilities. Excellent communication skills and demonstrated ability to liaise between business and development sectors to elicit requirements and plan development, testing and implementation phases.

APPLICATIONS

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

METROPOLITAN DEVELOPMENT CENTER, Brooklyn, NY                                                           01/2016 – Present

Database Reporter

·         Designed and created reports using Access as a front end and MS/SQL Server stored procedures to retrieve and join data from multiple tables as well as updating tables via use of triggers.

Community Habilitation Counselor

·         Assist high school students with special needs improve their computer skills, focus on their academic studies, social interaction and personal hygiene.

BROADRIDGE FINANCIAL SOLUTIONS, Jersey City, NJ                                                                12/2011 – 08/2015

Senior Applications Programmer

·         Supported and developed online (CICS) and batch (Cobol, VSAM and DB2) back-office trade and settlement processes of Stock Record, Margin, and Options for both end of day and intra-day components.

·         Calculated margin and option calls based on stock exchange, broker, and federal balance requirements for domestic and foreign account positions, enabling notification to account holder when funds are needed.

·         Accessing the appropriate input files, created XML formatted files to be delivered via Web service protocols.

·         Enhanced batch processes through optimized program logic and DB2 performance tuning.

ONE STEP UP LTD., New York, NY                                                                                                  04/2011 – 07/2011

Applications Programmer and EDI Support

·         Supported full-scale retail distribution system by coding in Progress 4GL on Linux server, using SQL logic for on-line and batch processes.

·          Designed and customized UPC shipping labels for several retail chains using Zebra programming language (ZPL).

AMERICAN STOCK TRANSFER AND TRUST CO., New York, NY                                                 06/2004 – 07/2009

Applications Programmer

·         Enhanced speed of online response time and nightly batch processing via use of DB2 queries, column functions, qualified cursors and performance tuning during a major VSAM file to DB2 system conversion.

·         Assisted Broker house service providers by downloading time-critical data for Corporate Reorganization, Dividend Reinvestment, and Escheatment processing.

·         Coded changes in Cobol/DB2 for reporting cancelled, surrendered, and lost certificates to Thomson Reuters, conforming to new Securities and Exchange Commission (SEC) regulations.

·         Developed processes which captured cost basis data for tax-lot accounting for P&S, transfers and exchanges.

NEW ERA SOLUTIONS, Brooklyn, NY                                                                                             01/2002 – 01/2003

Database Designer

·         Designed a SQL database linked to Magic front-end to support order-entry, invoicing and inventory control.

·         Created SQL triggers and stored procedures, enabling quick response to user on-line requests.

·         Performed QA testing, confirming accuracy of all modifications to the batch process and on-line screens.

HAMMERMAN ASSOCIATES, Salisbury, MD (NYC Office)                                                              07/2001 – 01/2002

Database Reporter

·         Designed and created critical management reports using Crystal 8.0 against MSSQL, Foxpro, and Access databases, tracking Fund investments for Fund of Funds LP's plus their underlying investments.

J. P. MORGAN CHASE & CO., Brooklyn, NY                                                                                   05/1998 – 05/2001

Senior Applications Programmer

Project: Global Custody Client Support & Swift Outbound Messaging

·         Created, updated, and transmitted domestic and foreign trade and foreign exchange (FX) transaction reports.

·         Developed a Mainframe to Windows-NT interface using Excel saving 4 man-hours daily.

·         Optimized the DB2 Swift Message Database by developing a flexible process to purge old messages.

BROOKS BROTHERS CLOTHING, New York, NY                                                                          11/1988 – 04/1998

Business Analyst

Project: System Migration Analysis, Design and Implementation

·         Collaborated with business analysts and other business managers to elicit requirements to migrate Mainframe Sales Audit and Inventory systems (Cobol/CICS) to a Unix RS6000 system.

·         Presented Business and Functional requirement documents pertaining to the scope of each phase of the project.

Project Manager

·         Managed team of 4 programmers modifying and testing several Assembler date utilities of 260 batch jobs to implement addition of 5th week to February to conform to 4-5-4 retail calendar requirements.

Applications Programmer

·         Supported on-line Merchandise system that controls on-hand/on-order stock levels and warehouse distribution, simplifying correction of errors for the user via symbolic cursor positioning.

·         Maintained Sales Audit system which edits and reports register and Mail Order inputs and feeds General Ledger.

RELATED SOFTWARE DEVELOPMENT EXPERIENCE

MABON, NUGENT & CO., New York, NY

Employee as a Financial Mainframe Developer for online and batch programs.

·         Implementing CICS and OMNIGARD, created Log System to identify the user who enters a given update.

·         Reduced daily job execution time of transaction reporting by twenty minutes utilizing the Syncsort utility.

SUNGARD-DML, INC., New York, NY

Consultant as a Financial Mainframe Developer for online and batch programs.

·         Participated in the development of an online global Stock Loan System that allows loan transaction filing worldwide.

·         Implemented the use of Basic Mapping Support (BMS) within CICS to display foreign codes.

EDUCATION

MIKDASH MELECH COLLEGE, Brooklyn, NY - Bachelor of Art (BA)                                          2003

COPE INSTITUTE, Brooklyn, NY - Diploma, Computer Programming                                           2001

SAM CAREER CENTER, Brooklyn, NY – Certificate, Project Management/Business Analysis/SAS          2016