Data Analyst - Excel, SQL, Power BI, Python

OLUWAGBEMI ADEKOYA

Data Analyst

Lagos, Nigeria +234 902-***-**** *****************@*****.*** LinkedIn GitHub Portfolio SUMMARY

Data Analyst with hands-on experience collecting, cleaning, and analysing data from multiple sources to support business decision-making. Proficient in Excel, SQL, Power BI, and Python, with a track record of building dashboards, tracking KPIs, and identifying trends and performance gaps across professional and public-sector settings. Currently completing the ALX Data Science programme (Data Analytics and Python for Data Science completed; Machine Learning in progress). CORE SKILLS

Microsoft Excel (Pivots, VLOOKUP, Charts) • SQL (Joins, CTEs, Window Functions, Views, MySQL) • Power BI (DAX, Calculated Columns, Multi-page Dashboards, KPI Tracking) • Python (Pandas, NumPy, Data Cleaning, Jupyter) • Tableau • Google Sheets • Exploratory Data Analysis • Statistical Modeling • Data Integrity & Quality Assurance • Cross-functional Reporting • Git

WORK EXPERIENCE

IT & Digital Operations Specialist Jan 2026 – Present Association of Enterprise Risk Management Professionals (AERMP) — Lagos, Nigeria

• Collect, clean, and analyse membership, training, and event data from multiple internal sources to support reporting and operational decision-making across the organisation.

• Build and maintain reporting on training, examination, and webinar performance, monitoring participation KPIs and flagging trends and gaps to leadership across 20+ events.

• Centralised digital records and communication workflows, improving data accuracy and reducing administrative turnaround time for a distributed team.

• Collaborate with cross-functional teams (leadership, training, and communications) to standardise reporting processes and maintain consistent data integrity across outputs. Computer Science Teacher (NYSC) May 2024 – Apr 2025 Peculiar Generation School — Calabar, Nigeria

• Digitised and managed a comprehensive student records system, achieving 100% data accuracy and eliminating errors in institutional reporting.

• Analysed academic performance data and developed data-driven visual presentations for staff performance reviews, simplifying complex information for faster, evidence-based leadership decisions. PROJECTS

World Cup 2026 Match Predictor — Python · Pandas · SciPy · Poisson Modeling · Data Visualization

• Built a Poisson goal-based prediction model in Python to forecast match outcomes from historical team performance data, collected and cleaned from multiple public sources.

• Developed a full analytical pipeline — data cleaning, exploratory data analysis, and a results visualiser — packaged with a documented notebook and README; published to GitHub and Kaggle. Maji Ndogo Water & Agriculture Data Analysis — SQL · Python (Pandas) · Power BI

• Cleaned and analysed a multi-table relational dataset spanning water services and agriculture, using SQL CTEs, window functions, and complex joins.

• Built multi-page Power BI dashboards with DAX calculated columns to track KPIs, visualise service delivery gaps, and support resource allocation decisions.

• Performed exploratory data analysis in Python (Pandas) to identify outliers, missing data patterns, and key performance trends.

EDUCATION

B.Sc, Computer Science (2:1) Sep 2018 – Oct 2023

University of Ilorin — Kwara State, Nigeria

CERTIFICATIONS

• Data Analytics, ALX Africa — 2026

• Python for Data Science, ALX Africa — 2026

• Machine Learning, ALX Africa — In Progress

• The Complete Python Bootcamp: From Zero to Hero in Python, Udemy — 2024

Contact this candidate