Tejas Khadke
SQL Developer | MES Engineer | SQL Server • Stored Procedures • Joins • Data Modeling • SCADA/MES Data Integration
- Role
- Mes Engineer at Mahindra Group
- Location
- Pune, MH, IN
- LinkedIn followers
- 500 followers
About Tejas Khadke
SQL Developer & MES Systems Engineer with hands-on experience in building and supporting real-time production data systems in Automotive Manufacturing.I work across the full manufacturing data stack:• PLC → SCADA → MES → SQL Server integration• T-SQL development, indexing, performance tuning• Production traceability, FPY and downtime analyticsWhat I Do:• Design and optimize SQL stored procedures, views, and reporting models• Configure FactoryTalk Transaction Manager (FTTM) and Kepware OPC UA for event-to-database data flow• Map PLC tag-level signals to traceable part/station lifecycle• Build data insights that support Production, Quality, and Maintenance teamsKey Results & Impact:• Improved query performance by ~35% through indexing and execution plan optimization• Built traceability workflows ensuring 100% unit-to-station process tracking across assembly operations• Enabled FPY and defect cause analytics that increased visibility for shift leaders and quality teamsTech Skills:T-SQL, MS SQL Server, Stored Procedures, Indexing, Views, CTEs, Window Functions, FactoryTalk Transaction Manager, Kepware OPC UA, RSLogix MES/SCADA Integrations, Java, HTML, CSS, JavaScriptI’m currently open to:• SQL Developer / Database Developer roles• MES & Manufacturing IT / Data Integration roles• Opportunities involving plant-floor data analytics and process visibility
Experience
Mes Engineer
Nov 2023 — Present · Chakan Pune, IN
Designed and optimized SQL Server tables, stored procedures, and views to support real-time production data capture and reporting.Implemented PLC → SCADA → MES → SQL Server data workflows using FactoryTalk Transaction Manager and Kepware OPC.Created SQL queries and validation scripts to ensure 100% assembly traceability across engine production lines.Automated production order acceptance and error-proofing logic, reducing manual operator intervention by ~60%.Developed dashboards and performance insights for production and quality teams, improving decision accuracy.Coordinated with software, maintenance, and line engineering teams to support digitalization and Industry 4.0 initiatives.Result: Improved production transparency, reduced manual errors, and enabled accurate part genealogy tracking.
Education
Centre for Development of Advanced Computing (C-DAC)
Post Graduate Diploma in Advanced Computing, Computer and Information Sciences and Support Services
Savitribai Phule Pune University
Bachelor of Engineering - BE, Electrical Engineering
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.