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.
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.
- DuckDB SQL query parsing, joins, aggregations, and table scans
- Intermediate result previews and query latency checks
- Browser-side dataset inspection during active exploration
- 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:
- Problem Framing (SCQA): Identify business blast radius, clarify constraints, and state initial hypotheses before touching schemas.
- Schema & Data Triage: Inspect multi-table relations with null keys, duplicate events, and mismatched grain in DuckDB WASM or Python.
- Transformation & Modeling: Write reproducible SQL, dbt staging/mart logic, or Excel reconciliation formulas validated against deterministic assertions.
- Regression Handling: Resolve an introduced schema change or join fan-out edge case and verify output accuracy.
- 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.
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.