Social Media Summer Intern

Li Pan

******.***.**@*****.***

Education

BA in Finance, Minor in Economics – Franklin & Marshall College, PA

2009

MBA in Management & Business Analytics – Hofstra University, NY

Double Major 2015–2019

MS in Finance – Goldey-Beacom College, DE

2020–2022

Experience

TV Program Assistant – Wuhan TV Channel, Wuhan, China

2005

Assisted in bilingual news production, guest coordination, and content development.

Pharma M&A Intern – InCap Group, Baltimore-based Advisory Firm

2008

Conducted research on pharmaceutical licensing and acquisition targets.

Summer Intern – StartingBloc, 503(c) Nonprofit Program, New York, NY

2008

Supported youth programming and community engagement initiatives.

Private Equity Intern – Bond Street Investors, LLC, New York, NY

2009

Sole intern responsible for maintaining encrypted Excel spreadsheets with advanced formulas across linked sheets.

Applied complex mathematical models to perform financial calculations and support investment analysis.

Collaborated closely with a cross-functional team including lawyers, bankers, and regional partners.

P2P Lending & Loan Underwriting Analyst – CreditEase, Beijing, China

2009–2011

Conducted client and industry research for peer-to-peer lending projects across various sectors, including oil & gas and construction.

Supported underwriting and due diligence efforts to ensure data accuracy and risk mitigation.

Chinese Social Media Assistant – Hofstra University, Hempstead, NY

2016–2017

Assisted in planning and executing Chinese-language social media campaigns to support university outreach and engagement.

Monitored engagement metrics and compiled reports for communications teams.

Brand Ambassador – Lice Communications, Various Locations, China

2023–2024

Represented a company connecting artists and lifestyle brands with real estate developers in emerging markets.

Collaborated with Gen Z entrepreneurs to plan and host a community event, promoting brand engagement and cultural outreach.

Clinical & Pharmacy Intern – Community Clinic, Flushing, NY

2024

Analyzed OTC drug pricing and effectiveness; categorized prescribed medications for pharmacy inventory.

Business Intelligence Analyst – AmeriChina LLC, NY

Apr 2024 – Mar 2025

Conducted research on millennial pop culture trends and built Tableau dashboards to guide strategic media campaigns.

Data Workshop Instructor – National Bookstore Education Series

2022 – Present

Taught Tableau and data concepts to diverse adult learners.

Education Facilitator – Multiple School Programs

2023 – Present

Delivered Mandarin Chinese workshops for grades 4, 6 & 7

Skills

Data & Technical Tools: Tableau, SQL, Excel (Advanced), R, MATLAB

Systems: Windows & MacOS Back-End Optimization Workflow Integration

Languages: English (Fluent), Mandarin Chinese (Native)

Strengths: Data storytelling, cross-functional collaboration, research synthesis, spreadsheet modeling

Leadership & Involvement

President, Hofstra Wealth Management Association

Panelist, Global Careers Panel (University Homecoming)

Mentor, 100 Women in Finance NE Women in Public Finance

Contact this candidate