System Analyst/ Developer

yuriy zhuravlev

* **** ***** • West Windsor, New Jersey 08550

**************@*****.*** • 609-***-****(c)

Summary

IT professional with extensive experience in wide variety of finance and business applications and ability to quickly adapt to a variety of environments and languages and changing workloads. Proven experience with z/OS, TSO, CICS, DB2, QMF, SQL, FILEAID/DB2, IBM SPUFI, TWS, COBOL, REXX, Endevor, Changeman, BMC tools, ICETOOL, File Manager, SORT, HP Quality Center, XML, HTML, CA-7, and WEBSPHERE. Strong analytical skills. Knowledge and experience in DB2 performance and tuning. Experience in installation and configuration IBM products (RDZ, Eclipse). Extensive record in 24/7 Production support, production issues resolutions, QA testing, and weekend and emergency implementation.

Professional Experience

Bank of America. Pennington, NJ 9/2016 – 12/2016

Senior System Analyst/ Developer

Provide support for UAT testing of financial applications.

Review business / system requirements and create detailed test scripts / test plans using predefined processes and procedures

Design, create and run process by using COBOL, DB2, and JCLs to extract data from production and load to test region. Identify critical points of process to extract data for validation. Create and run data extract process by using COBOL, DB2, and JCLs in test region to validate data before and after changes.

Create test cases for users to review for aproval. Create and run data extract process by using COBOL, DB2, and JCLs in test region for to extract data for validation and comparetion, create reports for users for aproval.

Create detailed test scripts and create and run JCLs to provide regression testing with big amount of data.

Report all system defects found during testing

Support periodic weekend and off-hour software releases.

MORGAN STANLEY, New York 6/2015 – 6/2016

Senior System Analyst/ Developer

Provided production support to several financial application: Money Movement, Money Transfer, Credit Cards, and Checking Accounts.

Reviewed coding in long running programs and provided changes to improve performance using COBOL, DB2, VSAM, and CICS.

On the business users requests, created multiple ad-hoc reports using JCL, TSO, SORT, ICETOOL, TSO, and REXX.

Reviewed and supported production implementations

Validated and test communication processes between mainframe and distributed environment after production implementations.

Reviewed and approved processes for “out-of-cycle” production installations.

Provided support to Disaster Recovery tests including switching operations between two Data Centers.

Reviewed supported applications schedules and usages of resources, made corrections to prevent production issues.

Created Data validation process to prevent production abends due to the invalid input data.

Built Error alert process to notify developers of issues in various log files.

ALKIRA INVESTORS, New York 5/2013 – 5/2015

Contractor

Provided production and maintenance support to the company’s mainframe based applications. Revised several processes to address performance issues.

Build and managed data export/import processes from mainframe to the distributed systems.

Build and managed tables, tables relations, and data.

Executed regular support requests for all SFDC instances including configuration, user administration and security matrix maintenance, data management, reports and dashboard development.

Implemented Formula fields and Roll-up summary fields.

Applied Validation rules to maintain data integrity.

Created Workflow rules and Workflow Actions, created and configured Approval processes and Assignment Rules to support Business Processes.

Created various reports and dashboards for custom and standard objects to provide detailed overview of renewals, balances, and forecasting.

Provided maintenance support and administration services including data cleansing.

Evaluated and installed third party applications from the Salesforce AppExchange.

Imported and exported data using Data Loader, Import Wizard and weekly Export.

Utilized agile methodologies in system analysis, design, and development.

CITIBANK, Long Island City, New York 11/1995 – 5/2013

Senior System Analist/Developer

Provided around the clock production support and software development to ensure the accurate delivery of financial statements for Citibank consumer, Private Bank, and business accounts nationwide by using COBOL, DB2, and CICS. Interfaced with internal and external customers to gather requirements and deliver high quality software that consistently meets business needs.

Design major system enhancements, conduct software design review and code analysis sessions, and participate in QA testing to ensure error-free coding and defect-free installations. Utilized agile and waterfall methodologies in system analysis, design, and development.

