# Xinlu Yu

Xinlu Yu is a remote worker on Himalayas, Assistant Commercial Development Manager at The LEGO Group, based in Canada.

Source: https://himalayas.app/@xinluyu

```text
Revenue and commercial analyst at The LEGO Group, who built trade investment KPIs and stopped a low-ROI program.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | Canada |
| Authorized to work in | Canada |
| Salary expectations | 40k+ CAD |
| Job categories | Revenue Analyst, Commercial Analyst, Pricing Analyst |
| Skills | Revenue Management, Pricing, Promotion Analysis, Trade Investment ROI, Revenue Forecasting, Business cases, Market Sizing, Price Elasticity, Bundling, SQL, Tableau, Excel, Superset, Amazon Redshift, Python |

## About

```text
At The LEGO Group, I owned trade investment and promotion analytics for retail customers, evaluating ROI and advising which promotions to continue, adjust or stop. My analysis led to stopping a low-ROI gift program worth CAD 95K+ in monthly trade investment.

I built a trade investment tracking framework that standardized customer and product-theme data for SQL and Tableau, with several metrics adopted as new KPIs. I also investigated underperforming SKUs and selected gift-with-purchase items from high-inventory and end-of-life products.

At Shanghai Disney Resort, I owned revenue management and pricing analytics for restaurants, kiosks and carts. I led menu repricing and recommended bundles informed by co-purchase analysis, lifting average check size by about 20%.

I also built revenue forecasts and scenario analyses for investment initiatives, and created Tableau dashboards that replaced manual data pulls. Earlier, I supported a digital e-coupon program at Shanghai Disney Resort and managed licensing business planning at Michelin, where annual sales grew 24%.
```

## Experience

### Assistant Commercial Development Manager

[The LEGO Group](https://himalayas.app/companies/lego-group). Oct 2024 - Sep 2026

```text
Owned trade investment and promotion analytics for 20+ retail customers, partnering with Key Account Managers and presenting monthly performance to sales and finance teams. Evaluated ROI of promotions, built a trade investment tracking framework, and investigated underperforming SKUs to protect full-price sales.
```

Skills: SQL, Tableau, Excel, Trade-Investment, ROI-Evaluation, Promotional-Analytics, Data-Pipelines, Dashboarding, Forecasting, KPI-development

### Senior Analyst, Revenue Management & Pricing (F&B)

Shanghai Disney Resort. Aug 2023 - Oct 2024

```text
Owned revenue management and pricing analytics for 12 restaurants and 20+ kiosks and carts, from daily performance monitoring to pricing and investment recommendations. Led menu pricing, built revenue forecasts and scenario analyses, and created 8 Tableau dashboards for ~100 users.
```

Skills: SQL, Tableau, Excel, Revenue-Management, Pricing-Strategy, Forecasting, scenario-analysis, Data-Visualization, Root-Cause-Analysis, Co-Purchase-Analysis

### Product Planning & Project Specialist

Shanghai Disney Resort. Jan 2022 - Jul 2023

```text
Served as deputy to the project manager on a digital e-coupon program, building the business case and preparing leadership updates. Supported revenue management for two hotels and conducted market research and competitor analysis.
```

Skills: Business-Case-Development, Project-Management, Revenue-Management, Market-Research, Competitive-Analysis, Ideas

### Contract/Project & Business Plan Management Specialist (Licensing)

[Michelin](https://himalayas.app/companies/michelin). Dec 2019 - Jan 2022

```text
Managed business planning and performance reporting for 15+ licensees across 20 licensed categories, including monthly revenue and royalty reporting. Sized markets and built business plans for new licensees, supporting the launch of four new product segments.
```

Skills: Business-Planning, performance-reporting, Market-Sizing, Licensing, Revenue-Forecasting, Project-Management

## Education

### University of Alberta

MBA, Innovation & Entrepreneurship. 2016 - 2019

```text
MBA in Innovation & Entrepreneurship from the University of Alberta, completed in 2019.
```

### EDHEC Business School

Master in Management, Management. 2016 - 2019. Grade: Top 10%

```text
Master in Management from EDHEC Business School, completed in 2019, ranked in the top 10%.
```

### Sichuan Normal University

Bachelor of Arts, French. 2012 - 2016

```text
Bachelor of Arts in French from Sichuan Normal University, completed in 2016.
```

## Tech stack

- Amazon Redshift
- Tableau
- Superset
- Pandas
- Python
- SQL

To contact Xinlu, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Pauline Kwok](https://himalayas.app/@paulinekwok): Reporting Architecture Analyst , StackAdapt Inc
- [Amanpreet Singh](https://himalayas.app/@amanpreetsingh3): Senior Data Analyst, Allied Technical Solutions
- [Anthony Chan](https://himalayas.app/@anthonychan): Principal Financial Analyst, OpenText Corporation
- [Echo Wang](https://himalayas.app/@echowang): Data Analyst, Geotab
- [Syed Fahad Inamdar](https://himalayas.app/@syedfahadinamdar): Business Analyst, Amphenol Canada Corp
- [Carlos Rey](https://himalayas.app/@carlosrey): Data Analyst, Projects On Track SAS
- [Lam Vo](https://himalayas.app/@lamvo1): Strategic Pricing Specialist, Bell Canada
- [Faiz H](https://himalayas.app/@faizh): Senior Analyst, Client Analytics, Bond Brand Loyalty
- [Hamzah Khan](https://himalayas.app/@hamzahkhan1): Volunteer, Community Meal Support
- [Victoria Janicki](https://himalayas.app/@victoriajanicki): Business Intelligence Lead, Emco Corporation
