Return to Project Vault

Software Architect & Full-Stack Developer | NSCE (2025)

Executive Summary

Delivered architectural governance, schema refactoring, and query performance optimization for North South Consultants Exchange (NSCE). The platform serves institutional donors (including UN, GIZ, and EU programs) to track, audit, and evaluate multi-sector regional development projects.

1. Context & Problem

  • ->Client / Domain: North South Consultants Exchange (International Development)
  • ->Timeline: 2025-2026
  • ->Project Role: Software Architect & Full-Stack Developer

//The Challenge

Conflicting translation plugin data models caused metadata corruption and duplicated keys across multi-language project records. Concurrently, nested multi-tier faceted searches (filtering by sector, donor entity, and geographic regions) triggered un-indexed wp_postmeta table scans that degraded server response times and lowered search engine indexing coverage.

2. Technical Stack & Implementation

  • ->Application Framework: WordPress with PHP 8.x and normalized Advanced Custom Fields (ACF) schemas.
  • ->Database & Indexing: MySQL InnoDB with optimized composite indexes on relational meta tables.
  • ->Edge & Infrastructure: WP Engine managed infrastructure with Cloudflare edge caching rules.

3. Architectural Decisions & Engineering Challenges

  • ->Multilingual Schema Normalization: Re-architected fragmented postmeta attributes into a canonical ACF schema, separating translation mapping into a dedicated relation ledger to prevent race conditions during concurrent updates.
  • ->Faceted Search & Geographic Filtering: Restructured backend queries to bypass un-indexed postmeta table scans using secondary indexed tables and custom MySQL join strategies. Built a dual-tier geographic engine supporting global country-level visualization and Egypt governorate-level filtering.
  • ->Edge Caching & Performance Tuning: Deprecated redundant third-party plugins, refactored data access paths using native PHP 8.x constructs, and aligned HTTP caching headers with Cloudflare edge workers to accelerate Time to First Byte (TTFB).

4. Operational & Institutional Impact

  • ->Search Engine Impressions: Increased organic search visibility to over 20,000 monthly impressions following TTFB and schema remediation.
  • ->Data Consistency: Established 100% data consistency across multilingual datasets for institutional donor reporting.
  • ->Database Efficiency: Substantially reduced database memory load and query execution times during concurrent multi-filter searches.