Arabic Flagship Program - Capstone Presentation

In May 2017, I gave a speech exploring my internship experience in Meknes, Morocco as part of the Arabic Flagship Program. I compared my legal internship and my internship with a local mechanic to the experiences I had back in the US. The presentation was given entirely in Arabic (mostly Modern Standard with some Moroccan Darija).

Computational Text Analysis of Arabic Newspapers

In the fall of 2016, my group conducted a computational analysis of news coverage surrounding the Arab Spring in Arabic language newspapers. Our analysis demonstrated the dominance of Egyptian protests across the Arab world. We used the R “tm” package and the “LDAvis” package to run topic modelson scraped newspaper articles. Click here to see the original Google document. Click below for a clean PDF.

Tools used: Microsoft Excel, R programming language

AI Hackathon for Equity - Curious GeorgePT Project

In October 2024, I attended a hackathon hosted by Hacks/Hackers in Baltimore city. My group created a custom OpenAI GPT model and engineered prompts aiming to make the model more curious and ask more questions of the user. Our project won the top prize of $500. You can read recaps of the hackathon from the host on their site or from Technical.ly.

Check out the final presentation slides by clicking on the project button below.

The City That Works

In 2023, I conducted an exploratory analysis of Baltimore City employee salary data. I wanted to calculate basic aggregate measures like median, minimum, and maximum salary, tenure, and average raise year over year broken down by city agency. I also wanted to demonstrate how to conduct an end-to-end data analysis project using publicly available data. I published my results in a Jupyter notebook and converted the notebook into an html document. The resulting report is published on this site. Click the project view button below to check it out!

Tools Used: Google Cloud Platform, Jupyter, Pandas

211 Maryland Data Dashboards

From March 2021 through October 2022, I built PowerBI reports displaying data on usage of the 211 health and human service referral system by Maryland residents. The reports query data from a MySQL database I built and stored in AWS RDS (Relational Database Service). I added data weekly using the MySQL command line tool after cleaning CSV exports using R.

Tools used: Amazon Web Services, PowerBI, R Programming Language

Community Court Watch in Baltimore City

From January 2020 through March 2021, I mapped cases of interest to city residents across the nine police districts in Baltimore. I collected data on charges brought, incident location, and outcome from my own work and other community liaisons on the office’s Community Engagement team. I used Excel and Google Maps to manage and visualize the data.

Tools used: Microsoft Excel, Google MyMaps

Health Equity Report in Douglas County, KS

In the fall of 2018 as part of the Health Informatics team, I helped write, research, and build visuals for the first Health Equity report in Douglas County, Kansas. We measured differences in health and economic metrics like infant birth weight, life exptectancy, income, and uninsured rate. We found that poor residents and residents of color do not live as long, as well, or make as much money as higher income residents and white residents.

Tools used: Microsoft Excel, R programming language