Senior Mainframe Programmer Analyst (COBOL)

ESTRELLA O. SAYSON

*** ****** **.

Roselle, NJ **203

Cell: 908-***-**** ***************@***.***

PROFESSIONAL SUMMARY

Sr Programmer Analyst with over 15 years of experience in mainframe application development and implementation, specializing in COBOL, CICS, DB2/SQL and JCL. Proven ability to analyze complex requirements, design technical solutions, and deliver robust code, testing, documentation. implementation and monitoring for financial systems. Contributed to significant projects involving system integration, data processing, and transaction management at major financial institutions including JPMorgan Chase, Bank of New York Mellon, Bank of America Merrill Lynch, Merrill Lynch. Eager to leverage expertise in system analysis and development to drive success at your organization.

EXPERIENCE SYNOPSIS

Senior Programmer Analyst with over 15 years of experience in the development and implementation of commercial data processing applications with emphasis in the IBM mainframe environment.

Strong financial industry experience working at JP Morgan Chase, Bank of New York, Merrill Lynch, Bank of America Merrill Lynch, Merrill Lynch.

Industries worked on include Banking and Financial/Brokerage institutions.

Systems worked on include Banking (Visa Credit Card); Financial/ Brokerage (AMFS-Wealth Cash Management Account (CMA), Trade Date Stock Record Repository, Global Bookkeeping Repository (composed of activities, holdings, tax lots and balances), Securities processing using batch & MQ, Global Short Term Investment Funds (STIF) for Money Market, Employee Stock/Equity Plan, Systematic Email Processing) applications.

Activities include participation in systems planning, conducted system analysis, design (functional/detailed), program analysis/development/enhancement/maintenance, create test plan and test script, unit/regression/end-to-end/system-integration testing, integration testing between mainframe and distributed which uses java (where applicable), Code review. User Acceptance testing(UAT) in QA, documentation, implementation and monitoring. Successfully implemented to production every project worked on using COBOL, CICS, DB2/SQL, VSAM, JCL, IBM utilities, LOAD/UNLOAD of DB2 data, Stored Procedure & MQ (where applicable).).

Was one of the 5-Team members tasked to work on the installation of all jobs to set up the EPLX UAT environment as part of BNY Mellon’s mainframe modernization project to create several test environments assigned to different systems to be used for UAT (User Acceptance Testing) of which EPLX environment is one of them.

Changed and tested CICS programs based on high level business requirements for ACAP project to add data entry functionality to enter REPO & LEND dates that impacts settlement of large volumes of trades. Also on the same project, changed and tested programs and process PROCs to expand the input file coming from external entity, Broker Dealer Corporation (BDC), to accommodate request from downstream process to expand the output file passed to them.

Changed various DB2/SQL, CICS programs and stored procedures (SPs) for batch and online to get the pending trade restriction amount from Brokerage Authorization needed for processing. Data is passed to external systems calling our SPs for the Preventing Trade-Through Violations in Restricted Amounts Project.

Analyzed, designed and Created the Move Money Transfer inquiry screen using BMS map to get information on how money is being transferred from one account to another. Developed the program using CICS, COBOL, DB2/SQL to interactively display pertinent information as to who-created, who-cancelled/who-updated the transfer and when transferred using TRAN-ID, confirmation number and date as the key in the Move Money system.

Coordinated with distributed group in the design of the program to create data for web use to optimize the DB2 data base in storing huge volumes of data without degrading performance in the Trade Date Stock Record (TDSR) project. This data was to be loaded to DB2 tables for the distributed system. Conducted integration test with them.

Conducted data integration test with mainframe external systems as well as integration test and the Distributed group during the IIP project for GBR.

Used Agile methodology in project development as well as SonarQube Scan & Code Coverage tools on new/changed programs to ensure that bugs are mitigated prior to production deployment as part of operations standards.

PROGRAMMING SYNOPSIS

HARDWARE: IBM/ES/9000, 3090

OPERATING SYSTEMS: MVS/ESA, MVS/XA, Windows10

LANGUAGES: COBOL6, COBOL5, COBOL II, COBOL

ENVIRONMENT: CICSPlex, ISPFPlex

