# GIS / Geospatial > Selected Engineer ApS work demonstrating GIS / Geospatial — the achievements that prove it. - [Accelerated geographical data pipeline performance by 50x by improving SQL programming and data modeling across PostgreSQL, MS SQL, and Google Cloud BigQuery.](https://engineer.company/portfolio/accelerated-geographical-data-pipeline-performance-by-50x-by-5/) - [Improved geographical map application performance by 10x through strategic database transition from MSSQL to PostgreSQL, optimizing processing and data security.](https://engineer.company/portfolio/improved-geographical-map-application-performance-by-10x-through-6/) - [Resolved 1,000 issues in geographical data and time‑series data, using GDAL, ArcGIS, PostGIS, Mapbox, QGIS, SQL (PL/pgSQL, Transact‑SQL), Bash, ensuring high‑quality big data processing.](https://engineer.company/portfolio/resolved-1-000-issues-in-geographical-data-and-7/) - [Delivered 8 Power BI projects with comprehensive manuals, integrating Microsoft Power BI tools with NodeJS API and Python FastAPI for effective data analytics and visualization.](https://engineer.company/portfolio/delivered-8-power-bi-projects-with-comprehensive-manuals-10/) - [Released 500 electricity and GIS data analysis reports, utilizing deep research and troubleshooting to ensure accurate geographic and time series big data insights.](https://engineer.company/portfolio/released-500-electricity-and-gis-data-analysis-reports-11/) - [Architected, created, and managed 100 PostgreSQL, MS SQL, and Google BigQuery data warehouse databases with primarily GIS and time‑series data, optimizing performance and scalability.](https://engineer.company/portfolio/architected-created-and-managed-100-postgresql-ms-sql-12/) - [Accelerated PostgreSQL performance by 10x via strategic indexing, partitioning, and query optimization, enhancing database efficiency for user, tenant, geospatial, and time‑series electrical data.](https://engineer.company/portfolio/accelerated-postgresql-performance-by-10x-via-strategic-indexing-15/) - [Automated GIS SaaS application deployment, data processing, and reporting system using GitHub Actions CI/CD, Python, Bash, and SQL.](https://engineer.company/portfolio/automated-gis-saas-application-deployment-data-processing-and-16/) - [Automated delivery of 20 GIS data pipelines and app data ETL processes, streamlining infrastructure automation and reporting.](https://engineer.company/portfolio/automated-delivery-of-20-gis-data-pipelines-and-17/) - [Led the software development of a GIS map application, driving revenue growth by 10x and positioning the product as a primary data asset.](https://engineer.company/portfolio/led-the-software-development-of-a-gis-map-24/) - [Directed full‑stack GIS map development, overseeing PostgreSQL, Mapbox, ReactJS, and NodeJS to deliver an integrated solution.](https://engineer.company/portfolio/directed-full-stack-gis-map-development-overseeing-postgresql-25/) - [Optimized forecasting and investment strategies for 11 electricity grid operators, driving operational efficiency through data‑driven GIS solutions.](https://engineer.company/portfolio/optimized-forecasting-and-investment-strategies-for-11-electricity-27/) - [Managed the execution of 30 successful GIS projects, demonstrating leadership in delivering innovative solutions across the field.](https://engineer.company/portfolio/managed-the-execution-of-30-successful-gis-projects-32/) - [Led the development, deployment, and support of over 30 GIS projects, demonstrating expertise in PostgreSQL, Bash, Python, JavaScript, GDAL, ArcGIS, PostGIS, and Mapbox technologies.](https://engineer.company/portfolio/led-the-development-deployment-and-support-of-over-35/) - [Contributed to user interface design processes, ensuring intuitive, visually appealing, and user‑friendly project interfaces.](https://engineer.company/portfolio/contributed-to-user-interface-design-processes-ensuring-intuitive-36/) - [Architected, developed, implemented, supported infrastructure, data processing, and the map application for 2 years non‑stop without any weekends, holidays, or vacations, 10–14 hours a day.](https://engineer.company/portfolio/architected-developed-implemented-supported-infrastructure-data-processing-and-55/)