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 ● Front End C# JavaScript ○ ○ ■ Language ■ Language ASP.NET MVC Web API on IIS JQuery ○ ○ ■ Boilerplate API framework ■ Boilerplate JavaScript framework Entity Framework Bluebird.js ○ ○ ■ Database abstraction ■ Compatibility framework Microsoft SQL Server Bootstrap 4.1 ○ ○ ■ Database ■ Graphic design 14

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