Data Analyst Science

GOP AROP

315-***-**** ***.****@*****.*** LinkedIn GitHub Blog Site

Data-driven problem solver with intermediate SQL query development and Python-driven process automation expertise. Proven ability to reconcile large, complex healthcare-style datasets, perform root-cause analysis of discrepancies, and deliver accurate regulatory submissions. EDUCATION

St. Lawrence University, Canton, NY

Bachelor of Science in Data Science, Graduated: 12/2024 DATA SCIENCE PROJECTS

Cloud Data Engineering: Cloud Infrastructure Performance & Cost Optimization Analysis

• Developed an automated ETL pipeline using Microsoft Azure Blob Storage, Python, and PostgreSQL to support real-time cloud performance and cost optimization analytics.

• Completed a rigorous data acquisition phase by leveraging the Azure CLI and secure environment variable management in PyCharm, reliably downloading CSV data from Azure Blob Storage.

• Established a scalable foundation for data transformation using Pandas, setting the stage for advanced aggregation and analytics via PostgreSQL.

• Currently advancing the project towards a comprehensive, production-ready solution that aligns with focus on secure, scalable cloud solutions. Interactive Dashboard: NBA Analytics Dashboard in Power BI

• Connected to NBA data sources using Power Query (via CSV), performing data cleaning, transformation, and derived metric calculations.

• Developed dynamic slicers with interconnected panels for season, player, and statistical filters.

• Built custom visualizations including shot charts (scatter overlay on NBA court image with conditional formatting/tooltips) and quadrant analysis charts using DAX reference lines.

• Replicated R/Shiny calculations with DAX to compute averages, proportions, and efficiency ratings, with key stats in summary cards/tables.

Data Visualization Blog Project, A Look Into Freedom, St. Lawrence University, Canton, NY

• Analyzed global trends in personal, civil, and economic freedom using the Human Freedom Index 2023 dataset to identify patterns and regional disparities.

• Utilized R programming to clean, analyze, and visualize data from 165 countries (2000–2021). Created interactive visualizations using ggplot2 and Shiny to explore freedom trends across regions.

• Identified a 15% decline in freedom scores in certain regions, while others showed resilience. Published findings on a data visualization blog, enhancing accessibility and engagement for a broader audience. Predictive Modeling: Time Series Analysis of Economic Indicators

• Predicted future trends in economic indicators (e.g., GDP, unemployment) using historical data to support decision-making processes.

• Developed a time series model in Python using ARIMA and Prophet libraries. Cleaned and preprocessed data to ensure accuracy and created visualizations to communicate findings effectively.

• Achieved a 90% accuracy rate in predicting GDP trends, providing actionable insights for economic planning. Published the analysis on Google Colab for collaborative review.

Machine Learning: Sentiment Analysis on Social Media Data

• Analyzed sentiment trends from social media data to understand public opinion on specific topics.

• Used Python and TensorFlow to build a sentiment analysis model. Preprocessed text data using NLTK and Pandas and trained the model using a neural network architecture.

• Achieved 85% accuracy in sentiment classification, providing valuable insights into public opinion trends. Shared the project on Google Colab for peer review and collaboration.

WORK EXPERIENCE

Student Mail Center Associate, St. Lawrence University, Canton, NY Aug 2022 – May 2024

• Implemented a size-based organizational system for package sorting, which improved retrieval time by 25% and reduced sorting errors, ultimately ensuring a 98% accuracy rate and enhancing mail center efficiency.

• Handled daily processing of 100+ packages, utilizing tracking software for precise check-ins and check-outs, which improved data accuracy and strengthened my organizational and operational skills. University Research Fellowship, Assessing Parity in the NBA, St. Lawrence University

• Evaluated and utilized domain knowledge in the NBA, focusing on team success and talent equality for competitive balance.

• Utilized RStudio for data analysis, including data cleaning, visualization, and scraping from basketball-reference.com.

• Employed standard deviations for win percentage and point differentials to gauge parity trends.

• Investigated how trade deadlines affect parity, revealing a decrease in team equality post-trade deadline CO-CURRICULAR EXPERIENCE

Co-Captain, Onondaga Community College Men's Basketball Team, Syracuse, NY Oct 2021 - Mar 2022

• Devised a set of stretching exercises at the beginning of practices for a team of 15 young men to prevent injuries.

• Led a team of 15 to an extended playoff run, which resulted in finishing in 5th place in the NJCAA DIII National Tournament.

• Cultivated teamwork and resilience environment and received Honorable Mention in the All-League team for my performance, while gaining skills in team management and strategy that I continue to apply in collaborative environments. Volunteer Tutor, Reading Partners NYC, Brooklyn, NY Oct 2024 – Present

• Provided tailored reading support to a 3rd-grade student reading below grade level, using engaging techniques to improve comprehension and confidence.

• I gained insight into personalized learning methods and enhanced my communication skills, fostering a supportive learning environment that helped the student progress.

SKILLS

• Programming Languages: Python

(Automation), Java, R, SQL

• Microsoft Suite Experience: Office, Word,

PowerPoint

• TEFL Certification: (Ongoing)

• Data Analysis: R (including ggplot, dplyr),

Python (including Pandas), RStudio, Tableau,

Data integrity monitoring

• Machine Learning Libraries: Scikit-Learn,

Keras, TensorFlow

• Version Control: GitHub

Contact this candidate