OLADIPUPO ABIDEMI FRANCIS

Data Analyst & AI Specialist
Lagos, NG.

About

Results-driven Data Analyst and AI Specialist with over 3 years of experience in transforming complex raw data into actionable business intelligence. Expert in Python, SQL, Excel, Power BI, and workflow automation (Make.com, Google Apps Script), consistently building multi-step automations and API integrations that significantly accelerate reporting cycles and eliminate manual effort. Adept at communicating intricate technical insights to diverse non-technical stakeholders, having trained and mentored over 50 professionals in data disciplines, and passionate about leveraging data and AI to drive growth for remote-first organizations.

Work

Franova Tech
|

Data Analysis Instructor

Remote, Remote, N/A

Summary

Led comprehensive data analysis training programs, equipping diverse cohorts with essential skills in Excel, SQL, Power BI, and Python to enhance their job readiness.

Highlights

Delivered hands-on training to diverse cohorts in Excel, SQL, Power BI, and Python, consistently achieving high learner satisfaction scores.

Developed structured curricula and real-world exercises, strengthening analytical problem-solving and job-ready data skills for participants.

Guided students through complete data pipelines, encompassing data cleaning, analysis, visualization, and reporting.

Integrated Make.com and Google Apps Script automation concepts into curricula, exposing learners to modern, efficient data workflows.

Mentored learners on project-based tasks, simulating real workplace data challenges across multiple industries.

Franova Tech
|

Outbound Sales & Enrollment Officer

Remote, Remote, N/A

Summary

Managed outbound sales and enrollment, successfully converting interested prospects into enrolled data analysis students through persuasive communication and diligent follow-up.

Highlights

Conducted warm outbound follow-up calls, converting interested prospects into enrolled data analysis students.

Communicated course benefits persuasively, effectively handling objections with confidence and professionalism.

Maintained detailed lead tracking records, consistently following up to maximize enrollment conversion rates.

SMEs & Educational Institutions
|

Freelance Data Analyst

Nigeria, N/A, Nigeria

Summary

Provided freelance data analysis services to SMEs and educational institutions, driving measurable improvements in sales revenue and academic performance through data-driven solutions.

Highlights

Built interactive Power BI dashboards and Excel reports, enabling data-driven decisions that improved SME sales revenue by 15%.

Designed student performance tracking systems, identifying learning gaps that boosted average academic scores by 15%.

Developed workflow automations with Make.com and Google Apps Script, significantly reducing manual reporting time.

Executed complex SQL queries across multiple datasets to extract, clean, and analyze business data for stakeholder reporting.

EasyTech
|

Data Analysis Instructor (Private Tutor)

Remote, Remote, N/A

Summary

Designed and delivered an intensive 3-month data analysis curriculum, significantly improving student performance through personalized instruction and hands-on projects.

Highlights

Designed and delivered an intensive 3-month curriculum covering Excel, Power BI, and data storytelling.

Improved student performance by 70% through hands-on projects and weekly personalized feedback sessions.

Education

University of Nigeria, Nsukka
Nsukka, Enugu, Nigeria

Bachelor of Education (B.Ed)

Mathematics

Languages

English
Yoruba

Certificates

Data Analysis — Incubator Hub & DSA

Issued By

N/A

Data Science — 3MTT Programme

Issued By

N/A

Data Analysis — HP Life

Issued By

N/A

Excel Fundamentals for Data Analysis

Issued By

Coursera

Data Literacy

Issued By

Coursera

Basic Information Literacy

Issued By

Coursera

Automating Real-World Tasks with Python

Issued By

Coursera

Data Analysis Foundation 1 & 2

Issued By

Microsoft/LinkedIn

Crash Course on Python

Issued By

Coursera

Data Science Math Skills

Issued By

Coursera

Skills

Technical Skills

Python, Pandas, NumPy, SQL, Joins, Aggregations, Excel (Advanced), PivotTables, Power BI, DAX, Dashboards, Tableau, Looker Studio, Make.com Automation, Google Apps Script, AI-assisted Analytics, ETL & Data Cleaning, Statistical Analysis.

Soft Skills

Data Storytelling, Curriculum Design, Mentorship (50+ trained), Remote Collaboration, Problem Solving.

Projects

SME Sales Performance Report

Summary

Cleaned and analyzed over 5,000 monthly sales transactions to provide actionable insights for small and medium-sized enterprises.

Student Performance Tracker

Summary

Processed data for over 200 students to identify subject-level learning gaps and optimize educational strategies.

OPay Personal Finance Dashboard

Summary

Analyzed personal transaction history to uncover spending patterns across various financial activities, including airtime, data, transfers, and debt repayments.

Nigeria Population Dashboard

Summary

Visualized over 10 years of national population and urbanization data in an interactive policy-support dashboard.

SQL Data Analysis Projects

Summary

Wrote complex SQL queries involving joins, aggregations, subqueries, and window functions to manipulate and extract insights from large datasets.