January 2026 - April 2026
Project Manager
Figma, Zoom, Database Tables, Ruby on Rails
The purpose of this project is to provide an updated database for head/neck/swallowing clinical case studies. The system will be designed where researchers and clinicians can upload and find case studies in a standardized format. A database must be designed using database tables and then wireframe's to understand the flow of the database.
Design a research database for head/neck/swallowing clinical case studies. The system is designed where researchers and clinicians can upload and find case studies in a standardized format. Since I am a project manager my goals are to be able to organize a team of students to produce a quality product. I will be using tickets to coordinate tasks while keeping in close contact with my team. We are on a time constraint as we only have till the end of the semester but I am confident my team and I will be able to make quality progress for the next set of students to continue on.
The first task for my team and I to tackle is creating a thorough database table. We were given 8 example case studies to read through to understand the data that will be in each study. We were able to narrow down a list of keys and their values. Below is the rough design of the database table.
After discussing more with the client and my team this is the finished table.
I assigned different team members tickets to create low-fidelity wireframe's based off of micro stories. Since we are in the initial stages of prototyping, I am encouraging different ways to format the wireframe's. My ticket I assigned myself is as follows: “As a clinician, I should be able to update and edit my submitted case study report.” I also created a landing page where users will be able to search for cases based on an input or selecting categories. This was the first iteration of the landing page and the wireframe for the ticket.
This is my styling for the landing page. This page has been prioritized while the database gets created in Rail as this needs to be put on a poster for a conference.
I also created this page that will show when the user searches for something. It has the same styling as the landing page. Once the user inputs their search the resulting case studies will show up with options to filter through them.
My team and I had the amazing opportunity to present this project at the 2026 UURAF. This poster was made by our mentor Jeff Siarto and my team and I presented it. We were able to gain a lot of feedback on the design and talked to many speech pathologists about the project. They all loved the idea and are excited for the database to become a reality.
While designing in Figma, I also spent some time moving all the database tables into Rails. Pretty straightforward work as Rails is easy to use and understand in my opinion. Click Here to see the repository in GitHub. I was able to do the basic scaffolding and adding bare html for patients, case studies, documents, authors, tags, and categories.
This project will be continuing to be worked on through the VIP program at MSU. In this semester my team and I were able to do user research, low and high fidelity wireframes, create the basics of the database in Ruby on Rail, and present our project at UURAF. I am proud of this project and hope to continue to work on it in the fall.