Open to New Opportunities

Daniel Chuks
Ugbajah

Supply Chain Data / Material Analyst
Inventory Optimization & Procurement Analytics

Turning supply chain data into smarter, sustainable, and cost-efficient decisions.

View Projects Research Download Resume Contact Me
Daniel Chuks Ugbajah
DCU
$15K+ Vendor Credits Recovered
40% Reporting Time Reduced
55K+ Healthcare Records Modeled
180+ Countries Analyzed
Who I Am

About Me

Supply Chain & Materials Analyst with dual Master's degrees in Logistics Systems Engineering and International Management.

Skilled in SAP S/4HANA (MM/WM), Material Master data quality, S&OP planning, inventory accuracy, and data-driven procurement. I combine analytics (Power BI, Excel, SQL, Python) with strong supply chain domain knowledge to improve operational efficiency, reduce costs, and optimize material flow.

Experienced across energy, pharmaceutical, FMCG, and academic research environments supporting S&OP, inventory accuracy, warehousing, and procurement performance.

⚡
Operations-First Real-world experience from refinery to pharmaceutical to FMCG
📊
Data-Driven Power BI, SQL, Python, SAP analytics for operational insights
🌿
Sustainability-Focused Circular economy, ESG metrics, and sustainable procurement

Get In Touch

📍 Toledo, Ohio — Open to Relocation & Remote
📧
📞 +1 567 413 0927
150+ Pharma SKUs
10% Stockout Reduction
Academic Background

Education

M.Sc.

Logistics Systems Engineering

Bowling Green State University — Bowling Green, USA

08/2023 – 04/2025 GPA: 3.8

Advanced study in supply chain systems, logistics optimization, sustainable operations, and research methodology applied to real-world logistics and industrial engineering challenges.

📄 View Transcript
M.A.

International Management Supply Chain Major

University of Applied Sciences (HTW Dresden) — Dresden, Germany

03/2020 – 10/2021 GPA: 3.45 (USA) | 2.4 "Gut"

International management with a supply chain specialization covering global procurement, cross-border logistics, strategic sourcing, and sustainable operations management.

📄 View Transcript
Exchange

Study Abroad Experience

ESCE International Business School — Paris, France

08/2020 – 01/2021

International exchange program at ESCE — École Supérieure du Commerce Extérieur, focusing on international business, global trade, and cross-cultural management.

📄 View Transcript
B.Sc.

Accounting

University of Calabar — Nigeria

02/2011 – 12/2015 Second-Class Upper Division

Foundation in financial accounting, auditing, management accounting, and business administration. Built core analytical and compliance skills applied throughout career.

📄 View Transcript
Portfolio

Featured Projects

Click any project to view the full interactive dashboard and SQL/Python code documentation.

01 Sales Intelligence

🍾 Beverage Category Sales Intelligence Dashboard

Advanced Excel Google Colab Python Power BI DAX
📄 View Full Dashboard & Code

Built an interactive Power BI dashboard analyzing multi-year warehouse sales, retail sales, transfers, and supplier distribution across four beverage categories. Applied advanced DAX measures, KPIs, and time-series visuals to identify category performance trends, with Beer leading warehouse sales at $6.53M and Liquor dominating retail activity.

389 suppliers analyzed across 4 beverage categories (2017–2020)
Beer captured 37.94% of 2019 warehouse sales ($6.53M)
Automated data cleaning in Google Colab for faster insight generation
Total warehouse sales: $7.81M | Total retail sales: $2.15M
02 Healthcare Analytics

🏥 Healthcare Patient Analytics Dashboard

SQL Server Power BI DAX Python Advanced Analytics
📄 View Full Dashboard & Code

Designed a comprehensive end-to-end healthcare analytics solution analyzing 55K+ patient admissions across 400 bed spaces and 40K+ doctors. Developed interactive dashboards with complex DAX measures to analyze patient demographics, admission patterns, insurance coverage distribution across five major providers, and medication distribution.

54,970+ admitted patients | 40,340+ doctors | 39,880+ hospitals
Urgent 33.46% | Elective 33.61% | Emergency 32.93% breakdown
5 insurance providers: Cigna, Medicare, UnitedHealthcare, Blue Cross, Aetna
Avg billing $25.54K | Avg admission 15.5 days | Avg patient age 51.54
03 Sales Performance Analysis

🍕 Pizza Sales Performance Analysis

SQL Server Power BI Advanced DAX CTEs Window Functions
📄 View Full Dashboard & Code

Built a comprehensive sales analytics dashboard analyzing 49,574 pizzas across 21,350 orders with $817.86K total revenue. Performed temporal analysis using SQL CTEs and window functions to identify peak ordering periods. Delivered actionable best/worst seller insights for inventory optimization and menu strategy decisions.

Friday is peak day (3,538 orders); July is peak month (1,935 orders)
Thai Chicken Pizza leads revenue at $43,434.25; Brie Carre is lowest
Classic category: 26.91% of sales | Large size: 45.89% of sales
Avg order value $38.31 | Avg 2.32 pizzas per order
04 Global Supply Chain

🌎 Global E-Commerce Supply Chain Dashboard

Python Pandas NumPy SQL Server Power BI
📄 View Full Dashboard & Code

Conducted multi-dimensional analysis of $36.78M in sales across 180+ countries and 65,750 orders. Created interactive Power BI dashboards evaluating market performance, delivery efficiency, and customer segmentation. Identified critical supply chain issues including 54.71% late delivery rate and 17.86% on-time delivery across global markets.

