Clarence San
Data Science and Analytics professional with 5+ years industry experience
- clarencesan@gmail.com
- Website
- https://github.com/csanry
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:
- Frameworks
- Keywords: