Apr 2017 – Jul 2021 · 4 yrs 3 mos · Sydney, Australia

• Modelling – combined multiple supervised and unsupervised learning technique
• Seasonality Modelling – using the association rule, and cluster algorithms such as k-mean clustering, hierarchical clustering, and a self-organizing map to group merchants based on their characteristics for seasonality refinement
• Propensity Modelling – performing inferential analyses, including logistic regression, GBM, factor analysis on salesforce data to predict likelihood of lead to application conversion, or probability of a customer to churn
• ETL – End to end development from building data infrastructure to delivery of an operational dashboard
• Postgres server – migration of data from a MYSQL database to postgres database and creation of the data schema for modelling and reporting purposes.
• Tableau server – set up of internal reporting systems that allow different business units to extract, share and exchange data/insights efficiently
• Probability of business Closure - predict the likelihood of a business is going to close by using GBM and logistic regression

Jan 2012 – Jan 2017 · 5 yrs · Sydney, Australia

• Working in Business Science team with major responsibility on:
• Manage modelling projects from scoping to final presentation
• Kick started the project with the stakeholder via understanding client's need, preparing custom proposals and project timeline
• Liaise with internal and external stakeholders to collect data, cleansing, and data manipulation/transformation using R and Excel
• Statistical analytics including Marketing Mixed Modelling, Attribution Modelling, Media Mix and Regional Optimizations, using Linear regression and Logistic regressions
• Efficiency and ROI optimization analysis, prepare the Optimisation template for visualization
• Building presentations to provide insights and solutions for clients. Visualize modelling output
• Develop new visualization products (Tableau, Datorama) based on client's’ request, with signature dashboards includes:
• Performance dashboard, which enabled the clients and internal team to monitor their marketing campaign across multiple channels, improving marketing campaign visibility and efficiency
• Optimisation Tool that helps media planner to allocate the media budget across different brands/product/channels
• Attribution Dashboard and Econometric Dashboard to visualize modelling output, significantly improve the way of selling econometric/attribution modelling product
• Automating reporting process via setup SQL query to connect different data feeds in DataMart, that directly stream data to Tableau
• Support various pitch works via liaising with internal and external stakeholders,giving media mix optimization recommendation with a highly data driven approach and providing custom visualization tools
• Coach junior team members, provide dashboard training workshops to internal and external stakeholders

Jan 2011 – Jan 2012 · 1 yr · Beijing City, China

• Identified frequent errors on data entry and improved data accuracy by 100%
• Validated in-house reporting and provide regular review
• Achievement: African Mineral (AMI) financing project:
• Assisted with road show preparation and presented AMI’s prospectus to Chinese investors
• Provided daily performance commentary for AMI
• Managed discretionary accounts in HK to trade AMI, which outperformed Fuji resource index by 5% over 3 months

Jan 2011 – Jan 2012 · 1 yr · Beijing City, China

• Stock research and financial modelling for the internally managed equity portfolio.
• Collect financial/investment/property market information and trends, analyse and report on findings.
• Periodically present a detailed market research analysis to CEO

Sep 2010 – Dec 2010 · 3 mos · Sydney, Australia

• Gathered company information from various sources, includes Bloomberg, and updated
• internal database
• Assisted steel, coal and aluminium costing study with production and cost data using Macro
• and Pivot Table, and using SQL to extract data from internal database
• Prepared Steel Monthly Report, a short term market overview of the steel industry.
• Gathered daily steel related news and updated internal news database

Jan 2007 – Jan 2008 · 1 yr · Macao

• Organized and promoted 8 self-development workshops and a 2 weeks career fair with 800 attendees
• Supported the management of 300-student accommodation, and build the accommodation database from scratch by using basic SQL technique

Jan 2006 – Jan 2007 · 1 yr · Macao

• Assisted Professor Fan Chun Wai with conduct the survey to potential study objects and building database in Microsoft Access
• Assisted Professor Fan Chun Wai to organize a 200 person conference