Return to Project Vault

Full-Stack Engineer | North South Consultants Exchange (NSCE) | 2025 - 2026

//Context & Scale

North South Consultants Exchange (NSCE) is an international development consultancy conducting monitoring, evaluation, and policy advisory for institutional donors including UN agencies, GIZ, and European Union programs. The platform tracks complex, multi-sector regional aid and development initiatives across Africa and the Middle East. Conflicting multilingual plugin data models corrupted metadata keys and duplicated entries across English and Arabic project records. Simultaneously, nested multi-faceted searches (filtering across funding agencies, development sectors, and geographic territories) triggered un-indexed wp_postmeta full-table scans that spiked database CPU usage and slowed Time to First Byte (TTFB). Retained as Full-Stack Engineer across 2025 and 2026 to resolve data corruption, refactor search queries, and optimize performance.

//Architectural Decisions

  • ->Canonical Schema Normalization: Re-engineered fragmented custom field data into a canonical ACF schema, decoupling language translations from core project metadata to eliminate race conditions and key collisions during concurrent editorial updates.
  • ->Indexed Faceted Search Architecture: Restructured backend data access to bypass un-indexed postmeta table scans, introducing custom indexed relationship tables and targeted composite indexes on taxonomy and meta attributes.
  • ->Dual-Tier Geographic Filtering Engine: Designed a hierarchical geographic data model supporting multi-criteria filtering across continental country jurisdictions and localized Egyptian governorates within a single unified query pipeline.
  • ->Edge Caching and Asset Optimization: Replaced legacy plugin bloat with native PHP 8.x constructs and aligned HTTP cache headers with Cloudflare edge rules to maximize edge cache hit ratios.

//Engineering Execution

  • ->Automated Metadata Migration: Authored idempotent SQL migration scripts that deduped and normalized thousands of legacy project metadata rows across bilingual records without data loss.
  • ->Direct SQL Join Optimization: Replaced sequential WP_Query meta-array filters with optimized direct SQL joins, reducing execution times on complex multi-parameter searches.
  • ->Infrastructure Alignment: Configured WP Engine PHP 8.x worker process limits and Cloudflare Page Rules to cache semi-static filtered archive pages at edge points of presence.

//Measurable Impact

  • ->20,000+ Monthly Organic Search Impressions: Accelerated page delivery and normalized structured data schemas, expanding organic search visibility to over 20,000 monthly impressions.
  • ->100% Data Integrity: Eliminated translation corruption and duplicate postmeta keys across all bilingual donor project records.
  • ->Substantial Query Latency Reduction: Composite indexing and custom join queries bypassed full-table scans, drastically reducing MySQL CPU utilization during peak search traffic.