(Daniel) Zixuan Yan

Business Consultant at Simon Vision Consulting
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Rochester, New York, United States, US
Languages
  • Chinese Native or bilingual proficiency
  • English Professional working proficiency

Topline Score

Bio

Generated by
Topline AI

0

/5.0
/ Based on 0 ratings
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

No reviews to display There are currently no reviews available.

0

/5.0
/ Based on 0 ratings
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

No reviews to display There are currently no reviews available.
You need to have a working account to view this content. Click here to join now

Credentials

  • Intro to ML: Image Processing
    Qwiklabs
    Mar, 2021
    - Sep, 2024
  • Introduction to Data Science in Python
    DataCamp
    Jan, 2021
    - Sep, 2024
  • Joining Data in SQL
    DataCamp
    Jun, 2020
    - Sep, 2024

Experience

  • Simon Vision Consulting
    • United States
    • Business Consulting and Services
    • 1 - 100 Employee
    • Business Consultant
      • Sep 2020 - Present

      - Helped Orolia (a global manufacturer) transit to heavy digital marketing after in-depth communication and conducting EDA with Google Analytics- Leveraged ETL jobs on historical data from Salesforce and Google Analytics with MySQL to develop a data pipeline- Built ROI models for 10+ digital campaigns; calculated and traced back ARPU, expected customer lifetime value (by product types, industries, geography, etc.), and expected deal size at 4 steps in the lead funnel to advise on the marketing team- Constructed 3 dashboards to visualize CLV, marketing pipeline, and campaigns attribution in Power BI for decision-making- Designed questionnaire with Qualtrics XM, collect missing purchasing patterns and market size data for CountertopSmart

  • LandPro Equipment, LLC
    • United States
    • Machinery Manufacturing
    • 1 - 100 Employee
    • Data Analyst
      • Jan 2021 - Present

      - Cleaned and reconstructed 10+ million phone call records by SQL; identified seasonality of inbound call frequency, the regional difference of demand, and customer profile; proposed 4 potential solutions for operator shortage during peak time- Design metrics to evaluate proposal impact, e.g., ATV loss, call-back rate; construct tableau stories for visualizing financial improvements and compare the feasibility- Develop data extracting and cleaning functions in R to automate the transformation of new records for further monitoring

  • Johnson & Johnson
    • Law Practice
    • 1 - 100 Employee
    • Business Analyst
      • Nov 2019 - Dec 2019

      - Conducted purchase analysis and cost prediction for 3000+ raw materials; built forecast analysis of prices and costs in upcoming quarters for 3 Asian regions; designed alternative procurement schemes for top 10 materials- Completed sales analysis of 900+ finished goods and delivered reports with ground visuals and analysis; provided marketing data support, sales, and market share estimates for hero SKUs across 5 sub-brands and 21 categories-Proofread a 30,000-word supplier contract and translated it into Chinese-Received training in negotiation and sourcing strategy

Education

  • University of Rochester
    Master's degree, Business Analytics (STEM)
    2020 - 2021
  • The Ohio State University Fisher College of Business
    Bachelor's degree, Marketing
    2017 - 2021
  • China University of Geosciences
    , Applied Chemistry
    2015 - 2016

Community

You need to have a working account to view this content. Click here to join now