MGFreelancer profile translated to English.
Back to original languageAbout Magamou
I am a Data Analyst Project Manager, passionate about data as a lever for decision-making and performance. For several years, I have been involved in complex data projects in demanding environments, particularly in the public, IT consulting, telecommunications, banking/insurance, and services sectors.
My expertise is based on three fundamental pillars:
1 - Business analysis, needs assessment, and key indicator modeling.
2 - Technical data exploitation, with strong experience in Power BI, SQL, and Python (automation, cleaning, transformation, predictive modeling).
3 - Project management, with a structured approach: team coordination, planning, deliverables, communication, and change management.
My technical expertise
Power BI (expert): modeling, advanced DAX, Power Query (M), publishing, workspaces, security (RLS), automatic refresh, performance.
Python (advanced): pandas, numpy, matplotlib, seaborn, scikit-learn, Excel/CSV file automation, APIs.
SQL (querying, complex joins, optimization)
BI/ETL Tools: Talend, Power Automate
Cloud & Databases: Azure, MySQL
Project Methodologies: requirements gathering, roadmap, specification writing, acceptance testing, documentation
My key achievements (concrete examples)
Power BI project for a large IT consulting group: industrialization of operational reporting for incident tracking, automation of the data pipeline (Python + Power Query), 80% reduction in report production time.
Support for an IT support department: creation of a volume prediction model (Python + Prophet) to anticipate activity peaks and adjust resources.
Data project manager for an IT consulting firm: implementation of a job offer database, cross-referencing with internal skills to automatically generate staffing recommendations (Power BI + Python).
French
Native or bilingual
English
Fluent
Can work on-site
Paris (up to 50km)
Experience
- Consort Group,Data AnalystDIGITAL AND ITNovember 2021 - March 2025 (3 years and 4 months)Paris, FranceMission 1: Consort Group for the management (11/21 – 08/22)• End-to-end data project management (scoping, prerequisites, development, validation, acceptance testing).• Analysis and visualization of data for regular reports to senior management (Dashboards and KPIs) to improve decision-making processes. Environment: Power BI, DAX, SQL, Talend, Project ManagementMission 2: Société Générale (09/22 - 03/23)• Design and implementation of predictive models to improve call and ticket forecasts for the service desk on behalf of Société Générale to optimize the client's financial resources.• Development of AI tools to enable technicians to respond to messages without making mistakes. (Auto-correction).Environment: Python (Forecasting), Power BI, AI, DAXMission 3: Axa (04/23 - 12/23)• Definition of data architecture and implementation of analytical solutions with Power BI and Python.).• Creation of a new tool for displaying predictions through the execution of Python scripts on Power BI (Python-Power BI connection) for a client to facilitate the use of Python scripts for non-initiates.Environment: Python, Power BI, Power Automate, SQL, Azure AutoMLMission 4: Consortia (01/24 - 07/24)• Scraping job offers from certain job sites with Beautiful Soup.• Database creation and cleaning (MySQL, Azure data factory).• NLP on job offers to identify the best offers.Environment: Python, NLP, Azure, SQL, GitMission 5: Banque de France (09/24- 03/25)• Extraction, analysis, and visualization of Eloquant ticket and call data• Analysis of the Microsoft Exchange Mailbox connected directly to Power BI. Environment: Power BI, DAX, Excel, Microsoft Exchange, Project Management
- FITECData Scientist and Decision MakingEDUCATION AND E-LEARNINGJuly 2021 - December 2021 (5 months)• Analysis of retail sales data to identify trends, patterns, and opportunities for sales performance optimization. Data collection and preprocessing, exploration to identify bestsellers and growth opportunities, customer segmentation, sales forecasting. Environment: Python (pandas, scikit-learn) Power BI SQL• Data Scientist and Decision Making
Recommendations
Be the first to recommend Magamou
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Scientific DoctorateUniversity of Lorraine,2016Doctorat scientifique
- Master II Process Engineering, Physics Chemistry for EngineeringSup Galilée, Paris 13 University,Master II Génie des Procédés, Physique Chimie pour l'Ingénierie
Certifications
- Microsoft Power PL-300Microsoft Power BI