Songxia (Dean) Li

Experience

• 

  Herb Chambers Toyota Of Boston

  Mar 2020 - Jul 2022

  Sales Consultant & Analyst

  • Experienced in inputting data into Excel and created Pivot table to organize both customer & vehicle information.• Analyzed sales data, including revenue, vehicle description, vehicle delivery process, and add-on product selection to identify trends and opportunities for improvement.• Utilized Excel to create various types of diagrams, including histograms, bar charts, and line charts, to visualize and extract valuable insights.

• 

  University of Southern California

  Mar 2021 - Sept 2021

  Assistant Business Analyst

  • Examined the contents of an e-commerce database in Python to forecast customer purchase behavior and visit frequency, aiming to assist the business in formulating effective marketing strategies.• Utilized a range of machine learning models and conducted comparative analyses to identify the most suitable one for predicting target results.

• 

  Herb Chambers Toyota Of Boston

  Sept 2023 - now

  • Collects revenue data into Excel from each transaction, conducting detailed analyses of salesperson performances. Then, provides valuable insights to the sales department, actively contributing to the achievement of monthly goals.• Applies data-driven insights in assessing customer creditworthiness, comparing evaluations to organizational standards. Utilizes information systems for lender searches, application forwarding, and collaboration with loan underwriters and processors. The data-driven approach informed decisions in the approval or rejection of loans.• Leverages advanced data analytics techniques to optimize the provision of insurance and financing services to customers, enhancing overall service quality.• Conducts market research and competitor analysis to stay informed about industry trends and maintain a competitive edge. Collaborate with sales teams to develop sales forecasts and promotional campaigns based on data-driven insights. Show less

  • Sales Manager

    Nov 2024 - now

  • Associate Finance Manager

    Sept 2023 - Nov 2024