Shuang Li

I'm Data Analyst

About Me

Hi, I’m Shuang — originally from Beijing, with international experience living and working across the United States and Latin America. My background spans project coordination, cross-cultural communication, and operations support, which gradually led me toward data analytics and data-driven problem solving.


Today, I’m pursuing a Master’s in Data Science at Illinois Institute of Technology while building hands-on experience in analytics, business intelligence, and visualization using SQL, Python, R, Tableau, and Power BI. I’m particularly interested in projects that connect data, operations, sustainability, and real-world decision-making.


Outside of work, I enjoy traveling, hiking, nutrition, and exploring new technologies and ideas. Fluent in Mandarin, English, and Spanish, I value opportunities that combine analytical thinking with collaboration, adaptability, and continuous learning.

Data Analyst / BI Analyst / Project Manager

  • China Phone: +86 18513704003
  • US Phone: +1 (910)393-5475
  • City: Beijing, China
  • Degree: Master of Data Science (In Progress)
  • Email: shuang.li.analytics@gmail.com
  • Freelance: Available

Data analyst and business intelligence professional with experience in analytics, ETL workflows, dashboard development, and research support across logistics, transportation, and sustainability sectors. Currently pursuing a Master’s in Data Science at Illinois Institute of Technology, with hands-on experience in SQL, Python, R, Tableau, and Power BI.

Experienced in data cleaning, visualization, reporting automation, and cross-functional collaboration, with a growing focus on analytics-driven operations and project execution. Passionate about transforming complex datasets into clear, actionable insights that support strategic decision-making.

Skills

Spreadsheets (Excel and Google Sheets) 100%
Python and R 85%
Relational databases and SQL 80%
Project Coordination And Management 90%
Data visualization (PowerBI and Tableau) 90%
Critical Thinking and Analytical Skills 80%
Pattern Recognition 75%
Stakeholder Communication 85%

Resume

Data analyst and BI professional with experience in analytics, dashboard development, ETL workflows, and cross-functional project coordination. Currently pursuing a Master’s in Data Science at Illinois Institute of Technology with interests in operations, sustainability, and data-driven decision-making.

Education

Illinois Institute of Technology

Master of Data Science (In Progress)

Expected Graduation: 2026

Illinois Institute of Technology, IL, USA

Graduate-level coursework in SQL, statistical modeling, machine learning, data visualization, and big data technologies. Curriculum emphasizes applied analytics, including relational databases, linear regression, deep learning, and time series analysis.

Google Business Intelligence Badge

Google Business Intelligence Professional Certificate

2025

Coursera, Remote

Completed Google’s Business Intelligence Professional Certificate, acquiring advanced skills in data modeling, ETL processes, and dashboard creation using SQL, BigQuery, and Tableau. Developed practical BI solutions through real-world projects, enhancing stakeholder communication and data-driven decision-making abilities.

Google Data Analytics Badge

Google Data Analytics Professional Certificate

2024 - 2025

Coursera, Remote

Completed the Google Data Analytics Professional Certificate, gaining hands-on experience in data cleaning, analysis, and visualization using tools such as spreadsheets, SQL, R, and Tableau. Developed a comprehensive understanding of data analytics processes and completed a capstone project to showcase practical analytical skills.

Capital Normal University

Bachelor of Arts & Public Administration

2007 - 2012

Capital Normal University, Beijing, China

Allegheny College

Exchange Study & Political Science

2009 - 2010

Allegheny College, PA, USA

Universidad de Buenos Aires

Language Certification & Spanish

2018 - 2021

Universidad de Buenos Aires, Buenos Aires, Argentina

Instituto Tecnológico de Buenos Aires

Non-Degree Study & Fundamentals of Engineering

2022 - 2022

Instituto Tecnológico de Buenos Aires, Buenos Aires, Argentina

Professional Experience

Heavy-Duty Vehicle Project Data Analyst Intern

2025 - Present

International Council on Clean Transportation (ICCT), Beijing, China

  • Built end-to-end ETL pipelines in Python and R to process multi-year heavy-duty vehicle datasets from ingestion and cleaning through analysis and report-ready output generation.
  • Standardized heterogeneous raw sources by harmonizing schemas, vehicle classifications, powertrain labels, OEM mappings, ZE flags, diesel filters, and regulatory weight-class rules.
  • Produced analysis-ready datasets and visual outputs for ZE MHDV market monitoring, diesel fuel-consumption trends, global market tracking, and ICCT research publications.
  • Contributed to analysis and data visualization for multiple publications, developing policy-relevant charts on sales, electrification, fuel consumption, emissions, and regulatory trends.
  • Validated outputs against source files, legacy reports, and benchmark figures; documented pipeline logic, QA steps, schemas, and handover materials.

