Summary
Overview
Work History
Education
Skills
Languages
Skills
Affiliations
Languages
Websites
Timeline
Generic

JIAYI SUN

State College

Summary

Results-oriented professional with experience at Microsoft, specializing in financial data analysis and strategic insights. Expertise in SQL and problem-solving has led to the development of impactful data-driven presentations that improve decision-making processes. Adaptability and quick learning skills facilitate success in fast-paced environments, contributing significantly to team objectives.

Overview

2
2
years of professional experience

Work History

Remote Intern

Microsoft
05.2024 - 06.2024
  • Conducted comprehensive business analysis on Microsoft’s core product lines, including Azure, Windows, Microsoft 365, and Xbox, by researching public filings and industry reports, and structured findings into slide decks to assess market strategy, business model, and segment performance
  • Performed financial data analysis using Excel, examining revenue trends, cost structures, and profit margins across business segments; applied pivot tables, charts, and formula-based models to identify growth patterns and cost optimization opportunities
  • Designed data-driven PowerPoint presentations with clear storytelling and executive-level visualizations to support strategic insights and business recommendations, sharpening consulting and financial analysis contexts

Product Analyst Intern

Jiangsu Huaxi Securities Co., LTD.
Nanjing
07.2023 - 08.2023
  • Gained foundational knowledge of stock market operations and regulatory frameworks, including order types, trading mechanisms, and compliance guidelines, through hands-on training and case-based learning
  • Supported client advisory efforts by researching market trends and stock performance, assisting in the preparation of tailored investment suggestions and helping customers identify suitable opportunities based on their risk profiles
  • Contributed to client relationship management by maintaining regular communication, sharing timely market updates, and assisting in the preparation of financial analysis reports that enhanced internal team decision-making and client engagement

Intern

Nanjing Jinchuangneng Network Technology Co., Ltd.
Nanjing
05.2022 - 08.2022
  • Supported staff members in their daily tasks, reducing workload burden and allowing for increased focus on higher-priority assignments
  • Gained valuable experience working within a specific industry, applying learned concepts directly into relevant work situations
  • Sorted and organized files, spreadsheets, and reports
  • Participated in visual presentation development, sharpening attention to detail and branding design

Education

Bachelor of Economics -

Pennsylvania State University
State College, PA
05.2025

Skills

  • MS Office Suite
  • Problem solving
  • Adaptability and flexibility
  • Event planning
  • Quick learner
  • SQL
  • Statistical analysis

Languages

  • English, Full Professional
  • Chinese (Mandarin), Native or Bilingual

Skills

MS Office Suite, SQL, Stata, English, Fluent, Chinese Mandarin, Native

Affiliations

Team Player | State College, PA | Aug 2021 – Aug 2022

  • Competed in weekly games and regional tournaments, demonstrating discipline, teamwork, and strategic thinking in high-pressure settings.
  • Contributed to team cohesion by mentoring new players, organizing off-court bonding activities, and assisting with practice drills.
  • Balanced athletic commitment with academic responsibilities, developing strong time management and perseverance skills.

Languages

English
Professional
Chinese (Mandarin)
Native/ Bilingual

Timeline

Remote Intern

Microsoft
05.2024 - 06.2024

Product Analyst Intern

Jiangsu Huaxi Securities Co., LTD.
07.2023 - 08.2023

Intern

Nanjing Jinchuangneng Network Technology Co., Ltd.
05.2022 - 08.2022

Bachelor of Economics -

Pennsylvania State University

Similar Profiles

CREATE PROFILE