terminal
Aug 8
Custom Spring Security Filter Chain
Building a layered security filter chain in Spring Security 6 — JWT validation, IP allowlisting, and request signing.
Read more
Theophilus: Data Analytics & Actionable Intelligence
Theophilus Thobejane:
Building to be a Data Analyst & Business Intelligence Specialist.
Microsoft Certified Data Analyst (PL-300, DP-900, AZ-900) with an ICT background in SQL and Python. What drives me is transforming raw, unstructured datasets into clear, actionable reporting.
Theophilus Thobejane@lab — zsh — 80×24
Theophilus Thobejane@T.ThobejaneLand ~ %
▋
v2.0.0
Last updated: Oct 9, 2026
Scroll to explore
The Journey
Connecting the Dots Between Data and Strategy
Starting with backend logic and relational databases taught me how data behaves beneath the surface. Today, as a certified Power BI and Azure data analyst, I take that technical rigor and apply it directly to business questions. Whether writing optimized SQL queries, structuring cloud data models, or crafting interactive reports, my mission is simple: turning complex numbers into direction and confidence.
Data Modeling & Cloud Foundations
Dependable analytics begins with sound architecture. Grounded in SQL query design, relational data structures, and Azure cloud fundamentals (AZ-900, DP-900), I understand how data is stored, extracted, and scaled. Clean schemas, data validation, and query optimization are my baseline for building trustworthy analytical systems.
Power BI & Business Intelligence
As a certified Power BI Data Analyst (PL-300), I transform complex tables into intuitive, interactive reporting systems. From star-schema modelling and custom DAX measures to automated refreshes, I build visual dashboards that empower stakeholders across teams to explore data and make decisions with confidence.
Problem Solver First
Behind every trend, metric, or outlier is an operational reality. I approach analytics by deeply understanding the business context first, then letting the numbers uncover the root causes. Whether it's diagnosing operational bottlenecks or monitoring core KPIs, the focus is always on delivering directional clarity.
philosophy.md
// My approach to software engineering
const philosophy = {
buildForScale: true,
automateEverything: true,
teachWhileLearning: true,
measureImpact: "94% RAG accuracy | 90.07% stock prediction | 70% pre-booking automation | 6 production projects",
currentStack: ["Python", "Node.js", "FastAPI", "PostgreSQL", "LLMs/RAG"]
};
Artifacts
Technical Projects
Production systems built for real clients and real problems — AI pipelines, delivery platforms, verification tools, and data models. Not tutorials. Not clones.
Arsenal
Technical Stack
Technologies I use to build production-ready systems. From databases to AI pipelines.
Data & Storage
PostgreSQL
Production
PostgreSQL
Production
MySQL
Advanced
MySQL
Advanced
Redis
Proficient
Redis
Proficient
MongoDB
Proficient
MongoDB
Proficient
Frameworks
Spring Boot
Production
Spring Boot
Production
Spring Cloud
Advanced
Spring Cloud
Advanced
Hibernate/JPA
Advanced
Hibernate/JPA
Advanced
Quarkus
Proficient
Quarkus
Proficient
Languages
Java
Production
Java
Production
SQL
Advanced
SQL
Advanced
Python
Proficient
Python
Proficient
Bash/Shell
Proficient
Bash/Shell
Proficient
Git
Git
Docker
Docker
REST APIs
REST APIs
Maven/Gradle
Maven/Gradle
CI/CD
CI/CD
JUnit 5
JUnit 5
OpenAPI
OpenAPI
Microservices
Microservices
Linux
Linux
Kubernetes
Kubernetes
AWS
AWS
The Path
Experience & Education
From student to teacher to builder. Every step taught me something about code, systems, and people.
Feb 2021 - Nov 2023
National Diploma in Information & Communication Technology (NQF-6)
University of Mpumalanga
Built core foundations in computer science, software logic, relational databases, SQL querying, and Python. Developed the technical discipline and analytical mindset that sparked my journey into data architecture and reporting.
Feb 2024 - Nov 2025
Advanced Diploma in Information & Communication Technology (NQF-7)
University of Mpumalanga
Advanced technical studies focused on enterprise database systems, systems analysis, and architectural design. Strengthened relational data modelling, query optimization, and structured analytical problem-solving.
Feb 2024 - Mar 2026
Developer to BI & Dashboard Specialist
Independent Projects & Solutions
While building full-stack applications, realized my strongest passion was on the data and visualization side—transforming complex backend records into intuitive dashboards. Focused on eliminating information overload for decision-makers by designing clean KPI summaries, automated reporting views, and structured SQL data models.
Feb 2026 - Sep 2026
Microsoft Certified: PL-300, DP-900 & AZ-900
Microsoft
Validated my end-to-end data and cloud skills by earning official Microsoft credentials: Power BI Data Analyst Associate (PL-300), Azure Data Fundamentals (DP-900), and Azure Fundamentals (AZ-900). Deepened expertise in star-schema data modelling, custom DAX measures, and cloud database systems.
Aug 2026 – Present
Azure Cloud & Data Trainee
Mecer Inter-Ed
Selected for the high-impact Azure skills acceleration programme funded by MICT SETA. Focusing on enterprise cloud services, cloud data architectures, and end-to-end data pipelines in Microsoft Azure while expanding real-world enterprise problem-solving capabilities.
Field Notes
Development Notes
Quick observations, experiments, and discoveries from the digital laboratory.
database
Aug 8
JPA N+1 Problem — Debug Approach
How I found and fixed a catastrophic N+1 query problem using Hibernate's SQL logging and query count assertions.
Read more
cpu
Aug 8
Java Virtual Threads (Project Loom)
Experimenting with Java 21 virtual threads — massive throughput improvement for I/O-bound tasks with near-zero thread overhead.
Read more
Current Focus
Workbench
What's currently on the workbench — active projects, experiments in progress, and things being built.
workbench.status
TheoCodes Portfolio
85%
Building and personalising this portfolio site — dynamic content, admin dashboard, and chatbot integration.