Nicolas Parot-Alvarez
Data Architect and Data Engineer at CRE - Commission de régulation de l'énergie- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Français Native or bilingual proficiency
-
Anglais Full professional proficiency
-
Espagnol Professional working proficiency
-
Japanese Elementary proficiency
Topline Score
Bio
0
/5.0 / Based on 0 ratingsFilter reviews by:
Experience
-
CRE - Commission de régulation de l'énergie
-
France
-
Government Administration
-
100 - 200 Employee
-
Data Architect and Data Engineer
-
May 2021 - Present
Designing and developing the data software and infrastructure to provide data to the market surveillance analysts and investigators, contributing to the energy market regulatory systems at the EU level. Python ELT, Dagster, DBT, SQL Server, Metabase, Gitea, GnuPG Designing and developing the data software and infrastructure to provide data to the market surveillance analysts and investigators, contributing to the energy market regulatory systems at the EU level. Python ELT, Dagster, DBT, SQL Server, Metabase, Gitea, GnuPG
-
-
-
Brevo
-
United States
-
Software Development
-
Data Architect and Data Engineer
-
Jan 2019 - May 2021
Designing data architectures and developing data pipelines for all departments of the company, examples: features usage for product, NPC and revenue reporting for executive, page views for marketing, accounting reconciliation for finance, identity and behavior data for compliance, collection and aggregation for data science, architecture and nomenclature for software architecture... I manage and develop data projects from A to Z: from collecting the needs and analyzing where data could… Show more Designing data architectures and developing data pipelines for all departments of the company, examples: features usage for product, NPC and revenue reporting for executive, page views for marketing, accounting reconciliation for finance, identity and behavior data for compliance, collection and aggregation for data science, architecture and nomenclature for software architecture... I manage and develop data projects from A to Z: from collecting the needs and analyzing where data could be found in the backend, redacting specifications for developer to improve the quantity and quality of data, to the final reporting layers for analysts and executives, solving all the technical challenges in between with coding and designing the right data tools architecture. I work inside both the data team and the software architecture team, leading overlapping projects (event architecture, metadata catalog), contributing to others and training people. Python, SQL, Apache Spark, Redshift, S3, GCP, Pub/Sub, MySQL, MongoDB, Qlik, Amplitude, Chart.io Show less Designing data architectures and developing data pipelines for all departments of the company, examples: features usage for product, NPC and revenue reporting for executive, page views for marketing, accounting reconciliation for finance, identity and behavior data for compliance, collection and aggregation for data science, architecture and nomenclature for software architecture... I manage and develop data projects from A to Z: from collecting the needs and analyzing where data could… Show more Designing data architectures and developing data pipelines for all departments of the company, examples: features usage for product, NPC and revenue reporting for executive, page views for marketing, accounting reconciliation for finance, identity and behavior data for compliance, collection and aggregation for data science, architecture and nomenclature for software architecture... I manage and develop data projects from A to Z: from collecting the needs and analyzing where data could be found in the backend, redacting specifications for developer to improve the quantity and quality of data, to the final reporting layers for analysts and executives, solving all the technical challenges in between with coding and designing the right data tools architecture. I work inside both the data team and the software architecture team, leading overlapping projects (event architecture, metadata catalog), contributing to others and training people. Python, SQL, Apache Spark, Redshift, S3, GCP, Pub/Sub, MySQL, MongoDB, Qlik, Amplitude, Chart.io Show less
-
-
-
MoneyVoice
-
United States
-
Technology, Information and Internet
-
Big Data Architect
-
Sep 2018 - Dec 2018
Designing and building the first big data integration pipelines for the MoneyVoice app on AWS. Monitoring their systems with Elasticsearch/Beats/Logstash/Kibana. Developing the concept of a central data hub using Kafka. This early stage startup failed to find new investors shortly after I arrived. Designing and building the first big data integration pipelines for the MoneyVoice app on AWS. Monitoring their systems with Elasticsearch/Beats/Logstash/Kibana. Developing the concept of a central data hub using Kafka. This early stage startup failed to find new investors shortly after I arrived.
-
-
-
LCL
-
France
-
Banking
-
700 & Above Employee
-
Lead Big Data via Jems consulting
-
Jun 2018 - Sep 2018
Tech leading on MapR's Hadoop best practices for distributed processing of data. Spark, Scala, MaprFS, Hive, Elastic Tech leading on MapR's Hadoop best practices for distributed processing of data. Spark, Scala, MaprFS, Hive, Elastic
-
-
-
Jems Group
-
France
-
IT Services and IT Consulting
-
300 - 400 Employee
-
Big Data consultant
-
Oct 2016 - Sep 2018
Helping key account clients to get into the wonderful world of Big Data. Helping key account clients to get into the wonderful world of Big Data.
-
-
-
Natixis
-
France
-
Financial Services
-
700 & Above Employee
-
Big Data Engineer via Jems consulting
-
Nov 2016 - May 2018
Building Hadoop based big data pipelines for Natixis' front office and back office. Data integration, cleaning, processing, storing, reporting and monitoring. Technologies: Hortonworks Data Platform, Spark (Scala, SparkSQL), Hive (SQL, ORC, Parquet), Kafka, HBase (Phoenix), OLAP on Hadoop, Zepplin, Tableau, Superset and others. Building Hadoop based big data pipelines for Natixis' front office and back office. Data integration, cleaning, processing, storing, reporting and monitoring. Technologies: Hortonworks Data Platform, Spark (Scala, SparkSQL), Hive (SQL, ORC, Parquet), Kafka, HBase (Phoenix), OLAP on Hadoop, Zepplin, Tableau, Superset and others.
-
-
-
Air Liquide
-
France
-
Chemical Manufacturing
-
700 & Above Employee
-
Scientific Consultant at Altran for Air Liquide
-
May 2015 - Oct 2015
Modernizing, improving and developing physics simulation of gas separation by adsorption in Fortran. Developing new Python scripts to automate parametric studies and data analysis of the simulated results. Scientific analysis of the results to determine best industrial process parameters (pressure, velocity, temperature etc... ). Modernizing, improving and developing physics simulation of gas separation by adsorption in Fortran. Developing new Python scripts to automate parametric studies and data analysis of the simulated results. Scientific analysis of the results to determine best industrial process parameters (pressure, velocity, temperature etc... ).
-
-
-
-
Research intern in exoplanet imaging instrument
-
Apr 2014 - Jul 2014
Internship on the THD (Très Haute Dynamique) high dynamic experimental optical bench for a space exoplanet imaging telescope directed by Pierre Baudoz. Physics simulation in Python from scratch of light propagation inside the whole instrument: extreme adaptive optics 32x32, 4-quadrants phase mask coronagraph, Self Coherent Camera. Introduction of a micro-dots apodizer to reduce diffraction effects, simulated and experimental results comparison. Coronagraphic contrast reached between… Show more Internship on the THD (Très Haute Dynamique) high dynamic experimental optical bench for a space exoplanet imaging telescope directed by Pierre Baudoz. Physics simulation in Python from scratch of light propagation inside the whole instrument: extreme adaptive optics 32x32, 4-quadrants phase mask coronagraph, Self Coherent Camera. Introduction of a micro-dots apodizer to reduce diffraction effects, simulated and experimental results comparison. Coronagraphic contrast reached between 10^-8 and 10^-10. Show less Internship on the THD (Très Haute Dynamique) high dynamic experimental optical bench for a space exoplanet imaging telescope directed by Pierre Baudoz. Physics simulation in Python from scratch of light propagation inside the whole instrument: extreme adaptive optics 32x32, 4-quadrants phase mask coronagraph, Self Coherent Camera. Introduction of a micro-dots apodizer to reduce diffraction effects, simulated and experimental results comparison. Coronagraphic contrast reached between… Show more Internship on the THD (Très Haute Dynamique) high dynamic experimental optical bench for a space exoplanet imaging telescope directed by Pierre Baudoz. Physics simulation in Python from scratch of light propagation inside the whole instrument: extreme adaptive optics 32x32, 4-quadrants phase mask coronagraph, Self Coherent Camera. Introduction of a micro-dots apodizer to reduce diffraction effects, simulated and experimental results comparison. Coronagraphic contrast reached between 10^-8 and 10^-10. Show less
-
-
-
-
Research Intern in exoplanet imaging instrument
-
Apr 2013 - Aug 2013
Internship on the SCExAO (Subaru Coronagraphic Extreme Adaptive Optics) on the Hawaii ground Subaru Telescope, directed by Olivier Guyon and Frantz Martinache. Optics simulation in Python, pupil design, optics bench rebuild, 2 night runs preparation with target choosing and observation log keeping. Internship on the SCExAO (Subaru Coronagraphic Extreme Adaptive Optics) on the Hawaii ground Subaru Telescope, directed by Olivier Guyon and Frantz Martinache. Optics simulation in Python, pupil design, optics bench rebuild, 2 night runs preparation with target choosing and observation log keeping.
-
-
-
-
Research intern on small gap electrical breakdowns in vacuum simulation
-
May 2012 - Jul 2012
The objective was to better understand the origin of unwelcome small gap electrical breakdowns in vacuum, which occur inside power switches used inside numerous scientific and industrial applications. A code was created in Fortran to simulate the thermic and electrical phenomena such as Joule heating, thermoelectronic emission, and Nottingham effect, and determine which electrode material was the best. The results lead to a ranking of the materials: Niobium is the more resistant to the… Show more The objective was to better understand the origin of unwelcome small gap electrical breakdowns in vacuum, which occur inside power switches used inside numerous scientific and industrial applications. A code was created in Fortran to simulate the thermic and electrical phenomena such as Joule heating, thermoelectronic emission, and Nottingham effect, and determine which electrode material was the best. The results lead to a ranking of the materials: Niobium is the more resistant to the unwelcome phenomena, then comes Titanium, while Graphite is the more sensible one. Show less The objective was to better understand the origin of unwelcome small gap electrical breakdowns in vacuum, which occur inside power switches used inside numerous scientific and industrial applications. A code was created in Fortran to simulate the thermic and electrical phenomena such as Joule heating, thermoelectronic emission, and Nottingham effect, and determine which electrode material was the best. The results lead to a ranking of the materials: Niobium is the more resistant to the… Show more The objective was to better understand the origin of unwelcome small gap electrical breakdowns in vacuum, which occur inside power switches used inside numerous scientific and industrial applications. A code was created in Fortran to simulate the thermic and electrical phenomena such as Joule heating, thermoelectronic emission, and Nottingham effect, and determine which electrode material was the best. The results lead to a ranking of the materials: Niobium is the more resistant to the unwelcome phenomena, then comes Titanium, while Graphite is the more sensible one. Show less
-
-
-
IAC Acoustics
-
Industrial Machinery Manufacturing
-
1 - 100 Employee
-
Engineering intern in acoustics
-
May 2011 - Jun 2011
Acoustic design, studies in anechoic chamber, industrial noise measurements. Acoustic design, studies in anechoic chamber, industrial noise measurements.
-
-
Education
-
FITEC (Big Data certification)
Certification, Big Data / Data Science -
Sorbonne Université
Master 2, Space instrumentation, astronomy and planetary science. -
Université Paris-Saclay
Licence and Master 1, Fundamental Physics -
Icam - Institut Catholique d'Arts et Métiers
“Classes préparatoires” (two preparatory years for entry to scientific careers), Physics and Mathematics -
Lycée Notre Dame de Boulogne Billancourt
Baccalauréat Scientifique - Spécialité Mathématiques, Sciences -
--
-
--