Alex Kesler

Delray Beach, FL

917-***-****

ad4psi@r.postjobfree.com

SUMMARY

A data processing professional with over 25 years of extensive experience specializing in the

development of applications for the financial and health care industries.

Possesses strong technical and analytical skills, with a solid background in implementing COBOL/CICS/DB2/JCL/VSAM systems in IBM mainframe and PC environments.

QUALIFICATIONS

A proactive team player with excellent organizational skills

A quick learner and very detail oriented

Ability to multi-task, prioritize and coordinate work in a fast-paced environment.

IBM mainframe and PC environments

HARDWARE: IBM 308X, 309X, IBM PC

SOFTWARE SKILLS

COBOL 390, z/OC IBM, CICS TS, DB2/SQL, MQSeries, VSAM, OS390/JCL, TSO/ISPF,

STORED PROCEDURE, QMF, ABENDAID, FILEAID, SPUFI, DB2 FILEAID,

PLATINUM, INTERTEST, XPEDITER, ENDEVOR, LIBRARIAN, PANVALET, CHANGEMAN, SYNCSORT, MICRO FOCUS COBOL, TOPAZ, ALDON, SOAP WEB SERVICES, VISION: RESULTS(DYL280), MS-WINDOWS, MICROSOFT Tools, Agile framework on Mainframe system, VS Code, AWS, WinSCP, FileZilla, FIS Omni Plus/ Omni Script developer

EMPLOYMENT HISTORY

Mutual of America Boca Raton, FL Senior Programmer Analyst 7/2008- Present

Participated in the development, testing and implementation of numerous new projects and enhancements for existing programs.

Provided the maintenance of programs and created new programs for the different

insurance divisions (Finance, Loans, Taxes, Funds, Thrift and Individual retirement savings products).

Responsible for extremely complex and ongoing software functions related to system analysis, data operating systems administration, database management systems, data communication systems, online applications programming, and quality assurance functions.

Experience in all phases of the software development life cycle.

Strong understanding of the SDLC and the associated deliverables which drive quality and timely delivery of software development efforts.

Researching and resolving production issues, troubleshooting of mainframe on-line and batch abends.

Evaluating daily, monthly, quarterly and annual batch process to improve performance and shorten the critical path window.

Used conducting parallel unit and system testing.

Writing systems and programs according to specifications from higher level staff or business analysts.

Influencing system design by identifying and recommending design and

requirement needs for software enhancements.

Generating a variety of complex and periodic reports and/or data through database

Management of data administration and data extraction techniques.

Provided general system users and management with system analysis and feedback.

Experience in dealing effectively with deadlines.

Provide design documents and translate into component-level designs to accelerate.

Developing, analyzing of design and reviews of design of programs and applications to ensure that customer specifications are satisfied.

Worked on enhancing and writing new Omni Script

Mentoring and coaching other staff members

All processes and projects were developed and implemented using COBOL, CICS, DB2, JCL and PROCS .

PCH Port Washington, NY

Senior Programmer Analyst (Consultant) 10/2007- 6/2008

Participated in the development, testing and implementation of enhancements to the DMS(Database Marketing System). Development and implementations of processes of DMS Pre-Conversion Data correction accounts that were incorrectly posted to DMS with old customer id).

Recalculation of DMS CUSU(Customer table) open order counts due to various

issues in Billing system that cost incorrect calculation in DMS.

Set up of ”DMS Credit Limits calculations process” for Conversion into PCS.

Incorporated credit limits logic into programs Including design and creating DB2

tables, modules to load DB2 tables from incoming files.

All processes was developed and implemented using COBOL,CICS, DB2,

JCL and PROCS .

conducting parallel unit and system testing.

UBS Weehawken, NJ

Senior Programmer Analyst 6/2005- 9/2007

Participated in the development, testing and implementation of enhancements to the TEFRA (Tax Equity and Fiscal Responsibility Act) of 1982.

This system was implemented using COBOL/CICS and DB2 environment.

