Cobol Programmer Analyst

CAROL RUSS

**** ********* ***. (***) ***- ****

Cheyenne, WY 82009 adv8pw@r.postjobfree.com

OBJECTIVE: Employment as a COBOL Specialist utilizing my extensive experience in systems analyst, developing, programming, testing, and implementing computer systems. Strong problem solving, written and verbal communication skills and training techniques with IT personnel and end-users.

SUMMARY:

• Experience working with technology in all realms including working with teams and

independently; dealing with theory and concepts; conducting maintenance, system changes

and modifications.

• Designed, developed and managed large databases for multiple-user access.

• Extensive experience in developing and programming software solutions.

• Ability to solve problems with limited information and meet deadlines.

• Worked in the Windows, Server, UNIX, and mainframe environments using a wide

variety of software.

• Worked with Agile development methodologies especially Scrum.

SOFTWARE:

T-SQL, MySQL, SQL stored procedures, ETL, Windows NT Shell Scripting, COBOL,

DB2, JCL, VSAM, Intertest, Expediter, Endevor, Java, HTML, Oracle, Microsoft Office Suite,

Rapid SQL, SSMS (SQL Server Management Studio), SharePoint, PowerPoint

EMPLOYMENT:

ACS Inc. – Cheyenne, WY Dec 2010 – Present

Analyzed, enhanced and tested new and existing programs and job flows; using COBOL, VSAM, and CICS for the MMIS system for the Wyoming Department of Health utilizing the mainframe and SQL Server 2012 environments. Before putting the new programs into production, the enhancements made to them were tested. Used CICS/Expediter to test and debug CICS programs. Wrote test plans and documentation for the user. Analyzed the user’s data and responded to their requests.

Wyoming Department of Family Services – Cheyenne, WY Mar 2009–Nov 2010 Analyzed, designed, programmed and tested modifications and enhancements to the Parental Obligation System for Support Enforcement system using COBOL/DB2/SQL in the UNIX, Windows, SQL Server environment. The system is a statewide child support enforcement program responsible for establishing paternity, medical and child support orders; enforcement and modifications of medical and child support orders; and collection and disbursement of child support payments. Documented the changes and enhancements made to the existing system.

Blue Cross and Blue Shield – Helena, MT Dec. 2008 – Feb 2009

Analyzed, designed, programmed and tested modifications to the existing batch and online programs using COBOL/DB2/Ascential in a SQL Server/mainframe environment. Performed extract, transform and load duties for the SQL data warehouse. Using SQL wrote stored procedures. Designed and developed tables

for the data warehouse. Produced the appropriate documentation and notifications for changes made to production systems or fixes for production problems.

C. Russ; resume continued, page 2/2

Utah Department of Health – Salt Lake City, UT Dec. 2007 – Nov 2008

Analyzed, designed, programmed and tested modifications to the existing batch and online programs using COBOL/DB2 in a mainframe/Windows environment. Analyzed and wrote design documents to incorporate the new eREP tables and files into the existing old mainframe eligibility system; COBOL programs; JCL and PROC’s. Created and modified existing JCL and PROC’s. Wrote Oracle queries and stored procedures on the SQL Server. The changes and enhancements were documented to the existing programs.

ACS Inc. – Santa Fe, NM Sept 2006 – Aug 2007

Supported the Data Warehouse for the Medicaid System for the State of New Mexico. Wrote, enhanced and maintained the existing desktop systems and queries using Access, Rapid SQL, Cognos with Sybase on the SQL Server. Tested these desktops and queries and moved them into production. Talked to the users, analyzing there problems and concerns. Wrote documentation for these enhancements to the existing

systems. Supported the production and enhancements of the existing New Mexico Medicaid Management Information System. Analyzed, designed, programmed and tested modifications to the existing batch and online programs using COBOL/DB2 in a mainframe environment. Analyzed and identified problems in the system. Provided solutions for those problems. Wrote responses and produced correspondence for customer service requests. Created and tested JCL. Documented the changes and enhancements to the New Mexico MMIS as well as maintained system and user documentation.

Wyoming Department of Transportation – Cheyenne, WY Aug 2002 – Aug 2006

Analyzed and developed enhancements for the existing systems using COBOL/MYSQL/VB in a

Windows/mainframe/UNIX/Oracle 9i environment. Developed and programmed reports for the payroll and accounting personnel using their files and tables. Wrote SQL programs using stored procedures to convert files and develop reports. Developed and wrote the on-line portions of various systems using VB. Gathered information from the users on their systems for the development and implementation of the RFP.

Furr’s, Inc. – Albuquerque, NM Nov 1999 – Dec 2001

Analyzed, modified, enhanced and tested programs for the Order Processing, Bilback, File Maintenance and Statement Reconciliation reporting systems for the grocery stores using COBOL in a Windows/mainframe environment and SQL/Microfocus COBOL on the SQL Server. Wrote SQL programs using stored procedures to convert files and write reports. Wrote and modified JCL job streams in the testing and production mainframe environment. Wrote and modified shell scripts on the server in the testing and production environments. Did performance tuning on the SQL programs on the SQL Server. Developed and managed large databases for multiple-user access. On a daily bases, performed data storage and retrieval procedures including backups and recovery. Created the masks to download the mainframe files to build the tables on the SQL Server. On a daily bases, rebuilt the tables on the client/server. Performed database administrative duties for the SQL Server portion of the project. Used the UNIX platform to go back and forth from the mainframe to the SQL Server. Trained programmers in relational database theory and SQL.

Boeing, Inc. – Seattle, WA May 1997 – Oct 1999

Analyzed, modified, enhanced and tested programs for the payroll system using SQL/DB2/COBOL II

in a Windows/mainframe environment. Modified JCL job streams in the testing and production

environments. Wrote reports using SQL for the payroll and the SMS systems. Built a library of SQL

reports which met the needs of the managers. Trained the managers on how to obtain their desired

reports from the library. Developed new tables to enhance and maintain the system. Built new plans

and packages for the payroll system. Ran the JCL to bind and rebind the plans and packages for the

system. Trained programmers in programming techniques using SQL and DB2. Developed and

programmed systems in Java. Took classes in Java and Oracle.

EDUCATION

University of Wisconsin-Eau Claire, Eau Claire, Wisconsin

B. S. in Mathematics/Computer Science received

Contact this candidate