
Office of University Counsel
Past Project (2024-2025)

Office of University Counsel
The Office of University Counsel (OUC) provides legal guidance across Tufts University, handling matters such as university operations, litigation, student affairs, intellectual property, employment, and regulatory compliance. Led by Senior Vice President and General Counsel Mary Jeka, OUC works to minimize legal risks, manage litigation, and ensure compliance while delivering reliable and professional legal services.
Project Goal
We are developing a streamlined database to help Tufts' Office of University Counsel efficiently access and filter information from the Physician Payments Sunshine Act. This tool will consolidate financial data related to medical, dental, and veterinary school employees, making it easier to review and manage compliance with transparency regulations.

Team Members

Rebecca Dinsmore
Project Manager

Sachin Zachariah
Technical Lead

Livia Bednarz
Designer

Sandra Alnamous
Developer

Keegan Carnell
Developer

Zach Klein
Developer

Josh Lamothe
Developer

Jordan Pittignano
Developer

Liam Smith
Developer

Lindsay Ulrey
Developer
Tech Stack

JavaScript

Python

Tailwind CSS

PostgreSQL

Neon

Next.js
Final Screens
![[TBD]](/_next/image?url=%2Fprojects%2F2024-2025%2Foffice-of-university-counsel%2Fsolution-1.png&w=1200&q=75)
![[TBD]](/_next/image?url=%2Fprojects%2F2024-2025%2Foffice-of-university-counsel%2Fsolution-2.png&w=1200&q=75)
![[TBD]](/_next/image?url=%2Fprojects%2F2024-2025%2Foffice-of-university-counsel%2Fsolution-3.png&w=1200&q=75)
![[TBD]](/_next/image?url=%2Fprojects%2F2024-2025%2Foffice-of-university-counsel%2Fsolution-4.png&w=1200&q=75)