Foster Guo Email & Phone Number

Shanghai, China

Xiamen, Fujian, China

- Worked in the Regulatory Statistics Products department, primarily on the Credit Checking System.- Refactored, designed and constructed a comprehensive Credit Checking Data Warehouse Framework for 3 banks, reduced internal data quality issues to 0 and ensured crucial data quality requirements set by the People's Bank of China.

Fuzhou, Fujian, China

- Worked for Content Mid Platform, including Content Ecology, Content Moderation and Content Operation.- Built the Content Ecology Data Warehouse from 0 to 1, guided by Kimball dimensional modeling, increased the bi-monthly data demand satisfaction rate from 62% to 90%, optimized ETL performance, decreased computation costs by 37%, enhanced data quality, reduced bi-monthly quality issues from 6 to 1.- Designed and developed a framework (Strategy Recall Platform) to assist content teams in retrieving data independently, accessed over 10 products and 30 entities, executed 100k+ tasks per day within ByteDance, led the full stack development, achieved significant performance optimization, reducing computation time by 90% and computation costs by 23%, attained a bi-monthly average user satisfaction rate of 96%.