Skip to content

Serhat Aslan

Data EngineerResearcherM.Sc. in Data Science

Currently at BMO · Warsaw, Poland

Hi, I'm Serhat. I'm a data engineer with 5 years of experience and an M.Sc. in Data Science. I build data pipelines, data warehouses and reports that help teams make better decisions.

Right now I work at BMO, closely with the QA and UAT teams: I prepare the test data they need for their test case creation and I support them end to end while they test.

Certifications

Fabric Data EngineerMicrosoft Associate · 2025Microsoft exam that proves I can build and run data pipelines, lakehouses and data warehouses on Microsoft Fabric.Click to verify on Microsoft Learn.Azure AI EngineerMicrosoft Associate · 2025Microsoft exam that proves I can build AI solutions on Azure, like language, vision and search services.Click to verify on Microsoft Learn.Fabric Data WarehouseMicrosoft Applied Skills · 2024Hands-on Microsoft lab test: I had to build a working data warehouse in Microsoft Fabric, not just answer questions.Click to verify on Microsoft Learn.
ITILITIL®Foundation · 2023Widely used standard for running IT services well: how teams plan, deliver and support the systems people use.

Current role

What I do today

Test Data Management Specialist at BMO

2025 – Present

Bank of Montreal · enterprise banking systems

  • Work closely with QA and UAT teams and prepare the test data they need to create their test cases.
  • Give end-to-end test support, from setting up test data to checking results during test runs.
  • Build and manage test data sets for many connected banking systems.
  • Mask and anonymize sensitive data so test environments are safe to use.
  • Use SQL to find, extract and validate data and to solve data issues quickly.
  • SQL
  • Test Data Management
  • End-to-end testing
  • UAT
  • Data Masking

Latest projects

Newest first — click a project to see how the data flows

    1. SourcePrices · Macro · News
    2. FinBERT + MIDAS
    3. Multimodal Transformer
    4. Return · Volatility · Correlation
    5. OutputPortfolio VaR

    Risk-aware multimodal Transformer that fuses market prices, macroeconomic series and FinBERT news sentiment to forecast returns, volatility and cross-asset correlation for portfolio VaR. 88 runs under leakage-safe walk-forward validation, rigorous significance testing, 100+ unit tests.

    PyTorch · Transformers · FinBERT · Time seriesView code ↗︎
    1. Source277K complaints
    2. TF-IDF
    3. SMOTE
    4. Logistic Regression
    5. OutputF1 0.747

    Text classification on 277K CFPB consumer complaints (stratified to 10K). Four models compared on TF-IDF features; Logistic Regression with SMOTE reached F1 0.747.

    scikit-learn · NLP · TF-IDF · SMOTEView code ↗︎
    1. SourcePostgreSQL
    2. Debezium
    3. Kafka
    4. Spark
    5. OutputDelta Lake · Bronze → Silver → Gold

    End-to-end change data capture: every Postgres insert, update and delete is captured by Debezium, streamed through Kafka and processed by Spark into a medallion lakehouse on Delta Lake and MinIO, with a star schema in Gold. Fully Dockerized.

    Kafka · Debezium · Spark · Delta Lake · DockerView code ↗︎
    1. SourceStreamlit UI
    2. FastAPI
    3. GPT-4 + travel APIs
    4. OutputItinerary

    LLM trip planner combining GPT-4 with attraction, weather and hotel APIs to generate city itineraries, served by a FastAPI backend and a Streamlit UI.

    FastAPI · OpenAI · StreamlitView code ↗︎
    1. SourceDocuments
    2. Sentence Transformers
    3. FAISS
    4. Gemini
    5. OutputFaithfulness · Relevance

    Compares retrieval-augmented generation techniques (hybrid retrieval, reranking, metadata filtering, chain-of-thought) with Gemini, FAISS and Sentence Transformers.

    Python · Gemini · FAISS · StreamlitView code ↗︎
    1. SourceSAP · Salesforce · Dynamics · Karmak
    2. Azure Data Factory
    3. SQL Server DWH
    4. OutputPower BI

    CI/CD-driven cloud warehouse unifying 25+ source applications. Replaced legacy data services with Azure Data Factory and streamlined data flow across platforms.

    Azure Data Factory · SQL Server · Data Warehousing · CI/CD

Experience

My career path, newest first — click a role for details

  1. 2025 – PresentNow

    Test Data Management Specialist · BMO

    Test data and end-to-end test support for QA and UAT teams.

    • Work closely with QA and UAT teams and prepare the test data they need to create their test cases.
    • Give end-to-end test support, from setting up test data to checking results during test runs.
    • Build and manage test data sets for many connected banking systems.
    • Mask and anonymize sensitive data so test environments are safe to use.
    • Use SQL to find, extract and validate data and to solve data issues quickly.

  2. Aug 2024 – Oct 2024

    Business Analyst · Köksan

    Reporting systems and business data structures.

    • Analyzed and optimized internal reporting systems and business data structures.

  3. 2022 – 2024

    Data Engineer · TEMSA

    Built the Azure data warehouse for 25+ applications and led their cloud migration.

    • Designed the data warehouse architecture and ETL processes for 25+ applications on Azure.
    • Replaced legacy data services with Azure Data Factory, integrating SAP, SQL Server, Salesforce, Dynamics and Karmak.
    • Led cloud migration projects for 25+ applications, improving scalability and efficiency.
    • Built 50+ Power BI dashboards and optimized 100+ SQL queries.
    • Introduced data governance, master data management, data catalog and data masking.

  4. 2022

    R&D Project Leader · TEMSA

    Requirements and delivery tracking for 10+ R&D projects.

    • Collected client requirements and tracked delivery for 10+ projects.
    • Organized 50+ project documents into a maintainable knowledge base.

  5. Sep 2021 – Dec 2021

    Data Analyst Intern · Badem Information Systems

    Neural network models and stakeholder reporting.

    • Built 5+ neural network models and presented findings to 10+ stakeholders.

Technologies

Tools I use in my daily work

  • SQL
  • Python
  • Azure Data Factory
  • Microsoft Fabric
  • Power BI
  • SQL Server
  • PostgreSQL
  • Spark
  • Kafka
  • Docker
  • DAX
  • PyTorch

Education

University degrees

M.Sc. in Data SciencePolish-Japanese Academy of Information Technology (PJATK), Warsaw · thesis on multimodal Transformers

2024 – 2026

Bachelor's degree

Çukurova University, Adana, Türkiye

© 2026 Serhat Aslan · Data Engineer · Warsaw, PolandTurkish (native) · English (C1) · Greek (C1) · Polish (A2)