Tina Xinyue Chen Email & Phone Number

Los Angeles, Ca, Us

Salt Lake City, Utah, Us

•Owned analytics aspect of planning and result analysis for new versions release, including identifying key success metrics, assisting in tracking event implementation, and maintaining data dictionary•Conducted deep dive analysis such as User Behavior, Feature Usage, and Funnel Analysis to unlock growth opportunities for Smule Mobile Apps and websites using Snowflake SQL and Python•Built automated dashboard and alerts using Tableau; Acted as the primary partner for Product Managers to understand the performance of the platform by monitoring KPI trends and diagnosing product issues•Translated analytical findings into actionable recommendations and strategies. Collaborated with cross-functional teams such as Product Design, BI, and Engineers for implantation•Consolidated upcoming A/B tests on a weekly basis and ensure no confounding factors between tests

New York, Ny, Us

•Own and develop efficient data flows to extract insights from multiple databases using complex query statements; troubleshoot data discrepancies to ensure data quality.•Develop, monitor, and report on extensive revenue KPI’s with specific attention paid to understanding the ROI of various revenue lines and initiatives.•Create tools and dashboards for fundraising teams and revenue line managers; analyze current dashboard usage to identify opportunities for optimization.

75017 Paris, Fr

•Performed various analyses including Campaign Performance analysis (Open Rate, Click Rate, Unsubscription ratio, and ROI), Omnichannel customer analysis, and other customer segmentation analysis in order to increase customer engagement and growth. •Established 3 major reports and dashboards to track KPIs related to retail marketing performance and generated actionable business insights by using Adobe Campaign, Salesforce, Zendesk•Analyzed Customer Experience based on customer demographics, engagement, and other metrics and initiated action plans that increased ROI •Monitored data flows to catch and resolve issues by collaborating with IT using Jira Ticketing System •Established various surveys, including Net Promoter Score Survey, and statistically analyzed the feedback

New York, Ny, Us

• Predicted 2019 Q4 Global Local Office Cost, Revenue and Budget using ARIMA Time Series Model and presented the Tableau visualization result to the Office of Financial Management• Built several automation dashboards for KPI Performance Reports and Project-based Reports that served 173 offices worldwide and saved 70% of time• Migrated data mart to the new data model structure, including business requirement gathering, gap analysis, SQL development and improvement, and Power BI dashboard development and automation.

Munich, Germany, De

• Researched for data related to “Airport City” from the internal database and public industry report• Drafted the Developing Model of Beijing International Airport City based on the analysis of case studies• Assisted the Project Manager to identify project requirements and prepared documentation for thecommunication with the Mayor of Beijing

Coralville, Iowa, Us

• Performed qualitative market research and Risk Analysis of the China market to determine the entry opportunities, constrains, beneficial polices and potential challenges and presented to the board of director• Created a model to calculate ROI of media spend and develop Tableau dashboards visualization to present rider and channel performance including KPIs, projections, and historical performance• Identified potential advertising channels and negotiate the advertising cost after conducting industry research

Master'S Degree, Management And Information System

Bachelor Of Business Administration (Bba), Accounting