About Ppierre
French
Native or bilingual
English
Native or bilingual
Experience
- SNCF RéseauConsultant Data Analyst BITRANSPORTATIONDecember 2024 - Today (1 year and 6 months)Paris, FranceData Governance, BI Steering, AMOA support within DG Num. Transverse BI referent for several service centers.● End-to-end industrialization of 12 penalizable SLA indicators under Power BI for 4 major service centers (CGI, Sopra Steria x2, Capgemini): from business rules to production deployment, including dev → testing → prod environment management and RLS (Row Level Security).● Design and deployment of an inter-departmental BI repository based on workshops to align on application repository normalization.● Automation of project manager satisfaction surveys (Microsoft Forms & Power Automate) for Steering Committees.● Quality improvement of contractual indicators in weekly meetings — remediation and convergence workshops with suppliers, direct support for decision-making by Sourcing, Finance, and Steering teams.● Drafting technical and functional specifications, access management (Active Directory, technical flows, databases), change management.Stack: Power BI · DAX · Power Query · Power Automate · Microsoft Forms · SQL Server · Active Directory · SharePoint · Jira · RLS
- PwCConsultant BI & Data EngineerCONSULTING AND AUDITSFebruary 2023 - November 2024 (1 year and 9 months)Paris, FranceMaintenance of the Magic XPI integration layer, HR and client management scope.● Design and development of integration flows, data mapping, job creation, and SQL Server database enrichment.● Production incident management, remediation, MOA coordination, and documentation of operating procedures.● Normalization of SQL transformations and procedures, corrective and evolutionary maintenance in Agile Scrum mode.Stack: Magic XPI · ETL · MS SQL Server · SQL · Stored Procedures · Agile Scrum
- SAIPEM SpAData Analyst BIENERGY AND UTILITIESSeptember 2021 - August 2022 (11 months)Paris, FranceEco-design & IT Carbon Footprint Project● Collection and transformation of multi-source data (+13,000 equipment, 19 asset types, 6 cities), cleaning, and enrichment via Python (Pandas, Jupyter).● Design and deployment of a Power BI dashboard for IT carbon footprint monitoring, presented to the France and Italy teams.● Automation of carbon footprint calculations via Power Automate and integration of flows via REST API.Stack: Power BI · Power Query · Python · Pandas · Jupyter · Power Automate · REST API
Recommendations
Be the first to recommend Ppierre
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
- Master 2Panthéons-Assas Université2023Master 2