Le Van Eric - Eric Le Van .fr

Development and automation of queries, views and stored procedures (Transact-SQL). ➢ Control of the quality and the completeness of the integrated data.
276KB taille 7 téléchargements 454 vues
Eric Le Van +33 6 79 76 63 35 [email protected] http://eric.levan.free.fr/

Paris, FRANCE

Internship in Business Intelligence From March 2016 (12 months) Education : • 2014 – 2016 : Master of Engineering in Business Intelligence, Speciality Big Data (Courses in English) Advanced Database | Data Warehouse | Data Mining | Predictive Analytics

at EFREI – Paris, FRANCE - http://www.efrei.fr/en • 2013 – 2014 : Bachelor degree in sciences and technology, Speciality mathematics and computer science at EFREI – Paris, FRANCE - http://www.efrei.fr/en 

Trimester studies abroad at San José State University – CA, USA Networks and Procotols | Operating Systems | Entrepreneurship and Negociation | Programming

• 2011 – 2012 : Bachelor degree in Computer Science, Speciality network and development at ETNA – Paris, FRANCE • 2010 – 2011 : Erasmus program, Internship in ENGLAND in a marketing agency (8 months)

Work Experience : • Apr – Sep 2015 : Business Intelligence Internship at Societe Generale, PARIS (92800), France (5 months)  Analyze the data and the business needs  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 • 2012 – 2013 : Business Intelligence Developer at 1000mercis, PARIS (75009), France (12 months)  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 • 2011 – 2012 : SQL Server Developer Internship at Argus de la Presse, PARIS (75018), France (12 months)  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) • 2010 – 2011 : Data Analyst Internship at Alchemy Worx, LONDON (WC1A 1LW), ENGLAND (8 months)  Reporting  Data split and cleansing  Data download from ESP platform (Email Service Providers) • 2008 – 2010 : Computer technician Internship at Valeo, CRETEIL (94000), France (24 months)  Active Directory Management  Installation, configuration of workstations and laptops  Administration of Cisco switches  User support: resolution of incidents, intervention  Administration of the computers database

Professional Skills : • Databases : SQL Server, MySQL, Oracle, MongoDB, Access, pgAdmin • English : Working knowledge (TOEIC : 785) • Méthodologie : Merise, Entity–relationship model, Star and Snowflake schema • French : Mother tongue • Business Intelligence : Microsoft Visual Studio (SSIS, SSRS, SSAS), QlikView, • German : Basic knowledge Talend, MicroStrategy • Langages : SQL, R, NoSQL, Transact-SQL, PostgreSQL, HTML, CSS, PHP, C#, XML

Interests : • Sport : American Football (in competition since 10 years, playing in 1st division of France / Player in national team) • Travel : USA (California, Nevada, Arizona, Texas), UK (London), Germany (Cologn, Karlsruhe), Spain (Barcelona)