Gavin Rose

• Supported 440+ undergraduate students across four semesters in applying statistical techniques to financial data, strengthening their ability to make data-informed business decisions and interpret market dynamics. • Facilitated instruction on regression analysis, descriptive statistics, log transformations, and correlation using Microsoft Excel, emphasizing their use in financial modeling and strategic business analysis. • Demonstrated probabilistic methods, including binomial and normal distributions, hypothesis testing, and expected value calculations to help students assess risk and simulate global economic scenarios. • Delivered 4+ hours of academic support weekly through structured office hours and exam review sessions, strengthening students’ quantitative reasoning and confidence in solving complex business problems.

• Monitored attendance, participation, and assignment submissions for 50 students using Google Sheets and Canvas, and applied Excel-based forecasting to ensure grade distributions remained consistent across course sections. • Held review sessions to reinforce key concepts in business ethics and equity, supporting student comprehension while maintaining academic integrity through assignment feedback and performance tracking. • Summarized weekly student data to assist faculty with final evaluations, contributing to a more transparent and data-informed grading process. • Supported course operations by managing administrative tasks and coordinating with faculty to maintain consistency in instruction and evaluation across multiple class sections.

• Guided 46 undergraduate students in applying Excel and Access tools such as Monte Carlo simulations, What-If Analysis, Solver, Goal Seek, Xlookup, Ifs, and Index to model financial scenarios and support data-driven decision-making. • Demonstrated advanced Excel techniques including Power Query, Power Pivot, and PivotTables to enhance data accuracy, streamline reporting processes, and strengthen financial analysis capabilities. • Facilitated review sessions and partnered with professors, teaching assistants, and peer tutors to clarify business concepts involving database design, scenario modeling, and Excel-based decision support systems. • Supported in-class instruction by resolving technical questions and guiding students through data management principles, improving their ability to analyze, interpret, and present business information effectively.

• Leveraged SQL and Excel to clean and organize Salesforce data, helping the sales team enhance the accuracy of reports and make more confident, data-driven decisions. I focused on identifying inconsistencies and restructuring account records to support more precise forecasting and long-term planning. • Identified and corrected duplicate and missing entries in Salesforce, which improved the accuracy and structure of account data across the CRM. These efforts streamlined the sales process and uncovered previously untracked accounts with potential for future client engagement and revenue growth. • Created forecasting models in Excel to help the sales team plan for future staffing needs. These models were used to align hiring timelines with business goals and ensure that revenue coverage remained consistent as the company scaled. • Collaborated with teams across marketing, IT, and customer service to build dashboards and reports using Tableau and Power BI. These visual tools helped translate complex data into clear insights, supporting company-wide initiatives and improved visibility into performance metrics.