Ms Office Analyst

Jim Kerns

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

Phone: 812-***-****

Evansville, IN 47711

Email: ******@******.***

Through years of experience managing my own business and adding value to

employers, I have proven my skills in supervision, coaching, problem

solving and relationship building.

_______________________________________________________________________

Demonstrated expertise in the following areas of IT.

Specialized IT SKILLS:

Machines: IBM 30XX, 43XX, 390

Languages: SQL, PL/SQL, COBOL, CICS, PL/1, Assembler

Utilities: EASYTRIEVE, TOAD, FOCUS

JCL & Operating Systems: OS/MVS, DOS/VSE

Databases: DB2, VSAM, Oracle 9i and10g, UNIX

Program access: TSO/ISPF, ICCF

PC: MS Office

______________________________________________________________________

EXPERIENCE:

Volunteer Work while looking for work

12/2007 - Present Volunteer at various agencies

Trustee for St Paul's UCC church

United Caring Shelter (day shelter)

Set up Access programs for staff use

Boy Scouts

Habitat for Humanity

University of Southern Indiana

1/2000 - 12/2007 Programmer/Analyst - Banner system

Sept 2005 - Dec 2007 Converted mainframe data to

client/server. Wrote new scripts for State Financial Aid on

the Banner system, using SQL and PL/SQL. For this

application I also used Shell Scripts and Stored

Procedures. Updated Degree Auditing program using

microfocus COBOL. Web modifications (added HTML statements)

for Registrar's Office, MS Office for reporting.

Jan 2000 - Aug 2006 Maintained existing COBOL CICS programs

and wrote new ones for Financial Aid and Degree Auditing,

using ICCF, on VSAM files.

American General Finance

2/1995 - 12/1999 Senior Programmer -

Analysis and programming for Marketing, Accounting and

Government reporting, using COBOL, CICS, TSO and DB2.

Created and updated JCL as needed. Operating system of

OS/MVS, Changeman

Lincoln Service

7/1992 - 2/1995 Operations Supervisor/Computer Programmer -

Mortgage Corporation

Designed, wrote and implemented improvements to the online

and batch Mortgage Loan system using PL/1 and Assembler,

updated JCL as needed with TSO. Supervised operation

employees.

Let's Party

9/1990 - 6/1992 Owner -

Party supply, wholesale and retail, party decorations and

balloon delivery.

Citizens National Bank

12/1980 - 7/1990 Senior Programmer/Analyst -

Responsible for DDA, Savings, Credit line, Fixed assets and

Accounts receivable systems using COBOL, CICS and

Easytrieve with ICCF. Made JCL modifications as needed.

Contact this candidate