About Us Our Team
   • Dan
   • Ralph
   • Daniel
Projects
   • Recent Projects
   • Past Projects

Database Development
&
Systems Integration

Past Projects

Time-Keeping Database

Client: The Public Interest Law Project

Developed a sophisticated multi-user database-driven time-keeping and reporting system custom-designed to the demanding workflow requirements of a specialized organization.

Web-based charting system

Client: Thunder Road

Developed an electronic Web-based electronic charting system for a non-profit organization committed to the treatment of adolescents in recovery. The system is built using VB.NET, ASP.NET, C#, SQL Server and Javascript.

Web-based Scheduling System upgrade

Client: Rising Sun Energy Center

Assisted a non-profit organization by upgrading and enhancing their Web-based scheduling system. The system is written in PHP and MySQL.

Implemented Credit Card Transactions

Client: Golden Gate Audubon Society

Implemented credit card transaction processing for the organizations's Web site, which is written in PHP and MySQL.

Dictation Management System

Client: A leading Northern California HMO

Developed a Dictation Management System for the Occupational Medicine Department. The system interfaces directly to the hospital's mainframe system and uses Access 97, VBA, Word 97 and Dragon Dictate. The system replaces a manual method, and has the potential to increase regulatory compliance and productivity by eliminating redundancy of data entry.

Disability Management Database

Client: A leading Northern California HMO

Developed a Microsoft Access/VBA disability management database system for the Workers Compensation Department of a leading northern California HMO. The system provides multiple reporting features for managing disability cases and decreasing their costs to the HMO. It also supports workers in recovering from occupational injuries quickly, and assists in ergonomic evaluations and improvements.

Echocardiogram Tracking System

Client: A leading Northern California HMO

Developed a Microsoft Access/VBA echocardiogram tracking system. The system replaces manual methods of tracking demographic and technical data. It greatly speeds up availability of data to other departments via automatic emails and automatic uploading to the mainframe system.

Deal Tracking System

Client: San Francisco Bay Area venture capital firm

Designed and developed a "Deal Tracking" system in Access 2002 that centralizes the firm's company and contact data -- previously stored in ACT! and Excel -- and streamlines its collection and manipulation. The system tracks financial results, funding and investors for 1500 firms, provides reporting by sector and industry and produces watchlist, taxonomy and current call reports.

Departmental Scheduling System

Client: A leading Northern California HMO

Developed a departmental scheduling system using a custom-designed GUI developed in Visual Basic 6.0, with a back end in MS-Access 2002. Previously a set of widely-varying Excel spreadsheets were used to plan physician schedules, and any changes required assistance from IT staff. The new integrated system allows all staff to make flexible alterations in real time and has the following features:

• Serves as a clinician and staffing scheduling tool by making the most current version of a department's schedule easily accessible to the department and staffing office;
• Provides color-coded alerts to ensure appropriate coverage by on-call doctors;
• Tracks changes made to schedules.

The system acts as a prospective patient access and budget management tool, and provides retrospective access and budget reporting. It also allows all staff to make alterations in real time and to predict budget constraint and accessibility constraint outcomes, while optimizing schedule planning.

Employee Tracking System

Client: A leading Northern California HMO

Developed a Microsoft Access employee tracking system for the Mental Health Department. The system tracks employee training, employee evaluations, and other personnel issues.

Nurse Midwife Analysis

Client: A leading Northern California HMO

Analyzed Access 97 nurse midwife data for the Labor and Delivery Department to produce reports on outcomes for nulliparous patients based on gestational age, optimal admission time for laboring patients, effect of epidural anesthesia on labor outcome and other statistics.

Breast Biopsy Database

Client: A leading Northern California HMO

Assisted in the development of an Access 97 database for the Diagnostic Imaging Department for tracking breast biopsies. Users automatically import patient demographic data and pathology results from the mainframe. Pertinent patient and lesion information captured in the database can be transferred automatically into the mainframe referral template and hen sent on to the surgery department.

X-ray File Room Application

Client: A leading Northern California HMO

Managed the development and implementation of an Access 97 / VBA application that improves X-ray file room efficiency by automating the ordering of X-ray jackets by specialty. The application interfaces to the HMO's mainframe system and is expected to significantly improve the level of patient care.

Vehicle Transport System

Client: M.A.C. Services

Designed and programmed a Vehicle Transporting, Routing and Mapping System for a 60-employee company specializing in the intrastate transfer of vehicles. The system was upgraded from a set of DOS-based Clipper applications to an SQL-based Visual Basic 5.0 application using Extended System's Advantage Database Server ODBC drivers. Programmed prototyping and conversion processes in Access 97 and VBA. The basic system functionality of order entry, invoicing, quotation, directions and mileage calculation was enhanced to include real-time routing, dispatching and mapping functions.

Product and Inventory Database

Client: Dreyer's Grand Ice Cream

Assisted the R&D Division in the development of a multi-user product development and inventory tracking database using Access 2.0 and Access Basic 2.0 under Windows 95.

Appropriation Request Database

Client: Wells Fargo Bank

Assisted the Corporate Properties Group in developing an Access 97 database to track appropriations requests. The system incorporates such features as an automatic interface to Microsoft Word forms and automatic e-mailing of appropriation status to managers via VBA DDE.