Open to opportunities

Shuyan Cao

@shuyancao

Message

Data-driven analyst specializing in finance and operational automation.

United States

Message

What I'm looking for

I am seeking a role that fosters innovation and collaboration, allowing me to leverage my analytical skills to drive business success.

As a Master of Finance candidate at the University of California San Diego, I have developed a strong foundation in data science and financial analysis. My academic journey has been complemented by hands-on experience in business operations and analytics, where I have successfully built automated dashboards and databases that enhance decision-making and operational efficiency.

In my current role as a Business Operations Automation Analyst at Community Dreams Foundation, I have implemented solutions that reduced manual tracking efforts by 70%, showcasing my ability to leverage technology for impactful results. My previous experiences as an Operation Analyst and Equity Research Analyst have further honed my analytical skills, allowing me to identify cost-saving opportunities and provide strategic insights that drive business growth.

Experience

Work history, roles, and key accomplishments

Current

Business Operations Automation Analyst

Current

Community Dreams Foundation

Dec 2024 - Present (6 months)

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.

Streamlit Google Sheets Database Management Data Analytics Automation

Operation Analyst / Coordinator

OEC Group

Feb 2024 - Dec 2024 (10 months)

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

Python Power BI Data Analysis SOP Development Process Automation

Fintech Product Ops Lead

Longley Capital

Sep 2023 - Present (1 year 9 months)

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.

Fintech Product Operations Risk Analysis Investor Relations Stakeholder Management Financial Products Presentation Skills

Equity Research Analyst Intern

TF Securities

Dec 2020 - Present (4 years 6 months)

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

Financial Modeling Python KPI Tracking Market Data Benchmarking

IT Transition Focus-Management Consulting Intern

Deloitte

Aug 2020 - Present (4 years 10 months)

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.

Market Research ERP Implementation Systems Analysis Project Management Consulting Automation