Ram Maheshwari Logo Image
Hannah Allen
hamburger menu hamburger menu close

Hi There!
I'm Hannah Allen

An analytically driven Public Health, Evaluation and Business Data Analyst who thrives on condensing high volumes of data into a usable story that explores possible trends. Expert at working independently and collaborating in team settings across multiple functions to gather information from a myriad of sources to effectively explain complex concepts to a variety of audiences. Proficient in addressing complex challenges.

Projects

About Me I am a data analyst with 5+ years of experience in public health, research, and program monitoring and evaluation with skills in Excel, VBA, Tableau, nonSQL databases (MongoDB), SQL (PostgreSQL), Python3, SciPy, Numpy, Pandas, Matplotlib, R, HTML, CSS, JavaScript, Machine Learning and much more! Certification in Georgia Tech Data Science and Analytics. Master of Public Health with certification in Methods of Monitoring and Evaluating Public Health Programming. I enjoy leveraging diverse background and skill set to support well-developed and efficient analysis.

Get to know me!

Hey! It's Hannah Allen and I'm a Data Analyst located in Atlanta, Georgia. I've done remote projects for agencies, consulted for startups and research projects, and collaborated with talented people to create digital products for both business and research use.

I am an excitable problem solver with a thirst for solving puzzles and the ability to venture out of the box to find patterns within large sets of structured, semi-structured, and raw data. Over the years, I've used hundreds of web and mobile apps in different industries and verticals. Feel free to contact me here.

Contact

My Skills

HTML
CSS
Excel
VBA
Data Analysis
JavaScript
Python3
Pandas
Jupyter Notebook
Google Colab
PowerBI
Flask
Web-Scraping
API Interactions
GIT
Tableau
Github
MongoDb
SQL(PostgreSQL)
SQLAlchemy
ETO
AWS
ETL
GMaps
ArchGIS /GIS online

Projects Enjoy exploring my projects! These projects extract, transform and load data in order to analyze, and present data visuals - from supporting and analyzing data in healthcare, finance, government, UFO sightings, human resource databases, and more.

Software Screenshot

Project 1: VBA & Wall Street Data

Utilize VBA scripting to analyze real stock market data for 3 consecutive years (2018 - 2020)

Case Study
Software Screenshot

Project 2: Tableau Citi Bike Data Analysis

The focus of this analysis is to look at Jersey City Bike Station data and explore these considerations through stations.

Case Study
Software Screenshot

Project 3: Python-API & Vacation/Weather Data

Visualized the weather of 500+ cities of varying distance from the equator to plan to plan future vacations. Utilized weather API to filter hotels with desired weather conditions and visualized those hotels on GMaps.

Case Study
Software Screenshot

Project 4: Predicting UFO Sightings

In 2021, the US Department of Defense acknowledged the legitimacy of leaked UAP videos. Since then, the UFO community has come to the fore-front of the public eye and was the impetus for this analysis in predicting future UFO sightings.

Case Study
Software Screenshot

Project 5: Leaflet-Earthquake Data

Used the USGS 2022 earthquake data USGS GeoJSON Feed page, "All Earthquakes from the Past 7 Days" API to create the Earthquake Visualization.

Case Study
./assets/png/sql.png

Project 6: SQL/PGAdmin Employee Information Database

Designed tables to hold data from the original CSVs, imported the CSVs into a SQL database and analyzed the data for trends.

Case Study
Software Screenshot

Project 7: World Happiness Data Analysis

Analyzed World Happiness Datasets from 2015-2022, completed linear regressions to attempt to answer if weather, alcohol consumption, life expectancy and income impacts Happiness Scores.

Case Study
Software Screenshot

Project 8: Youth Obesity and Poverty ETL

Extracted Obesity Overweight and Weight Control Data from the 2017 Youth Behavioral Surveillance System data from Kaggle.com and compared it to poverty data for US School Districts from the 2017 US Census API. Extracted and transformed the data, then loaded the data into a SQL database in Postgres using python.

Case Study
Software Screenshot

Project 9: Mission to Mars Web-Scraping

Built a web application that scrapes various websites for data related to the Mission to Mars and display the information in a single HTML page.

Case Study

Contact I look forward to hearing from you! Please leave your contact information or reach out via Email Hannahgallen@gmail.com.