Galal Sabry

Project: Qassim Municipality GIS Supply and Installation

Client: Qassim Municipality (QM) - KSA

Scope: Design and Construction supervision of the initiative related to flood mitigation and protection along stormwater drainage system for Qassim Municipality - Buraydah city, in addition to GIS technical support for all municipality GIS projects which includes:
▪ Stormwater network
▪ Roads and Bridges Network
▪ Irrigation and Gardens Network
▪ Electric Street Light Network
▪ Hydrological Studies
▪ Building Execution
▪ GIS for Investment Opportunities
▪ Buraydah City Assets Survey Project
▪ Levelling Project for Building Permit / Construction License
▪ Linking transactions acceptance with Flood Valleys Streams
▪ Linking urban development with the local and detailed plans of Buraydah city.
▪ Al-Qassim Province Land use / Land cover management and information

Position: GIS Consultant / Qassim Municipality GIS Technical Manager

Responsibilities:
• Provide overall project GIS planning, management and advisory
• Develop strategies for project consultancy
• Geodatabase Design, Development & Management
• Conversion and QA/QC of Backlog Projects
• Confirm user requirements specification (URS) & consultancy services
• Prepare schedules and take-off timetables along technical specifications & plans for GIS system design, data modeling, migration strategy, field survey & data capture, field verification/validation, geo-spatial data rectification, data conversion, QA/QC & data acceptance framework including hardware & software configuration recommendations
• Management and coordination of all project sub-contractors & business partners including HW/SW Providers/Dealers and data conversion vendor
• Monitoring performance and workflows regarding the organization plans; establishing immediate actions to solve any deviations from QM plans ensuring meeting the project milestones and time frame
• Approve/Supervise contractors’ submission of the Project GIS Invoices
• Hydrological analysis reinforcement using various GIS analysis Techniques
• Cartographic design for high quality map production
• Plan & Conduct GIS Presentations / Orientation Seminars, Requirements Analysis & Data Modeling Workshops
• Provide onsite and offsite technical advisory and project management support
• Conduct training for QM users regarding the GIS packages & applications
• Conducting demos and presentations on the GIS web applications and respond to queries from the QM PM along related engineers
• Manage/Track the workflow for each GIS related department in QM.
• Monitoring performance against data conversion process; including statistical reports about the Geodatabase status & QM staff editing progress

Project: EEHC DCCs GIS supply with SCADA integration
Client: Egyptian Electricity Holding Company (EEHC) - Egypt
Scope: Establishing and maintaining a turnkey solution of a functioning state-of-art GIS enterprise system for two distribution control centers (DCC) in Dokki and 6th of October
along the related electrical network using Esri technology to be integrated with Supervisory Control And Data Acquisition (SCADA) system.
Position: GIS Consultant
Responsibilities:
 Provide overall project GIS planning, management and advisory
 Develop strategies for project consultancy & implementation phases
 Confirm users requirements & consultancy services
 Prepare technical specifications & plans for GIS system design, data modeling,
migration strategy, field survey & data capture, field verification/validation, geo-
spatial data rectification, data conversion, QA/QC & data acceptance framework
including hardware & software configuration recommendations based on EEHC
requirements
 Ensure a fair & competitive tender process to allocate appropriate contractor
company for the project realization
 Ensure timely & effective implementation of the project meeting spatial data
directorate & EEHC expectations
 Tendering: Prepare & release RFP & Tender Evaluation & Award
 Supervision of contract during project execution & maintenance
 Plan & conduct GIS orientation seminars, requirements analysis & data modeling workshops
 Management and coordination of all project sub-contractors & business partners including HW/SW Providers/Dealers and data conversion vendor
 SLD data update and synchronization
 Training, capacity building & onsite support for EEHC GIS community

