Yuxin Yi

Experience

• 

  China Securities Company Limited

  Mar 2021 - May 2021

  Industry Research Assistant

  1.Analyzed 5 years of comprehensive financial data for over 20 leading companies in the e-commerce, social media, gaming, and digital entertainment sectors. Collected annual and quarterly data on revenue, monthly active users, and transaction volumes. Created a Tableau dashboard to distill complex information into actionable insights for strategic investment decision-making.2.Assisted in comprehensive industry research, focusing on technology, stock performance, and competitiveness within the digital content protection, semi-conductor and developer services industries. Contributed to enhancing 3 industry research reports, providing insights for strategic planning and market positioning. Show less

• 

  JD.COM

  Dec 2021 - Mar 2022

  Logistic Cost Analyst

  1.Developed a machine learning model to predict the logistic cost and the trend based on the delivery order volumes and average prices in assisting relevant business department controlling the ecommerce supply chain cost, achieved a 7% reduction in logistic cost.2.Developed and implemented a predictive model for courier attendance using weekly attendance data and real-time trends, enabling early interventions, and supporting the business department in optimizing workforce deployment and operational planning.3.Integrated and monitored personnel attendance, express delivery, and order placement data in real-time. Utilized pivot tables to analyze the staff attendance rate and weekly order volumes, enabling a data-driven approach that improved operational efficiency by 10%. Show less

• 

  Agricultural Bank of China

  Jun 2022 - Sept 2022

  Operations Analyst

  1.Leveraged pivot tables to efficiently analyze daily active users and new user metrics, streamlining the analysis process to save 60% in time. Enabled quicker insights into user engagement, significantly improving strategies and boosting retention for the mobile banking app.2.Spearheaded the introduction and financial management of a new project launch, prepared comprehensive project content, budget calculations, and a 12-year earnings forecast. Analyzed risks and the break-even point, delivering a detailed report that supported strategic decisions and facilitated project alignment.3.Analyzed transaction data to resolve financial disputes within mobile banking services. Identified customer behaviors and incident causes, estimated losses, provided data-driven insights that aided in achieving fair resolutions, increased customer satisfaction rate by 4%. Show less

• 

  Acorn Analytics

  Sept 2023 - Jun 2024

  Data Analyst, Practicum Project

  1.Spearheaded research about resource allocation to improve alternating least squares recommendation system’s overwhelming results, including clustering, auction algorithm2.Led the team of 5 people to define a linear programming model with the goal of maximizing matching score between buyers and properties, and 2 constraints to address overwhelming results and improve 8% overall score and customer satisfaction3.Visualized the distribution of 16,000 properties using ArcGIS, deployed MongoDB with 2dsphere indexing, filtering buyers within 25 miles, cutting processing time from 6 hours to 14 minutes, experimented with quad tree, Geohash, and H3 index for further efficiency Show less