Cobol DB2 CICS Programmer/Analyst
Resume:
Lydmila Gorelik
Reisterstown, MD 21136
Home 410-***-****
Cell 443-***-****
E-Mail ************@*****.***
SUMMARY
I offer more than twenty years of experience in information technology, including software development and business analysis. Experienced working both independently and in a team-oriented collaborative environment. Well-developed problem solving skills, result-oriented, willing to learn new technologies and teach fellow team members.
TECHNICAL SUMMARY
Programming Languages:
IBM COBOL, OS/JCL, EAZYTRIEVE, ACUCOBOL, HPCOBOL, MICROFOCUS COBOL, FORTRAN, SQL, PL/SQL, HTML, XML, REXX.
Operating Systems:
Z/OS, OS/390, MVS, UNIX, Microsoft Windows, MPE, MS-DOS.
Hardware:
IBM Mainframe, UNISYS, HP-3000, IBM-PC.
Databases:
DB2, Oracle 10i, Microsoft SQL Server, Microsoft Access, Sybase, HP Image.
Utilities and tools:
MVS Utilities, VSAM, CICS, TSO/ISPF, MQ Series, CA-7 Scheduler, FileAid, AbendAid, Xpeditor, Endeavor, Panvalet, SPUFI, QMF, DB2 Stored Procedures, SyncSort, Bourne Shell, Korn Shell, Informatica, Intellimatch, TOAD, WinSQL, DbVisualizer, InterTest, Finalist, Powerhouse (Quick, Quiz, QTP), HP QUERY, MICROFOCUS Animator.
Desktop applications:
Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Office Visio.
EXPERIENCE
October 2015 – Present: CMS, Baltimore, MD
Position: Contractor Sr. Cobol/DB2 Programmer. Contract with Lockheed Martin IT.
Project Highlights
Contract with Social Security Administration (SSA) to support and maintain DDAP (Division of Disability Appeals Processing), CPMS (Case Processing Management System) and Legal Analysis Workload System (LAWS).
My responsibilities include supporting of the Database Application Development Branch (DADB) system including maintenance, development and testing of the following applications:
Data Generation System (DGS) CICS/DB2 back-end programs;
CPMS Query CICS/DB2 back-end programs;
CPMS TA (Table Administration) CICS/DB2 programs.
May 2015 – October 2015: CMS, Baltimore, MD
Position: Contractor Sr. Cobol/DB2 Programmer. Contract with Lockheed Martin IT.
Project Highlights
Contract with Social Security Administration (SSA) to support and maintain CATF (Control and Audit Test Facility) system.
My responsibilities included maintenance, development and testing of the CATF system using COBOL, JCL and TSO/ISPF.
My assignments included:
Running daily and monthly data sets backup jobs and updating Excel spreadsheet with statistics;
Creating address data reports by request of SSA OSCAR (Onsite Security Control and Audit Review) office/component. The reports were used to conduct reviews and included MBR (Master Beneficiary Record), Title 2 ORSIS address data and MES (Modernized Enumeration System);
Creating monthly exception reports for Operational Support Units (OSU);
Updating, compiling and testing of Supplemental Security Record (SSR) COBOL programs.
Designed and developed:
oA new REXX program to create a list of monthly backup data sets. It helped to avoid manual errors when updating the existing CATF jobs and saved maintenance time;
oA new SAS program to generate the missing backup report;
oNew reports using the Vision: Results Report Writer.
August 2008 – December 2014: DB NET, Linthicum, MD
Position: Contractor Sr. Cobol/DB2 Programmer. Contract with IBM IT.
Project Highlights
Contract with Center for Medicare and Medicaid Services (CMS) to maintain RAS (Risk Adjustment System) and RAPS (Risk Adjustment Processing System). The systems process Medicare part A, B, C and DME claims data.
My responsibilities include maintenance, development and testing of the RAPS system using COBOL, JCL, DB2, TSO/ISPF and Endeavor.
I was involved in development of requirements, design, programming, testing and development of system documentation for ICD-10 (International Classification of Diseases, Tenth Revision) project.
For this project I was closely involved in creating new complex job schedules and in automation of existing jobs. I set up new NDM processes, performed unit and system testing, worked closely with CMS NDM and scheduling teams as well as with other partners. I created scheduling flowcharts using Microsoft Office VISIO. While researching tools and utilities for my programming assignments I learned basics of REXX and CLIST. My assignments included:
Writing new programs and maintaining existing COBOL programs based on user requirements;
Developing DB2 Stored Procedures to update DB2 tables;
Downloading and retrieving DB2 data using BMC and IBM utilities;
Writing SQL queries to validate or research test and production data using BMC and IBM utilities;
Performing data validation using Excel macros.
October 2006 – April 2008: TEK Systems, Woodlawn, MD
Position: Contractor Programmer/Analyst. Contract with Northrop Grumman IT.
Project Highlights
Contract with Center for Medicare and Medicaid Services (CMS) to maintain Medicare Beneficiary Database system (MBD).
Designed, developed and maintained the Environment Management Support (EMS) Microsoft SQL Server Access database to control and schedule life cycle test activities.
As a member of the testing team I was involved in integration testing of the consolidated CMS inquiry system. My responsibilities included creation of new test cases, maintaining Oracle test database, creation of test data, creating and executing queries to validate results. In order to perform these tasks I had to communicate and coordinate testing activities with developers, business analysts and end-users.
Maintained infrastructure for project development and testing including DB2, Oracle, CICS, MQ Series and Endeavor.
March 2006 – October 2006: APEX Systems, Woodlawn, MD
Position: Contractor Programmer/Analyst/ Contract with Lockheed Martin Corporation.
Project Highlights
Contract with Social Security Administration to develop business documentation of Social Security Administration Account Receivable System.
My assignment was to perform analysis of Returned Check Action (REACT) Processing Operation business processes. My responsibilities include:
Reviewing of existing on-line and hard-copied documentation
Interviewing SSA business analysts and programmers to get relevant information about the process.
Translating COBOL program source code into business requirements.
Creating Visio flowcharts and Microsoft Word documentation.
March 2000 – February 2006: Care First Blue Cross Blue Shield, Owings Mills, MD
Position: Programmer Analyst
Design, development, maintenance, documentation and production support of the Provider System in Maryland and National Capital Area.
Project Highlights
Provider Data Migration Project
Developed business and technical specifications for database load process.
Developed CICS services for SOA oriented, web based Provider portal applications.
Developed and modified PL/SQL programs for loading of Oracle tables.
Project hardware: IBM Mainframe, UNIX
Project software: DB2, Oracle 9i, VSAM files, COBOL, CICS, MQSeries, PL/SQL
Provider Data Integration Project
Developed and maintained a system to synchronize Oracle tables on mid-tier with DB2 and VSAM files on Maryland and DC mainframes using MQ transactions.
Project hardware: IBM Mainframe, UNIX
Project software: DB2, Oracle 9i, VSAM files, COBOL, CICS, MQSeries, PL/SQL
Unified Service System Project
Developed technical specifications, mapping documents, and Subject Matter Expert documentation of the Provider systems.
Project hardware: IBM Mainframe, UNIX
Project software: DB2, Oracle 9i, VSAM files, COBOL, PL/SQL
HIPAA Project
Wrote claims adjudication program utilizing COBOL and DB2
Project hardware: IBM Mainframe
Project software: DB2, VSAM files, COBOL, CICS
Provider System Enterprise Data Warehouse Integration Project
Developed Provider data extract programs, retrieving data from VSAM files and DB2 tables to feed the Enterprise Warehouse.
Project hardware: IBM Mainframe, UNIX
Project software: DB2, VSAM files, COBOL, CICS, Intellimatch
EDUCATION
1974–1978 Mechanical Design College, Kiev, USSR
Diploma: BS. Degree with major in Computer Programming.
1995 – 2006 In-house Professional Training:
Service Oriented Architecture
Oracle 9i SQL and PL/SQL
MQSeries Application Programming
CICS Command Level Interface
DB2 SQL Performance and Tuning
SAS 8 Application Programming
Microsoft Word, Access, Excel Classes
Hewlett Packard MPE/iX Computer System Training Course
1987 - 1988 Institute of Advanced Technology
Computer technology classes
Contact this candidate