PROFESSIONAL SKILLS

HARDWARE: SunSparc Work Station, Goulds, Minicomputer, IBM PC
OPERATING SYSTEMS: Solaris & BSD Unix, DOS 6.22, Windows 3.1, Windows for Work Groups 3.11, Banyan Vines 4.x, Windows 95, Windows NT, Novell
LANGUAGES: Visual Basic , Visual Basic for Applications, VB.net, Unix C Shell, C, C++, FoxPro, ObjectPal, SQL Server, PowerBuilder 5.0, DBASE III, Visual Basic , ASP, Clipper, Assembler, Pascal, Perl, Visual Basic for Applications Excel, Java, PowerBuilder
RDBMS: MS Access, MS Excel,SQL Server, Paradox, SQL Anywhere, Visual FoxPro
DB TOOLS: Erwin
GUI: Visual Basic 6.0, Visual Basic for Applications, ObjectPal, Visual FoxPro

PROFESSIONAL EXPERIENCE DETAILS:

Jun 07 - Present Confidential Cleveland OH
Database application and report development in Access and Excel with Visual Basic for Applications and SQL. Modified and created financial applications to process salary offsets and transfer data between various pay offices and Banks for Government travel card debts. Wrote requirements for modification to mid tier Applications which collected treasury debts from various pay offices. Created queries and reports on an Adhoc basis as required. Tested new military pay system interface with the salary offset program. Responsible for system troubleshooting and monitoring and data analysis of four database systems. Wrote documentation for the Travel Card Database Application.
Software: Access 2003, Visual Basic for Applications
Hardware: Pentium IV
OS: Windows XP

Dec 05 - Mar 07 Confidential Columbus OH
Ad Hoc Reporting, Excel Macros, AS400 Queries, Database and Report Development in Access with Visual Basic for Applications and SQL. Created the Percent off Clearance Access application which updated 3 huge spreadsheets of retail information on and calculated various metrics on a weekly
Basis. Created queries and reports on an Ad Hoc basis for various departments, and was responsible for running and trouble shooting all weekly and monthly reports in Access and Excel
Software: Access 2003, Excel 2003,Visual Basic
Hardware: Pentium IV, AS400
OS: Windows XP

Feb 03 - Dec 05 Confidential, Columbus, OH
Programming & Analysis
Designed and coded File Pickup Report System which used mainframe data and Access SQL and Visual Basic Scripting and Excel to generate formatted and sorted reports for Shipping Department, as well as a System to Access Data from various systems to track down missing files. Designed and coded file information database application to provide information and status on Mortgage loan files and generated productivity reports for Manganagement.
Designed and coded an underwriter rating database system that tracked underwriter performance on several compliance criteria and tracked this information from quarter to quarter.
Software: MS Access, Visual Basic for Applications
Hardware: Pentium
OS: Windows NT

Mar 97 - Feb 03
Independent Consultant
Apr 98 - Jan 03 Confidential, Columbus, OH
Programming & Analysis
Added a module which produces targeted, personalized promotional marketing materials. Fixed various bugs and expanded the functionality of the system with additional forms, reports and queries with embedded code. Provided hardware and software support. Also worked on a web page.
Software: Visual Basic, Java
Hardware: Pentium
OS: Windows 95

Apr 02 Confidential
Programming & Analysis
Member database application Troubleshooting and Consulting
Software: MS Access and Visual Basic
Hardware: Pentium
OS: Windows ME

Apr 02 Confidential
Programming & Analysis
Webpage design in Front Page
Software: Front Page
Hardware: Pentium
OS: Windows 95

Apr 99 - Jun 01 Confidential, Hilliard, OH
Programming & Analysis
Designed and coded a program for creating six types of inspection reports and a program for tracking warranty repairs.
Software: FoxPro 3.0 conversion to Visual Basic
Hardware: Pentium
OS: Windows NT

Feb 01 - Apr 01 Confidential, OH
Programming, Analysis & Web Page Design
Programmed a real estate search web site using ASP, and Front Page.
Software: Active Server Pages, Front Page
Hardware: Dell Pentium
OS: Windows Millenium

Sep 99 - Dec 99 Confidential Columbus, OH
Programming
Rewrote a Pascal check writing program in Microsoft Visual Basic.
Software: Visual Basic for Applications
Hardware: Pentium
OS: Windows 95

Aug 98 - Apr 00 Confidential, Akron, OH
Programming & Analysis
Fixed bugs in point of sale application, Added accounts receivable module to point of sale program, added code to prevent users from editing invoices that had already been transferred to accounts receivable. Created and accounts payable module.
Software: Visual Basic, SQL Server
Hardware: Pentium
OS: Windows 95

