Data Analyst with 3+ years in Power BI & SQL
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Detail-oriented Food Science graduate with hands-on experience in data collection, cleaning, and analysis seeking a Data Analyst Internship. Proficient in Excel (Pivot Tables, VLOOKUP/XLOOKUP, Charts), Power BI (Power Query, DAX, Interactive Dashboards), and SQL (JOINS, Aggregations, GROUP BY). Adept at transforming raw datasets into actionable insights that drive business decisions, with a strong analytical mindset cultivated through laboratory research and quality assurance work.
Federal University of Technology, Akure
B.Tech · Food Science and Technology
August 1, 2019 – June 30, 2024
AAVA Brands, Agbara
Quality Control Intern
September 1, 2023 – January 31, 2024
Ado-Odo/Ota, Ogun State, Nigeria
Federal University of Technology, Akure
Laboratory Trainee
March 1, 2022 – October 31, 2024
Akure South, Ondo State, Nigeria
Retail Customer Insights Analysis
June 27, 2026 – Present
Queried retail databases using core SQL clauses (SELECT, WHERE, ORDER BY, GROUP BY, HAVING) to extract targeted customer and transaction data. Performed data aggregation and trend analysis across product categories, regions, and time periods to uncover sales patterns. Applied JOIN operations across multiple relational tables to combine customer, product, and transaction datasets for holistic analysis. Outcome: Delivered structured query outputs that enabled identification of top-performing product categories and high-value customer segments.
Sales Data Cleaning Project
June 27, 2026 – Present
Cleaned and standardized a raw sales dataset by systematically removing duplicate records, filling or flagging missing values, and correcting data inconsistencies. Applied Excel data validation techniques to enforce data integrity rules and prevent entry of invalid records. Combined disparate datasets using VLOOKUP and XLOOKUP functions, creating a consolidated, analysis-ready master file. Outcome: Produced a clean, structured dataset ready for downstream analysis, eliminating data quality issues that would compromise reporting accuracy.
Sales Performance Dashboard
June 27, 2026 – Present
Connected and integrated multiple data sources into a unified Power BI environment, establishing reliable data pipelines for ongoing reporting. Cleaned and transformed raw sales data using Power Query, standardizing formats and resolving inconsistencies to ensure data accuracy. Designed fully interactive dashboards with slicers, dynamic filters, and KPI visualizations enabling stakeholders to drill down into performance metrics. Built data models and defined table relationships, then authored DAX measures and calculated columns to support complex business logic and dynamic KPI tracking. Outcome: Delivered a self-service reporting tool that reduced manual reporting effort and improved visibility into sales performance trends.
Customer Data Analysis Project
June 27, 2026 – Present
Conducted end-to-end exploratory data analysis (EDA) on a customer dataset, profiling data distributions, outliers, and missing values. Calculated descriptive statistics (mean, median, standard deviation, percentiles) to characterize customer segments and purchasing behaviour. Built dynamic Pivot Tables and Pivot Charts to summarize data across multiple dimensions, enabling rapid comparison across customer groups. Identified actionable customer behaviour trends and translated findings into clear, business-relevant recommendations. Outcome: Insights surfaced key customer segments contributing to 80% of revenue, providing a basis for targeted retention strategies.
Food Packaging and Safety
Unknown
March 1, 2025 – Present
Health and Safety Induction
Unknown
February 1, 2025 – Present
ISO 9001:2015 Quality Management System Foundations
Unknown
February 1, 2025 – Present
Cultural Fit Analysis
The candidate's projects demonstrate a clear focus on data analysis, aligning well with the target role. The diversity of projects (sales performance, data cleaning, customer analysis, retail insights) shows a breadth of application for their data skills. While the educational background is in Food Science and Technology, the candidate has proactively developed relevant data analysis skills and applied them in personal projects, indicating strong initiative and adaptability. The certifications are not directly related to data analysis, but the ISO 9001:2015 foundation suggests an understanding of quality systems, which can be beneficial. The lack of a psychometric test score makes a comprehensive cultural fit assessment challenging.
Soft Skills & Operational Fit
The candidate demonstrates strong attention to detail and data accuracy, which is critical for a Data Analyst role. Their experience in quality control and laboratory work highlights a methodical approach to data collection and analysis. The resume also indicates collaboration and a proactive attitude, suggesting a good fit for team environments. However, the psychometric test score is 0, which is insufficient to assess logical reasoning, work attitude, stress handling, and team collaboration effectively.