Data Science & Business Administration student at Northeastern University
Hi I’m Amy! I’m a Data Science & Business Administration student at Northeastern University. This portfolio showcases my selected projects, skills, and ways to connect with me. I have experiences programming with Python, R, and SQL. Alongside these technical skills, I also had previous experiences with design projects.
Timeline: July 2025 - August 2025
Location: Northeastern University, Boston, MA Tech. Stack: R, SQL, MySQL (Aiven)
Designed and implemented a normalized relational schema in MySQL, loading 10,000 rows from CSV files into an Aiven cloud-hosted instance to enable efficient management and querying of aircraft incident data.
Developed SQL queries for data analysis and utilized R for automated reporting, improving data accessibility and enabling
detailed insights into aircraft incident trends.
Timeline: March 2025 - April 2025
Location: Northeastern University, Boston, MA Tech. Stack: Python, Pandas, NumPy, Plotly, Dash, JSO
Analyzed statewide university data across tuition, educational, academic, social, facilities, career, and diversity metrics to identify
trends and insights in higher education.
Cleaned and preprocessed 3,697 rows of data using Python for accuracy and consistency.
Built an interactive scatter plot of 1,299 cleaned data points using Plotly, Pandas, NumPy, and Dash; loaded data via JSON,
enabling filtering by university and comparison of key statistics visualized via radar charts.
Timeline: November 2024 - December 2024
Location: Northeastern University, Boston, MA Tech. Stack: Python, Pandas, NumPy, Plotly, Dash, JSO
Developed Python analysis functions to examine a cleaned dataset of 2,000+ video games across North America, Europe, and
Japan, identifying regional trends and patterns in sales and genre preferences.
Provided actionable insights on how cultural and geographic factors impact genre preferences, emphasizing the need for
regional market segmentation to optimize product sales and marketing strategies for global gaming audiences.