SOFTWARE: CICS, SQL/DB2, SPUFI, DB2 Stored Procedure, MQ series, QMF, OS/JCL,

ICETOOL, SYNCSORT, File Manager, Debugger batch/online, File-Aid, BMC, Fault Analyzer, Endevor, Excel, Visio, Abend-Aid, MS-Outlook, Flowchart, OPC/A &

CA7 scheduler, Microsoft Word, CA-Intertest, Xpediter, Skype for business, Microsoft Office Communicator, EXTRA, Eclipse, IDIIP, BMC-CRQ, Power Point, UACR,

Agile/Jira, Confluence, IDz, Unix, SonarQube Scan, Code Coverage, TraceMaster, DUS, Reflection, Changeman, Control-M.

EDUCATION

B. S. Chemical Engineering

Cebu Institute of Technology University, Philippines

TRAINING

Debugger batch/online Web based - Merrill Lynch-Bank of America, NJ, USA

SQL Programming in DB2 Version 5 – Platinum Consulting Education Center, Toronto, Canada

Structured Systems Analysis and Design – National Computer Institute, Philippines

COBOL Language Programming – National Computer Institute, Quezon City, Philippines

EXPERIENCE PROFILE

Seven Seven Softwares, Rockaway, NJ 05/06/24 - 04/30/2025

Programmer Analyst

Client was JP Morgan Chase, Jersey City, New Jersey

Global Shares (GS) Project

Global Shares System was newly acquired by JPMorgan Chase and has to be created on its platform to be integrated into the Retail Portfolio system which is the Tax platform of JPMorgan Chase. Was a member of the Team tasked to build GS system on the RP system.

GS is a system that manages employee equity plans for startups, tech companies and enterprise brands. Its platform provides equity management and administration solutions to corporate clients and their employees. Taxes on company stock grants (like employee stock purchase plans (ESPPs), restricted stock units (RSUs), and stock options) are generally paid on the value of the stock when it's acquired or exercised, and on any capital gains when the stock is sold. At EOD, GS sends to RP the file of Tax Lots created from various Trades.

Retail Portfolio (RP)

RP among its other functions, is the tax platform of JPMC commonly known as Tax Lot. Tax Lot is a record of transactions and their tax implications (dates of purchase and sale, cost basis and sale price) involving a particular security. Every time shares of security are bought, an Open Lot is created to track the date and price of the purchased Security. When shares are sold, Tax Lots allow JPMC to automatically find the shares that keep investors taxes as low as possible. As part of the sale, Close Lot is created and removed from existing Positions. The current RP system will soon to be replaced by a new system, called Silver.

Responsibilities:

One of the GS Team members tasked to work on Global Shares Project to create new process to accommodate Global Shares in the Retail Portfolio System. Conducted system analysis, created technical design from high-level business requirement. Participated in systems planning and code reviews. Developed new programs, PROCs, JCLs, control cards) using COBOL, DB2/SQL. Conducted unit test, parallel test, User Acceptance Test (UAT) using VSAM files. Created various PROCedures to capture raw data from external feed to be formatted from the web to be processed by GS.

Currently the Silver process cannot be implemented just yet while Global Shares process is already ready.The Silver Team were in the process of parallel testing the existing RP and Silver process in Prod. Once Silver is considered clean and functional, GS will be incorporated into the Silver system (New RP). Agile methodology and Confluence were used in the development work.

Seven Seven Softwares, Rockaway, NJ 06/28/21 – 12/31/2023

Programmer Analyst

Client was Bank of New York Mellon, New York City, NY

Global Securities Services (GSS)

Fed ACAP Project (Automated Claims Adjustment Process) - GSP-DVS Process

is an industry mandated project for all Fed Reserve Banks to provide additional tracking capabilities (like adding new Federal Security Types and Securities Lending/Borrowing tracking to ACAP) and aligning more closely the timing of affecting claim adjustments to the time at which Principal & Interest (P&I) payments are made to Fedwire Securities Service participants. This project is a combined effort between GSP & DVS Systems since DVS is the messaging Interface for US Market Securities Transactions on the GSP Custody Platform to the Depository Trust Clearing Corp (DTCC).

