Request a Quote

Featured Client

.Net Project for a Danish Company

Option Matrix has been working over last 2 years for an IT solutions firm in Denmark that provides portal solutions to sports clubs

Hospital Data Management

The objective of the project was to develop a desktop application to manage the data related to the patient and handle multiple departments in different modules for effective hospital management. Patients can fix their appointments with the doctors, come to the clinic, undergo diagnosis, and receive medical advice / follow-up. This project is a windows-based application/software called EMR to store patient healthcare data. The application consists of a ‘front-end’ and a ‘back-end’. The front-end file acts as the user interface for HDM. It contains forms, queries, reports, code modules and local tables. The front-end file contains table links to the back-end file. The back-end file is located on a server that acts as an HDM database.


Admin User

Admin user can installs the application in different departments with a pre-defined authentication. At the time of installation, the admin user can setup the login details for different department users. Admin user can also manage the department user, user profiles, providers, patients of different departments, insurance companies, tasks like type / category relationship and mailbox / staff assignments. Assign access rights to different users.


Department Users

Department users are the users of different departments in the hospital have access rights to perform different tasks based on their authentication. Prospective Department users can also add a new patient record and manage the existing patient records, Fix an appointment for the patient with a consultant (doctor) and search for an appointment of a particular doctor, admin user can manage the schedule of the providers and resources. The reminders for the tasks for a particular patient with complete details can be sent


Key Features
  • Manage the clinical CPT codes, Code CPT Types, DME CPT Codes and ICD codes to prepare the case sheet easily for the billing dept.
  • Manage the predefined text category of different clinical practices.
  • Manage the insurance providers for the patients.
  • Manage the pharmacies for alliance.
  • Manage the physician’s instructions.
  • Manage the ROS cluster types.
  • Interpret the patient problems by using different tests .
  • Manage the SOAP boilerplate test.
  • View the mailbox list and mail category list

Technology Architecture

The application was programmed in windows architecture using .Net 2.0 (with VB.Net as language) and MS SQL Server 2000 or equivalent as RDBMS. There is a separate MS SQL Server 2000 database at each of the three offices and these 3 databases synchronize with each other as per the set schedule. The windows interface application can be loaded on each PC in the LAN and there is a higher capacity Windows XP / 2003 server in each of the 3 offices where the MS SQL Server 2000 RDBMS has reside. Optimistic locking with ADO.Net disconnected database has been used. Another interface was created and linked with the patient forms web application.

Founder,
Real Estate photography project, USA

Quality :

I cannot evaluate the server application code, only the user and admin interfaces; so on those I rate a 5.

Productivity :

Sometimes things seem to slow down but I think that just me not complete understanding the scope of the project on the server side. 4.5

Communication :

EXCELLENT 5, Everyone is always available.

Predictability :

Because the communication is EXCELLENT, 5, I am able to count on the level of performance and expectations so again 5.

Professionalism :

Highest level of Professionalism - If I could rank this as a 6, I would. I am impressed with the level of professionalism at all levels and with everyone I have interacted with.