Lead BI & Data Engineer

From SAP tables to decisions people trust.

I build the whole path from SAP to the people who run the business: CDS extraction views, Microsoft Fabric pipelines and Power BI models for manufacturing, supply chain and procure-to-pay. 6+ years, end to end.

Read the P2P case study Get in touch

Lagos, Nigeria · works full UK business hours (WAT)
Open to UK roles with Skilled Worker sponsorship, and remote

Portrait of Michael Ogungbe, lead BI and data engineer

pl_p2p_daily · from my P2P project all checks passing

01
ExtractSAP CDS views, CDC delta
02
Bronze16 SAP tables with lineage
03
Silvertyped, SAP rules applied
04
Goldstar schema, 24 KPIs
05
Quality gate54 / 54 checks
06
Power BIDirect Lake model

Runs daily after the SAP extract; the gate blocks a bad refreshHow it works →

6+ yrs

in data and BI, from analyst to lead engineer

F64

Microsoft Fabric capacity I build and deploy pipelines on

60%

less manual reporting at GZ Industries after automating ETL

150+

professionals trained in analytics and machine learning

Selected work

Real SAP problems, built end to end

My day-job work runs on live SAP data, so I can't publish it. Instead, I rebuild the same problems on realistic synthetic SAP data and publish all the code.

Case study · public code

Procure-to-pay analytics: SAP S/4HANA → Microsoft Fabric

A UK food manufacturer's full P2P flow, from requisition to payment, rebuilt end to end. CDS extraction views feed a Fabric lakehouse, a quality gate reconciles every KPI, and Power BI answers the questions procurement and finance actually ask.

ABAP CDS
Fabric Lakehouse
PySpark
Direct Lake
Power BI · DAX
CI

Read the case study → Code on GitHub ↗

What the analysis surfaced

£304kin duplicate invoices paid, missed by SAP's exact-match check

8 ptsof OTIF lost to short deliveries, concentrated in ingredients

£434kof GR/IR older than 90 days, ready for the year-end clean-up

£1.05mcommitted only after the invoice arrived (after-the-fact POs)

In progress

Inventory and material movements

Stock coverage, slow-moving and obsolete stock, and movement-type analysis built on MATDOC: the questions planners and controllers ask every week.

MATDOC
MM
Fabric
Power BI

From my day job · under NDA

Dashboards I've delivered on live SAP data

Manufacturing operations performance
Stock levels and material movements
Daily delivery tracking
Procure-to-pay, from requisition to payment

Happy to walk through how they were designed in an interview.

What I do

One person across the whole data path

Most SAP analytics problems come from the gaps between teams. I work on both sides of those gaps.

Data architecture

Designing how SAP data reaches the business and stays trustworthy.

SAP extraction with ABAP CDS views built in Eclipse (ADT)
Medallion lakehouse design on Microsoft Fabric
Star schemas and conformed dimensions

Data engineering

Pipelines that run every day without anyone watching them.

Fabric pipelines and PySpark notebooks on F64 capacity
Deployment pipelines and Git integration (Dev → Test → Prod)
Automated quality gates and reconciliation to source

Analytics and BI

Numbers that procurement, operations and finance agree on.

KPI definitions agreed with the business, written down
Power BI semantic models, DAX and Direct Lake
Dashboards for operations, supply chain and P2P

Skills

Tools I use every week

SAP

SAP ERP
ABAP CDS views
Eclipse / ADT
SAP BO / BW
MM: purchasing & inventory
SD: deliveries
FI: accounts payable

Microsoft Fabric

Lakehouse
Data pipelines
Dataflow Gen2
Notebooks (PySpark)
Direct Lake
Deployment pipelines
Git integration
F64 capacity

Analytics

Power BI
DAX
Power Query
Row-level security
Data modelling
KPI design
Tableau
Statistics

Engineering

SQL
Python
PySpark
Azure Data Factory
Azure Synapse
Medallion architecture
Data quality testing
Git · Azure DevOps

Experience

6+ years in data and BI

Lead BI Analyst & Data Engineer
Jul 2024 – Present

GZ Industries Ltd · Aluminium can manufacturing · Nigeria, South Africa, Kenya
- Own the platform from SAP to report: ABAP CDS extraction views in Eclipse (ADT) and Microsoft Fabric pipelines on F64 capacity, promoted Dev → Test → Prod with deployment pipelines.
- Power BI for production (OEE, scrap, downtime), stock, material movements, daily deliveries and procure-to-pay, used by around 70 people through a Power BI App with row-level security.
- Cut manual reporting by 60% by automating ETL and model refreshes, and built predictive downtime indicators for maintenance teams.
Data Architect & Analytics Lead
Apr 2024 – Present

The Bredge · Data consulting · Remote, part-time
- Set BI delivery standards across client environments; leadership dashboards improved resource-planning accuracy by 45%.
Chief Operating Officer
Oct 2021 – Jul 2024

Greysoft Technologies · IT services · Part-time
- Built a central analytics layer across finance, delivery and HR that cut reporting cycles by 50%; cohort analysis behind a 17% rise in renewals.
Data Analyst
Jan 2023 – Jun 2024

Active Technology Innovation · BI consulting · Part-time
- Public health and education analytics on 50,000+ records a month; quadrupled self-service report generation.
Data Science Instructor
Aug 2020 – Sep 2022

Natview Foundation · Kad ICT Hub · Part-time
- Trained 150+ early-career professionals in analytics and machine learning on Nigerian public health data.

Education

BTech, Statistics: Federal University of Technology, Akure · 2015 – 2019

Certifications

365 Data Science: Machine Learning in Python · Web Scraping & API Fundamentals · Advanced Excel
Product School: How to Build Digital Products

Download full CV (PDF)

Contact

Let's talk about your SAP data.

Open to Lead BI, Data Engineer and Analytics Engineer roles in the UK (Skilled Worker sponsorship) or remote. Based in Lagos, available during UK business hours.

michealayo632@gmail.com LinkedIn GitHub Download CV