Los Angeles Data Analyst
Resume:
***********@*****.*** • 510-***-****
FENGNING(HENRY) LIU
UCLA Undergraduate Student
EDUCATION
ASSOCIATED IN ART Aug 2022 - May 2024
Santa Barbara City College Santa Barbara
Graduated with Honors, GPA: 3.93 President’s Honor Roll (multiple terms) BACHELOR OF ARTS IN INTERNATIONAL DEVELOPMENT STUDIES Sep 2024 - Sep 2025 University of California-Los Angeles Los Angeles
GPA: 3.71/4.0
PROFESSIONAL EXPERIENCE
PROGRAM & DATA ASSISTANT INTERN May 2022 - Aug 2022 red cross society of china Beijing
PRODUCT/DATA ANALYST INTERN Jan 2024 - Jun 2024
ByteDance Beijing
RESEARCH ASSISTANT INTERN Jun 2024 - Sep 2024
Asian Development Bank, China Resident Mission Beijing PROJECT DEVELOPMENT – ECO-ANXIETY EDUCATIONAL WEBSITE Mar 2025 - Jun 2025 GLB HLT 130 Final Project Los Angeles
LEADERSHIP AND ACTIVITIES
MEMBER Sep 2024 - Sep 2025
UCLA Model United Nations Los Angeles
VOLUNTEER COORDINATOR May 2022 - Present
Beijing Fangshan District Pet Stray Rescue Station Beijing SKILLS
Python (pandas, NumPy), R, SQL, Stata, Excel (Pivot), Tableau. LANGUAGES
English, Mandarin Chinese, Cantonese Chinese.
Built a simple data dictionary and cleaned hundreds of program/activity records (de-duplication, standardized labels) using Excel and OpenRefine.
Produced weekly pivot-table dashboards (participation, outreach coverage, content trends) and circulated concise one-page summaries to program leads.
Designed and distributed an intake form; merged responses with legacy sheets for monthly rollups. Coordinated 100+ volunteer shift logs; reconciled sign-in sheets, flagged inconsistencies to site coordinators. Organized digital archives with standard naming/versioning, enabling quick retrieval during audits and reducing review time by ~70%. Assisted the product analytics team in cleaning and analyzing tens of thousands of user interaction records from Douyin (Chinese TikTok); focused on engagement metrics (likes, comments, shares). Contributed to A/B testing with samples of tens of thousands of users, summarizing retention and watch-time differences. Built/maintained 10+ weekly dashboards in Excel and SQL to monitor DAU, session duration, and feature adoption. Prepared slide decks and visualizations for cross-functional meetings, informing product managers on content performance trends. Collected and organized provincial statistical yearbooks and government survey datasets on labor markets, education, and social protection.
Conducted data cleaning and descriptive analysis (Excel, Python) on aa survey dataset (~15–25k observations) covering youth employment, wages, and education levels.
Produced 15+ charts, summary tables, and visuals for internal briefs on economic and skills development. Reviewed 30+ Chinese/English policy reports and academic papers; prepared annotations and summary notes for senior economists. Supported validation of two draft ADB working papers by cross-checking numerical consistency and policy indicators. Co-developed an educational website analyzing eco-anxiety among California youth through four dimensions: political, bodily, educational, and economic.
Authored and designed the Educational and Economic sections, integrating public health data, policy reports, and structural violence theory.
Synthesized 15+ academic and policy sources to frame eco-anxiety as a structural public health challenge, rather than an individual disorder.
Participated in weekly simulations on climate governance, development, and global trade. Prepared background research and short position notes to support committee discussions. Collaborated with 15+ peers to draft policy memos and debate strategies; strengthened teamwork and public-speaking skills. Contributed 150+ cumulative hours since 2022 (on-site during school breaks; remote coordination while studying in the U.S.). Supported operations by organizing donations, maintaining adoption records, and managing outreach posts on social media. Helped run 10+ community outreach initiatives to raise awareness of adoption and animal welfare.
Contact this candidate