Jean-Pascal Lack
Expert Power BI
Salaire / Taux journalier
Paris, France
Freelance
À distance uniquement
Expertises
Langues
Expérience de travail
Tech Lead Power BI
Sanofi
mai 2022 - Présent
4 ans 6 mois
À distance
- Participated in the identification, understanding, and documentation of business requirements - Exchange with business to create some specific KPI to measure efficiency of the activity. These KPI developed in DAX help to provide greater visibility into data. - Translate some business requirement into insightful Power BI visuals. - Working with Power BI Service for creating Dashboards and sharing them to business users. - Set up of Row Level Security (RLS) on Power BI report in order to only display some specific data to end user according to their rights - Implemented some non-regression automated tests on Power BI to track any issue that could come from modification in the database or Power BI. - Develop Power Point files that is dynamically link to the Power BI report, and therefore can use the visuals/interactions from Power BI reports - Communicated regularly with both IT and non-IT teams to ensure knowledge transfer between cross functional teams. - Set up of automated email alerts on Power BI when some specific target point are reached for some KPI.
Consultant Power BI
AXAL
mars 2022 - Présent
4 ans 8 mois
À distance
Déploiement de Power BI au sein de la société pour différents services afin de remplacer et améliorer les rapports existants. Création des rapports suivants : - Rapport Power BI d'état financier de la société, (comparaison versus l'exercice précédent, et comptabilité des différents services d'AXAL) - Création des rapports Power BI partagé avec des clients d'AXAL pour le suivi des KPI AXAL - Autres dashboard PowerBI (suivi CA, consommation gasoil RSE, suivi pointage et horaires, calcul rentabilité des projets) Particularités : - optimisation des rapports pour vue mobiles - création d'alertes automatiques par email déclenché par Power BI lors du franchissement d'un seuil. - mise en place de row-level security (RLS)
BI Manager
BMS International
avr. 2021 - sept. 2022
1 an 6 mois
Moka, Maurice
BMS was founded in 2016, and is now ranked among top 100 EU Amazon FBA sellers. We create and commercialize brands on e-commerce platforms. Within BMS, I am in charge of the IT & data team. Our main mission is to deliver accurate data and insights for the different departments (Sales, Finance, Management, Sourcing, Marketing) of BMS. My missions : - Develop PowerBI reports - Develop automated tools with Google Sheets - Continuous improvement of process and tools - Manage one Senior Data Engineer
Sightness
oct. 2016 - mars 2021
4 ans 6 mois
Moka, Maurice
Operations Data Manager
avr. 2018 - mars 2021
3 ans
Moka, Maurice
Our job : Analyze and handle multisourced data to enable our clients to optimize their goods' transport. My missions : - Opening of a new department starting with 6 data analysts, growing up to 14 data analysts - In charge of the onboarding of new clients ( invoice control and Power BI Dashboard following the expense and the quality of services of companies) - Train and coach of advanced analysts and teams leaders - Direct our software development - Management of the team on a daily basis ( also involves recruitment , regular appraisal meeting , team building, management of risks and priority) - Follow up of the growth of our office in Mauritius ( starting with 15 employees and now 50 employees)
Project Data Manager
juin 2017 - mars 2018
10 mois
Moka, Maurice
My missions : - Manage group's project - Develop intelligent and dynamic dashboards for our clients using Power BI. - Participating in the continuous improvement of our operations and services. - Acting as a quality assurance officer and guarantee the internal quality of our services. - Direct our software development
Data Analyst
oct. 2016 - mai 2017
8 mois
Moka, Maurice
- Fast learning of best practices in the road transport sector; - Controlling and analysis of the expenditure Transport by means of invoice audits and dashboards; - Onboarding of new clients and creating dashboards on Power BI according to our client needs; - Formalisation of analysis and production processes; - Automation of production stages;
Formation
Centrale Méditerranée
Diplome d'Ingénieur, Engineering
2010 - 2014
5 ans
Activités et associations : - Voluntary worker at Ecole Centrale Marseille Student Social Club. - Co-organiser of TVP 2012 (race across Marseille harbour ) - responsible for PR - promoting event attracting 200 students.
General engineering knowledge : management, mechanical engineering, Lean manufacturing, logistic
The University of Sheffield
Master of Science (MSc), Aerodynamics
2012 - 2013
2 ans
Résultat : MSc with Distinction
Final year project : Study of the influence of an empty car on freight train’s aerodynamics through CFD
Licences et certifications
Maîtriser l'analyse de données avec Power BI
Délivré le : juil. 2021
Power BI : Visualisations avancées et notions clés du DAX
Délivré le : juil. 2021
Power BI avancé : L'analyse de données avec DAX
Délivré le : juil. 2021
ISTQB (International Software Testing Qualifications Board) - foundation
Délivré le : janv. 2016
Portfolio
