Data Analyst & Engineer (Lifemate Nigeria Intern) – ETL and automated data pipelines (2021–2024)
Sales Performance Analysis: Used SQL to extract and analyze sales data from multiple tables, creating reports on revenue trends, top-performing products, and customer purchasing behavior. Applied joins, aggregations, and window functions to generate business insights. Data Cleaning and Validation: Wrote SQL queries to identify duplicate records, missing values, and data inconsistencies. Developed validation checks to improve data quality before analysis or AI training workflows. Customer Segmentation Project: Queried customer transaction data to group users based on purchasing patterns, frequency, and spending levels. Used SQL aggregations and filtering techniques to support marketing and business decisions. Dashboard Data Preparation: Created SQL views and queries to prepare datasets for visualization tools such as Tableau or Power BI. Optimized queries to improve reporting performance and ensure accurate metrics.