Mainframe Programmer/Analyst

EDUARD GELFAND

*** **** ***., ***. *** Cell: 917-***-****

Brooklyn, NY 11224 ******.*******@*****.***

SUMMARY

Highly dependable and results-oriented professional with progressive information systems experience. Special expertise in programming, technical writing, systems analysis, mainframe applications design and implementation. Able to provide innovative solutions to complex technical issues. Excellent Customer Service skills and Business Partner satisfaction ratings.

A loyal and thorough individual with strong communication and interpersonal skills and who works well independently as well as in a team. Quickly adapts to changing environments with flexibility, while working for organizations with rapid growth and change.

TECHNICAL EXPERIENCE

HARDWARE: IBM 3090, 3033, 370/158, IBM PCs and Compatible.

SOFTWARE: COBOL2/LE, MVS JCL, TSO/ISPF, OS/MVS/XA, Cloud Platform, z/OS Connect, JSON, CICS, DB2/SQL, VSAM, MQ Series, DB2 Stored Procedure, SYNCSORT, FILEAID, SAS, Easytrieve, COMPAREX, XPEDITER, INTERTEST, CHANGEMAN, ENDEVOR, LIBRARIAN, FTP/SFTP, NDM, INFOMAN, Service Now, Actuate, PRF, Detector.

PROFESSIONAL EXPERIENCE

UPS, Payroll Department, Wayne NJ / Matrix Inc. 09/2019-Present Sr. Programmer/Analyst

Responsible for supporting Payroll Processing Module (PPM). PPM is a radar modified system that computes net pays for final payment to all employees in US, Canada and Puerto Rico.

Developed Automated time cards load process from Activity and Recording systems into Payroll mainframe application. Utilized Cobol, DB2, CICS, dynamic JCL.

Modified Payroll process to adjust overtime payment for CA and AK employees to comply with the Fair Labor and Standards Act (FLSA). Utilized Cobol, DB2, Detector,

DB2 Stored Procedure, CICS, JCL.

Provided impact analysis and made updates to replace BMC load/unload DB2 utilities by IBM product.

Citigroup Wealth Management,

Jersey City, NOC7, NJ / Mitchell Martin Inc.

09/2009-08/2019

Sr. Application Programmer/Analyst, Security Master Central (SMC)

Was responsible for building infrastructure to process and normalize internal and external vendor data feeds and messaging streams for SMC. SMC is a centralized multi-vendor financial instrument and issuer platform that supports increased product coverage, regulatory and cross-offering requirements across markets and asset classes. Interfaced with different departments within the Citi and Vendors regarding new deployments.

Developed a Real Time Interfaces (RTI) using API Restful calls from Cloud Platform via Web Sphere/zOS Connect/Jason/Web CICS to Mainframe for different Market products, such as Fixed Income, Equities, Options, Money Market, Commercial Papers, Certified Deposit, TRACE eligible and other utilizing MQ Series, CICS, DB2, DB2 Stored Procedures, COBOL, VSAM, JCL, SDLC.

Participated in development/modification of modules for different projects related to OFAC/AML policy. Modules enabled Red Flag these transactions that may involve money laundering and have to be approved/rejected by a designated AML Compliance Officer. Maintained a list of OFAC countries and its new sanctions to apply.

Designed DB2 modules to identify, map and cross reference Alternate IDs for the same product to consolidate them in a DB2 table and create a feed for other Citi businesses. That helped easily identify a corresponding product if there is any production issue.

Designed RTI for Prime Finance/Broker group to provide SMC reference data for securities of interest (SOI) and changes for a new Setup, Delete, Update and Corporate Action events happened in SMC at real time. A daily reconciliation feed was also provided at the end of batch cycle.

Created batch and on-line modules to accommodate Conversion projects for Pershing, Broadridge and Morgan Stanley. For Stock Record migration to Broadridge worked on sourcing that data from other systems to continue support BAU process.

Participated in various mid-term projects such as: converted transmission jobs from FTP to NDM for internal and external Clients, provided SMC end-of-day and Historical pricing feeds, prepared multiple Cleanups and Purge securities jobs, produced numerous daily and ad-hoc reports, released a number of One-time jobs and SPUFI to fix batch and front-end production problems.

UBS Wealth Management, New York, NY

2000-2008

Sr. Associate, Product and Pricing Database (PRDB)

Participated in various projects for new development, enhancement, maintenance, production and post-production systems support using COBOL2, DB2, CICS, JCL, VSAM, JSP/Servlet technology.

Developed a process to validate and update data from Security Master File and PRDB DB2 tables to support Bridge Forward Process for Collateralized Debt, Mutual Funds, UIT and other products. Led to increase data integrity, enabling modules to minimize its contention and production runtime at the batch critical path. Supported various projects related to Corporate Actions.

Created Auto-setup process to convert securities from merged firms such as Piper Jeffrey, McDonald Investments and other. Managed refreshes of daily Cross reference files for QA testing within the firm.

Designed COBOL2/DB2 modules to consolidate holding securities in a separate DB2 table and a flat file for Holders project. This effort significantly reduced the processing time for DB2 calls, improved turnaround time of Ad hoc requests for business partners and was very useful for developing new modules.

Developed CD product descriptions generator modules, which enable users automatically, generate security descriptions at its setup in PRDB system.

Coded DB2 Stored Procedures to pass data to Java front-end application.

PriceWaterhouseCoopers, New York, NY

1997-2000

Sr. Programmer/Analyst, UPS Billing Department

Involved in Euro Currency Project for International Billing System to support an automatic

Conversion of Local currency into Euro as shared currency for the EMU (European Monetary Union) nations.

Wrote logical and physical system changes based on new business requirements.

Prepared Impact analysis of COBOL2/DB2/CICS programs, JCL’s and PROC’s required for modifications.

Provided UAT and System Integration tests, Implementation and Production support.

Took part in the full Life Cycle Project for Billing System to charge a shipper the adjusted residential or commercial rate. UPS was able to recover losses about $100M annually.

Had extensive user Interface to identify the origin source document.

Developed new Job streams including various Control reports broken down by regions and districts.

EDUCATION

Bachelor of Science in Engineering and Computer Science:

Technological Institute, Kiev, Ukraine.

Certificates of Completion: Java Developer Boot Camp and Actuate e-Report Designer.

IBM Learning Center Classes: DB2 Stored Procedures and MQ Series.

Contact this candidate