*Maintain and Develop the GIS strategic plan for GWWC departments
* Prepare priority scenarios and alternative implementation scenarios
* Develop GIS policies and procedures
* Geodatabase Development & Data Management
* Manage & Supervise the Data Development track including network digitizing, editing
& validation, backlog management including CAD to GIS conversion, Basemap /
Network updating, Data QA/QC, Data Testing & Analysis, Survey field tasks and
developing the required applications providing the required technical support
* Maintaining GIS data quality and integrity to support high-quality analysis, facilitate
sharing and for a smarter decision-making process using the following QA/QC tools
and techniques:
1-Reconfiguration & development of the water data model (schema) as well as the water geometric network on a regular basis (i.e. domain values, geometric network connectivity rules) to prevent errors from occurring in the first place
2- Visual data QA to detect systematic errors (i.e. overall shift in the data) as well as random errors (i.e. misspelled text)
3- Automated data QA/QC routines using ArcGIS Data Reviewer, Topology and other customized tools to verify the data accuracy and integrity along maintaining connectivity of the utility geometric network fixing the generated errors
4- Quality control on recently edited data using a versioned geodatabase to identify and resolve potential data issues (i.e. conflicting edits) followed by reconciling and posting the versions edits then compressing and backing up the data
5- Automating repetitive tasks using scripts and geoprocessing models
6- Applying the water utility data management toolbars and extensions such as "ArcFM tools" and "Water Utility Network Editing and Anlaysis" for custom editing and automatic attributes populating
7- Specific data Quality Control checks using spatial and attribute queries
8- Generate data QA/QC reports and certify data quality as per conversion specifications
* Manage GWWC subcontractors & business partners including HW/SW providers
* Monitoring performance and workflows regarding the organization plans;
establishing immediate actions to solve any deviations from GWWC plans
* Supervision and consults contractors submission of GIS & CAD Data
* Satellite imagery / aerial photography Georeferencing and Orthorectification
* Creation of Digital Elevation / Terrain Models (DEM, DTM) & TIN Networks
* Hydraulic analysis reinforcement using various GIS analysis Techniques
* 3D Visualization and Analysis
* Cartographic design for high quality map production
* Prepare plans along writing the related technical documents and specifications
* Conduct training for GWWC users regarding the GIS packages & applications
* Plan & Conduct GIS Presentations / Orientation Seminars, Requirements Analysis & Data Modeling Workshops

