Financial Analyst Intern

Xinlan(Amy) Lin

San Diego, CA 858-***-**** *************@*****.*** www.linkedin.com/in/amy-lin-6a1669204 EDUCATION

University of California - San Diego San Diego, CA Bachelor of Science Major: Joint Major Mathematics and Economics Minor: Finance 09.2020 - 06.2024

● GPA: 3.72/4.0

● Provost Honors for 7 Quarters

PROFESSIONAL EXPERIENCE

Fortune Cookie Technologies Inc.Hayward, CA

Financial Product Intern 11.2024 - Present

● Collaborated with cross-functional teams to assist in the design and launch of 2 new financial products

● Conducting competitor benchmarking and market analysis that ensured 100% alignment with current market demand and drove early adoption success.

● Analyzed datasets with 5,000+ records using Excel (pivot tables) and SQL (complex queries) to uncover key business insights, contributing to a 10% increase in business growth strategies based on data-driven decision-making.

● Developed 2 robust calculation models encompassing 4 key financial categories, 3 user scenarios, and over 20 custom equations, enhancing product accuracy.

Zhejiang Geely Holding Group Zhejiang, China

Financial Analyst Intern 07.2023 - 10.2023

● Coordinated monthly budget assessment meetings to streamline the report process with cross-functional teams and increased 8% operational efficiency

● Assisted in assorting data by using Excel functions like VLOOKUP and INDEX to improve documentation accuracy, resulting in 22% reduction in errors in fiscal year reports

● Performed comprehensive data analysis and executed data processing automation by using Jupyter, facilitated the decision-making and strategic planning process by 16% for the Management Team DIANins Global Anaheim, CA

Marketing Intern Jun. 2022 - Aug. 2022

● Conducted a market research price analysis project using SQL, achieving a more reasonable price and increasing the total sale by 23.8%

● Coordinated and maintained an online seminar involving 100+ participants

● Organized 5+ media group chats with 200+ members, driving a 26% increase in engagement rate QianXiang Real Estate Company Henan, China

Financial Officer Assistant Aug. 2021 - Sep. 2021

● Supported organizational duties and 10% of input for tactical decision-making mainly in the board meetings

● Assisted in auditing invoices and employee expense reimbursements, decreasing average process time by 45%

● Responsible for making and following several bank balances, account receivables, and inventories PROJECTS

NYC Housing Price Prediction Analyzing Financial Data, UCSD Data cleaner, Model developer 2024

● After cleaning data and removing outliers, developed a linear regression model to predict NYC housing prices using over 2.2M data points with an 80.91% model accuracy.

● Demonstrated the importance of geographic variables with accuracy dropping to 45.73% when zip code was excluded, thus highlighting location as a critical factor in housing price prediction. Starbucks Corp. Stock Pitch Financial Statement Analysis, UCSD SWOT and financial analyzer, Presenter

● Conducted a detailed DCF valuation estimating Starbucks' intrinsic value and recommended purchase based on long-term appreciation potential and stable dividend profile.

● Analyzed financial performance from 2021–2023, highlighting improved profitability and solvency with increasing ROE and decreasing debt-to-equity ratio, supported by global expansion and digital sales growth. SKILLS

Programming Languages: Java, Python, SQL, Matlab

Softwares: Microsoft Office Suite, Quickbooks, Google Workspace, Jupyter, Stata SE, Matlab

Contact this candidate