SYSTEMS DESIGN AND DEVELOPMENT
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