Yu Han

Yu Han

Business Analyst Intern

Followers of Yu Han426 followers
location of Yu HanNew York, New York, United States

Connect with Yu Han to Send Message

Connect

Connect with Yu Han to Send Message

Connect
  • Timeline

  • About me

    Data Analyst | Master @ NYU | SQL |Python |Excel |Tableau | Pandas

  • Education

    • Rutgers University–New Brunswick

      2019 - 2023
      Bachelor's degree Statistics

      Minor in Human Resource Management

    • New York University

      2023 - 2025
      Master of Science - MS Integrated Marketing

      Marketing Analytics Track

  • Experience

    • Shanghai Xinpa Information Technology Co., Ltd

      Jul 2020 - Aug 2020
      Business Analyst Intern

      • Engineered and implemented SQL queries to extract and manipulate IT software data within the financial software sector, preparing an industry analysis report to fuel the company’s future expansion and innovation endeavors.• Researched development strategies of a leading financial software service provider, conducting a thorough examination to the company’s operations and its diverse portfolio of software solutions.

    • Beijing YiYuXi Art Museum

      Oct 2020 - Nov 2021
      Marketing Intern

      • Enhanced exhibit inventory management by verifying information, collecting essential textual materials, and organizing files; utilized dashboard tools and trend analysis techniques to monitor inventory levels and optimize resource allocation.• Conducted data collection and analysis, employing PEST and SWOT analyses to delve into visitors’ attitudes towards exhibitions, ensuring the integrity and accuracy of exhibition materials through meticulous inspection and proofreading.• Streamlined communication and decision-making processes by crafting concise meeting minutes, capturing actionable outcomes, and providing clarity and direction for the next steps to facilitate the seamless execution of strategic initiatives. Show less

    • Glodon Company Limited

      Feb 2022 - May 2022
      Marketing Analyst Intern

      • Leveraged SQL to collect and structure data from 300 Philippine construction companies, systematically categorizing company profiles by type and extracting contacts and key profiles to drive strategic business outreach initiatives.• Led a dynamic virtual new product launch event, steering detailed discussions on the product’s operational strategy; integrated data insights to refine marketing approaches, improving audience attendance and engagement by 20%.• Developed comprehensive brand, product, and activity materials, contributing to the launch of multiple promotional campaigns; collaborated with Department Managers to conduct quarterly marketing data analysis and optimize campaign effectiveness Show less

    • PwC

      Jun 2022 - Aug 2022
      Management Consulting Intern

      • Developed advanced regression models in Python using data from 70 major Chinese cities including critical factors such as population density and geographic attributes, generating a business analysis report about future trends, key opportunities, and potential risks in China’s real estate market, contributing to informed business strategies and driving revenue growth.• Spearheaded the creation of 3-statement forecasts, conducted discounted cash flow (DCF) analyses, and executed comparable company and precedent transaction analyses to support M&A transactions for the client.• Collaborated closely with stakeholders and leadership to dissect industry trends, competitive landscapes, and growth opportunities, building an interactive Tableau dashboard to present actionable recommendations. Show less

  • Licenses & Certifications