Junhong Li Email & Phone Number

Herndon, Virginia, United States

• Data Standards & Efficiency: Established new data standards and metrics, improving record accuracy and data gathering efficiency, boosting team productivity.
• Advanced Excel & Pivot Tables: Streamlined datasets using advanced Excel functions and Pivot Tables, enabling rapid retrieval of product details and pricing, enhancing team efficiency.
• ETL Processes & Regression Analysis: Led SQL-based ETL processes and applied Python-based linear regression to shift from value-based to demand-based pricing, increasing profits by 9% in 2023.
• Time-Series Forecasting: Analyzed order and quotation records with Python, developing time-series forecasting models to dynamically adjust pricing, improving product win rates by 11% in 2023.
• Data Visualizations: Conducted Exploratory Data Analysis (EDA) on quotation records, creating charts and dashboards using Tableau to support data-driven decision-making.
• Cross-team Collaboration: Worked with sales and marketing departments to present data insights, optimizing marketing strategy for slow-moving products, boosting sales by 24% and reducing costs by 31% in 2023.

Boston, Massachusetts, United States

• Market Analysis: Collected global industry market reports’ data, performed Exploratory Data Analysis (EDA) to provide initial insights for a ski track app.
• NLP Analysis: Extracted over 20,000 user reviews from worldwide app stores using Python and conducted natural language processing (NLP) analysis to statistically analyze high-frequency vocabulary in both high and low.
• Data Visualization: Utilized Tableau to create data visualizations, supporting feature optimization plans based on processed data analysis results, and improving stakeholder understanding and supporting decision-making.
• Feature Optimization: Supported optimization suggestions based on user feedback analysis and market demand forecasts, resulting in an 8% increase in app downloads in the month following the new version's release.

Beijing City, China

• Conducted user behavior analysis and advised investment strategies, focusing on mobile game companies.
• Assessed financial health of mobile game companies by analyzing income growth and net profit margin ratios.
• Utilized linear regression models to project future revenue based on game download and user activity data.
• Analyzed financial risk using asset-liability structure and cash flow data to inform investment strategies.

Master'S Degree, Analytics （Concentrate In Evidence Based Management)

Bachelor Of Science - Bs, Finance And Financial Management Services

Activities and Societies: Roller Blade Club, Student union