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.

Experiential Learning Program Details

SchoolUniversity of the District of Columbia (UDC)
Engagement FormatCapstone - Small Team Consulting Project - Students work in consulting teams of 3-5 directly with faculty and client liaisons on developing real solutions to real-world challenges.
Students EnrolledN/A
Meeting Day & TimeN/A
Student Time Commitment4-7 Hours Per Week
Company Time Commitment1 Hour
Duration8.71 Weeks

Program Timeline

Touchpoints & Assignments Due Date Type

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

Industry Mentors

Company Admin


[email protected]

Academic Mentors



[email protected]

Assigned Students

There are currently no students assigned.