Internal application / Case 01

ERP for a fragrance factory.

A custom system for a fragrance and cosmetics factory: machine maintenance, quality control, production and warehouse in a single environment.

  • Python
  • FastAPI
  • SQLite
Module diagram · conceptual representation

01 / Context

The starting point.

A fragrance manufacturing and filling plant, with production lines, machinery, quality controls and a warehouse, whose records and alerts were handled manually on paper and in Excel sheets.

02 / My contribution

From analysis to practice.

Functional scoping, rollout, testing and ongoing development of the system through AI-assisted development, working with maintenance, quality, production and warehouse teams to fit it to how the plant works.

Understand the plant

Turn each area's records and alerts into concrete modules and flows.

Build and validate

Develop, test on the shop floor and adjust the features with the people who use them every day.

Support the operation

Maintain and extend the system as new needs arise in the factory.

03 / Scope

What it solves.

Machine maintenance (a QR-coded record for each machine, interventions, history and spare parts), quality control (incoming material inspection, checklists and actions), production downtime logging, warehouse locations, IT support with an equipment inventory, and document management. It also covers goods receipt and dispatch, with weighing and dock appointments.

04 / Outcome

The project today.

System in use at the factory, bringing maintenance, quality, production and warehouse work together in a single environment.

Let's keep the conversation going

Have a similar challenge?

Tell me about it