Contact me at:

SAMAR MANDKE

Smart Automation Tools developer | Field Service engineer

Achieve freedom from Repeated Tasks by saving 2+ hours daily

ABOUT ME

Automate Today . Live Your Dream Tommorow

Samar Mandke lives in Mumbai with his joint family, drawing inspiration from a home full of love and shared responsibilities. A unique blend of Field Service Engineer and Data Analytics Specialist, Samar has spent over 15 years streamlining complex tasks with smart automation.

Samar Mandke lives in Mumbai, India, with his parents, wife, and child in a joyful joint family. Surrounded by love and shared responsibilities, he draws daily inspiration from his home life. Outside work, he enjoys music, travel, and quality time with loved ones, firmly believing that creativity thrives in balance.
Professionally, Samar is a rare blend of Field Service Engineer and Data Analytics Specialist, with 15+ years of experience (10+ in data-centric roles). Starting with biomedical engineering, he worked hands-on with technologies like MRI machines and surgical robots systems critical to patient safety.
Facing increasing service demands and inefficiencies, he began automating tasks using Excel and VBA, which sparked a deeper journey into data analytics. Over time, he mastered SQL, Tableau, and Python to build intelligent solutions that improved outcomes.

He holds a Postgraduate Diploma in Operations Management (2013) and a Postgraduate Diploma in Computer Science and Artificial Intelligence (2022), with hands-on project experience. Project work details are available at eportfolio.mygreatlearning.com/samar.
Samar’s skillset developed over the decade of real-world problem-solving into powerful, time-saving strategies practised by the top 2% of professionals, saving up to 2 hours daily. It's a practical guide to boosting productivity through automation and data-driven insights.

15+
Years of Experience
100+
Automation Tools
50+
Dashboards Built
1000+
Hours Saved
Return to Top

SKILLS AND TOOLS

Data Automation
📊 Excel (Formulas, Pivot, Power Query)
🤖 VBA Automation & Dashboards
🐍 Python (Pandas, NumPy, Matplotlib)
🧮 Power BI (DAX, Modeling)
📈 Tableau (Interactive Visuals)
🗃 SQL for Data Handling
Data Science
📊 Exploratory Data Analysis (EDA)
📉 Predictive Modeling
🧠 Machine Learning Algorithms
🗃 Data Cleaning & Wrangling
📚 Scikit-Learn, Seaborn, Matplotlib
Project & Process Management
📌 Project Planning & Tracking
📈 Improving Process
📝 Technical Report Writing
🤝 Cross-Team Collaboration
Field Service Engineer
🔧 Equipment Troubleshooting
🛠 Preventive Maintenance
📏 Calibration, IQ/OQ/PQ
🔍 Root Cause Analysis (RCA)

My Projects

Accordion Full Feature
Data Automation (Excel and VBA)
  • KPI Dashboard
  • Contracts and Payment Trackers
  • File Management
  • Automated GSTR Reports
  • Automation with Outlook, Word, PPT
📊 KPI Automation Dashboard

🔹 Automated Data Refresh – Eliminate repetitive tasks with live KPI updates.

🔹 Custom Metrics & Views – Track the performance indicators that matter most to your business.

🔹 Interactive Dashboards – Explore trends with dynamic charts, filters, and drill-downs.

🔹 Smart Alerts – Get notified about risks or opportunities instantly.

🚀 Impact: This solution reduces reporting time, minimizes human error, and empowers teams to focus on strategic actions rather than data preparation.
📑 Contracts & Payment Tracker

🔹 Centralized Contracts – Store and manage all your contracts in one secure location.

🔹 Payment Tracking – Monitor invoices, milestones, and due payments effortlessly.

🔹 Smart Reminders – Get notified about renewals, overdue payments, and approvals.

🔹 Analytics & Reports – Gain insights into cash flow, contract status, and vendor performance.

🚀 Impact: This tracker streamlines contract management, ensures timely payments, reduces errors, and gives your team clarity for better decision-making.
📂 File Management Tools

🔹 Open & Access – Quickly open files and folders without searching endlessly.

🔹 Rename Files – Keep your documents organized with clear, consistent names.

🔹 Delete Safely – Remove unwanted files with secure deletion and recycle options.

🔹 Copy & Duplicate – Easily copy files or create duplicates for backups.

🔹 Move & Organize – Drag and drop files between folders to maintain structure.

