// Service Manager · Pune, India

PRAMOD
KOLI

SERVICE MANAGEMENT  ·  AI INTEGRATION
INDUSTRIAL SOLUTIONS  ·  POWER BI  ·  DATA ANALYTICS
9+ Years XP
40+ Engineers Led
5 Industries
PK
01 //

ABOUT ME

I'm a Service Manager at VATS Filtration Technologies, Pune — with 9+ years of hands-on experience turning complex industrial operations into efficient, data-driven systems.

My work sits at the intersection of field service engineering and modern analytics. I manage 40+ field engineers, own full P&L for service operations, and have implemented Power BI dashboards that give real-time visibility into KPIs, billing, and complaints.

What sets me apart: I combine mechanical engineering roots with AI tools, ERP systems, and business intelligence — bridging the gap between workshop floors and boardroom decisions.

Currently exploring how AI can further transform service management — from predictive maintenance to automated reporting and intelligent scheduling.

Service Operations Management
Power BI & Data Analytics
KPI Dashboard Design
P&L & Profit Management
CRM & AMC Scheduling
Root Cause Analysis (CAPA)
ERP Implementation
Team Leadership (40+ People)
Project Execution
Business Development
Supply Chain Management
AI Tools Integration
02 //

EXPERIENCE

JUN 2023 – PRESENT · PUNE

VATS FILTRATION TECHNOLOGIES

Service Manager

Leading end-to-end service operations for an ISO 9001-2015 certified industrial filtration company. Managing 40+ field engineers across defence, manufacturing, automobile, cement, and power plant sectors. Built Power BI dashboards for live KPI tracking, gross margin analysis, and complaint analytics. Own full P&L accountability for service division.

Power BI P&L Management 40+ Team CRM AMC Scheduling KPI Reporting
NOV 2020 – JUN 2023 · PUNE

SPHAR ENTERPRISES

Deputy Service Manager · ELGI Authorised Dealer

Managed breakdown and preventive maintenance operations for compressed air systems. Maintained ELGI CRM for TTR tracking, AMC scheduling, HMR records, and supply chain trackers. Trained service engineers on new products and ensured commissioning documentation standards.

ELGI CRM Preventive Maintenance Supply Chain Training
OCT 2019 – NOV 2020 · MUMBAI

PRECIOUS ALLOYS PVT. LTD.

Project Engineer · Maintenance

Installation and maintenance of furnaces, casting machines (Indutherm CC400/VCC450/VC600), chiller plants, plating plants, and air compressors. Managed rhodium plating plant modification. Handled piping, gas exhaust systems, and mechanical troubleshooting.

Casting Machines Plant Installation FESTO Valves
FEB 2017 – SEP 2019 · JALGAON

JAIN IRRIGATION SYSTEMS

Maintenance Supervisor

Supervised 30-person maintenance team for German online pipe extrusion machines. Responsible for hydraulic systems, pipe cutters, haul-offs, and water bath tanks. Collaborated with new part development and tool room teams.

30-Person Team German Machinery Hydraulics Extrusion
MAY 2014 – MAY 2015 · JALGAON

TATA MOTORS

Maintenance Assistant

Early-career hands-on industrial maintenance experience at one of India's largest automotive manufacturers. Built foundation in disciplined maintenance operations and engineering practices.

Automotive Industrial Maintenance
03 //

SKILLS

📊
DATA & BI
Power BI dashboards with dynamic filters, KPI visualizations, sales analytics, manpower metrics, and complaint trend analysis across FY cycles.
⚙️
SERVICE OPS
Full service lifecycle management — breakdown response, preventive maintenance, AMC scheduling, CRM, SLA management, and field team coordination.
🤖
AI TOOLS
Practical AI integration in daily operations — using AI for reporting, automation, content creation, analysis, and operational efficiency improvements.
📈
P&L MANAGEMENT
End-to-end profit accountability for service divisions. Monthly billing targets, margin tracking, expense optimization, and revenue growth strategies.
🏭
INDUSTRIAL TECH
Deep expertise across hydraulics, oil filtration systems, air compressors, casting machines, pipe extrusion, and mechanical engineering fundamentals.
👥
LEADERSHIP
Managed teams of 30–40+ engineers across multiple locations. Training, performance reviews, scheduling, and building high-performance service cultures.
04 //

PROJECTS

PROJECT_01 // 2022–PRESENT

DYNAMIC INSIGHT HUB

Power BI transformation of VATS service operations. Interactive dashboards tracking monthly service sales, gross margins, average order values, manpower efficiency, expense distribution, and complaint analytics — with dynamic filters for strategic decisions. Covers historical data FY 2022–2024.

Power BI KPI Analytics Service Ops Data Viz
PROJECT_02 // DEC 2023

SUPER ONLINE STORE ANALYTICS

End-to-end data analytics project using time series analysis for sales forecasting. Built interactive dashboards for decision-makers, implemented predictive models, and delivered real-time actionable insights that significantly improved forecasting accuracy and operational performance.

Time Series Sales Forecasting Dashboard Data Analytics
PROJECT_03 // ONGOING

AI-POWERED GOOGLE ADS

Running targeted Google Ads campaigns for VATS Filtration — managing bidding strategy, audience targeting, and conversion optimization. Leveraging AI tools to analyze campaign diagnostics, optimize budget allocation, and drive industrial client acquisition at minimum cost.

Google Ads AI Optimization Digital Marketing
PROJECT_04 // ONGOING

OIL FILTRATION NAS IMPROVEMENT

Field-documented NAS level improvement from NAS 11 → NAS 6 for hydraulic and turbine oils. Live before-after case studies showing water-contaminated oil restoration. Translating technical results into ROI-focused service offerings for industrial clients.

Oil Filtration NAS Analysis Field Engineering
pramod@vats:~$
$ run ai_integration --status
✓ Google Ads optimization: ACTIVE
✓ Power BI automation: ACTIVE
✓ AI reporting pipeline: ACTIVE
✓ Portfolio site: DEPLOYED

$ get --tools
Claude AI, ChatGPT, Power BI,
Google Ads, ERP Systems, CRM,
Excel Advanced, MS Project

$ status --learning
✓ AI for Business (LinkedIn, 2024)
✓ MS365 Project Mgmt (LinkedIn, 2024)
✓ SAP MM, Excel Advanced

$

AI MEETS
INDUSTRIAL
OPERATIONS

I'm not just a service manager who uses computers — I'm actively building AI into how industrial service work gets done.

From running Google Ads campaigns with smart bidding to designing Power BI dashboards that replace manual reporting, I use every available tool to make operations leaner and decisions faster.

This portfolio itself is a live example: built with AI, designed for impact, linked from LinkedIn so every prospect sees the full picture.

Claude AI ChatGPT Power BI Google Ads AI SAP MM MS365 ERP Systems
05 //

CONTACT

LET'S BUILD
SOMETHING
EFFICIENT.