VERIFICATION & ENGINEERING METHODOLOGY

How ESERIA Builds, Executes & Grades Engineering Assessments

ESERIA Systems separates marketing statements from inspectable engineering facts. This page documents how The Citadel runs SQL and Python exercises locally in browser memory via DuckDB WASM, what metadata is saved server-side for rubric scoring, how five-stage submissions are graded, and which cloud security controls govern our platforms.

Published: October 15, 2026·Last Reviewed: November 10, 2026·Author: John J. Lawal (Lead Solutions Architect)

1. Client-Side Execution Model (DuckDB WASM & Pyodide)

In standard browser-based simulation drills, scenario CSV and Parquet tables are loaded into DuckDB WebAssembly inside the learner's browser tab rather than executing interactive queries on shared customer production databases.

Executed Locally in Browser
  • DuckDB SQL query parsing, joins, aggregations, and table scans
  • Intermediate result previews and query latency checks
  • Browser-side dataset inspection during active exploration
Sent to Backend for Grading & Records
  • Submitted SQL scripts, workbook formulas, and SCQA written memos
  • Deterministic test assertion outputs and rubric scoring breakdown
  • Cohort enrollment metadata, timestamps, and optional Uncaved SHA-256 hashes

2. Five-Stage Simulation & Rubric Verification

Rather than multiple-choice trivia, candidates progress through a structured diagnostic workflow where both code output and written reasoning are inspected:

  1. Problem Framing (SCQA): Identify business blast radius, clarify constraints, and state initial hypotheses before touching schemas.
  2. Schema & Data Triage: Inspect multi-table relations with null keys, duplicate events, and mismatched grain in DuckDB WASM or Python.
  3. Transformation & Modeling: Write reproducible SQL, dbt staging/mart logic, or Excel reconciliation formulas validated against deterministic assertions.
  4. Regression Handling: Resolve an introduced schema change or join fan-out edge case and verify output accuracy.
  5. Executive Memo & Rubric Review: Present findings clearly for automated rubric evaluation (and faculty review in institutional cohorts).

3. Infrastructure Security & Claim Policy

  • Transport & Storage Encryption: HTTPS / TLS 1.3 encryption in transit; managed PostgreSQL and cloud object storage with AES-256 encryption at rest via AWS and Firebase infrastructure.
  • Access Governance: Role-based access control (RBAC) and MFA for administrative operations, aligned with Nigeria Data Protection Act (NDPA 2023) workflows.
  • SLA & Benchmark Scope: ESERIA does not publish unaudited global uptime percentages or zero-risk fraud guarantees on public marketing pages. Institutional clients with contractual SLA needs receive custom service terms during procurement.
Reviewed Technical Documentation

John J. Lawal - Lead Solutions Architect, ESERIA Systems Ltd

Founder and principal systems architect in Abuja, Nigeria, responsible for custom enterprise deployments (KGERA, IVLEAD, RUIMUN, CEA) and the curriculum design of The Citadel assessment engine.