Shuyan Cao

Built automated dashboards using Streamlit and Google Sheets API to track HR metrics, enabling real-time insights and reducing manual tracking and inputting efforts by 70%. Developed and maintained databases supporting ad-hoc reporting and HR analytics, leading to improved cross-department visibility and cross-functional collaboration.

Analyzed over 10,000 rows of operational and pricing data using Python and Power BI, fixing errors and surfacing cost-saving opportunities for freight contract negotiations. Reconciled A/R and A/P data across global shipments, identifying recurring mismatches and improving billing accuracy by 15%. Developed SOPs and supported process automation projects, streamlining reporting cycles and enhancing

Analyzed consumer-facing financial products, specifically 529 plans, and their operational risks to support fintech product design and investor decision-making. Led investor presentations for over 50 internal and external stakeholders, aligning cross-functional teams on strategic priorities.

Analyzed teashop and hotel industry and company data, including Hey Tea and Ji Hotel, to evaluate business trends and performance indicators such as RevPAR and store expansion strategy. Synthesized quantitative and qualitative insights to support strategic investment decisions, using Python to streamline KPI tracking and financial benchmarking across leading brands. Collaborated with analysts to t

Conducted market research across 8 industries, providing strategic insights to support technology platform transformations and ERP implementations. Supported requirements gathering and systems gap analysis for ERP implementation strategy in pitch books. Led project meetings, assigned tasks, and ensured timely delivery of consulting engagements.

Grade: $10,000

Relevant Courses: Data Science for Finance (SQL & Python), Machine Learning, Risk Management. Honors: Rady Fellowship ($10,000).