A/IAALQUIM IASELECTED WORK · CASE 09

CASE 09 · PRIVATE DEMO CONTROLLED OPERATIONAL WORKFLOW

EIA OS

A living project record that coordinates environmental work with roles and evidence.

EIA OS structures projects, technical and financial responsibilities, documents and states inside a multi-tenant application. Its staging uses controlled local authentication and organization-isolated persistence.

ROLEPRODUCT ARCHITECTURE · FULL-STACK DELIVERY2026
201unit + integration tests
22forced-RLS tables
56migrations
2,165 msP95 create/recalculate

PROJECT CARD / RECRUITER VIEW

The project's technical dossier.

EXPLICIT STATE PRIVATE DEMO
TARGET USER

Environmental consulting teams coordinating scope, owners, evidence, technical review and financial control.

WHAT I BUILT

I designed the product, the multi-tenant model, the roles, the operational workflows and the staging deployment with database and storage.

AI ENGINEERING SIGNAL / RECRUITER VIEW

Backend, APIs, deployment, testing and controls.

DEPLOYMENT
Staging on Oracle with web, PostgreSQL, storage and four workers reported ready.
BACKEND / APIS
Quotation domain, scenario calculation, PDF/XLSX export, audit and live/ready/worker health.
DATA / SECURITY
56 migrations; 22 tables with RLS enabled and enforced; 39 SECURITY DEFINER functions audited.
TESTING
103/103 unit, 98/98 integration, 32/32 concurrency and 8 local E2E all green.
PERFORMANCE
30 stress quotations with no failures; P95 create/recalculate of 2,165 ms; 30 exports generated.
ARCHITECTURE OVERVIEW
  1. 01Next application
  2. 02Local auth in staging
  3. 03PostgreSQL + RLS
  4. 04Object storage
  5. 05Operational worker
WHAT WORKS TODAY
  • Staging login
  • DB, schema and storage ready
  • Demonstration tenant
  • Technical, commercial and financial roles
HARD TECHNICAL DECISIONS
  • Enforce isolation by membership at the database
  • Never publish mutable credentials
  • Separate healthy staging from a finished commercial product
MEDIA AND DEMO
DEMO
Private and temporary for recruiters
SCREENSHOTS
Delivered with coordinated access
VIDEO
Pending recording
WHAT IS STILL PENDING
  • The environment shown is staging and is presented as a technical pilot, not a finished commercial service.
  • No reusable credentials are published: current roles can execute operational actions.
  • Recruiter access is delivered privately and temporarily after coordinating on LinkedIn.

01 / PROBLEM

A complex project needs more than a shared folder.

Scope, deliverables, owners, technical review and financial control evolve at different rhythms. Without explicit states and permissions, coordination depends on memory and scattered messages.

02 / DESIGN DECISION

Turn the project record into a work system.

The application organizes entities, roles, transitions and artifacts inside a tenant. Each user sees and operates only what belongs to their organization and responsibility.

SYSTEM / END TO END

The product as an explicit flow.

Each phase has a distinct responsibility. That separation makes it possible to observe, test and fix the system without relying on intuition.

  1. 01

    Configure

    Create organization, project, scope and participants with defined roles.

    TENANT
  2. 02

    Plan

    Translate the commitment into activities, deliverables and owners.

    SCOPE
  3. 03

    Execute

    Record progress and artifacts inside the operational record.

    WORK
  4. 04

    Review

    Apply technical and financial controls according to the authorized role.

    CONTROL
  5. 05

    Deliver

    Preserve state, evidence and history for project closure.

    PROOF

PROOF / WHAT IS ACTUALLY SHOWN

Evidence, not decoration.

The labels indicate whether the data was observed, comes from the artifact or belongs to the professional record of the case.

OBSERVED HEALTH · AUG 11 2026READYDB, schema and storage
LOCAL RELEASE VALIDATION201 / 201unit and integration
LOCAL RELEASE VALIDATION32 / 32focused concurrency tests
LOCAL RELEASE VALIDATION30 / 30stress quotations without failure

SCOPE / HONEST BOUNDARIES

What is demonstrated and what still needs validation.

A technical portfolio must also show where the available evidence ends.

  • The environment shown is staging and is presented as a technical pilot, not a finished commercial service.
  • No reusable credentials are published: current roles can execute operational actions.
  • Recruiter access is delivered privately and temporarily after coordinating on LinkedIn.

CASE 09 / EIA OS

A living project record that coordinates environmental work with roles and evidence.