Yassine Benelkari

Industrial Engineering and Logistics Engineer, currently BI Project Manager & Data Analyst at ExcelRise. My versatile profile, at the crossroads of industrial and data professions, allows me to effectively support business departments in transforming raw data into automated BI reporting.

🛠️ Services offered:

- Analysis of business needs: Procurement, production, shipping, inventory, transport, sales, invoicing, maintenance, energy consumption, etc.

- Data collection: Excel, Access, CSV, SQL Server, Oracle, SAP HANA, Sage X3, Snowflake, API, CRM.

- Data cleaning, transformation, and preparation: SQL, Power Query, MyReport Data.

- Loading and modeling in the Data Warehouse: MyReport Data, Power Pivot.

- Dashboard development: Excel, Power BI, MyReport Center.

- Optimization of complex SQL queries.

- Adaptation of reporting models within the framework of SAP ECC to SAP S/4HANA migration.

🔧 Key achievements:

- Complete management of BI projects for 8 recycling plants: from understanding business needs to putting dashboards into production.

- Automation of raw material weighing via connected sensor and real-time data integration into SQL Server via the OPC UA protocol.

- Coordination of Master Data audit preparation: achieving a score of 100%.

- Migration of manual Excel reporting to an automated system based on MyReport Center.

📊 Examples of developed reports:

- Sales, invoicing, and commercial performance tracking.

- Customer and supplier service level tracking.

- Purchase and transport cost tracking.

- Inventory tracking in quantity, value, and coverage (MRP).

- Production loss monitoring (OEE, rate, scrap, downtime, breakdown, etc.).

- Tracking of labor hours billed to the client.

- Energy consumption monitoring (electricity and gas).