Available for opportunities

Ahmadullah
Ahmadzai

Data Analysis & Development Economics

Double Master's from Göttingen & Florence. I specialize in humanitarian data analysis, econometrics, and turning large scale survey data into real world insights for development and policy.

Observations analyzed
64,812
Settlements tracked
10,802
Survey rounds · provinces
6 · 34
Tool Proficiency
Stata / RAdvanced
SQL / Power BIIntermediate+
PythonIntermediate
Analytical outputs Afghanistan CBNA — Key Visualizations
R · ggplot2 · rayshader · Kontur 2023
Population Density — Population Spike Map
3D spike map · Kontur 2023 · Mapped by A. Ahmadzai
Afghanistan 3D population density spike map
Stata · IOM DTM · 6 survey rounds
IDP Displacement Surge
Avg arrivals/settlement — peak Round 5, Dec 2021
0 150 300 450 180 220 290 340 449 380 Jun'20 Dec'20 Jun'21 Aug'21 Dec'21 ★ Jun'22 ↑ Taliban takeover
SQL · Power BI · IOM humanitarian data
Aid Coverage Growth
Settlement coverage: 30.8% → 80.5% across 6 rounds
0% 25% 50% 75% 30.8% 80.5% Jun'20 Dec'20 Jun'21 Aug'21 Dec'21 Jun'22 +49.7pp over 2 yrs
449
Avg IDPs/settlement
Round 5 peak
80.5%
Aid coverage
by Round 6
34
Afghan provinces
monitored
467
High-displacement
settlements, zero aid
3,090
Settlements in
triple deprivation
59→53%
School access decline
Taliban restrictions
01

About Me

I am a Development Economist and Data Analyst with a double Master's from the University of Göttingen and the University of Florence. My research sits at the intersection of humanitarian crises, internal displacement, and evidence based policy, using large scale panel data to understand how political transitions shape the lives of vulnerable communities.

“Humanitarian Aid and Internal Displacement during Political Transitions: Evidence from Settlement-Level Panel Data in Afghanistan” — Master's Thesis, 2025

My toolkit spans statistical programming (R, Stata), database management (PostgreSQL, SQLite), visualization (Power BI, ggplot2, plotly), and Python. I have processed IOM/DTM datasets with 64,000+ observations, built normalized relational databases, and produced publication-ready econometric results.

Beyond the technical, I have worked inside banking, research, and academic institutions bridging rigorous quantitative analysis with practical institutional realities.

Feb 2022 – Feb 2025
M.Sc. Development Economics
University of Göttingen, Germany
Double Degree
Feb 2022 – Feb 2025
M.Sc. Economics & Development
University of Florence, Italy
MAECI Scholar · Erasmus+
Sep 2016 – Jun 2020
B.Sc. Economics
International Islamic University, Islamabad
Jun 2025
PL-300 Power BI + SQL Bootcamp
Udemy Certification
Certified
Apr 2019
Data Analysis Certificate
NISTE, Islamabad · Excel, SPSS, Stata
02

Technical Skills

Statistical
Stata
R
Excel
SPSS
Database & SQL
PostgreSQL
SQLite
Window Functions
Data Modeling
Visualization
Power BI
ggplot2
plotly
QGIS
Other Tools
Python
LaTeX
Git
DAX / Power Query
03

Featured Projects

Rggplot2plotlysf / mapsIOM DTM
Project 01 /

CBNA Community Needs
Visualization in R

End-to-end visualization pipeline processing 6 rounds of IOM's Community-Based Needs Assessment across 12,000–16,000 Afghan communities. Full data cleaning, harmonization, choropleth maps with sf, heatmaps, trend charts, and interactive plotly dashboards revealing humanitarian disparities.

16,000 communities/round
6 rounds harmonized
R 100%
Vulnerability Heatmap · Province × Round Herat Kabul Helmand Kunduz Kandahar Nangarhar Badakhshan Balkh R1 R2 R3 R4 R5 R6 ↑ Peak Low High IDP
StataPanel DataFixed EffectsDiDEconometrics
Project 02 /

IDP Displacement & Aid Analysis
— Stata Econometric Workflow

Complete Stata pipeline analyzing IDP arrivals, aid delivery, and community vulnerabilities. Fixed vs. random effects models, clustered standard errors by province, lagged variables, interaction terms, and Difference-in-Differences for quasi-experimental evaluation of humanitarian intervention impact across 6 panel rounds.

Panel fixed effects
Clustered std errors
Hausman test
DiD eval
DiD — Parallel Trends + Coeff Plot Policy DiD Treatment Control 0 Aid IDPs Security Health School Coefficients
SQLSQLite3NF SchemaWindow FunctionsDiD
Project 03 /

Afghanistan CBNA Database
Design & SQL Analysis

Transformed a 64,812-row flat file into a fully normalized 3NF relational database covering 10,802 settlements across 6 rounds. Advanced SQL — LAG, RANK, NTILE, PERCENT_RANK, CTEs, difference-in-differences, moving averages, running totals, 5 reusable reporting views. Key: 467 high-displacement settlements received zero aid in Round 6.

64,812 observations
10,802 settlements
5 tables · 6 scripts
Window Function · Aid Gap Query -- Top provinces by IDP surge SELECT province_name, AVG(idp_arrivals) AS avg_idp, LAG(avg_idp) OVER (PARTITION BY province_id ORDER BY round_id) AS prev FROM observations province avg_idp prev_round Herat 894 612 Kabul 712 489 Helmand 680 401 Kunduz 521 388 10,802 rows · 0.08s 3NF · 5 tables
Power BIDAXData ModelingPL-300
Project 04 /

Interactive Power BI
Dashboard & Reporting

Interactive Power BI report with dynamic data modeling, DAX measures, drill-through capabilities, and publication-ready visual storytelling. Built following PL-300 Microsoft Data Analyst certification principles — star-schema relationships, calculated KPIs, slicers, and report publishing.

DAX measures
Star schema
PL-300 aligned
Interactive drill-through
CBNA Dashboard — Power BI 449 Avg IDPs 80.5% Aid Cover 10,802 Settlements 3,090 Triple Dep. IDP Arrivals by Round Aid Coverage Mix 3 types ▼ Province filter Kabul Herat All provinces
04

Experience

Jun 2025 – Oct 2025
Student Research Assistant
University of Göttingen
  • Data analysis, cleaning & management using Excel, Stata, and R
  • Literature reviews and academic paper summarization
  • Preparation of research presentations, reports, and publications
Göttingen, Germany
Apr 2020 – Aug 2021
Monitoring & Evaluation Officer
Afghan United Bank
  • Cleaned and analyzed operational data across departments to evaluate performance
  • Designed monitoring frameworks to track efficiency of banking operations
  • Generated reports and dashboards for senior management
Kabul, Afghanistan
Jan 2021 – Aug 2021
Intern Researcher — Economics Studies
Insan Research Organization
  • Organized, analyzed, and interpreted data for research projects
  • Translated official documents between Dari/Pashto and English
  • Prepared monthly research reports
Kabul, Afghanistan
05

Languages

Pashto
Native
English
Fluent
German
B2.1 Intermediate
Persian
Near-native
Hindi
B2 Upper-Int.
06

Get in Touch

Ahmadullah Ahmadzai
Ahmadullah Ahmadzai
Data Analysis & Economic Research · Göttingen, Germany

Let's build something
meaningful together.

Open to analyst roles, research positions, and data consulting especially in development economics, humanitarian analytics, and public policy. Open to remote and relocation.

Send an Email →