Data Structures
Binary Tree Traversal:
- inorder (L→Root→R)
- preorder (Root→L→R)
- postorder (L→R→Root)
AVL Tree Balance ↓
height(L) - height(R) ≤ 1
Heap: parent > children
Graph: V + E = ?
Trie for prefix search
Algorithms
Dijkstra's: min dist
priority_queue<T> pq
Dynamic Programming →
opt[i] = max(opt[i-1])
Quick Sort: O(n log n)
partition[pivot] {...}
merge_sort() → stable
BFS vs DFS usage?
Machine Learning
Gradient Descent ↓
θ = θ - α∇J(θ)
Neural Networks:
σ(wx + b) activation
Backpropagation ←
Loss = ∑(y - ŷ)²
CNN: conv layers →
RNN: ht = f(ht-1, xt)
K-means clustering
System Design
Microservices arch:
- service discovery
- API gateway pattern
Load Balancing →
consistent hashing
Database Scaling:
read replicas ↓
sharding strategy
master-slave setup
Distributed Systems
CAP Theorem →
pick 2: CA/AP/CP
Consensus Protocols:
Raft, Paxos, ZAB
Leader Election ↓
heartbeat timeout
Event Consistency
vector clocks t++
ML System Design
Feature Store ←
online/offline serving
Model Monitoring:
drift detection →
A/B testing setup
batch inference
model versioning
GPU utilization %
DSA Patterns
Two Pointers →
Sliding Window:
window.size(k) {...}
Backtracking Tree ↓
if(!valid) return
Monotonic Stack
Union Find: path
compression opt.
ML Optimization
Batch Norm Layer:
μ_B = mean(B)
σ²_B = var(B)
Dropout(p=0.5) →
Adam Optimizer:
m = β₁m + (1-β₁)g
ReLU vs LeakyReLU
vanishing grad?
System Patterns
Circuit Breaker →
Retry w/ backoff
Throttling: rate
Bulkhead Pattern ↓
resource pools
CQRS + Event Src
Saga Pattern →
compensating txn

Hello, I'm David Mellors

Software Engineer based in Cape Town

Welcome to my portfolio fellow web surfer! 🏄‍♂️ Feel free to scroll down to discover my work experience, or use the navigation buttons at the top right to learn more about me and view my featured projects 😁

Skills & Technologies

AWSCloud ArchitectureDevOpsPythonDjangoNode.jsNext.jsTypeScriptDockerCI/CDSystem DesignMicroservicesSupabase
David Mellors

Featured Projects

Newmarket

Newmarket

Newmarket is a B2B property technology platform that connects property developers with independent brokers, streamlining property sales and eliminating traditional intermediary costs through comprehensive property listing management, broker verification, and deal tracking systems. Built with a modern tech stack including Next.js, React, TypeScript, Ant Design on the frontend and Node.js, tRPC, Supabase (PostgreSQL) on the backend, along with Zod validation, React Hook Form, and TUS file uploads. I focused on building the administrative dashboard and broker management system, developing property and development management interfaces, implementing deal tracking and commission processing workflows, creating file upload systems for property assets and documentation, and designing database schemas with TypeScript/Zod validation - delivering key features including broker onboarding and verification, property listing management, deal pipeline tracking, and responsive admin interfaces for platform operations.

TypeScriptSupabaseDocker+3
Capuchin

Capuchin

Capuchin is an AI-driven audience-profiling platform that combines data science and behavioural science to help clients understand and segment their customers. We built a Django backend that ingests multiple data sources, runs Python-based ETL pipelines on AWS (using S3, Lambda and Postgres), and applies statistical models to generate actionable metrics. Outputs include both interactive dashboards and automated Excel reports. My work focused on the core report-automation feature, designing the statistical functions, integrating them into a Celery-powered job queue, and building the Django views and serialisers that produce ready-to-share workbooks, dramatically cutting manual reporting time and giving stakeholders clear, data-backed insights.

PythonDjangoCelery+2
AgriEnergyConnect

AgriEnergyConnect

An ASP .NET MVC web application aimed at creating a platform that facilitates efficient energy management in agricultural settings. The project was divided into a Software Proposal, a Prototype, and a Performance Report and was part of my Programming university module. Designed, developed, and deployed a comprehensive platform using ASP .NET MVC with features including a marketplace, user role management (Admin, Employee, Farmer), user profile management, password change functionality, product addition, product filtering, and a responsive, user-friendly web interface.

C#SQLASP.NET+3
Chronolog

Chronolog

Chronolog is a time tracking application designed to help users manage their tasks and monitor their productivity effectively. Showcase Here's a video showcasing all the features of Chronolog - https://www.youtube.com/watch?v=N3tZQRVdM5w Features Task Management: Users can create, edit, and delete tasks. ⁠Time Tracking: Chronolog tracks the time spent on each task to help users analyde their productivity. Category-based Statistics: Users can view statistics for each task category to understand their time distribution. ⁠User Authentication: Secure user authentication system to protect user data and provide personalized experiences.

KotlinFirebaseMVC
Here Now

Here Now

HereNow is a zero-cost solution for tracking and verifying community service hours completed by Varsity College Cape Town's Bachelor of Education students. It’s built around two main components: 📱 Mobile App (iOS & Android): Seamless session logging, tracking, and report generation for students. 💼 Web Portal: Tools for administrators to manage, verify, and export service data.

React NativeExpoGoogle Maps API+13
Go-Places

Go-Places

Go - Places is a B2B platform that enables brands to optimise selling their products across multiple e-commerce platforms. The MVP aims to provide a comprehensive dashboard to brands and Go - Places users, utilising reporting for sales or status updates and warehouse management of inventory across multiple platforms. This dashboard is designed to help identify opportunities to streamline operations and reduce the complexities to optimise sales on each marketplace. The platform focuses on aggregating reporting metrics, tracking sales, and managing stock efficiently, making it easier for businesses to navigate the competitive landscape of digital marketplaces.

Next.jsAWS RedshiftAWS Lambda+7

Work Experience

MOHARA logo

MOHARA

Junior Software Engineer

  • As a Junior Software Engineer at MOHARA, I contribute to the design, development, and optimization of scalable applications and data-driven solutions. My role involves working with full-stack technologies, cloud services, and data engineering tools to enhance system performance and drive business insights.
MOHARA logo

MOHARA

Software Engineer Intern

  • Proactively developed an internal course platform using the T3 stack and Sanity Studio as a CMS, showcasing initiative. Contributed to a client’s project by creating unit tests, refactoring OpenAI API queries, and resolving UI/backend issues, including optimising SQL CTEs to prevent redundancy.
HyperionDev logo

HyperionDev

Software Engineering - Coding Mentor

  • At HyperionDev, I leveraged my deep understanding of Software Engineering principles to review student submissions. I utilised technical skills including Python, Django, SQL, Software Design, OOP , and version control with Git. • Reviewed and provided feedback on 1000+ projects covering full-stack solutions, achieving a 97% average quality rating.

Education

The IIE's Varsity College logo

The IIE's Varsity College

Post Graduate Diploma in Data Analysis

  • Developing expertise in data-driven decision-making, statistical analysis, and machine learning.
The IIE's Varsity College logo

The IIE's Varsity College

Bachelor of Computer and Information Science in Application Development

Grade: 88%

  • Graduated from a rigorous curriculum in Computer Science with distinction (88%).

Get in Touch

Have a question or want to work together?

drmellors@gmail.com