Unit 504, 287 Pyrmont St, Ultimo NSW 2007 |- |-| www.linkedin.com/in/minyanshi
MINYAN SHI
PROFESSIONAL
SUMMARY
Senior Data analyst with over 4 years’ experience at top multi-national firms in the US and China,
focusing on big data analytics. Proficient data development, analytics, modelling, visualisation, and BI
reporting skills, coupled with expertise in shareholder engagement. Holding a Master of Science
degree graduating from one of the Top 3 Geography Program in the US. Thrive in fast pace and agile
environment.
SKILLS PROFILE
Database: SQL, MySQL, MongoDB, Oracle, PostgreSQL, PostGIS, and Microsoft Visio.
Data Analysis: Tableau, Power BI, Excel, Alteryx, Python, NumPy, Pandas, Scikit-Learn, Jupyter
Notebooks, R, Hive, Hadoop, Spark, Amazon Web Service, Azure, Data cleaning, Data Manipulation,
Data Visualisation, Statistical Modelling, Geospatial Analysis, and Machine Learning.
Programming: Python, REST API, SOAP API, Node.JS, JavaScript, JSON, GeoJSON, XML, and Html.
Project Management: Six Sigma, Microsoft Azure.
CERTIFICATIONS
/AWARDS
PROFESSIONAL
EXPERINCE
•
Best Project Consultant Award, A Better Community Consulting Firm for NGOs, 2019
•
Outstanding Contribution Personnel Award, Didi, 2018
•
Best Map Project, Washington State GIS Conference, 2014
•
National University Innovation Program scholarship, Beijing Forestry University, 2010
•
Outstanding Student Scholarship, Beijing Forestry University,-
Senior Data Analyst, Didi - Beijing, China
❖ World’s leading on-demand mobile transportation platform
2017/11 to 2019/5
•
Established weekly operation reports of KPI measurements presenting to the CEO, set
performance targets, evaluate performance, and provided ongoing reports and ad hoc
insights analysis extracting big data using SQL/HIVE.
•
Identified and enhanced an infection of KPI framework, increased customer satisfaction by
7.1% and supported scale to over 10,000 employees by analysing cross-channel customer
feedback data, building KPI metrics, and leading implementation project across 6 teams.
•
Fastened operation response time from 1 week to 1 day by defining monitoring framework
with over 20 steps and 80 KPIs, building data capability forming operation database
coordinating among cross-function team, and delivering a real-time Tableau dashboard.
•
Strategically supported customer retention along with $1 million cost savings, identifying and
implementing “drivers signing up account” process optimisation through quantities analysis,
surveys, and customer interviews, collaborating with Product team.
Strategy/Project Consultant, A Better Community Consulting Firm for NGOs – Beijing, China
❖ Pioneer consulting firm for NGOs, Partnership with PWC, Accenture, Microsoft, and IBM
2018/09 to 2019/02
•
Specified the scope and requirements of a 5-year development plan for a foundation
increasing education in rural China by supporting project manager conducting interviews and
1-day workshops with C-level members of the education foundation.
•
Delivered recommendations for the development plan focusing on preschool children by
leading 3 members conducting industry analysis, market research, and expert interviews.
•
Formed the strategic plan identifying market opportunities, strategies, and development
journey for the foundation across 0-16 years old children, collaborating with 10 consultants
from global leading consulting firms like McKinsey, BCG, KY and Deloitte.
Business Data Analyst, Newmark Knight Frank – Chicago IL, USA
❖ Global leading commercial real estate advisory firm
2015/03 TO 2017/03
•
•
Identified over 280 site opportunities for clients’ market expansion working on 5 client
accounts with $6 million revenue retail group. Delivered in-depth market and site analysis
reports using social-economic, population, and competitors’ data.
Developed the predictive model that supported a major client’s annual expansion plan of
over 300 retail sites by integrating internal data and various third-party social-economic, and
customer segmentation data from ESRI, AggData, and Forum Analytics.
•
Supported business development managers making deals in the field providing real-time
data, and saved 27% mapping operation time by automating map updates with ArcGIS online
using Node.JS, Rest API, and JavaScript.
•
Reduced operation time by 14% by building dashboards showing milestones of potential
retail sites’ development and bringing the tool into use with trainings for cross-function and
geographical dispersed teams and clients.
Business Data Analyst, Zillion Info – Columbia SC, USA
❖ Innovative location intelligence and big data analytics platform
2014/08 to 2015/01.
EDUCATION
•
Won customer contract from department of urban planning by building demo of visualising
time series data and illustrating change patterns for a smart city plan.
•
Created customer-friendly manual for the school redistrict analytics web platform.
MASTER OF SCIENCE: GREOGRPHY
2011/08 to 2014/05
State University of New York at Buffalo – Buffalo NY, USA
GPA: 3.9/4.0
•
Awarded the “Best Student Map” at Washington State GIS Conference using logistic
regression model to predict the suitability for vineyards
BACHELOR OF SCIENCE: GEOGRAPHIC INFORMATION SYSTEMS
2007/09 to 2011/06
Beijing Forestry University – Beijing, CHINA
MAJOR GPA: 3.6/4.0
•
Led a research group of 3 people publishing paper “Extracting Crowns of Populous based on
Quickbird High-resolution Remote Sensing Imagery
