Daniel Liu Email & Phone Number

Vancouver, British Columbia, Canada

-Innovating and developing the Active Concession Management System (ACMS) across the network airports for the Commercial Team to leverage big data to improve revenue and stretch sales potential.-Benchmarking and positioning concession performance between specific airports and the industry, contributing data-driven results and guidance for concession.

Greater Chicago Area

Focusing on Non-aeronautical business:Concession units (F&B and Retail) performance analytics Passenger survey / analysis Market trend analysis and forecast Data modeling and dashboardFinancial performance analysisSpace planningMicrosoft Power BI / Power AutomateDatabase administration

Taipei City, Taiwan

• Took lead to conduct market gap analysis to identify potential business opportunities.
• Successfully managed marketing research with AC Nielsen, analyzed qualitative and quantitative data to understand customers’ opinions in-depth to increase the attractiveness and feasibility of the offers.
• Determined analytical objectives and strategies with specific measurements (KPIs). Performed daily and weekly reviews and analysis of the current projects by using the established metrics.
• Created data requirements files and collected large amount of customer transactional data (more than 600K members) from clients. Involved in raw data validation and ETL process, ensured data quality.
• Designed automated daily dashboard to show KPIs by SKUs by stores by regions to interact with clients. Created weekly dashboards for 3-4 account managers to follow up their projects and take necessary actions to.
• Collaborated with a team of more than 10 members from partner companies located in Canada and the Netherlands to conduct full in-depth analysis for each project with billions of data rows. Overcame the issue of.

Shanghai

• Analyzed weekly store-level operational data to keep track of store operations metrics and generate insights to improve store operations by stores by regions.
• Optimized models to forecast and re-project weekly sales by projects based on current trend and historical data.
• Requested and collected weekly stores transactional data from clients’ data center based on analytical needs.
• Designed data files and updated each file on a weekly basis to keep the entire team updated about the latest sales and project key performance indicators.
• Conducted weekly and monthly inventory analysis from manufacturer’s production all the way down to demands from clients’ individual store to optimize the trade-off between associated cost and fulfilment.
• Managed inventory replenishments (6 – 8 SKUs by projects to over 1,000 supermarket level stores) based on actual sales data and reprojection, reduced out of stock risk within 5% level successfully.

Shanghai

• Conducted marketing research to evaluate influence on end customers’ preference and decision-making process when perceiving additional bonus during shopping.
• Involved in designing customer loyalty project strategy and detailed mechanism along with operations, marketing, account managers and sales managers.
• Provided project’s training to client’s staff before each project kicked-off, networked with more than 50 store managers each project and maintained an excellent communication throughout the entire project period.
• Updated weekly project performance reports to the clients.
• Visited and observed client’s store execution and advised recommendations to improve.
• Participated in meetings with clients and performed as a key channel to follow-ups on a regular basis.

Master Of Science - Ms, Business Data Analytics

Courses including Business Analytics, Analysis Big Data in Python, Customer Analytics, Data Visualization, Data Mining, Forecasting.

Msc Advanced Marketing Management

Activities and Societies: Students: Marketing Degree experience included an empirical project at the Partwell Group for 4 months. Modules.

Ba (Hons) Business With Marketing, Marketing

Marketing, Finance, Human resource, Business information, Supply chain, Organisational culture, Management, and Leadership.