Key Projects:

Using DB2 for data processing to create statements. Create and maintain DB2 table to improve application performance.

Responsible for the development, implementation, and production support statements’ “merge” application.

Designed and implemented new “check image” function.

Build processes to support multilingual, business, and Consumer statements; to assemble data for the Private Banking Group statements.

Revised application’s architecture to add DB2 table to split data to improve DB2 performance for the business statements with more than 6K pages.

Demonstrated significant commitment by regularly working nights, weekends, and holidays to successfully deliver projects on schedule.

Responsible for the statements’ part of the Retirement Product Services (RPS) redesign project.

Performed business analysis and wrote requirements for the RPS project data sources, completed data mapping.

Improved performance efficiency by redesigning processes for large volume of transactional data.

Developed several procedures to support data migration to the Web based applications.

Revised statements’ process to prepare data for the HP Extream Formatter. Wrote specifications for the new statement format.

Prepared test cases and project’s documentation. Organized training sessions for the application users.

Created automated email process for sending financial reports as attachments.

Designed and developed processes to print “I-1099” statements and to request statement re-printing.

Participated in design and development of Statements On the Web (SOW) system to produce bank statements for businesses and customers upon request.

Created on-line and batch programs to accept orders, collect archived data, generate statements in PDF format, download them from mainframe to a server using IP address, and to notify customer via e-mail (CICS, DB2, COBOL).

Responsible for the development and maintenance of the CitiGold statement system.

Expanded system by adding new functions: automatic rendition process and in-house printing for XEROX printers (COBOL, ADABASE, NATURAL).

Developed programs to gather business data from the mainframe database and load it to the Oracle Database using SQL*LOADER.

IT Consultant, Various New York locations 03/1993 – 11/1995

Interfaced with a diverse range of financial industry clients to complete sophisticated application and system development projects within budget and ahead of schedule. Provided full scale technical support and guidance to developers, users, and project stakeholders.

Key Projects:

Spear, Leeds & Kellog – Applications Consultant

Participated in creating COMMODITIES ON-LINE TRANSACTIONS system that provided interactive editing, audit trails, and record keeping. Designed and developed several on-line and batch programs (COBOL, CICS, DB2).

Developed programs to support Future Trades and Treasury Bills addition and cancellation processes (COBOL, DB2).

Wrote on-line menu driven programs with screens which allowed users to add, update and delete information and facilitated up and down loads of various financial data (COBOL, CICS).

Strengthened operations through the software system design, coding, and testing. Provided 24/7 on call support.

Kidder Peabody – Applications Consultant

Participated in creating COMMODITIES ON-LINE TRANSACTIONS system that provided interactive editing, audit trails, and record keeping. Designed and developed several on-line and batch programs (COBOL, CICS, DB2).

Developed programs to support Future Trades and Treasury Bills addition and cancellation processes (COBOL, DB2).

Wrote on-line menu driven programs with screens which allowed users to add, update and delete information and facilitated up and down loads of various financial data (COBOL, CICS).

* * * * * * *

Technical Proficiencies:

Systems: WINDOWS, UNIX, LINIX, OS/MVS/XA/ESA, TSO/ISPF, SALESFORCE.COM

Languages: COBOL, REXX, ASSEMBLER, C, VB, APEX, VISUALFORCE

Software: CICS, BMS, SDF, IBM UTILITIES, VSAM, PANVALET, EXPEDITER, FILE-AID, INFOMAN, CHANGEMAN, JCL, MICROFOCUS WORKBENCH

Databases: tableBASE, DB2 (SQL, SPUFI, QMF), ACCESS, EXCEL, ADABAS (NATURAL)

Interoffice communications: MS OFFICE (POWERPOINT), LOTUS NOTES, MS OUTLOOK.

Education and Training

MS in Mathematics

Voronezh State University, Russia

Professional Certification:

SalesForce.com Certified Administrator (ADM201): #1685792

Contact this candidate