🚀 Impact: Streamlines file operations, reduces clutter, prevents errors, and keeps your digital workspace organized and efficient.
📊 Automated GSTR Reports

🔹 Auto Data Fetch – Pull GST data directly from multiple sources without manual entry.

🔹 Real-Time Calculations – Instantly calculate tax liabilities, input credits, and totals.

🔹 Custom Reports – Generate GSTR-1, GSTR-2, GSTR-3B, and other reports tailored to your needs.

🔹 Error Checks & Alerts – Identify mismatches or missing entries automatically.

🚀 Impact: Saves hours of manual work, reduces errors, ensures compliance, and provides accurate, audit-ready GST reporting.
🤖 Office Automation: Outlook, Word & PowerPoint

🔹 Outlook Automation – Send emails, schedule meetings, and manage inboxes automatically.

🔹 Word Automation – Generate documents, fill templates, and format content with a click.

🔹 PowerPoint Automation – Create slides, update charts, and automate presentations effortlessly.

🚀 Impact: Reduces repetitive tasks, boosts productivity, ensures consistency, and frees up time for strategic work.
Data Automation (Python)
  • Data Cleaning
  • Power Grid Management
  • Master-Slave Load Balancing for IoT Sensors
  • Route Discovery in Graphs
🧹 Data Cleaning for EDA

🔹 Remove Duplicates & Nulls – Clean your datasets for accurate analysis.

🔹 Standardize Formats – Ensure consistency in dates, numbers, and text fields.

🔹 Correct & Impute Data – Fix errors and fill missing values intelligently.

🔹 Validate & Transform – Apply business rules and prepare data for exploration.

🚀 Impact:
Streamlines data preprocessing, improves analysis accuracy, and enables faster, reliable insights for decision-making.
Power Grid Data Management

🔹 Node Mapping – Represent power stations, substations, and transformers as connected nodes.

🔹 Edge Connections – Model transmission lines with capacity, voltage, and distance attributes.

🔹 Graph Structure – Store the grid as a graph for easy traversal, analysis, and simulations.

🔹 Load & Failure Analysis – Identify critical paths, simulate outages, and optimize power flow.

🚀 Impact:
Visualizing and managing power grid data as a graph enhances efficiency, improves reliability, and enables faster decision-making in energy distribution.
⚙️ Master-Slave Load Balancing for IoT Sensors

🔹 Master Coordination – Central node manages communication and workload distribution among slave sensors.

🔹 Slave Optimization – Sensor nodes share processing and data collection tasks efficiently.

🔹 Dynamic Load Shifting – Automatically shift load from busy nodes to underutilized ones.

🔹 Fault Resilience – Detect failures and redistribute tasks to maintain seamless operation.

🚀 Impact:
Ensures efficient energy usage, prevents sensor overload, improves network reliability, and maximizes overall IoT system performance.
🗺️ Route Discovery in Graphs

🔹 Node Connectivity – Identify all possible paths between two nodes in a network.

🔹 Shortest Path – Find the quickest or least-cost route using algorithms like Dijkstra or BFS.

🔹 Multiple Routes – Explore alternative paths to optimize traffic, power flow, or data routing.

🔹 Network Analysis – Detect bottlenecks, critical connections, and redundant links.

🚀 Impact:
Enables efficient routing, minimizes delays, improves reliability, and supports decision-making in networks and system designs.
Data Science
  • Telecom Customer Churn Prediction
  • Mobile User Demographics
  • Google Store Rating App Prediction
  • Bank Loan Defaulter Prediction
  • Signal Quality prediction
  • Flower Species Classification
  • Sarcasm detection in tweets
  • Pnemonia Detection using XRay images
📊 User Segmentation with Clustering

🔹 Unsupervised Learning Model – Group users based on similar interests, habits, and behaviors.

🔹 Cluster Analysis – Identify distinct user segments for targeted strategies.

🔹 Personalized Engagement – Enable apps and mobile providers to deliver relevant content and offers.

🔹 Insights for Growth – Understand user behavior patterns to improve retention and satisfaction.

🚀 Impact:
Optimizes marketing efforts, enhances user experience, and drives engagement by leveraging data-driven segmentation.
📊 Customer Churn Prediction

🔹 Supervised Learning Model – Classify customers based on the probability of churn using historical data.

🔹 Pattern & Insight Analysis – Identify key factors and trends that drive customer churn.

