Si Yi Email & Phone Number

Shanghai, China

1. Developed DWS feature-wide tables based on different business processes in the data warehouse (DWD facts table) and aggregated them into basic features for recommendation scenarios in multiple dimensions.2. Utilized Spark, Shell, Python, and other tools for data processing, such as binning and normalization, enriching model features.3. Developed and optimized live streaming CTR and post-validation (danmaku/likes/payments) models, achieving over 35% improvement in relevant metrics.4. Developed and optimized push notification strategies, resulting in a 30%+ increase in click-through rates and a 40%+ increase in room entry UV.5. Developed and maintained log and monitoring data, including ETL, analysis, and alerts. Utilized technologies such as Kafka, Flink, Spark, and Superset.

Shanghai, China

1. Utilized data mining for the construction of user profile labels, such as age, gender, retention, churn, and user preferences.2. Decomposed and implemented business data requirements, including ROI prediction, various preference audience segments, and other data development work supporting business operations.3. Maintained and optimized ETL tasks, addressing issues like data skew and dependency coupling.

Shanghai, China

1. Communicated and coordinated with government data projects, confirming data requirements, delivery formats, and standards.2. Conducted data extraction, cleaning, verification, analysis, and data visualization (Python/Tableau /Echarts).3. Prepared data analysis reports and created interactive visualizations. Key projects included data mining for citizen hotline, urban grid data exploration, housing maintenance fund data analysis, community infrastructure project data analysis, and analysis of service levels in the property industry

Nantong, Jiangsu, China

1. Managed project planning for the self-elevating drilling platform (CMHI-139), including progress and cost analysis using Excel.2. Conducted detailed design (AutoCAD) for the outfitting components of the self-elevating drilling platform (CMHI-139) project.