Andrew William Email and Phone Number

• Shanghai rotation (Mar'24-May'24) - Growth strategy project for global supermarket in China. Owned critical workstreams like measuring price importance across portfolio, building price setting tool with financial model for in-scope categories.• Growth opportunities identification and menu optimization project for international pizza chain in HK market. Developed growth hypotheses and analyses, strategically optimised architecture of Combos segment (~50% annual sales), and created financial model. • B2B pricing and packaging project with tech unicorn in visual arts space across AU and US markets. Conducted transaction data analyses, consumer research survey programming and owned choice-based conjoint insights.• Assortment optimization project with global supermarket in AU. Refined existing assortment optimization algorithm to help determine optimal ranging for attracting more regular shoppers.

• Coordinated with multiple stakeholders including data engineering, product, and growth, ops excellence teams to gather data requirements, define metrics and create project plans.• Applied BigQuery SQL to wrangle more than 100 Gbs of IoT mileage and battery data, producing source tables that feed into stakeholder projects like breakage rate and battery management reporting. • Utilized Tableau to design and create visualization dashboards on IoT data, being the first to unlock IoT insights for Zoomo.• Developed advanced data analytics framework and report for classifying customers at high risk of arrears, detecting them early on during onboarding.

• Created Market Basket Analysis (Apriori) framework to suggest product pair bundling for sales team, leading to 33% increase in revenue in experimental run. • Deployed analysis to Streamlit to automate process as part of Chief Product Officer’s approval for integration into internal systems, serving more than 200 internal sales teams.• Conducted ad-hoc analysis on customer and sales data using BigQuery SQL, producingdata visualizations in Redash to present insights for marketing and communications team.

• Led a team of 5 people on customer analytics project, specifically customer reviews analysis.• Developed the baseline model for semi-supervised topic extraction ( LDA + Word2Vec ). Given asentence, the model could output the topic on what that sentence is about.• Created several other models for various NLP tasks, including a model that indicates how negative comments are for a topic and a model for ranking information content in a sentence.