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• Création de la solution SQL BI avec procédures stockées de transformations• CICD du projet SQL et ADF sur trois environnements• Création du reporting sur Power BI avec travail sur l’UX/UI o Background o Thème police et couleurs o Fields parameters o Filtre de dates selon le contexte du KPI analysé

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• SSRS reporting integrated with Dynamics: purchase and sales tracking, sales tracking, data consistency• Production monitoring and error analysis

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• Production tracking, data refresh and error analysis

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• Creating a star schema model on Azure Analysis Services• Power BI report

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)• Model modeling in Power BI• Power BI Data Security (RLS) in a pyramid hierarchy• Power BI reports suggestion• Reporting Services (SSRS) reports based on the Power BI model

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.• Dynamics 365 optimization• Production launch & Third party maintenance • Transfer of knowledge to the Dynamics team, for the project’s takeover

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• Scheduling of SSIS packages• Organization of the project’s backlog• Built-in and contextualized SSRS reports in Dynamics: tracking sales progress, customer information• Creating Power BI Data Models & Reports• Training internal team to overtake the project: SSIS packages and Power BI reports• Drafting training documents, and follow-up of the internal team skills development• Production launch + Third party maintenance

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• Deployment in production and management of the business switchover

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