Programmer Analyst Systems

Alex Kesler

Delray Beach, FL 917-***-**** ******@*****.*** linkedin.com/in/aleksandr-kesler-6496552ba

SENIOR PROGRAMMER ANALYST

MAINFRAME PROCESS & SYSTEMS ANALYST

Technical analyst with a wealth of experience in the development of applications for financial and healthcare industries. Strong technical and analytical capabilities with qualifications in recommending cost saving best practices for system performance, security, and reliability. Additional core competencies include the following:

Program & System Development Testing and Analysis Strong SDLC, DB2/SQL Knowledge

Agile Frameworks Legacy System Maintenance Multilingual/English, Russian, Ukrainian

Technical Leadership Knowledge Transfer and Training Portfolio Management Information System

SOFTWARE SKILLS

Mainframe Environment:

COBOL

CICS TS

DB2/SQL

VSAM

JCL (OS390/JCL)

TSO/ISPF

Stored Procedure

MQSeries

Syncsort

z/OC

Development & Testing Tools:

SPUFI

InterTest

XPEDITER

Topaz

QMF

Version Control & Management:

Endevor

Librarian

Panvalet

ChangeMan

Database and File Management:

FileAid, Platinum, and DB2 FileAid

ABENDAid

Tools and Technologies:

Micro Focus COBOL

VS Code

AWS (Amazon Web Services)

WinSCP

FileZilla

Agile on Mainframe System

SOAP Web Services

FIS Omni Plus/Omni Script Developer

PROFESSIONAL EXPERIENCE

Mutual of America Boca Raton, FL

Senior Programmer Analyst, 7/2008 – Present

Led the development, testing, and implementation of new projects and enhancements for insurance division programs. Maintained and created programs for financial products with SDLC understanding. Researched and resolved production issues, improved batch process performance, and ensured customer specifications were met through detailed design and analysis.

Mainframe Development & COBOL Programming: Designed and developed COBOL programs for core financial systems, optimizing insurance and retirement savings processes.

DB2 Integration: Implemented and maintained DB2 databases to support transaction processing and reporting for financial products.

JCL Scripting: Managed batch job processing through Job Control Language (JCL), ensuring efficient execution of critical system tasks.

Endevor for Change Management: Utilized Endevor to control software changes, managing source code versions and ensuring smooth deployment.

CICS: Developed and maintained CICS-based online transaction processing systems to ensure real-time data accuracy for financial products.

Reliability and Stability: Revamped company's outdated and expensive applications, resulting in a 35% improvement in software engineering costs and significantly reducing system failures.

Cost Efficiency & Business Growth: Restructured and developed programs across diverse insurance divisions (Finance, Loans, Taxes, Funds, Thrift, and Individual retirement savings), yielding a 20% reduction in software engineering costs and expanding customer base significantly.

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

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

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

PCH Port Washington, NY

Senior Programmer Analyst (Consultant), 10/2007 – 6/2008

Advised on the functionality, accuracy, and efficiency of the Database Marketing System (DMS) through targeted improvements in data correction, operational recalibration, credit limit management, and database integration.

COBOL/DB2 Expertise: Developed COBOL programs integrated with DB2 to optimize DMS data accuracy and reporting.

JCL: Managed batch processes with JCL to ensure timely execution of updates and corrections within the DMS.

Profitable Project Leadership: Enhanced Database Marketing System by correcting mis-posted accounts, leading to a new project that generated over $10M in profit within one year.

Operational Efficiency Improvements: Addressed issues in Billing system that caused incorrect calculations in the DMS customer table. Resolved data discrepancies, leading to more reliable reporting and decision-making.

Risk Mitigation and Compliance: Developed and implemented strategies for calculating credit limits in the DMS by ensuring compliance with financial regulations and internal policies, resulting in reduced risk of credit overextension and potential financial losses.

System Integration and Optimization: Incorporated credit limits logic into programs by designing and creating DB2 tables, saving over $30M annually through system enhancements.

UBS Weehawken, NJ

