OBIDEYI OLANREWAJU O.

Data Analyst

Osogbo, NG.

About

Results-oriented Data Analyst adept at leveraging Microsoft Excel (Power Query, Pivot Tables, advanced formulas), SQL (MySQL), and Power BI to transform complex datasets into actionable insights. Proven ability to clean data, build interactive dashboards, and drive data-driven decisions across diverse domains including environmental sustainability, election analytics, and financial performance.

Work

Excelerate

|

Data Analyst Intern (Team Lead)

Remote

→

Summary

Led a team in a 3-week compliance analysis project, developing a unified master table and delivering strategic recommendations to university leadership.

Highlights

Spearheaded a 3-week compliance analysis for Saint Louis University, leading Team-2 to integrate data from 3 disparate systems (totaling 45,087 rows) into a unified master table with a 99.7% join match rate.

Executed comprehensive data cleaning and standardization using SQL functions (ROW_NUMBER(), TO_TIMESTAMP(), REGEXP_REPLACE(), SPLIT_PART()) to ensure data integrity and accuracy across all datasets.

Uncovered 7 critical compliance risk areas, including 1,869 unpaid I-901 fees, 4,485 unissued I-20s, and 1,990 SEVIS-Applicant ID mismatches, alongside country-specific hotspots (Ghana 72.7%, Nepal 84.4% unpaid).

Developed and presented 5 strategic recommendations to SLU leadership, supported by a Looker compliance dashboard with automated alerts, enhancing proactive risk management.

Education

Osun State University Osogbo

Osogbo, Osun State, Nigeria
Bachelor's Degree / Diploma Microbiology

Languages

English

Certificates

Microsoft Power BI Data Analyst (PL-300)

Microsoft

Skills

Data Analysis & Visualization

EDA, Data Cleaning & Transformation, Dashboard Design, KPI Reporting, Geospatial Analysis, Compliance Analytics, Variance Analysis, Performance Analysis, Trend Analysis, Statistical Analysis.

Microsoft Excel

Pivot Tables, Power Query, VLOOKUP, XLOOKUP, IF/IFS, SUMIFS, COUNTIFS, Conditional Formatting, Currency Formulas, Advanced Formulas.

Microsoft Power BI

Multi-page Reports, DAX Measures, Choropleth Maps, KPI Cards, Cross-page Navigation, Slicers, Drill-downs, Dashboard Building.

SQL

MySQL, DDL/DML, ROW_NUMBER (), REGEXP_REPLACE (), TO_TIMESTAMP (), SPLIT_PART (), Subqueries, Data Cleaning.

Tools

MySQL Workbench, Looker.

Projects

Environmental Sustainability Dashboard

Summary

Developed an interactive dashboard analyzing waste management and environmental sustainability trends across 30 Local Government Areas (LGAs) in Osun State, providing data-driven recommendations.

Nigeria 2023 Presidential Election Dashboard

Summary

Designed a national dashboard for the Nigeria 2023 Presidential Election, visualizing voter turnout and results across geo-political zones.

Expenses-Claims Analysis Dashboard

Summary

Built a multi-currency dashboard tracking $426,042 in expenses with detailed breakdowns and monthly trends for 2023–2025.

Budget Forecast Analysis Dashboard

Summary

Tracked $3.79M actual vs. $3.74M budget across 6 departments (FY2024–2025), surfacing a $54,639 variance and 55% under-budget rate.

Access to Basic Services - United Nations

Summary

Created a relational database to track global basic service access metrics and authored DDL schema with numeric precision and NOT NULL constraints.