A collection of academic and professional projects spanning full-stack development, data engineering, and analytics.
Conducted a data analysis project using R and RStudio to investigate time-based and geographical patterns of malicious SSH login attempts from a public Kaggle dataset. The project involved cleaning JSON data, geolocating IPs, and creating visualizations with ggplot2 to identify attack schedules.
Executed an in-depth analysis of a Goodreads book dataset by leveraging advanced PostgreSQL features. This project involved creating materialized views for frequently accessed data, using window functions to calculate author ratings, and implementing custom data types to structure complex information. Performed query optimization by creating indexes and analyzing execution plans to significantly improve data retrieval speed.
As a data analyst librarian, I designed and normalized a database to 3NF from a raw dataset of San Francisco Public Library usage. I developed and executed advanced SQL queries using PostgreSQL to answer key business questions, identifying trends in patron activity, checkout patterns across time, and relationships between patron age and library use to inform strategic planning.
Developed a customer-facing website and integrated a digital survey to streamline data management and enhance communication for Go Green Tree & Outdoor Services.
A data visualization project utilizing Microsoft Power BI to interpret complex datasets into actionable insights, based on the Microsoft Press curriculum.