Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic
Yordanos Girma Ayele

Yordanos Girma Ayele

Frankfurt Am Main

Summary

MSc student in Data Science with a strong foundation in computer science, data engineering, and statistical modeling. Proficient in designing and implementing ETL pipelines and optimizing database structures, with hands-on experience managing large, complex datasets. Committed to leveraging data-driven methodologies to enhance research quality, ensure compliance, and support informed decision-making. Eager to contribute analytical expertise to innovative projects that drive impactful results.

Overview

5
5
years of professional experience

Work History

Project Experience

University of Pisa
09.2023 - Current
  • Data Validation

Implemented KolmogorovSmirnov and Chi-square goodness-of-fit tests in Python to validate survey distribution. Ran Monte Carlo simulations to measure Type I/II error rates and automated exact p-value estimation.

Demonstrated ability to validate large datasets against benchmarks, mirroring clinical trial data checks.

  • Traffic Incident Data Warehouse

Designed and implemented ETL pipelines (SSIS, Python) to ingest and clean traffic incident records Built OLAP cubes (SSAS) for fast, multidimensional analysis and reporting.Applied data quality checks to ensure consistency across large, heterogeneous datasets.

  • UK Road Accident Analysis

Preprocessed and explored 1.6 million records of accident data; engineered features for analysis.Built predictive models (logistic regression, random forests) and clustering to uncover hidden patterns Collaborated in translating raw data into actionable insights, similar to preparing datasets for clinical research.

  • Customer Data Segmentation & Dashboards

Conducted audience segmentation for a nonprofit's Google Ad Grants campaigns. Designed performance dashboards (Power BI, Python) to track and optimize campaign outcomes. Showcased ability to present data clearly to non-technical stakeholders.

Data Analyst

G2G IT Solutions
03.2021 - 08.2023
  • Designed and maintained customer data pipelines (Python, SQL) to ensure accuracy, reliability, and availability of service-related datasets.
  • Implemented data validation and quality checks to improve consistency of customer records across operational systems.
  • Collaborated with both technical IT teams and customer-facing operations teams to translate requirements into actionable data solutions.
  • Created dashboards and automated reports (Power BI, SQL Server) to monitor service performance and support data-driven decision-making.
  • Resolved real-time data issues by troubleshooting inconsistencies and ensuring uninterrupted operations.
  • Documented and optimized data management processes, contributing to compliance and best practice standards.

Education

MSc - Data Science & Business Informatics

University of Pisa
Pisa, PI

BSc - Computer Science

Dilla University
01.2021

Skills

Programming & Data Engineering

  • Python (Pandas, NumPy, data pipelines, automation)
  • SQL (database queries, schema design)
  • ETL pipeline development (SSIS, Python)
  • Data warehouse & OLAP cube design (SSAS)

Data Quality & Validation

  • Statistical testing (Kolmogorov–Smirnov, Chi-square)
  • Monte Carlo simulations for error estimation
  • Data cleaning, preprocessing, and transformation

Analytics & Visualization

  • Power BI dashboards and reporting
  • Matplotlib for data visualization
  • Feature engineering and clustering
  • Predictive modeling (Logistic Regression, Random Forests)

Collaboration & Processes

  • Cross-team collaboration (IT operations customer teams)
  • Documenting and optimizing data processes

Other Technical Tools

  • PySpark MLlib (basic machine learning at scale)
  • Workflow modeling (BPMN with Camunda, Petri Nets with WoPeD)

Languages

English
Advanced (C1)

Timeline

Project Experience

University of Pisa
09.2023 - Current

Data Analyst

G2G IT Solutions
03.2021 - 08.2023

MSc - Data Science & Business Informatics

University of Pisa

BSc - Computer Science

Dilla University
Yordanos Girma Ayele