Cédric Pittet

Experience

• 

  KBA-NotaSys SA

  Oct 2011 - Apr 2016

  Business AnalystManage business oriented IT projects- Project management, workshops, redaction of functional and technical specifications. Software development follow-up, QA tests and production deployment.- Main projects : o SharePoint 2013 deployment: new corporate intranet and collaborative workspaces o Continuous improvement of our ERP system (MS Dynamics AX 2009). E.g.: implementation of a new purchase order approbation workflow o Implementation of a product configuration software (Camos) in relation of a SAP migration: Interface specification (data migration) between our ERP and Camos, System administration, user rights management, quality assurance.- BI : create, improve and maintain business reports (SQL Server, SSRS)DBA : ERP Technical Manager / SharePoint 2013 administratorMaintain maximum availability of supported services for users (ERP, SharePoint and other apps)- Application server : delivery management, upgrade, environment cloning- Database : maintain data integrity, performance analysis, backup strategy- User rights management of the ERP system, BI servers and SharePoint- TMA coordination with our suppliers (planning and first quality assurance tests)- Level 2 IT support Show less

  • Business Analyst - System administrator

    Jan 2013 - Apr 2016

  • Junior Business Analyst

    Apr 2012 - Dec 2012

  • Internship as a Business Analyst

    Oct 2011 - Mar 2012
• 

  PTC

  Sept 2016 - Mar 2022

  I'm working as a senior analyst & developer BI for the Data Team at D'Ieteren Auto.The purpose of the Data Team is to develop and maintain the company’s Data Warehouse, datamarts and the reporting tools. We are using the following technology : MS SQL Server 2016, PowerShell, PowerBI, Azure Data Factory, Microsoft Azure, Cognos, QlikView.Main achievements:- Creation of a new Datamart for the after-sales department as Technical LeadThe objective of this new Datamart is to centralise and consolidate data from several new operational systems in order to improve the business processes of the After-Sales department (Interventions, Warranty, Dealer’s bonus calculation). - Management of a small team of developers in an Agile environment (SCRUM) - Data ingestion and development of the Datamart (SQL Server): 40 fact tables and 65 dimensions- Development of a new PowerBI dashboard for Network Dealers.The purpose of the dashboard is to enable managers and operational teams to have a better overview of daily operations and a global view of performance. - Analysis and assessment of 200+ KPIs across 5 business domains - Development of ETL processes (PowerShell & SQL Server) - Development of PowerBI dataset & report for the Bodyshop business domain- SalesForce data ingestion with Azure Data Factory to create a Datamart for the Marketing Department- Automation of PowerBI refresh with PowerShell & XMLA to improve data availability- Improvement of the ETL framework logging system with PowerShell and SQL Server - Better data synchronisation between Azure Data Warehouse and DataVault - Reduced maintenance costs due to a more stable ETL environment- Continuous improvement of the Data Warehouse to meet the business requirements - Documentation of specifications and data modelling (DataVault) - Data ingestion of multiple sources (SQL development) - Realization of a POC for a new CI/CD workflow on Azure DevOps and Azure Synapse Show less Scope of the project: Reporting Platform migration from Oracle / Crystal Report to MS SQL Server 2016 (Full stack).The purpose of the Reporting Platform is to provide Performance and Availability reports of all the Services (Web site, Web app, Web Services, Mobile app) developed by Smals. Achievements - Gather requirements and business rules of the existing system. - Design a new Datawarehouse using data modelling techniques (Kimball Schema) - Design and implement ETL processes - Design performances and availability reports - Implement a master data management system - Set up interfaces with other business teams and with the Configuration Management Database - Provide technical documentations Technologies - Microsoft SQL Server 2016 full stack (SSMS, SSIS, SSRS, SSAS) - Master Data Services 2016 Show less

  • Senior Analyst & developer BI chez D'Ieteren Auto

    Feb 2019 - Mar 2022

  • Analyste & développeur BI chez Smals

    Sept 2016 - Jan 2019
• 

  BMS Building Materials Suisse

  May 2022 - now

  Senior Data Analyst