Fully responsible for development and implementations of various number of programs such as JCL, PROCS and Store Procedures of DB2 modules for TEFRA system. Creation of Ad-hoc batch/DB2 reports for various user requests.

Logical design, coding and implementation of new subsystem which is reconcile files unloaded from Proceeds and Dividends DB2 tables with PMIS system files and then update DB2 tables (Turbo Tax) for Current year, Tax year, Daily adjustments Tax year. Also design, coding and implementation of reconciliation process for files 1099,1027 and 480.6(A, B,C) forms and printed forms (summary, detail).

24/7 Production support. Full life cycle development experience.

Goldman Sachs Jersey City, NJ

Senior Programmer Analyst 5/2004- 5/2005

Fully responsible for a development and implementations group of DB2 modules for ACATS system.

Making designs and creating DB2 tables, modules to load DB2 tables from

incoming files.

Responsible for various number of programs and reports used by financial clients to identify: assets to be transferred from one firm to another

Change detection module to give clients the ability to track all changes

within account transferring cycle, account rejection reports.

Develop Store Procedures modules for the Auto Cage Security systems.

MERCK-MEDCO Montvale, NJ

Senior Programmer Analyst 12/2000- 3/2004

Participated in the development, testing and implementation of wide scale enhancements and creation of new functions for the Medical Management Prescription System (MMRx). The MMRx system’s purpose was to help management and pharmacy staff track the dispensing and delivery of medications to regular plan subscribers and over the counter clients. This System also provided users with an analytical interface for resolving conflicts involving rejected prescriptions. This system was implemented mostly using COBOL/CICS background transactions working with VSAM for data interfaces and DB2 for data repository.

Responsibilities included: development of a new background CICS function for matching incoming prescription orders against corresponding Subscriber plans producing new prescription entries and maintaining dispense limits; Logical design and creation of a new set of DB2 tables for the prescription orders shipping process; development and implementation of several new CICS screen functions for historical prescription analysis by Subscriber and other elements, functions utilized complex SQL queries for mining the necessary data; Creation of Ad-hoc batch/DB2 reports for various user requests.

Bear Stearns Whippany, NJ

Programmer Analyst 3/2000-12/2000

Participated in the maintenance and redevelopment of the Trade Reconciliation Reporting System, a component of the International Trading Verification System. This system allowed its users to view both sides of current trades in a wide variety of reports with formats focusing on specific breaks in trade info as well as certain match summaries. This system was redeveloped in a COBOL/DB2 environment.

Responsibilities Included: analyzing and rewriting dozens of poorly structured hardcode based report modules, redesigning them into highly maintainable database driven programs; Creating DB2 tables and design documentation; conducting parallel unit and system testing, coordinating user acceptance testing and turnover.

Merrill Lynch Somerset, NJ

Programmer Analyst 4/1998- 3/2000

Participated in the development, testing and implementation of enhancements to the General 401K Employee Services System (401K GES). The system also provides a facility for handling new account transfer and setup in cases of employee’s rolling over from prior company’s plan. System enhancements were developed in a COBOL/CICS/DB2 environment.

Responsibilities included: coding and testing of enhancements to the main batch module used in conversion of incoming account transfer records for Merrill Lynch account setup; participated in the design and development of a new 401K Loan Activity System for administrating allowable hardship and personal finance loans.

Participated in the development, testing and implementation of enhancements to the Omni Trust Accounting System. This system provided the firm with the ability to maintain various types of trust accounts and to apply transactions from several interfaces, including Trade Processing system and Pension Deposits system. The system also provided accounting staff with important asset tracking, fee calculation and tax reporting capabilities. System enhancements were developed in a COBOL/CICS/DB2 environment.

Responsibilities of coding and implementation of enhancements to the fee calculations batch process; development of wide-spread changes to the Tax Worksheet/Schedule D reporting modules; design and development of a new checking interface process

LANGUAGE SKILLS

Fluent in Russian and Ukrainian

Contact this candidate