Business/Functional BI Consultant

Florian Nicolas

Avenue du Maréchal Leclerc – ****0 Aix-en-Provence – France

*******.**************@*****.*** www.flonicolas.com

LANGUAGES

French (mother tongue) – English, Spanish (fluent)

PROFILE

Over five (5) years of Business Intelligence (BI) Data warehousing experience (internships and university).

Strong skills in BI (data modeling ETL Development Reporting with KPI & Dashboards) & Statistics.

Motivated, strong worker, dynamic and versatile with strong oral/written skills.

Ability to work under pressure in group or independently.

SKILLS

Programming: C/C++/C#, JAVA, HTML, PHP, SQL, PL/SQL.

Softwares: Oracle 11g, MySQL, MS.BI / SQL Server (SSAS, SSIS, SSRS), Talend Open Studio,

QlikView 11.0, MS Office 2013 (Word, Excel, Powerpoint, Access…), SAS (SAS

Base, SAS Enterprise Guide, SAS Graph) – Business Objects XI – Tableau Software.

General Skills: Business Intelligence (data sources, data modeling, ETL Development, OLAPAnalysis)

Statistics (data analysis, statistical models, data mining, clustering, statistical studies …)

Project Management

Finance Marketing

EDUCATION

M.S in Computer Science specialty in Business Intelligence Big Data (2nd year) September 2014

Université Lumière Lyon 2 – Lyon, France. - (5 years after high school diploma)

M.S in Computer Science (1st year) July 2013

Université Lumière Lyon 2 – Lyon, France. - (4 years after high school diploma)

B.S Computer Science Applied to Business Management & Marketing July 2012

Université Aix-Marseille – Aix-en-Provence, France. – (3 years after high school diploma)

Two-Year Technical Degree in Computer Science & Statistics Data analysis June 2011

Université d’Avignon – Avignon, France - (2 years after high school diploma)

CAREER EXPERIENCE

CAPGEMINI FRANCE AIRBUS GROUP – MARSEILLE, FRANCE. April 2014 – September 2014

Functional/Business Intelligence Consultant. (6 months)

French Multinational Corporation headquartered. CAPGEMINI provides IT services and is a consulting,

outsourcing and professional services company with 130,000 employees in over 40 countries. Employed by

Capgemini in Technology Services division & Business Application Consulting entity – Worked for

AIRBUS HELICOPTERS (NHIndustries Business Unit).

