Yu Han

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