Skip to main content

Client engagement through NeoSOFT

Client engagement through NeoSOFT

Centralized Multi-School ERP: Architecture and Engineering Leadership

Client engagement through NeoSOFT on a centralized multi-school ERP. My work covered solution architecture, cross-module workflows, production and reliability investigation, reporting decisions, and delivery leadership with the wider team.

Node.jsNestJSTypeScriptPostgreSQLRedisKafkaGCPReactMetabase

Overview

A centralized multi-school ERP shared by schools and head-office functions — not presented here as a true SaaS multitenant product. Module boundaries covered student lifecycle, admissions, academics, finance-related operations, transport, access control, notifications, configuration, integrations, and reporting. Architecture notes separate implemented platform patterns from recommendations that were not yet validated in production. Capacity discussions used an expected concurrency context around 15,000 concurrent users; that figure is a design expectation, not measured production concurrency.

Architecture notes

  • Centralized multi-school architecture with shared platform capabilities across schools and head office
  • Web and mobile clients over domain-oriented backend services
  • PostgreSQL-centered transactional workloads with Redis for session/cache context
  • Kafka-oriented notification and event paths where applicable
  • Reporting via portal and Metabase paths; embedding selected Metabase reports treated as proposed follow-up
  • Expected concurrency around 15,000 used as design context only — not a published load test result

Problem

Multi-school operations needed consistent information and controlled workflows across schools, head-office functions, and parent/staff applications — without collapsing every school into a one-size-fits-all process or leaving cross-module ownership ambiguous.

Constraints

  • • Client confidentiality — public naming stays anonymized as a centralized multi-school ERP
  • • Ongoing institutional operations during delivery
  • • Process variation across schools
  • • Mixed maturity across modules and workstreams
  • • Some investigations produced recommendations that remain unverified
  • • 15,000 concurrency is design expectation only; school-count and total-user figures are not published pending owner confirmation

Solution

Framed the platform around institutional actors and reusable workflow modules, with explicit attention to domain boundaries, integration edges, production investigation, reporting classification, and release governance. Personal contribution centers on solution architecture, technical review, requirements clarification, production analysis, team coordination, and delivery leadership — distinct from implementation completed by the wider team.

Results

  • • Clarified cross-module architecture and workflow ownership for a centralized multi-school ERP.
  • • Supported production investigation and remediation planning, distinguishing observation, immediate stabilization, later investigation, and proposed follow-up.
  • • Defined release and review responsibilities that make technical decisions and handoffs more explicit.
  • • Documented reporting decisions around definitions, freshness, access, and refresh ownership.
  • • Created focused case studies on performance, reporting, and governance from the same engagement.

Lessons learned

In education ERP work, actors, permissions, calendars, and module boundaries are product decisions first. If those stay vague, every later integration and report becomes expensive. Separate what was defined, what was implemented, and what was validated. Do not equate a centralized multi-school platform with SaaS multitenancy unless the tenancy model is explicitly designed and evidenced.

Related

  • Investigating Performance and Reliability in an Enterprise ERP

    Within the school ERP engagement, Redis memory growth, PostgreSQL CPU pressure, materialized-view refresh load, query amplification, middleware latency, and connection-pool concerns were investigated. This case separates observation, immediate stabilization, later investigation, proposed follow-up, and measured results where actually available.

  • Defining Release Governance for Enterprise Engineering Teams

    For the school ERP program, contribution focused on making SRS sign-off, walkthroughs, technical-flow ownership, architecture review, QC evidence, PR governance, environment access, release impact/rollback, production checks, and RCA expectations explicit.

  • Designing Reporting Across ERP Workflows

    Operational and executive reports needed consistent business definitions, freshness choices, access hierarchy, and refresh ownership — distinguishing live, near-real-time, materialized-view, and nightly-summary paths, and separating existing portal/Metabase reporting from proposed embedded Metabase work.

  • ERP / Business Application Solution Blueprint

    Clarify actors, workflows, rules, data boundaries, and integrations before committing to build or rebuild scope.

  • Architecture Review

    An architecture health check for systems with growing risk, technical debt, difficult integrations, or change that has become expensive.

  • Production Performance & Reliability Diagnostic

    Investigate slow APIs, database and cache pressure, timeouts, and recurring incidents — then prioritize remediation with a validation plan.

  • Technical Leadership & Delivery Advisory

    Senior guidance for architecture decisions, technical planning, review governance, release readiness, and engineering execution.

  • All selected work

    Flagship project, case studies, and design studies.

Working through something similar?

Tell me what you are building or where the system is struggling. We can identify whether an architecture review, ERP blueprint, performance diagnostic, or technical advisory is the right next step.