Eric Mertens

Skills: Qlik Sense · Qlik · Powershell · Data Warehouse Architecture · Data Vault

Owner, Datawarehouse Architect & Analyst, Business Objects Certified Universe Builder, Qlik Sense Senior Consultant Occasionally, NLP Coach & Trainer

* Project - Transparency Reporting * Description - Develop a new Data Mart + Qlik Sense App for the regulatory reporting and internal dashboard to replace manual process * Tasks - Sources Analysis (4 different file structures + reference data) - Data Modeling / Star Modeling - SQL development (DDL/DML/DCL) - Qlik Development - Documentation - Maintenance & Follow-Up * Project - Drug Development * Description - Maintain & expand existing Data Mart * Tasks - Adapt the current Data Mart based on new business requirements - SQL development (DDL/DML/DCL) - Documentation * Project - PostgreSQL/RDS Monitoring App * Description - Develop a new Qlik Sense App on PostgreSQL/RDS objects (Tables, Columns, Indexes, Comparison between DEV/ACC/PRD, Statistics, …)

* Project - BI-Box Fiduciaires * Description - Design and develop a new reporting solution on an accounting software (WinBooks) using Data-Vault modeling and Star modeling. * Functional Analysis - Mind Map - UML Actor & Use Case Diagram for the As-Is and To-Be Situation - Data Vault and Star Model Design - Data Flow & Process Flow Design * Technical Analysis - Source to target column mapping - Detailed analysis of ETL process * Development & Testing - Implementation of the target Data Vault model and Star-Model (tables, indexes, sequences, ....) on Ms SQL Server 2014 & PostgreSQL - Development of ETL jobs with ODI, Python, Pentaho Data Integration / Kettle * Business Development - Sales & Marketing to promote the solution

* Projects - EAMR - DQ Dashboard * Description - Manage analyst team of the DG DEVCO DWH Sector * Tasks - Reporting to Head of DWH Sector - Coaching & People management of analysts - Analysis of several key projects (DQ Dashboard, EAMR, …) * Technologies & Tools : - Oracle, Data-Vault, TOAD, SAP BODS, Sybase PowerDesigner

* Project - Hosting of the BI-32 project by I-AM.217 department * Description - Migration of an existing ETL developed in ODI to Pentaho Data Integration (PDI / Kettle). * Tasks - Analysis - Infrastructure setup - Development - Tests - Release in Prod - Knowledge transfer * Technologies & Tools - Oracle, PostgreSQL, MySQL, Linux, Pentaho Data Integration/Kettle, Fly Speed Query, Data-Vault

* Project - Hermes * Description - Design and develop a new reporting solution based on Odoo data to target customers for email marketing * Tasks - Functional & technical analysis - Development & Testing - Release in prod * Technologies & Tools - Odoo, Python, RESTful API, Linux, ZoHo Reports

* Projects : - InciMII - INES - DIS - ATHENA - A1058 - RIOC Calls - A1138 - TC460 Driver Forms - A1139 - Minute Responsible - A1140 - Referential Data - RDV - TrackPro - A175 - CostModel - Quick Win - SARA - Data For Reporting - ArtRob Lite * Main Tasks : - Functional Analysis - Data Modeling (Data-Vault & Star-Model) - Development using ODI - Release & Scheduling - Maintenance & Improvements - Knowledge Transfer * Personal Initiative : - Develop ODI procedures in Groovy + ODI SDK to automate the design and development of Data-Vault models and interfaces

* Project : - 5 days of support on SAP BI * Tasks : - Installation, administration, JDBC configuration * Technologies & Tools : - SAP BI, Linux, JDBC

* Project - BI Implementation @ Effigy * Description - Implementation of BI methodologies for Effigy (Kimball approach, …) - Prepare the MCTP BI 2008 Exam (SSIS/SSAS/SSRS) - Support & Coaching of BI team members - Pre-sales support for Sales Representative - Writing of Proposals for BI opportunities

* Project - Setup of a BI Training Curriculum * Description - Collect BI Training & Trainers information - Collect standard BI Roles & Skills information - Design of an online application on Zoho to manage the Training, - Trainers, Roles & Skills information

