Business Intelligence and Technical Consultant for Dynamic 365

• Oct 2019 - Present

PG BI Client: PetroGabon BI Objective: Set up a set of transactional monitoring reports and Analytics from D365 and Excel with reconciliation Implementation the Cloud Architecture (BYOD, DataWarehouse ). Analysis of the need and the indicators for each sector of activity. Design Data Warehouse.Development of entities and Aggregate Data Model. Realization of ETL processes. Realisation of Dashboards- Vernicolor BI project: Elaborate of Dashboards (Order & Customer Invoice, Production & Planning, Purchase & Supply...), for Vernicolor Group using Dell Boomi (Cloud Integration Tool) and Qlik Sense.This dashboards are intended for Priority ERP and Dynamics 365 FO.• Analysis and Development phase:Identified the need for each dashboard.Develop and modify the data entities of D365 FO necessary to meet the needs ofDashboards.Data Warehouse Conception and KPI definition.• ETL phase: using Dell boomi (Cloud Integration Tools) for extract, transform and load elaborate Dell Boomi processes from the various ERP systems implemented: Dynamics 365, ERP priority to DW.• Restitution phase: Realization of the dashboards with Qlik Sense with a continuous update and evolution according to customer request (turnover by project, Consumable by project. Budget monitoring ...).-SPM Project : * Configure and Deploy Project Service Automation of Dynamics 365. * Conception of DataWarehouse "PSAW" . * Prepare dashboards for monitor with KPI effort and production rate ...- Environment Management(Environement Deployment, Backup Managment(Import/Export for Tier 1 and Tier 2....) .....- Dashboard and Reports : Power BI, QlikSense.- Cloud Integration : Dell Boomi- Dev : X++ (Modifie and Develop Data entities..)

Intern Consultant in Dynamics 365 for Finance & Operations & Business Intelligence

• Jan 2019 - Sep 2019

Buisness Intelligence Intern

• Jul 2018 - Sep 2018

-Mis en place d'un catalogue de rapports et de tableaux de bord avec Power BI (Ventes,Achats,Trésorerie,Comptabilité,Projets,Production,WMS) et intègration avec Microsoft Dynamics NAV et Microsoft Dynamics AX