Ran Ye

Experience

• 

  University of Nebraska-Lincoln

  Jun 2020 - Aug 2020

  Research Assistant

  • Led a small group of 5 students to label Hyperspectrum Maize Images and implemented classification methods and feature engineering; uncovered ground truth which was used for training and testing models.

• 

  OneRequest

  Jun 2021 - Jul 2021

  Data Analyst

  • Created key metrics such as Frequency of Zero Matching Search to monitor user searching experience, cross-checked data quality using MySQL and presented metric trends to aid strategic decision making for C-level executives.• Identified and monitored sales metrics to measure car dealership partnership outcomes for company-wide audiences.• Built weekly-hierarchy reports and tracked weekly data for sales team by providing visualization of market penetration performance; established DirectQuery and incremental refresh to decrease the dashboard refresh time to 2 mins and added in flexibility in future automation adaptations. Show less

• 

  Spreetail

  Mar 2022 - Oct 2022

  Pricing Analyst

  •Built and maintained automated pricing system on all SKUs($1B value) by collaborating with business intelligence team to provide scalable solutions to expand business strategies•Defined and developed a centralized measurement system with 5+ KPI metrics and conducted weekly review with stakeholders and senior leaderships to derive business insights•Conducted quantitative analysis by using SQL and Excel on retail data and drove pricing initiatives to optimize pricing strategy and violation monitoring process with collaboration efforts across multi-functional teams•Performed A/B testing and conducted statistical analysis to provide data-driven branding solutions•Partnered with data engineers to develop integrated data repository and ETL data pipelines which improved the data aggregation efficiency by 70% Show less

• 

  PayPal

  Jan 2023 - now

  Senior Account Analyst