Data Analyst with 1+ years in SQL & Power BI, specializing in retail and customer behavior analysis.
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 Data Analyst with hands-on experience in SQL, Power BI, and Excel, and a portfolio of real-world analytical projects spanning retail sales, HR compensation, and customer behavior analysis. Currently pursuing a M.Sc. in Data & Information Science at the University of Ibadan. Passionate about transforming raw data into actionable business insights.
University of Ibadan
Master of Science (M.Sc.) · Data & Information Science
August 1, 2025 – June 30, 2026
Obafemi Awolowo University
Bachelor of Science (B.Sc.) · Biology
August 1, 2018 – June 30, 2023
Astro Marketer
Data Entry Specialist
January 1, 2025 – June 1, 2025
India
Click worker
Data Entry & Validation Specialist
May 1, 2021 – September 1, 2022
India
Walmart Retail Sales Analysis
June 1, 2025 – Present
Analyzed 45 stores across multiple years to identify the top 10 revenue-generating locations and uncover macroeconomic drivers of retail performance. Quantified the impact of external factors (fuel price, CPI, and unemployment) on weekly sales using Pearson correlation calculations written in SQL. Built week-over-week sales growth tracking per store using LAG () window functions, and ranked weekly market leaders using RANK () partitioned by year. Identified underperforming stores meeting three simultaneous criteria: below-average sales, high unemployment regions, and above-average fuel prices. Determined that holiday weeks outperformed non-holiday weeks and that mild temperatures correlated with higher average customer spending.
Nigerian HR Employee Compensation Analysis
June 1, 2025 – Present
Investigated compensation equity across departments by identifying the highest and lowest average salaries and calculating salary spread (max - min) per department. Detected salary outliers, employees earning more than 50% above or below their department average, using CTE-based deviation analysis, and ranked departments by outlier frequency. Applied a multi-section analytical framework covering compensation structure, internal equity, and workforce distribution to generate actionable HR insights.
Café Sales Data Cleaning
June 1, 2025 – Present
Cleaned a dirty transactional dataset by replacing ERROR/UNKNOWN placeholders with NULL values across 7 columns using conditional UPDATE logic. Recovered missing values in Total Spent, Quantity, and Price Per Unit columns by deriving them mathematically from available related fields. Inferred missing Item values by mapping known price-per-unit relationships, and dropped rows where both Item and Transaction Date were null and unrecoverable. Standardized data types (INT, DATETIME) and validated all cleaning steps with targeted SELECT COUNT(*) confirmation queries.
Nigerian Retail Sales Excel Dashboard
June 1, 2025 – Present
Built a multi-chart interactive Excel dashboard analyzing #471M+ in total sales across Nigerian states, product categories, and regions. Identified Technology as the highest-margin product category (18.4%) and flagged South West as the volume leader while South East showed higher margin potential. Visualized the relationship between discounting strategies and profitability, revealing that higher discount rates correlated with declining profit margins. Produced KPI cards tracking Total Sales, Total Profit (#83.8M), Profit Margin (18%), Total Orders (1,000), and Average Discount (6%) for executive-level reporting.
Customer Acquisition & Retention Power BI Dashboard
June 1, 2025 – Present
Built an interactive dashboard analyzing customer acquisition and retention across sales reps and product categories, covering 1,000 total customers. Revealed a balanced customer base with New Customers (504) and Returning Customers (496), indicating stable growth and retention performance. Identified top performers, with David leading acquisition (~23%) and Bob driving the highest returning customer share (~22%). Uncovered product insights, showing Furniture leading in retention (146) while Clothing drove the highest new customer volume (143). Designed KPI cards and dynamic visuals (donut charts, bar charts, tables) to enable quick, data-driven evaluation of sales performance and customer distribution.
Cultural Fit Analysis
The candidate's project portfolio demonstrates a proactive and self-driven approach to learning and applying data analysis skills, which aligns with a culture of continuous improvement. The diversity of projects (HR, retail, customer acquisition) indicates a broad interest in applying data analysis to different business problems. However, the experience is primarily in data entry roles, and the target role of Data Analyst is a significant step up, which might require a strong mentorship environment. The low psychometric test score could indicate potential challenges in team collaboration or adapting to new work environments, which are crucial for cultural fit.
Soft Skills & Operational Fit
The candidate demonstrates strong attention to detail and accuracy, as evidenced by their data entry roles and emphasis on data integrity in projects. Their ability to manage concurrent tasks and meet deadlines in a remote, self-directed environment suggests good organizational skills and autonomy. The project descriptions indicate a problem-solving mindset, particularly in data cleaning and inferring missing values. The psychometric test score is low, which might indicate potential challenges in logical reasoning, work attitude, stress handling, or team collaboration, requiring further investigation.