• Constructed database auto-update strategies, integrating Python and SQL to deliver reliable ETL pipeline• Developed dynamic, automated Looker dashboards for real-time KPI tracking, improving campaign performance monitoring efficiency• Created comprehensive dashboards for KPI reporting and performance monitoring, addressing data issues with advanced data solutions.• Partnered with clients to evaluate business request and perform analytical approaches to identify user trend• Collaborated with external technical stakeholders to showcase features and tools that streamline the onboarding process• Coordinated product developments with engineering team to build personalized ad-creation system• Built and implemented models to inform strategic decisions and project planning (Marketing mix model, Classification model, Market affinity model)

• Established the automation testing projects, enhancing release efficiency by 32% using Python and Shell• Initiated and built auto-reporting system, supporting effectively monitored and daily regression test results• Collaborated closely with engineering team to investigate optimal system configurations, boosting data transfer efficiency by 13% by applying statistical models and analysis• Designed and maintained testing documentations, supporting feature development and validation process• Managed and synchronized projects across multiple teams, ensuring seamless bug fix procedure

• Designed VR solution that improves inexperienced drivers’ skills by 1.6 times using Python• Built automated data pipeline to extract, load, and transfer user data from VR system• Applied statistical analysis to evaluate the system effectiveness (ANOVA, logistic regression, hypothesis tests)