CHIAMAKA OKAKPU

Data Analyst Intern

LinkedIn

About

Highly analytical and results-driven Data Analyst Intern with a robust foundation in Python and SQL, adept at transforming complex datasets into actionable insights. Proven ability to conduct comprehensive data analysis, develop compelling visualizations, and optimize strategies across marketing and web traffic initiatives. Eager to leverage strong problem-solving skills and a proactive approach to contribute to data-driven decision-making in a dynamic environment.

Work Experience

Data Analyst (Intern)

HNG TECH Internship

Jan 2025 - Present

Contributed to data analysis initiatives within a dynamic internship environment, focusing on enhancing data quality, deriving actionable insights, and supporting strategic decision-making across various departments.

  • Partnered with cross-functional teams, including product and marketing, to define data requirements and deliver tailored analyses, improving strategic alignment.
  • Streamlined data processing workflows by cleaning and structuring large, complex datasets, enhancing data accuracy and integrity while reducing errors.
  • Conducted in-depth analysis of marketing campaign performance, identifying key insights to optimize strategies and improve overall campaign effectiveness.
  • Developed compelling reports, interactive dashboards, and visualizations using Power BI and Excel to clearly communicate complex data insights to stakeholders.
  • Performed comprehensive SEO analysis, identifying key opportunities that led to a measurable increase in web traffic and improved search engine rankings.

Education

Computer Science

Yaba College of Technology (HND)

Sep 2023

Courses

  • Data Structures
  • Algorithms
  • Database Management Systems
  • Software Engineering
  • Web Development

Certificates

Foundations: Data, Data Everywhere

Coursera

Nov 2023

Ask Questions to Make Data-Driven Decisions

Coursera

Oct 2023

Python for Data Analysis

Datacamp

Sep 2023

Data Analytics Essentials

Cisco Networking Academy

Aug 2023

Projects

SQL Based Marketing Analysis

May 2025 - May 2025

SQL-driven data analysis project focused on optimizing marketing campaign performance and resource allocation.

Data Cleaning And SEO Optimization

Mar 2025 - Apr 2025

Project focused on enhancing data quality for product descriptions and improving SEO performance through automated processes.

Exploratory Data Analysis on Marketing Campaign Data

Jan 2025 - Feb 2025

Comprehensive exploratory data analysis project focused on uncovering actionable insights from marketing campaign datasets.

Skills

Data Visualization

  • Power BI
  • Excel
  • Matplotlib
  • Seaborn

Data Management

  • Data Cleaning
  • Data Transformation
  • Data Structuring
  • Data Accuracy

Programming

  • Python
  • Pandas
  • SQL

Data Analysis & Reporting

  • Exploratory Data Analysis (EDA)
  • Marketing Analytics
  • KPI Analysis
  • Report Generation
  • Dashboard Creation

SEO & Web Analytics

  • SEO Analysis
  • Keyword Research
  • Website Visibility
  • Organic Traffic