LETHEUM

Selected work

Projects and professional experience

Professional systems work, independent products and experience across commercial and organisational contexts. Each account identifies the nature of the work and the contribution involved.

Professional Systems Work

Previous professional experience

When SQL Returns the Wrong Answer

Operational reports depended on several layers of views, calculations and historical records.

Investigating an incorrect figure required tracing its origin across dependent SQL structures and checking the business rules represented by the data.

Read case
Compare SQL totals

Illustrative model

Which rows reach the total?

Compare the report calculations

Report total200

Source order

ORDER-01

100

Rows included in the sum

  • ORDER-01100
  • ORDER-01100

Report total

200

Two matches repeat the same order. The query runs and the report shows twice the real value.

Report total100

Source order

ORDER-01

100

Rows included in the sum

  • ORDER-01100

Report total

100

When the measure is order value, restore one row per order before summing. The result returns to the source amount.

Previous professional experience

Keeping Data Consistent Across Applications

An integration between a business application and an e-commerce platform required transformations across different data structures.

The work involved PHP, REST APIs, aggregating source records, calculating availability and maintaining consistent identifiers and product attributes.

Read case
Compare API requests

Illustrative model

What does the shop receive?

Compare API operations

Availability sent

Business application

Record A
3
Record B
2
Record C
4

Mapping & aggregation

Match the product identifier and add the source quantities.

3 + 2 + 4 = 9

Calculated availability

Shop payload

PRODUCT-01

9

Availability

The three records become one product in the shop. The create request includes its calculated availability.

Availability omitted

Business application

Record A
3
Record B
2
Record C
4

Mapping & aggregation

Match the product identifier and add the source quantities.

3 + 2 + 4 = 9

Calculated availability

Shop payload

PRODUCT-01

—

Availability

The update still identifies the product, but this payload leaves out availability. A successful request alone cannot tell you whether the figure changed in the shop.

Independent private application

AI Suggestions Without Automatic Database Changes

A full-stack CRM integrates hosted and local AI models to prepare proposed data operations.

The application validates and reviews proposals before authorised data changes are applied. Human approval remains part of the workflow.

Read case
Open the approval example

Illustrative model

What changes the stored record?

Compare approval states

No write

  1. Structured proposalUpdate a contact record
  2. ValidationFields checked
  3. Human approvalPending
  4. DatabaseNo write

Validation checks the proposal. The application still waits for a person to review and approve the change.

Authorised write

  1. Structured proposalUpdate a contact record
  2. ValidationFields checked
  3. Human approvalRecorded
  4. DatabaseAuthorised write

Approval permits the operation. The application writes the authorised change and records what happened.

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.

Selected professional experience across separate assignments
2020–present

Beyond the Click

Websites, e-commerce development, marketing measurement and CRM operations, with the contribution and context of each assignment kept distinct.

Landing pages, marketing analytics, WordPress and WooCommerce, email campaigns, contact segmentation and CRM workflows. The account distinguishes the work across separate assignments.

Read Experience Feature

Community leadership and collective project experience
Italy, 2026

Coordinating Across Institutions, Communities and Historical Memory

Communication materials, operational programme work and coordination contributions to a collective initiative promoted by Đông Sơn, at Palazzo dei Trecento in Treviso on 26 September 2026.

Public communication, stakeholder engagement and project preparation through a leadership role in an Italian-Vietnamese community association. Responsibilities were shared among participants and organisers.

Read Experience Feature

Independent research directions and proposed applications are described separately.

Read Research Directions

Discuss your project

Tell us what you’re trying to resolve and where you’d like Letheum to help.

Discuss a project