Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

AARON ESSIEN AMOAKO

AKIM SWEDRU

Summary

Logical Data Analyst skilled in requirement analysis and database management. Self-directed and proactive professional with two years of experience collecting, cleaning and interpreting data sets.

Overview

2
2
years of professional experience
1
1
Certification

Work History

Data Analyst

Best Buy Computers
06.2021 - 10.2023
  • Designed and developed data pipelines to acquire, clean and process data.
  • Developed dashboards and reports using business intelligence tools including Microsoft Power BI and Tableau.
  • Created and optimized DAX calculations, measures and expressions to support complex data analysis.
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Defined key performance indicators (KPIs) based on collected data sources.
  • Leveraged SQL queries to extract, transform and load data into databases.
  • Generated standard and custom reports to provide insights into business performance.
  • Collaborated with stakeholders to identify business needs and the understanding of data content.
  • Identified, analyzed and interpreted trends or patterns in complex data sets.
  • Presented reports to internal and external stakeholders.
  • Designed automated ETL processes for efficient data extraction, transformation and loading into the required models using Microsoft Power Query.
  • Ensured data quality through consistent checks.
  • Generated quick insights using sparklines, charts and visuals on Microsoft Excel.
  • Created databases, schemas and tables using SQL and Microsoft SQL Server.
  • Conducted exploratory analysis of complex datasets using Python libraries such as NumPy, Pandas, Matplotlib and Seaborn.
  • Imported, transformed and exported data using Python libraries.
  • Developed data mining algorithms to identify and classify patterns in data.

Education

Bachelor of Arts - Economics

University of Cape Coast
Cape Coast, Ghana
05.2017

Skills

    Proficiency in Microsoft Power BI and Tableau

    Proficiency in Microsoft Excel and Python Programming

    Proficiency in SQL and Microsoft SQL Sever

    Data Visualization and Presentations

    Excellent communication skills both written and verbal

    Team work abilities

    Data Mining

    Data Modeling

    Data Integrity Validation

    Analytical Problem Solving

    Attention to Detail

Certification

  • [Data Analyts], Reed

Languages

English
Bilingual or Proficient (C2)

Timeline

Data Analyst

Best Buy Computers
06.2021 - 10.2023

Bachelor of Arts - Economics

University of Cape Coast

Similar Profiles

CREATE PROFILE
AARON ESSIEN AMOAKO