Freelancer profile translated to English.

Description

Power BI, SQL, ODI, SAP BI, SAP BO, MS Project Trainer:

⭐️ Data Analyst, Data Engineer Consultant

🏆 Over 30 training sessions delivered during my 6 years of consulting in training centers, directly at client sites, and in schools.

Hello and welcome to my profile! 👋

I'm Sylvain, a currently employed Data Engineer and a freelance trainer passionate about sharing the skills I've acquired over 14 years of consulting in business intelligence tools (Power BI, ODI, Talend, ETL, SAP BI, SAP BO, Webi, SQL) and project management (Microsoft Project, MS Project, GanttProject).

🎯 My areas of expertise:

✔️ Training on data extraction, transformation, and loading (ETL) using Oracle Data Integrator, Talend

✔️ Training on setting up reporting and dashboards

Using tools like Power BI, SAP BO, SAP BI, Webi

✔️ Training in project management

Using tools like Microsoft Project or GanttProject

🚀 Examples of project experience:

CONSULTING

→ Consulting, analysis, and business owner support for the creation and implementation of a data warehouse and the development of various key indicators for analyzing different functional areas of the company (Power BI, SQL)

→ Evolution of the information system and renewal of the commercial management IT tool using SQL, ODI, SAP BI

PROJECT MANAGEMENT

→ Project monitoring with MS Project, for the implementation of a data warehouse and the creation of various Power BI reports for analyzing different functional areas of the company (Invoicing, Training, …)

💬 Do you have a need for classic or custom training?

Don't hesitate to contact me to discuss your project! 🙌🏻

#Power BI #SAP BI #SAP BO #Talend #ODI #Oracle Data Integrator #ODI #SQL #MS Project

Industry field of expertise

Languages

French
Native or bilingual
English
Fluent
Spanish
Conversational

Workplace preferences

Remote only

Primarily works remotely

SIB [numérique et santé]
Business Intelligence Engineer
SOFTWARE PUBLISHING
August 2018 - Today (7 years and 10 months)
Rennes, France
Cross-functional role between diffusion and development teams. Involved in all stages of design and deployment (specification, development, testing, support) of the Magellan and Sillage Data software.
- Needs analysis, Specification writing
- Development of ODI data loading flows and SAP BI dashboards
- Python Development (Dashboards, data extraction, indicator calculation)
- Version testing and qualification
- Customer support
- Maintenance and administration of the SAP BI platform (SAP BI Referent)
- Innovation mission

Main Tools:
- Oracle Data Integrator
- SAP BI
- GIT, GitLab
- Python: Pandas, Dash
- Databases: Oracle, PostGres
Python Development Python Git Gitlab Oracle Data Integrator ODI SAP Business Objects Training Oracle
Next Decision
BI Consultant
TECH
January 2012 - August 2018 (6 years and 7 months)
Rennes, France
Since 2009, I have carried out numerous missions within NextDecsion in a wide variety of sectors: Banking/Insurance (Arkéa), Industry (Manitou), Agri-food (Cavac), Retail (Maison du monde), Aeronautics (HOP), Transport (Brittany Ferries)... I am currently based in Rennes.

Mission Typology:
- Business Owner Support (AMOA)
- Analysis and writing of software architecture specifications
- Analysis of technical specifications
- Multidimensional modeling in star/snowflake schema
- Datawarehouse redesign/creation
- Datamart construction, SGBD loading, and Universe construction
- Reporting and dashboarding development
- Writing of production deployment documentation, writing test scripts
- Testing, deployment, and management of application and technical evolutions
- Trainer for business intelligence tools
- Presentation of new business intelligence tool features
- Migration audit
- Skills transfer
- Project management....

Main Tools:
- Oracle Data Integrator
- BusinessObjects (Webi, Designer, SAP Dashboard, CrystalReport)
- Pentaho
- QlikSense
- Talend
- Databases: Oracle, Sybase, Sql Server, DB2, Sybase....

Trainer:
- Oracle Data Integrator
- Power BI
- Sap Business Objects Webi, SAP Dashboard, and Crystal Reports
- Pentaho Data Integration and Pentaho Report Designer
- State of the art of BI
Oracle Data Integrator ODI Talend Kettle Pentaho Data Integration SAP Business Objects SAP BO SAP BI QlikSense Oracle SQL Pentaho Power BI Microsoft Power BI Microsoft Project Training Training Facilitation
Groupe SII
BI Developer
TELECOMMUNICATIONS
September 2009 - January 2012 (2 years and 4 months)
Nantes, France
Mission at Bouygues Telecom:
Project Opera: Redesign of Bouygues Telecom's Next Generation business intelligence systems, aiming to replace existing BI systems (2G, XT). With 70 Terabytes of data in 2009, the data warehouse is one of the ten largest databases in France. Within a team of 25 people, technical design and development of data loading processes in the areas of portability, auxiliary accounting, and product and distributor reference data.

Technologies: ODI, Shell, Teradata
ODI Oracle Data Integrator Shell SQL Teradata Java SVN