Ignition Perspective Manufacturing Dashboard Development

I need an experienced Ignition Perspective developer to build a manufacturing operations dashboard for a client in the discrete manufacturing space. The client has two existing SQL data streams — production output counts and equipment status signals — and needs them surfaced in a clean, mobile-friendly Perspective view. --- **Deliverables** - One Ignition Perspective project (.proj) with all views, templates, and embedded style sheets - Named queries pulling from client's existing SQL schema (no hard-coded credentials) - Scheduled refresh driven by a single project-scoped parameter (no republish required to change interval) - SQL scripts or documentation for any stored procedures or additional tables created - Short handoff guide covering: how to change the refresh interval, how to add new machines, and how to migrate the project between gateways --- **Dashboard Requirements** - **Header bar:** Plant name, live date/time, last-refresh timestamp + manual refresh icon - **KPI strip (4 cards):** Units Produced Today, Current Shift Output, OEE %, Active Faults — each with trend indicator vs previous shift - **Machine status sidebar:** Scrollable list of equipment cards showing machine name, state badge (Running / Idle / Faulted / Offline), utilization bar, time-in-state counter — color-coded left border per state - **Production Output Over Time:** Area/line chart with hourly buckets and dashed target rate overlay - **Units by Machine:** Horizontal bar chart ranked highest to lowest, bars colored by machine state - **Machine drill-down view:** State history Gantt (last 8 hours), fault log table, per-unit production count chart - Scales cleanly on tablet/kiosk (768px) — sidebar collapses to drawer, KPI strip to 2×2 grid --- **Tech Requirements** - Ignition 8.1+ Perspective module - SQL Server backend (named queries only — no Tag Historian required) - ISA-88 aware tag structure preferred (Site → Area → Workcell → Unit) - Parameterized queries — no inline SQL - Timer-based polling, not subscription-based, to manage gateway load --- **Required Experience** - Ignition Perspective view and template development - SQL Server named queries and stored procedures - Manufacturing/MES dashboard delivery - Must be able to share a screenshot, repo, or schema example of prior Ignition work --- I will provide the SQL schema, sample data, and a design reference screenshot. You handle the build, documentation, and handoff package. Fixed-price bids only — include your timeline and a brief description of a similar project you've completed.