FrieslandCampina

Marketing Research Analyst

Mar. 2018 - Jun. 2018

• Analyzed company-wise and industry-wise data from Nielsen to estimate competitor’s market size, ROI and other digital marketing performances in China’s dairy industry; measured market share through urban population, purchase index and per capita spending on Excel PivotTable; presented findings on PowerPoint directly to Director.

• Conducted sales and inventory analysis by pulling raw data from e-commerce platforms, updating Access databases and building regression models to identify sales opportunities; generated heat maps and dashboards in Power BI and Excel to monitor sales performance so as to optimize inventory allocation.