Manchester, New Hampshire, United States
Public Health & Environmental Data Analyst | M.S. Environmental Biology 📍 Based in New Hampshire (Serving Concord, Manchester, Nashua, and nearby Mass) 📧 Reach me directly: [email protected] or message me on LinkedIn. My Story I'm a data analyst with an M.S. in Environmental Biology focused on public health and environmental data — work where findings inform real decisions about communities and resources. TECHNICAL TOOLKIT Visualization: Certified Tableau Desktop Specialist, Power BI, Excel Dashboards Database/SQL: MySQL, SQL Server (ETL, data cleaning, relational architecture) Analysis: Python (Pandas, Matplotlib) Domain Expertise: Environmental Health Metrics, Population Surveillance, Social Determinants of Health (SDOH) KEY PROJECTS & IMPACT Customer Churn Analysis: Identified $1.5M in annual revenue at risk across 1,869 churning customers. Month-to-month contracts churn at 4x the rate of two-year contracts; newest customers churn at nearly 47%. Built and published a 5-view Tableau dashboard segmenting churn by contract type, tenure, and service type. Green Space & Public Health: Analyzed County Health Rankings data across 59 counties in five New England states to examine the relationship between park access and health outcomes. Income-stratified analysis revealed that park access correlates with health outcomes differently by income level — with direct implications for resource allocation. Public Health Analytics: Modeled U.S. obesity correlations (2011–2024) across 50+ states to identify high-risk regional trends. Harvard Forest LTER Ecological Monitoring — 4-dashboard Tableau Story analyzing 60+ years of climate, phenology, and forest composition data; identified a statistically significant warming trend of +0.030°C/year. Hubbard Brook Precipitation Analysis: Analyzed long-term precipitation trends at the Hubbard Brook Experimental Forest using Power BI, visualizing ecological patterns across multiple decades of LTER data. Foundation: Completed the Data Analytics Accelerator, a 10-module intensive bootcamp under Avery Smith covering Excel, SQL, Tableau, Power BI, Python, and R. Full portfolio published at davidhmills.carrd.co. THE DTM ADVANTAGE As a Distinguished Toastmaster (DTM) — the highest credential from Toastmasters International — I make complex data findings accessible and actionable for decision-makers at every level. Professional Working Proficiency in French (DELF B2 certified, June 2026). I passed the four-part exam comfortably with an overall score of 71. A passing score is 50100.
Title: Independent Data Analytics Portfolio Company: Self-directed / independent study Dates: 2026 – Present (set the start month to when you began the churn project — see my note below) Location: Concord, NH · Remote Description: Designed and built six end-to-end analytics projects spanning commercial and scientific domains, each taking the work from raw data through modeling to an interactive dashboard and a communicated finding. Customer Churn Analysis (Excel, SQL, Tableau) — identified $1.5M in annual revenue at risk across 1,869 churning customers; found month-to-month contracts churn at roughly four times the rate of two-year contracts. Green Space & Public Health (Tableau, Excel, SQL) — analyzed park access against health outcomes across 59 New England counties using income-stratified SQL analysis. Harvard Forest Climate Analysis (Excel, Tableau) — examined six decades of forest climate and composition data, quantifying a long-term warming trend and a multi-decade shift in dominant tree species. Hubbard Brook Precipitation (Power BI) — built a DAX-driven dashboard on 65 years of federal precipitation data, surfacing a 68% rise in major storm events. Drinking Water Safety (Python) — used Python to analyze road-salt chloride loading against aquatic-safety thresholds. U.S. Obesity & Physical Inactivity (Excel) — conducted a multi-year CDC trend analysis with data-quality validation.
- Built 9 comprehensive data analytics projects using SQL, Python, R, Tableau, Power BI and Excel. - Built interactive dashboards - Demonstrated Expertise in data visualization, statistical modeling, and database optimization. - Performed statistical analysis using Python (Pandas, Matplotlib, Seaborn) and R for predictive modelling. - completed the tenth and final module in early February 2025.
Description: Built foundational analytics skills through structured certificate programs in Power BI, Tableau, MySQL, and advanced Excel. Earned the Maven Analytics MySQL certification with an 88% score (top 15% of cohort), developing command of SQL query optimization and relational database concepts.
Description: Ensured high-quality data accuracy by scoring student math and reading projects against predefined criteria. Consistently maintained a superior scoring accuracy, achieving over 90% on math projects and 80% on interpretive reading projects, significantly exceeding the required 70% benchmark. Quality Assurance played a major role in this position.
Location: Concord, New Hampshire, United States · On-site Description: Collected and validated demographic data from 10-50 residences daily using standardized government protocols. Managed Sensitive Personally Identifiable Information (PII) while conducting community-level demographic surveillance in the Concord area. Achieved a 90% response rate from at-home residents through strategic data collection methodologies.