← All projects

Apprenticeship project, BUT · OPmobility

Building from scratch the management of 600 grippers.

Before, there was nothing: no tool, outdated files and purely reactive maintenance. I built the system, from the specifications to the layout of the workshop.

SettingApprenticeship, BUT GMP
CompanyOPmobility
Period2025 – 2026
ToolsSharePoint, Power Apps, Power Automate, Power BI, Python
Gripper tracking app

01Context

350 → 600grippers, i.e. +70%
350machines managed
650moulds
5 minlost per search

The plant extension and the return of off-site stock grew the fleet by 70%. Files were outdated, maintenance was 100% corrective, storage was not optimised, and stock discrepancies regularly exceeded €1,000.

02Specify

  • Constraints: zero-cost deployment, under IATF 16949 requirements.
  • A tool that had to stay in place after my contract ends.
  • Specifications co-written with another apprentice: a no-code solution on SharePoint, with data hosted internally.

03Develop

  • A Power Apps “Store” app to manage withdrawals and stock levels in real time.
  • A Power Automate flow that automatically emails an alert when a breakdown occurs.
  • NFC tags tested to make data entry reliable with dirty hands, then dropped after an ROI analysis.

04Operate

  • A DMAIC approach applied to fleet tracking.
  • A Power BI dashboard: Pareto of breakdowns per machine, weekly tracking, and a plant map to locate breakdowns.
  • A logistics effort formula (frequency × area × penalty coefficient) and a Python script that crosses dimensions and usage frequency to generate a placement matrix.

05Manage

  • A 5S project: full reorganisation of the workshop and standardised addressing (e.g. P13-H1).
  • A dedicated “breakdown zone”, with change management for the teams.
  • Today, maintenance reports its issues directly in the tool.

06What I learned

Developing is not only about building a tool, it is also about dropping a bad idea in time.

Power BI dashboardTracking settingsPlant mapSharePoint and Power Platform architecture