Case Study Clinic Management System
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 1 of 1
Client
Requirement
CMS is a web-based application for managing multiple clinics' data along with providing common access to clinic’s doctors and receptionists. Client required a system to manage all the back-office team activities for their patient's appointment & their follow-ups. It provides doctors with their daily schedule based on the clinic location and also allows the patient to make the payment through Cash, Credit Card, Insurance Card etc. Part Payment can also be handled. User can generate receipts for Insurance Company and also for the patient. Following is the list of modules present in the Clinic Management System:
Appointment Scheduler Today's Appointment Registration Lab Module Reports Employee Profile MIS Reports Help Desk Cash Scroll
Project
Challenges
Team faced the following challenges:
Developing a system to handle clinic’s requirement for multi-location but centralized patient data management.
Developing a web-based application which would require no installation.
Developing a system which would easily integrate with third-party appointment scheduling software and provide appointment updating facility.
Developing a queue management system which needs to be user-friendly.
Ensuring safe and secure transfer of data.
www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd
Page 2 of 2
Technologies Operating System & Server Management
Development Tools & Environments Database
Used Windows OS, Multi-Server Architecture with Staging & Production Environment through Version Controlling releases, Server Optimization, Security & SSL Implementation, Scheduler for Back-ups, Alert Monitoring System Integration, Server Performance Tuning at regular intervals, Software Firewall Configuration & Maintenance ASP.Net, MVC, C#, SSRS etc. MSSQL Database Server 2008, Report Service (SSRS), DB Clustering, DB Optimization, Master Slave Replication, Query Optimization, Scheduler for Backups
Manpower Project Leader
1
Developers
5
Designers
1
Integrator
1
DBA
1
Quality Assurance Testers
2
Planning Taking into consideration the functionality of the application the following development areas were charted out to be elaborated upon: The web server using HTTP protocol for communication with the web browser. A third-party appointment scheduling software was bought and planned to be integrated into the application.
www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd
Page 3 of 3
 Application approach was done as per SAAS module in order to manage multi-location data controlled by their respective administrators.
Architecture We are using 3-tier architecture which provides Presentation layer (PL), Business Access layer (BL) and Data Access layer (DAL). BAL: Business Access layer contains business logic, validation related to the data. DAL: Data Access layer contain methods which help the Business layer to connect data and perform required action like returning data or manipulating data (insert, delete, update). PL: Presentation layer contain .asp or html where data is presented to the user and inputs are taken from the user. Deployment Architecture For deployment we are using Windows Server 2008 with IIS7. We are also using MVC architecture. Benefits of MVC are given below: 1. 2. 3. 4. 5. 6. 7. 8. 9.
Enables the full control over the rendered HTML Provides clean separation of concerns (SoC) Enables Test Driven Development (TDD) Easy integration with JavaScript frameworks Follows the design of stateless nature of the web Restful URLs that enables SEO No View-State and Post-Back events It provides RAD development Easy development models for developers those coming from WinForm development
Development
Highlights
The application was designed perfectly to integrate with the third-party scheduler and manage appointments of the patients. The SAAS model provided the client with a system capable of handling all the multi-location data and with ease of access for everyone. Queue management module helped maintaining the patient visits smoothly. The control of the site was given to administrator who can set up users, user roles and assign page-level access to each of these roles.
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 4 of 4