Los Angeles Analyst Intern

Jasmine (Yujing) PAN

********@***.*** +1-323-***-**** Los Angeles, CA https://www.linkedin.com/in/jasmine-yujing-pan/ E DUCATION

University of Southern California Los Angeles, CA

Master of Science in Business Analytics (MSBA) Dec. 2025 USC Dornsife College of Arts and Science Los Angeles, CA Bachelor of Arts in Economics (Minor: Applied Analytics) May.2023 PROFESSIONAL EXPERIENCE

California Consulting, Inc. Los Angeles, CA

Analyst Intern Jan. 2024 to May. 2024

● Conducted industry and export trend analysis using Excel and market research tools; identified high-growth sectors

(cosmetics and smart home devices) by evaluating market size, profitability, and alignment with national export policies.

● Analyzed customer behavior and competitive landscape to support data-driven product targeting strategies, improving marketing focus and lead conversion rates. McKinsey & Company Remote

Part-Time Analyst Aug. 2023 to Nov. 2023

● Analyzed and cleaned operational data from internal databases using SQL; built Power BI dashboards to visualize lead time variability, supplier KPIs, and cost structures.

● Led 20+ supplier and vendor interviews via cold calls and structured surveys to assess performance metrics, contributing to a global tech client’s supply chain optimization strategy.

● Identified process inefficiencies and recommended supplier consolidation strategies, supporting decisions projected to reduce excess inventory by 15% and enhance procurement ROI. DELOITTE Beijing, China

Audit and Assurance Intern Jun. 2023 to Aug. 2023

● Conducted 30+ control tests and analyzed financial transaction samples in Excel to support IPO readiness for one of China’s largest healthcare providers, ensuring data accuracy, regulatory compliance, and a complete audit trail.

● Verified 50+ vendor invoices, service contracts, and on-site inventory records across multiple hospital departments and procurement units, identifying discrepancies and offering data-driven insights to enhance operational efficiency and reduce compliance risk.

IDC Capital Group Ltd. Qingdao, China

Consulting Intern May. 2022 to July. 2022

● Generated market analysis reports for companies in various industries, including financial service, healthcare and life science, digital and information technology

● Conducted on-site investigation to 10+ companies and summarized meeting records to generate investment strategy proposals

ANALYTICS PROJECTS

Healthcare Project: Forecasting Demand and Optimizing Queue Management for Sollis Health

• Engineered weekly demand forecasts using SARIMAX models, incorporating seasonal patterns and exogenous factors (e.g., weekday, clinic location), achieving >85% accuracy in predicting visit volume.

• Built queueing simulation models (M/M/s) for urgent and scheduled care streams to evaluate staffing efficiency under varying patient arrival rates, identifying >30% potential reduction in average wait time during peak hours.

• Proposed coordination strategies leveraging triage pathways and aftercare follow-ups to reduce unnecessary visits; aligned customer behaviors with capacity by recommending staggered scheduling and targeted reminders. Economic Impact Analysis: Investigating the Dynamics of Housing Prices in Greater Los Angeles

● Used Instrumental Variable regression with Starbucks locations as an instrument for crime rates to address endogeneity

● Discovered key relationships between crime, turnover ratios, and housing prices, with a 1% increase in turnover ratios. leading to a $22,470 rise in house prices (p < 0.01) and a 1% increase in crime rates reducing values by $2,203 (p < 0.01).

● Identified key insights for LA City Planning, such as targeting investments in walkable neighborhoods to enhance property values and implementing crime reduction strategies to protect housing prices, with findings supported by an R value of 0.33. L EADERSHIP & INVOLVEMENT

USC Chinese Students Association Los Angeles, CA

President Aug. 2022 – Jun. 2022

● Operated the management of the association and coordinated business between departments

● Hosted bi-weekly meetings and organized events and workshops with E-board members

● Interacted with other student associations and University officials T ECHNICAL SKILLS

● Language: Chinese (Native); English (Fluent); Spanish (Beginner)

● Programming Languages: Python (TensorFlow, Scilit-Learn, Seaborn, Gurobi), SQL, and R

● Software & Platforms: MATLAB, VBA for Excel, Snowflake, Stata, Power BI, SAP (HANA, BW)

● Analysis & Modeling: Time Series Analysis, Predictive Models, Statistical Regression, Optimization

● Interests: Golf, Photography, Piano, Flute, Accordion

Contact this candidate