Freelancer profile translated to English.
Back to original languageAbout Abdessamad
I am a passionate Business Intelligence (BI) and Data Engineer consultant with over 13 years of experience in designing, developing, and deploying high-performance BI solutions. I have worked with companies across various sectors, from finance to telecommunications, including large-scale projects in the banking sector.
My Key Skills:
- Business Intelligence:Design and deployment of interactive dashboards with Power BI, SSRS, and Tableau. I have a strong background in creating analytical cubes with SSAS and Azure Analysis Services.
- Data Engineering:Expertise in building and populating Data Warehouses on cloud platforms like Google Cloud Platform (GCP) and Azure. I am proficient in ETL tools such as Microsoft SSIS and DBT for efficient data integration and transformation.
- Databases:Skilled in managing and optimizing relational and multidimensional databases (SQL Server, Oracle, PostgreSQL, etc.), as well as data modeling for complex projects.
- Data Analysis:Ability to gather and analyze business user requirements to provide suitable BI solutions. I am comfortable with programming languages like SQL, Python, and C# for advanced analysis.
My Achievements:
- Designed and deployed Power BI dashboards to improve sales team performance, resulting in a measurable increase in efficiency and sales.
- Implemented Data Warehousing solutions on GCP, consolidating millions of data points from multiple sources, enabling reliable, real-time data-driven decision-making.
- Managed BI projects from start to finish, including data modeling, development, production deployment, and user training.
French
Native or bilingual
Arabic
Native or bilingual
English
Fluent
Can work on-site
Nanterre (up to 50km)
Experience
- Orange FranceDATA ENGINEERJanuary 2020 - February 2023 (3 years and 1 month)Projects:• Creation and population of a Data Warehouse on GCP, BigQuery to centralize and consolidate customer and vendor data from multiple channels (CRM, call tracking tools, appointment management applications) into a single data warehouse, using data pipelines with the DBT framework.• Design and creation of Power BI Dashboards to analyze vendor performance data on interactions (response rate, call duration, appointment success), improve tracking and targeted actions, identify business opportunities, and provide dynamic dashboards for managers to track KPIs related to customer interactions and team performance.Mission: 1. Needs Analysis:• Gather and analyze business user needs via Jira/Confluence.• Write functional and technical specifications. 2. Data Pipeline Development:• Create workflows with DBT to transform data in BigQuery.• Write optimized SQL queries for data transformation and aggregation in BigQuery.• Automate data pipelines with Cloud Run. 3. Data Integration:• Load data into Google Cloud Storage (GCS) from external sources.• Perform ETL/ELT by combining BigQuery, DBT, and Python.Environment: Google Cloud Platform, BigQuery, Cloud Run, Google Cloud Storage, DBT, SQL, Jinja, Python, Github, Jira, Confluence, Power BI
- Groupe BPCEBI ConsultantFebruary 2023 - Today (3 years and 4 months)Projects:• Design, creation, and deployment of an Azure Analysis Services tabular cube and Power BI dashboard for the Risk Management department.• Design, creation, and deployment of a Power BI dashboard for the Special Affairs department (litigation management).Mission: 1. Data Modeling and Management• Design the data model and tables in Hadoop.• Perform data transformation steps with SQL Hive. 2. Creation and Deployment of Analysis Tools• Design, creation, and deployment of AAS (Azure Analysis Services) cubes.• Design, creation, and deployment of Power BI dashboards. 3. Source Code Management and CI/CD• Manage source code with Git and Bitbucket.• Perform build and deployment pipeline for cubes via Jenkins. 4. Release and Deployment Management• Manage releases with the XL Release tool.• Deploy to production via XL Deploy.Environment: Hadoop, SQL Hive, Azure Analysis Services (AAS), Power BI, Git, Bitbucket, Jenkins, XL Release, XL Deploy, JIRA, Confluence
- Microsoft pour OrangeMicrosoft BI Consultant and Tech LeadNovember 2016 - December 2019 (3 years and 1 month)Projects:• Migration from SQL Server 2014 to 2017.• Creation and deployment of a new tabular cube for Enterprise sales data under SSAS 2019.• Migration of Power BI dashboards based on an Import mode database to the tabular cube in LiveConnection mode.• Development of reports and Power BI dashboards for sales and national stakeholders.Mission:• Participation in project workshops, task definition, and planning.• Tabular cube development and deployment.• SSIS package development.• T-SQL script development.• MDS 2019 development and deployment.• Dashboard development and deployment (Power BI).• Acceptance testing assistance.• Tech Lead for a team of 6 developers (skill development, unblocking issues, code reviews, code optimization, etc.).• Ensuring adherence to best practices for development and deployments on Microsoft DevOps.Environment: Microsoft BI (SSIS, SSRS) 2017, SSAS 2019, Power BI on premise, SharePoint 2013, Windows Server 2012, Windows Server 2016, Microsoft SQL Server 2017, Visual Studio 2019, Microsoft Devops
Recommendations
Be the first to recommend Abdessamad
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
- Computer Engineering DegreeCompiègne University of Technology2011Diplôme d'ingénieur en Informatique
- Physics and Engineering SciencesPreparatory classes for higher education schools2008classes préparatoires aux grandes écoles
Certifications
- Analyzing and Visualizing Data with Microsoft Power BIMicrosoft2022
- Microsoft Certified Solution Expert (MCSE): Business Intelligencemicrosoft2014