Industry 4.0 dashboards for Coca-Cola & EIPICO
Real-time factory monitoring dashboards for two enterprise clients — Coca-Cola and EIPICO. Live production KPIs, energy / water / CO₂ telemetry, embedded IoT integration, cross-functional delivery with SAP and hardware teams.
- Enterprise clients
- Coca-Cola · EIPICO
- Data modalities
- Production · Energy · Water · CO₂
- Real-time
- SignalR live
- Domain
- Industry 4.0
Tech stack
- .NET Core
- ASP.NET Core Web API
- SQL Server
- SignalR
- Stored Procedures
- SQL Agent Jobs
- IoT Integration
- REST APIs
Situation
EL-Square builds Industry 4.0 / IoT solutions for enterprise manufacturers. Two flagship clients — Coca-Cola and EIPICO (pharmaceutical) — needed a real-time platform where plant managers could watch production lines, utilities consumption, and environmental KPIs live from a single dashboard. Raw data was already flowing from embedded IoT devices on the floor; the business layer to turn that into decisions didn’t exist yet.
Task
Design and build the backend + data layer for two live production dashboards. Specifically:
- Ingest and normalize telemetry from embedded IoT devices
- Compute KPIs (production output, energy consumption, water usage, CO₂ emissions) in near-real-time
- Expose a REST API and live streaming layer to a web admin dashboard
- Coordinate integrations with SAP, frontend, mobile, and embedded hardware teams
- Deliver on enterprise timelines against non-negotiable client expectations
Action
Data layer. I implemented the core logic close to the data using SQL Server stored procedures, views, and SQL Agent jobs — KPIs that run every minute, rollups that run hourly, daily/weekly/monthly aggregates. Going stored-proc-first kept the hot path fast and auditable, and let SAP integration teams consume pre-computed views without knowing internal table shapes.
API layer. A .NET Core Web API exposed the computed KPIs, historical rollups, and per-line drill-downs. Clean separation between data access (Repository pattern), domain logic, and HTTP.
Real-time streaming. SignalR pushed updates to the dashboards so plant managers didn’t need to refresh. Connection management, group-based broadcasts per plant / per line.
IoT integration. Worked closely with embedded hardware teams on payload formats, buffering for flaky connections, and dedup/idempotency for retried messages. The goal was that a reader on the factory floor could drop offline for five minutes and recover without double-counting production.
Cross-functional delivery. Daily sync with SAP, frontend, and IoT teams. The delivery success hinged on interface contracts — API shape for frontend, event schemas for SAP, payload formats for hardware — so I spent real time on clear, versioned documentation.
Result
- Live production dashboards shipped for Coca-Cola and EIPICO plants
- Plant managers got data-driven visibility into production output, energy usage, water consumption, and CO₂ emissions — previously surfaced only in next-day reports
- KPI calculation offloaded from the application tier to the database, keeping the API snappy even during telemetry spikes
- Successful end-to-end delivery with SAP, embedded IoT, frontend, and mobile teams — the kind of delivery where the technology worked because the coordination worked
Why this project matters for clients
If you’re running legacy industrial software, SAP environments, or OT/IT convergence projects, this is the work that proves I can ship in that context. Stored-procedure-heavy SQL Server, real-time streams, multi-vendor coordination, and enterprise procurement cycles are not the same world as SaaS — and I’ve delivered in both.