Data Analyst - Business Intelligence Enthusiast

DERRICK CARTER

Data Analyst/ Business Analyst

336-***-**** ****************@*****.***

https://www.linkedin.com/in/derrick-carter-9a27a91b4 Greensboro, NC 27401 https://dcnation618-cell.github.io/DerrickCarter.github.io/ Professional Summary

Highly analytical and detail-oriented aspiring Data Analyst with a Bachelor's degree background in Physics & Astronomy, providing a strong foundation in quantitative analysis and problem-solving. Familiarity in SQL, Python, and Tableau. Proven ability to clean, transform, and model complex datasets to deliver actionable business insights for decision-making.

Technical Skills

Category Skills & Tools

Programming & Database SQL, Python

Business Intelligence Tableau

Data Analysis & Modeling Statistical Modeling (Hypothesis Testing, Regression Analysis, Uncertainty

Quantification), Advanced Analytical

Problem-Solving

Data Manipulation Excel (Pivot Tables, Pivot Charts, VLOOKUP, HLOOKUP, VBA), Data Cleaning

Data Projects

EXPLORATORY DATA ANALYSIS (EDA) PROJECT: GLOBAL LAYOFFS Personal Project - Boone, NC July 2025

● Conducted comprehensive Exploratory Data Analysis (EDA) on a cleaned global layoffs dataset, leveraging aggregate functions to quantify impact across industries, countries, and company stages.

● Developed advanced analytical queries using multiple Common Table Expressions

(CTEs) and Window Functions (e.g., DENSE_RANK, SUM OVER...) to calculate a rolling total of layoffs by month and rank the top five companies with the largest layoffs annually.

DATA CLEANING PROJECT: GLOBAL LAYOFFS DATA IN MYSQL Personal Project - Boone, NC July 2025

● Applied advanced data cleaning and transformation techniques in MySQL, utilizing Window Functions (ROW_NUMBER for duplicate identification and self-joins for imputing missing values across over 2,300 layoff records.

● Standardized and refined a real-world dataset by correcting data inconsistencies, normalizing industry and country fields, and converting a text string column to a proper DATE data type to ensure data integrity for subsequent time-series analysis. TABLEAU VISUALIZATION PROJECT: AIRBNB SEATTLE DATA Personal Project - Boone, NC July 2025

● Integrated, blended, and transformed data from three sources (listings, calendar, and reviews).

● Designed and built a comprehensive Tableau dashboard that utilized five key visualizations, including a time-series analysis of revenue and a geographic map of pricing, to provide an investor with actionable insights on rental strategy and profitability.

Excel Data Cleaning & Analysis Project: Superstore Sales Data

Personal Project - Boone, NC July 2025

● Executed a comprehensive data cleaning and preparation pipeline in Excel, addressing critical data quality issues such as removing duplicates, standardizing inconsistent text entries, and correcting formatting errors across a large dataset of superstore sales.

● Applied advanced Excel functions and tools (e.g., TRIM, PROPER, LEN, LEFT, FIND, Text to Columns, Remove Duplicates, Conditional Formatting) to enhance data accuracy and ensure consistency for reliable analysis.

● Developed and presented actionable insights through organized tables and basic visualizations within Excel, enabling a clear understanding of sales trends and data patterns for the superstore management.

●

Work Experience

BURGER KING - CREWMEMBER

Boone, NC October 2024 - Present

● Managed high-volume order processing in a fast-paced environment, demonstrating strong attention to detail when recording and fulfilling complex customer requests.

● Developed core problem-solving and communication skills by summarizing customer feedback to management and contributing to process improvements that reduced order errors.

MCDONALDS - CREWMEMBER

Greensboro, NC August 2020 - August 2023

● Maintained 100% data accuracy by meticulously verifying cash transactions and inventory logs, which ensured accurate stock levels and minimized accounting errors.

● Optimized operational efficiency by consistently analyzing drive-thru times and kitchen flow to quickly identify and resolve bottlenecks, directly contributing to a higher throughput rate during peak hours.

Education

BACHELOR OF ARTS & SCIENCES Appalachian State University - Boone, NC

● Major: Physics & Astronomy

● Expected Graduation: May 2026

Contact this candidate