This report contains conclusions and recommendations for a healthcare claim submission and payment platform for out-of-network medical procedures. Working for FreeFuse, our team analyzed user experience data to generate actionable insights. I used Google Sheets to clean and normalize the various data sets, which included numerous duplicate records. I used SQL to organize activity records into user sessions, and analyzed these for session length by user role, which revealed that a logoff timer had not been implemented. I also used SQL to identify which screens and UI elements users interacted with most often, isolating pain points in the user experience. Finally, I used Google Sheets to generate charts and data tables to effectively communicate these insights to stakeholders.

I created this presentation for an assignment in my Data Analysis program. We were asked to create a data presentation with data visualizations and a video/audio component of ourselves delivering the presentation. I chose online security as the topic because it's a topic of growing importance to everyone who uses the internet, and because I find it fascinating from a technical perspective. In the presentation, I highlight some concerning statistics in cybersecurity, and offer a few basic tips to help keep yourself out of trouble. I sourced data from the FBI's database of cyber events and processed it with MySQL. Visualizations were created using Google Sheets. 

As my final project for Harvard's CS50 SQL course, I created the Auto Repair Shop Workflow Management System. This is a MySQL database designed to simplify operations and record keeping for auto repair shops. It enables storing customer and vehicle information, recording work done and parts used, and tracking the part inventory stock status. The system compiles this information into digestible formats, enabling invoice generation, sales tracking, and more.

Front desk clerks can enter customer and vehicle information, create new invoices, view invoice notes, and generate completed invoices for customers. Technicians can view invoice notes to see which services the vehicle requires, and record the work that has been performed. The parts department can access and filter the parts inventory, and track part sales by item, category, date, or invoice. Management can review sales by time period. Customers can view and update their personal information after creating a password linked to their email address.

This is a sample data management plan I wrote for an assignment in my Data Analysis program. The assignment was to provide a data management plan for a data project that involved cleaning social security numbers and health information. I was asked to identify and explain the following:

• Data Types: What types of data are being collected, who will have access to the data sets, who will use the data, and what roles do the users have?

• Data Roles: Who might use the data, and how might those needs change over time?

• Data Documentation:  What types of metadata standards are appropriate? What kinds of other documentation might also be useful?

• Data Quality: Should data be cleaned and / or the quality be checked before being stored?

For my response, I researched metadata standards and how they are implemented, and I applied lessons from the course materials regarding the classification of data types and data roles.