One of the developers/maintainers for the Yelp Campaign Management APIs.
Developed the customization features (e.g. Location targeting, Keywords targeting) for campaigns with AWS SQS, Kafka, StreamSQL, Redshift
Migrated daily ad inventory ETL from MapReduce to Spark and reduced the 75% runtime and cost.
Led the project to integrate our experimentation platform into Ads team, cooperated with stakeholders across teams, and advocate new tool in Ads team (~50 engineers).
Release engineer for deploying code across multiple teams
Mentored new hires and helped them onboard smoothly and quickly.
Joined on-call rotation to debug production issues across Ad system.
Became the on-point who answered any question related to our system in team slack channel.
One of the instructors of Ads academy and teached ~ 20 new hires each cohort.
Yelp, Software Engineering Intern
San Francisco, CA
05/2019 – 08/2019
Designed the schema of new Cassandra table to support more complex and flexible query.
Modified a MapReduce batch and persisted data into AWS S3, Cassandra and Redshift
Created a RESTful API using Pyramid and manipulated MySQL tables with SQLALchemy.
Built a Python batch for comparing or backfilling Cassandra tables in the past two years(140GB) and solved the performance problems of querying without partition key.
Projects
Snackathon: A React and Flask based Web Application for snack availability detection
Build the front end with React, Bootstrap and backend with Flask, Redis
Programed Raspberry Pi and controled the camera to take the photo for snack rack per 10 seconds.
Implemented the tool with OpenCV for labeling pictures and preprocess data with Numpy, Pandas.
Trained the Support Vector Machine (SVM) model with scikit-learn and stored on disk with pickle.
An Angular and Spring based IoT Application for device monitoring
Created a dashboard web application with advanced charts using Angular, Ant Design, D3.js for monitoring
Developed the backend with Spring Boot, Spring Data JPA, Spring WebSocket
Design the RESTful API and implemented the token-based authentication feature with Spring Security, JWT.
Containerized the application with Docker and Docker compose and deployed at AWS EC2.
Sold the application to a chinese company and made $2,000
Undefined: My personal tech blog
Created with Gatsby(React) to optimize SEO and managed data with GraphQL.
Supported the dark/light mode toggle, i18n, latex formula, React component in Markdown, code highlight.