RESTful API

I have the pleasure of working on two high-profile pieces of business software that require fullstack development experience.

Yalla

Tech Stack - PHP (CodeIgniter 3), MySQL (RDS 5.4 to 8.1), Vue.js 2, AWS

Yalla is an all-in-one CRM that offers task and project tracking, chat features, and client information. I had two major contributions, and many minor updates and maintenance features to this softare during my time at Lemonade Stand.

First, I performed a major update to a live database; taking MySQL 5.4 to MySQL 8.1 with no downtime. Using AWS RDS blue/green deployment to maintain continuity during the upgrade, and ensuring ongoing snapshots are taken for temp rollbacks or disaster recovery.

Second, I personally built out a robust services and revenue tracking dashboard as an addition to this software. This portion involved significant DB schema overhaul as well as fresh API additions. Fortunately, the frontend did not require much refactoring as the primary layout of the application was well established, though it did take some familiarity with UIKit to seamlessly integrate.

In addition, I was responsible for ongoing UX/UI, bug tracing and resolution, and customer support for all aspects. This software is designed to integrate with many different platforms to make data transfer simple and seamless. While I was not part of the development of these endpoints, I was involved in many of the debugging processes for existing integrations.

Yalla is a complex team-management software and while it took some time to become familiar with the ins and outs, I believe that my contributions have added a layer of usefulness and functionality that otherwise was sorely lacking.

To visit, please navigate off site here: Yalla
Foreground image

Build Then Bless

Tech Stack - PHP (CodeIgniter 4), MySQL (RDS 8.0), Vue.js 3, AWS

Build Then Bless is an employee development platform designed to improve company culture from the bottom up. This software was already functioning when I came onto the project and had a number of users already signed up. While working on this project I was tasked with project managing the mobile development side of BTB, debugging during onboarding of new agencies, disaster recovery, and general efficiency among other things.

I believe my most impactful contribution to BTB was a platform-wide performance audit focused on improving speed, scalability, and database efficiency.
Some highlights are:

  • Refactored inefficient PHP patterns (array_column, array_search, N+1 queries) to cut memory and CPU usage.
  • Optimized MySQL queries by eliminating index-blocking patterns like DATE(created_at) and unindexed filters.
  • Shifted key business logic to the database using views, stored procedures, triggers, and scheduled events.
  • Reduced load on cron jobs and batch operations while preparing the system for long-term growth.
In all, this initiative directly improved app responsiveness and laid the groundwork for a more maintainable, scalable backend. Given more time, I would continue to iterate through and implement more efficiency changes as I do believe there is a deep well here. Further, I would work with the team to establish efficiency standards for the kinds of logic that shall continue to live in PHP and which should, by default, be moved into the database.

Check out the software here: Build Then Bless

Contributions

Together, I believe these two projects paint a clear picture of my backend knowledge and my approach to development. Efficiency is in the foreground of my concern, and database logic is my preferred method of handling key business logic.
Thank you for your time.

Foreground image