Ogundeyi Oluwafemi Ezekiel

Data Analyst
Abeokuta, NG.

About

Detail-oriented Mathematics graduate and aspiring Data Analyst with hands-on experience in financial data analysis, leveraging SQL, Power BI, and Microsoft Excel. Completed professional certifications and built impactful portfolio projects in fraud detection and sales analysis. Passionate about empowering fintech companies with data-driven decisions through actionable insights and interactive dashboards to drive strategic outcomes.

Work

Credit Card Transaction Fraud Detection Analysis (Project)
|

Data Analyst

Abeokuta, Ogun State, Nigeria

Summary

Led a data analysis project to identify fraudulent patterns in credit card transactions, leveraging SQL and Power BI for comprehensive insights and visualization.

Highlights

Analyzed 19,643 credit card transactions using MySQL to detect fraudulent patterns based on transaction amount and time of day, enhancing risk identification.

Identified that high-value transactions (above $500) exhibited a fraud rate 3x higher than low-value transactions, utilizing SQL CASE statements and GROUP BY aggregations to pinpoint critical risk factors.

Built an interactive Power BI dashboard to visualize fraud distribution by amount bucket and time of day, providing stakeholders with clear, actionable insights for mitigation strategies.

Financial Fraud Detection (Project)
|

Data Analyst

Abeokuta, Ogun State, Nigeria

Summary

Developed a portfolio project focused on identifying fraudulent financial transactions by applying data cleaning and exploratory data analysis techniques to banking data.

Highlights

Utilized advanced data cleaning and exploratory data analysis (EDA) techniques to spot anomalies and suspicious patterns within banking data, improving data integrity and insight generation.

Implemented robust data processing workflows to prepare complex datasets for analysis, ensuring accuracy and reliability in fraud detection efforts.

Contributed to the development of a comprehensive fraud detection framework by identifying key indicators and data points crucial for financial security.

BUA Foods Sales Analysis (Simulated Dataset) (Project)
|

Data Analyst

Abeokuta, Ogun State, Nigeria

Summary

Developed an interactive sales performance dashboard using Advanced Microsoft Excel to analyze multi-year revenue and profit datasets for strategic business decisions.

Highlights

Developed a comprehensive, fully interactive sales performance dashboard using Advanced Microsoft Excel to analyze multi-year (2024–2025) revenue and profit datasets, enabling detailed financial review.

Engineered dynamic Pivot Tables, data source models, and customized regional slicers to track quarterly sales distributions across Nigeria, providing granular insights into market performance.

Transformed complex raw corporate metrics into executive-ready data visualizations, highlighting seasonal sales trends and supporting strategic business decisions with clear, actionable intelligence.

Education

Federal University of Agriculture Abeokuta
Abeokuta, Ogun State, Nigeria

B.Sc Mathematics

Pure and Applied Mathematics

Languages

English

Certificates

Google Data Analyst Professional Certificate

Issued By

Coursera

Data Analytics Job Simulation

Issued By

Deloitte (via Forage)

Skills

Power BI

Dashboard Design, Power Query, DAX, Data Visualization.

MySQL

Data Extraction, Subqueries, Data Cleaning.

Microsoft Excel

Data Validation, Charts, Tables, Dashboard Design, Data Cleaning.

Statistical Analysis

Data Distribution, Trend Analysis, Descriptive Statistics, Anomaly Detection.

Interests

Financial Markets
Content Creation
Problem Solving