LETHEUM

Software Engineering / Systems Analysis

Software, data and the systems they operate in.

Work spanning full-stack applications, complex business software, relational databases and integrations.

The portfolio also covers independent research into organisations, institutions and decision-making.

The portfolio includes independently developed applications and anonymised technical experience from previous professional roles.

Explore Selected WorkResearch & Analysis
System layersApplication architecture
  1. APPLICATION
  2. BUSINESS LOGIC
  3. RELATIONAL DATA

What the work covers

Engineering

Full-stack development, databases, business logic, CRM and ERP applications, integration troubleshooting and application architecture.

Research & Analysis

Independent exploration of organisations, institutional structures, incentives, strategic dependencies and decision-making.

Additional experience Digital communication, marketing operations, stakeholder engagement and multidisciplinary project coordination.

Selected work

View all work

  1. Previous professional experience

    When SQL Returns the Wrong Answer

    Investigating incorrect operational figures across dependent SQL views, business rules and historical data.

    • SQL Server
    • SQL
    • Relational databases
    Read case study
    Calculation path. Relational records pass through dependent views and calculations to produce a report value.
    1. Source records
    2. Dependent views
    3. Report value

  2. Previous professional experience

    Keeping Data Consistent Across Applications

    Examining how records, calculated values and identifiers move between interconnected business applications.

    • PHP
    • SQL
    • REST APIs
    Read case study
    Integration path. Several operational records pass through transformation and mapping to one destination product.
    1. Source records
    2. Transform & map
    3. Destination product

  3. Independent application

    AI Suggestions Without Automatic Database Changes

    A CRM in which AI-generated proposals are validated and reviewed before approved database operations are executed.

    • Next.js
    • TypeScript
    • PostgreSQL
    Read case study
    Approval path. A generated proposal passes through validation and user approval before a database write.
    1. AI proposal
    2. Validation
    3. User approval
    4. Database write

Private application · Overview only

Learning & Education Platform

An independently developed full-stack educational application with authenticated workflows, study planning, assessment tracking, relational data and explainable rule-based recommendations.

  • Next.js
  • TypeScript
  • PostgreSQL
  • Drizzle ORM
  • Authentication
  • Server-side validation

Research beyond software

Independent research examines how organisations, institutions, economic incentives and technological systems influence decisions and outcomes.

The work includes conceptual modelling, stakeholder analysis, comparison of alternative explanations and scenario exploration.

Explore Research

Broader experience

Experience also extends to digital marketing, analytics, public-facing communication, organisational coordination and cultural or interdisciplinary initiatives. That work provides context for the engineering and research.

Broader Experience