Mohamed Elmujtaba Elwasila
Mohamed Elmujtaba Elwasila
Client project · 6-person team · Jan 2025 – Present

Customer Relationship Management System (CRM)

A CRM built for the Professional Liaison Network at the University of Bristol, replacing an Excel-based workflow. I developed the Django backend as part of a 6-person team.

CRM contact list with client details blurred
The contact list. Client details are blurred.

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.

Architecture diagram: CI and deployment workflows build Docker images and push them to Amazon ECR; frontend and backend run on Amazon ECS behind an Application Load Balancer, with the backend connected to AWS RDS
The deployment architecture. Select the diagram to open it full size.

Tools Used

Django
Python
Flutter
MySQL
Docker
AWS ECS
ALB
AWS RDS