Education
Aug 2024 - Dec 2024
COOP Careers
Data Analytics Fellow
-
Developed data analytics skills by completing 200 hours of workshops, assignments, and projects in Excel, Tableau, and SQL which were led by 4 industry professionals in a cohort of 18 peers
-
Utilized Excel functions such as Vlookups, sorting, and filtering to clean a 2018 SF Crime dataset, which contained over 150,000 rows of data points, and used Tableau to find insights and create visualizations to provide data-driven recommendations to a mock SFPD
Sep 2018 - Sep 2022
University of California, Santa Barbara
B.S. in Statistics and Data Science
Relevant Coursework: Statistical Data Science, Introduction to Statistical Machine Learning, Regression Analysis, Advanced Statistical Models, Introduction to Bayesian Data Analysis, SAS Base Programming Computer Science - Problem Solving I & II
Projects
Nov 2024 - Dec 2024
Marketing Campaign Capstone Project
@ COOP (Excel, Tableau)
-
Worked with a team of four as an inventory analysis and tasked with analyzing our client’s marketing data to see which exchanges and websites used by the client performed the best to optimize usage
-
Cleaned over 10,000 rows of raw data in Excel to filter out missing values and unwanted columns
-
Compared the graphs of different performance metrics, such as CPA, CVR, and CPM, on Tableau across multiple exchanges and websites to recommend the top performers that stays under the client’s goal of under $400 CPA and suggested a rate of $3200 for client’s to spend on websites
Jun 2023 - Jul 2023
Regression Analysis of Financial Data
@ M&N Sarchet Inc (Excel)
-
Gathered financial information of different acquired companies, such as their EBIT/EBITDA, MVIC, and total revenue that will be used in Excel’s regression analysis tool
-
Performed regression analysis to look for relationships between MVIC and multiple financial measures
-
Determined the most accurate model for the client to use for their project by comparing R-squared and regressions output values
Work
Experience
May 2024 - Aug 2024
Consulting Intern
@ Equity Consulting
-
Created 2 Excel dashboards weekly using financial data from the California Community College and highlighted the differences between their budgeting and expenditures
-
Presented findings from SFCC adopting budget and audit report from 2022-2023 to an industry panel showing differences between the adopted budget and the actual spendings of the college to improve plans on future budget spending
Jun 2020 - Sep 2020
Customer Support
@ Mattson Resources
-
Guided clients under unemployment due to COVID-19 on EDD website usage and troubleshooting issues on receiving unemployment benefits using EDD software
-
Handled 50+ user interactions per day, giving detailed, personalized, friendly, and polite service to ensure customer retention and satisfaction
-
Produced 10+ reports daily on any updates made to a client’s unemployment claim in the EDD database for technicians resulting in more efficient clearances on their claims
Skills
& Expertise
-
Programming Languages: Python, R, SQL, SAS, C++
-
Libraries: NumPy, Pandas, Matplotlib, Seaborn, BeautifulSoup4, NLTK, SciKit-Learn, Dplyr, Ggplot2, Tidyverse
-
Analytics Tools: Tableau, Excel