# Senior Data Engineer - Nicolas GERARD # Senior Data Engineer Deploy quickly with confidence and delight your users Creator of [Tabulify](https://www.tabulify.com), author of [Datacadamia](https://www.datacadamia.com), big proponent of AI agentic data processing, with more than 20 years experience, I'm mastering the data landscape from data harvesting, integration, visualization, deployment and monitoring. Feel free to contact me to discuss any data questions or problems as well as my competences to implement or resolve them. ## Characteristics Me in 3 points ### T-shaped Engineer Data is my passion and I'm able to work on front-end, back-end and infra allowing me to tackle a broad range of complex real-world problems without extra hire. ### Give a damn Relentless result-driven with a high creativity on solutions. Being idle waiting for an never-coming answer is not in my nature. ### Clear Model Builder Intractable problems find their source in bad models. I'm capable of building them, spotting inconsistencies, understanding interconnections and trade-offs. ## Most Notable Creations Show, Don't tell ### Tabulify A data processing framework that focus on prototyping and testing for a quick and confident deployment (Java based). ### Kubee A terminal client to deploy a Kubernetes cluster and install apps by using a single source of truth values file bringing full configuration consistency (From a Single VPS and beyond). ### Datacadamia I write openly since 2008 and inadvertently created Datacadamia, one of the biggest data knowledge base enjoyed by 14K users daily (bots excluded). ## Advanced Skills 360 Overview ### Coding - AI I can create plugins (SDK), custom integration (Rest, JDBC), Bot (Deployment), AI agent or tools (MCP) and extract features (text, metadata). I did it to automate and resolve complex pipelines. ### Analytics - BI I can create dashboards, reports and custom visualizations. I designed cubes, semantic layers with BI applications as well as in Notebooks. ### Real Time - Streams I can create real time analytics and data integration. I have build stream based data processing flow as well as real-time reporting and monitoring on time series database. I can develop mini-batch as well as queue based data processing pipeline. ### Data Warehouse - ETL I can build a data warehouse from scratch. I worked on multiples markets from Automotive, Fashion, Insurance to Telecom using the three layers Kimball architecture or data vault fashion. ### Big Data - Data Lake I can implement a data lake. I worked on Hadoop/Spark based environment as well as cloud data lake engine. I even wrote Hadoop map-reduce app before Spark was born. ### Performance - Model Performance first. As a database administrator, I worked on performance analysis and resolved long running issues from hours to milliseconds. ## Projects and Employments Main Roles ### 2019/26 - Full Stack Data Developer Bytle - Software development I worked on data application development around data processing and publication * [Tabulify](https://www.tabulify.com) - data processing tool - development of all files and databases connectors * [Datacadamia](https://www.datacadamia.com) - data article publication * [Kubee](https://kubee.bytle.net) - Kubernetes data platform deployment * Real-time Analytics Backend (time-series db + dashboards) ### 2011/19 - Senior Data Engineer HotITem - Business and IT consulting I worked on data engineering (dashboarding, reporting, data lake and data warehouse development) and data platform tasks (DBA, CI/CD, Cluster installation and monitoring) * KPN - Call center analytics (Oracle BI environment with data vault design) * Peugeot/PSA - Automotive marketing analytics * Tommy Hilfiger - Oracle to SAP Hana analytics migration * VGZ - Informatica Big Data Implementation * Ziggo - Cloudera Data Platform Migration Support * NS - Informatica Big Data platform installation ### 2009/11 - Business Intelligent and DataWarehouse Consultant Ciber (Experis) - IT consulting I worked with the Oracle team on OBIEE, OWB and OBIA projects. * Van Gansewinkel - 360 Data Analytics and integration of 20 regional applications * Gemeente Rotterdam - Oracle E-Business Analytics development ### 2008/09 - Business Intelligent Consultant NewFrontiers (Teradata) - Analytics software editor I worked on the development and implementation of the flagship product [BI4SAP QuickStart product](https://www.computable.nl/2007/05/08/newfrontiers-introduceert-oracle-business-intelligence-voor-sap/), a SAP analytics product built on top of Oracle technology. * Tommy Hilfiger - Analytics Migration to the new Oracle Business Intelligence environment ([Presentatie](https://nico.gerardnico.com/resume/tommy-discover-to-obiee)) * Schouten en Nelissen - Implementation of BI4SAP * Engie - Data Quality Improvement (Presentation of this work on the [OBI Forum](https://nico.gerardnico.com/090603/mdm-obi-forum/)) ### 2005/08 - ERP Project Manager and Developer SemWare - ICT consultancy and ERP software editor Specialized in the [BAAN (Infor Ln)](https://www.semware.fr/ma-solution/erp/105-erp-baan) and IGus ERP (Seeds Management), I worked as ERP specialist and developer. * Audit and workshops on BAAN Implementation (Distribution, Finance, Manufacturing, Process After-sales) for main customers : [Lancy](https://www.lancy.com/), [Maestria](https://www.maestria.fr) and [Pommiers](https://www.pommier.eu/) * Development and support of the IGUS ERP (Oracle Forms and Business Object) ### 1998/04 - IT and Project manager LANCY - Concrete pumps manufacturer Recruited during my study to replace their old ERP, after a successful implementation, I took the position of manager to make IT a competitive advantage and improve processes, stock and customer/supplier relationship organization wide. * Strategic Information Technology Definition and yearly budget proposition according to the local and headquarters’ strategies (Budget of 140 K Euro, 7 servers, 50 personal computers) * Automated stock management per profiles organised by class and consumption (ABZ Curve, MDM Project) that brought a 10% stock and a 50% purchase order amount reduction * Analytics and Reporting Platform implementation based on Oracle Warehouse, Crystal Report and Business Object ## Skills Set Tools and technologies Note that the entire skill section is a Graph with a total of 304 nodes. We show below only the most relevant one sorted alphabetically, but you can drill down on each one to discover them all. Analytics Reporting , Business Intelligence , Notebooks , Data Visualisation , Olap Business Intelligence Analytics , Data Visualisation , Oracle Business Intelligence , SAP Business Object Big Data Data Lake , Real Time , Data Warehouse , ETL , CI/CD Kubernetes , Git , GitHub , Ansible , SSH , Docker , ArgoCd Cloud Aws , Gcp , Azure Computer Science Languages , AI , Algorithms , Crypto Hash , Signature (Symmetric/Asymmetric) , Trust Models (PKI, Acme) Data Lake Data Warehouse , Big Data , Spark , Big Query , Snowflake , Parquet , Medaillon/Kimball Architecture Data Science Notebooks , R Lang , Python , Data Visualisation , Data Visualisation Analytics , Business Intelligence , Notebooks , Data Science , Grafana Data Warehouse Data Lake , Stream/Batch , Big Data , MDM / Data Quality , Medaillon/Kimball Architecture , Data Vault Databases Performance , Olap , Oracle Database , SQL Server , PostgreSQL , MySQL , Clickhouse , Sap HANA , Database Engine , SQL Table , JDBC/ODBC ETL Real Time , Big Data , Powercenter , Powercenter Big Data , Oracle Warehouse Builder , Oracle Data Integrator , Apache Nifi , IAM Oauth/Oidc , JWT , AuthN , Trust Models (PKI, Acme) Languages R Lang , Python , Computer Science , SQL , Java , Javascript , Bash , Go , Notebooks R Lang , Analytics , Data Visualisation , Data Science , Jupyter , RStudio , Excel Performance Databases , Data Structures , Algorithms , Platform Prometheus , Kubernetes , Grafana , Ansible , SSH , Docker Real Time Stream/Batch , ETL , Big Data , Apache Nifi , Prometheus , Grafana , RabbitMQ , Kafka Reporting Analytics , SAP Crystal Reports , Oracle Analytics Publisher , Typst Data Structures Performance , Spatial/GeoData , Graph , SQL Table , XML , Json , Parquet , Text , Collections ## Education Degrees and diplomas ### 1997/98 - Master - Production Engineering and Industrial Computing University of Bordeaux( With honors ) Enterprise Resource Planing, Business performance, computer engineering, networks, control systems and industrial studies ### 1994/96 - Bachelor - Industrial Engineering with Production specialization University of Burgundy( With satisfactory honors ) Production management, Quality, Automation, Electronics, Metrology, Maintenance, Human Relations, Computer Science, Physics, Chemistry, Mechanics of Materials, Labor Law, Sociology, Ergonomics, Business Economics, CAD-CAM, CNC, MRP ## Interests And Hobbies Games Chess, Rugby Reading Product Design, Psychology, Biography, History, Economy, Law, Sports Running, Swimming, Skiing ## Languages Lost in Translation Dutch( Fluent ) English( Fluent ) French( Native Speaker )