EXPERIENCES
Senior BI Engineer, SCHNEIDER ELECTRIC
PARIS – A partir de Janvier 2020 ( 5 ans++)
Senior BI Engineer au sein du département DSS Digital Schneider Services .
Accomplissements :
• Planification et gestion du projet Agile Scrum – Jira , Trello , Sharepoint
• Rédaction des spécifications fonctionnelles et techniques des KPI’s
• Suivi et gestion de 40 KPI’s & Dashboards (DEV-QA-UAT–PROD )
• Conception et développement des KPI’s et Dashboards (Build & Run)
• Estimation et chiffrage du projet (Workload , budget )
• Management d’une équipe (4 à 8 personnes) prestataires et offshoring
• Organisation des workshops avec des équipes Business et techniques en France , USA , Philipines , Espagne ,China , Irland , India ,Canada , Danemark .
Senior BI & Analytics Engineer – Schneider Electric
• Project CSH BI / ED BI – Customer Service Hub Dashboard
Working in collaboration with teams based in USA, Spain , Danemark ,Irland , India
• The 2 projects Consist of migrating SalesForce CRM Analytics Dashboards (Ex Einstein Analytics) and Power BI to Tableau Dashboards
• Define the roadmap with technical team and stakeholders
• Estimate the workload and budget of the project
• Analyze the business requirements of KPI’s and elaborate specifications
• Organize Workshops with Technical Team and Business
• Analysis of the existing solution in Einstein Analytics (Input flat files, Recipes, Datasets, Reports).
• Perform data mapping in Intel Data Store, ensure the integrity and quality and design BI models.
• Manage Tableau Reporting team using Agile Scrum Methodology (Jira)
• Design the start schema model in Cloud Datawarehouse AWS Redshift
• Participate with the team to Migrate SOQL to SQL and Tableau Formulas
• Design and develop more than 20 Tableau Dashboards and 2 PBI
• End to End testing (UAT – QA – Pre-Prod) and manage Sprint Releases
• Deploy Tableau Server for Target users ( 1800 End users and Managers )
Project China Salesforce CRM Migration
Working in collaboration with teams based in France , China , Philippines , India
• Collect and define the Business Requirements for China CRM Migration
• Migrate China SalesForce Dashboards to Tableau for IT Global
• Analyze and define Roadmap of End-to-End Testing (QA - UAT)
• Perform Gap Analysis and End to End Testing for all Environments
• Deploy SalesForce Tableau Dashboards to end users (8000 users)
Project Supply Chain - Tableau Project Deployment and Operational Support
The Supply chain project aims to build a BI solution (Dashboards) to monitor the lead time (KPI) from the shipment of the parts order arriving to delivery.
• Manage workshops with the business based in Canada , USA and Spain
• Collect and define the Business Requirements for GSC operations with Stakeholders based in Ireland
• Manage the project planning (Roadmap , Jira Sprints , Releases)
• Collect and Analyze data Exracted from SalesForce CRM
• Ensure the development of the KPI’s in IntelDS (Amazon Redshift)
• Organize the workshops with technical team based in Philippine
• Ensure the development of the Tableau Dashboards
• Ensure the weekly Run process (Data extraction – Tableau reports)
• Qualify data, analyze issues, and manage their resolution & deliveries
• Define User Acceptance Tests (UAT) with the end users (800 managers)
• Assure Tableau Administration , user access management and Run
• Write users training document and participate to training organization & workshop session
Project- BFS BI(Bridge Field Services- Management and Operational Support
• Take in charge the evolutions of requirements defined by the business
• Manage team of (4-8 people) based in France , Philippines , India
• Manage and Run 40 KPI’s and dashboards (DEV-QA-UAT–PROD )
• Provide a Level 3 and operational support to the business
• Ensure the monthly Run process (Data extraction in AWS – Deployment of Tableau reports)
• Manage the BI-Weekly meetings to follow up all projects (Build and Run)
BI Business Analyst – Société Générale
Project TOMFIR - Enterprise Datawarehouse management - BDF (Bank Details of France)
Within ITIM, the Risk and Finance Management Department (PRF):
• Analyze the expression of need (framing)
• Elaborate the functional and technical specifications
• Define the Star schema data conceptual model (MCD) (tool Hopex-MEGA)
• Monitor the progress of end-to-end changes from the design phase to the production phase
• Create Power BI reports - KPI extraction for the financial direction of the Société Générale (700 End Users)
• Datalake Migration to Big Data (Spark)
• Ensure the Bank approval and testing (control-M – Unix – Azure Devops)
BI Data Analyst - Orange
Project Orange Reporting
• Build a solution for managing and monitoring the economic performance of the IT department at Orange
• Analyze and elaborate the expression of needs with the business
• Manage the project planning (Agile Scrum-Trello)
• Design the DataWarehouse in Microsoft Sql Server(Star Schema)
• Developp ETL and load the Datawarehouse using Talend
• Create reports and dashboards in Power BI
Technologies: (CRM: Salesforce / Cloud: Amazon AWS S3-Redshift- Microsoft Azure
/PowerQuery-SQL-Tableau Prep/ Reporting: Tableau - Salesforce CRM Analytics, Power BI
BI BUSINESS ANALYST, SOCIETE GENERALE
PARIS – Octobre 2018 à Decembre 2019 ( 1 an ++)
Au sein de ITIM, le département Pilotage Risques et Finance (PRF):
Accomplissements :
• Rédaction du dossier de conception (spécifications fonctionnelles et techniques)
• Réalisation du modèle conceptuel de données MCD (Fact Table,Dimension)
• Suivi de l'avancement des évolutions (DEV-QA-UAT-PROD)
Technologies: ( ETL : IBM Datastage / Microsoft Azure - Reporting: Power BI )
CHEF DE PROJET BI , ORANGE
PARIS – Septembre 2017 à Septembre 2018 (1 an ++)
Mettre en place une solution BI pour la gestion et le suivi de la performance
économique de la Direction des systèmes d’information DSI .
Accomplissements :
• Planification et gestion du projet Agile (Scrum)
• Conception du DataWarehouse modèle en étoile (Star Schema)
• Développement ETL et chargement du Datawarehouse
• Création des rapports et des tableaux de bord (10 KPI’s)
Technologies: (ETL : Talend / SQL Server , Azure - Reporting: Power BI)