
Nicolas PLANCHON
Business Analyst & Data Analyst | PMO
Salary / Daily rate
Paris, France
Freelance
Can come onsite
Skills
Languages
Work experience
Business Analyst/Analytics Engineer acting as Chief of Staff
Airties
Mar 2022 - Present
4 years 8 months
İstanbul, Türkiye
Strategy Consultant
Strategy&
Mar 2021 - Mar 2022
1 year 1 month
Casablanca, Morocco
Data Engineer
Geoblink
May 2018 - Sep 2018
5 months
Madrid Area, Spain
Recently selected by Bloomberg as one of the 50 most promising startups in the world, Geoblink is a SaaS-based location intelligence solution that helps companies (in sectors such as Retail, Real Estate and FMCG) make informed business decisions that concern location. It combines advanced analytics and big data, together with a rich map-based UI to display multiple types of statistics in a way that is simple to use and easy to understand. Responsible for data acquisition through web-scraping. Skillset: - Python (BeautifulSoup, Selenium); - Javascript; - SQL.
Data Analyst
Deezer
Sep 2017 - Mar 2018
7 months
Paris Area, France
Deezer is the first music streaming service created in the world in 2007 in Paris, France. In 2018 Deezer is the #3 biggest music streaming service in the world. In the Data Analytics team I was responsible for providing analysis and dashboards to various teams and was the dedicated person for every issue regarding the PR teams on the global scale. Daily working on a Hadoop 2 ecosystem (mainly SQL related Hive, Spark also). Dataviz with Tableau and extensions.
General Assistant
Joliette Art Museum
Jun 2017 - Aug 2017
3 months
Joliette, QC, Canada
The Joliette Art Museum is recognized as Quebec’s most important art museum outside of the major cities. While pursuing the objectives of conservation, dissemination and research established over half a century ago by its founders, the Musée continues to expand its permanent collection, which currently comprises some 8,500 works held in four collections: Canadian art, European art, contemporary art and archaeology. At the same time it offers a wide range of programmes structured around the promotion of its permanent collection and the presentation of temporary exhibitions, as well as a host of educational and cultural activities for visitors of all ages. In the 'Administration' department I have been responsible for planning activities, exhibitions and other events in the museum till December 2017. In the 'Education' department I have been responsible for taking care of the day camp (55 children, 70 activities). In the 'Visitors' department I have been responsible for visitors welcome and museum monitoring.
Ed'Express, the hitchhiking race
Dec 2015 - Jun 2017
1 year 7 months
Lille Area, France
President
May 2016 - Jun 2017
1 year 2 months
Lille Area, France
Ed'Express, the hitchhiking race is the biggest student hitchhiking race in Europe. 2017 edition => Paris-French Riviera (by plane) -> French Riviera -> Chiavari, Italy -> Milano, Italy -> Venezia, Italy -> Bohinjska Jezera, Slovenia -> Ljubljana, Slovenia -> Pag Island, Croatia -> Plitvice Park, Croatia -> Split, Croatia - Managed a 32 person team to set up the biggest student hitchhiking race gathering 70 participants during 10 days across Europe (8 stages, 4 countries, 1500 km of hitchhiking); - Increased of 450% in the yearly budget; - Negotiated deals with key accounts (Air France, Salesforce, Henkel, LCL, Boursorama, Fortuneo, Bret's, La Potagère...); - Legal status reorganization hand in hand with a lawyer and the French administration; - Management of every interaction with authorities across Europe to make our event safe; - Cleaning of the financial situation; - Change in the organization (switch from a functional structure to a project oriented structure); - CRM implementation with accountancy integrated (Salesforce+Numm); - Creation of a brand new event to promote hitchhiking on a shorter timespan (48 hours); - First outsourced departure of the race on the French Riviera;
Logistics Manager
Dec 2015 - May 2016
6 months
Lille Area, France
Responsible for the 2016 edition route. 2016 edition: Lille, France -> Bouillon, Belgium -> Luxembourg -> Strasbourg, France -> Konstanz, Germany -> Munchen, Germany -> Heiligenblut, Austria -> Ljubljana, Slovenia - Management of a 12 person team to set up the route of our hitchhiking race gathering 60 persons during 8 days across Europe (7 stages, 6 countries, 1200 km of hitchhiking); - Creation of the route; - Designing of the bill of specifications for my team; - Budget management to build the best event possible; - Event operational management: planning management -participants welcome, accommodation mangement on a daily basis, catering, sweeper cars management, safety management; - Built a GPS tool to ensure the safety of our participants; - Designed the association website; - Designed an e-commerce platform to improve the registrations;
Buy Side Intern
Leroy Merlin España
May 2016 - Aug 2016
4 months
Madrid Area, Spain
Leroy Merlin is a French headquartered home improvement and gardening retailer serving several countries in Europe, Russia, Asia, South America and Africa. Generally established on the outskirts of major towns and cities, Leroy Merlin stores are large centres (9000 m² on average) providing self-service and sales assisted services. The company is mainly focused on: DIY, gardening, building, sanitary equipment and interior decoration. In the Buy Side department, I have: - Revised a whole range of ceramic products and reported errors to more than 20 providers; - Monitored the fixes done by our providers; - Implemented a brand new range of ceramic products for the 2016 autumn term;
EDHEC Sailing Cup
Apr 2016 - Apr 2016
1 month
Roscoff, France
Logistics manager
Apr 2016 - Apr 2016
1 month
Roscoff, France
The EDHEC Sailing Cup is the European biggest student regatta. - Built a 20 000 m² village gathering 10 000 visitors and 3 000 participants; - Monitored the village and the lifeplaces for the event hand in hand with our service providers.
Head Commission
Apr 2016 - Apr 2016
1 month
Roscoff, France
The EDHEC Sailing Cup is the European biggest student regatta. The Head Commission is the crisis centre of the EDHEC Sailing Cup. - Live supervision of 100 organizers; - 1500 P+ party management (entrances, safety, video controlling, radio transmission system); - Collaboration with the police and our security company to maintain a very high level of safety during the event.
Education
Bilkent University
Full year exchange program, Finance
2019 - 2020
1 year 2 months
Centrale Lille
Master in Engineering, General Engineering, Mathematics, Algorithmics, OO programming, Mechanics, Thermodynamics
2015 - 2020
5 years 2 months
EDHEC Business School
Master in Management, Management, Corporate Finance, Statistics
2015 - 2020
5 years 2 months
Activities and societies: Représentant des élèves auprès de l'administration de l'école
CPGE Gay Lussac
Intensive preparation courses for top business schools
2012 - 2015
3 years 2 months
Grade: Vice-valedictorian
Activities and societies: Fondateur de l'association Alumni GayLu, création d'un site web support de l'association.
Licenses & certifications
TOEIC - 970
Issued: Mar 2019
MOOC Deep Learning
Issued: May 2018
MOOC Hadoop Platform & Application Framework
Issued: Apr 2018
MOOC Gestion de Projet avancée
Issued: Oct 2016
MOOC Fondamentaux du Big Data
Issued: Sep 2015
MOOC Géopolitique de l'Europe
Issued: Apr 2015
MOOC Espace mondial
Issued: Apr 2015
Upper Intermediate Level - English as a foreign language
Issued: Aug 2013