Data collection work
Industrial Automation Data Collection
PLC data collection and production metrics
- AVEVA Wonderware ·
- Visual Basic ·
- MS SQL ·
- PLC Data
Quick overview
Worked on an industrial data collection/reporting project for a pipe production line. Collected PLC production data into SQL Server, built AVEVA/Wonderware screens and data views, and translated client requirements into reporting and data collection logic.
Details are anonymized and summarized without exposing internal code, customer data, or proprietary implementation details.
Context, responsibility, outcome, and takeaway
Context
I worked on an industrial automation/data collection project related to pipe production. The system collected production data from PLCs and stored it in SQL Server so it could be used for reporting and operational visibility.
My role
I collected production data from PLCs, stored collected data in SQL Server, built AVEVA/Wonderware screens and data views, worked on reporting-related logic, and clarified requirements with the client/project director.
Result
The project improved visibility into production data and required close communication with the client/project director to turn operational requirements into concrete data collection and reporting implementation.
Takeaway
Industrial reporting depends on understanding the production process, clarifying operational requirements, and turning available PLC data into useful SQL-backed views.
Expandable details for the technical story
Stakeholder context
A major part of the work involved discussing requirements with the client/project director. The client described operational needs, and I had to clarify the meaning, understand the production process, and translate it into software/data collection logic.
Data collected
The collected data included package counts, time required to produce packages, production quantities, line-related operational metrics, and other PLC data relevant to production reporting.
Backend-adjacent value
Even though the stack was not .NET, the work followed backend/reporting thinking: collect production data, store it in SQL Server, structure it, calculate meaningful metrics, and make operational information usable.
Core responsibilities and engineering details
- Collected PLC production data for a pipe production line
- Stored operational metrics in SQL Server for reporting
- Built AVEVA/Wonderware screens and data views
- Implemented logic for moving collected PLC data into SQL Server
Additional technical details 3 more points
- Used SQL queries and reporting tools to display production data in a more usable format
- Worked with package counts, production duration, quantities, and other line-related operational metrics
- Discussed requirements with the client/project director and translated operational needs into implementation