GSP (Global Securities Processing) is a real time online multi-currency securities movement and controls system that tracks and reports securities positions including settled and unsettled trades as they are moved through BNY Mellon’s global sub-custodian network. It interfaces with BNY Mellon’s International Monetary Management System (IMMS) which reflects cash balances and currency positions as well as historical cash transactions and cash projections.

DVS (Depository Management System) is an application that serves as a Settlement Messaging Interface for US Market Securities Transactions on the GSP Custody Platform to the Depository Trust Clearing Corp (DTCC) for corporate assets; the Federal Reserve Bank (FRB) Fedwire Securities Service for government securities; and for physical securities.

GSP and DVS are two (2) of the major systems that are greatly involved in this Project since both are passing data to each other via MQ and batch process before they send data out to external parties. Several Change Requests (CR) were created by Business to accomplish the goal of the Fed ACAP Project. Was assigned to work on Change Requests CR48, CR69 and enhancing all DVS programs impacted by the Fed ACAP Project.

Responsibilities in few of the Changed Requests (CR) components of the ACAP Project.

CR48 – participated in system planning. Created technical design from high-level business requirements. Changed and tested online CICS COBOL programs using VSAM files to add data entry functionality on REPO and LEND dates so that DVS will allow Operation User to setup independently two (2) dates (REPO-ACAP-DATE and LEND-ACAP-DATE) on S620 screen. These dates trigger key processing logic in DVS and impacts settlement of large volumes of trades. A date is set if REPO/LEND-ACAP-DATE is blank or future business date and User enters a new future business date. An error is flagged if the value in REPO/LEND-ACAP-DATE field is today or past business date and User tries to update their fields. The program then LINK’s or XCTL’s to another program to display information, update certain fields or print report depending on the TRAN-ID that the User enters. This change will enable GSP accounts to start using new transaction types (Borrows, Collateral) without impacting Fed Market Settlement as DVS introduced new tracking/reason codes to support Loans/Borrows transactions Conducted peer code review. Participated in upper-management overall project changes review. CR48 was implemented successfully to Prod on March 17, 2023.

CR69 – participated in systems planning. Created technical design from high-level business requirements. Changed several programs, copybooks, control cards and PROCs to accommodate changes in the POSition input file transmitted from external party, BDC (Brooker Dealer Clearing) transmitted to DVS. This change request is due to the new data requirement of TLM-ERU System (external downstream system) for additional amount fields coming from DVS. To accomplish this, BDC changed their input file record format from 3 records of 80 bytes length record to 4 records of 80 bytes length record. DVS process these POS input file records creating an enriched file for TLM-ERU with 12 new amount data fields. POS output files and corresponding copybooks were expanded due to the new requirement. Unit tested the changed job stream process using files received from BDC to ensure accuracy and completeness. Conducted functional & regression testing of changed COBOL programs. Coordinated with User to request BDC to send file for use in in unit/system test. Conducted peer code review. Participated in upper-management overall project changes review. CR69 was successfully implemented to production in April 2023.

Other DVS batch and online programs Impacted by Fed ACAP Project – since new borrow codes are introduced to the DVS system, regression and functional test were conducted to twelve (12) COBOL programs by creating test data based on program logic used as input records to produce the desired output files and/or reports. During batch unit testing PROCs, JCL, control cards and VSAM files were used. These reports can also be accessed online.

During online unit testing, some CICS programs just need file set up via INSYNC based on program logic to test the change. Some CICS programs need CICS TRAN-ID to be invoked to create the file needed, others, need MQ messages received to test the CICS program being changed. Coordinated with the User during UAT since she has to invoke a CICS Transaction to set up her own file that invokes another CICS Transaction to display the entered information by printing the report online to verify if the program change is correct. Conducted code review. These programs were successfully implemented to production in April 2023.

CANE Project – Custody Account Number Expansion Project

Account number of all DVS systems have been expanded from 6 to 8 digits as part of the mainframe modernization initiative. Was a member of the Team designated to accomplish this task. Was assigned with many COBOL and CICS programs to be changed for different systems. Unit tested each batch and online program by system. During batch unit testing PROCS, JCL, control cards and VSAM files were used to produce the desired outputs and/or reports.

