The Problem
The Professional Liaison Network (PLN) team at the University of Bristol kept its client records in Excel. A spreadsheet does not validate what is entered, and it cannot restrict who sees sensitive client information. This CRM replaces it with a web application backed by a database.
My Contribution
I developed the Django backend in a 6-person team, working through stand-ups and pair programming. I helped containerise the application and deploy it to AWS ECS behind an Application Load Balancer.
I migrated 686 client records to AWS RDS and implemented validation checks on the data. I also implemented access controls for sensitive client information.
Architecture
Users reach the app through an Application Load Balancer. The frontend and the Django backend each run as their own service on AWS ECS, and the backend stores its data in MySQL on AWS RDS. CI and deployment workflows run from pull requests on GitHub: they build Docker images, push them to Amazon ECR, and deploy them to ECS.
Tools Used
Project Links
Source is private: built for a University of Bristol client team.