Incarcerated Person Medical PowerBI and Databases

Designed a scalable SQL database to support migration of medical analytics from an SSAS cube to a cloud-native Power BI solution. Improved data accessibility, reporting performance, and maintainability while aligning with the Sheriff’s Office modernization roadmap.

Facility Maintenance

Developed a weekly-updated cloud reporting system to track facility maintenance issues across all Sheriff’s Office buildings. Leveraged Power Automate and Azure Pipelines to automate ingestion and geospatial mapping of incidents, enabling leadership to target high-risk facilities and reduce downtime.

Contracts for San Diego Sheriff’s Office Grants Division

Created a cloud-based Power BI Contracts dashboard that tracks contract duration, remaining funds, and operational milestones for the Grants Division. Automated monthly refreshes using Azure Pipelines and Power Automate, eliminating manual reporting and improving financial visibility.

SeeRise

Developed a Streamlit application to visualize the impact of carbon dioxide levels on global temperatures and sea level rise, integrating emulator outputs for predictive modeling of Florida coastal flooding scenarios. Won Best Project Award at the HDSI Capstone Showcase!

Emulators Exploring the Climate

Programmed in a team to explore using emulators to predict the future from different socioeconomic shared pathways. Used Pattern Scaling, Gaussian Processes, and Random Forests.

Big O Explained

Programmed in a team to create an interactive visualization that explains Big O Notation to new coders using Python and graphs. Allowed website use for lower division data science classes.

Water Quality & Socioeconomic Status in CA

Explored the relationship between socioeconomic factors, race, and water quality in California. Found that socioeconomic factors affect water quality!

Investigating Abortion Rates

Explored how abortion rates changed in response to representation of female politicians, access to OB/GYN care, and income level. Worked with a team to find income level has little influence, OB/GYN rate has some influence, and women in government have a high influence.

League of Legends Model Building

Pair programmed to identify a binary classification problem, create a baseline predictive model using two features, and create an improved predictive model using six features and hyperparameters.

League of Legends Soul Analysis

Pair programmed to clean a DataFrame, used permutation tests to analyze missingness and missingness dependency, and created hypothesis tests to learn about the distribution of data.