MUBARAK ADESOLA ADEDEJI
Data Analyst · Python · SQL · Power BI · R · ODK
*********************@*****.*** +234 808-***-**** Kaduna, Nigeria LinkedIn: linkedin.com/in/mubarak-adedeji GitHub: github.com/Mubydeji PROFESSIONAL SUMMARY
Data Analyst with 3+ years of end-to-end experience — from field data collection to executive reporting — across public health, government policy, and commercial operations. Built ETL pipelines, multi-LGA Power BI dashboards, and ODK survey instruments used by state-level health programs in Kaduna. Fluent in Python, SQL, R, and Power BI; one of few analysts with hands-on ODK experience for primary data collection in low-resource settings. Turns messy, real-world data into clear insights for decision-making. Open to remote and international opportunities. PROFESSIONAL EXPERIENCE
Click-On Kaduna Data Science Fellowship 5.0 Oct 2025 – Present Data Science Fellow· Kaduna, Nigeria
• Key Achievement: Built a Bronze–Silver–Gold SQL data warehouse for longitudinal health data across 14 LGAs, cutting analyst query time by ~40% and enabling repeatable ETL workflows for ongoing research.
• Using Power BI and DAX, rebuilt the PHC facility readiness dashboard — redesigning the data model and adding trend measures across 500+ facility records, informing state-level resource allocation decisions.
• Designed a 60-variable ODK survey instrument for a maternal health prevalence study, structuring data capture to ensure zero entry errors and immediate analysis-readiness on collection.
• Led field data collection across 14 LGAs via ODK Collect, applying validation logic (range checks, cross-field rules) to deliver a clean dataset to a government-aligned research team.
• Ran EDA and statistical analysis in Python and R on longitudinal facility data, surfacing readiness gaps and exposure patterns that guided PHC planning recommendations across Kaduna State.
• Produced a reproducible evidence brief — methodology, findings, and policy implications in one document — enabling non-technical stakeholders to act on results without analyst mediation.
• Worked within a real-world, government-aligned data environment — delivering analysis used in active public health planning across Kaduna State.
Bilsun Textile LTD Sep 2023 – Present
Lead Data Analyst & Media Manager
• Key Achievement: Built a Power BI + Excel reporting suite tracking KPIs across 5+ product lines — replacing manual spreadsheets, cutting reporting time by ~30%, and driving a ~15% reduction in overstock.
• Modelled demand patterns across 1,000+ monthly transactions, enabling automated stock reorder triggers that reduced stockout incidents and improved inventory efficiency.
• Developed pivot-table dashboards with automated Excel formulas, giving management real-time revenue visibility without ongoing analyst input.
• Used social media performance data to build a content strategy that measurably improved engagement and customer acquisition efficiency over 6 months.
Lagos State Ministry of Innovation, Science and Technology Apr 2024 – Oct 2024 Data & Policy Analyst (Industrial Trainee) · Lagos, Nigeria
• Key Achievement: Synthesised 20+ policy documents on digital governance into concise analytical briefs that enabled faster, evidence-based decision-making by ministry officials.
• Mapped and documented public-sector data workflows, producing a reference framework that improved reporting clarity across teams handling technology policy.
• Worked directly within a government data environment — gaining practical exposure to public-sector reporting standards, data governance, and evidence-driven policy cycles. SkillHive Oct 2021 – Nov 2024
Program Manager · Nigeria
• Key Achievement: Designed Excel tracking dashboards monitoring facilitator utilisation and learner progress across 50+ learners per cohort, used consistently across a 3-year program run.
• Produced evaluation reports from cohort assessment data, identifying delivery bottlenecks that drove scheduling and resource improvements across 3+ program tracks.
PROJECTS
PHC Facility Readiness — Power BI Dashboard — Power BI, DAX, SQL, Longitudinal Health Data
• Problem: State health planners had no consolidated view of readiness across 14 LGAs. Approach: Redesigned the data model, wrote DAX trend and gap measures, built drill-through pages by LGA and facility type. Outcome: Dashboard adopted by a government-aligned team for ongoing monitoring, replacing ad hoc spreadsheet reporting. Lung Cancer Prevalence — Demographic & Lifestyle EDA — R, RStudio, ggplot2, tidyR
• Problem: Identify lifestyle and demographic risk factors for lung cancer. Approach: Cleaned 309 records, resolved duplicates, recoded binary variables, and profiled exposure distributions with annotated visualisations. Outcome: Reproducible EDA report surfacing 3 high-signal predictors, ready for downstream modelling. Heart Disease Risk — Feature Engineering Pipeline — Python, pandas, NumPy, Matplotlib, Seaborn
• Problem: Raw patient records had mixed types, missing values, and no engineered risk features. Approach: Built an end-to-end pipeline covering imputation, encoding, interaction terms, and risk-score derivation. Outcome: Clean, model-ready dataset with documented methodology — suitable for ML classification. Petrol Subsidy Perception — National Survey Analysis — Power BI, DAX, Descriptive Statistics
• Problem: Quantify public awareness of Nigeria's petrol subsidy removal across demographics and geography. Approach: Segmented survey data by geopolitical zone, state, LGA, and urban/rural split; built DAX measures for comparison. Outcome: Interactive Power BI report exposing regional awareness gaps, used to frame policy communication.
Retail Sales Forecasting — Mathematical Modelling — Python, Excel, Time-Series Analysis
• Problem: A retail business had no forecasting system for inventory or revenue planning. Approach: Applied trend decomposition to 18 months of sales data; validated projections against holdout periods. Outcome: 3-month forecasts that reduced planning uncertainty and replaced ad hoc estimates. TECHNICAL SKILLS
Programming: Python (pandas, NumPy, Matplotlib, Seaborn) · R (ggplot2, tidyR, dplyr) · SQL BI & Visualisation: Power BI (DAX, data modelling, drill-through) · Excel (pivot tables, advanced formulas, dashboards) Data Engineering: ETL pipeline design · SQL warehouse architecture (Bronze/Silver/Gold) · Data cleaning & validation Data Collection: ODK Collect · ODK survey script design · Primary field data collection Statistical Methods: Exploratory data analysis · Feature engineering · Descriptive & inferential statistics · SPSS Other Tools: Git · Jupyter Notebook · HTML/CSS · Microsoft Office Suite EDUCATION
Air Force Institute of Technology (AFIT), Kaduna Jul 2022 – Jun 2026 B.Sc. Mathematics — Expected June 2026 · Kaduna, Nigeria Relevant Coursework: Linear Algebra & Matrix Theory, Probability Theory, Mathematical Statistics, Mathematical Modelling, Numerical Methods, Real Analysis
Academic Projects: Constrained optimisation modelling; dynamic systems via second-order differential equations; retail sales forecasting via data analysis.
CERTIFICATIONS
• Python Data Associate — DataCamp
• SQL Associate — DataCamp
• AI Fundamentals — DataCamp
• Understanding Data Science — DataCamp
• Green Digital Certificate Program — INCO Academy
• Click-On Kaduna Data Science Fellowship — Click-On Kaduna (In Progress) LEADERSHIP & COMMUNITY
TheSoftwareChasers Jun 2022 – Present
Co-Founder & Project Manager · Nigeria
• Co-founded a tech startup building Sell Harvest (agro-e-commerce for smallholder farmers) and SkillHive365 (online training platform) — leading product and team coordination from concept to deployment. Click-On Kaduna NFTI — Student Tutor Oct 2025 – Present
• Mentored 20+ data science students in Python, Excel, and analytical thinking, guiding capstone projects built on real datasets.
Mathematics Students Association, AFIT — Social Director Jul 2023 – May 2025
• Organised academic and community events for a 100+ member student body, driving engagement across the mathematics department.
LANGUAGES
Yoruba — Native · English — Fluent · Hausa — Basic