Web-based charting system

Client: Thunder Road

Developing 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: San Francisco Bay Area non-profit

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

Database Systems Support

Client: San Francisco Bay Area wholesale distributor

Currently supporting the MS-Access, SQL Server and networking needs of the company, including their database systems which manages invoicing, purchase orders, sales analysis, inventory and payroll functions with the assistance of PDAs for inventory scanning.

Departmental Scheduling System

Client: A leading Northern California HMO

Developing 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.

Dictation Management System

Client: A leading Northern California HMO

Developing 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

Developing 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

Developing 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.