Mengying LI

Mengying Li
Data Scientist
Windows Device Group Core Data Science Team
Microsoft Corporation

MengyingLi.github.io
ml3576@columbia.edu

I'm a Data Scientist at WDG (Windows Device Group) Core Data Science Team of Microsoft. I joined Microsoft right afte graduating from Columbia University with a M.A. degree in Quantitative Methods in the Social Sciences.
I am specialized in data analysis and data visualization. I am familiar with R, Python, U-SQL, Stata, ArcGIS, HTML, CSS and JavaScript (D3.js, Leaflet.js, etc.). My current projects at Microsoft focus on app usage, app install base, Windows gaming population and device hardware attributes. I enjoy going to data science and data visualization meetups in my free time. I maintain some of my projects on GitHub.

Education

2013–2015 M.A., QMSS, Columbia University in the City of New York, New York, New York, USA Relavant Coursework: Applied Data Mining; Applied Data Science; Data Analysis for the Social Science; Data Visualization; Spatial Analysis & GIS; Advanced Spatial Analysis & GIS
2009–2013 B.A., Economics (Honors Program), University of International Business and Economics, Beijing, China Relavant Coursework: Econometrics; Micro-Econometrics; Intermediate Microeconomics; Intermediate Macroeconomics; Mathematical Economics I & II; Financial Economomics
Advisors: Chunhua Wang
Thesis: Relative Intensity of Coal Consumption in China

Work Experience

2015– Data Scientist, Microsoft Corporation, Redmond, WA • Writing complex U-SQL/SparkSQL queries to subset, manipulate and aggregate massive data sets and generating business insights by conducting detailed analysis and rich visualization using R/Python.
• Autamating the creation of dashboard reports with Javascirpts and Kendo to help internal and external stakeholders have an easy and clear view of the underlying data.
2014–2014; Data Integration Intern, Nielsen N.V., New York, New York, USA • Integrated clients’ survey data with Nielsen’s panel data to enable clients’ build-up of cross-media brands using SAS.
• Calculated and visualized fusion consistency scores to create reports for clients from fashion show industry using R.
2014–2014 Data Analytics Intern, McGraw-Hill Education, New York, New York, USA • Used D3.js to modify the product prototype to enable individualization of student assignments.
• Classified students’ success using machine learning with R & Python to direct teachers’ timely intervention.
• Actively contacted and updated research results to key people in sales and technical departments.
2012–2013 Government Affairs (GA) Coordinator, DuPont, Beijing, China • Collected government news and analyzed policy information about DuPont’s business in food, energy, and protection.
• Interacted with government agencies and GA team to manage time schedule and host meetings.
2012 Conference Staff, Financial Times (FT) Chinese, Beijing, China • Edited the bulletin for FT Chinese 2012 Annual Forum and contacted guests and lecturer.
• Set up the venue, registered the guests and maintained the order of the conference.
2012 Research Analyst & Administrative Intern, Ministry of Commerce, Beijing, China • Collected and analyzed data in the research of low-carbon economy and energy development in China.
• Exchanged confidential files and kept record of the business trips of leaders in the department.
2012 Fund Manager Assistant, Industrial and Commercial Bank of China, Beijing, China • Collected and classified customers' information and registered new customers.
• Revised marketing strategy of a new personal finance product which ranked the most popular product in February.

Research Experience

2013–2014 2015 Environmental Sustainability Index Center for International Earth Science Information Network, Earth Institute, New York, New York
• Use R and Excel to update and clean up the enrionmental performance indicator data for each country from 2005 - 2013.
2013–2014 Index Insurance in Ethiopia International Research Institute for Climate and Society, New York, New York
• Calculate the local rainfall-elevation relationship and spatial-temporal correlation of rainfall in Ethiopia using R, ArcGIS and SatScan.
• Create multiple maps to visualize the rainfall distribution pattern in Ethiopia using ArcGIS, and write a 4500-word report.
2013–2014 Amsterdam Avenue Project Sociology Department, Columbia University, New York, New York
• Design and create the Stata dataset to store the results from more than 400 surveys.
• Analyze the distribution of social and physical disorder along Amsterdam Avenue using R and ArcGIS.
2013–2014 America’s Changing Neighborhoods: An Encyclopedia of New Faces of Ethnicity & Diversity Sociology Department, Columbia University, New York, New York
• Reviewed relevant literature and collected census data about demographic and social change of 8 ethnic groups in New York City.
• Analyzed the data and visualized the result using R and ArcGIS, and write a 4500-word report for each ethnic group.
2012–2013 Comparative Study of Carbon Intensity in China and the US University of International Business and Economics, Beijing, China
• Modified the decomposition model and reviewed literature on related carbon emission indexes in both US and China.
• Compared empirical results of US and China and drew political implications in carbon reduction.
• Published the research paper in Science & Technology Progress and Policy (CSSCI).
2012–2013 Study of Environmental Satisfaction in Chinese Cities University of International Business and Economics, Beijing, China
• Reviewed literature on contingent valuation and environmental concern theory and revised regression models.
• Interpreted regression results and verified them in a multi-probit model with 500 observations using Stata.
• Presented the research paper in a seminar with over 100 attendants; the paper is under review with Regional Studies.
2010–2011 Measurement and Analysis of Price Index for Students University of International Business and Economics, Beijing, China
• Led a team of 7 to collect over 2000 questionnaires among 200 samples over 1 year, and analyzed the data using Stata.
• Wrote a 10-page report that raised the university’s awareness of students’ inflation-adjusted subsidies.

Honors & Awards

2012 Second Prize in Literature Review Contest (5% out of 100) University of International Business and Economics, Beijing, China
2012 Meritorious Winner in 2011 Mathematical Contest in Modeling (20% out of 735) The Consortium for Mathematics and Its Applications, Bedford, MA
2010–2012 China National Scholarship (1% out of more than 8000) Ministry of Education of the People's Republic of China, Beijing, China
2009–2012 Excellent Student (5% out of 441) University of International Business and Economics, Beijing, China
2011 Key Project & Second Prize in Research Project Contest (Rank 10/ 100) University of International Business and Economics, Beijing, China
2010 Key Social Practice (Rank 5/60) University of International Business and Economics, Beijing, China

Publications & Working Papers

2013 Study of Carbon Intensity in China and the US [Science &Technology Progress and Policy accepted] Mengying Li, & Chunhua Wang
2013 Environmental Satisfaction in Chinese Cities [Regional Studies submitted] Changdong Zhang, Mengying Li, & Chunhua Wang

Leadership & Volunteer Activities

Sep. 2012 Volunteer Translator for 4th Beijing International Polo Open Tournament Beijing, China
2010–2011 Leader of Theoretical Research Department at Agriculture & Rural Area Association Beijing, China
July. 2010 Social Practice Leader for Summer Rural Volunteer Activity Muge Village, Bozou, Anhui Province, China
Jan. 2010 Social Practice Member for Winter Rural Volunteer Activity Zhujiaying Village, Baoding, Hebei province, China
July 2009 Volunteer Kindergarten Tutor for Chunhui Kindergarten Taiyuan, Shanxi Province, China