Building a Bridge Between Operations and Data: ERP Integration Project
Sometimes the most powerful improvements aren’t flashy dashboards — they’re behind-the-scenes pipelines that just work.
At Kavaklıdere Wine Co., one of my proudest contributions was leading the integration of production operations into the NETSIS ERP system.
This wasn’t just data entry. It was a strategic redesign of how real-world manufacturing processes are translated into digital logic.
My Role and Approach
The first step was understanding the production flow:
How are products coded?
When does a product become another product?
How do we reflect delays, changes, and manual corrections?
Working cross-departmentally, I identified the key data points that needed to be standardized and built a framework for:
Choosing the correct product codes for each process
Structuring SQL logic for consistent and traceable data
Creating views that allowed for real-time operational insights
The Tech Behind It
I used:
SQL Server to create optimized views and indexes
Excel VBA to automate reporting directly from the ERP database
Worked closely with ERP consultants to validate integration points
Built documentation for future updates and process adjustments
What It Taught Me
ERP systems are the heartbeat of any manufacturing company.
If the system is inconsistent, the decisions are unreliable.
This project taught me to:
Bridge the gap between production teams and IT
Balance technical accuracy with operational flexibility
See databases not just as storage, but as real-time operational tools
