Student Onboarding Optimization
DMAIC methodology applied to reduce onboarding cycle time and improve data quality for Nigerian EdTech startup
D
Define
Problem Scoped
M
Measure
Baseline Set
A
Analyze
Root Causes Found
I
Improve
Solutions Deployed
C
Control
Monitoring Active
Onboarding Cycle Time
72 hrs
18 hrs
75% reduction
Data Quality Score
67%
93%
+26% improvement
Manual Touch Points
12
3
75% eliminated
Hours Saved Weekly
40+
~$2,000/month saved
Process Flow Improvement
Before vs After DMAIC
1
Student Registration Form
5 min → 2 min
2
Manual Data Entry to Sheet 1
15 min
3
Copy to Master Spreadsheet
10 min
4
Data Validation & Dedup
45 min → Instant
5
HubSpot CRM Import
30 min → 2 min
6
Welcome Email Sequence
Manual → Auto-trigger
Root Cause Analysis
Fishbone Diagram Findings
People
Inconsistent data entry
No standard training
Multiple handoffs
Process
12 Google Sheets
No single source of truth
Manual deduplication
Technology
No CRM system
No automation
Fragmented tools
Data
Duplicate records
Inconsistent formats
Missing fields
Cycle Time Control Chart
Statistical Process Control (Post-Implementation)
Upper Control Limit
24 hrs
Mean
18 hrs
Lower Control Limit
12 hrs
Project Savings
Annual impact breakdown
Time Saved
2,080 hrs
Cost Savings
$24,960
Efficiency Gain
+312%
Lean Six Sigma Green Belt Certified
This project demonstrates DMAIC methodology, root cause analysis, process mapping, and statistical process control.
Data Quality Improvement Over Time
Defect rate tracking through DMAIC phases