Ahmed Mahmoud Swid

Professional Summary

Business & Data Analyst with 5+ years at Riyadh Municipality, turning operational data into decision-ready dashboards and KPIs. Designed and delivered BI platforms governing SAR 179.3M in maintenance contracts, and automated executive reporting end to end — from data cleaning to daily delivery with no manual step. Skilled in Power BI, DAX, Power Query, SQL and Excel across data modelling, dashboard design and workflow automation. PMI CAPM® certified; delivered over 360 hours of hands-on Power BI workshops to 150+ staff, and authored their material.

Skills

Experience

• ●Built a 34-screen operations platform running SAR 179.3M of street-lighting maintenance contracts for the Wasat sector — from data cleaning to the decision board, as sole analyst, designer, developer and operator.
• ●Automated the seven-page daily executive report so it reaches the director by email and Telegram with no human in the loop, replacing manual preparation every morning.
• ●Replaced subjective contractor assessment with one objective yardstick across eight maintenance contracts: spend rate against elapsed duration, safety score, and deducted penalties.
• ●Ran a risk analysis of the lighting network — 60,658 poles and 445 stations classified into five risk tiers from resistance and leakage readings — so repair priority rests on measurement rather than judgement.

Key Projects

• Wasat Sector Platform — Street-Lighting Maintenance

  Riyadh Municipality · General Directorate of Infrastructure

  A 34-screen operations platform running SAR 179.3M of maintenance contracts: automated data cleaning, a field map of 7,709 complaints across eight zones, an objective contractor scorecard, EVM forecasting, and an analytical assistant plus a daily executive report delivered to the director automatically.

  Next.js · TypeScript · Supabase/PostgreSQL · Claude · n8n · Leaflet

• North Sector Enterprise System

  Riyadh Municipality

  An 8-dashboard analytics platform with self-serve Excel ingestion, RBAC, a Telegram analytical assistant, and scheduled email reports and alerts.

  Next.js · Claude · Supabase · n8n · RBAC