With more than 12 years of experience in SQL, I am able to write complex and efficient SQL queries.
Eric LE VAN
Eric LE VAN
Data Engineer
Professional Profile
Originally from France, I’m a Data Engineer since 2016 and I have been working as such in Montreal, Canada since 2018. I have a passion for both Data and Travel.
My profession has given me the chance to combine both my passions and I have been able to work abroad. Going from London, England to across the pond to New York City, USA.
My interest in Data started in 2008 during my early undergraduate studies. I knew it was the road to follow when right after graduation, I was able to complete an 8-month internship as a Marketing Data Analyst in London, England.
During my Master’s program, I also had the opportunity to go in exchange for a semester in California, right to the heart of Silicon Valley.
These international experiences have enabled me to improve my English and gain professional experience abroad. It has also enabled me to develop my autonomy and to adapt rapidly to the different environments I could encounter.
In 2016, I obtained my Master’s degree of Engineering in Business Intelligence with a specialization in Big Data. This degree allowed me to increase my knowledge and to reach my career goal of becoming a Data Engineer.
My work experiences as a Data Engineer include knowledge from working in Consulting, Marketing as well as Banking. My current focus is on New Technologies and Big Data in the Video Game Industry.
Years of experence
Line of code
Happy companies
What I can do
My Services.
SQL developer
ETL developer
Extract all the data needed, Transform and Load.
Big Data
Management of billions data rows on a daily basis.
Database designer
I can produce a detailed data model of a database. I know Entity-Relationship model, Star and Snowflake schema.
Report designer
I am proficient with SSRS and Power BI reports. I can build complex reports, using multiple datasources and datasets.
Database administrator
I'm currently not looking for opportunities.
Contact meResume
My experience and education.
Experience
Data Engineer
- Responsible of the Data Pipeline for Rainbow Six Siege, First Person Shooter (FPS) game of Ubisoft with over 85 million players.
- Big Data Environment: Management of billions data rows on a daily basis
- Objectives: Building ETL solutions at scale, Designing and Building large data pipelines, Data collection, Data cleansing, Transformation of raw data in relevant data, Automation and Industrialization of processes, Player's behavior analysis
- Technologies: Apache Hive | Apache Spark | Apache Airflow | Apache Superset | HDFS | Tableau
Ubisoft
Montréal, QC, CANADA
Sep 2018 - Today
Data Engineer
- Environment: BNP Paribas Corporate and Institutional Banking / ITO - Business & Client Management / Business Management
- Objectives: Data collection from SharePoint Lists, Data cleansing, Improve the accuracy of KPIs Budget, Automation and Industrialization of the Business Management tools
- Realization: Reports (headcount, dollars, mandays, projects, reforcast) helping the managers to follow their teams and budget
- Technologies: SQL | SSIS | Powershell | Alteryx
BNP Paribas
New York, NY, USA
Apr 2017 - Aug 2018
Business Intelligence Developer
- Environment: Microsoft Services / Resource Management (~120 consultants, ~2000 missions/year)
- Objectives: Improve the accuracy of KPIs forecasting (Billing, PreSales, Subcontractors)
- Deliver reports for managers
- Realization: BI Self-Service (Comparison Outlook calendar/intern tools)
- Consulting for external clients (Sales, Medical, Marketing)
- Technologies: SQL | SSIS | Power BI
Microsoft
Paris, FRANCE
Feb - Sep 2016
Business Intelligence Developer
- Analyze the data and the business needs
- Study a BI solution in order to replace the actual solution
- Implement the new solution
- Migration of references and sources data in the new Data Warehouse
- SSIS: creation and development of integration flows (ETL)
- SSRS: creation and deployment of reports
- SSAS: creation of an OLAP cube with Dimension and Fact tables
- Acquisition of knowledge on MicroStrategy
Société Générale
Paris, FRANCE
Apr - Sep 2015
Business Intelligence Developer
- Construction and supply of SQL Server databases
- Development and automation of queries, views and stored procedures (Transact-SQL)
- Control of the quality and the completeness of the integrated data
- Creation, development and automation of SSIS integration flows (ETL)
- Creation and deployment of SSRS reports
1000mercis
Paris, FRANCE
2012 - 2013SQL Server Developer
- Construction and supply of SQL Server databases
- Optimisation of the databases structure
- Development of queries, views and stored procedures (Transact-SQL)
- Control of the quality and the completeness of the integrated data
- Creation, development and automation of SSIS integration flows (ETL)
Argus de la Presse
Paris, FRANCE
2011 - 2012
Data Analyst
- Reporting
- Data split and cleansing
- Update of database
- Data download from ESP platform (Email Service Providers)
Alchemy Worx
London, UK
2010 - 2011
Computer Technician
- Active Directory Management
- Installation, configuration of workstations and laptops
- Administration of Cisco switches
- User support: resolution of incidents, intervention
- Administration of the computers database
Valeo
Créteil, FRANCE
2008 - 2010
Education
Master of Engineering in Business Intelligence
Speciality Big Data (Courses in English)
- Advanced Database
- Data Warehouse
- Data Mining
- Predictive Analytics
EFREI
Villejuif (94), FRANCE
2014 - 2016
Trimester studies abroad 
Speciality mathematics and computer science
- Networks and Procotols
- Operating Systems
- Entrepreneurship and Negociation
- Further Object-Oriented Programming
San José State University
San José (CA), USA
2013 - 2014
Bachelor's degree in Sciences and Technology
Speciality mathematics and computer science
EFREI
Villejuif (94), FRANCE
2013 - 2014Bachelor's degree in Computer Science
Speciality network and development
ETNA
Ivry-sur-seine (94), FRANCE
2011 - 2012Erasmus program 
Internship in England (8 mois)
UTEC
2010 - 20112 years technical degree in Computer Science
Speciality network and development
UTEC
2008 - 2010
Sep. 2018 - Today
Apr. 2017 - Aug. 2018
Feb. - Sep. 2016
Apr. - Sep. 2015
2012 - 2013
2011 - 2012
2010 - 2011
2008 - 2010
Portfolio
My passion for travelling. Find out more at thedatavoyager.com
Contact Me
- Montréal, QC, Canada
- eric.levan.pro@gmail.com
- https://www.eric-levan.com
- https://www.linkedin.com/in/elevan