About Billal
French
Native or bilingual
English
Fluent
Arabic
Conversational
Experience
- Air FranceData AnalystAVIATION AND AEROSPACEJuly 2023 - Today (3 years)Tremblay-en-France, FranceRole: Consultant Data Business AnalystContext – The Data 'Flight Program' team (AMO) ensures the development of BI reports with the business for decision support (Team of 5 people)
- Functionally:
- Gathering requirements from Business teams (Long & Medium haul and Regulation teams).
- Analyzing user needs and determining data consistency requirements.
- Defining technical specifications in collaboration with BIG DATA teams (data sources to query, data snapshot frequency...) and validating final datasets.
- Validating BI reports developed with business teams (workshops, brainstorming, user support)
- Mentoring a Data Analyst intern
- Technically:
- Development of POWER BI reports:
- Data modeling (star schema) – Database queried: Teradata
- Power Query, M language for data preparation.
- Development of business KPIs, visualization, pagination, and intuitive menu.
- Creation of measures and calculated columns (DAX)
- Automating report refresh on the server
- Creation of a Power BI application serving as a report catalog.
- User rights management (role creation, access)
- Development of SPOTFIRE reports (SQL
# - Royal CaninData Engineer & Data AnalystAGRICULTURENovember 2021 - Today (4 years and 9 months)Bois-Colombes, FranceIBM/ Royal Canin ProjectInternational project, 100% in English.Role: Data Engineer & Analyst within the 'Digital Governance' teamContext - The 'Digital Governance' team's role is to ensure that digital assets (website, social media, applications, etc.) comply with Mars' policies, codes, and standards. This is a key area for maintaining consumer, customer, and associate trust.Achievements:▪ Development of a Pyspark script on Databricks / Azure DevOps to collect data from various sources for reporting needs.▪ Development of a Power BI report to monitor the Royal Canin ecosystem, then other segments.▪ Leading periodic sessions on website vulnerabilities.▪ Working with teams worldwide to help them comply with Mars standards.Project Results - Development of an automated dashboard to guide activities, present results to the Business Owner, and take concrete actions.
- L'OréalData Analyst & Data EngineerFASHION AND COSMETICSJuly 2020 - August 2021 (1 year and 2 months)Bois-Colombes, FranceData Engineer & Data AnalystIBM/ L'Oréal ProjectInternational project, 100% in English.Context - L'Oréal launched the 'ELIXPEDIA' program, a unique global data catalog. The migration and upgrade were carried out from the old system in place (SAP) to the new one (Elixpedia MDM).Achievements:▪ Development of BI reports to monitor activities and data quality (Power Bi, SQL, R...)▪ Execution of reports to monitor the migration / upgrade.▪ Responsible for the Back Office team - 3 people (organization, task allocation, activity monitoring...)Project Result - Management of the Data Factory technical team and monitoring of several deployments worldwide.
Recommendations
Be the first to recommend Billal
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