Project case study
Horse Racing Syndicate | Custom Role-Based Portal Replacing Spreadsheet-Driven Operations
Designed and built a custom syndicate management platform that replaced spreadsheet-heavy workflows with a secure, role-based web application for managing ownership information, operational visibility, and day-to-day syndicate processes.
- SaaS Portal
- Role-Based Access
- Authenticated Dashboard
- Workflow Automation
- Product Design
- React / Next.js
- PostgreSQL
- Operational Systems
Need help replacing manual ops with product-style workflows? Browse implementation services or start a scoped discussion.
Systems involved
- Spreadsheet-driven legacy workflow
- Authenticated user portal
- Role-based dashboards
- Structured operational data
- Workflow replacement logic
- Product-style architecture
- Role-based visibility controls
- Ongoing platform support
Overview
Horse Racing Syndicate was created to solve a real operational issue. Core processes were previously handled through spreadsheet-driven workflows and fragmented data handling, which added unnecessary day-to-day friction. The project moved that workflow into a secure, role-based portal so operational information became structured, visible, and easier to manage.
The brief
Scope and implementation targets
The goal was to replace spreadsheet-heavy syndicate operations with a secure, role-based platform that improved operational visibility, reduced manual friction, and provided a maintainable product foundation.
- Replace spreadsheet-heavy workflows with a secure role-based portal
- Provide authenticated account access for operational visibility
- Deliver role-based dashboards for different user types
- Move toward structured data handling beyond manual spreadsheet management
- Improve day-to-day workflow clarity and operational control
- Establish a maintainable platform foundation for future expansion
The challenges
Operational friction points
The earlier setup relied too heavily on manual updates and spreadsheet tracking. That approach created avoidable friction as data grew, user needs diverged, and visibility requirements became more complex.
- Spreadsheet-led processes created repetitive manual updates and avoidable friction
- Operational information was fragmented and not surfaced through a dedicated user portal
- Access control needed clearer structure around who could view and manage what
- Different user groups required different levels of visibility and workflow access
- Manual handling became harder to manage as platform and operational requirements grew
- The system needed to become more professional without introducing admin complexity
What I delivered
Delivery focused on turning spreadsheet-led operations into an authenticated, role-based product workflow with practical maintainability.
Custom portal application
Built the project as a dedicated portal experience rather than a marketing site, with authenticated access and product-style screen flows.
Role-based access control
Implemented role-aware access behaviour so different users could view the right information and workflows without unnecessary exposure.
Dashboard-driven UX
Designed and delivered dashboard interfaces that made operational information easier to scan and manage than spreadsheet-led processes.
Workflow replacement planning
Mapped manual syndicate operations into structured digital flows, reducing dependence on disconnected tools and repetitive admin steps.
Structured data model
Shifted toward application-style data handling so platform operations could stay cleaner, easier to maintain, and more consistent over time.
Product-style implementation
Balanced business workflow needs with practical system design, treating delivery as product engineering rather than front-end styling only.
Secure authenticated experience
Implemented secure account-based access so sensitive operational information could be controlled and surfaced to the right users.
Platform foundation for growth
Delivered a maintainable baseline that supports future features, improved workflows, and ongoing operational refinement.
Key outcomes
Google reviews
What the client said
Approved Google review content matched to this case study.
This section only appears when an approved Google review is linked to this project.
Approved Google reviews
5.0
Based on 1 approved Google review
an hour ago
“PKTechie did a great job building our Horse Syndicate platform. He understood our business needs well and helped turn a manual, spreadsheet-heavy process into a much more streamlined and professional system. He was reliable, easy to work with, and delivered a high-quality result. Highly recommend.”
Positioning note
Why this project matters
Horse Racing Syndicate shows the kind of engineering work that is often under-represented in portfolios: replacing messy manual workflows with a structured product system. The value is not only the interface; it is the shift to authenticated, role-based delivery that improves operational clarity and creates a maintainable platform.
Services involved
- Product and portal design
- Custom web application development
- Role-based access implementation
- Authenticated dashboard UX
- Workflow digitisation
- Structured data and system design
- Business process simplification
- Ongoing platform support
Tech and platform
- React / Next.js
- PostgreSQL
- Authenticated user portal
- Role-based access
- Dashboard UI
- Structured application data model
Final summary
Horse Racing Syndicate started as a response to spreadsheet-driven operational friction and moved into a secure, role-based web platform. The result is a stronger product-oriented foundation that supports cleaner day-to-day workflows and future platform growth.
Need a custom portal that replaces manual workflows?
I help businesses turn spreadsheet-heavy operations into secure, role-based product workflows that are easier to manage and scale.
You can also browse more project work for related portal and implementation examples.