This portfolio is a growing collection of analytics and operations projects. It highlights work with SQL, reporting, and efficiency improvements as I transition deeper into data analytics.

  • Summary: Using the information in the dataset answer the question. Does going to university in a different country affect your mental health?

    Tools: SQL, DataCamp, DataLab

    Link: Download Project Report

  • Summary: Utilized Point of Sale and Excel to reconcile computer inventory levels with physical counts of material. Improved ordering by reducing amount of overstock while keeping proper inventory levels on ground.

    Programs: POS, Excel

  • Summary: Build a 16X10 pergola on existing deck. Completed solo over 3 weekends.

    Tools: Treated Lumber, Air Powered Tools, Hammers, Drills, Levels, Saws

    Images: Pictures

  • Summary: Implemented and created new league website, went from complex manual game scheduling to efficient automated system

    Programs: Quickscores.com

    Link: loraincountysoccer.org

  • Summary: Designed a themed night-light enclosure featuring superhero motifs — built using CAD and optimized for printability.

    Tools: Printed with durable filament, finished for safety. Used Anycubic FDM 3D printer.

    Images: Pictures

  • Summary: Clean and validate dataset, explore and analyze the dataset, create and define a metric for the business to monitor, summarize findings, include graphs and visuals

    Tools: R, SQL, Excel, Markdown, DataLab, Powerpoint

    Link: Download Project Report, Second Project Report, Second Project Visual Presentation

  • Summary: Used dispatch management system to optimize routing, reduced turnaround time by 25 minutes

    Program: DDMS

  • Summary: Build a 16X10 floating deck with a flight of stairs. Lead 3 person crew for 1 day.

    Tools: Treated Lumber, Air Powered Tools, Hammers, Drills, Levels, Saws

    Images: Pictures

  • Summary: Center stabilizer bar on tractor bent. Cut old bar off, replaced and welded new bar. Replaced seals on hydraulic cylinder.

    Tools: Angle grinder, welder, wrenches

    Images: Pictures

  • Summary: Modified slicing parameters and firmware settings on a FolgerTech FT-6 to improve print consistency, precision, and reduce material waste. Designed small mechanical parts to replace worn components, proving ability to handle reverse-engineering, fit tolerances, and mechanical functionality.

    Tools: wrenches, screwdrivers, computers, wires, filament motherboards, various PCB boards and switches, heat syncs, heaters

  • Summary: Designed and fabricated a modular sling-retention device for an airsoft training replica to enhance carrying stability and quick transition handling

    Tools: Filament, screws, nuts and washers, Anycubic FDM 3D printer

    Images: Pictures