Mohamed BOUSAROUT

🛠️🔄📊 Renforcer les équipes durant l'absence d'une ressource clé (congé maternité), j’assure les responsabilités de Team Lead - Data Engineer, combinant coordination d'équipe, supervision des opérations et optimisation des processus. ● Supervision et gestion du backlog : Organisation et priorisation des tâches, garantissant la continuité des livrables. ● Maintien en condition opérationnelle (MCO) : Pilotage de l’environnement de production, assurant la stabilité et les performances de bout en bout, de l’intégration à la restitution des données. ● Gestion des incidents : Résolution proactive des incidents de niveaux 2 et 3, avec une approche orientée amélioration continue pour réduire les risques de récidive. ● Administration des accès : Gestion et sécurisation des accès via EPM Oracle pour une conformité optimale. ● Déploiement en production : Planification et exécution des mises à jour et des évolutions pour répondre aux besoins métiers dans un environnement dynamique. ● Reporting stratégique : Animation des réunions clés (COPIL, COTECH) et présentation des indicateurs de performance, contribuant à une prise de décision éclairée.

🛠️🔄📊 Join the Data/Salesforce team to enhance data integration capabilities in Salesforce, addressing the needs of multiple clients. ● Manage necessary updates and optimizations to improve the performance of data integration processes in Salesforce. ● Work closely with project managers to define business requirements, propose relevant solutions, and facilitate communication between technical teams and stakeholders. ● Responsible for estimating changes, tracking tasks, and drafting detailed reports for stakeholders, ensuring transparency and project management efficiency.

🛠️🔄📊 Data integration in GL events information systems with Talend ● Talend DI Expert: Design and implementation of robust and scalable data integration solutions with Talend, ensuring smooth data transformation and migration between systems. ● Advanced Querying: Expertise in querying on SQL SERVER, MySQL, Oracle, along with knowledge in SQL SERVER administration (optimization, diagnostics, backup, and restoration). ● Technical Specification Writing: Close collaboration with teams for drafting technical specifications, ensuring that solutions meet business needs.

🛠️🔄📊 Key responsibility in migrating over 1000 SSIS/SSRS flows from SQL2012 to SQL2019, ensuring a smooth transition and performance improvement. ● Project Management: Full management of the migration project, ensuring effective planning and execution. ● SSIS & SSRS Migration: Successful migration of various SSIS flows and SSRS reports of different types, while ensuring compatibility with SQL2019. ● Quality Control: Rigorous testing with output data verification, ensuring data integrity and accuracy post-migration. ● Monitoring & Reporting: Regular reporting on completed tasks to ensure transparency and effective communication with stakeholders. ● Workload Estimation: Accurate evaluation of the workload required for complete migration, enabling optimal resource allocation.

🛠️🔄📊 Source data integration (API, SFTP, Database, CSV, etc.) with Talend in Salesforce ● Data Integration: ETL Talend data integration into Salesforce ● Salesforce Goéland Support: Technical support levels 1, 2, and 3 for the Salesforce Goéland platform ● Functional Context: Ability to quickly understand the functional context of projects and adapt to the specific needs of the client's activity ● Development & Testing: Development followed by unit testing to validate code quality ● Technical Documentation: Writing clear documents, including technical specifications, to facilitate understanding and maintenance ● Project Delivery: Active participation in the production phase to ensure a smooth project transition to production.

🛠️🔄📊 Development/maintenance of SSIS flows, decision modeling (DWH, DMs), and reporting via SAP BO for the company's various business units, management of the BI PEDRETTI project (meeting planning & business requirements gathering, identification of technical specifications, estimation). ● Functional Analysis: In-depth evaluation of functional needs and their formalization to ensure a tailored solution. ● Technical Specifications: Development of technical specifications to align technology with business needs. ● Technical Architecture: Definition of technical architecture to ensure performance and scalability. ● Integration with SSIS: Feeding and optimizing data warehouses with the SSIS tool. ● Reporting with SAP BO/Power BI: Creation of universes, datasets, data flows, and provision of key indicators for end users using SAP BO/Power BI. ● Quality Assurance & Management: Development following the company's quality assurance standards while ensuring optimal cost and time management.

🛠️🔄📊 Development and maintenance of an Rshiny application for the visualization/communication of medical analysis results of patients' intestinal microbiota. ● Dashboard: Synthesis of all analysis results in a dashboard format. ● Automated Reporting: Generation of automated reports for patients and their treating physicians. ● Data Cleaning and Transformation: Cleaning and transforming FASTQ data from NGS sequencing. ● Statistical Modeling: Statistical modeling of data from the NGS sequencer (ZIP, ZINB, Trans. Log ratio). ● R Shiny Application and MySQL Database Connection: Connecting the R Shiny application with the MySQL database of microbiota patients. ● Web Application Development: Designing and developing a web application for automatic email sending to the treating physicians of each patient who has ordered microbiota analysi

🛠️🔄📊 Design and development of a web application for stock and customer management for a store as part of a final year project ● Stock and Sales Management: Manage the store's stock and sales. ● Customer Management: Create and communicate with customers about promotional operations. ● Sales Analysis: Analyze sales over different time periods and make forecasts. ● Customer Satisfaction: Analyze and monitor customer satisfaction.

🛠️🔄📊 Modeling, development, and maintenance of the database for a Java Desktop application dedicated to commercial management. ● Database Modeling: Design and structure the database. ● Development of Stored Procedures: Create and delete user accounts to ensure secure access to the application. ● Client and Order Management: Develop stored procedures to optimize the commercial process for managing clients and orders. ● Billing Management: Develop stored procedures for generating, editing, and tracking invoices for clients.