Zijing(Selena) Qian

Seattle

Summary

Informatics student at the University of Washington with experience in user research, product requirements, data analysis, and cross-functional collaboration. Skilled in SQL, Excel, Figma, and front-end basics, with hands-on experience supporting CRM optimization and product design projects.

Overview

year of professional experience

Work History

Data & Operations Analyst Intern

Data and Operations Analyst Intern, Shaanxi Borui

06.2025 - 09.2025

Used SQL to optimize data table structures and develop core metric logic, streamlining data report generation.
Conducted user interviews and business research with 10+ users to identify key pain points in the CRM system; documented 15 core functional requirements to support product solution design.
Researched cross-functional workflows across content, sales, and operations teams; identified communication gaps and standardized processes, enhancing collaboration efficiency by 20%.
Analyzed user behavior data and conversion paths to pinpoint key drop-off points; proposed optimization suggestions to inform product iteration.

Finance Project Research Intern

Hengniu Capital

06.2024 - 08.2024

Researched industry and company trends, analyzed market changes, user needs, and business models, enhancing project evaluation and strategy development.
Collected and organized company, industry, and competitor information; simplified complex financial data into clear presentation materials for stakeholder understanding.
Participated in simulated investment projects by combining financial data, industry trends, and market insights to develop preliminary investment analysis conclusions.
Collaborated with team members to deliver project research presentations, improving structured communication and business analysis skills.

Education

Undergraduate - Informatics

University of Washington

Seattle, WA

06-2027

Skills

Product & Design: Figma, Canva, PowerPoint, User Research, Prototyping
Data & Analytics: SQL, Excel, PivotTables, VLOOKUP, Tableau, R
Technical Skills: HTML, CSS, JavaScript, Python

Data analysis
SQL database management
Process improvement
Data visualization

Websites

https://linkedin.com/in/zijing-qian-5b6696368

Hobbies and Interests

Hiking, Ballet, Guzheng, Konghou, Vlog Filming & Video Editing

Projects

Party Game Information Platform | Product Lead & Front-End Developer
Sep 2025 – May 2026

Designed product structure and core features, including game filtering, category browsing, and detail pages, to help UW students find party game information more efficiently.
Built information architecture and user flows to improve the search experience and reduce friction in the user journey.
Optimized page layout and interaction logic based on user scenarios, improving the overall browsing experience.
Developed core interface components using HTML and CSS, collaborating on the front-end implementation of the platform.

Chinese Entrepreneur Network, UW Chapter | Project Lead
Oct 2023 – Apr 2026

Designed event themes and operation strategies based on the needs of UW students, attracting 1,000+ total participants.
Managed social media promotion and community operations, improving user engagement through content optimization and posting strategy.
Analyzed registration and attendance data to improve event conversion, user experience, and future planning.
Coordinated content, marketing, and external resources to ensure smooth project execution across teams.

Portfolio

https://uw-team-info380.atlassian.net/jira/for-you?continue=https%3A%2F%2Fuw-team-info380.atlassian.net%2Fwelcome%2Fsoftware%3FprojectId%3D10002, https://miro.com/app/board/uXjVG96UvzA=/?share_link_id=858891033628, https://miro.com/welcomeonboard/MEJ1L1V2V2JjSzFXalZvb1pRSkV5RlBldXgyY3VhSGdNaEVrV0ozWE9EZnhFN1hoMXRpSWtaT0JEaDFjN1B4aWU0aENSdHpiK3pOOVFNekt2UzRFalNQSThZdGNldXJzdGNjKzVDN3JOcURZbEdURW5KTHpSazlTM1RkaTE4WW5BS2NFMDFkcUNFSnM0d3FEN050ekl3PT0hdjE=?share_link_id=690910375360

Timeline