Ran(Amanda) Yang

Experience

• 

  China National Offshore Oil Corporation, CNOOC

  Jul 2012 - Sept 2012

  Marketing Intern

  • Classified data of Guangzhou LPG (a kind of clean energy) market, calculated indexes based on previous market model and energy evaluation equation, and proposed analysis report to LPG project manager;• Participated as researcher into field-investigation of Guangzhou LPG market and reported analysis of current situation of LPG promotion using Excel data analysis tool;• Assisted manager to draft the proposal of enhancing LPG promotion in Guangzhou to government and participated government conference of clean energy development; Show less

• 

  Guangzhou Communications Technician Institute

  May 2013 - Jul 2013

  Internship

  • Intern as a teacher teaching internet marketing course, covering even marketing, viral marketing, inbound marketing, keywords bidding, social media marketing and so on;• Encouraged students to conduct a marketing plan for an electronic commerce company: yixun.com;• Designed a business game for students to simulate transaction by playing roles in supplier, manufacturer, bank, mortgage company in different business environment;

• 

  Facts and Measures, LLC

  Jun 2014 - Jun 2016

  Data Scientist

  • Conducted visualization, hypothesis test and ANOVA on New York State Inpatient Quality Indicators data using Tableau, Power Query, Power Pivot, Power View and Excel;• Analyzed voter behavior and predicted whether vote or not for next year on Voter information data using SQL Server Data Tool to process SSIS and SSAS; compared performance among data mining algorithms including decision tree, clustering, logistic regression and neural network; • Integrated data and optimized database structure for Financial Capital group insurance;• Applied study plans and trained teammates to achieve the MCSA and MCSE certificates;• Data Management, Data Mining, Modeling• MS SQL Server, MS SQL Data Tools, IBM SPSS Statistics, IBM SPSS Molder, R, Splunk Show less

• 

  Merkle

  Aug 2016 - Sept 2018

  Senior Analyst
• 

  Deloitte Digital

  Sept 2018 - now

  Senior Consultant