Daniel Demonceau, GIS Engineer and Software Developer in Melbourne, Australia
Daniel Demonceau

GIS Engineer and Software Developer in Melbourne, Australia

Member since September 22, 2022
Daniel has been a professional full-stack developer for more than twelve years and has mainly worked in the GIS field for startups, small companies, enterprise businesses, and as a freelancer. He designed database models and REST APIs, created ETL scripts, optimized back ends, and implemented React front ends. As an avid learner and as a way to give back to the open-source community, Daniel started a technical blog seen by thousands, where he shares step-by-step guides to solve GIS challenges.
Daniel is now available for hire

Portfolio

Experience

Location

Melbourne, Australia

Availability

Part-time

Preferred Environment

Visual Studio Code, Windows, Linux, WSL

The most amazing...

...application I've developed is a severe weather warning app to take preventive measures for the telco's assets and save millions of dollars per year.

Employment

  • Founder and Tech Lead

    2022 - PRESENT
    Fluffy Clouds Avenue Pty Ltd
    • Developed several full-stack websites to be presented as a portfolio for the company using the Next.js framework as a base.
    • Built a battery-powered IoT GPS receiver box with a Raspberry Pi that regularly shares its position and other sensing data like temperature, air pressure, and humidity with a server using the 4G and LP-WAN networks.
    • Scripted a Python tool to extract financial information from the Alpha Vantage API and calculate the magic formula score for a set of stocks.
    • Prepared technical papers and pitched the startup at events.
    Technologies: TypeScript, JavaScript, React, Next.js, NestJS, Tailwind CSS, HTML, CSS, MUI (Material UI), Materialize, Bootstrap, QGIS, PostgreSQL, PostGIS, GeoJSON, Google Maps API (GeoJSON), Google Maps, Google Maps API, Google Geocoding API, Sentinel 2, Jest, Cypress.io, Auth0, Firebase, GML, Remote Sensing, ERDAS, Apollo Server, GPS, GraphQL, Raspberry Pi, Raspbian, ArcGIS, ArcGIS API, ArcGIS Online (AGOl), ArcGIS JavaScript API 3, Mapbox, Mapbox GL, Deck.gl, Prisma, PostCSS, PostGraphile, Transitions, PL/pgSQL, GitHub, Node.js, Express.js, NPM, YARN, GNSS, Internet of Things (IoT), Axios, ESLint, Lodash, NumPy, Styled-components, Mobile GPS, Ubuntu, Ubuntu Server, GeoServer, Full-stack, REST, APIs, Maps, Architecture, Software Architecture, JSX, React Redux, Redux, REST APIs, Solution Architecture, Web Architecture, REST API Architecture, API Architecture
  • Senior Software Engineer

    2021 - PRESENT
    Directed Electronics Australia
    • Designed a telematics geofencing solution for our SaaS used by our clients in the road freight industry.
    • Maintained the current telematics platform by completing bug fixes in the database, the back end, the API, and the front end.
    • Developed new features by making changes in all the layers (vertical slice) by respecting the business case requirements and the deadlines for the product development cycle.
    Technologies: JavaScript, TypeScript, React, PHP, Microsoft SQL Server, MongoDB, SingleStore, Python, Docker, GitLab, SQL Stored Procedures, GIS, QGIS, JSON, GeoJSON, Shapely, Google Maps API (GeoJSON), LeafletJS, Mapbox, Mapbox API, Mapbox Styling, Mapbox GL, MemSQL, VS Code, Deck.gl, Laravel, ESLint, Lodash, Ubuntu, Ubuntu Server, PyMongo, SaaS, Full-stack, REST, APIs, Maps, Architecture, Software Architecture, JSX, REST APIs, Solution Architecture, REST API Architecture, API Architecture
  • Freelance and Blogger

    2014 - PRESENT
    Freelance Clients and Blogger
    • Developed several Python scripts to create true-color mosaics from Sentinel-2 satellite granules (images), completed change detection analysis, and performed crop type classifications (supervised and unsupervised).
    • Created several maps for a client representing the geothermal potential surrounding the municipality of Plan-les-Ouates in Switzerland.
    • Conceived, designed, and implemented the migration plan from an Oracle Spatial database into PostgreSQL and PostGIS.
    • Built a real-time web app mapping the Sydney ferries using the NSW public API.
    • Explored the DEM, hill shade, and slope analysis capabilities of PostGIS and applied them to the use case of the Brussels capital region.
    • Worked on several concept web apps to showcase the capabilities of different GIS tools and methods, such as a holiday picture app, an interactive map showing the indigenous population in Canada, and a web app showing Runtastic outdoor workout routes.
    • Created a batch script to extract drone image file metadata and rename the image file with the coordinates of the center of the image.
    Technologies: TypeScript, PostgreSQL, PostGIS, Prisma, Tailwind CSS, Sentinel 2, Remote Sensing, ArcGIS, ArcGIS Online (AGOl), MongoDB, React, Next.js, NestJS, Python, Node.js, Express.js, Fastify, Oracle, Oracle Spatial, Shapely, GeoJSON, Google Maps, Google Maps API, LeafletJS, OpenLayers, Google Earth, KML, Google Earth KML, Vehicle Routing, GPS, GNSS, Styled-components, CSS, WordPress, ArcPy, XML, Sentinel, Axios, ESLint, Ubuntu, Ubuntu Server, GeoServer, Shell, Batch, Bash, Apache, Apache Tomcat, Full-stack, REST, APIs, GraphQL, Maps, Architecture, Software Architecture, REST APIs
  • GIS Developer and Manager

    2017 - 2021
    Vocus Group Ltd
    • Led the full-stack GIS team in meeting the business requirements of the GIS infrastructure used by 200+ daily users in the company.
    • Conceived, developed, and maintained the entire GIS infrastructure using open source technologies.
    • Designed and implemented from scratch a topological database model and migrated the entire asset network data (5+ million records) from two different old systems to the new unique one using Python scripts.
    • Wrote most database functions, stored procedures, and views using SQL and PL/pgSQL to keep the whole data model consistent for every CRUD operation.
    • Conceived, developed, and maintained the GIS web client of the GIS infrastructure using Node.js, React, Google Maps, OpenLayers, Leaflet, Bootstrap, and Material UI.
    • Maintained our mobile app developed in React used by field workers.
    • Enhanced the REST API of the GIS infrastructure written in Go.
    • Developed a real-time severe weather warning app using the Bureau of Meteorology API and automated the creation of reports listing affected assets for the operation control center team to take preventive measures and save millions in avoiding damage.
    • Built a health check app to permanently test the quality and performance of every tier in the GIS infrastructure using JMeter, SchemaSpy, and Python and sent out an alert in case of an outage for quick action.
    Technologies: PostgreSQL, PostGIS, MongoDB, Go, JavaScript, Node.js, Python, React, Ember.js, Google Maps API, LeafletJS, OpenLayers, Bootstrap, MUI (Material UI), Git, GitLab, SQL Stored Procedures, SQL Views, SQL Triggers, PL/pgSQL, GIS, QGIS, HTML, CSS, SQL, Atom, GML, KML, GeoJSON, XML, Slack, VS Code, Geocoding, Google Geocoding API, Google Maps Geocoding API, Express.js, NPM, YARN, Axios, ESLint, Lodash, Ubuntu, Ubuntu Server, GeoServer, CouchDB, Full-stack, REST, APIs, Maps, Architecture, Software Architecture, ETL, JSX, REST APIs, Solution Architecture, REST API Architecture, API Architecture
  • Senior GIS Engineer

    2016 - 2016
    Quadratic SRL
    • Wrote Python scripts to import MultiSpectral Sentinel-2 satellite images in batches from their raw formats to PostgreSQL.
    • Developed scripts to extract data and process information about crops from Sentinel-2 satellite images using PostGIS, PL/pgSQL, Python, and PyQGIS.
    • Analyzed our client's business needs in the agro-industry to improve their harvest logistics and implement the requirements and criteria in the processing scripts.
    • Represented the startup at various events about Earth monitoring.
    • Prepared and gave training on remote sensing applied to the agro-industry and its concrete applications. Oversaw a series of practical and interactive exercises using Sentinel-2 images, Landsat, and planet data.
    Technologies: PostgreSQL, PostGIS, Python, QGIS, PL/pgSQL, OpenLayers, Git, GitLab, Remote Sensing, Radar Remote Sensing, Satellite Images, Sentinel 2, Maps
  • Senior GIS Engineer

    2015 - 2016
    Oscars
    • Provided Oracle Spatial, Oracle GeoRaster, and business analytics consultancy to Groupe ADP in France and Public Service of Wallonia (SPW) in Belgium.
    • Oversaw the GIS part for our in-house product designed for airports to help them track any vehicle on the ground in real time to improve the overall logistics on the tarmac.
    • Led our team of developers and organized their agendas regarding our in-house developments and external consultancy missions.
    • Represented and pitched the startup at various seminars, economic missions, business gatherings, schools, and universities.
    Technologies: Oracle, Oracle Spatial, IT Project Management, IT Services, Business Development, Customer Service Representative, Sales Presentations, Pitch Presentations, PL/SQL, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Maps
  • GIS Engineer

    2013 - 2015
    Esri BeLux
    • Developed a pothole detection algorithm using ArcGIS technologies and Python scripting.
    • Built additional plugins in JavaScript for the ArcGIS Web AppBuilder.
    • Delivered first-line customer support on Esri products, mainly ArcGIS for Desktop, ArcGIS Server, and ArcGIS API for JavaScript for English, French, and German-speaking clients.
    • Provided on-site consultancy and coaching on ArcGIS for Desktop, ArcGIS Server, ArcGIS API for JavaScript, and the road network extension (LRS) to our clients in various industries.
    • Provided training on the Esri product suite (ArcGIS for Desktop and ArcGIS Server) to a class of clients.
    • Presented ArcGIS's newest features at our annual Esri Days event to our clients.
    • Attended conferences and seminars and followed technical training on ArcGIS API for JavaScript at Esri Developer Summit in Palm Springs, California, in 2015.
    Technologies: JavaScript, Project Consultancy, Coaching, ArcGIS JavaScript API 3, ArcGIS, ArcGIS Server, ArcGIS Online (AGOl), Web AppBuilder for ArcGIS, ArcGIS Collector, Esri, ESRI Operational Dashboards, ArcMap, Training, ICT Training, GML, KML, XML, ArcGIS API, Maps
  • GIS Project Engineer

    2010 - 2013
    Hexagon
    • Developed a complete and automated test suite in Java for the ERDAS APOLLO product that runs daily and generates reports about the parts that need attention.
    • Led and supervised a team of QA engineers for the integration testing of all the Intergraph geospatial server products.
    • Customized ERDAS APOLLO according to the client's needs, such as building a custom form tailored to the type of data the client is working with.
    • Fine-tuned the ERDAS APOLLO server by configuring the RAM usage, swap space, and file system configuration to have the solution working optimally on the client's infrastructure.
    • Provided support, coaching, and consultancy on our range of products and in-house customizations to our clients, mainly on the ERDAS APOLLO product suite.
    • Gave 5-day training, at our offices and abroad, on the ERDAS APOLLO product suite to our clients in the EMEA region.
    Technologies: Java, JavaScript, HTML, CSS, Consulting, Coaching, App Support, ERDAS, Remote Sensing, Satellite Images, GNSS, GPS, XML, YML, CSV, GML, KML, Imagery, 3D Images, Image Processing, GeoJSON, JSON, Maven, Perforce, IntelliJ, YAML, Linux, RedH, Windows, CityGML, Intergraph GeoMedia, IIS, JBoss, Apache Tomcat, Apache, Maps

