Samuel Okotako
ITENFR

Selected engineering work

From ideas to systems.

Data pipelines, governance and analytics: projects presented through concrete problems, technical decisions and available evidence.

4 projects shown
01 / 04Privacy engineering · synthetic PoC

Data Governance & Masking

PII classification and consistent pseudonymization across synthetic relational data.

Problem
Protect sensitive identifiers without breaking relationships and constraints across tables.
Technical approach
Inventory, classification, masking and validation with explicit policies.

Python · PostgreSQL · YAML

Read case study
  1. 01Generate
  2. 02Inventory
  3. 03Profile
  4. 04Classify
  5. 05Mask
  6. 06Validate
02 / 04Data Engineering · synthetic data

E-commerce Data Pipeline

Incremental pipeline handling corrections, late data, quality checks and a dashboard.

Problem
Avoid duplicates and inconsistent metrics when corrections and new columns arrive.
Technical approach
Python and DuckDB for generation and ingestion; dbt for staging and marts; Streamlit reads the snapshot.

Python · DuckDB · dbt · Streamlit

Read case study
E-commerce project Streamlit dashboard with KPIs and charts from synthetic data
03 / 04ITS course project · group work

NoSQL Big Data with Databricks

Inside Airbnb listing analysis for Amsterdam and Rio de Janeiro: exported Bronze, Silver and Gold layers, with documented execution limits.

Problem
Organize listings and reviews from two cities into separate layers for comparable analysis.
Technical approach
The exported notebooks define four Delta Bronze tables, one Silver listings table, and Gold views/queries. A Silver reviews table is described but not defined in the archive.

Databricks CE · PySpark · Spark SQL · Delta Lake

Read case study
  1. 01Bronze: 4 tables
  2. 02Silver: listings
  3. 03Gold: views and queries
04 / 04Electronics · final school project

Arduino electronic radar

An educational prototype for detecting nearby objects, built as a final project.

Problem
Detect nearby objects with an educational electronic system.
Technical approach
An Arduino proximity-detection prototype. The presentation connected the project to the historical evolution of military technology between the two world wars.

Arduino · components to confirm

See education
Conceptual illustration; prototype specifications still need verification
Available details
Context
Final project for the Electronics and Automation diploma at I.T. Archimede.
Problem
Detect nearby objects with an educational electronic system.
Technical approach
An Arduino proximity-detection prototype. The presentation connected the project to the historical evolution of military technology between the two world wars.
Available evidence
Presented as a final school project. Measurements and specific components still need verification.
Technology
Arduino · components to confirm