* Projects - VAIO-Link New Technology - Sony Style Store Contact Center DWH - Logistics - SQL 2000 DTS Migration to ODI - Garata - Clarify ODS - Magic Link - Sony VOE Global Data Warehouse Implementation - Business Suite - Sales Agent XP db - Garata ODS - FBI - Korogashi - Sales Revamp - TVOE Demand Planning - ERPC BO 6.5 to BOXIR3 Migration * Description - Solution Architecture - - Mind map - - UML Actor & Use Case Diagram for the As-Is and To-Be Situation - - Star Model design - - Data Flow & Process Flow - Detailed Design - - Source to target column mapping - - Detailed analysis of ETL process - - Detailed analysis of Business Objects universes - Development & Testing - - Implementation of the target star model (tables, views, indexes, ...) on SQL Server 2000 & SQL Server 2005 through SQL DDL scripts - - Development of ETL jobs with Oracle Data Integrator (ODI - formerly Sunopsis) by creating and maintaining several ODI projects - - Data Quality Assessment of the source database through specific ODI projects - - Eventually, development of specific LKMs, IKMs, CKMs, and RKMs - - Creation & Maintenance of BO Universes and Reports using BO 6.5/BOXIR2/BOXIR3 - Release in production - - Release of the ODI scenarios through the ODI versioning system - - Release of the BO Universes by import/export from the development domain to the production domain - - Creation of the target star-model through SQL DDL scripts - - Scheduling of the ODI scenarios through startscen.bat ODI mechanism - Maintenance & Improvement of the Data Marts to follow business changes from March 2006 until June 2011 - Knowledge transfer

* Project - Dashboard * Description - Detailled analysis of ETL process, as well as Business Objects universes & reports - Development of those ETL jobs with the Business Objects Data Integrator Tool - Development of universes and reports with Business Objects 6.5 - Automation, production set-up, scheduling of ETL and reports - Implementation of WEBI to access reports and universes through a web interface - Training of key-users for the Business Objects Tools (Reporter, Designer, Data Integrator) and introduction to star-modeling - Knowledge transfert

* Project - Setup the training "Les Bases de la PNL" * Description - Analyse "As-Is State" and "To-Be State" of the potential attendees; - Identify concepts needed to move away from the "As-Is State" towards the "To-Be State"; - Create training material (handouts & slides); * Project - Setup the training "Gestion des conflits avec Le Petit Prince" * Description - Analyse "As-Is State" and "To-Be State" of the potential attendees; - Identify concepts needed to move away from the "As-Is State" towards the "To-Be State"; - Create training material (handouts & slides); * Project - Life Coaching for Individuals * Description - Coach individuals in analysing their current situation; - Coach individuals in defining their personnal goal; - Define actions to move away from the current situation towards individual personnal goal; - Train, support and coach individual in executing those actions.

* Project - Functionnal Analysis for the Leonardo project (Customer DataMart v2) * Description - Analyse business requirements written by end-users; - Identify scope of the solution by using UML; - Create dimensionnal model and databus based on reports requirements; - Design database star-model using Oracle Designer; - Identify source table to populate target tables; - Design ETL batch process. * Project - Technical Project Leading for the Leonardo project * Description - Technical follow-up of the development team; - Manage weekly project team meeting. * Project - Personnal Initative at Mobistar * Description - Develop Ms-Access application to collect metadata coming from several source databases.

* Project - DataWebhouse Design for PAW (Proximus Advanced Website) Auditing * Description - Create and design the whole technical architecture for reporting and dimensionnal analysis about traffic on Proximus Website. * Project - Solution Architecture * Description - Analyse business requirements written by end-users; - Create dimensionnal model based on reports requirements; - Design database star-model using ER/Win Modeling; - Design ETL batch process. * Project - Detailed Design * Description - Write Spec (DDL) for DBA: Tables structure, indexes, partitionning, sizing; - Write Spec for SAS Developpers: Mapping between target tables and source tables, ETL algorythm and pseudo-code, testing queries, process flow and data flow; - Write Spec for BO Developpers: BO Universes Specification, BO Reports Specification; - Present kick-off meeting to technical team.

* Project - Elite Management Software * Description - Development of a java-based software for data acquisition, presentation, and archiving

* Description - Recruitment Task - Benefit and Compensation Package analysis, design, and setup