From the rules to the physical data model (UML). I often use the snowflake schema (multidimensional relational database with facts and normalized dimensions).
DBMS (PostgreSQL), pgModeler, SQL, PL/pgSQL, etc.
OLAP technologies
I work with Pentaho and OLAP services to improve data access and analytics.
Pentaho Schema workbench (OLAP cube, MDX), Pentaho Data Integration, Pentaho, etc.
Spatial data
I handle different formats (PostGIS extension, GeoJSON, SHP, OGC standards as web map services, etc.).
OGR/GDAL and Python are my swiss knife!
GIS: QGIS and ArcGIS (Pro and Online).
Metadata
In addition to data dictionaries and tables comments, I implement a metadata manager to facilitate updates and knowledge of available data (preview on my projects page).
Rigor, attention to detail and performance optimization.
Web development and data visualization
Web development
Development of web applications (responsive) from back-end to front-end (REST).
Back-end: Node.js (Express), some PHP.
Front-end: ES6, jQuery, starting Vue.js on some components, HTML5/CSS3, Pug, Bootstrap, etc.
Bundling with Parcel, Git workflow deployment (hooks), unit testing with Mocha.
Dashboard prototype
I designed an easily reusable dashboard prototype. It contains charts/maps and consumes data from APIs. Everything is setable from JSON files at the root of the project.
Built with Node.js and JavaScript libraries as Chart, OpenLayers, etc.
Look for the best way to represent data and to extract relevant informations.
Mostly use of open source tools as JavaScript libraries and data visualization solutions: Tableau, GEO Key (Business Geografic), CARTO, ArcGIS Insights, etc.
Data processing: ETL (Pentaho Data Integration or FME) and Python!
Web design
Rather used to reproducing designer models, I also like to design. I mainly focus on the user experience.
UX/UI, responsive design, graphic design and details.
I love art and drawing, you can find examples on my Instagram. I also use these skills for IT during the design phases (drawing of interfaces, models, etc.).
Pencil, ink, clear line drawing (Belgian comic strip), portrait, architecture, etc.
Mouse
I manipulate vector drawings to refine cartographic productions and to illustrate new ideas!
Colorization, Inkscape (or Adobe Illustrator).
Mmmh, have you noticed this strange unmasked figure, with two-tone glasses, walking in the night