Jun 97 - Aug 97 Confidential, Delaware, OH
Programming & Analysis
Geoneft Database Conversion Program. Created a program to convert data from a database of geological abstracts to a format for import to a new database system.
Software: Perl
Hardware: Pentium, (Portable to Unix Midtier)
O/S: MKS Unix Emulator, Unix

May 96 - Aug 96 Confidential, Columbus, OH
Programming & Analysis
IWorked with the legal expert at Core solutions to modify the CobraTrack insurance tracking program to comply with new HIPPA regulations.
Software: FoxPro 5.0
Hardware: Pentium
O/S: Windows 95

Aug 96 - Feb 97
Consultant, Confidential, Columbus, OH
Jan 96 - Feb 97
Ohio Department of Aging, Columbus, OH
Analysis & Screen Design
Screen design for PASSPORT/RSS system which tracked contracts and services provided to Seniors to support
Software: PowerBuilder 5.0
Hardware: Pentium
O/S: Windows 95

Dec 96- Jan 96
In House Development
Screen Design and Coding OIBRS violations tracking for Department of Justice
Software: Visual Basic 6.0
Hardware: Pentium
O/S: Windows 95

Aug 96 - Dec 96
Confidential, Columbus, OH
Programming
Modified C++ programs which extracted data from Clipper database files in a sales forecasting system. Wrote Unix C Shell programs to check nightly processing runs.
Other Responsibilities:
Running and documenting monthly database realignment process
Running and documenting weekly new products load
Database and software trouble shooting
Software: Interbase, Think Systems, C++, C Shell, DOS batch files
Hardware: Sun Station, IBM 486
O/S: Windows 3.1

Jun 96 - Sep 96
Web Master, Citizens Protecting Ohio from a Six State Nuclear Waste Dump, Columbus, OH
Web Page Design
Designed and developed a Web Page
Trained staff in using database and Browser Software
Software: HTML, File Maker Pro, AOL Browser
Hardware: IBM 486
O/S: Windows 95

Apr 94 - May 96
Programmer Specialist I, The Ohio Department of Transportation, Delaware, OH
Programming & Analysis
Designed, Coded, Debugged and/or modifies the following Networked Data Base Applications:
Work List Program
Personnel Data Base Conversion Program
Small Tools Inventory Program
Accident Program
Training Program
Library Check Out Program
Other Responsibilities
Software Installation
Hardware and Software Trouble Shooting
User Instruction and Assistance Maintenance of district wide on-line and parts ordering system
Software: Clipper, Object Pal
Hardware: IBM 486, Pentium
O/S: Windows 3.1, Windows for Work Groups 3.11, Banyan Vines

Jan 91-Apr 94
Supply Systems Analyst, The Defense Construction Supply Center
Columbus, OH
Lead Programmer for Available Funds Project
Designed coded and debugged and/or modified C mid-tier programs and FoxPro GUI.
These programs calculates money available for stock replenishment from sales figures, and
Distributes it among projected buys according to item criticality.
Software: C, C++ FoxPro
Hardware: Goulds Mini Computer, IBM 486
O/S: BSD Unix, DOS 6.0

Lead Analyst for Customer Returns II Project
I led a team of item managers in designing requirements for an on-line reporting system
That provides information on stock return requests and allows managers to input decisions to accept for credit, accept without credit, or reject.
Programmer for Critical Item Review Project debugged, tested and modified C, C++ mid-tier programs and PC level PC level programs in Clipper.
These programs automatically create reports on items with procurement difficulties to be used
In briefings to DCSC's commanding officer.
Software: C, C++, Clipper, FoxPro
Hardware: Goulds Mini Computer, IBM 486
O/S: BSD Unix, DOS 6.0

Programmer for Key to Shared Processor Project
Debugged, tested and modified C, C++ mid-tier programs and FoxPro user interface.
These programs allow on-line viewing and entry of five decision transactions that previously
were entered on punched cards.
Software: C, C++ FoxPro
Hardware: Goulds Mini Computer, IBM 486
O/S: BSD Unix, DOS 6.0

Aug 87-Feb 88
Student Programmer, Confidential, Columbus, OH
Designed, coded, tested and debugged Pascal programs for automated check writing, database entry, mailing and billing
Software: Turbo Pascal, DBASE
Hardware: IBM 286
O/S: DOS 5.2

EDUCATION:
Bachelor of Science, Computer and Information Science, College of Engineering, Ohio State University June, 1992, GPA 3.2

PROFESSIONAL TRAINING:
Fast Track to PowerBuilder Environment
Transition to the PowerBuilder Environment.
Intermediate ObjectPal Application Development
Introduction to ObjectPal Application Development
C Programming
Unix Shell Language C++ Java