Pioneered data migration from NoSQL to SQL database for over 800,000 users. Optimized speed of migration script to be faster by 10 times using batch queries and ensured data sanity using verification scripts.

Created the first release with SQL database on production, setting the configuration of SQL database and the foundation for future SQL releases.

Led a team of 7 people to create an instructor account request portal in 6 weeks, reducing 90% of manual effort for administrator to process instructor requests and notify instructors.

Created ExcelFlex SDK using Golang and Excelize library to streamline Excel data conversion for TikTok Shops' brand partners, cutting exportable Excel report development time by 50%.

Spearheaded design of account onboarding system for key brand partners using Golang, simplifying communication cost among 4 groups of stakeholders by 80% and reducing system maintenance effort by 80%.

Led development of regional report email service for key accounts in Europe. Deployed cronjobs, optimized email lists, and established a task management database for seamless and compliant reporting in European operations.

Created TypeScript questions and solutions for frontend interview related content.

Helped in localization of the website design and translation for Chinese users.

Collaborated in a 6-member cross functional scrum team to create rankings of products in global e-commerce software and to provide sellers with greater transparency of performance of their products, improving the penetration rate for sellers with sales by 3%.

Built line chart modules using React, Less and Storybook in Data Insights team’s charting library, which reduced configuration time for each chart from 2 days to 1 hour, and enhanced extensibility of 20 usages across codebase.

Built a notification banner system using Java and Angular to disseminate essential updates such as deprecation of features to 800,000 users.

Implemented user statistic graphs using D3.js and Cron Jobs for administrators to monitor user responses.

Implemented a Case Management System (CMS) using Ruby on Rails, React, TypeScript and PostgreSQL to enable Lions Befrienders Service Association (LBSA) to provide counselling services to 1,000 clients every year.

Communicated weekly with clients from LBSA and CareCorner Singapore and turn the complex requirements into a digital workflow for 250 staff.