Skip to content
View ouchchenomar's full-sized avatar

Block or report ouchchenomar

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
ouchchenomar/README.md

Hi, I'm Omar Ouchchen 👋

Junior Data Engineer in Casablanca, Morocco. I build data pipelines that are tested, documented and safe to rerun, from ingestion to reporting, with a focus on financial data and data quality.

Portfolio LinkedIn Email

💬 Looking for a full-time Data Engineering role.

🚀 About me

  • State Engineering Degree (Master's level) in Knowledge Engineering and Data Science, ESI Rabat, July 2026.
  • Final-year internship in the Trading Room of Attijariwafa Bank (CIB): Python/SQL pipelines with Airflow and dbt, Bronze/Silver/Gold modeling in PostgreSQL, data quality checks and a data catalog.
  • Oracle Cloud Infrastructure certified (Data Science Professional and Foundations Associate, 2025).

📚 Featured projects

Data warehouse for the quarterly filings of 4,547 U.S. banks (FDIC API): idempotent ingestion (SHA-256), data contract, revision history and SCD2, publication blocked if any of 65 dbt tests fails, daily Airflow orchestration and a Power BI dashboard. Totals are within 0.5% of the official FDIC figures.

Stack: Python, PostgreSQL, dbt, Airflow, Power BI, Docker

Counterparty reference data fed by the GLEIF API (211 Moroccan LEIs, incremental ingestion). 7 dbt data quality rules tested against ground truth (64 of 64 anomalies detected, 0 false positives), golden record and quarantine.

Stack: Python, dbt, DuckDB, Airflow

Credit scoring on synthetic data: 20+ data quality rules, 19 features, Random Forest (AUC 0.93), SHAP explainability, a FastAPI API, a Streamlit dashboard for the risk department and monthly drift monitoring (PSI). 38 tests.

Stack: Python, scikit-learn, SHAP, FastAPI, Streamlit, Docker

Star schema built from a raw CSV, checks in Power Query, DAX measures (sales, orders, average order value) and the monthly revenue trend.

Stack: Power BI, Power Query, DAX

Other projects

  • RAG system: semantic search (TF-IDF or Sentence Transformers) over PDF and TXT documents, a local GGUF LLM (TinyLlama, Mistral), a FastAPI API and a web interface.
  • Real estate price prediction: Linear, Ridge and Lasso regressions compared on California Housing, the best one served by a Flask API in Docker on Google Cloud Run.

💼 Experience

  • Attijariwafa Bank – CIB, Trading Room, Casablanca · Feb – Jun 2026 · Final-year internship, Data Engineering, Data Governance and BI. Onbor, an internal platform prototype that digitizes client onboarding: ETL/ELT pipelines (Python, SQL, Airflow, dbt), Bronze/Silver/Gold architecture in PostgreSQL, data quality checks and data catalog, FastAPI APIs, documentation and user acceptance tests.
  • TAMWILCOM, Rabat · Jul – Aug 2025 · Document AI assistant (RAG) on financial products: PDF extraction, embeddings, FAISS index, FastAPI backend, Streamlit interface.
  • Doosys, Rabat · Jul – Aug 2024 · Took part in requirements analysis and Odoo customization (document management), testing and user guides.

🛠️ Skills

Data engineering Python SQL Apache Airflow dbt PostgreSQL DuckDB FastAPI

BI and data quality Power BI DAX Data quality Data catalog

Tools and cloud Docker Git Oracle Cloud Google Cloud Run

Currently learning: PySpark, Databricks.

🏆 Certifications

  • Oracle Cloud Infrastructure 2025 Certified Data Science Professional (Oracle, 2025)
  • Oracle Cloud Infrastructure 2025 Certified Foundations Associate (Oracle, 2025)
  • Machine Learning Specialization, 3 courses (Stanford / DeepLearning.AI, 2024)
  • Exploratory Data Analysis for Machine Learning, with Honors (IBM, 2024)
  • Introduction to Power BI (DataCamp, 2025)
  • Agile Project Management (Google, 2024)
  • Python for Data Science, AI & Development (IBM, 2023)
  • Google courses: Foundations: Data, Data, Everywhere (2023) and Ask Questions to Make Data-Driven Decisions (2024)

🎓 Education

  • State Engineering Degree (Master's level), Knowledge Engineering and Data Science · École des Sciences de l'Information (ESI), Rabat · 2023 – 2026
  • Preparatory Classes (CPGE), Mathematics and Physics · Lycée Prince Moulay Abdellah · 2021 – 2023

🌍 Languages

French: fluent (TCF 2025: C1 on the multiple-choice tests) · English: professional proficiency · Arabic · Amazigh

Pinned Loading

  1. fdic-bank-data-warehouse fdic-bank-data-warehouse Public

    Data warehouse for the quarterly filings of 4,500 U.S. banks (FDIC): duplicate-free ingestion, revision history, gated publication. Python, PostgreSQL, dbt, Airflow, Power BI.

    Python

  2. counterparty-data-platform counterparty-data-platform Public

    Governed counterparty reference data: incremental ingestion of GLEIF LEIs, data quality rules tested against ground truth (64/64 anomalies caught, 0 false positives), quarantine and golden record. …

    Python

  3. Credit-Risk-Scoring-Portfolio-Monitoring Credit-Risk-Scoring-Portfolio-Monitoring Public

    End-to-end credit risk scoring on synthetic data: 20+ data quality rules, Random Forest (AUC 0.93), SHAP explainability, FastAPI API, Streamlit dashboard and PSI drift monitoring. 38 tests, Docker.

    Python

  4. ML_housse_prediction ML_housse_prediction Public

    House price prediction on California Housing: Linear, Ridge and Lasso regressions compared on MSE, best model served by a Flask API in Docker on Google Cloud Run.

    Python

  5. PowerBI_Suivi_Ventes PowerBI_Suivi_Ventes Public

    Power BI sales dashboard: star schema built from a raw CSV, Power Query checks, DAX measures (sales, orders, average order value) and monthly revenue trend by region and product.

  6. RAG_sys RAG_sys Public

    Retrieval-augmented generation system: semantic search (TF-IDF or Sentence Transformers) over PDF and TXT documents, local GGUF LLMs (TinyLlama, Mistral), FastAPI API and web interface.

    Python