Property Management System (PMS)

Steadfast Management was operating a growing property portfolio using a combination of spreadsheets, physical records, and manual financial processes. As the business expanded, these disconnected systems became increasingly difficult to maintain, resulting in inefficiencies, reporting inaccuracies, and significant administrative overhead.

To solve this, I designed and developed a centralized Property Management System (PMS) that automated core business operations, including tenant management, financial tracking, invoice generation, maintenance records, and reporting. The platform became the agency's single source of truth, providing real-time visibility into property operations while significantly reducing manual work.

The agency's day-to-day operations relied heavily on spreadsheets and manual processes that were no longer sustainable as the business scaled.

Key challenges included:

• —Excessive administrative workload caused by repetitive manual tasks.
• —Financial leakage due to fragmented records and inconsistent tracking.
• —Maintenance requests being tracked across multiple spreadsheets and physical logs.
• —Time-consuming invoice generation and tenant communication.
• —Inaccurate financial reporting caused by manual calculations.
• —Limited scalability for managing a growing number of properties and tenants.

These inefficiencies not only increased operational costs but also restricted the agency's ability to focus on growth and client service.

I worked closely with the business owner to audit existing workflows, identify bottlenecks, and map out a digital transformation strategy tailored to their operational needs.

The result was a fully custom Property Management System built using Next.js, TypeScript, PostgreSQL, Prisma, and hosted on DigitalOcean.

Key capabilities included:

One of the biggest challenges was migrating years of spreadsheet data into the new platform.

To solve this, I developed a custom Excel import and validation tool that enabled bulk data migration directly into the database while maintaining data integrity.

This reduced client onboarding and migration time by approximately 90%.

The implementation delivered immediate operational improvements across the business.

The Property Management System transformed Steadfast Management from a spreadsheet-driven operation into a scalable, data-driven business.

By automating critical workflows and centralizing operational data, the agency was able to reduce administrative overhead, improve financial visibility, and establish a technology foundation capable of supporting future growth.