Basant Mohamed Alsmahy | GIS & Data Analytics Portfolio

🧑‍💻 About Me

GIS & Data Analyst with hands-on experience in ArcGIS Pro, spatial analysis, geodatabase design, topology validation, and coordinate transformation for infrastructure and administrative mapping projects.

Experienced in integrating survey data (GPS & Total Station) with GIS workflows and combining spatial analysis with Excel, Python, SQL, and Power BI to deliver dashboards, thematic maps, and data-driven reports.

Strong focus on spatial accuracy, cartographic standards, and data quality validation.

🛠 Technical Skills

GIS & Spatial Analysis: ArcGIS Pro, Geoprocessing (Clip, Intersect, Dissolve, Buffer, Spatial Join), Topology Validation, Geodatabases, Projection Systems (WGS84, UTM), Cartography
Surveying & Engineering: Total Station, GPS Surveying, Field Data Processing, AutoCAD 2D
Data Analysis & Reporting: Excel (Pivot Tables, Power Query), Python (Pandas, NumPy), SQL, Power BI, Tableau
Core Competencies: Problem Solving, Analytical Thinking, Data Validation, Technical Documentation

💼 Professional Experience

GIS & Surveying Specialist – Arab Contractors Company (11/2024)

Produced 20+ GIS maps using professional cartographic standards. Performed coordinate transformation with positional error < 5 cm. Reduced spatial data errors by 15% through topology validation. Integrated GPS survey data into ArcGIS Pro geodatabases and synchronized with AutoCAD drawings.

Data Analyst – Digital Egypt Pioneers Initiative (06/2025 – Present)

Cleaned and prepared 10+ datasets for KPI tracking. Improved data accuracy by 25% through preprocessing and validation. Built interactive dashboards using Excel, Python, SQL, and Power BI. Presented insights using data storytelling techniques.

Freelance GIS & Data Analyst (2025 – Present)

Delivered 15+ GIS and data analysis projects across freelance platforms. Analyzed datasets containing 5,000–30,000 records. Built dashboards reducing reporting time by 35%. Developed thematic maps, spatial analysis reports, and geospatial visualizations.