Senior Programmer Analyst, 6/2005 – 9/2007

Led hands-on development, testing, and implementation of enhancements to the TEFRA system, encompassing program development, ad-hoc reporting, subsystem design, and database management.

COBOL/CICS and DB2 Development: Enhanced TEFRA system compliance and financial reporting by developing COBOL/CICS applications and DB2 integration.

Endevor for Source Control: Leveraged Endevor for maintaining program versioning and ensuring controlled deployment in a complex environment.

JCL: Employed JCL for managing batch processes and ensuring seamless execution of program updates.

Development, Testing, and Implementation: Satisfied banking standards and saved over $50M with TEFRA enhancements using COBOL/CICS and DB2.

Ownership of Programs: Developed and implemented various programs (JCL, PROCS, Store Procedures) for the TEFRA system, reducing turnaround times for tasks related to tax calculations and reporting.

New Subsystem Implementation for Data Reconciliation: Designed and implemented a subsystem ensuring data consistency between Proceeds and Dividends DB2 tables and PMIS system files, enhancing compliance and financial reporting precision.

Goldman Sachs Jersey City, NJ

Senior Programmer Analyst, 5/2004 – 5/2005

Led DB2 module development for Automated Customer Account Transfer Service (ACATS), optimized data loading, oversaw asset transfer programs, created account tracking module, and developed security procedures for systems.

DB2 and COBOL: Led the development of DB2 modules integrated with COBOL programs to facilitate automated account transfers.

JCL & Endevor: Managed batch jobs using JCL and controlled source code changes with Endevor for deployment accuracy.

CICS Integration: Implemented CICS programs to support real-time tracking and reporting for account transfers.

Development Leadership: Managed the development and implementation of DB2 modules crucial for the ACATS system, ensuring efficient account transfers.

Database Management: Designed and formatted DB2 tables and modules for seamless data loading from incoming files, optimizing data handling processes.

Program Oversight: Supervised various programs and reports used by financial clients, facilitating accurate identification and transfer of assets between firms.

Client-Centric Innovation: Created a detection module enabling clients to track account transfer changes and generate rejection reports, resulting in over a 22% improvement in software engineering costs.

Security Enhancement: Developed Stored Procedures modules for Auto Cage Security systems, bolstering transactional security and operational integrity.

MERCK-MEDCO Montvale, NJ

Senior Programmer Analyst, 12/2000 – 3/2004

Participated in the development, testing, and implementation of improvements and new functionalities for the Medical Management Prescription System.

COBOL/CICS Development: Improved prescription processing with COBOL and CICS programs, ensuring more accurate order fulfillment.

DB2 Database Management: Designed and managed DB2 tables to streamline the prescription shipping process.

Improved Prescription Processing: Developed a background Customer Information Control System (CICS) function to match prescriptions to plans, increasing accurate fulfillment by 30% and improving patient care.

Efficient Shipping Process: Designed new DB2 tables for the shipping process, enhancing efficiency and accuracy in medication delivery.

Detailed Data Analysis: Created CICS screen functions for historical analysis, enabling better decision-making and insights into prescription trends.

Custom Reporting: Developed ad-hoc reporting capabilities to support audits, compliance, and performance monitoring, increasing the system's utility and responsiveness.

.

ADDITIONAL RELEVANT EXPERIENCE

Bear Stearns Whippany, NJ

Programmer Analyst 03/2000 – 12/2000

Redeveloped the Trade Reconciliation Reporting System, enhancing maintainability, data integrity, and performance. Conducted thorough testing and coordinated user acceptance to ensure a smooth transition and reliable operation, improving overall system quality and user satisfaction.

Merrill Lynch Somerset, NJ

Programmer Analyst 04/1998 – 03/2000

Enhanced 401K Employee System for efficiency and reliability, improved user interfaces and reporting accuracy, ensured compliance and minimized risks. Contributed to strategic development and innovation of new systems and processes.

EDUCATION

Polytechnic University – Bachelor of Science

Contact this candidate