Ziyu Chen

Experience

• 

  University of Rochester

  Sept 2021 - May 2024

  • Analyzed sales models of all S&P 500 companies to measure the influence magnitude imposed by Covid. • Developed a neural network with macroeconomic indicators by using Python and Adam optimizer, achieving 30% increase in accuracy compared to standard regression models.

  • Undergraduate Student

    Aug 2020 - May 2024

  • Research Assistant

    Sept 2021 - Apr 2024
• 

  BrandEmPower, Inc.

  Jun 2022 - Aug 2022

  Data Analysis Intern

  • Conducted industry research and customer analysis to create statistical reports in developing marketing strategies for sports finance education programs, amplified client response rate by 15%.• Leveraged annual sales data into Power BI dashboard for profitability insights, collaborated with a 15+ member marketing team to analyze KPIs for cost-effective management.• Maintained large databases of 1000+ universities (NCAA division) with 25% faster data retrieval using SQL.

• 

  Simon Business School, University of Rochester

  Jun 2022 - Aug 2023

  Office Assistant

  • Audited advisor contact spreadsheets with 1000+ contacts using Excel OpenSolver, VLOOKUP, and VBA for effective communication and outreach. • Provided administrative support to various departments, including scheduling appointments, managing reception.• Imported attendance data for 70+ events by inspecting the service system, ensuring 100% accuracy of information

• 

  City of Rochester

  Aug 2022 - Dec 2022

  Business Management Intern

  • Supported SME funding programs by coordinating with 40+ local enterprises, resulting in a 20% improvement through personalized program matching and tailored application processes. • Applied Excel Pivot Table to archive job reports, boosting government digitization with 35% in data accessibility.• Utilized Tableau to visualize revenue growth in funding programs, optimized web functionality with 20% increase in page views.

• 

  Blackmore Partners Inc

  Apr 2023 - Jul 2023

  Business Analyst Intern

  • Conducted SWOT analysis to evaluate business operations and performance, implemented SQL data validation for project records, enabling task management across multiple projects with 10% increase in client responsiveness.• Designed client/staff surveys to engage stakeholder meetings, streamlining deal sourcing by 15% through Infusionsoft and Power Automation, actively contributing to 10+ successful deals.