| Project |
Problem/Need |
Solution/Task |
Comment |
Technology |
| Database Design |
Database Design for New Business |
Convert Business Object Model into Database Design, Dictionary, Business Rules |
Business Policy, Operations & Rules from scratch |
Database Design, Object Modeling, ERD Modeling |
| Prototype Database System |
Working Operations Database to Test Business Model, Operations, and Assumptions |
Build Database Tables, Forms, Lists, Queries, Menus. Implement Business Rules:Types, Validations, Constraints, Methods, Policies |
Rapid Application Development Environment enabling quick evaluation and turnaround |
Relational Database (Helix, SQL), Macintosh Systems |
| Reservations Web Site |
Online 24-hour Vehicle Reservations Web Site connected to Operations Database |
Translate Web Design into working site with secure database interface |
Qilan Middleware enabled quickly-built Web-Database connections |
Web Server, Web-Database Middleware, Relational Databases, Macintosh OS X Unix, Apache, Qilan, Helix, OpenBaseSQL |
| Member Applications Web Site |
Online 24-hour Membership Application Forms connected to Operations Database |
Specify and Build Member and Business Application Forms for Web access and secure database interface |
Qilan Middleware enabled quickly-built Web-Database connections |
Web Server, Web-Database Middleware, Relational Databases, Macintosh OS X Unix, Apache, Qilan, Helix, OpenBaseSQL |
| Electric Vehicle Rentals |
Adapt Database tables, functions, and Web Site to special needs of Electric Vehicle Rental |
Translate Electric Vehicle requirements into Business Rules, and implement in Database, Middleware, and Web Site |
Charging Time, Grace Periods, Pricing, Usage Research Data |
Macintosh, Relational Database |
| Electronics Interface |
Receive and send data to/from custom electronics in rental vehicles. Capture Vehicle Usage Logs |
Design and Build remote data communication and loading interface tools between custom vehicle electronics and Operations Database |
OptoData built the Custom Electronics for Vehicle Activity logging (Time, Miles, Activity) |
Unix Shell Tools, Modem Communications Tools |
| Project |
Problem/Need |
Solution/Task |
Comment |
Technology |
| Automated Claim Response Generation |
Systematize standard response rules and free-form review capture & reporting |
With Experts (Dentists) evolve a coding worksheet of 400 possible professional responses. Build database to accept & report coding and open-ended claim review responses |
Frequent Interview & Analysis Cycles |
Macintosh, Helix Relational Database |
| Cost Savings Reporting |
Reporting of cost-per-claim & detail savings from claim review |
With Experts (Dentists) evolve detailed cost savings per procedure reviewed. Build database, tables, & reports for monthly production. |
Frequent Interview & Analysis Cycles |
Macintosh, Helix Relational Database |
| Counseling Letter Generation |
Systematize standard counseling comments for automatic letter generation |
Facilitate capture of professional (Dentists) utilization review comments for encoding. Build database & custom tools for generation of review letters. |
Precise, accurate, clear statements important |
Informix, Solaris Unix |
| Billing System & Procedures |
Reconcile Vehicle Reservations with Vehicle Logs and Member Usage for Billing |
Develop Database Forms and Reconciliation Procedures for Invoicing |
Semi-automatic |
Macintosh, Helix Relational Database; Unix tools |
| Insurance Claims Tracking Database |
Implement Dental Insurance Claim Review Tracking System |
Design & Build Database Tables, Forms, Lists, Reports, Invoicing |
Rapid Turnaround as Client Needs Evolved |
Macintosh, Helix Relational Database |
| Project |
Problem/Need |
Solution/Task |
Comment |
Technology |
