Problem
The organisation needed to move from scattered data and manual processes to a common operational base with access control, modules and reporting capability.
Anonymised case
Modular operations platform for a foundation
Design of an internal platform to organise people, projects, modules, permissions and operational reporting without exposing sensitive data.
- Client type
- Foundation, anonymised by default
- Technologies
- ReactViteReact AdminFirebase AuthSupabasePostgreSQLSQLCloudflare
Constraints
- Sensitive personal and operational data.
- Need to coexist with existing tools.
- Non-technical teams who needed clear screens and reliable exports.
- Gradual rollout by module to reduce risk.
What was done
- Data model for people, projects, groups, activities, employees and the relationships between modules.
- React/Vite applications and administration with React Admin.
- Firebase authentication and authorisation against Supabase/PostgreSQL.
- Deployment routes, documentation, deactivation controls and operational validation.
Governance and security
- Access by module and active user.
- Hard delete disabled on administration screens.
- SQL templates, backups and post-migration checks.
- Separation between public information and internal documentation.
What it demonstrates
- Ability to bring together process, data, authentication and operational screens.
- Judgement to build module by module rather than attempt a wholesale replacement in one go.
- Attention to security, continuity and handover.
Result
The organisation gained a clearer base for managing operations, permissions and reporting without multiplying independent spreadsheets.
Related services
Connected areas
Service
Data, indicators and dashboards
Turns scattered spreadsheets, forms and applications into reliable indicators for management and accountability.
View service ServiceBespoke operational tools
Small internal applications for when Excel, forms and disconnected SaaS no longer support the daily work.
View service ServiceFractional IT Director
A senior part-time IT function for organisations that are too small to maintain IT leadership of their own.
View service ServiceIT governance, continuity and operations
Clarifies who controls the systems, where the data lives, how access is protected and what happens if something fails.
View serviceDoes this fit your situation?
Briefly describe the operational, data or AI problem. The first reply can help to guide the type of diagnostic.