Andrew E. Osborn

303-***-**** **** Clay St.

aconjg@r.postjobfree.com

Denver, CO 80211

SUMMARY

Programmer/Analyst with fifteen years' experience analyzing,

designing, coding, and testing custom written programs to adhere to

business rules. Team player who communicates effectively with all

levels of the organization.

TECHNICAL SKILLS

COBOL II CICS JCL Oracle

DB2 Easytrieve TSO/ISPF VSAM

IBM Mainframe Java PL/SQL AS/400

PROFESSIONAL EXPERIENCE

Scottrade, Inc (CRI)

2008-2015

Westminster, CO

Programmer/Analyst

Analyzed COBOL programs to determine the business rules and to

re-write/restructure

using structured programming based upon these business rules.

Wrote online and batch programs to adhere to business requirements.

Modifications and enhancements to existing COBOL programs.

AddOns, Inc 2006-2008

Littleton, CO

Technical Consultant, Ellipse

Created COBOL programs and UNIX scripts for numerous

customers using Mincom Ellipse Software

Assisted clients with system conversions creating

and maintaining cross reference tables

Supported existing legacy systems before and during

system conversions

Determined required system changes and estimated

time to complete for proposal estimations.

Intrawest (Winter Park Ski Resort)

2005-2006

Winter Park, CO

Database Coordinator, Central Reservations

Gathered and interpreted data from Access reports

and Excel to compare previous years revenue and

reservation and room night figures to evaluate the

current fiscal year and budgeting

Prepared reports to establish individual and team

reservation goals

Devry University

2001 - 2005

Oak Brook, IL

Programmer/Analyst, Financial Reporting and Student

System

Completed a large project that converted a legacy

Mainframe and AS/400 COBOL system to an Oracle system.

Wrote COBOL and JCL programs, UNIX Scripts, and PL/SQL

procedures to load data from the legacy system into

Oracle.

Designed enhancements to link the legacy systems with

Oracle to decrease manual intervention.

Supplied enhancements to automate processes to move

data from multiple platforms to replace manual

processing.

Analyzed business requirements and provided technical solutions

and wrote custom programs for financial reporting and the student

system using PL/SQL and Oracle.

Researched and resolved software defects for in-house accounting

and student system programs.

Created system improvements for financial reporting and the

student system that improved operations efficiency.

Seabury & Smith (Marsh & 1999 - 2001

McClennan)

Chicago, IL

Sr. Programmer Analyst, Financial Reporting

Supported financial reporting and royalty payment COBOL programs.

Created and enhanced fixes and upgrades to custom written COBOL

programs.

Provided custom reports to Senior Management.

A.M. Castle and Company 1998 - 1999

Chicago, IL

Programmer, Warehouse Management System

Automated the inventory management system using COBOL to ensure

inventory numbers were accurate and that orders were correctly

processed.

Maintained the inventory system for the metal cutting optimization

software processes using COBOL.

American International Group (AIG)

1990-1997

Chicago, IL

Premium Auditor, Commercial Insurance

Performed financial audits of numerous companies to determine

correct insurance premiums.

EDUCATION

MASTER OF SCIENCE - PROJECT MANAGEMENT, Keller Graduate School of

Management, Chicago, IL - 2005

BACHELOR OF BUSINESS - FINANCE, Western Illinois University,

Macomb, IL - 1990

CERTIFICATES

Computer Career Program (COBOL, JCL, DB2) - DePaul University,

Chicago, IL - 1998

Introduction to SQL and PL/SQL - Oracle University, Chicago, IL -

2001

Oracle 9i Programming with PL/SQL - Oracle University, Chicago, IL

- 2001

Programming Certificate (Java, C++, C, VB.net, PL/SQL) - Front

Range Community

College, Westminster, CO 2012 - Present

Contact this candidate