Dakang Li Email & Phone Number

Los Angeles County, California, United States

• Maintained over 50 long term customers’ rates, FAK and discount based on yearly margin benchmark and shipping tariff by using Excel and SQL.
• Created a cost prediction model by using machine learning skills, accuracy rate up to 80% comparing with actual cost, helped operation team develop new lanes of shipping.
• Coordinate with sales team to process RFP by using cost model, winning customer at 5% higher margin than before.
• Participate in the design of sales incentive project… Show more
• Participate in the design of sales incentive project, including using RFM model and k-mean clustering to categorize customer, defined follow-up report metrics and delivered report monthly. This project acquired 3 new.
• Designed and delivered monthly companywide performance report by using SQL and Excel, including operation and sales. Covered 90% of periodical data request.

Los Angeles

• Worked as analyst in the only international student community-based apartment in Los Angeles
• Designed and built a company sales database from scratch, in charge of the maintenance and usage of the database.
• Designed and built a company operation dashboard by using Tableau, define key metrics of the department, maintain and optimize dashboard.
• Extracted data from local real estate website via web crawler, cleaned data in R, applied time series on historical marketing price.
• … Show more
• Calculated company cash flow and housing vacancy rate by Excel, and guided the company's marketing department on how to increase accuracy and efficiency according to the results. Show less

Burbank

• Create a mailing list for targeted customer campaign by using Excel and Alteryx.
• Optimize Alteryx processes to improve reporting efficiency and increase reporting efficiency by 50%.
• Through Fishbowl, Paytronix check the performance of campaign, summarizes them into reports, analyzes customer behaviors to optimize marketing strategies, optimizes, and re-creates the list of next campaign in Tableau.
• Through Fishbowl, Paytronix check the performance of campaign, summarizes them into reports, analyzes customer behaviors to optimize marketing strategies, optimizes, and re-creates the list of next campaign in Tableau.
• Provide Trade Area Analysis, Ad-hoc Analysis, Potential Client Target Analysis to client.
• Help clients maintain their membership database, clean up regularly, integrate, and prepare for the next campaign. Show less

Shanghai

• Worked as booking consultant in the world's largest marketplace for student housing
• Established a bridge between foreign landlords and Chinese students with colleague, helped over 100 Chinese students find housing in the UK and the Australia.
• Utilized Salesforce to record each successful inquiry. Issued house recommendation monthly based on user comments and rates on our website.
• Achieved Exceeded Expectation in the final review with 200% personal KPI accomplished.

Master'S Degree, Applied Analytic, 3.73

理学学士, 海洋技术