Working for five projects for Kuwait (MEW) & (KW Uni.), UAE (ADWEA) & Sultanate of Oman (RAECO) with the following responsibilities:
 Conduct training for users regarding the project GIS packages & applications
 Coordinating GIS-related activities with OM & Design departments
 Prepare & develop procedures and technical specifications for data Assessment, Collection, Validation, Conversion, Migration and QA/QC
 Revising, Updating & Developing of the Utility Data Model and Geodatabase design
 Monitoring performance against plans and establishing resolution actions for any variances from plans ensuring meeting the project milestones and time frame
 Writing technical documents, schedules and take-off timetables
 Conducting demos and presentations
 Inventory, Assessment & Collection of all hard/soft drawings and tabular data (As-builts, Schematic Diagrams, SLD, Sketches, AutoCAD, WaterCAD, manufacturer's specifications, Excel...) through a lot of visits to all water departments
 Performing visual & automated discrepancies identification and gap analysis regarding the collected drawings to identify the required and missing geospatial data to be surveyed
 Managing and Tracking data conversion and migration workflow/editing progress by
supervising the team responsible for converting the collected data into the GIS
system as per data model requirements and specifications (ArcFM Standards)
providing the required technical support
 Loading GIS data into the Enterprise Geodatabase per each project stage
 Prepare project deliverables report per each stage
 Editing and Developing of the Water Network Connectivity Rules
 Performing visual & automated data QA/QC using ArcGIS Data Reviewer, Topology and other customized tools to verify the data integrity along maintaining connectivity of utility’s geometric networks fixing the generated errors
 Generate data QA/QC reports and certify data quality as per conversion specifications
 Geodatabase Administration: Reconciling and Posting all Water Sectors Versions edits on weekly basis solving any detected conflicts followed by data compress & backup
 Generating weekly Version Differences report regarding all Water Sectors Versions
 Customized high quality map production
 Carry out geo-spatial queries and generate statistical reports
 Implementation of CAD to GIS migration process
 Prepare CAD Drawings Submittal Guidelines report to be used by AutoCAD
subcontractors for standardizing submitted as-built drawings
 Coordination with the subcontractors regarding CAD to GIS specifications illustrating how to use the Utility AutoCAD template customized for this process maintaining the
project projected coordinate system
 Revise and approve AutoCAD as-built drawings submitted by subcontractors to match the CAD to GIS specifications for direct loading into the Enterprise Geodatabase
 Testing, Implementing & Installing of the GIS desktop packages & applications:
- Water facility siting (integrated with ArcFM Web Viewer)
- ArcFM Water Trace tools
- KAUSD Desktop Viewer application
- KAUSD CAD to GIS, AutoCAD Xdata
- KAUSD Data Migration application
- ArcGIS
- ArcFM
- Oracle Client 11g R2
 Review and edit the Data Dictionary that applies to the client requirements
 Prepare and Conduct a weekly progress meeting with the organization GIS PM along Water OM & Design sectors to track the strategic plan workflow solving project criticalities and
obstacles
 Coordinating and following up with the survey team regarding the entire Water Transmission Network data accuracy double check including all the assets
 Participating in preparation and modification of the GIS contracts regarding project subcontractors

 Preparation and Implementation of working plan
 Creation and maintenance of the structures necessary for the GIS Data storage
 Management and Administration of ArcServer/ArcSDE
 Technical support for the GIS teamwork
 Preparing & Conducting GIS unit presentations
 Writing technical documents
 QA/QC for Existing & Proposed GIS Master Plans of Water / Wastewater Networks
 Geodatabase Design / Update
 Analyzing the geographic relationships among varying types of data
 Transferring GIS data between different systems
 Maintaining the projected coordinate system for all GWWC GIS data
 Revision and following up of Giza GIS Master plan of Water / Wastewater Networks
 Editing and Updating Giza Governorate Basemap regarding the following regions:
(Imbaba, Sakyet Mekky, Haram, Waraak, 6th of October)
 Creation of Al-Sheikh Zayed Basemap from scratch
 3D Representation of Giza new cities; Al-Sheikh Zayed and 6th of October
 Designing and Implementation of Al-Sheikh Zayed Water and Wastewater GIS
networks from Generation up to customer service connections
 Assistance of Hydraulic Analysis Unit using various GIS analysis Techniques
 Participating with the Master Plan Unit in following up the progress of the new
projects along updating the existing ones

Project: GIS Master Plan For the entire Egyptian transport network
Client: Ministry of Transport and Civil Aviation Authority - Egypt
Responsibilities:
 Preparation and Implementation of working plan
 GIS Data Model and Geodatabase Design / Update
 Supervising & Tracking data conversion workflow
 Geodatabase QA/QC Report
 Technical support for the GIS teamwork
 Writing technical documents
 Preparing & Conducting GIS presentations
 Cartographic design assistance for high quality map production
 Carry out geo-spatial queries and generate statistical reports
 Maintaining the projected coordinate system for all the project deliverables

Project: Potable Water & Sewerage System Master Plan 2037 - Canal cities
Client: Ministry of Housing, Utilities and Urban Development - Egypt
Responsibilities:
 Data collection for all system elements
 Technical support for the team work using GIS programs
 Analysis of the existing Water/Wastewater networks, Pump stations, boosters, force mains & treatment plants
 Transferring GIS data between different systems
 Database Design/Update
 Creation and maintenance of the structures necessary for the GIS Data storage
 QA/QC of the GIS Projects
 System future planning
 Data conversion of AutoCAD files and tabular data into ArcGIS Geodatabase
 Design TICE Brochure Using Photoshop and Freehand

Project: GIS Master Plan For Suez governorate land use and real estate identification
Client: The Ministry of Planning - Egypt
Responsibilities:
 Geodatabase design and creation
 Develop Procedures for digitizing cadastral & building data
 Append data
 Support the data conversion process
 Perform editing activities for manual processes as needed