🔹 Retention Strategy Support – Enable targeted interventions to retain high-risk customers.

🔹 Data-Driven Decisions – Focus marketing and support efforts where they matter most.

🚀 Impact:
Reduces customer attrition, improves retention strategies, and maximizes lifetime value by understanding churn patterns.
📱 App Rating Prediction

🔹 Data-Driven Insights – Collect app features, user reviews, and ratings from Play Store datasets.

🔹 Predictive Modeling – Use machine learning to predict the rating of a given app.

🔹 Feature Analysis – Identify which app features contribute most to higher ratings.

🔹 Strategic App Development – Help developers focus on features that enhance success and profitability.

🚀 Impact:
Increases chances of app success, guides feature optimization, and enables data-driven decisions for app development.
🏦 Bad Loan Analysis & Prediction

🔹 Data-Driven Insights – Analyze loan attributes like funded amount, term, interest rate, and borrower details.

🔹 Predictive Modeling – Use machine learning to identify high-risk loans and potential defaulters.

🔹 Risk Assessment – Understand patterns that lead to delayed or defaulted payments.

🔹 Strategic Decision Support – Help banks minimize losses and improve lending strategies.

🚀 Impact:
Reduces non-performing assets, improves loan approval decisions, and strengthens financial stability.
📡 Signal Quality Prediction

🔹 Problem: A communications equipment manufacturer needs to ensure reliable signal transmission.

🔹 Solution: Build a Deep Learning model that predicts signal quality using multiple parameters such as frequency, power, noise levels, and environmental conditions.

🔹 Benefits:
✅ Early detection of poor signal quality
✅ Improved equipment performance
✅ Reduced downtime & maintenance costs

🚀 Impact: Ensures stable communication networks, enhances customer satisfaction, and boosts operational efficiency.
🌺 Flower Species Classification

🔹 Problem: Identifying flower species manually is time-consuming and error-prone.

🔹 Solution: Develop a Convolutional Neural Network (CNN) that classifies different flower species from their images with high accuracy.

🔹 Benefits:
✅ Automates species identification
✅ Helps in research & biodiversity studies
✅ Useful in agriculture & botanical applications

🚀 Impact: Enhances accuracy in plant identification, aids ecological studies, and supports smart farming solutions.
😏 Sarcasm Detection in Tweets

🔹 Problem: Understanding sarcasm in text is challenging for both humans and machines, as it often relies on hidden context and tone.

🔹 Solution: Build an NLP-based supervised learning model using deep learning (LSTMs/Transformers) to detect sarcasm in tweets.

🔹 Benefits:
✅ Improves sentiment analysis accuracy
✅ Helps brands track genuine customer feedback
✅ Supports mental health & social media monitoring

🚀 Impact: Enables companies and researchers to better interpret online conversations, reducing misclassification of emotions and opinions.
🩻 Pneumonia Detection using X-ray Images

🔹 Problem: Pneumonia is a serious lung infection that can be life-threatening if not diagnosed early. Manual diagnosis through X-ray scans is time-consuming and prone to human error.

🔹 Solution: Develop a Convolutional Neural Network (CNN) model that classifies chest X-ray images into Pneumonia and Normal categories.

🔹 Benefits:
✅ Faster and more accurate diagnosis
✅ Assists radiologists in decision-making
✅ Scalable for use in healthcare systems

🚀 Impact: Enhances early detection of pneumonia, reduces diagnostic errors, and supports doctors in saving lives.
Project Management
  • Automated Project Task Tracker
  • Resource Allocation & Capacity Planning System
📌 Automated Project Task Tracker

🔹 Task Creation – Capture project tasks via forms, emails.

🔹 Auto Assignment – Allocate tasks to team members based on workload or expertise.

🔹 Real-Time Status Updates – Sync progress automatically in SharePoint, Google Sheets, or Power BI dashboards.

🔹 Alerts & Reminders – Notify team members of deadlines, delays, and dependencies.

🔹 Analytics – Track completion rates, overdue tasks, and team productivity with automated reports.

🚀 Impact: Boosts team collaboration, reduces manual tracking, and ensures on-time project delivery.
📌 Resource Allocation & Capacity Planning System

🔹 Resource Pooling – Centralize employee skills, roles, and availability in SharePoint / Google Sheets.

🔹 Smart Allocation – Auto-assign resources to projects based on skill match, workload, and availability.

