SUMMARY

Senior Programmer/Analyst with extensive experience in full-life cycle management writing application software, data analysis, data access, data structures, data manipulation, databases, programming, testing and implementation. Designed technical and user documentation, software conversions and effectively managing project teams. Skilled in COBOL, CICS, JCL, DB2, SQL, VSAM, MQ Series, SAS etc. Extensive experience with SQL Server in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity. Areas of expertise include customer service and support, application and requirement analysis and process improvement and documentation.
Supported the existing enhancements of the Global Securities Processing (GSP) Securities Settlements System (SSS) and Income Servicing System (Corporate Actions' Dividend/Interest events) online and batch systems. The major tasks of the SSS system were to track the transaction life cycle of trades settled by BNYM on behalf of clients that have contracted for global custody services, to keep records of security holdings, to accept trade instructions from clients and to provide reports to Securities Operations for monitoring and control of securities movements.
Applications included: Global Securities Processing Settlements and Income Servicing; Dividends; Domestic Loans; Policy Transactions Systems; Stock Over the Wire; Safekeeping; Vault, Automated Customer Account Transfer Service, Transfer Initiation.
The most recent projects included:

• "Auto-Verification" project which allowed automatic verification of deliver type transactions that failed verification due to insufficient position shares from "Unverified" status to "Check" at time of verification of receive type transactions. The project substantially reduced manual interference in trade processing.
• "Auto-Referral" project which allowed automatic creation, verification, settlement and modification of security transactions based on incoming instructions from the bank sub-custodian system and increased STP rate for Receive VS Pay and Receive Free trades.
• "Broker Master Data Base(BMDB)" project which allowed for the bank to have only one entry point for trading and clearing brokers, thus eliminating necessity for the GSP to maintain its own Broker Master and provided GSP with real time updates of broker data.

TECHNICAL SUMMARY

HARDWARE: IBM Mainframes, IBM 9000/3090/43xx, ES-9000, IBM PC Compatibles
OPERATING SYSTEMS: MVS/390, MVS/ESA, Z/OS, IBM TSO, WINDOWS and UNIX, DOS, VISTA.
LANGUAGES: COBOL/COBOL II, JCL, CICS, ASSEMBLER/MACRO, SQL, SAS, EASYTRIEVE, Java Script, C#.
SOFTWARE: COBOL II, CICS, VSAM, ASSEMBLER/MACRO, MVS/OS390, IBM z/OS /JCL, TSO/ISPF, IBM Utilities, SyncSort, FTP Utilities, SMTP Utilities, DB2xx(SQL, SPUFI, QMF), FILE-AID, OMEGAMON, MQ Series/BMW, NDM, BMS, XPEDITER, Intertest, CEDF, ABEND-AID, ENDEVOR, MACRO4xx (FreezeFrame, InSync, TraceMaster, DumpMaster), Database SQL Server 2005 Enterprise, OPC, DOS, SAS, Changeman, EASYTRIEVE, BDAM, Java Script, C#, .NET, Lotus Notes, Microsoft Office Suite (Word, Excel, Power Point), Visio, Access.
TESTING TOOLS: XPEDITER (batch and on-line), MACRO4xx (FreezeFrame, InSync, TraceMaster, DumpMaster), OMEGAMON, InterTest, CEDF, CEBR, ABEND-AID, FILE-AID.

EXPERIENCE:

Confidential, New York, NY, 1998 - 2009
Position: Sr. Programmer/Analyst

• Innovated a system that sent messages to e-mails to Lotus Notes automatically on abnormal termination of jobs in a batch mainframe environment. The system used SMTP tools. Created batch performance improvements for this innovation using COBOL, ASSEMBLER and JCL utilizing VISTA system.
• Created and implemented multiple batch performance improvements and online enhancement initiatives on MQSeries/BMW for the Global Security Processing (GSP) department.
• Collaborated in 'GSP - ATP OUTSOURCING PHASE 2 - GSP00483' project created by a merger of the Bank of New York with Mellon Bank. Developed plan of actions as well as coordinated resources to meet objectives and established priorities to meet goals.
• Led "GSP - CG SO.450 DEPOSITORY MOVEMENTS" project. This project combined securities trade processing between SMDB (Security Master Database) System, Portfolio Services System (PSS), Global Security Processing (GSP) and Domestic Security Processing (ASP) systems. New programs, maps, database objects, ESDS,KSDS,RRDS files and reports were produced using CICS, COBOL, JCL, DB2/SQL, VSAM, MQ Series.
• Collaborated on multiple conversion projects (JP Morgan, Mellon Bank, Prudential Brokerage, etc) to synchronize the data to the BNYM standards. Instructed and effectively worked with on-site/off-shore outsourcing resources, end-users in Brussels, London, Far East and UAT testers to ensure delivery of the best possible product.
• Conducted multiple conversion projects effectively working directly with users in domestic and overseas departments (UK and Belgium). Responsibilities included program/system analysis and design, coding, debugging, unit testing, UAT support, implementation and production support of development projects and system corrections. Created, scheduled, maintained and executed batch jobs in OPC in development environments. Prepared program/system design specifications based on business/functional requirements, documented test cases and their results in compliance with SDLC. Developed new and enhanced existing CICS screens, coded new and modified existing Cobol/DB2/CICS modules, built and changed PROCs, created control cards, ran jobs, and submitted production implementation requests.
• Led "GSP- IIC Narrative Remapped Repo_GSP00378" project which involved seven major applications: INFORM, GTM, ASP, PSS, GSP, MIDYS and MERVA. This project included preserving in the Incoming Message File for the next day IIC unverified trades from the previous day. Developed and accomplished all stages required by the SDLC. Programs were written in CICS/COBOL/ASSEMBLER, utilizing DB2 tables and VSAM ESDS,KSDS and RRDS files and run in a batch and on-line environments.
• Built a proven track record for producing quality deliverables for the Securities Settlement System by providing effective support for production problems and troubleshooting resolutions.
• Collaborated in maintenance of SWIFT Incoming and Outgoing Messages Processing System, Instruction System, GSP Report System, Stock Loan System and Block Trades Settlement System. These systems involved in the creation, verification, settlement, finalizing or reversal and cancellation of the Receive Free, Deliver Free, Receive Versus Pay, Deliver Versus Pay, Stock Loan and Stock Loan Releases transactions.
• Represented GSP and Security Settlement System in the Disaster Recovery Testing. Provided 24/7 production support for both online and batch systems to satisfy Service Level Agreements (SLA) on a timely manner. Scheduled, maintained and executed jobs in OPC. Monitored critical, time-sensitive, and highly visible batch; made sure that key jobs were running on time, responded to situations including jobs being flagged late, upstream or downstream problems, and job abends. Reported to internal users on any systems issues, and closed problem tickets once they have been addressed.
• Was responsible for the creation and modification of weekly, monthly, quarterly and annual reports. This includes: Record Keeping Services (Transfers), Proxy Services, Cash Dividend Services, Stock Dividend Services, Corporate Actions, Dividend re-investment, Direct Registration, Dividend Reinvestment Direct, Issuance, Restricted Stock Plans, Employee Owned Shares.
• Was responsible for the creation of daily statistical risk reports for upper management for the analysis of bankrupt banks: Lehman Brothers, Washington Mutual, etc. All reports and data analysis were performed utilizing COBOL, SAS - Statistical Analysis System and Easytrieve.
• Participated in design, development, implementation, maintenance and production support of Event Setup, Client Profile, Security Profile, Shareholder Profile and Proxy Projects. Coded and tested applications for Dividends, Reinvestment, Stock Split, Proxy Voting, and Tax Reporting. Created programs for Investor Mailbox Proxy systems that include proxy mailing and vote processing to help thousands of public companies and mutual funds worldwide communicate and conduct business with shareholders.

Confidential, Russia, 1994 - 1996
Positions: Business Analyst/Project Manager.

• Prepared statement of work, cost benefit analysis, risk assessment, project and resource plans, and managed project communications at all levels of the organization.
• Facilitated sessions with development, business, and executive teams to elicit and analyze needs and defined system specifications, prepared gap analysis, documented and defined business requirements, functional specifications, workflows, data models and data migration, and wireframes and designed concepts, interacting with development teams to ensure successful development of requirements.
• Created QA and UAT test strategies, including regression and integration testing, wrote test scripts, end-to-end testing scenarios and test plans, managed testing, defect reporting and change requests.
• Planned and coordinated system releases with business, technology and infrastructure teams.
• Developed, documented, and implemented new processes and procedures across multiple business groups.
• Oversaw resolution of system issues through first line production support and coordination with technology teams.

1993 - 1994
Positions: Data Base Administrator.

Responsibilities included:

• Created, modified, maintained and optimized SQL Server Database
• Scheduled and monitored all maintenance activities of SQL Server including database consistency check, and index defragmentation.
• Performed DBA duties including: database backups, restores, performance tuning, and capacity analysis
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL
  Server databases

1991 - 1993
Positions: SAS Programmer/Analyst.

Responsibilities included:

• Troubleshooting and quick problem resolving for critical Job runs.
• Led SAS data conversions from text, free form, COBOL files and other formats.
• Maintained and enhanced SAS-based tool to create disaster recovery files.
• Created SAS jobs to run after DASD backups, to create restore JCL.
• Created SAS reports on RMDS. Used SAS to create JCL files to migrate all RMDS reports to new platform via tape and routing to JES2 node and performed data analysis and statistics.

EDUCATION

BS/MS in Engineering and Computer Science
Certificate, Computer Programming, ASA Institute of Business and Computer Technology