During online unit testing one system used online DUS system (dedicated to a specific region) to receive data via MQ from external party (BDC) in real time used as input to process trade settlement transactions. If there are no input data coming from BDC, the input file is created manually based on program logic by using a CICS TRAN-ID (existing system) to invoke the program to write to the QUE to test the changed CICS program. Other systems just need to invoke CICS TRAN-ID after setting up the input file using INSYNC based on program logic to test the changed CICS program. The changed programs either LINKs or XCTLs to another program depending on the TRAN-ID entered by the User or being passed. Participated in peer code review. Supported the successful implementation of the project in production on Nov 2023.

EPLX Environment Project

Was one of the 5-Team members tasked to work on the installation of all jobs to set up the EPLX UAT environment as part of BNY Mellon’s modernization project to create several test environments which are assigned to different systems to be used for UAT (User Acceptance Testing) of which EPLX environment is one of them.

Matlen Silver Inc., Somerville, NJ 09/29/19 – 03/28/2021

Programmer Analyst

Client was Bank of America Merril Lynch, Hopewell, NJ

GBR - Global Bookkeeping Repository is the source of client financial data for many of the global utilities initiatives. This repository consolidates client financial data (activities, holdings, tax lots and balances) into one source regardless of entity, region, product, currency, etc. The repository also has Trade Date, Settle Date and Real-time views. Consumers of the data include MyMerrill, Global Wealth Management, Global Wealth Investments Management (GWIM), Managed Accounts, Retirement, Statements, etc.

GBR Enhancements: Analysis, design, program development/enhancement, unit/end-to-end/integration testing, QA & production support using COBOL, DB2, JCL, PROC, CICS & utilities to perform development work in

an agile environment. Also used UACR to balance the records in the input and output files for batch process. Verified test results.

System Maintenance - Worked on system performance enhancements of various GBR systems by streamlining the Trade Date, Trade Settlement, Non-Trade, ATLAS online transaction processes in interfacing with accounts processing (AP) group. Analyzed and changed existing process flow and programs to achieve design requirements for an efficient process. Participated in peer code reviews. Conducted unit and integration test of all process components using VSAM files. This will be implemented on May 12, 2021. The streamlining process led to the development of new process and programs to create files needed to insert into the HAC DB2 table. This enabled efficient and quicker turnaround time for downstream processes. Supported the implementation of the new HAC process on February 5, 2021.

IIP (Integrated Investment Platform) Project - encompasses mainframe and distributed processes in the Global Wealth Management System where IBM builds an integrated financial platform.

-Analyzed the integration process and modified COBOL, DB2 program to add Private Bank (BANA-P) accounts into the GBR process flow for Trade Date, Trade Settlement, Non-Trade, ATLAS online transaction. UACR rules were changed to accommodate BANA-P accounts. Conducted unit and integration test with accounts process (AP) group to ensure that changes are good when GBR interfaces with AP. This change is currently running in QA.

-Analyzed and developed a separate process to integrate BANA-P into the GWIM (Global Wealth Investment Management) system flow. COBOL/DB2 programs and UACR rules were modified based on requirements.

-Conducted unit and system test to ensure correctness of the change. All components are currently executing in QA.

-Another component of IIP project is integration testing with IBM on the mainframe conversion of the P&I (Principal & Income) process into java. A process was developed, new COBOL/DB2 program was written to reconcile P&I number of shares and/or corresponding holdings against the Master file so that any mismatch flags the record as out-of-balance

Development of new and modifications to existing programs have to undergo SonarQube Scan & Code Coverage to ensure that bugs are mitigated prior to production deployment as part of operations standards.

Seven Seven Softwares, Rockaway, NJ 10/15/18 – 6/30/2019

Programmer Analyst

Client is Bank of New York Mellon, Jersey City, NJ

DVS - Depository Management System is an application that serves as a Settlement Messaging Interface for US Market Securities Transactions on the GSP Custody Platform to the Depository Trust Corp Clearing (DTCC) for corporate assets; the Federal Reserve Bank (FRB) Fedwire Securities Service for government securities; and for physical securities.

CICSPlex Project -

