Yuaner Wang

Experience

• 

  China Galaxy Securities Co.

  Jan 2021 - Mar 2021

  Business Analyst Intern

  • Used SQL to do Data Wrangling and Exploratory Data Analysis on extensive customer data. Built a dashboard in Tableau to gain insights into customer investment preferences and behavior. • Supported cross-functional teams efficiently in analyzing customer financial data and provided data-driven investment recommendations. Delivered real-time investment market data and analysis to clients.• Endeavored infusing advanced data visualization techniques into work-hosted weekly meetings and seamlessly integrating with various teams to expedite task completion. Show less

• 

  Mengniu Global R&D Innovation Center

  Jul 2021 - Oct 2021

  Intern
• 

  大华会计师事务所（特殊普通合伙）

  Jan 2022 - Apr 2022

  Audit Intern

  • Learned the annual audit process with limited tutoring in 2 weeks.• Summarized data (13GB+) as support appendix, used Excel functions to link data to the audit report automatically associated with Outlook for mass emailing. • Employed Python for data crunching and automation of sampling process for audits, resulting in a 25% reduction in processing time and a 20% increase in data accuracy, significantly enhancing overall audit efficiency. • Hosted weekly meetings and reported to the senior manager weekly to ensure timely and efficient cooperation. Show less

• 

  Epoca International LLC

  Nov 2022 - Apr 2023

  Student Consultant/ Data Analyst
• 

  Asset Technology Solution, Inc.

  Apr 2024 - now

  Business Data Analyst