Sales Tableau

Xinran (Cindy) Li

San Jose, CA *****

*****.*****@*****.***, 510-***-****, https://www.linkedin.com/in/xinran-cindy-li/ EDUCATION

Santa Clara University, Leavey School of Business Santa Clara, CA Master of Science in Business Analytics December 2019 California State University, East Bay Hayward, CA

Bachelor of Science, Business Administration March 2013 TECHNICAL SKILLS

● Database Presto, MySQL, PostgreSQL, SQL Server

● Visualization Tools Tableau, Plotly, Matplotlib, Seaborn, ggplot2, Microsoft Excel/Google Sheets, PowerPoint

● Machine Learning Random Forest, Decision Tree, KNN, Logistic Regression, K-means, etc

● Programming Python(Pandas, Pyspark, NumPy, Scikit-learn), R, Hadoop, AWS Athena, Redshift

● Analytics skills Google Analytics, User Behavior/Acquisition Analysis, Segmentation/Targeting, Data-Driven Marketing, A/B Testing, Probability, Econometrics

WORKING EXPERIENCE

Uber Technologies Inc. San Francisco, CA

Analyst, Restaurant Growth Analytics and Insights - Uber Eats (Via ApexSystem) February 2020 - Present

● Designed the Global Metrics Business Review Tableau dashboard, which tracks changes in gross bookings, active restaurants, closed wons, and other key sales metrics. Due to the rapid changes caused by COVID-19, added daily change views to the dashboard which traditionally shows only MoM and WoW changes. This dashboard is utilized by executives of Uber Eats to compare growth trends across regions and forecast future performance.

● Collaborated with the Sales Compensation team to develop attainment reporting, using data connections from Jira, Google Sheets, and Xactly. Utilized advanced data transformation functions (such as Pivot Table, Vlookup, Array Formular) in Google Sheets. This dashboard is used by Uber Eats Head of Strategy Planning & Analytics, Global Sales Operations to analyze sales rep performance.

● Developed an insights-driven Account Management dashboard in Tableau, focused on monitoring the health of restaurant partners and quickly surfacing at-risk locations. Launched new features including churn view, dynamic tooltips, and currency conversion by using advanced Tableau functions including Parameter, Set, Calculation Field, and LOD functions. This dashboard helped provide visibility to Account Management teams across the globe.

● Analyzed and maintained existing Presto SQL queries in Hive for performance improvements, cleaning, validating, and analyzing large datasets to develop Tableau Dashboards and Google Sheets Reports. Created complex Presto SQL queries, utilizing Uber Eats restaurant delivery, order, and Salesforce data to build BI friendly data frames and power Tableau dashboards. Atollogy Inc. Santa Clara, CA

Business Analyst Intern June 2019 - September-2019

● Queried data and generated new columns using PostgreSQL in DataGrip to prepare data with high consistency, reliability, and quality for analysis.

● Developed 18 live Tableau dashboards to help business stakeholders detect important business insights: abnormal cycles, over speeding trucks information, etc.

● Pioneered in-depth analysis (predict potential factors of operational inefficiency) on operational datasets with over one million rows using machine learning algorithms (Linear Regression, Classification, and Clustering) in Python.

● Generated four ad-hoc reports and analysis based on requirements from the business stakeholders.

● Presented four Tableau dashboards to potential customers and helped the company acquire two new customers in Sept 2019.

● Increased operational efficiency of the customer by 5% since August by designing and developing data visualization dashboards in Tableau.

● Collaborated with the VP of Customer Success and the Engineering team to identify and address areas for improvement. Shenzhen Microgate Technology Co., Ltd. San Jose, CA Account Manager August 2015 - August 2018

● Facilitated ongoing assistance for three major clients to ensure customer satisfaction on product price negotiation, resolving long product lead-time, and poor sample quality issues.

● Coordinated with Engineering, Marketing, and Operations departments to ensure on-time product delivery to customers.

● Led a team of four to conduct a competitive analysis report using Excel and PPT for the integrated circuit component market.

● Acted as a strategist technology adviser for key decision-makers. Increased company revenue in the US market by 8% in 2017. PROJECTS

Data Analytics on World Happiness Report with Python https://github.com/Cindyli0310/Data-Analytics-on-World-Happiness-Report-with-Python

● Cleaned data from the World Happiness Report, built predictive models to predict happiness scores from various factors of countries in Python. Machine learning models were used including logistic regression, decision trees, and random forests.

● Presented meaningful visualization using Scikit-learn and Seaborn.

● Delivered managerial insights by analyzing machine learning results.

Contact this candidate