DVS application is using specific CICS commands that needs remediation when transitioning to CICSPlex configuration in order to remove CICS Affinities like ENQ, DEQ, START TS QUE and others. Affinity is a characteristic of an application that constrains transactions to run in a specific region and prevents dynamic workload distribution in a CICSPlex environment.

Responsibility: Member of the Team who conducted analysis to identify the COBOL CICS programs with affinities using eclipse and IDIP. The Team submitted a spreadsheet containing programs with affinities sorted by affinity to the

Project Manager which was the basis in changing programs to remove the affinities.

GSF - Global STIF Project (Short Term Investment Funds) is a global sweep engine that facilitates the movement of cash to various destinations based on a client's directive and manage client's "idle" cash balances and limit their overdraft

liability.

Money Market Reform EU Project for Short Term Investment Funds (STIF)

GSF has introduced a new type of NAV (Net Asset Value) named 'DNAV'. This type of funds can trade only when the price is available for the value date of the trade. For EU Money Market Funds, a number of funds have decided that they will change their funds so that they will set a price at night then use that price as the price that all trades trade for the following day.

Responsibility: Analyzed and changed COBOL CICS DB2 program to validate NAV date, price and source to call new COBOL CICS SQL/DB2 programs. Also developed these new COBOL CICS SQL/DB2 programs to calculate the current date trade as well as the future date trade based on the trade value date, current business date and NAV date. Tested and verified results. Supported its successful implementation on May 25, 2019.

Mitchell Martin, New York, NY 10/8/2017 - 6/13/2018

Programmer Analyst

Client was Bank of America Merrill Lynch, Hopewell, NJ

SEPS – Systematic Email Processing Services is the processing of emails for GWIM (Global Wealth Investment Management) application clients pertaining to trade confirmations, trade alerts, notices, update to client accounts information and other communications regarding client financial transactions using COBOL5, DB2/SQL, CICS, VSAM, JCL interfacing with web service application using .NET.

Responsibility: System maintenance and development.

-Analyzed system based on new business requirements. Changed and code impacted programs using COBOL/DB2 program. Created test script to unit test. Conducted code review and UAT. Successfully implemented to production the changed programs.

-Supported SEPS application daily production activities as to various client inquiries raised by business. Participated in system and low-level design, QA plan and test script walk through. Analyzed, streamlined and changed the EFail logic to simplify the process as required.

-One of the team members that modified SEPS system to catch specific errors from different web servers that feed SEPS which caused emails to fail. Analyzed and developed new purge DB2 program based on requirement to delete rows greater than 7 days from the log table which is created via CICS online process to reprocess failed emails. Created the map for data entry process. Used Agile methodology to get specification changes and track on daily status. Supported its implementation on June 8, 2018.

Assistant Vice President (AVP)

Bank of America Merrill Lynch, Hopewell, NJ 8/5/2011 - 6/22/2017

AMFS –Asset Management Financial System is the processing platform for Wealth Cash Management Account (CMA) application. CMA is a full-service and self-directed brokerage account that offers integrated investment, banking and lending solutions to clients. It is a mainframe COBOL5 application with DB2 database.

Responsibility: Participated in system planning, system analysis, design (functional & technical), program development/enhancement, unit/integration/system/regression testing, QA/production support using COBOL, DB2, JCL, PROC, CICS, SP, MQ, BMC utilities, FM, Debug Tool. Attended training for idZ programming as part of mainframe modernization geared towards using Java in program development and processing. It was found out later on that Java cannot handle huge volume of data, unlike, mainframe.

Worked as part of the team tasked in the development of new system, enhancement and/or modification to existing systems based on requirements from the Business Users. Participated in system planning, analysis, design (functional and technical), participated in peer code review and SIT/QA test plan walk through. Created test plan and test script which is the basis in validating test results. Used IBM utilities, BMC, File Manager, online debug tool during unit testing. Coordinated with onshore and offshore colleagues in supporting every deployment to production to ensure BAU. Collaborated with external teams during User Acceptance testing of SP programs both online and batch to ensure that results are good to obtain their sign-off. Coordinated with peers from external teams and Systems Assurance during QA run in the event that external files are not received to avoid failure of QA scheduled jobs that will adversely affect downstream processing. Supported applications which use MQ that scoop transaction records for batch processing to be passed to downstream jobs in QA and prod. During system test, CICS region where Checks MQ exists is checked to ensure that there are MQ data since checks processing is the first to run. In case of MQ job issues, program is checked among other things then referred to respective developers for resolution. Monitored QA and SIT run and supported each successful implementation in production. Projects worked on.