Experience

  • GIS Blog
    http://themagiscian.com

    A technical blog focused on GIS developments using open-source GIS tools to solve common spatial problems. The purpose of this blog is to share knowledge in the GIS community as it is written in a pedagogic and easy-to-follow way.

  • Website for a Land Surverying Company Specialized in Drone Applications
    https://altitude-surveying.be/

    Development of a website for a land surveyor company specializing in drone applications. This website was developed as part of my master's thesis in economic science, which was about creating a business plan for that company.

  • Cumulus Capital Management Website
    http://cumuluscapitalmanagement.com

    A Next.js-based website for a fictive wealth management company. The website describes three proven long-term investment strategies and shows a dynamic portfolio with P/Ls updated daily with the latest quotes. A back-end Python script gathers the latest quotes and inserts them in the database for immediate viewing in the front end. The purpose of this website is to provide the community with simple investing strategies. I build the back and front end with PostgreSQL, GraphQL, Next.js, React, and Tailwind.

Skills

  • Languages

    JavaScript, PL/pgSQL, TypeScript, KML, Python, HTML, CSS, C++, Java, Go, PHP, SQL, XML, GML, YAML, GraphQL, Batch, Bash
  • Libraries/APIs

    ArcGIS, React, Google Maps, OpenLayers, Node.js, Google Maps API, LeafletJS, NumPy, REST APIs, ArcGIS JavaScript API 3, Shapely, jQuery, Google Maps API (GeoJSON), Mapbox API, Mapbox GL, Google Geocoding API, Google Maps Geocoding API, Lodash, PyMongo, React Redux
  • Tools

    GIS, Git, Esri, Geocoding, Sentinel, ArcMap, JSX, GitLab, ERDAS, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Web AppBuilder for ArcGIS, ArcGIS Collector, Prisma, Apache, Maven, Perforce, IntelliJ, Atom, Slack, VS Code, Auth0, PostCSS, GitHub, NPM, Intergraph GeoMedia, Shell, Apache Tomcat
  • Platforms

    ArcGIS Online (AGOl), Visual Studio Code, Windows, Linux, Oracle, Ubuntu, ArcGIS Server, Docker, WordPress, RedH, Mapbox, Firebase, Raspberry Pi, Raspbian, MapServer, JBoss
  • Storage

    PostgreSQL, PostGIS, SQL Stored Procedures, SQL Views, SQL Triggers, PL/SQL, MongoDB, Microsoft SQL Server, OVH, JSON, GeoServer, CouchDB
  • Other

    GNSS, Cartography, ArcGIS Desktop, Coaching, App Support, Project Consultancy, QGIS, Satellite Images, GeoJSON, Google Earth KML, Maps, IT Project Management, Consulting, Oracle Spatial, Business Development, Customer Service Representative, Sales Presentations, Pitch Presentations, Remote Sensing, GPS, WSL, Sentinel 2, Google Earth, Vehicle Routing, Imagery, ESLint, Ubuntu Server, Marketing Mix, Business Law, Human Resources (HR), Tax Accounting, Negotiation, IT Services, Radar Remote Sensing, SingleStore, ESRI Operational Dashboards, Styled-components, ArcPy, Training, ICT Training, YML, CSV, 3D Images, Image Processing, CityGML, ArcGIS API, Mapbox Styling, Apollo Server, PostGraphile, Transitions, Internet of Things (IoT), Axios, Mobile GPS, SAP, Business Ideas, Business, Finance, IIS, SaaS, Full-stack, APIs, Architecture, Software Architecture, FontAwesome, Solution Architecture
  • Frameworks

    Tailwind CSS, Next.js, Ember.js, Bootstrap, MUI (Material UI), NestJS, Express.js, Fastify, Materialize, Jest, Cypress.io, Deck.gl, YARN, Laravel, Redux
  • Paradigms

    REST, Management, ETL, REST API Architecture, API Architecture, Web Architecture

Education

  • Master's Degree in Economic Sciences and General Management
    2011 - 2013
    ULiège - Liège, Belgium
  • Master's Degree in Geographic Sciences, Geomatics, and Geometrology, Finalization in Land Surveying
    2005 - 2010
    ULiège - Liège, Belgium

Certifications

  • JavaScript Algorithms and Data Structures
    APRIL 2022 - PRESENT
    freeCodeCamp
  • Project Management: The Basics for Success
    JULY 2016 - PRESENT
    University of California | via Coursera
  • Successful Negotiation: Essential Strategies and Skills
    SEPTEMBER 2015 - PRESENT
    University of Michigan | via Coursera
  • ArcGIS Desktop Entry 10.3 (EADE103)
    AUGUST 2015 - PRESENT
    Esri

To view more profiles

Join Toptal
Share it with others