Mainframe analyst

ROMAN ILYASOV

**** ****** ***

Tarzana, CA *****

C: 347-***-**** ********@*****.***

SUMMARY

As a Senior Mainframe Programmer had 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, JCL, DB2, SQL, Imbedded SQL, VSAM, MQ Series, CICS, CICS Internal Structures, CICS Command Level Programming, Mainframe SAS written on IBM system, 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.

Had experience with the following projects/systems Financial System, Medical System, Student Information System, Vehicle System

As a Business Analyst, took part in designing, developing and troubleshooting of Programming Management Systems. The system was designed to meet financial and business needs of the company utilizing a number of complex screens, views and reports. Used in more than a hundred field offices around the world it was responsible for the maintenance of the organization’s financial workflow from allocations and approval of the funds to management of bank transactions and GL/PAR accounts.

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/COBOLII, JCL, CICS, ASSEMBLER/MACRO, SQL, Mainframe SAS.

SOFTWARE:

COBOLII, CICS, VSAM, ASSEMBLER/MACRO, MVS/OS390, IBM z/OS /JCL, TSO/ISPF,

IBM Utilities, SyncSort, FTP Utilities, SMTP Utilities, DB2xx(Imbedded SQL, SPUFI, QMF), IMS DB, IMS DC, FILE-AID, OMEGAMON, MQ Series/BMW, NDM, BMS, XPEDITER, Intertest, CEDF, ABEND-AID, ENDEVOR, MACRO4xx (FreezeFrame, InSync, TraceMaster, DumpMaster), Database SQL Server 2008 Enterprise, OPC, DOS, Changeman, Mainframe SAS, Outlook, Lotus Notes, MS SharePoint, Application Lifecycle Management (ALM), Microsoft Office products (Word, Excel, Power Point, MS Project, Visio, Access, etc).

TESTING TOOLS:

XPEDITER (batch and on-line), MACRO4xx (FreezeFrame, InSync, TraceMaster, DumpMaster), OMEGAMON, InterTest, SmartTest, CEDF, ABEND-AID, FILE-AID, File Manager, Fault Analyzer.

EXPERIENCE:

2015 - 2016

2014 - 2015

2014 - 2014

2012 - 2014

2010 – 2012

Position: Mainframe Lead - Contractor at Infosys with on-site job for TOYOTA in Torrance, CA

As a consultant I worked for Toyota in three departments: Staff Master, Dealer Daily and Vehicle.

Participated in production support in these three systems.

Lead Warranty Legacy System retirement project. Completed this project – retiring the part which sent data to Dealer Daily.

In Staff Master System which is corporate repository of Dealer Personnel data for University of Toyota, I created and updated the online modules which supported Global and US Toyota Dealer personal data.

I created/updated online source modules which were written in COBOL using IMS/DC Databases and DB2 tables. Also, I created and updated the corresponding elements in the following libraries: PSB, MFS, ACB, DBD.

Through the monitors users could browse, update, terminate existing staff and add new staff data.

The information written in IMS and DB2 databases were used not only for the online system but for the batch to create user's reports.

Dealer Daily is a department which was responsible for creation of daily reports using input written in DB2 databases which were created in all other departments and sent the daily reports by schedule or on request to users via WEB services.

In Dealer Daily and Vehicle departments I created and updated members of batch system: PROCs, JOBs, Control Cards and Batch programs which used IMS/DB and DB2 databases, flat files, VSAM files and MQ.

In these departments I supported the following applications: Toyota and Lexus Vehicle Sales, Part Orders, Material Orders, Daily and Monthly Inventory, Financial Statements, Warranty Claims, Registration Certifications and Used Retail Delivery Reports.

Also, made changes in SAS mainframe programs which created users Vehicle reports and I did changes for PROC’s steps which run SAS programs.

For testing and implementation of new and changed elements a Change Man tool was used.

For manual Edit/Browse/Extract/Load IMS Databases and DB2 tables the File Aid tools were used.

