Andrew Aldrich | Full Stack Engineer

LiveBulletin

A virtual bulletin board that helps churches and schools keep announcements from getting lost.

C#React.NET Core AzureDockerEF Core MongoDBGitHub ActionsFirebase

THE CHALLENGE

Announcements get ignored

Physical bulletin boards at churches and schools are easy to walk past. Information about events and announcements rarely reaches the people who need it.

THE APPROACH

A cloud-native rebuild

I paired a .NET Core + EF Core API with MongoDB Atlas for storage, then containerized everything with Docker so it could scale horizontally on Azure.

THE RESULT

Ship on every commit

A React + Bootstrap frontend hosted on Firebase, wired to a GitHub Actions pipeline — one commit to main and the latest version is live.

team collaboration configurable security access

access from anywhere with mobile friendly design

Musicians Worship

A community for church musicians

C#Microsoft .NETAngularEntity FrameworkSignalR

In my spare time, I worked on a personal project that combined my passion for music and software development. I aimed to create a website to manage chord charts and resources for songs, and to establish a community for sharing these resources with the world. The site included features such as sending friend requests, creating groups for sharing ideas, adding songs, creating playlists, and other tools useful for church musicians. In one version, I even added a real-time instant messenger for users to communicate. In addition to the site, I created a help section with documentation. The search had a simplistic search correction to offer "did you mean" functionality. I rewrote the project 2-3 times to improve the code, and initially started in Angular.JS before rewriting the frontend in Angular. I still hope to publish this site, as I believe it could greatly improve the workflow for church music teams.

Tech Used In Project

I utilized .Net with Entity Framework for the backend. For the frontend, I used Angular. The realtime chat was written using SignalR.

Team Reporting Tool

A tool for team health

C#AngularEntity FrameworkMicrosoft .NETiOS & AndroidXamarin

I developed this tool to promote healthy teams in the workplace. I developed both a fully functional website and iOS and Android app. (Another developer helped create the marketing and styling for the site) Through building this application I learned a lot. It helped me grow in full stack development.

The tool allows a business to invite team members. Team members can then be assigned a leader. Every week team members fill out a report. It asks simple question, such as their high and low of the week and allows them to rate their stress, moral, and workload. Also, I allowed for users to customize the report to add their own questions and ratings.

Tech Used In Project

For the backend layer, Entity Framework was utilized to write and access the SQL database. The data was then passed through several layers of business logic, view models, to the APIs. Data was then consumed on the frontend. Angular was used in the frontend with Bootstrap for the styling.

AI/ML Support Ticket Urgency Predictor

Using AI & ML to predict urgency

PythonFlaskHTMLCSSJavaScriptAIMachine Learning

For my WGU capstone project I wrote a website that would use machine learning and AI to predict the urgency level of support tickets. The goal was that given a set of data that contains support tickets that have been labeled as urgent/not urgent on a scale of 0-3, the computer would be able to predict the urgency of a new support ticket. The project resulted in an accuracy result of 85.82%.

Tech Used In Project

I utilized Python for analyzing and build a model for the AI algorithm. Then I used the model and built the website using Flask. This made it easy to integrate the model and the site.

Generative AI Dynamic Web Page Generator

Using AI to create content and designs

HTMLCSSJavaScriptAIOpenAIChatGPT 4o Mini

AI Web page generator showing how entering a topic and description you get a stylized web page.

To deepen my understanding of AI, I developed a project to generate web pages based on a prompt. While generative AI could be used to generate HTML, I wanted to take a slightly different approach. Instead I fed into the AI model sections that represented HTML code. Each section defined what it was and what inputs were needed. I then allowed the model to choose the best sections and generate inputs for each section.

Tech Used In Project

For this proof of concept AI project it was written in JavaScript. I utilized the ChatGPT 4o mini model from OpenAI as the AI model.

AI Helpdesk Ticket Summarizer

Summarize support tickets

I built a tool at work to help our team, especially the developers, get the gist of helpdesk tickets at a glance and act accordingly. By pulling out critical details from each ticket, it saves our team the time of digging for context and key info. Also, since it's all about AI, nearly all of the code was generated via Copilot, but I approached the project as if I were writing it myself debugging, testing, and refining each piece individually before assembling everything into a working solution.

Node.jsOpenAIAPIs

Ticket #4821 — Legacy Helpdesk

Customer reports checkout fails intermittently after payment step, no error shown on screen, occurs across browsers, started after last deploy...

AI Summary posted to ClickUp

Checkout silently fails post-payment since the latest deploy — likely a regression, not a customer error.

Sales Tracker — Blazor Hybrid

Track inventory and sales

A demo built to explore Blazor Hybrid — one shared codebase running offline-first on desktop, mobile, and browser. It includes a sales dashboard, real-time inventory validation, and a data layer that swaps storage implementations (SQLite vs. IndexedDB) by platform.

BlazorMAUIC#SQLiteIndexedDB

Penguin Jump

An infinite penguin runner

A spare-time infinite runner built in Unity, with power-ups, sound effects, and a coin-based skin store. The penguin artwork started as my sister's marker sketch — I digitized it myself.

C#UnityGame Design

AndrewAldrich

Interfaces people enjoy using

APIs and logic that hold up

Shipping without the drama

One codebase, every device