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, PIBSc - 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