Rudy C.

Responsible for the BI solution for the needs of the Road Logistics commercial unit, from raw data, ETL to a datamart, definition of KPIs, to dashboards on Tableau Software and other reports for end-users. Migration and replacement of existing solutions based on Data architecture and modern data engineering technology (Tableau Software, DBT, Snowflake).

Permanent contract. Development of KPIs and Migration of reports with change of Dataviz tool from QlikView to Power BI. Agile Animation, Project Management, SQL test queries, Presentation of reports in Steering Committees.

Implementation of KPIs, SSIS job loads to monitor the company's Production activity. Creation of reports on Production and Sales of watches in SAP BO and detailed analyses in SSRS

• Gathering KPI requirements for each business area: Logistics, Production, Sales, After-Sales Service

• Loading indicators on MSBI using SAP data on supplier/customer orders

• Performing quality tests on indicators on SQL Server and verifying SSIS job results

• Writing technical specifications, analyzing indicators, and presenting reports to Committees

• Monitoring and developing reports by activity, Training Key Users on their use

Technical Activities:

• Implementing indicators according to calculation rules defined by Key Users using SSIS jobs

• Extracting, Loading, and Automating SSIS jobs and implementing SSRS reports

• Creating indicators by domain on SmartCockpit from SAP data on customers

• SQL queries, tests performed in Acceptance, verification of figures delivered in Production

• DAX queries for detailed financial analysis by point of sale at Swatch Group

• Validating figures and Delivering reports generated and presented to Management Committees