$36.78M total sales | 65,750 orders | $3.73M total discounts analyzed
Europe leads with 29.56% market share ($10.87M)
Consumer segment: $19.1M (51.91%) | 170K+ discounted items tracked
Delivery performance analytics across 5 global markets & 23 regions
Academic Work

Research

🔎

Research Focus

My research focuses on leveraging data analytics, artificial intelligence, optimization techniques, and digital technologies to build sustainable, resilient, and intelligent supply chains that support circular economy principles, operational excellence, and evidence-based decision-making.

Future Research Directions

🤖 AI Agents for Supply Chain Automation
🛠 Autonomous Procurement Systems
🔭 Sustainable Supply Chain Digital Twins
♻ Circular Supply Chains for SMEs
📉 Smart Inventory Management using AI
🏥 Healthcare Supply Chain Optimization
⛽ Energy & Refinery Supply Chain Analytics
🤝 Human-AI Collaboration in Supply Chain
🌐 Resilient Global Supply Chain Networks
🌿 Sustainable Logistics for Developing Economies

Research Works & Publications

January 2017
Journal Article

Forensic Accounting Education in Nigeria: The Perspectives of Academics

A survey of Nigerian accounting academics finds strong agreement that forensic accounting can curb fraud, but universities are not yet ready to teach it due to manpower shortages, resulting in limited curriculum coverage.

Forensic Accounting Nigeria Education Fraud Prevention
January 2017
Survey Study

Opinion and Behavior of Nigerian Undergraduate Students Towards Forensic Accounting for Fraud Prevention and Detection

A nationwide survey shows most Nigerian accounting undergraduates are aware of forensic accounting, view it positively, and believe it enhances their ability to prevent and detect fraud, highlighting the need for skilled academics to teach it effectively.

Undergraduate Survey Fraud Detection Nigeria
October 2021
Masters Thesis — HTW Dresden, Germany

Circular Economy and Its Effect on Sustainability: An Overview of Its Adoption, Implementation, and Measurement in Relation to the European Commission New Circular Economy Action Plan (CEAP) 2020

The study examines how the EU's Circular Economy Action Plan 2020 is being implemented and measured globally, finding growing corporate adoption and effective indicators that support sustainability, waste reduction, and Europe's goal of climate neutrality.

Circular Economy EU CEAP 2020 Sustainability Waste Reduction Masters Thesis
April 2025
Masters Capstone — Bowling Green State University

Circular Economy and E-Waste: Assessing the Ease to Adoption and the Impact of the European Union Right to Repair and Circular Activities on Sustainability

This study evaluates how the EU Right to Repair policy and circular economy practices influence e-waste reduction and sustainability, finding strong progress and a positive CE–RtR link among leading tech firms, though adoption gaps remain due to repair accessibility, design, and affordability barriers.

E-Waste Right to Repair Circular Economy EU Policy Capstone Project
Technical Expertise

Core Technical Skills

📊

BI & Visualization

Power BITableauGA4DatabricksDAXKPI Dashboards
🗃

Database & SQL

SQL ServerAzure SQLT-SQLCTEsWindow FunctionsSSRS
🛠

ERP Systems

SAP S/4HANASAP MMSAP WMSSAP AribaMRPP2PGR/IR
💻

Programming

PythonSQLJavaPandasNumPyMatplotlibSciPy
📄

Analytics Tools

Excel Power QueryPower PivotETL PipelinesData ModelingStar Schema
☁

Cloud Platforms

Azure SynapseAzure Data LakeAzure SQL
📚

Supply Chain Ops

S&OP PlanningDemand ForecastingInventory OptimizationRFQ/RFPSupplier ScoringOTIF
🌿

Sustainability & Research

Circular EconomyESG MetricsCarbon FootprintIndustry 4.0/5.0Optimization Models
Professional Development

Certifications

Continuous learning across supply chain, data analytics, ERP systems, and business intelligence.

🎓

Google Data Analytics Professional Certificate

Google / Credly
View Certificate ↗
📊

Power BI Data Visualization & Dashboard Tips, Tricks & Techniques

LinkedIn Learning
View Certificate ↗
💻

Pandas Essential Training

LinkedIn Learning
View Certificate ↗
🛠

Exploring Basic Data for Manufacturing & Product Management in SAP S/4HANA

SAP Learning
View Certificate ↗
🛠

Going Deeper with SAP S/4HANA Embedded Analytics

SAP Learning
View Certificate ↗
🛠

Exploring Operational Procurement in SAP S/4HANA

SAP Learning
View Certificate ↗
🗃

ETL in Python and SQL

LinkedIn Learning
View Certificate ↗
🗃

Introduction to SQL

Sololearn
View Certificate ↗
📄

Advanced Microsoft Excel

LinkedIn Learning
Verified
📄

Excel Essential Training (Microsoft 365)

LinkedIn Learning
View Certificate ↗
📚

Supply Chain Foundations: Sales & Operations Planning (S&OP)

LinkedIn Learning
View Certificate ↗
📚

Supply Chain Beyond the Basics: Building System Dynamics Models

LinkedIn Learning
View Certificate ↗
📚

Explore a Career as a Supply Chain Manager

LinkedIn Learning
View Certificate ↗
📈

Build Your Analytical Skills with Statistical Analysis

LinkedIn Learning
View Certificate ↗
📉

Automated Data Governance in Practice

LinkedIn Learning
View Certificate ↗
Let's Connect

Get In Touch

Looking for help with supply chain analytics, procurement visibility, inventory optimization, or dashboard development? Let's connect.

📧
📞
📍
Location Toledo, Ohio — Open to Relocation & Remote
Download Resume