Current Private Equity Analyst Intern

Diane Li

*******@*.************.*** 786-***-**** LinkedIn GitHub Davie, Florida

EDUCATION

Northwestern University Evanston, IL

Bachelor of Science in Economics & Theatre Minor: Business Institutions Expected Jun 2027

• GPA: 3.72/4.00 Dean’s List SAT Math: 790/800, SAT Reading & Writing: 740/800

• Relevant Coursework: Accounting, Python for Data Science, Econometrics, Macroeconomics, Microeconomics, Calculus, Statistics RELEVANT EXPERIENCE

Tastelli LLC. Chicago, IL

Marketing Team Member, Analyst Dec 2023 -Present

• Built an inventory forecasting model implementing three rigorous stress tests to predict second half of 2024 if we underperformed, stayed consistent, or overperformed; predicted June-September 2024 forecast trends with 90% accuracy

• Collaborated with CEO and CMO to spearhead inter-collegiate College Ambassador program by designing a project plan and overseeing application process; currently leads weekly operational meetings and assigns weekly marketing deliverables

• Pitched to 3-5 retail owners and distributors at a global distributor’s trade show and helped garner $15,000 in sales

• Managed all brand partnerships and content creation on Instagram, created UGC appealing to Gen-Z audience, reached over 300k users and drove online sales by 30% in the month of June StageStrat Consulting Evanston, IL

President Nov 2024 - Present

• Founded first entertainment consulting club dedicated to providing students barrier-free learning opportunities in business while helping grow local arts firms in the greater-Chicago area

• Developed and currently leads executive board and general club meetings; delegates weekly tasks to reach marketing, development, and finance goals, and within the first week of launch, received 70+ responses on interest form

• Created 5-year plan including strategies for client acquisition, structures for weekly meetings, casing materials, and potential investment events for Northwestern’s entertainment projects Form & Function Marketing Evanston, IL

Incoming Account Executive, Analyst Sep 2023 - Present

• Marketing analyst for Northwestern Medicine, animal rescue center, food and beverage company, and public radio across 4 quarters; received Exceptionally Engaging and MVP award from Account Executives

• Conducted research of the marketing and branding of 100+ businesses in Chicago to compile 3 comprehensive SWOT analyses for clients focused on market expansion, e-commerce, and digital marketing

• Orchestrated marketing efforts consisting of an email campaign implemented with A/B testing, on-campus sampling events reaching over 600 students, and brand guides compiling of logo, fonts, colors, and social media post mockups

• Evaluated the success of Northwestern Medicine’s Facebook and direct outreach initiatives for garnering clinical trial participants and discovered a weak click rate on Facebook advertisements, which caused an excess of hundreds of dollars on spending Accounting and Business Finance Project Evanston, IL Academic Project Jan 2025 - Present

• Worked with a team to develop a comprehensive financial analysis of T-Mobile, US, Inc. from 2020-2023 using 10-k and ratio analysis; included current financial health, potential drawbacks from operations, and future growth rates in 50-page written report

• Completed competitive analysis by analyzing AT&T Inc.’s 10-k; conducted comparisons between operating margins, liquidity and leverage ratios, vertical and horizontal analyses, and segment analysis in report LEADERSHIP EXPERIENCE

Virginia Wadsworth Wirtz Center Evanston, IL

House Manager and Box Office Representative Sept 2023 - Current

• Resolves customer disputes and manages front of house operations for audiences of over 300 at Northwestern’s five theaters

• Created and trained others on how to create visual maps to identify highest opportunity segments for ticket sales using data visualization Dolphin Show Evanston, IL

Director of Fundraising, Assistant Producer Nov 2023 – Jan 2025

• Led and developed comprehensive end to end strategies to crowdfund $11k for America's largest student-produced musical, including copywriting, email marketing, and alumni outreach through phone banking

• Worked with a team of 150 students to plan promotional events as assistant producer while also performing in a lead role for production of 'Kinky Boots' which became America's highest grossing student musical of all time grossing $62,000 ADDITIONAL INFORMATION

Published: Paper published in NIH, National Library of Medicine. Conducted research to develop an efficient assay for detection of COVID 19 strains using CRISPR technology as a part of Biochemistry department at Tulane Medical School. Awards: Northwestern School of Communication Theatre Department award for academic merit and on-stage achievements, Dean’s List, National Commended Scholar, AP Scholar with Distinction, Silver Knight Honorable Mention, NSDA Speech Finalist Technical: Excel, PowerPoint, Canva, Pandas, NumPy, Matplotlib, Stata, Google Workspace Interests: NUTutor, Dual Citizen of U.S. and Canada, Advanced Mandarin (Speaking), Intermediate Spanish

Contact this candidate