Capstone – Project

Making Sense of Messy Medication Data

A Collaboration Between

Project Synopsis

Our data pipelines include data from different healthcare systems, which record and transmit similar types of data in different ways.

Ex: transactional medication data across a patient/med life cycle
– Initial doctor order, with clearly documented dose, frequency, start date, reason, and code set backing the name
– patient reports that medication to another doctor, name is different, no code set backing the name, dose/frequency not recorded
– patient reports that medication to the ER, name is different (again), no code set backing the name, dose/frequency are recorded
– patient is discharged from the hospital, told to continue that medication, slightly different code set from the initial order
– sees initial doctor again, dose/frequency of medication is changed

Project Topics

Customer Service

Data Management

Software Design & Development

Company Information

CompanyVessel Health
StagePre-Revenue Startup
Hiring PotentialFollow-on Projects, Formal Internship, Entry Level Full-Time, Upper Level Full-Time

Company Overview

A patient-facing platform that gets all of your medical and wellness data into one place so that you can see patterns and proactively manage your health.

Industry Mentors

Healthcare for Humans


[email protected]

Experiential Learning Program Details

SchoolUniversity of the District of Columbia (UDC)
Engagement FormatCapstone - Small Team Consulting Project - Students work in small groups of 2-6 directly with faculty and host company project champions on developing real solutions to real-world challenges.
Students Enrolled10
Meeting Day & TimeMonday and Wednesday 4:30pm-5:50pm
Student Time Commitment4-7 Hours Per Week
Company Time Commitment1 Hour
Duration8.71 Weeks

Program Timeline

Touchpoints & Assignments Due Date Submission

Key Project Milestones

  • February 21, 2020 - KICKOFF MEETING @ 9:30 AM PT / 12:30 PM ET

    Susanne, the VH’s founder will web conference into class to discuss her product, vision, and the project scope

    Suggested Deliverable:

    Prepare for kickoff meeting by familiarizing yourself with VH’s website:

  • March 6, 2020 - Get Up-To-Speed on Vessel Health's Product Configuration & Data Model

    • Explore: VH Demo Account:
      • What does VH product do?
      • Who is the VH primary user? Are there other users?
      • What data is included in the account?
      • What information might be missing?
      • Would you use a platform like this? How?
    • Get up-to-speed on healthcare data systems:
      • Where does healthcare data live?
      • What are the major domains of healthcare data?
      • What kind of structure is used to organize the data?
      • What standards exist for this type of data? (Consider: Privacy, HIPAA Compliance)
    • What types of challenges exist with interoperability?
      • What are the economic incentives for organizations in the healthcare market to comply and integrate with other systems?
      • Explore: HL7 or FHIR Documentation
      • (FHIR & HL7 website)

    Suggested Deliverable:

    Prepare for Q&A with VH’s Executive Leadership Team

  • March 27, 2020 - Mapping & Roll-up Process Proposal for Medication Data

    • What is the similarity matching problem in VH’s system?
    • What existing techniques are relevant to the similarity matching problem?

    Suggested Deliverable:

    • Propose approach to similarity matching problem to support required mapping roll-up functions
  • April 17, 2020 - PROGRESS REPORT: Mapping & Roll-up Process Proposal for Medication Data

    • What data is included in the transactional data table?
    • What method can be used to satisfy the example mapping?
    • What are some additional edge cases to consider?

    Suggested Deliverable:

    • Develop description or sample code that would be able to review transactional medication information
    • Ideally, the output should be comprehensive for an average consumer using the product
    • Prepare for Q&A with VH Team
  • May 8, 2020 - Refine and Finalize Mapping & Roll-up Process Proposal for Medication Data

    • How can your methodology be improved?
    • What else can be done with this data?

    Suggested Deliverable:

    • Submit Report on Findings
    • Discuss Follow-on Work to be Done

Project Resources

There are no resources currently available

Academic Mentors



[email protected]

Assigned Students

There are currently no students assigned.