David Aichelin

Conceived data models using DBT to optimize the structure of the data warehouse. Developed numerous Grafana reports based on BigQuery queries. Created data models (LookML) and internal/external reports using Looker and Looker Studio. Developed Python machine learning programs, particularly for categorization with PyTorch and integration with the Sirène API. Created models in Cube based on DBT tables for specific analyses. Updated data and performed reverse ETL in Hubspot using Airbyte and Rudderstack.

- Update and creation of different Power BI /Qlikview report for social housing and finance area. - Definition of technical solution based on SQL Database and Talend flow. - Data analyst for a client who manufactures internet connected tools for the industry I had to understand the environment, create a database and Talend dataflow to centralize all the information. I finally produced different Power BI templates to present clearly the data and show clients how to improve the production.

- Update and creation of different Power BI /Qlikview report for social housing and finance area. - Definition of technical solution based on SQL Database and Talend flow. - Data analyst for a client who manufactures internet connected tools for the industry I had to understand the environment, create a database and Talend dataflow to centralize all the information. I finally produced different Power BI templates to present clearly the data and show clients how to improve the production.

- Asset Management Solution Analyze and Technical specification - Responsible for designing, coding, and testing the applications - Design, creation and maintenance of a SQL database to support the solution - SSIS 2016 dataflow from Customer data to obtain useful result for the client - Definition of the reporting with the customer - Participate in weekly meetings and calls with management - Test and development responsibility

- Member of a 40 persons project to create a new tool to automate Investments funds audits - Lead of the ETL Solution and Standard reporting solution (4 team members) - Definition of technical solution based on SSIS 2016 and Talend Dataflow from intern and extern sources - Business Analysis with the customer regarding the reporting - Reporting SSRS 2016 and Qlikview for clients - Documentation and project management

- Web portal Migration: Business Object, SQL, SAP BW - Project for inside customer (Tax, Advisory and Training Divisions): SSRS,SSIS,SQL - Reporting Project: Business Object, Live Office - Fund industry training received - Business Analyst fund industrie

* Project Cloud Microsoft: use of Microsoft Azure and Power BI * Project for different customers : SSIS, SSAS, SSRS

Ich war bei der Firma Technology & Strategy (eine IT-Dienstleistungsfirma) in Strasbourg. Ich war verantwortlich für die Entwicklung des Deutschen Marktes.

Während des Sommers habe ich 2012 ein viermonatiges Praktikum bei Daimler in Mannheim gemacht. Ich habe dort die Datenbank umstrukturiert und mehrere VBA Programme hergestellt.

- Management - Controlling

- Informatik - Buisness Intelligence