Kristen(Jiatong) Yao

Kristen(Jiatong) Yao Email and Phone Number

Data Analytics | Consulting | Python | R | SQL | Tableau @ Simon Practicum - Transitowne (Auto Dealership) Project
Rochester, New York Area
Kristen(Jiatong) Yao's Location
Los Angeles Metropolitan Area, United States, United States
About Kristen(Jiatong) Yao

Innovative, self-motivated, creative, and data-driven storyteller with excellent analytical and communication skills. Proficient in R, Python, SQL, and Tableau. Fluent linguistic in English, Mandarin Chinese, and basic Italian. Experienced in marketing & pricing strategy and data analysis. Proficiency in Using: R programming, Python programming, SQL, Tableau, Google Analytics, IBM Waston, MS Office Tools, Adobe Photoshop, CADSkillset snapshot:-Marketing Research: Backward Marketing Research, Customer Segmentation, Product Map, Perceptual Map, Conjoint Analysis, Simulated Test Market, Focus Group, Social Media Analysis.-Statistical Analysis: Explanatory & Exploratory Analysis, Machine Learning, Statistical Modeling, Predictive Modeling (Linear/Polynomial/Logistic Regression, Neural Networks, AIC, BIC), Hypothesis Test, Optimization, Grid Search, Bootstrapping.-Pricing Strategies: Product Line Pricing, Break-even Analysis, B2B Pricing Strategies, Competitive Pricing, Online Pricing, Dynamic Pricing, Demand & Willingness to Pay Forecast, Platform Pricing.-Business Analysis: Machine Learning(Decision Tree, Bayesian Classifier, Neural Networks), Dashboard Building, Visualization, Clustering, Text Mining, NLP, Principal Components Analysis.

Kristen(Jiatong) Yao's Current Company Details
Simon Practicum - Transitowne (Auto Dealership) Project

Simon Practicum - Transitowne (Auto Dealership) Project

View
Data Analytics | Consulting | Python | R | SQL | Tableau
Rochester, New York Area
Kristen(Jiatong) Yao Work Experience Details
  • Simon Practicum - Transitowne (Auto Dealership) Project
    Simon Practicum - Transitowne (Auto Dealership) Project
    Rochester, New York Area
  • Simon Practicum - Transitowne (Auto Dealership) Project
    Data Analyst
    Simon Practicum - Transitowne (Auto Dealership) Project Feb 2019 - Present
    Leveraged customer behavior data and analytics to drive customer acquisition, retention, and growth. • Reorganized source data (1.5 years, 20+ million rows) using R, including build a data pipeline to transform the source data into multiple granularity levels automatically; Conducted ETL (Extract-Transform-Load) processes and set up customized databases using MySQL.• Building predictive models based on sales and demographic data analysis to develop customer personas and ideal customer profiles and visualized the results with Tableau.
  • Simon Vision Consulting
    Marketing Consultant
    Simon Vision Consulting Jan 2019 - Present
    Rochester, Ny, Us
    Conducting a branding strategy project to strengthen YourCare’s (healthcare) brand awareness across NY state. • Developing branding plan for local Rochester start-up healthcare company as a member of a five-person team; providing insights into new branding campaign by gathering and analyzing competitive intelligence; tailoring branding position by analyzing strategic strengths and weaknesses of competitors.• Designing an innovative digital marketing plan as part of the overall project by conducting benchmarking research on social media development, webpage design, and advertisement promotions.
    View
  • Ernst & Young
    Consultant Internship-Risk
    Ernst & Young Feb 2017 - Jun 2017
    London, Gb
    Conducted data analysis for the State Grid Jibei Electric Power Company that improved China Electric power reform•Collected data by communicating with clients and researching on third party platform •Utilized Tableau to visualize data by scatter diagrams to determine characteristics of power companies macroscopically •Built linear models in Excel to adjust and verify the related factors in macro hypothesis•Presented the analytical results in front of leadership team and provided recommendations for the Access System of the State Grid Jibei Electric Power Co.
    View
  • Ernst & Young
    Accountant Internship-Advisory
    Ernst & Young Jul 2016 - Aug 2016
    London, Gb
    Participated in semiannual audit program of Chinalco (Aluminum Corporation of China Limited)•Responsible for completing audit papers in main business incomes, main business cost, and fixed assets•Communicated with client’s financial auditors to obtain audit evidence; checked credentials; sorting papers
    View

Kristen(Jiatong) Yao Skills

Sql Microsoft Excel Microsoft Office Microsoft Powerpoint Tableau Microsoft Word Skilled Multi Tasker Data Analysis Project Management Business Strategy Statistical Data Analysis Statistical Modeling Nosql R Leadership Management Neo4j Python Teamwork Financial Analysis Team Leadership Accounting Financial Reporting Reporting And Analysis Presentation Skills Regression Analysis

Kristen(Jiatong) Yao Education Details

  • University Of Rochester
    University Of Rochester
    Business Analytics
  • Beijing Technology And Business University
    Beijing Technology And Business University
    Accounting
  • University College Cork
    University College Cork
    Accounting
  • The University Of Hong Kong
    The University Of Hong Kong
    English Discussion Skills: Critical Discussions On China

Frequently Asked Questions about Kristen(Jiatong) Yao

What company does Kristen(Jiatong) Yao work for?

Kristen(Jiatong) Yao works for Simon Practicum - Transitowne (Auto Dealership) Project

What is Kristen(Jiatong) Yao's role at the current company?

Kristen(Jiatong) Yao's current role is Data Analytics | Consulting | Python | R | SQL | Tableau.

What schools did Kristen(Jiatong) Yao attend?

Kristen(Jiatong) Yao attended University Of Rochester, Beijing Technology And Business University, University College Cork, The University Of Hong Kong.

What skills is Kristen(Jiatong) Yao known for?

Kristen(Jiatong) Yao has skills like Sql, Microsoft Excel, Microsoft Office, Microsoft Powerpoint, Tableau, Microsoft Word, Skilled Multi Tasker, Data Analysis, Project Management, Business Strategy, Statistical Data Analysis, Statistical Modeling.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.