Doctor Order(DO) Management System

Client: Medical Supplies Management Company.

Issues:

• Existing “system” 100% manual - queries, copy/paste, Excel/Word, 2 separate computer monitors per user, MyFax and then manual follow-up.
• DO data exists in medical billing software but no system to manage – and quote received to change/add this function was cost prohibitive.
• No reporting existed – period. This caused lost sales when DOs were missed.
• Extreme operational inefficiencies in manual system, especially with follow-up and handwritten notes.

Solution: Develop a browser-based, DO management system running on client’s new internal web site (not externally hosted).

Process:

• Jointly develop, document, and review business requirements with client.
• Assist client with hardware and software requirements to support custom application (server specifications, .NET, SQL).
• Assist client with hardware and software configuration during installation.
• Develop .NET/SQL solution to run in their 64-bit Microsoft server environment.

Key Results:

• No software installation required for end users due to browser-based solution. Application available anywhere with an internet connection.
• Rapid application development delivered working application within 3 months.
• Built data extraction layer to integrate appropriate DO information from existing medical billing software.
• Complex, rules-based engine developed for insurance requirements.
• Business analytic reports with drill-down capability enabled business to track follow-up progress as well as employee performance.
• Significant operational improvements in DO management along with increase in sales and customer satisfaction.

Technology:

• .NET / SQL 2005 environment.
• 64 bit Windows server environment.
• Template and cover letter system integration.
• Microsoft Reporting Services.