Project case study
Industrial Automation Data Collection
PLC data collection and production metrics
AVEVA WonderwareVisual BasicMS SQLPLC DataOEE
Summary
Quick overview
Short industrial automation collaboration for a manufacturing client, focused on PLC data collection, production data views, and operational metric calculations.
Professional or private work. Details are summarized without exposing internal code, client data, or proprietary implementation details. Screenshots or private demo can be shared on request when available.
Problem
What needed to be solved
Worked for up to three months on a collaboration project with stakeholders from the factory side, where data from programmable logic controllers had to be collected, displayed, and interpreted for production monitoring.
Implementation
What I worked on
Built and adjusted data views in AVEVA Wonderware, used Visual Basic and MS SQL, discussed requirements with the project director, and helped shape calculation decisions for metrics such as OEE.
Technical decisions
Responsibilities, systems, and engineering trade-offs
- PLC data collection and production data visualization
- AVEVA Wonderware screens and data views
- Visual Basic logic and MS SQL-backed data handling
- OEE and production metric calculation discussions
- Technical trade-offs between factory requirements, existing technology, and AVEVA platform limitations
Result
Result and value
Helped turn industrial production data into usable operational views while navigating tooling constraints and production metric requirements.
What I learned
Practical takeaway
Industrial reporting depends on practical trade-offs between available data, platform limitations, and metric definitions.