Oracle Projects/Activities by R. Kent Francis at Kiva/Accela Inc.
==================================================================

Kiva's enterprise software is used by the largest city/county/state
govenment entities across the US to keep track of all their land records,
Requests for services (complaints/violations),  Permits,  Professionals,
Inspections, Work Orders and other transaction based needs including forms
for the payments of fees, multipayments/credit cards/professional credit
accounts.  It is provided in both a client-server and web environment;
to both the government entity as well as to the general public.

In the early months of 1998 I was hired to create the specifications for an
Infrastructure Inventory Control System (later called Asset Management) which
I designed, coded, and integrated into the main Kiva Products.  Since there
is a fixed component to the system, but also a variable group of fields based
upon the particular asset (streets have different descriptors than trees for
example), the system is totally flexible.  In addition to maintaining
information about the asset, a model can be created which mirrors transactions
performed against the asset with standard budgets for materials, hours and
costs.  These can be compared against actual services performed and a series
of work orders and management reports generated.  They were sufficiently
impressed with my work that they retained me full-time.

Progressively all the programs for the Kiva system (including over 500 forms)
have been enhanced from a character-based to bitmap-based set of forms; oracle
4.5 thru 6i.  Databases also have evolved thru 9i and the forms have been
standardized to run concurrently in both a client server and web based
environment. I have become proficient in all aspects of forms programming/
triggers/procedures and SQL.  I have fixed major components of every module.
I implemented standards for report variables and the interface with forms,
and added LOV's and hover text for all standard fields in the system.  I
adjusted, standardized and fixed the majority of the "system" maintenance
forms.  I reviewed all the forms for year 2000 compliance and repaired the
majority of the form and reports date handling.  I converted a substantial
part of the V2 triggers left in forms.  I added system triggers to replace
many "add on the fly" subroutines to update system tables.  I converted many
of the validation triggers to cursors.

I also learned Oracle Reports, and created custom reports for a number of
customers.

As far as DBA type work:

I have used DBA studio to set up a database, define tablespace, and grant
priviledges. I have imported and exported databases. I have used SQL scripts
run in sqlplus to set up tables, views, triggers, indexes, constraints. I
have used Toad to model/debug SQL statements.  I have used TOAD explain plan
to check for number of rows returned from a complex query to debug it. I have
used Oracle Net8 easy config to define the connections to the database for
the listener.

I trained the contract programmers we hired, as well as the new programmers
in reports,  forms, and the Kiva coding standards.  I attended Oracle 6.0
training and trained our group in the changes.  I have attended two classes
on Java, but have not had opportunity to yet apply any of the  material
learned to the Kiva product.

I helped establish standards for the ESRI Graphic Interface System integration
into the core system and modified all query forms so maps can highlight the
information queried in both directions.

I modified all query forms in the system to be completely flexible/customizable
by city and by user.  They can specify for each user which fields will appear
what they will be called, how big the fields are, and how the form is sorted.

I built a Hazardous Materials tracking system that complies with California
regulatory requirements.

In an effort to increase my productivity, I purchased my own laptop computer
with sufficient memory and speed to be an efficient development platform.
I acquired Comcast broadband service into my home office and set up a local
network so that I could efficiently work from home 4 days a week.

A year ago Kiva was merged with four other companies and their individual
products into Accela Inc and grew to 10 times the number of employees
including a company in China.  In late November the new management decided to
downsize the local programming staff and ship the work overseas.  I am
available immediately for a new project.  I would prefer to work for a stable
company on a long term, permanent contract.