Numidia Chaouadi Email & Phone Number

Rouen, FR

• Client: SpiritProjet de reporting de données commercialisation et financiers
• Reprise de rapports existants
• Reproduction de rapports suivant un modèle fourni par le client
• Simplification des requêtes SQL pour déporter les règles de gestion dans les outils (hiérarchies etc.)
• Création de rapports avec certaines complexités
• Ateliers de spécifications des KPI à suivre dans la BI

• Client: SeqensMarketing data reporting project
• Unit costing of SSRS and Power BI reports
• Creation of Power BI data models
• Reporting proposal and Power BI and challenging user’s need
• Functional analysis of business requirements
• Power BI reporting: Track delivery progress, worker load, data consistency

• Client: EliorCentralized recovery data on a full Azure platform
• Resumption of the 2020 project
• Evolutions
• Workshops of user acceptance test

• Client: Bouygues constructionReporting of financial and logistics data
• Harvesting business needs
• Data cleansing work (duplicates, sources + different file structures)
• Setting up the data model
• Workshops of user acceptance test
• Visual suggestion

• Client: Air LiquideBI Europe production follow-up
• Production monitoring of critical RUNS of financial closes
• AWS Data Lake architecture to Azure DWH
• Data transformation analysis with ADF Data Flow
• Identifying errors from the ADF log Monitor
• Error analysis and direct action

• Client: LeetchiData migration from an on-premises DB to multiple DBs on the Azure cloud
• Specification workshops and data validation
• Proposal on the method used (SSIS / ADF / Hybrid DB)
• Setting up dataflows + optimizing performance

• Client: in'liInitialization of a project to centralize rental path data on a full Azure BI platform
• Functional specifications
• Set up Azure tools
• Setting up ADF pipelines to retrieve data from different sources (Dynamics + SQL DB) in the Data Lake and sending them to the DWH (SQL DB)
• Creation of functions to read, sort and transform the data from the Data Lake using Serverless Synapse with a delta load management
• Unifying data and additional transformations via stored procedures in the SQL database

• Centralized data recovery on a full Azure platform
• Setting up ADF flows:‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎o SQL DB → Data Lake (ADF Copy, full and delta)‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎ ‎‏‏‎o Data Lake → DW (ADF data flow)
• Organization of the project’s backlog
• Setting up Azure tools
• Implementing security with Key Vault
• Integration and continuous deployment (CI/CD)

• Client: BruneauMarketing tools redesign project
• Monitoring the progress of the development of bidirectional delta flows (SQL DB <=> Dynamics) carried out by another data consultant
• Data specification workshops and validation of the data scope to be integrated
• Project takeover of dataflows and validation of the data by the business

• Client: SogefiRedesign of data flows from BackOffice data (SAP) to Dynamics 365
• Reverse engineering of the existing solution (SSIS, SQL, C#)
• Need analysis and proposal for new project architecture
• Drafting functional specifications and data mapping with business validations
• Setting up SSIS data flows (SAP HANA → SQL DB → Dynamics 365)
• Continuous deployment of the Data solution.

• Client: in'liProject carried out as part of the deployment of a marketing platform carried out with Microsoft Services on Dynamics 365
• Definition of the architecture of the data transfers needed for the project
• Collaboration/Intermediary between the DWH data recovery team and the Dynamics team
• Specification workshops and validation of data needs
• Setting up bidirectional delta SSIS data flows (SQL DB <=> Dynamics 365)
• Optimization of SSIS dataflows

• Client: AlesProject to migrate servers from 2008 to 2016 used by a custom mobile application
• Defining the target project architecture and specifying environments
• Migrating SQL, SSIS, and SSRS from SQL 2008 R2 to SQL 2016
• Upgrading SSIS Packages and custom components
• Technical documentation of environments
• Acceptance tests from start to finish

• Client: TerrealPOC Power BI report based on Dynamics 365 data
• Creating the Data Model
• Proposal of restitutions & visualizations
• User presentation
• Training an internal team to create SSIS dataflows from SQL database to Dynamics 365

• Client: SynergieCustomer data centralization project on Dynamics 365
• Data specification workshops
• Creation of a Power BI data model based on Dynamics data
• Power BI report security (RLS)
• Organization of the project’s backlog
• Third party maintenance on SSRS reports integrated on Dynamics

• Client: SisleyData centralization project on Selligent CRM
• Evolution of the functional scope previously implemented
• Evolution of SSIS interfaces
• Assistance to the internal production deployment team

• Client: AprévaData centralization project on Selligent CRM
• Data Specification Workshop
• Evolution of SSIS Power Interfaces
• Redesign of the project (naming, deletion of obsolete objects...)

• Client: Ciment-CalciaProject of centralization and reporting of customer data, stocks etc.
• Evolution and fix technical and functional data integration (Stored Procedures, SSIS)
• Fixing existing SSRS reports
• Security management on reports

• Client: EconocomProject for the retrieving data from a telephone call center
• Reverse engineering from expected output Excel files using the existing data from the production SQL DB
• Creating SSIS dataflows sending the expected Excel files by SFTP
• Scheduling of SSIS packages
• Production launch