Yi Fang Yeh Email & Phone Number

Taiwan Taichung

◼︎Successfully introduced data-driven thinking to a startup, creating a data team from scratch. ◼︎Developed 25+ dashboards for regular data tracking, providing insights for all departmental staff. ◼︎Produced automated business reports, incorporating key indicators such as AARRR. ◼︎Led a data tracking project with Firebase, collaborating with front-end engineers to implement a systematic data tracking structure, resulting in comprehensive user data. ◼︎Constructed an ETL pipeline with Data Engineers, facilitating automated data-driven decision-making. ◼︎Evaluated 10+ product experiments, including multiple A/B tests, accelerating product iteration speed by 40%. ◼︎Build an internal SQL AI query system for colleagues to access data via natural language, increasing data acquisition efficiency by 80%.

台灣 臺北市

◼︎Utilized SQL for daily database queries to provide daily ad reports.◼︎Constructed an on-site Search Volume Dashboard, guiding strategy formulation.◼︎Process ad-hoc data requests and assist advertising team members in monitoring performance.◼︎Provide regular analysis reports and provide action recommendations based on insights.

台灣 臺北市

■ Analysis Report【Retention Rate Report】Utilised SQL to analyze Retention Rate of members and defined “key retention period”.After giving voucher for users based on the analysis, retention rate increased by 10%.【Web / App Behavior Analysis】Obtained raw data from GA and Firebase and transformed to metrics or dimension ofuser flow. Visualized data by Tableau and keep optimize with a/b testing.【SEO Predicted Report】Connected with Google Trend API with Python and predicted search volume of movies.■ Data DashboardBuilt 10+ dashboards for editors & marketing team to track KPI of articles and ads.■ Data TrackingCollaborated with R&D to track user behavior data for a/b testing in multiple devices.

台灣 臺北市

■ Data AnalysisCreated data visualization dashboards with Power BI to illustrate the insight.Analyzed website data with Google Analytics, and led projects to optimize websites.【Registration Optimization Project】Queried MySQL database and joined different table to defined membership level.Analyzed member behavior and redesigned registration page based on the analysis report. As a result, the registration rate growth by 20%.■ SEODeveloped and implemented strategies. Monitored the performance by Google Search Console.Coordinated with the R&D team. Generated Sitemap and Breadcrumbs to help SEO.Cooperated with the Content team. Directed the team to create SEO friendly articles.The traffic of Organic Search increased by 178% as a result.■ Advertising ManagementManaged Google Ads and plan SEM strategies. Increased 20% growth in sales. Managed Facebook Ads in promotional events. Increased ROAS by 30%.

台灣 高雄市

■ Commercial ProductionWrote scripts, cooperated with a film studio and edited videos.Finished 8 commercial videos for 3 months.