Kyan Hsu Portfolio
Exploring the intersection of business and AI through innovative projects and skills development.
My Projects
Explore my work at the intersection of business and AI.
Interactive Map
My code sets up a Dash web application for visualizing the relationship between household income, living expenses, job salaries, and state tax rates across U.S. states. It reads data from CSV files. The app allows users to select a career and view a choropleth map and bar charts that show the income-to-expenses ratio by state, making it easy to compare affordability. Users can interact with the map to see detailed state information, and all visualizations update dynamically based on user input.
Stock Analysis Dashboard
Detects anomalies, makes predictions, and calculates risk factor.
Python-based dashboard application designed for real-time visualization of stock market trends, anomaly detection using machine learning algorithms, and predicting future stock prices based on technical analysis indicators and linear regression models.
Credit Score
This Python code performs several tasks related to credit score prediction. It also uses data visualization to display data in an easy-to-understand format.
*Instead of credit score, the program can be trained on almost anything, given the data in a csv format. You can use this to predict products customers are likely to like, trends of a certain demographic, and how someone compares to others.
Financial Planner
This application includes various financial planning tools to help users manage their finances, plan for retirement, track expenses, and estimate taxes. It leverages Pandas for data handling, Plotly for interactive visualizations, and Matplotlib for additional plotting options.
*The original code utilized Streamlit, but I converted it to Dash to better suit Google Colab.
Education
Santa Clara University
Bachelor of Science in Commerce, 2024-2028
Major: Accounting Information Systems (AIS) | Minor: Business Analytics
Experience
Social Media and Marketing Intern
Faith and Community Empowerment (FACE)
May 2023 - August 2023
Utilized tools such as Excel sheets and Constant contact to streamline communication and outreach efforts.
Reached out to collaborate with 100+ nonprofit organizations.
Promoted financial aid programs for underserved communities.
Designed social media posts and managed the media calendar to optimize outreach strategies.
Marketing Data Analyst Intern
SCU Alumni Network
May 2025 - Present
Analyzed engagement metrics from Sprout Social, Switchboard, BBIS, and Clara to support alumni outreach strategies.
Utilized Excel and analytical tools to clean, manipulate, and interpret data, tracking trends to inform program development.
Collaborated with 10+ Alumni Directors to translate data insights into recommendations, creating compelling deliverables.
Cashier and Barista
Macu Tea
May 2024 - September 2024
Effectively handled customer needs and resolved complaints, maintaining high level of customer satisfaction.
Prepared a variety of drinks, adhering to precise recipes.
Processed all transactions, ensuring a balanced register at the end of each shift.
Pro League Racer
Amazon Web Service (AWS) DeepRacer
March 2022 - November 2024
Created a local server to run virtual simulations using Linux.
Achieved consistent top 3% rankings in North America in 2022 and 2023.
Coded a reward function and utilized reinforcement learning to optimize racing performance.
Certification
Google Data Analytics Professional Certificate
https://coursera.org/share/67eb02fdc86e4f521a692349dc766a3c
DS102X: Machine Learning for Data Science and Analytics
https://courses.edx.org/certificates/f612e76494594bc79c3d344ee52affa9
Python Basics for Data Science Certificate
https://courses.edx.org/certificates/e15e59aaef3a4432b1fc29f8e5b92a33
The Language and Tools of Financial Analysis
https://www.coursera.org/account/accomplishments/certificate/E45MN4W7M2VD
Investment Risk Management Coursera Project Network
https://www.coursera.org/account/accomplishments/certificate/YJYPAWZD5TW7
Resume
Languages
English
Mandarin
Cantonese
Full Professional Proficiency
Professional Working Proficiency
Elementary Proficiency
Equity Research Analyst
Santa Clara Investment Fund
November 2024 - Present
Conducted company screening and research: industry trend analysis, internal benchmarking, and valuation modeling.
Led quarterly healthcare reports in a 6-figure AUM portfolio, allocating assets through industry and regulatory analysis.
Pitched and secured capital allocation for 3 equity investments, emphasizing strong financials and growth potential