🔹 Capacity Forecasting – Use Power BI / Power Query to predict overutilization or underutilization.

🔹 Dynamic Updates – Real-time sync when project timelines shift or priorities change.

🔹 Reporting – Automated dashboards showing utilization %, bottlenecks, and future demand vs. supply.

🚀 Impact: Optimizes workforce usage, prevents burnout, and ensures projects meet deadlines with the right resources.
Robotics Process automation( RPA)
  • Customer Support Ticket Automation
  • Automated Feedback Response System
🎫 Customer Support Ticket Automation

🔹 Trigger & Capture – Automatically log new tickets from Google Forms or Microsoft Forms.

🔹 Ticket Management – Create and store tickets in SharePoint or Google Sheets for easy tracking.

🔹 Categorization & Tracking – Use Power Query to categorize tickets (billing, tech, general) and monitor SLA status.

🔹 Automation & Reporting – Auto-assign tickets to agents and generate weekly resolution reports.

🚀 Impact: Speeds up support processes, ensures timely responses, and improves customer satisfaction through streamlined ticket management.
📊 Automated Feedback Response System

🔹 Feedback Collection – Gather responses from surveys, forms, and customer reviews automatically.

🔹 Intelligent Categorization – Classify feedback by type (complaints, suggestions, praise) using NLP techniques.

🔹 Automated Responses – Generate instant, context-aware replies to customer feedback.

🔹 Reporting & Insights – Track trends, sentiment, and recurring issues for business improvement.

🚀 Impact: Enhances customer engagement, speeds up response times, and provides actionable insights for better decision-making.
Field Service Enginner(FSE)
  • Service Analytics & Reporting
  • Service Planner
📊 FSE Service Analytics

🔹 Performance Monitoring – Track FSE efficiency, task completion rates, and on-time service delivery.

🔹 Demand Forecasting – Predict upcoming service calls and allocate FSEs proactively.

🔹 Route & Travel Insights – Analyze travel patterns to optimize field visits and reduce downtime.

🔹 SLA & Compliance Tracking – Ensure timely service and adherence to agreements.

🔹 Actionable Insights – Identify training needs, high-performing engineers, and areas for operational improvement.

🚀 Impact: Enhances FSE productivity, reduces response times, optimizes resource allocation, and supports data-driven field operations.
🛠️ Weekly Service Planner

🔹 Smart Scheduling – Plan service calls for the week by clustering tasks based on priority and location.

🔹 Travel Optimization – Minimize travel time by mapping efficient routes between service calls.

🔹 Priority Management – Attend high-priority tasks first while balancing routine maintenance and PMS.

🔹 Auto Assignment & Alerts – Allocate technicians based on expertise and availability, with real-time notifications.

🔹 Reporting & Insights – Track weekly progress, pending calls, and optimize future schedules.

🚀 Impact: Boosts productivity, reduces travel costs, ensures timely service, and enhances customer satisfaction.

EXPERIENCE

GE Healthcare
2010 - 2016
Intuitive Surgical India Pvt. Ltd.
2016 - Present

CERTIFICATIONS

Education

PGDM
Artificial Intelligence & CS
(IIITD)
PGDM
Operations Management (Wellingkar Mumbai)
B.E
Biomedical Engineering
(Mumbai University)

What People Say about me

Voice of trust – Professional Views

Testimonial Grid
Person 1

"Samar excels at turning complex business needs into scalable, high-performing software that delivers real value, combining technical expertise with empathy and business insight."

- Vidyadhar Gawade
(Manager at Amazon)

Person 2

"Samar’s expertise in data analytics, smart solutions, and problem-solving made a big impact at Intuitive Surgical; he’s a collaborative professional who consistently delivers with insight and enthusiasm."

- Mayur Phutane
( FSE at Intuitive Surgical)

Person 3

"Samar excels in smart tools, automation, and data analytics, leveraging Excel, VBA, Python, SQL, Power BI, and Tableau to create efficient, data-driven solutions that save time and drive productivity. transformation."

- Rohan Kadam
(Senior Analyst at DXC)

Person 4

"I had the privilege of working with Samar at GE Healthcare, where his professionalism, expertise, and collaborative spirit stood out. A reliable and insightful problem-solver, he thrived in our global team and is an asset to any organization."

- Arijit Roy,
( Lead Customer Service Sepcialist (Bangladesh)