Wentingyin S.

Experience

• 

  丰立装饰集团

  May 2017 - Aug 2017

  Salesperson

  • Introduced company services to customers in order to increase sales and provide an increased level of customer service and satisfaction. Created a 3 month total revenue of 2,640,000 RMB for the company, equivalent to US$377,143.• Awarded the Top 3 quarterly sales award among 100 plus sales staff.• Communicated with a diverse customer base to critically evaluate, solve problems and consider alternative solutions to their interior design needs. • Evaluated customer budget constraints and led analysis conversation to determine financial ability for dream home. • Negotiated and de-escalated conflict issues between clients and designers to ensure a smooth transition from design to installation to completion. Show less

• 

  丰立装饰集团

  Jul 2019 - Sept 2019

  Business Analyst Intern

  • Created 4 webpages interface with animation and navigation for the local office using HTML, attracting 2000 visitor per day.• Performed A/B tests to investigate impacts of different local office homepage interfaces on conversion rates.• Built 2 Tableau dashboards to show the revenue growth of different interior design styles in the urban areas of southwestern China in the last 5 years.• Built a simple forecast model with multiple linear regression method to predict potential revenue of next year Show less

• 

  CITIC Securities Company Limited

  Nov 2020 - Dec 2020

  Industry Research Analyst Intern

  • Extracted stock data of 5 major oil companies from Yahoo Finance using R and created 6 time series plots with ggplot2 and dplyr to demonstrate trending and seasonality. • Developed a lasso regression model using 15 indicators to estimate the land value in multiple districts of Shenzhen with 70% of accuracy and identified 5 most significant variables. • Wrote complex MYSQL queries to accurately retrieve customer and client information.

• 

  Oregon State University

  Apr 2022 - Jan 2023

  Business Analyst

  • Build a logistic regression model with 68% of accuracy which using 9 variables to compute the odds of a student landing a full-time job within 6 months right after graduation. • Designed a relational database to optimize data collection of participants and events. • Built 3 Power BI dashboards to compare the differences on demographic and academic performance between event participants of the organization and the whole student population on a termly scale.• Leveraged data-driven insights to optimize a musical event, achieving a 15% increase in attendance and a 10% reduction in costs through strategic vendor negotiations. Show less

• 

  Labyrinth Lab LLC

  Aug 2023 - now

  Construction Industry Analyst | Construction Material Business Consultant

  · Developed a sourcing strategy for construction materials, using analytics to connect U.S. small enterprises with global suppliers efficiently, enhancing procurement processes.· Provided market analysis and demand forecasting for construction materials to U.S. small enterprises, identifying growth opportunities and advising on targeted strategies.· Offered construction materials outsourcing consulting and streamlined documentation processes for small enterprises engaging in overseas procurement, and improving transaction efficiency. Show less