Si Lu Email & Phone Number

Mclean, Va, Us

Reston, Virginia, United States

Shanghai, China

- Designed 10+ digital platform tracking measurements and communicated the tracking demands with engineers- Analyzed tracking data using Excel and SQL to evaluate user behaviors and increased visit frequency by approximately 20%; visualized the user interaction insights using Tableau to assist consultants presenting the Life Insurance Digitalization Reform Strategy

Shanghai, China

- Built 2 databases in the competitive analysis projects for a leading Australian healthcare brand and a leading sports firm by data merging and data transformation using SQL; saved 20% of data extraction time- Researched on business strategy for client company and its 5 major competitors by conducting interviews and reading reports; visualized the insights of distribution channels and product development plans using PowerPoint Think-cell, created 3 Tableau dashboards to demonstrate the marketing strategy and business framework to help client company understand its competitive position in the market

Shanghai, China

- Screened out 41 local companies from over 60,000 pharmaceutical sales records in a specialty pharma screening project for a private equity firm by utilizing PivotTable and VLOOKUP functions in Excel - Explored the market demand patterns of a protein drug; transformed real-world expert insights into model parameters; constructed the market forecast model based on historical data to predict sales of the protein drug and provided advice to client company on future manufacture planning- Studied Parkinson patients’ pain points by applying sentiment analysis and LDA topic modeling using Python to measure patients’ frustration level towards different symptoms in a Parkinson’s disease social listening project

Shanghai, China

- Assisted consultants on developing fast food market entry insights through gathering information, designing 2 questionnaires, making 10+ cold call interviews, quantifying the relationship between regions and customer flow, and completing interview report

Master Of Science - Ms, Quantitative Finance

Bachelor’S Degree, Logistics, Materials, And Supply Chain Management

Bsc, Business And Management（International Track）