
Yuriy Razgon
- IBM Mainframe Developer
- Sacramento, CA
- Member Since May 25, 2023
Yuriy Razgon
An Information Technology Professional with experience as a programmer/analyst including design, development, implementation, quality assurance and maintenance of projects (SDLC) carried out both in client sites as well as in-house projects. Background includes Batch and Online applications with good exposure to COBOL/ASSEMBLER (BAL), JCL and RDBMS, mostly working within IBM mainframe Z/OS environment, utilizing DB2 (UDB), SQL, CICS, VSAM (IAM) and TSO/ISPF including EXPEDITOR, INTERTEST, FILEAID, SYNCSORT, SPUFI, QMF, CHANGEMAN, ENDEVOR, PANVALET and MVS Utilities.
Technical Expertise:
Programming Languages:
COBOL II (10+ yrs), SQL (10+ yrs), ASSEMBLER (10+ yrs)
Applications:
Credit Card, Financial and Merchant Systems
Software:
JCL (10+ yrs), VSAM (IAM) (10+ yrs)
RDBMS:
DB2 & UDB(10+ yrs)
OLTP:
CICS (10+ yrs)
4GL:
Visual Age Generator (1 yr)
Tools & Utilities:
Fileaid, Expediter, Intertest, Syncsort, Changeman, Endevor, Panvalet, Librarian, TSO/ISPF, SPUFI, QMF, Platinum, Princeton, IDCAMS, FTP, NDM, IEBGENER, OPC, ZEKE
Software Development Methods:
Waterfall and Agile
Operating Systems:
MVS, OS/390, MS-DOS, Windows, UNIX
Hardware:
IBM 3090, IBM PC Compatibles
August 2013 - December 2017
IBM Mainframe Developer
California Department of Health Care
West Sacramento, CA
Developed and modified Medi-Cal online and batch applications for California Department of Health Care Services, managing by Xerox and IBM.
· Analyzed business requirements
· Created Technical System Design documents
· Developed Cobol programs
· Created and executed Unit tests
Environment: COBOL II, CICS, VSAM, JCL, TSO/ISPF, File Manager, Expeditor, IBM Debugger, Pan Valet, Endevor, Z/OS, MS Windows 7, MS Office.
November 2009 - February 2013
HP Sr. programmer
Division of Motor Vehicles
Sacramento, CA
Assigned by Hewlett-Packard to the Information Technology Modernization (ITM) project at the State of California Division of Motor Vehicles (DMV).
Conversion legacy California DMV Driver License applications (Assembler, Cobol, VSAM) to a modern ones (Cobol II, CICS, DB2).
Started as a COBOL developer. Converted to Assembler analyst.
· Analyzed legacy IBM Assembler programs (TLT)
· Developed and defined system requirements from legacy IBM Assembler programs
· Created appropriate technical documents for new Cobol programs (Transaction Design, Detail Module Design)
· Developed new Cobol programs for Driver License applications
· Created and executed Unit tests
· Fixed defects of new Cobol programs
Environment: Assembler, COBOL II, CICS, DB2, JCL, DMV’s Backend Framework, Endevor, TSO/ISPF, VSAM, QSAM, Expeditor, VIASOFT, FILEAID for DB2, SPUFI, Z/OS, MS Windows XP, MS Office, MS Excel, HP Quality Center (HP ALM/QC and HP UFT/QTP)
December 2007 - July 2009
Programmer/Analyst - consultant
Brown Brothers Harriman
Boston, MA
“Action World” - BBH investment application.
Developer for Action World 1.0 Notifications Defaults, Action World 2.0 Action Enrichment Pre-Payment Advice and Action World 1.0 to 2.0 conversion projects.
· Analyzed Cobol source programs and DB2 tables according to a business requirements.
· Developed CICS/Cobol/DB2/MQ programs for CICS background processing.
· Developed Batch/Cobol/DB2 programs for conversion process.
· Created and executed Unit Test Plans.
· Executed system tests.
· Participated in User Acceptance tests.
Environment: CICS, COBOL II, DB2, MQ, JCL, CHANGEMAN, TSO/ISPF, VSAM, QSAM, PQEDIT, SPUFI,INTERTEST, FILEAID for DB2, Z/OS, MS Windows XP, MS Office, MS Excel, Extra, Quality Center.
August 2004 - August 2007
Programmer/Analyst - consultant
Lowe’s Companies Inc.
Wilkesboro, NC
Lowe’s Special Order Sales System (SOS) Electronic Catalog improvement and GBI (Canadian stores) Finance Peoplesoft ERP Implementation.
Lead Analyst for Model Count Growth improvement project.
Developer for Market Specific Availability, SOS Express and GBI Peoplesoft ERP projects. Some developments were done using ODS (Object Distribution System) based on MQ series. All developments were done using SDLC/SOX (Sarbanes-Oxley Compliance) methodology.
· Developed Technical System Design documents.
· Developed Cobol II/DB2 Batch and Online programs, Jobs, Procedures and Control Lines.
· Modified APS Cobol and Easytrieve programs.
· Created and executed Test Plans, Test Cases and Test Scenarios for Unit, Regression, System and User Acceptance tests.
· Created Implementation Plans.
· Created Change Control documents.
· Created QA documents.
· Created batch schedule requests.
· Implemented developed items into production.
· Monitored developed items at first production run.
· Performed QA and Second Tester functions.
· Was involved in production support and production problem fixes.
· Actively interacted with ODS (MQ Series) support team.
Environment: JCL, TSO/ISPF, COBOL II, APS COBOL, DB2, VSAM, QSAM, SPUFI, QMF, SORT, BMC, CICS, TERADATA, XPEDITER, PRINCETON, LIBRARIAN, FILEAID, ZEKE, MVS Z/OS, MS Windows XP, MS Office, MS Excel, VISIO, ATTACHEMATE.
October 2003 - April 2004
Mainframe consultant
Citi Commerce Solution (CitiGroup)
Deerfield (North Chicago), IL
De-conversion project of Citi Private Label Credit Card System for commercial and consumer credit accounts to FDR. Member of Commercial Posting Team.
· Determined Jobs, Procedures, Control Lines and Programs involved in de-conversion process.
· Made changes of all involved items.
· Created and modified FTP and NDM jobs.
· Created Test Scripts, Test Plans and change control documents.
· Provided Unit and System Tests.
· Requested OPC (schedule) changes.
Billing Cycles and Credit Card Prefixes changes projects have been done for certain Citi clients.
Environment: JCL, COBOL, TSO/ISPF, CICS, DB2, SPUFI, INTERTEST, QMF, FILEAID, QSAM, VSAM, OPC/A, MVS OS/390, MS Windows 95, MS Office, MS Excel, RUMBA. IGS (IBM Global Service) environment.
September 2003 - October 2003
Consultant, Programmer/ Analyst
Sears
Hoffman Estate, IL
Developer for Command Restructure project of Sears Advantage Merchandising System for Batch and Online applications.
· Converted Cobol/Assembler I/O modules from VSAM to DB2
· Designed and documented test plans and test cases
· Executed unit and system tests
Environment: JCL, VS COBOL II, ASSEMBLER, TSO/ISPF, CICS, DB2, SPUFI, QMF, FILEAID, QSAM, VSAM, MVS OS/390, MS Windows NT, MS Office, Lotus Notes, Extra. IGS (IBM Global Service) environment.
April 2003
Student
Experian
Shamburg, IL
· Accessing transactional databases course based on Direct Data system.
August 2001 - December 2002
Mainframe consultant
Citi Commerce Solution (Citigroup)
Deerfield (North Chicago), IL
Development and maintenance of the legacy Citi Private Label Credit Card System (former Sears Payment System) for commercial and consumer credit accounts. Member of Consumer Posting Team. Responsibility included Requirements analysis, Design, Coding, Unit Testing, System Testing, User Acceptance testing (requirements validation).
· Analyzed, created, changed, debugged, tested (unit, regression) and implemented into production legacy and new COBOL (Batch and CICS) programs for DB2 and VSAM (IAM) files.
· Created and tested embedded SQL COBOL codes replacing legacy VSAM (IAM) access method for Batch and Online environment.
· Created and executed Unit Test Plans and Test Cases.
· Created, modified and tested Production JCLs (jobs, procedures) and control lines for IBM Utilities to fix production problems and for new development.
· Performed System and Acceptance Tests by running parallel Production Batch using Test Environment.
· Intensively used SPUFI, QMF, FILEAID, INTERTEST and MVS Utilities (IDCAMS, IEBGENER etc.).
· Used QUIKJOB to fix some production problems.
Environment: JCL, COBOL, TSO/ISPF, CICS, DB2, SPUFI, INTERTEST, QMF, FILEAID, QSAM, VSAM, MVS OS/390, MS Windows 95, MS Office, MS Excel, Personal Communications, RUMBA. IGS (IBM Global Service) environment.
February 2001 - July 2001
Developer
Bureau of Technology Management Department of Corrections
Madison, WI
Development of Integrated Corrections System.
· Created Triggers and SQL Stored Procedures on Procedural Language (PL/SQL) using DB2 UDB and Platinum products.
· Created COBOL programs using MQ Series.
· Created Test Scripts, Test Plans and change control documents.
· Provided Unit and System tests.
Environment: DB2 UDB on Window NT, MVS OS/390, Platinum.
July 2000 - January 2001 Developer
Developer
Vital Processing Services, Columbus, GA
Vital Merchant Accounting System development. VITAL was a joint venture between TSYS, Inc. and VISA International.
Programmer/analyst for Online (CICS) Re-engineering of the Merchant Processing based on the TS-1 Credit Card Processing System. Re-engineering involved conversion of Legacy Online ASSEMBLER (CICS) programs to COBOL using Visual Age Generator for COBOL.
· Designed from scratch and developed the Online process utilizing VisualAge for COBOL using 4GL, GUI, TUI, DB2 UDB, CICS, VSAM, mainframe MVS tools and utilities.
· Created test scripts, test plans and change control documents.
· Provided unit and system tests.
Environment: JCL, ASSEMBLER, COBOL, VISUAL AGE GENERATOR, 4GL, TSO/ISPF, CICS, DB2, EXPEDITER, FILEAID, ENDEVOR, SYNCSORT, QSAM, VSAM, MVS OS, MS Windows NT, MS Office, MS Excel and Extra for SNA Server.
August 1999 - January 2000
Programmer
Continental Graphics, Culver City (Los Angeles), CA.
Production support for Continental Graphics.
· Created, changed, debugged, tested and implemented new and modified existing programs for legacy Boeing Computer System. The programs written on ASSEMBLER and COBOL for ISAM and QSAM files.
Environment: COBOL, ASSEMBLER, DOS VSE/ESA (CONDOR).
April 1999 - July 1999
QA tester/analyst
IBM/Detroit Edison, Detroit, MI
Participated in Y2K conversion for the Detroit Edison Power Billing System.
· Performed testing, debugging, and modification of programs initially checked and changed by IBM programmers for Year 2000 compliance.
Environment: COBOL, ASSEMBLER, DB2, CICS, VSAM, JCL, PANVALET, TSO/ISPF, FILEAID, and Utilities for OS MVS.
March 1997 - March 1999
Programmer Analyst
Total Systems Services Inc, Atlanta, GA.
Participated in Y2K conversion for TSYS Credit Card Management System TS-1.
· Identified date-related places in programs, JCLs and Control Lines (Cards).
· Analyzed, modified and tested ASSEMBLER and COBOL programs utilizing VSAM for CICS and BATCH.
· Analyzed, modified and tested production JCLs and Control Lines.
· Created test scripts, test planes and change control documents.
· Provided unit and system tests.
Environment: JCL, ASSEMBLER, COBOL, DB2 IMS, VSAM, TSO/ISPF, Easytrieve, Rexx, Expeditor, CICS, FileAid, Endevor, SyncSort, QSAM, MVS, MS Windows, MS Office, MS Excel, Lotus Notes and Extra for SNA Server.
September 1996 - February 1997
Programmer Analyst
Total Systems Services Inc, Columbus, GA.
Participated in conversion of legacy Credit Card Management System.
· Conversion of legacy Credit Card Management System TS-1, written in ASSEMBLER and COBOL for CICS and Batch using VSAM files as a database, to new system TS-2, written in COBOL II for CICS and Batch with DB2 and IMS.
· Created from scratch conversion Assembler programs for testing the BankCard System.
· Performed analysis and creation of flowcharts for production programs.
Environment: JCL, Assembler, COBOL, Easytrieve, Rexx, Expediter, CICS, FileAid, Endevor, SyncSort, QSAM, VSAM, MVS, MS Windows, MS Office, MS Excel, Visio, and Extra for SNA Server.
March 1990 - August 1996
Lead Software Specialist
Kermit, Ltd., Riga, Latvia
· Created from scratch, developed and maintained databases and programs for Warehouse Keeping for Wholesale and Retail Trade companies.
· Currency Exchange, Code Accounting, Credit against Goods and Privatization Certificates Management applications were created for Latvian banks.
Technical environment included use different PC’s environment as Windows, MS-DOS, OS/2, UNIX (SCO) and SQL Server. Most applications were created on FoxPro and Oracle.
July 1985 - February 1990
Lead Software Specialist
Latvian SSR Planning Committee Special Design Office of Vacuum Coating, Riga, Latvia
Worked in the Automated Systems Design Department.
· Created and managed databases using ASSEMBLER, COBOL, FORTRAN, PL1 with DB2 for IBM/370, and C with INGRES under UNIX (PDP-11, VAX-11).
· Various database creation and development.
September 1974 - Jun 1984
Lead Programmer/Analyst
Scientific Research Institute of Microdevices Riga, Latvia
· Computer systems creation and development for design and production process automatization of Integral circuits measurement.
· Actively participated in Integral Circuits Computer Design System development and implementation.
Technical environment included use ASSEMBLER, COBOL, DB2 and FORTRAN IV/77, PL1 for OS (IBM/360) and for RDOS (Nova/Data General). Access methods BDAM, ISAM.
Red Banner Institute of Civil Aviation Engineers (Computer and Automation Faculty), Riga, Latvia
B.S. in Electrical Engineering. 09/69 – 07/74
Latvian State University Computing Center, Riga, Latvia
Assembler Language Course. 01/79 – 06/79