Cayden Shim

United States

@cayshim

Badges

Problem Solving
CPP
Python

Certifications

Work Experience

  • Data Analyst Research Intern

    Epistemic Analytics Lab – Wisconsin Center for Education Research•  October 2024 - Present•  Madison, WI

    Deploying Quantitative Ethnography methods with network modeling to process, code and analyze qualitative data. Assisting researchers in preparing, analyzing, and presenting large quantitative datasets using R, Excel, and Python. Coordinating outreach, supporting webinars and workshops, and collaborating with internal teams and external partners.

  • Real Estate Investment Analyst Intern

    Madison Private Equity•  October 2023 - June 2024•  Madison, WI

    Conducted in-depth analysis of 2 past clients in the agricultural real estate sector, using financial data to gain hands-on experience with DCF valuations, deriving potential investment targets based on precedent transactions analysis. Achieved 83% engagement on monthly newsletter by creating Excel database of 200 potential clients to distribute via email. Increased readability of existing FP&A Excel templates by 20% for clients through updating formulas and aesthetic.

  • Innovation & Value Analyst Intern

    Rockwell Automation•  June 2023 - August 2023•  Milwaukee, WI

    Conducted research of automobile manufacturers, analyzing key trends in manufacturing automation via financial statement analysis, Capital IQ research reports, proxy statements, and comparable company analysis. Utilized Qualtrics to create a digital maturity model, integrating KPIs to augment the sales process, resulting in a projected $4MM increase in sales over the next fiscal year based on an estimated 10% increase in client retention. Analyzed 10 potential clients’ pain-points via manufacturing downtime, labor utilization, and financial data from 10k and investor reports, and presented findings through PowerPoint slide-decks and Excel forecasting models.

Education

  • University of Wisconsin-Madison

    Finance, Bachelor of Business Administration•  September 2022 - Present

    Majors: Finance, Data Science | Minor: Mathematics

Skills

Capital IQ
FactSet
Excel
Python
R
SQL