Ange-Ghislain KOUAMEData Engineer
FR

Selected Work

Selected Work

Professional systems first, then academic work. Each status says exactly how far a project went: nothing proposed is presented as delivered.

  1. In internal use

    Public Procurement Data Platform

    From a raw spreadsheet extract to certified, traceable and documented data: layered ETL, rule catalogue, star schema, semantic model and Merkle integrity certificates.

    Period
    2026, ongoing
    Context
    Ivorian Ministry of Economy, Finance and Budget · internal tool
    Stack
    Python · pandas · Jupyter · SQL Server 2022 · T-SQL
  1. Prototype

    Explainable Risk Scoring and Unsupervised Anomaly Detection

    An auditable scoring grid, forensic tests and a Keras autoencoder benchmarked against FAMD, with success criteria fixed before computation and limits reported as found.

    Period
    Oct 2026
    Context
    Analytical extension of the procurement data platform · awaiting business validation
    Stack
    Python · pandas · NumPy · scikit-learn · SciPy
  1. In development

    Secured Data Catalogue and Internal Portal

    A DDI/NADA metadata catalogue hardened for restricted microdata, a tested library module, and server upgrades rehearsed on a full replica with scripted rollback.

    Period
    2026, ongoing
    Context
    Internal portal of the Financial Control Directorate · not exposed to the internet
    Stack
    NADA 5.4 · World Bank Metadata Editor · PHP 8.4 · MySQL 8.4 · Apache 2.4
  1. Delivered

    Budget Execution Audit Analytics

    An end-to-end audit pipeline on official budget data for a ministry section, from raw spreadsheets to an interactive diagnostic and an automated audit narrative.

    Period
    Mar 2026
    Context
    Ministry of Agriculture and Rural Development · budget section 229, fiscal year 2024 · official State data
    Stack
    Python · pandas · Metadata Editor · Power Query · Power BI
  1. Delivered

    State Budget Resources and Expenditure, 2011 to 2019

    A macro-budgetary datamart and dashboards on nine years of official Ivorian budget data.

    Period
    Feb 2025
    Context
    Official, collected and verified State budget data
    Stack
    Power BI · DAX · Power Query · Excel
  1. Demonstration

    French Property Prices 2025: Pipeline, Audit and Dashboard

    Public data, full method: 3.8 million property transfer lines turned into a controlled pipeline, an audited dataset documented to DDI standards and an interactive dashboard.

    Period
    Nov 2026
    Context
    Public dataset: Demandes de valeurs foncières (DVF), DGFiP, 2025 · Licence Ouverte 2.0
    Stack
    Python · pandas · NumPy · DDI-Codebook 2.5 · Dublin Core
  1. Academic

    Business Intelligence for a Film Rental Business

    A snowflake model, KPI design and temporal, revenue and customer analytics in Power BI.

    Period
    Mar 2025
    Context
    Relational rental database (actors, films, customers, stores, countries)
    Stack
    Power BI · DAX · Power Query · Snowflake schema
  1. Academic

    Comparative COVID-19 Modelling

    Data preparation, polynomial regression and a Lotka-Volterra model on five countries, evaluated with R², RMSE and MAE, and read with their limits.

    Period
    Mar 2025
    Context
    Senegal, Côte d'Ivoire, Burkina Faso, France, USA · Jan 2020 to Dec 2021
    Stack
    Python · pandas · scikit-learn · Matplotlib · Seaborn
  1. Academic

    Retail Sales Datamart

    A complete BI chain for a hypermarket: Talend ETL into a MySQL datamart feeding sales and performance dashboards.

    Period
    2024 to 2025
    Context
    Centralisation of sales data for strategic KPIs
    Stack
    Talend · MySQL · Data visualisation