Edward Wan

- Ai Driven Analysis - Ai Project & Product Development - Product Analysis - Sales Forecasting - Data Modeling - Campaigns Analysis - Loyalty Programs Analysis

-Lead analytics support for new and existing clients (including FMCG and property management in HK and oversea) to analyze the business and customer behavior based on their business needs, with the aim to discover customer potentials and derive business value -Manage a team of colleagues, assigning them tasks to create automated daily and weekly reports using Python andAPI extraction, reduced weekly report generation time by 90%, resulting in increased efficiency and client satisfaction -Work closely with sales team to develop measurement strategies based on traffic, engagement and demographic data for clients truly understanding their target customer behavior, effectiveness of marketing campaign and operation

-Developed the segmentation and modeling (RFM Model, Customer Engagement Model) for targeting the customer from Hang Seng Credit Card, LIVI Bank and Insurance Partners (Allianz, Chubb and Hang Seng Insurance) -Work self-sufficiently to find the customer behavior and characteristics in order to present any actions for future development & strategic business opportunity, as well as enhancements to operational policies -Work closely with internal (CRM, Marketing & Financial Team) and external partners in building, implementing, tracking and improving the KPI (acquisition & sales) , decision strategy and pre & post - campaign preparation and evaluation

Received, cleaned, and extracted data from data warehouse using SQL, Access and Excel to provide real-time insights into the product, service and marketing campaign Developed data architecture design to enable analysts and perform targeted customer analysis Conducted a strictly financial analysis based on the weekly sales revenue and KPIs among all channel

Created informative and actionable reporting that highlights relevant business, sales trends and opportunities for improvement Built the complex Tableau dashboards with advanced functions and SQL to provide insightful analysis Designing, developing, and maintaining data collection systems and SQL Server databases

Supported new device/smartphone launch and execution plan Organized marketing campagins and events (ACGHK 2017) Collected quantitative and qualitative data from marketing campaigns