Ruiyang Zou

Atlanta, GA, ***** 347-***-**** adhq66@r.postjobfree.com linkedin.com/in/kathy-ruiyangzou github.com/ruiyangzou00/kathy.github.io SUMMARY

A self-starter experienced in discovering actionable insights in fast-paced startups. Attentive to detail, having a strong curiosity, and willing to ask questions to seek answers. Brought in significant growth of $3M sales through conducting experiments, tracking key metrics, and presenting technical analysis into visualizations and compelling stories. TECHNICAL SKILLS

• Data Analytics Tool: Excel (Pivot Table), MySQL (Join, Window Function, Subquery), Python (numpy, pandas, statsmodels)

• Data Visualization and Reporting Tool: Tableau, PowerPoint, Word, Google Cloud, Google Analytics, Github

• Models: Regression, Descriptive Statistics, Inferential Statistics, Hypothesis Testing (Experimental Analysis), RFM, CLTV WORK EXPERIENCE

MarTechApe Atlanta, GA

Data Analyst Intern 08/2020 - present

• Evaluated market conditions & competitor data in Python to identify emerging trends and recommended changes to marketing tactics

• Created informative dashboards in Tableau to automatically deliver competitor analysis reports to managers, improving work efficiency by 20%

• Developed CLTV model to analyze user segment and generated budget guidelines for the marketing campaign MYKLOVR New York, NY

Data Scientist Intern 11/2019 - 08/2020

• Monitored site metrics in Tableau dashboards and identified trends of business, increasing the subscription rate by 10%

• Created entity resolution using Python to solve data merging process, resulting in a 70% reduced in execution time

• Built a concurrent Web Scraper to collect data for over 6,000 US colleges using Treading in Python, increasing efficiency by 75%

• Designed database schema, created database tables and created Views to support other teams, increased 40% query performance

• Performed Quality Assurance and Validation: aggregated and cleaned 80,000 records in database to support data augmentation EXNATIVE New York, NY

Marketing Data Analyst Intern 11/2019 - 02/2020

• Worked in a small team to perform ROI analysis via different channels and evaluate campaign performance, optimizing budget efficiency by 12%

• Defined and tracked website KPIs of marketing funnel in Google Analytics, raised hypotheses of variance and summarized root causes to executive summary for the marketing team, driving a 15% QoQ sales growth

• Ran experiment analyses of Email marketing A/B Tests by testing assumptions, calculating statistic measures (P-Value, Confidence Interval) in Python, and reporting visualization results to leaders to non-technical audiences, resulting in a 12% Open Rate increase

• Partnered with Engineers to optimize UI design and discovered areas for websites improvement; reduced 6% of Bounce Rate GLOBAL AI New York, NY

Data Analyst Intern 05/2019 - 11/2019

• Analyzed sales pattern using Excel charts, wrangled together disparate data sources and generated investment recommendation

• Delivered investment reports, giving an edge of 6% accuracy to investors in estimation than Wall Street consensus

• Managed team of 3 to construct a model of stock price movements based on earnings surprise using Python; boosted revenue by 10%

• Extracted and cleaned 3M records for over 500 US stocks using API; transformed data into the model input in Python and MongoDB INDUSTRY PROJECTS

UI Design Improvement A/B Testing 02/2020 - 04/2020

• Identified new opportunities, formulated proper hypotheses for A/B Tests, and defined metrics to evaluate the funnel of E-Commerce

• Led metrics & statistics calculation to perform Multivariate Analysis and estimated the impact for business

• Translated insights into understandable stories to product managers using PowerPoint and influenced critical business strategies

• Created concrete summaries and successfully persuaded manager to improve product-detail location; estimated to bring in $3M EDUCATION

FORDHAM UNIVERSITY New York, NY

Master of Science, Finance GPA 3.89/4.00 08/2018 - 12/2019

• Course Highlights: Data Mining in Tableau, Modern Business Analysis, Advanced Python

• Marketing Mix Modeling, E-commerce Marketing Bootcamp, AB Testing Bootcamp, Google Analytics Individual Qualification NANJING AUDIT UNIVERSITY Nanjing, China

Bachelor of Arts, Accounting GPA 3.57/4.00 08/2014 - 06/2018

Contact this candidate