About Pedro
French
Native or bilingual
English
Fluent
Experience
- BNP-ParibasBUSINESS ANALYST: POWER BI EXPERTBANKING AND INSURANCENovember 2023 - December 2024 (1 year and 1 month)Paris, France
RDS Division – ITG-FRESH – Risk & Finance Transformation
Project to structure and industrialize decision-making data flows for strategic steering of Risk & Finance activities.Main Responsibilities:- Design of BI data architecture (ingestion, transformation, analytical layer)
- Development and automation of multi-source data pipelines
- Ensuring the quality, performance, and reliability of decision-making datasets
- Implementation of BI governance (security, access, environments)
Pipelines & Data Processing:- Automated collection from SFTP, SharePoint, ServiceNow (GRC)
- Cleaning, normalization, and transformation using Python & SQL
- Structuring analytical models optimized for Power BI
BI Layer & Analytics:- Development of strategic dashboards:
- Resources, budget, agility, risks, obsolescence, SharePoint migration
- Advanced DAX & performance optimization (volume, response time)
Industrialization & Security:- BI deployments in Dev/Test/Prod environments
- User access management (RLS, permissions)
- Technical & functional documentation (use cases, specs, guides)
Deliverables:- Automated data pipelines
- Documented data models
- Industrialized decision-making dashboards
- Deployment & governance procedures
Business Impacts:- Significant reduction in manual reporting processes
- Reliability of strategic indicators
- Better anticipation of IT risks
- Faster budget and resource decision-making
Stack:Python, SQL, Power BI, DAX, DAX Studio, SFTP, SharePoint, ServiceNow, AWS (S3, Lambda), ETL/ELT, CI/CD, Agile/Scrum - Accenture / AFD TechData EngineerCONSULTING AND AUDITSOctober 2022 - November 2023 (1 year and 1 month)Paris, France
La Fabrica – IT DSI Innovation Lab
Project within the IT DSI data lab to industrialize an intelligent matching engine between consultants and project opportunities, in order to optimize resource allocation and reduce idle periods.Main Responsibilities- End-to-end design of the AWS cloud data architecture
- Development and automation of ingestion and transformation pipelines
- Implementation of NLP processing for skills extraction
- Ensuring reliability, normalization, and structuring of analytical datasets
- Making results available via a BI layer
Pipelines & Data Processing- Automated ingestion via AWS Lambda to S3
- Data transformation, cleaning, deduplication, and normalization
- NoSQL storage in AWS DocumentDB / MongoDB
- Semantic enrichment via AWS Comprehend (NLP)
- Skills ↔ opportunities matching engine
Visualization & Reporting- Development of Power BI dashboards for matching monitoring
- Performance indicators for consultant assignments
- Decision support for staffing teams
Deliverables- Automated AWS pipelines
- Documented Lambda scripts
- Structured data models
- Power BI dashboards
- Functional use cases
- User guides & operating procedures
Business Impacts- Complete automation of the consultant/project matching process
- Faster project starts
- Reduction of inter-mission periods
- Improved quality of skill matching
Stack:AWS: S3, Lambda, DocumentDB, Amazon Comprehend - Python - NoSQL/MongoDB - Power BI - SAP BO - Power Automate - Jira - Confluence - SharePoint - Bouygues TélécomTransport PMO: Production ManagerTELECOMMUNICATIONSNovember 2021 - March 2023 (1 year and 4 months)Vélizy-Villacoublay, France
Hosting & Active Equipment Division – Transport Network Modernization Program
Operational steering and data structuring project for production monitoring for FTTA/FTTO deployment and core network equipment as part of the backbone modernization and 5G commercial launch.Main Responsibilities- Steering the FTTA and aggregation/core network equipment production project portfolio
- Multi-project planning, workload management, forecasting, and priority arbitration
- Monitoring of quarterly production commitments and management of inter-project risks
- Operational support for deployment teams on complex issues
Production Process & Data- Multi-source collection of field data (CSV, Excel, SharePoint, SAP BO)
- Data cleaning, deduplication, normalization, and aggregation
- Structuring of production monitoring databases (SharePoint, Osmose)
- Analysis of bottlenecks and implementation of action plans
Automation & BI Steering- Automation of reporting flows via Power Automate & Power BI
- Creation of production KPIs: deadlines, capacity, performance, risks
- Development of operational governance dashboards
Deliverables- Production data collection and transformation pipelines
- Decision-making Power BI dashboards
- Performance indicators and steering tools
- Production monitoring and governance processes
Impacts- Complete reliability of production data
- Improved visibility of schedules & capacity
- Reduction of deployment delays
- Better anticipation of operational risks
Stack:Power BI (DAX, Power Query), Power Automate, SharePoint, SAP BO, Oracle (Osmose), MySQL (GEDI), Excel, Visio
Recommendations
Be the first to recommend Pedro
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's Degree in Electrical Engineering and Digital SystemsUPEM2018