Skip intro
Mehrad Andalibi

Software · Data · AI · Ottawa

View projectsResume (PDF)

About

I build software, work with data and keep learning, and I study the business side on purpose, so the technology fits how organizations actually run.

  • Studying

    Bachelor of Technology, Business Systems Development

    Algonquin College

  • Open to

    Software, IT, data & BI, and AI roles

    Including co-op

  • Preparing for

    AWS Certified Solutions Architect

    Associate

  • Based in

    Ottawa, Ontario

    Canada

I'm a software developer in Ottawa. After graduating from Algonquin College's Computer Programming diploma, I'm now completing a Bachelor of Technology in Business Systems Development. My foundation is in Java and Spring Boot, RESTful APIs and relational databases, and I've built on it with SQL, Python and statistics for working with data.

I'm most interested in the places where technology meets the business: data analysis and business intelligence, AI tools and agents, IT systems, and the orchestration layer that connects autonomous systems to the software organizations run on. I'm open to software, IT, data, BI and AI roles, and eager to keep learning wherever the work takes me.

Skills

The languages, frameworks and tools I work with, from the tiers of an application to data and analysis, plus what I'm learning next.

  • Java
  • SQL
  • JavaScript
  • Python
  • PHP
  • Dart
  • Shell
Tier 1

Web

Presentation

  • HTML
  • CSS
  • JavaScript
  • PHP
Tier 2

Backend

Business logic

  • Spring Boot
  • Java Servlets
  • MVC Architecture
  • RESTful APIs
  • DAO Pattern
  • JUnit Testing
  • Session Management
  • Auth & Access Control
Tier 3

Databases

Persistence

  • MySQL
  • Oracle
  • SQL Server
  • Microsoft Access
  • MongoDB
  • Neo4j

Data & analysis

Querying, analysing and reporting on data

  • SQL
  • Python
  • Statistics
  • Google Analytics

Learning now

Where I'm growing next

  • AWS cloud architecture
  • Business intelligence
  • AI agents & LLM APIs
  • AI coding tools
Runs onGitLinux / UNIXRHELUbuntu

Projects

Now building · Project 01

Fleet Orchestrator

A fleet manager for autonomous mobile robots that speaks VDA 5050, the open standard warehouse robots use to receive orders and report their state. It dispatches transport orders over MQTT, tracks each robot's live state, and is being built to recover cleanly when things go wrong.

  • Java
  • Spring Boot
  • Maven
  • MQTT · Mosquitto
  • Docker
  • VDA 5050
Message flow · simulated order state
Fleet managerSPRING BOOTBrokerMOSQUITTOagv-aIDLEagv-bIDLE

  • ADR-001

    Wildcard subscriptions

    Subscribe to uagv/v2/+/+/state so new robots appear without configuration changes.

  • ADR-002

    Raw state, derived view

    Store each robot's raw last State message and derive the view from it, rather than mutating a model.

  • Release plan

    v0.1 → v0.2

    Happy path with two simulated robots by October 2026, failure recovery by November 2026. Dashboard later.

The laptop screen in the intro film and this diagram are illustrative previews, not captured output. The repository goes public with v0.1.

Earlier projects

Enterprise Java web application · 3-tier

Public Transit Fleet Management System

Enterprise-level Java web application built with Servlets, MVC architecture and the DAO pattern. Modular vehicle management, GPS tracking, secure authentication with role-based access control, and JUnit-validated business logic.

  • Java Servlets
  • MVC
  • MySQL
  • JUnit
ptfms · live fleetIllustration
Vehicle managementGPS trackingRBAC

Full-stack web application

Algonquin College Blog

Responsive full-stack web application for managing dynamic college blog content, with a database-driven backend and a clean, responsive front end.

  • PHP
  • SQL
  • HTML/CSS
  • JavaScript
blog-posts.phpIllustration
Campuspublished

Welcome week schedule

Careersdraft

Co-op fair: what to bring

Librarydraft

New study rooms open

Object-oriented Java

Logistics Company Core

A foundational Java application for shipping and inventory management. Applies strict object-oriented principles to practical business logic, integrated directly with SQL databases.

  • Java
  • SQL
  • OOP
  • Inventory tracking
logistics-core · shipmentsIllustration
Inventory62% stocked
  • SHP-1042Pallet · 24 unitsPicked
  • SHP-1043Crate · 6 unitsIn transit
  • SHP-1044Parcel · 2 unitsPicked
  • SHP-1045Pallet · 18 unitsIn transit

Database design

Lavender Grill Database

SQL Server database architecture for a restaurant, centred on structured relational schema design. Efficiently manages and queries complex menu and order relationships.

  • Microsoft SQL Server
  • RDBMS
  • Schema design
lavender_grill.sql · schemaIllustration

Education

  1. In progress

    Bachelor of Technology, Business Systems Development

    Algonquin College, Ottawa, ON

    Building the business, systems-analysis and project-management side on top of a software foundation.

  2. May 2024 – December 2025

    Computer Programming Diploma

    Algonquin College, Ottawa, ON

    3.95GPA / 4.0

    Relevant coursework: Data Structures & Algorithms, Database Systems, Web Development, Object-Oriented Programming, Software Engineering.

Certifications

  • AWS Certified Solutions Architect – Associate

    Amazon Web Services · Preparing

  • Advanced Google Analytics

    Google Digital Academy · 2021

  • Digital Marketing

    Tehran Institute of Technology · 2020

Contact

Say hello