jhoff@intnet.net
LANGUAGE SKILLS:
OFFICE SUITES:
MS Office for Windows 95 and MS Office 97 & 2000,Corel WordPerfect Office
for Windows 95, Ms VSS,OLEDB,N-TIER,Visio,Visual Studio,Visual Studio.net,Magic,Clearcase,blackbox testing
DATA BASES:
I
St. Petersburg, Fla . Over 80 medical billing centers were converted. IAMS was an ASP for hundreds of billing centers. I used MS Remote Desktop in conjunction with SQL Server Enterprise Manager 2000. I converted about
100 billing centers databases from Btrieve and Access 97 to SQL Server. Extensive use of Backups, Restores and
DTS imports/exports (about 500 of each).
4/2002 -
Senior Programmer - Full-time
This project involved extensive database conversion coding using Visual Basic 6.0 of a Btrieve
medical billing system to a SQL Server 7.0 Data center database in Orlando. This involved
extensive use of Btrieve call and ADO connections to a SQL server database.
I was heavily
involved in on-line retrieval and testing and end-user testing. Also extensive use of SQL
Server Enterprise for database updates and stored procedure creation. . Over 80 medical billing centers were converted. I was an ASP for hundreds of billing centers. I used MS Remote Desktop in conjunction with SQL Server Enterprise Manager 2000. I converted about
100 billing centers databases from Btrieve and Access 97 to SQL Server. Extensive use of Backups, Restores and
DTS imports/exports (about 500 of each).
centers were converted.
FLORIDA POWER-DCI.,St. Petersburg, Florida 1/97- 4/97
Client/Server, Oracle, SQL Server, Access, IMS DB/DC, DMSII, FoxBase,
Clarify, Business Objects, Paradox,
Ms Sql Server Enterprise Manager,Dos,DTS import/exports
UTILITIES:
EASYTRIEVE,ROSCOE,FOCUS,INTERTEST,CANDE,LIBRARIAN,SQL Plus,Toad,Sheridan
SQL Loader,Videosoft Controls,clearcase
Oracle Browser,MS Outlook,Wise Install Master,Robohelp,Blackbox testing
TELECOM:
CICS,3270 Emulation,HLLAPI,Netview,and PcAnywhere,HIPAA
RECENT CLASSES:
DB2/SQL Application Programming, Platinum Technology(Computer People),
April,1993,Certified Novell Administrator ,
May 1994.,Programming in MS Visual C++ 4.0 (DCI-March 1997),
EDUCATION/TRAINING:
Bachelors of Science, Physics-University of Washington, 1973
Bellarmine Prep School,Tacoma, Washington
Computer Programming and Operations-ITT Computer Institute
DB2/SQL-Platinum Technology (Computer People),1993
Rexx/CMS-St. Petersburg Junior College,1987
Unix and "C" Language-St. Petersburg Junior College,
1986 Oracle-St. Petersburg Junior College,
1994 Novell CNA School-Tampa, Fla.,1994
C++-(Computer People) DCI-Clearwater, Fla- March 1997
OCP Intro to Oracle 9i Sql ===Icubed April 2002
Oracle 9iDB adm 1--Icubed May 2002
Oracle 9iDB adm 2--- Icubed May 2002
Oracle Preformance Tunning ---Icubed June 2002
SPECIAL PROJECT:
Worked for FRANKLIN EQUITY MUTUAL FUND in doing
portfolio analysis in DBASE III+.
This involved calculating a three year moving average
of the price/earnings ratio for each of the stocks
in the Standard and Poors 500 (S and P 500) stocks universes,
and grouping those ratios into quintals (1/5).
We then weighted the growth rate of earnings for these
stocks over a 5-year period and grouped
those into quintals.
We then took the PE ratio and divided this by the growth rate,
thus getting a measure of
"how much do you pay for a stock's growth."
The FRANKLIN EQUITY MUTUAL FUND then invested and even
dollar amount starting at $1 million in the top 50 stocks that met this
criteria, held these stocks for one
quarter (three months) and then performed this calculation again ("re balanced").
Using my software this
mutual fund was one of the top performing equity mutual funds
for the period from 1982 to 1988,
and the net asset value of the fund grew from $200
million to about $3 billion.
PROFESSIONAL EXPERIENCE:
Tampa, Florida 9/2001-present
On Temp assignment using Visual basic and Access for a medical company dealing with workmens comp.
Heavy new development coding and design for a national workmen's comp and managed-care provider company.
This project written in VB6 with OLE documents,ADO data controls and grids
and heavy use of server(network)based Access tables is a complete front-end
customer view of manager care providers with all demographics and repricing data.
Approximately 40 different modules and approximately 20,000 lines of VB6 code.
Extensive SQL COMMANDS.and heavy installation coding using Wise Install Master 9.0.
VERIFONE,Clearwater, Florida 12/97-2001 (Layoff/Merger)
Analyst/Programmer
Lead Analyst/Programmer in charge of developing,
testing,writing installation programs for embedded
systems-PC's attached to POS terminals for
monitoring sales at gas stations and convenience stores.
I used
VB 4.0 extensively and light VC++ and Crystal Reports.
I also developed installation programs using Wise
Solutions to test/install the software on all variants
of Microsoft Wndows from windows 95 to Windows NT and
Windows 98.
We used serial and remote (modem) communications for
pulling sales Data and gathering
reports.
Awards: GEM (Going Extra Mile) - 2000
WILLIAM R. HOUGH,
St. Petersburg, Florida 9/97 - 11/97
- Found a job closer to home
Visual Basic Programmer
Responsible for coding,testing,and documentation
of a new security processing system.
This system would allow account executives to review security
positions,trades,production and
customer account balances for securities
such as Municipal funds,etc.
It was written in MS Visual Basic 4.0
using RDO controls tied into SQL Server 6.5 databases..
WORLD COLOR PRESS, Tampa, Florida 4/97 - 8/97 - downsized-dotcom bomb-dot com gone
Oracle Database Engineer
This job entailes creating dynamic HTML
web sites using Platinum SQL
Station embedded inside of HTML,CGI and Javascript.
Our clients included Lucent Technologies, Paradyne
and Spiegel catalogues.
Extensive data modeling (S-Designer) using physical
data models and Oracle packages.
These web sites allowed customers to place orders for
telephone,routers,etc.
using an extensive
search of online database with graphics images and catalogues.
The web sites ran on Sun Solaris servers.
WEB SITES WE DESIGNED:
SPIEGEL,
JBUTLER,
LUCENT,
OUR WEB SITE:
ADVANTA,
PARADYNE,
AVON
Some of their other clients are :
Bantam Doubleday Dell,Ford Motor,Forbes,Tech Data,
Disney,Blockbuster
Entertainment,Johnson and Johnson,Honeywell Space Systems,
Oshman's Super Sports, AirAge Publishing,
Bellsouth,Bellsouth Olympic Kiosk.
Senior Programmer Analyst, Systems Development-
(3 months-Cont. Temp Position)
I programmed in MS Access 2.0 tied in with Oracle 7.1 databases
on Windows NT 3.51 servers.
I also programmed many graphs of Florida Power loads and temperatures,
and performed many
maintenance changes on existing systems.
I worked for the Power Marketing Dept. in their "trading" room
and their energy control center.
GATORBAIT SOFTWARE., Palm Harbor, Florida 1/96 - 12/96
Oracle Developer 2000 Programmer(Perm Position)
[-Layoff Chapter 11]
Developed conversion/load procedures for Oracle Accounting
Software for the
Nursery/Greenhouse Industry. Extensive use of Oracle 7.1 Developer 2000 in
Windows 95 environment. Interaction with Novell NetWare 4.1 and SCO UNIX
Servers. Extensive SQL Conversion coding using SQL * Plus and PL* SQL
scripts, SQL Loader, Procedure Builder (Triggers), and Oracle Browser. Some
Oracle forms (4.5 ) development and Oracle reports
(2.5), also Delphi 2 development.
TKC., Pinellas Park, Florida 11/95 - 12/95
Visual Basic Programmer
(3 months-temp position)
Worked in Visual Basic 3.0 to copy protect and encrypt
envaluation software for the Internet Some HTML webs
page development.
MORTON PLANT HOSPITAL., Clearwater, Florida 1993-1995
Micro Computer Analyst(Perm. Position)
- Layoff due to Merger
Designed, developed, and implemented three complete financial applications
for the Home Health subsidiary of Morton Plant.
The applications were Payroll,Purchase Orders,and Human Resources.
* All applications were written in Borland Paradox for DOS, and were
installed on both Novell 3.1 networks
and stand-alone.
Symantec's PcAnywhere was used extensively to communicate
data from office to office.
Developed employee wellness database using Microsoft Visual
3.0 and VB. 4.0 (Prof. Edition) and Microsoft
Access 2.0.
We used Crystal Reports for reporting.
JMH SOFTWARE., Palm Harbor, Florida 1992-1993
Micro Computer Analyst-Owner of Home Business
Programmed Visual Basic 1.0 for a lottery application.
FIRST FLORIDA BANK, N.A., Tampa, Florida 1986-1993
Senior Programmer Analyst
(Perm. Position) - Layoff due to Merger
Maintenance of Marshall & Isley banking code and conversion of
correspondence banks to *this vendor's system.
* Converted seventeen banks from different vendors' C & S, NCR, FIS,
Burroughs,NAFS to M & I deposit systems.
* Converted 110,000 accounts and $600 million
in balances for DDA,Savings,
CD's,and IRA accounts.
Senior Programmer Analyst, Systems Development 1986-1990
* Designed, developed, and installed a complete PC-BASED deposit and
consumer loan branch automation system for First Florida branches.
Saved millions of dollars in duplicate
data entry, printing,
and transmission costs to host and increased
accuracy and efficiency.
* Designed, programmed, and implemented the
real-time transmission of
customer information from PC's to
an IBM 3090 host using 3270 emulation's.
Developed complete deposit and consumer loan
reporting system in FoxBASE.
The reporting system contained
daily and monthly-consolidated reports.
COLLIER-JACKSON, Tampa, Florida 1984-1986
Senior System Analyst (Perm Position)
Programming and installation of newspaper circulation software
throughout the United States.
This software was installed on HP 3000 and DEC. VAX mini computers.
Installed three newspaper circulation systems throughout the Midwest.
SOUTHEASTERN COMPUTER CORP., Clearwater, Fla. 1978-1984
Systems Analyst/Programmer
- Layoff due to merger
Programming, design, and installation of taxation and
appraisal systems for county governments throughout
the United States.
All systems were on Burroughs small and medium systems.
* Programmed and installed five taxation and appraisal
systems in the United States.
Programmed complete taxpayer billing for ten county government clients.
ST. ANTHONY'S HOSPITAL, St. Petersburg, Florida 1975-1978
Programmer Analyst
Conversion of service bureau patient accounting system
to in-house system.
Development of on-line real time
patient accounting system for patient charges, admitting, and insurance
billing. Developed G/L system.
* Converted service bureau to in-house in fifteen months
for all charges and accounts receivable.
* Developed real-time system in Burroughs DMS II for admitting, patient
charges, and insurance charges, and
insurance billing in thirty-six months.
* Powerbuilder 5.0 usage for 6 months dates from 1996 and although not
current - it would only
Take me a little over 1 week to come up to speed on Powerbuilder 7.0