Daniel Liu Email & Phone Number

Chicago, Il, Us

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 management and identifying new business opportunities from the existing airports.-Managing all non-aeronautical data analytics with the analyst team and fulfilling analytics-related requests such as reports, templates, and documentation. -Forecasting air travel demand and trends and segmenting passengers to enhance passenger engagement with customized offerings to increase conversion rate.-Budgeting the sales and evaluating the financial impact-Customizing sales dashboards to support network site management with valuable and customized insight through advanced data analytics and data visualization.-Working cross-functionally with Marketing to deliver passenger engagement measurements and potential ROI.-Leading analytics projects for internal entities (internationally)

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 improve the outcomes. • 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 different time zone. • Presented analyzed results in an interactive and story-telling way to all level audience 2 times per project. • Forecasted and simulated inventory by weeks and managed weekly inventory allocations to minimize the risk of stockout and overstock (±5% tolerance) for 4 projects operated in 2 countries simultaneously.

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. • Conducted stock allocation for client in order to get the right stock to the right store at the right time, achieved less than 10% out of stock situation. • Screened nearly 30 customer service calls each day and succeeded to resolve 93% of issues from customers.

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.