Infrastructure & Security

Multi-Site Pharmacy Infrastructure

Systems and network-security operations across a large multi-site pharmacy environment.

EnvironmentZahrat Al-Rawdah Pharmacies
Period2019-2022
LifecycleHistorical / completedHistorical delivery from the 2019–2022 Zahrat Al-Rawdah Pharmacies operating period. Technologies and scale are presented as historical production context rather than current-stack claims.
Multi-Site Pharmacy Infrastructure architecture representation for Infrastructure & Security
Architecture RepresentationHistorical operating-model visual representing enterprise-scale pharmacy infrastructure, centralized systems and repeatable branch technology patterns.
Project overview

Multi-site pharmacy technology operations delivered at enterprise scale

Systems administration and network-security operations supporting a large pharmacy estate of 150+ branches across 10+ cities, combining branch connectivity, FortiGate security, Hyper-V infrastructure, Solver ERP and SQL Server operational support.

StatusHistorical / completedEnvironmentZahrat Al-Rawdah PharmaciesPeriod2019-2022
Context & challenge

The operating need

A geographically distributed pharmacy business needed repeatable branch technology operations, reliable connectivity, centralized systems support and consistent security practices across a large and growing footprint.

Role & responsibility

Ahmed's contribution

Ahmed supported systems administration, network security and multi-site rollout operations, including FortiGate environments, Hyper-V infrastructure, Solver ERP support, SQL Server backup/restore tasks, endpoint upgrades and branch go-live readiness.

Solution

How the work was approached

Environment: Zahrat Al-Rawdah Pharmacies, 2019–2022, spanning 150+ pharmacies across 10+ cities with central and branch technology dependencies.

A repeatable multi-site operating model combined standardized branch connectivity, security appliances, centralized virtualization, ERP/SQL support and disciplined rollout/handover practices so branch technology could scale without becoming completely bespoke at each location.

Execution highlights

  • Supported FortiGate-based branch and central connectivity/security across a large multi-site pharmacy footprint.
  • Operated Hyper-V infrastructure and supported Windows and application services in the central environment.
  • Supported Solver ERP and SQL Server operational tasks, including backup/restore activities and troubleshooting around business-system availability.
  • Participated in repeated branch openings and technology rollouts covering network, endpoints, ERP readiness, CCTV, UPS, access/attendance and operational handover.
Security & operational controls

Designed for responsible operation

  • Public material excludes branch IP addresses, firewall policies, credentials, VPN secrets, database contents and private vendor or user information.
  • Historical technologies are labeled as historical production experience and are not presented as the user’s current stack.
  • The public visual represents scale and operating model rather than a literal security topology.
Key decisions

Choices that supported the outcome

  • Favor repeatable branch patterns over one-off configurations to make rollout and support more scalable.
  • Keep virtualization, ERP/SQL operations and branch network/security support connected through one operating model instead of treating them as isolated silos.
  • Preserve local operational handover while maintaining centralized standards for connectivity, security and core systems.
Lessons

What the work reinforced

  • At multi-site scale, consistency in branch patterns reduces troubleshooting time and deployment risk.
  • ERP availability depends on more than the application itself: branch connectivity, SQL operations, endpoints and local readiness all matter.
  • Large branch estates require repeatable rollout, documentation and support discipline to stay manageable.

Delivery status

Current project maturity

Implemented, validated, in-progress and planned elements are shown separately where the project is still evolving.

IMPLEMENTED

Historical production operations covered branch connectivity/security, Hyper-V infrastructure, Solver ERP/SQL support and repeated branch rollouts.

VALIDATED

Historical production scope from the 2019–2022 Zahrat period, retained as prior enterprise-scale operating experience rather than a current-stack claim.

Technology

Technology used in this work

The stack and platforms associated with this project.

FortiGatehistorical production
Hyper-Vhistorical production
Safetica DLP
Solver ERPhistorical production
SQL Serverhistorical production
About the project visuals

Historical operating-model visual representing enterprise-scale pharmacy infrastructure, centralized systems and repeatable branch technology patterns.

Production topology, IP addresses, firewall rules, credentials, VPN secrets, database content and private vendor/user information are intentionally excluded.

Copied