JOHN BREWER

Valorant Group Project - Business Intelligence

Project Overview: Analyzed professional Valorant player data to identify overpowered characters needing nerfs.

• RapidMiner, Decision Trees, RMSE, Kaggle
• Built a decision tree model to identify underperforming characters using pro player data.
• Applied RMSE to define a performance threshold and highlighted overpowered characters (Chamber and Raze).
• Visualized results in a decision tree, providing actionable insights on balance changes.

Airline Traffic Delays and Cancellations Project - Tableau

Project Overview: Analyzed and visualized major causes of airline delays, cancellations, and traffic in the USA (2016-2017).

• Created interactive dashboards to track flight delays, cancellations, and on-time performance.
• Analyzed seasonality patterns and state-level flight delays, providing insights into systemic delays.
• Presented key findings through synchronized dashboards for clear, data-driven decision-making.

  SQL Database Design - Hospital System

Project Overview: Designed and implemented an SQL database to manage hospital records, including physicians, patients, and payments.

• Developed an ERD to model relationships between physicians, patients, and payment information.
• Implemented SQL DDL statements to create tables for Physician, Patient, Payment, Invoice, and Invoice_Total.
• Ensured database integrity with foreign key relationships and optimized for performance and scalability.

Eagle Scout, Boy Scouts of America, Highest Rank Achievable in the Boy Scouts of America. Eagle Scout Service Project was a helicopter pad for the Maury County Emergency Management Department.