Data Analyst Intern

2025 - 2025

State Post Bureau Development and Research Center, Beijing, China

  • Assisted with data collection, cleaning, and preprocessing of national postal and express delivery datasets.
  • Built Excel pivot tables and dashboards for regional volume comparisons and growth trends.
  • Supported regular reporting and analysis of delivery performance metrics and policy impact evaluations.
  • Collaborated with research staff to visualize delivery time distributions and logistic network insights.
  • Utilized SQL and Python (pandas, matplotlib) to automate data processing and support internal research reports.

Data Analyst & BI Analyst

2024 - Present

Freelance, Remote

  • Cleaned, validated, transformed, and maintained multi-source datasets for analysis-ready reporting.
  • Analyzed survey results, KPIs, and business performance data using SQL, Python, and advanced spreadsheets.
  • Built dashboards and visual reports in Excel, Google Sheets, Tableau, and Power BI to support client decisions.
  • Designed ETL workflows and automated recurring tasks with Google Apps Script.
  • Delivered reports, visual decks, and actionable insights to identify trends and improve performance.

Additional Professional Experience

International Family Operations Management

2014 - 2024

Self-Managed, USA, Argentina, Brazil

Managed complex international household logistics, relocations, scheduling, budgeting, and multilingual coordination across multiple countries while supporting family operations and community initiatives.

Project Coordinator

2012 - 2014

CRCC Asia, Beijing, China

Coordinated international internship programs, cross-cultural events, and stakeholder logistics for global participants and local partners.

Earlier Roles

Account Executive — Score Advertising

Administration Manager, Part-Time — Frogo New Media

Project Coordinator — China Entrepreneurs

Portfolio

Data analysis and business intelligence projects.

  • All
  • Data Analytics
  • Business Intelligence
  • Data Storytelling

Google Data Analytics Certificate Capstone Study

BellaBeat - How Can a Wellness Technology Company Play It Smart?

Google Business Intelligence Certificate Capstone Project

Cyclistic - New York City Bike Share Business Intelligence Dashboards

Statistical Learning Final Project

China Real Estate Demand Prediction

Bayesian Inference Project

Students Performance Analysis Report

Hierarchical Normal Model - Gibbs Sampling Project

Bayesian Analysis of U.S. Support for Ukraine Aid

Bayesian Computational Statistics Final Project

Bayesian Analysis of Renewable Energy and Weather Conditions

Time Series Data Analysis Report

Time Series Data Analysis of UK Gas Consumption

Core Competencies

Data Cleaning

Organize, structure, and prepare raw data by identifying errors, removing duplicates, handling missing values, and ensuring consistency—laying a solid foundation for accurate analysis.

Data Analysis

Explore datasets to uncover trends, patterns, and insights using tools like spreadsheets, SQL, and R—helping inform decision-making with data-driven evidence.

Data Visualization

Transform complex data into clear, engaging visuals using Excel, Tableau, or PowerBI — making insights easy to understand through charts, dashboards, and visual storytelling.

Testimonials

Shuang demonstrated exceptional technical skill, professionalism, and teamwork throughout our logistics data analysis project. She quickly grasped complex business logic, delivered accurate and insightful reports, and maintained proactive, reliable communication from start to finish.

Peng Bin

Logistics Data Project Client

Shuang approaches analysis with deep thought and integrity. She carefully explored our survey data, offered systematic analytical ideas, and ensured that every insight remained true to the data’s authenticity and accuracy.

Tian Yuan

Survey Analysis Project Client

Shuang demonstrates excellent analytics kills with strong business understanding. She is easy to communicate with, proactive, and consistently delivers high-quality outcomes.

William Leung

Event Data Management Project Client

Contact

If you're interested in working together or have a project in mind, feel free to get in touch!

Address

Chaoyang District, Beijing, China

WeChat

+86 18513704003

WhatsApp

+1 (910) 393-5475

Email

shuang.li.analytics@gmail.com