Clarence San

Data Science and Analytics professional with 5+ years industry experience

Education

Master of IT in Business in Analytics
from Singapore Management University

Courses

  • GMAT 750 (98th percentile)
  • Coursework - Applied Machine Learning, Big Data Techniques, Data Science for Business, Machine Learning Engineering, Statistical Analysis, Spreadsheet Modelling

Bachelors of Arts in Media and Communications
from University of Melbourne

Courses

  • Coursework - Digital Media Research, Research Methods, Comparative Media Systems, Marketing Communications

Experience

present

Senior Data Analyst at foodpanda

Highlights

  • Designed and implemented a relational data wareshouse using BQ and dbt; reduced computation requirements of pipelines >10%
  • Built and managed tableau and looker studio dashboards, consisting of >50 SQL queries for 11 markets in the APAC region
  • Wrote and open sourced python libraries and applications
  • Automated email sendouts and presentations for business stakeholders; reduced time to query data and prepared monthly reports from 4 hours to 30 minutes
  • Managed a large-scale source migration of >200 dbt models with 0 incidents; eliminated timeout errors by refactoring dbt models; identified and deprecated 40+ redundant models to save >$300 USD in monthly cloud expenses

Advanced Analytics Associate at Kantar Millward Brown

Highlights

  • Developed analytic models - methodologies included Structural Equation Modelling, Regression, Classification, Segmentation, Ensemble modelling and Marketing Mix Modelling
  • Conceptualize and spearheaded an APAC-wide knowledge session on improving MS Excel workflows - 500+ attendees
  • Instituted a repository of ~20 Python, R, and VBA scripts to streamline workflow efficiency and reduce time required for menial checks by more than 80%

Projects

ELT Pipelines with dbt, airflow and snowflake :

Highlights

  • Data Engineering project demonstration

Foodpanda Data Visualisation challenge :

Highlights

  • 2nd place in the competition

Foodpanda Data Summit '23 Hackathon :

Highlights

  • 3rd place in the competition - Ridernomics

Skills

Languages
Keywords:
  • Python
  • R
  • SQL
  • Scala
Frameworks
Keywords:
  • Google Cloud Platform
  • BigQuery
  • Airflow

© 2024. All rights reserved.