Diane Guan Email & Phone Number

United States

AI model development

North Carolina, United States

• Developed a comprehensive Text Message Analysis System to gauge patient volume, enabling strategic nurse staffing optimization based on fluctuating patient demands, significantly improving operational efficiency and.
• Created a Staffing Analysis Dashboard using Tableau, providing Pinnacle Management with four detailed visualizations that incorporated patient demand trends, peak times, nurse metrics, and staffing ratios.
• Employed Python to implement Machine Learning (LSTM model) to predict daily patient demand based on historical time-series data; enhanced decision-making for nurse allocation by generating accurate daily forecasts of.

Hong Kong SAR

• Led the valuation analysis for Tesla Inc., emphasizing income statements and operational metrics of automotive and energy segments, gathered and cleaned user engagement data in SQL, conducted EDA to define project.
• Built and tested RNN and LSTM models in Python to forecast stock prices accurately, achieving an optimal balance between model complexity and predictive precision.
• Collaborated closely with cross-functional research team to conduct analysis of Tesla's FSD sales, competitive landscape, and projected profits, leveraging model outcomes to inform strategic stock holding decisions for.

Dublin, Ohio, United States

• Conducted and analyzed 2 A/B testing experiments to evaluate interface optimization, utilizing T-tests to establish statistical significance, resulting in a 7% increase in customer satisfaction
• Performed SQL queries to build data collection, storage, and processing infrastructure for a comprehensive economic database covering over 20 Chinese provinces and 2400+ counties
• Constructed and tested data pipeline and fully automated & interactive Tableau dashboards for internal stakeholders to inform marketing and product strategies

Shenzhen, Guangdong, China

• Performed SQL queries to build data collection, storage, and processing infrastructure. Analyzed extensive sales data in the E-commerce sector, ensuring accuracy and clarity; delivered simplified and visualized.
• Conducted statistical analysis, built predictive models in Python focusing on churn rates and customer segmentation.Applied PCA to identify critical factors in user retention
• Developed Logistic Regression and Random Forest predictive models for user retention, successfully automating discount policies and backend migration processes
• Designed and implemented ETL solutions with over 200GB data. Maintain data infrastructure including building more than 40 data tables, reconstructed the databased structure, improving the query efficiency about 50%

• Used IBM Cloud to upgrade the chain engineering management process for production, inventory control, distribution, cost and marketing, providing recommendations for supply chain optimization.
• Conducted data analysis on supply chain and business operation with senior analysts to identify continuous improvement opportunities, resulting in 10% reduction on operating cost.
• Attended meetings with supply chain team to evaluate process gaps and proposed platform, design, and infrastructure solutions to initial sales support.

Education record

Bachelor Of Science - Bs, Double Major：Quantitative Sciences & Economics

4.3

Summer Program