Ethan Yu

Loyola Marymount University, College of Business Administration | Los Angeles, CA
Bachelor of Science, Information Systems & Business Analytics | Minor in Computer Science
May 2024

• Dean’s List 2021-2023 Academic Year
• Relevant Coursework: Database Management Systems, Data Visualization & GIS, Business Information Technology, Computer Programming (Python), Data Structures, Network & Cloud Computing, Fundamentals of Finance, Operations & Supply Chain Management

LMU Financial Planning & Analysis | Student Budget Analyst | Los Angeles, CA
May 2022 – Present

• Collaborated closely with budget managers, assisting in executing 200+ budget amendments and reclassifications cross referencing Excel, Workday, and Longview planning, improving budget accuracy
• Analyzed large financial datasets by generating 100+ budget reports and financial models using advanced Excel functions such as VLOOKUP, pivot tables, and filtering for precise budget analysis and decision making

FoolProof Foundation | Financial Literacy Mentor Intern | Los Angeles, CA
May 2022 – August 2022

• Delivered comprehensive financial literacy instruction twice a week to middle and high school students, covering diverse topics such as budgeting, investing, and financial planning
• Collaborated with fellow mentors to create structured lesson plans utilizing FoolProof modules and visually engaging PowerPoint slides, optimizing the learning experience for students

El Pollo Inka | Social Media Manager | Torrance, CA
February 2020 – August 2021

• Successfully coordinated marketing efforts for INKA CARES during COVID-19, creating impactful flyers and managing a fundraising campaign on GoFundMe that raised over $3,000
• Photographed visuals, utilized Adobe Photoshop and Lightroom skills to edit visuals and enhance brand awareness for INKA CARES on El Pollo Inka's Instagram platform

Career Analysis: Shaq vs. Michael Jordan in Tableau

• Merged and cleaned 2 data sets containing game data from Shaquille O’Neil and Michael Jordan
• Utilized Tableau visualizations functions to compare their peak seasons, then creating a dashboard to conclude the data visualizations
• Conducted in-depth statistical analysis to identify key performance trends and insights in the data

Sports Analytics SQL Database

• Leveraged SQL to analyze NBA game data extracted from datasets on Github
• Analyzed individual player and team performance, identified trends, and constructed predictive models and forecasts for future game outcomes

SQL, Java Script, AWS, Python, Tableau, Microsoft Excel, Pivot Tables, Microsoft Access, Workday, Adaptive Planning, Longview Planning, Bloomberg, Adobe Photoshop/Lightroom

• Ignatian Leadership Capstone | Loyola Marymount University
• Eagle Scout | Boy Scouts of America