Employment History:
April 2012 - March 2018
Client: A e-commerce company selling perishable products online.
1. Setup Business Intelligence for tracking product flows using BigQuery.
2. Scheduled queries to create aggregate tables which can then be used to setup data visualisations on Google Data Studio.
3. Created a data model and setup numerous charts on Google Data Studio ranging from user behaviour to monetisation.
Client: A video streaming app
1. Setup app download campaigns across Adwords, Facebook/Instagram and Snapchat.
2. Managed a Digital Marketing portfolio by setting up automatic data upload to big-query and optimising the campaigns on Cost per Install and Cost per Subscription basis.
3. Built an automatic pro forma income statement for the App on spreadsheets including the ads spend and LTV through monthly subscription revenue