CHANGFAN LI
Oakland
Summary
UC Berkeley undergraduate student with experience in policy-oriented research, data analysis, and research writing. Skilled in conducting literature reviews, analyzing quantitative and qualitative data using Excel, and translating complex findings into clear reports and presentations for non-technical audiences. Past experience includes supporting policy-relevant market and regulatory research through data collection, visualization, and cross-regional analysis. Particularly interested in applied research related to energy efficiency, sustainability, and evidence-based public policy.
Overview
3
3
years of professional experience
Work History
Office Intern
China Mobile Group Device Co., Ltd. Henan Branch
Zhengzhou
07.2025 - 08.2025
- Collected and analyzed quarterly mobile device sales in Henan province and revenue data using Excel
- Created data visualizations to identify trends relevant to pricing, distribution, and market performance
- Synthesized quantitative findings into internal reports and presentation materials to support management decision-making
- Collected and organized city-level retail sales data across Henan Province for major mobile phone brands (including Vivo, Xiaomi, Honor, and Huawei) to support comparative market analysis
Intern
International Civil Aviation Organization
06.2023 - 07.2023
- Conducted background research on international civil aviation standards and recommended practices (SARPs)
- Reviewed policy and technical materials related to aviation operations, safety, and regulatory frameworks
- Summarized key policy concepts and meeting discussions into written materials and presentation slides
- Supported internal coordination by assisting with meeting preparation and documentation
- Gained exposure to international discussions on aviation sustainability and emissions-related policy frameworks
Co-Founder
Africause Project
05.2023 - 06.2023
- Co-organized a community-based fundraising initiative that raised approximately $940 to support education-related needs for 20 low-income families in The Gambia
- Assisted with planning and coordination of resource allocation, including monthly food support distribution
- Tracked basic project metrics, including funds raised, number of beneficiary households, and distribution timelines
- Documented project activities and outcomes to support internal reporting and future program planningDocumented project activities and outcomes to support internal reporting and future program planning
Office Administrative Assistant
Henan Youth Development Foundation
Zhengzhou
06.2022 - 07.2022
- Supported the implementation of education assistance programs aimed at improving access to schooling for low-income and rural students
- Conducted site visits to rural schools to assess facilities, student needs, and program eligibility
- Assisted in organizing and tracking program resources, including educational supplies and sports equipment valued at approximately 20,000 RMB
- Documented basic program data, including beneficiary counts, donation categories, and distribution timelines, to support internal reporting and resource allocation planning
Education
Bachelor of Arts - Political Economy
University of California, Berkeley
Berkeley, CA05.2028
Skills
Policy research and literature review
Data analysis (Excel)
Quantitative and qualitative data synthesis
Data visualization and trend analysis
Research report and policy brief writing
Market and policy trend analysis
Evidence-based analysis and recommendations
Written communication for non-technical audiences
Languages
English
Full Professional
Chinese (Mandarin)
Native/ Bilingual
Timeline
Office Intern
China Mobile Group Device Co., Ltd. Henan Branch
07.2025 - 08.2025
Intern
International Civil Aviation Organization
06.2023 - 07.2023
Co-Founder
Africause Project
05.2023 - 06.2023
Office Administrative Assistant
Henan Youth Development Foundation
06.2022 - 07.2022
Bachelor of Arts - Political Economy
University of California, Berkeley