Resume

Program Data Analyst - Marketing

Sept 2024 - Dec 2024

Conducted a detailed analysis of 100K+ sales transactions for ecommerce company, Quantum Supply, using Excel and SQL. Identifying key trends in product performance, regional sales, and loyalty program metrics for the marketing and finance teams.
Developed strategic recommendations including creating marketing campaigns to retarget one-time purchasing customers from 2020 to 2021, increasing number of complementary offerings to top selling products, launching limited-time discounted products to increase sales, and investigating international growth opportunities in APAC and LATAM regions.
Designed a dynamic Tableau dashboard and presentation to report on essential campaign marketing metrics including click-through rates, signup rates, and average claim amounts for Healthcare company, Row Health. Included data visualizations for marketing, claims, and signup metrics for cross-functional accessibility.
Provided actionable insights into campaign categories suggesting to reallocate $19K of ad spend from low to high performing campaigns, retargeting 40K users to capture a projected 1,200 new signups, and increasing conversion rates in high-potential states to 20%

Bachelor of Science: Finance

San José State University

Excel
SQL
Tableau
PowerBI
GitHub Google BigQuery
Google Firebase
Cursor

Finance Teaching Assistant

Jan 2023 - May 2023

Ensured data accuracy for 100+ students guiding them to the correct solution by conducting data validation in Excel, verifying key financial metrics such as Weighted Average Cost of Capital (WACC), Internal Rate of Return, and Net Present Value.
Created a comprehensive grading Excel dashboard to show student real-time performance insights, showing class averages, minimums, and maximums per assignment, saving faculty several hours every week to focus on student 1 on 1's and research activities.
Improved feedback loops to faculty and students by achieving a 100% on-time completion rate for all graded assignments, identifying key areas for faculty to address in the classroom.
Increased student comprehension by translating complex financial concepts into easily understandable terms that allowed students to effectively apply them in projects and exams.

Strategic Business Analyst

Jan 2023 - May 2023

Led a team of 4 students in conducting a thorough analysis of Spotify Inc. to assess its investment viability, culminating in a well founded recommendation to potential investors
Utilizing Spotify’s 20-F, annual reports, and investor calls, conducted extensive research on their business model, financial health, competitive landscape, and innovations to gain insights into its operations
Performed data analysis on Spotify’s financial statements to identify patterns in revenues, cost of goods sold, net income, and free cash flow to project future value creation for the company
Coordinated our team in producing a comprehensive 20-page report and presentation that showcases Spotify's strategic business, our key findings, and investment recommendations

Financial Data Analyst

Aug 2022 - Dec 2022

Developed a data-driven sell recommendation for students and professor, highlighting a 35.5% overvaluation of the Protolabs Inc.’s enterprise value.
Projected a 16% decline in return on invested capital (ROIC) over the next five years, underscoring potential challenges in profitability and reinforcing the sell recommendation.
Forecasted a 5.7% annual revenue growth for Protolabs Inc., utilizing historical data from 2012-2022 to facilitate informed long-term financial planning.
Presented key financial findings and metrics to a non-technical audience, showcasing key trends and growth opportunities found during market analysis and due diligence.

Video Editor & Manager

Oct 2021 - Jan 2022

Reduced video production turnaround time to just 2 days for 24 projects over a 3-month period by developing an efficient workflow process for transforming raw videos into polished content.
Achieved seamless project execution and timely content releases, accumulating over 370,000 video views, by effectively coordinating communication between graphic designers and editors
Increased video visibility and viewership by leveraging search engine optimization strategies and keyword research to optimize video titles, descriptions, and tags.