Below is a
summary of some of the programming projects we have worked on in
recent years. (This is just the initial version of this page.
Updates will be issued over time.) Most work has been done in
Laguna Niguel, California and/or onsite. However, we have worked in
conjunction with offshore resources.
Medical Supplies Distributor (Lake Forest, CA) Industry: Medical Services
reporting capabilities of a multi-user Microsoft Access database used
by legal department to track litigation. Reports include open matters
and year end summaries.
Insurance Agency (Corona Del Mar, CA) Industry: Financial Services
This multi-user Microsoft Access project implemented a leads tracking and
bonus reporting system. It uses a shared backend database on the
office server. Reports include applications, leads, bonuses and contacts.
Bond Trading Firm (Corona Del Mar, CA) Industry: Financial Services
This Microsoft Access project implemented a business intelligence front end to the
existing trades database. The trades database recorded information on
all bond and equity trades the firm placed. Reports provided included
trade blotters, daily sales, trade recaps, settlement spreadsheets
and many other.
In a subsequent project the data was moved into a SQL
Server back end database using views and pass-through
queries. This resulted in increased stability and
substantial performance improvement.
This application was created for the marketing department of a major
manufacturer of tankless water heaters. The database tracks
demographic information by plumber, distributor and sales
representative. Drill down forms and graphs were provided by each of
the above categories showing performance by goal area.
Telecommunications Support (Laguna Niguel, CA) Industry:
This Microsoft Access database basically maintains the information of employee,
functions, equipments, jobs and invoices for a firm laying
underground communications lines. Reports are available for weekly
sales, weekly time log, and invoices. Along with the same the
database has statistical reports based on employee, function and equipments.
Homebuilder (Corona, CA) Industry:
This construction management database contains information related to
community, phase, supplier, labor etc. There are several forms (such
as maintaining Temp Labor, Purchase Order, and Inspection Cycle Time
etc) and reports (such as Cost, Labor, Test Listing, Purchase Order,
Preview, Delivery items etc.) available in the application. There are
several Charts used to fulfill some specific presentation
requirements. Also users can export (or import) data to (or from)
ClassWare Web ERP (Laguna Niguel, CA) Industry: Education
application for private schools. Maintains information on students,
vendors, classes, courses, time charges, etc. Information is captured
directly from web forms and placed in a MySQL database on the web in
real time. Numerous reports available. System runs on a Linux/Unix
server and is available through any standard web browser. No
installation required. Beta release but in production use.
Testing (Culver City, CA) Industry: Medical
This was an
object-oriented Middle Tier application written in Visual Foxpro. It
collected information from legacy FoxPro databases and normalized it
The data was then applied to a SQL Server database in near real time.
This allowed users to see test results over the web.
Services for Youths (Long Beach, CA) Industry:
database has been designed to keep track of the all the processes
that are followed for providing psychiatric services to youths and
children. It maintains the information related to staff, team,
position, training, client (agency), guardian, referral contacts,
discharge, funding, diagnosis, relationship. We did the original
design and implementation and have subsequently worked on several
forms and reports.
Software Vendor (Coto de Caza, CA) Industry: Legal
team that developed a retail Visual FoxPro database for use by law
firms. Comprehensive application including forms, reports and help
documentation. Application fetured flexible relationships between
attorneys, judges, jurisdictions, witnesses, etc.