Sahara Tyner Melgar | Data Analytics Student

Sahara Tyner Melgar

Data Analytics Student

Based in New York, NY

About

Results-driven aspiring Data Analyst with a strong passion for extracting insights from complex datasets. Currently pursuing a Bachelor's degree in Data Analytics & Data Management at Western Governors University, equipped with a solid foundation in statistical analysis, data visualization, and database management. Skilled in Python, SQL, and Excel, I am eager to leverage my analytical mindset and technical acumen to solve real-world business challenges through data-driven decision-making. Committed to continuous learning and staying abreast of emerging trends in the field, I am poised to contribute to the success of organizations by transforming raw data into actionable intelligence.

Skills

Projects

Financial Statement - Excel

• Developed a comprehensive financial statement in Excel, consisting of three sheets: Transactions, Profit & Losses, and Balance Sheet. • Utilized advanced Excel functions, including SUM and SUMIFS, to accurately calculate and analyze final costs.

Credit Card Defaults Visualization - Power BI

This Power BI visualization highlights credit card defaults across demographics in the United States. I utilized a Kaggle dataset and included all US states for map visualization. Additionally, I made use of various charts and customizable filter to display and compare various demographics.

Jersey City Citibikes Visualization - Tableau

Within this Visualization, I've utilized Tableau to visualize the most popular Citibike stations in Jersey City alongside charts that showcase insights into these trips. I've created 6 sheets alongside a final dashboard.

Car Insurance Claims - Pivot Tables, Charts, and Dashboard - Excel

Within this project, I focused on utilizing Excel to extract valuable insights. I created 6 Pivot Tables and Charts, allowing me to visually present key findings effectively. By exploring and analyzing the data, I was able to uncover valuable insights that contributed to informed decision-making.

Experience

2020-2023

Secretary

• Streamlined communication channels and optimized project timelines, fostering collaboration, and enhancing business processes through efficient utilization of Google Workspace, Microsoft Office, Slack, and Zoom. • Orchestrated seamless domestic and international travel arrangements with exceptional attention to detail and time management, ensuring smooth operations and a superior experience for executives and staff. • Exhibited strong vendor management skills by sourcing office equipment and supplies cost-effectively, maintaining confidentiality, and exercising discretion in sensitive matters.

2023-2023

Data Analyst Intern

• Transformed complex datasets into actionable insights using Tableau, Power BI, and advanced Excel functions, enabling stakeholders to make data-driven decisions. • Developed visually captivating dashboards and reports, effectively presenting data findings to cross-functional teams, and driving collaborative problem-solving. • Streamlined data processing and analysis by utilizing SQL to extract, clean, and integrate diverse datasets, ensuring accuracy and consistency in visualizations.

Education

2023-2025

Data Management & Data Analytics

Western Governors University