Project 1 - Data collected about the helicopters availability (flight hours, daily status, scheduled

maintenance Analyzed business requirements (weekly meetings). Draw-up MoM (Minutes of Meetings)

& functional specifications. Developed KPI and Dashboards into QlikView (BI software for data

visualization – to generate dynamically Dashboards & KPI). Updated some QlikView reports (KPI and

Dashboards) within the client requests (TMA). Tests and integration into the production server.

Project 2 - A lot of data was duplicated Established a data dictionary - Modeled a data warehouse structure.

Implemented the model into MySQL + Loading source data into the data warehouse.

Project 3 – Wrote minutes of meetings, BPM diagrams (workflow) and specifications for another project.

Page 1

Florian Nicolas +33 6 51 87 46 87 *******.**************@*****.***

STATISTICS CANADA – OTTAWA, CANADA. May 2013 – September 2013

SAS Assistant Consultant. (4 months)

Canadian federal government agency commissioned with producing statistics – Employed by Statistics

Canada in Business Survey Methods Division with 16 people – Worked for the GOVERNMENT OF

CANADA – Survey on retail sales sent monthly or yearly at Canadians clients - Business Survey Methods

Division needed to decrease the cost of project and verify some strategic decisions.

Extracted sales data with SAS macros (use of SAS Base) after extraction, applied a “RAKING” processus

on data to manage data quality and get estimated data Analysis – OLAP Cube: compared estimated data

with production data (use of SAS Enterprise Guide). SQL, SAS Base, SAS Graph, SAS Enterprise Guide.

BUSINESS & DECISION – MARSEILLE, FRANCE. April 2012 – August 2012

Technical Manager Assistant. (4 months)

International Consulting and Systems Integration (CSI) company - Worked in JAVA Development Division

with a JAVA Technical Manager – Human Resources Division needed a web application which had to

manage global information and the skills level of each employee.

Developed a web application (in JAVA – pattern MVC) which had to manage information about employee

(first name, last name, skills).Software Development model (V-Model) – Realized every steps of a web

application development project : project definition – implementation – Project Test and Integration.

IRD (Institut de Recherche pour le Développement) – MONTPELLIER, FRANCE. April 2011 – June 2011

Researcher Assistant. (3 months)

French research institute which regroup employees from Université de Montpellier I, Université Montpellier

II, CNRS & IRD – Worked with 4 other workers (PhD students) for an IRD Researcher - Data about the

tree’s phenology and about the environmental factors (temperature, humidity…) collected daily, weekly,

monthly and yearly in West North of Benin

Evaluated the best environmental factors that influences on the tree’s phenology. Managed of data quality to

obtain the best data sets Applied an AFC (Factorial Analysis) on the dataset and used statistical models to

establish the best link between the environmental factors and the binaries variables.

DB SCHENKER – BRIVE, FRANCE. June 2009 – August 2009

Delivery Driver and Assistant Boss-Loader (Summer Job) (3 months)

Owned subsidiary of Deutsche Bahn AG that focuses on logistics - Worked in a local French agency of 50

employees – DB SCHENKER needed full-time summer worker to stand in for the permanent employees.

Morning: helped my co-workers to the loading truck on the morning when they begin their journey Cleaned

the loading deck with the loading deck boss – Moved pallets to optimize the merchandise stocking.

Afternoon: went with a small truck to deliver the merchandise to clients (an average of 25 clients each day in

Downtown Brive).

July 2006 – August 2006

CCPF Couverture Charpente Prat & Fils) - BRIVE, FRANCE.

Seasonal Worker (Summer Job) (2 months)

Executed all of orders of my boss – CCPF’s car wash and interior cleaning of vehicles – Stored the

company’s goods (tiles, scaffold, slate, building material…) into the working ware house.

Helped my co-workers to cleaning up a site and removing equipment. Loaded trucks when my co-workers

went to the building site and unloaded trucks when my co-workers went back to the company office.

Cleared the undergrowth – Maintained open/green spaces around the company’s buildings.

INTERESTS

Trips – US: Chicago (1 week) – New York City – Boston – Miami (2 months) – Washington (1 week).

Canada: Ottawa – Toronto – Montreal – Quebec City – London – Lake Huron – Lake Superior.

Germany (Munich) – Portugal (Lisboa) – Italy (Roma, Milan) – England (London) – Spain…

Sports – Hikings – BasketBall – Rugby

Page 2

Florian Nicolas +33 6 51 87 46 87 *******.**************@*****.***

COMMUNITY INVOLVMENT

University Student Society

Various positions and responsibilities of events (projects…)

BI Division Responsible in Junior E-Webbi (Junior enterprise) (April 2013 – August 2013)

Prospect clients to have some missions for students.

Writed Business Propositions to manage the financial link between the company and Junior E-webbi.

Volunteer

Responsible of Business Development of INFINITY ONGLES – 4 months - Beauty Salon needed to develop

its business through the social networks (Twitter, Facebook, LinkedIn, Viadeo) and a new website – Created

accounts on the social networks – Updated news every weeks – Developed the new website for the agency.

Seminars/Conferences/Webinars/Trainings

« Business Discovery Tour QlikView » Marseille, France (June 5th, 2014) Seminar

« Tendances BI » (June 15th 2014)

Marseille, France Seminar

« Big Data New solution » (July 4th, 2013)

Ottawa, France Conference

« Data Control & Data Quality » (July 17th, 2013)

Ottawa, France Conference

«Talend Master Data Management» (June 25th, 2014)

Online Training

«Talend Open Studio for ESB » (June 19th, 2014)

Online Training

REFERENCES

Available upon request

Page 3

Contact this candidate