Skip to content
View Ofrank-design's full-sized avatar
🧑‍🎓
Studying
🧑‍🎓
Studying

Block or report Ofrank-design

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
ofrank-design/README.md
b232ef05-4a4a-4207-9764-d5f1c7c6ee4a 🌐 Live Portfolio

▶ Visit my Portfolio →

🛠️ Procurement & Logistics Toolkit

A free, browser-based toolkit for supply chain and procurement professionals no login, no install, no cost.

▶ Live Demo →

📊 SCM Projects Python & JavaScript

Two practical supply chain projects built from scratch a KPI dashboard in Python and a procurement quiz game in JavaScript.

▶Life Demo →

Kiran1689

Student Year Location Portfolio Focus Goal

Tech Stack

📦 Procurement & Supply Chain

Ghana PPA Ghana e-GP EOQ Modelling ABC Analysis Contract Management Strategic Sourcing

📊 Analytics & Tools

Microsoft Excel Power BI Python JavaScript HTML5

⚙️ ERP Systems

SAP MM Odoo Oracle Cloud MS Dynamics 365

🛠️ Dev & Productivity

GitHub VS Code Microsoft Learn Matplotlib

Hi, I'm Frank Oduro 👋

"Bridging academic theory with hands-on supply chain innovation from Day 1."

I am a Procurement and Supply Chain Management student at Kumasi Technical University (KsTU), enrolled in October 2026. Rather than relying solely on traditional coursework, I am proactively utilizing this GitHub repository as a digital portfolio to document practical applications of my learning ahead of my 2030 graduation.

💼 What I am Building

Here, you will find active projects focused on public data, operational transparency, and operational efficiency:

  • Data-Driven Dashboards: Live analytical tools built utilizing Ghanaian public sector procurement data.
  • Enterprise Resource Planning (ERP): Simulated end-to-end ERP transaction workflows and inventory models.
  • Contract Management: Standardized Service Level Agreements (SLAs) and automated supplier scorecards.

My goal is to graduate with a verified track record of technical competence, providing prospective employers and collaborators with transparent, measurable evidence of my strategic procurement skills.


🛠️ Technical Skills

⚙️ ERP Systems

SAP Odoo Oracle Dynamics

Full procure-to-pay cycle: Vendor → PR → PO → GR → Invoice

📊 Procurement Analytics

Excel PowerBI SCOR

Spend analysis · Supplier dashboards · SCOR metrics

📋 Contract Management

Contracts Negotiation

UNDP templates · Framework agreements · KPI benchmarking

⚖️ Compliance & Ethics

Ghana UN

Ghana e-GP portal · ESG sourcing · Public procurement law

📦 Inventory & Logistics

EOQ ABC Incoterms

Safety stock · Demand forecasting · Reorder points

🎯 Strategic Sourcing

Category TCO

CIPS 7-step framework · Make-vs-buy · Competitive tendering


📁 Portfolio Projects

# Project Skills Status
01 ERP: SAP MM Procure-to-Pay Workflow SAP S/4HANA · Full P2P cycle 🔵 Year 2 · 2027
02 Contract Management: Mock SLA & Negotiation UNDP templates · 5-page SLA 🔵 Year 2 · 2027
03 Supplier Scorecard & KPI Dashboard Excel · Power BI · 10 vendors 🟣 Year 3 · 2028
04 ✅ Inventory Optimization Model Excel · EOQ · ABC · Safety Stock ✅ Completed
05 Procurement Analytics: Ghana Spend Dashboard Power BI · Ghana e-GP data 🟣 Year 3 · 2028
06 Strategic Sourcing: IT Category Plan CIPS 7-step · TCO model 🟡 Year 4 · 2029
07 Compliance & Ethics: Tender Risk Assessment Acts 663 & 914 · Risk matrix 🟣 Year 3 · 2028

▶ View Full Portfolio →

🎓 Certifications

17 free, self-paced certifications mapped to 7 projects and 28 KSTU modules.

Program Provider Status
✅ Inventory Management Certificate HP LIFE Completed
✅ Business Communication Certificate HP LIFE Completed
✅ Agile Project Management HP LIFE Completed
⏳ Excel & Data Analysis Learning Path Microsoft Learn In Progress
SAP ERP Essential Training openSAP Year 2
Law and Contract Management OpenLearn Year 2
Power BI Learning Path Microsoft Learn Year 2
Supply Chain Analytics World Bank Year 3
Strategic Sourcing & Category Management CIPS Year 3
E-Procurement Learning Program World Bank Year 3
Procurement and Contract Management UniAthena Year 3
ESG & Sustainable Business Practices UN Global Compact Year 3–4
Global Logistics & SCM World Bank Open Learning Year 2–3
Data Analysis with Python IBM Cognitive Class Year 3
Lean Six Sigma White Belt 6sigmastudy Year 3
Oracle Procurement Cloud Fundamentals Oracle University Year 2
Microsoft Dynamics 365 Fundamentals Microsoft Learn Year 4

▶ View Full Certifications →

🗺️ 4-Year Roadmap

2026 ──────────────────────────────────────────────── 2030
  │                                                      │
  ▼ YEAR 1        ▼ YEAR 2       ▼ YEAR 3   ▼ YEAR 4   │
  Foundation      ERP & SLA      Analytics  Specialise  │
  ──────────      ─────────      ─────────  ──────────  │
  ✅ Project 4    Projects 1&2   3, 5, 7    Project 6   │
  Excel mastery   SAP · Oracle   Internship MS Dynamics  │
  Odoo · Acts     Power BI       Dashboard  Thesis      │
  9 Certs         9 Certs        10 Certs   All 17 ✅   │

📈 Supply Chain KPI Dashboard Python

A fully coded KPI dashboard built with Python and matplotlib, visualising six key supply chain metrics for a Ghana public sector context.

Charts included:

  • On-Time Delivery Rate vs target (line chart)
  • Purchase Order Cycle Time (bar chart)
  • Supplier Quality Rate (line + fill)
  • Cost Savings vs Budget — GHS (bar chart, green/red)
  • Inventory Turnover Ratio (line chart)
  • Annual Spend by Category (pie chart)

KPI Scorecard at the bottom summarises December performance at a glance — green for on target, red for below.

SCM KPI Dashboard

⚡ GitHub Stats

GitHub Stats GitHub Streak

Top Languages

🏆 GitHub Trophies

📊 Contribution Graph

Contribution Graph

🤝 Cᴏɴɴᴇᴄᴛ Wɪᴛʜ Mᴇ 🤝

frankoduro1912@gmail.com odee_frank _anonymoustroy ofrank-design linkedin
Buy Me A Coffee

📍 Kumasi, Ghana · KSTU BSc Procurement & Supply Chain Management · Enrolled Oct 2026

“The way to get started is to quit talking and begin doing.”
— Walt Disney

LAST UPDATED: 23TH, JUNE 2026

Pinned Loading

  1. Ofrank-design.github.io Ofrank-design.github.io Public

    Procurement & Supply Chain Portfolio ..Hit a star button if you find it helpful⭐

    HTML 10

  2. procurement-logistics-toolkit procurement-logistics-toolkit Public

    Free browser-based toolkit for professionals EOQ calculator, supplier risk dashboard, logistics cost estimator & Ghana e-GP tender tracker MIT free to use, fork, and adapt. A star is appreciated if…

    HTML 10

  3. Supply-chain-management-TrialProject Supply-chain-management-TrialProject Public

    Supply Chain KPI Dashboard (Python + matplotlib) & Ghana Procurement Quiz Game (JavaScript) built by a Procurement student using Claude template

    HTML 13