Ziyuan Huang

Technical Proficiency:

• Proficient in Python for data analysis (Pandas, NumPy, SciPy) and SQL for database querying and manipulation
• Experienced with Tableau and Matplotlib/Seaborn to design clear, actionable visualizations for academic projects
• Applied statistical methods (hypothesis testing, regression) in coursework to derive insights from real-world datasets
• Familiar with Git for version control and Jupyter Notebooks for iterative data exploration

Data Management & Problem-Solving:

• Skilled in data cleaning and preprocessing to resolve inconsistencies (eg, handled missing values in a retail sales analysis project)
• Developed ETL workflows in Python for converting raw datasets into structured formats, improving analysis efficiency by 30%
• Adept at identifying patterns and anomalies in datasets, contributing to data-driven solutions in class competitions

Communication & Collaboration:

• Delivered data-driven presentations to academic teams, translating technical findings into non-technical insights
• Collaborated in cross-functional student teams using Agile methodologies to complete a semester-long predictive modeling project

Adaptability & Passion:

• Self-taught Power BI to enhance visualization skills beyond coursework, creating dynamic dashboards for volunteer projects

Relevant Coursework:

• PROGRAMMING FOR INFORMATICS
• ELEMENTS OF SOFTWARE DESIGN
• FOUNDATIONS OF DATA ANALYSIS
• INTRO HUMAN-CENTERED DATA SCI
• (GPA383)