Sandra Hershey-Zagrans portrait
ARCeH Externship via Extern

Established professional returning to the workforce

I bring prior career experience and fresh focus after a planned break, ready to contribute reliably from day one.

Work samples

Work samples and summaries that reflect my prior professional experience and the types of roles I seek as I return to work.

  • Data Analytics, Health Outcomes Externship with ARCeH
    Data Analytics, Health Outcomes Externship with ARCeH
    ARCeH logo

    ARCeH · ✅ Verified by Extern · ⏱️ In progress

    Data Analytics, Health Outcomes Externship with ARCeH

    Here’s what the data says: put a pin in Bangkok. Draw a five-hour flight radius around it. You just circled half the world's population. And half of those people are kids under five, an age where survival itself isn't guaranteed. Five isn't an arbitrary number: it's the line researchers use as a proxy for a country's overall health, because almost every preventable childhood death, driven by a bad water source, poor air quality, or an infection nobody caught in time, happens before it. Clear five, and the odds of reaching adulthood jump astronomically. Don't, and the cause almost always traces back to poverty, healthcare access, environmental risk, or nutrition, something that could have been mapped, measured, and prevented in time. That's the gap this externship exists to close: turning scattered, messy public data into a specific, defensible answer about what's actually driving that risk in a given place, and pass it to the people at ARCeH who want to know about it.

    Data AnalysisData VisualizationData Storytelling

About me

I bring prior career experience and fresh focus after a planned break, ready to contribute reliably from day one.

I’m Sandra Hershey-Zagrans. I am an established professional reentering the workforce after a career break, ready to apply my prior experience to new opportunities and projects.

Externships

Data Analytics, Health Outcomes Externship with ARCeH

In progress

Skills

Workforce reentry experienceProfessional experience (established career)

✅ Verified by Extern · ⏱️ In progress

Data Analytics, Health Outcomes Externship with ARCeH

Here’s what the data says: put a pin in Bangkok. Draw a five-hour flight radius around it. You just circled half the world's population. And half of those people are kids under five, an age where survival itself isn't guaranteed. Five isn't an arbitrary number: it's the line researchers use as a proxy for a country's overall health, because almost every preventable childhood death, driven by a bad water source, poor air quality, or an infection nobody caught in time, happens before it. Clear five, and the odds of reaching adulthood jump astronomically. Don't, and the cause almost always traces back to poverty, healthcare access, environmental risk, or nutrition, something that could have been mapped, measured, and prevented in time. That's the gap this externship exists to close: turning scattered, messy public data into a specific, defensible answer about what's actually driving that risk in a given place, and pass it to the people at ARCeH who want to know about it.

Data AnalysisData VisualizationData Storytelling

Overview

The externship converted public health and environmental datasets into analytic evidence about drivers of under-five mortality around Bangkok. The work mapped relevant indicators, clarified the limits of correlational analysis, and produced a structured approach for combining disparate data sources into comparative, place-based analyses.

Data Analytics, Health Outcomes Externship with ARCeH

What I've accomplished

I produced a cleaned CSV of DHS STATcompiler data with 447 region-year rows (425 complete pairs) covering seven countries, and evaluated the dataset against a six-point quality checklist.

Project breakdown

I searched for and exported DHS STATcompiler data, converted it to CSV, and evaluated it against a six-point checklist. I produced a cleaned file of 447 region-year rows (425 complete pairs) covering seven countries, and noted limits to carry forward.

I inspected the DHS STATcompiler CSV, recorded that one row = one subnational region per survey, counted 473 rows and 11 columns, identified 26 national-total rows to remove, noted 425 usable regional rows after dropping incomplete cases, and outlined cleaning steps that produced a final…

Google Docs
Access

I selected Spearman rho and ran it within each country-survey. Across 19 rounds (13–34 regions each) rho ranged -0.51 to +0.74 (median -0.09), 11 rounds negative, 8 positive, three p<0.05; pooled data gave rho = -0.342 (p<0.0001).

Google Docs
Access
View all work