Position: Programmer Analyst - Contractor at UCLA

10920 Wilshire Blvd, Los Angeles, CA 90095

Performed update of PROC elements to replace utility programs to

bypass failing of job steps when users are not sending the data via FTP

Performed updates for various jobs to make all job steps dependent on successful or not successful completion of FTP step or predecessors steps

Performed changes for JCL elements to create production subdirectories in FX project for LIFETECH client

Performed updates for mapping in DICLIENT to limit the length of fields

Performed updates in FX Director for Hospital Epic Rename project for the conditions when input files are not exist

Created report for invoices with pending status for 3 years and over. Also, made a performance creating SQL program which produced the same report with the following improvements – resources was saved, the machine run-time was decreased

Participated in Disaster Recovery Testing performing monitoring the Batch and On-line systems.

Performed FX mainframe scheduling maintenance: removed from library outdated elements; included new elements; updated existing elements with fail operation codes

Position: Programmer Analyst - Contractor at COLLABERA 25 Airport Road Morristown, NJ 07960 with on-site job for IBM 840 Still Water Road, West Sacramento CA 95605

Project Description:

The Department of Health Care Services (DHCS) is responsible for administering Medi-Cal - California's Medicaid program. This is public health insurance Program which provides needed health care services for low-income individuals Including families with children, seniors, persons with disabilities, foster care, Pregnant women, and low income people with specific diseases such as Tuberculosis, breast cancer or HIV/AIDS

Responsibilities: -

Analyzed system to enable new eligibility program for children's medical services for San Mateo County.

Involved in gathering requirements and Co-coordinating with Client for discussing the technical business Impacts on the Requirements.

Involved in coding using COBOL – CICS – DB2 - SQL, JCL – Mainframe SAS Programs.

Involved in preparing Unit and Integration testing scripts for the CA-MMIS Mainframe Application.

The Bank of New York Mellon Inc., ZeroChaos Inc.

Position: IT Business Analyst - Contractor at ZeroChaos

1800 Gateway Drive, Suite 100 San Mateo, CA 94404

Worked on DST Reconciliation settlement positions and transactions reports based on a portfolio accounting system creating External Transactions Processing module of the system used to streamline and automate the process and workflow for external transactions between the controlling and paying offices from payment request to payment processing

Facilitated requirements by gathering workshops, having individual

interviews with stakeholders and subject matter experts (SMEs)

Created use case models and functional specifications based on

an evaluation of user requirements

Used various modeling techniques to create Use Case, Activity,

State Transition, and Data Flow diagrams

Collaborated with the technical personnel to determine optimal

solution architecture

Provided project status reports to IT and business management

units

Assisted QA team in developing test plans and relevant test

scenarios

Defined User Acceptance Testing criteria with users and

supported UAT of the system, including the triage and

prioritization of identified defects

Resolved and documented system enhancement and production

issues

Elicited requirements via JAD sessions, interviews, workshops,

existing system’s documentation and procedures review

The Bank of New York Mellon Inc., New York, NY

Position: System Analyst - Contractor at ZeroChaos with on-site job for BNYM in NY.

Key responsibilities:

Gathered business/user requirements and communicated them to development teams.

Performed document analysis, gap analysis, requirements workshops, business process descriptions, use cases, scenarios, business analysis, and workflow analysis.

Developed business and functional requirements

Provided mapping documents along with transformation rules for the applications involved in the development.

Analyzed functional and user test results, opens defects if necessary.

Actively managed change requests as required to ensure successful delivery of the project.

The Bank of New York, 101 Barclay st New York, NY 10286

1998 - 2009

Position: Sr. Programmer Analyst - Employee at BNY

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/imbedded 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.

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.

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.

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.

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.

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.

EDUCATION

BS/ MS in Computer Science, Touro College, New York, NY 2010

Combined BS and MS in Engineering, Tashkent University of Engineering, Tashkent, Uzbekistan 1992

Contact this candidate