SDMay18-26: Electronic Scheduling Tool for UnityPoint Weight Loss - - PowerPoint PPT Presentation

SDMay18-26: Electronic Scheduling Tool for UnityPoint Weight Loss Clinic

Matt Cavalier, Joel May, Madeline Andreassen, Luke Sternhagen, Matthew Burket, Ryder Schoon

1

Our Client

• UnityPoint is large Healthcare company in Iowa, Illinois and Wisconsin
• We worked with UnityPoint Clinic Weight Loss – West Des Moines
• People we worked with

○ Vanessa Calderon ■ Process Improvement ○ Angela Claytor ■ Clinic Administrator 2

Problem

• Scheduling many appointments with many providers in one day
• Currently significant effort to schedule these appointments
• There is issues with double booking of providers
• Current schedule is not making the best use of provider item

3

Goals of the Project

• Create a proof of concept application that allows for that easy scheduling of

many providers on day

• Reduce double booking and other scheduling issues
• Increase the number of patients seen by providers
• Reduce patient wait time between each provider

4

Demo

5

Requirements: Functional

• Application that helps the client with scheduling
• Scheduling Algorithm

6

Requirements: Epic Information Retrieval

• Get scheduling data from Epic
• Denied access to directly interface with Epic
• Instead the data is exported and parsed by our program

7

Requirements: HIPAA

• Health Insurance Portability and Accountability Act, requires patient data to

be protected

• To stay HIPAA compliant we decided to not store patient data

8

Requirements: Non-Functional

• Provide suggestions in under five seconds
• Allow the software to configurable to adapt changing needs of the clinic
• The software should be intuitive and easy to use

9

Market Research

• Current scheduling system - Epic’s electronic medical records system (EMR)

○ Not flexible for front desk personnel needs ○ Forces personnel to manually search for appointment slots due to inflexibility ○ Inefficient at generating best fit appointment times 10

Design - Architectural Overview

11

Component Diagram

12

Design - Algorithm

13

Technology Used

• Server Side & Algorithm DLL

○ C# ■ Language ○ ASP.NET MVC Web API on IIS ■ Boilerplate API framework ○ Entity Framework ■ Database abstraction ○ Microsoft SQL Server ■ Database 14

• Front End

○ JavaScript ■ Language ○ JQuery ■ Boilerplate JavaScript framework ○ Bluebird.js ■ Compatibility framework ○ Bootstrap 4.1 ■ Graphic design

Testing

• Front End

○ Manual Testing (both acceptance and integration testing)

• Server

○ Continuous integration (compilation and deployment) ○ .NET built-in unit test framework ○ Postman integration tests

• Algorithm

○ Unit Testing ○ All combinations testing 15

The Future

• We will give the project to UnityPoint for testing and validation
• We want to implement heuristics on generated schedules

16

Things We Learned

• How adapt to changing requirements
• Translating, understanding, and conveying technical information
• Deployment of a complex .NET project with continuous integration

17

Thank You

Vanessa Calderon and Angela Claytor Srikanta Tirthapura Iowa State University College of Engineering, Joe Zambreno, and Tom Daniels

18

Questions?

19