Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Derrick Mensah

The Bronx,NY

Summary

Data analyst with 2+ years of experience in data analysis, reporting, and dashboard development. Proven track record in leveraging Python, SQL, and Tableau to provide data-driven insight and automate processes, improving decision-making and operational efficiency. Seeking opportunities to further develop data analytics expertise and contribute to organizational growth.

Overview

2
2
years of professional experience
1
1
Certification

Work History

Freelance Data Analyst

Self-employed
Remote, NY-New York
07.2022 - Current
  • Provided data analysis services to clients across various industries, helping them make informed decisions through data-driven insights.
  • Helped clients reduce tax liabilities by 10-15% through detailed financial data analysis.
  • Utilized Python and SQL to clean, process, and visualize data for customized client reports, improving their ability to manage financials, inventory, and customer data.

Data Analyst

Excellence Community Schools
Bronx, NY
10.2022 - 07.2023
  • Developed 5 Tableau dashboards, enhancing KPI monitoring and supporting decision-making for school leaders.
  • Provided data-driven solutions to support decision making.
  • Conducted exploratory analysis of complex datasets using Python libraries, such as NumPy and Pandas.
  • Leveraged SQL queries to extract, transform and load data into databases.
  • Automated manual reporting processes with Python and SQL, reducing reporting time by 25%.
  • Provide IT support and troubleshooting for staff members in all ECS sites.
  • Created and maintained an annual staff attendance dashboard, developed a student academic performance dashboard to assist teachers and principals in tracking progress and improving outcomes.
  • Identified and resolved data quality issues in large datasets.

Education

Bachelor of Science - Atmospheric Sciences And Meteorology

SUNY Oneonta
Oneonta, NY
05-2021

Skills

Programming languages: Python, SQL

Data Visualization: Tableau and Microsoft Excel

Data Analysis: Exploratory analysis, statistical analysis, machine learning

Soft skills: Strong work ethic, problem solving, teamwork

Other skills: Data quality management ETL processes, reporting automation

Certification

  • Google Data Analytics Certificate
  • General Assembly Data Analytics Certificate

Timeline

Data Analyst

Excellence Community Schools
10.2022 - 07.2023

Freelance Data Analyst

Self-employed
07.2022 - Current

Bachelor of Science - Atmospheric Sciences And Meteorology

SUNY Oneonta
Derrick Mensah