Meixia Yang
Phone: 650-***-**** Email: adroyw@r.postjobfree.com
Experience
May -2021 to current, Data Analyst, JD Health, a telemedicine company under JD.com
● Write SQL queries to calculate the average repeat sessions between providers and patients to evaluate providers’ quality based on retention.
● Build a dashboard to identify providers who filed significantly fewer claims than the number of sessions they had to identify fraudulent providers on the platform 2015- 2020 CEO, Noah Decoration LLC (Online Store)
● Sole CEO started an online Store across online channels (Amazon, Etsy, Faire) and reached close to half a million dollars in annual sales in 2021
● Analyze advertising campaign CTR & Conversion rate data to optimize advertising budget allocation across channels and different products
● Conducted demand and supply analysis for merchandising, inventory planning at SKU level based on seasonality and customers’ preference across channels Jan-2022 to current, Data Analyst, for kids with autism at George Hall Elementary school
● Analyze children’s behavior trends through data collection and proposed intervention treatment plans based on these analyses.
● Conducted statistical analysis to identify key areas where children are underdeveloped that need help.
Skills
Programming Language: MySql, R programming, Python (beginner) MS Office: Excel Pivot table Summary, Vlookup, Visualization, PowerPoint Education
2021-2022: Coursera Certificate Google Data Analytics Professional Certificate 2005-2010: B.A English Beijing Foreign Studies University 2011-2014: M.S Linguistics San Jose State University