Dental Web Site Design
 
 
 
 
 
 
 
home | database design | Access | SQL Server | custom app | web | portfolio


Making Your Vision of Technology a Reality!©™
Welcome to Visionary Information Technologies' web site. We offer a wide variety of Computer, Technology and Internet related services.

Under redesign / construction ...

:: Featured Case Study ::Database Development
Project:
Dental Health Associates - Claims Management Tracking System
Hollywood, California

Task:
  • Develop a Multi-User Database on Microsoft Access2000 to automate the Claims Management System to track, maintain, calculate and manage Dental Eligibility Claims.
  • Automate time consuming and repetitious tasks of collecting data, billing and sending statements / claims.
  • Scan Claim Forms, Claim Payments and manage scanned data.
  • Print checks in Batch mode.
  • Track All automated as well as manual Eligibility calls.


    • Solution:
  • Existing historical data was imported into the new database.
  • Developed routines to import the Insurance Company's Eligibility Data, on monthly basis.
  • Databases were created for Doctors, Eligible Patients, Current Patients, Historical Claims, and all their relationships were established and the data was normalized.
  • Comprehensive User Interfaces was created for viewing all Eligibility Data, as well as all the Claims and their associated Doctors and Patients.
  • Multiple workstations were setup for scanning claims and viewing them electronically.
  • Dynamic reporting of Revenue, Activities, processes

    Results:
    There are over 30 different input screens, 25 different reports, processing a database of close to 200,000 eligible patients. The system is handling and reporting on thousands of cases every month.

    Tools:
    Microsoft Access 2000, Microsoft Office 2000, Microsoft Windows 2000 Workstations (Dell systems), Microsoft Windows NT Server, Fujitsu Scanners
    		•

     

    VITech Partial Client List
    Flash: AHA Inc.
    Azarmehr Dental Practice
    Pousti Plastic Surgery
    Los Angeles Valley Braces
    DentalCube
    Database Enabled: DentalWebSearch
    Newport Canyon HOA
    OC Toastmasters

    Medical / Dental Web Sites: Azarmehr Dental Practice
    Pousti Plastic Surgery
    Alex Farnoosh Periodontics
    Molayem Orthodontics
    Parkside Dental Group
    West Los Angeles Dentist
    Gardena Dental group
    Maxella Dental
    Gardena Dentist
    Los Angeles Valley Braces
    Shawn Taheri Pediatric Dentist
    Brentwood Dental Group
    Other Web Sites: OC Toastmasters
    Tandis Research
    AHA Inc.

    Database Programming Projects:
  • Law Office Client Management System (3 months)
  • Perfume Connection Inventory Management (3 months)
  • Clients / Leads Tracking System (4 months)
  • Dental Health Associates Insurance Authorization Tracking (15 months)
  • California Air Resources Certification Tracking System (8 months)
  • NWQ Stock Broker Acitivity Tracking System (5 years)
  • Prudential Insurance North America Insurance Processing (12 months)

    		•
     
    		 
    Remember 9-11, Fire Fighter Donation
    copyright (c) 1992-2002 VITech, All Rights Reserved. Terms and Conditions of Use.
    Email: info@vit.net - Toll Free Call: 888-607-2538
    This site is best viewd on MSIE 5+