Move Money Transfer Inquiry – is an interactive tool to retrieve information about the money that has been transferred from one account to another using confirmation # and date as the key upon invoking the TRAN-ID.

Analyzed and gathered business user requirements and designed system requirements software (functional design), created technical/detailed design documents, developed/coded new BMS map and new online program using BMS map, CICS, COBOL5, SQL/DB2 that displays pertinent information as to who-created, who-cancelled, who-updated the transfer and when. The program also LINKs to other CICS programs to get other required information. Used TMON to verify the program definition in CICS to make sure that they are all successfully defined in QA and production.

Free Credit Balance Project – is a regulatory mandate to implement the quantitative liquidity requirement consistent with the liquidity coverage ratio (LCR). The project addressed the issue where the Free Cash is overstated because the settled cash balance of each individual account is not adjusted (reduced) by its outstanding obligations. Conducted system analysis and of impacted programs. Assisted in the design and developed new COBOL5, SQL/DB2 program/PROC/JCL for Ready Assets process which is one of the components of the project. Successfully implemented to production on August 5, 2016.

Preventing Trade-Through Violations in Restricted Amounts Project – is the inclusion of the pending trade amount in the calculation of the open-to-buy or available amount for withdrawal. Changed various DB2 & CICS programs and stored procedures (SPs) for batch and online to get the pending trade restriction amount from Brokerage Authorization needed for processing using COBOL5/DB2/SQL/CICS. Data is passed to external teams calling our SPs. Analyzed and created stub program to test the SPs. Coordinated with external groups that call our SPs for integration testing in batch and CICS. Supported the successful implementation to production on May 13, 2016.

Money Movement Notices Project – creates a file feed used to send letters to the clients regarding recurring transfers initiated either from the branch or call center. It also includes information of standing instructions of transfers that are deleted, cancelled/suspended or updated. Analyzed and developed new program using COBOL, SQL/DB2 to address this requirement. Successfully implemented to production on April 22, 2016.

Reg 23 Project – enhancements were made to conform to government regulations. Analyzed and changed stored procedure (SP) program to close transactions that are more than 45 days. Developed a stub program to test this SP. Created test script based on different conditions. Supported its implementation on March 2014.

Money Movement Project – is the transferring of money between brokerage accounts to bank or external party and vice-versa thru different channels, ie. branch, IVR, online (My ML) and call center. Analyzed and developed new COBOL, SQL/DB2 program to create YTD Monthly Retirement Report file where transactions are coming from the branch (WMW) and call center (FSVC) then send the report to the Users thru email using SMTP. Successfully implemented to production in Feb 2014.

Money Movement Retirement Project – developed new online CICS COBOL5 DB2/SQL called program that checks if an account has a retirement distribution standing instruction or if a recurring transfer exists in the database. Analyzed and developed new online stub program to unit test the new online program. Used TMON to verify the program definition in CICS to make sure that they are all successfully defined in QA and production. Coordinated with external team who calls the program during QA testing.

Also developed daily retirement distribution report without programming, just JCL. The report is sent to the Users as an email attachment using SMTP and ICETOOL to extract the required information from a file originating from another process that access DB2 table. Successfully implemented to production on Dec 6, 2013.

Mobile Check Deposit Project – is a process where clients can deposit their checks directly to their brokerage account using their mobile device such as an iPhone. Analyzed and modified various COBOL5, SQL/DB2 programs as per requirements. Created test plan and script during unit testing using MQ data where checks are put and verified results. Coordinated with Checks team to put checks transactions data in MQ during System Integration Testing. This is to ensure that CICS region where MQ exists contains data for the application to get since Checks processing is the first to run during SIT which are then fed to downstream jobs for batch processing. The project was successfully implemented to production in Dec 2011.

Involved and implemented many other different projects.

Modis, Piscataway, NJ 07/9/2009

Contact this candidate