AK
Portfolio Loading
Please wait...
Experience Impact Projects Skills Education Certs Contact
๐Ÿ“ Mumbai, Maharashtra, India  ยท  Open to Opportunities

Akshay Kanavaje

Data Analyst  ยท  Applied Data Scientist  ยท  Python ยท SQL ยท Power BI ยท AWS

Hands-on experience across the full analytics lifecycle data cleaning, feature engineering, time series forecasting, dashboarding, and predictive modeling. Background in engineering and data quality brings a strong focus on data integrity, reproducibility, and reliable decision-making across retail, operations, and research environments.

8Projects Built
8Certifications
6Industries Covered
โšก Top Impact
โœ… 100% Compliance Traceability @ Dembla
๐Ÿ“Š 7,120 Production Records Analyzed
๐Ÿค– End-to-End ML Pipeline Deployed
๐Ÿ›ก๏ธ 6 Security Vulnerabilities Remediated
๐Ÿ“ˆ XGBoost Forecasting Models Built @ EPO

Work History

Eru-Tech Solution Pvt Ltd
Intern
May 2026 โ€“ Present๐Ÿ“ Mumbai, India
โ–พ
  • Built and tested GraphQL API queries and mutations using Postman on a production low-code developer infrastructure platform including variables, fragments, aliases and error debugging on live PostgreSQL backed endpoints.
  • Wrote complex PostgreSQL queries using JSONB operators to extract, transform and load nested JSON data through production ETL pipelines connecting external data sources to PostgreSQL via GraphQL APIs.
  • Worked on production data pipelines processing real-time data and user behaviour events including Go template functions for dynamic query generation and multi-step function orchestration on live databases.
J D Wetherspoon
Operations Associate
Nov 2023 โ€“ Dec 2025๐Ÿ“ United Kingdom
โ–พ
  • Queried transactional sales data using SQL to combine tables for item-level and category-level analysis.
  • Analyzed 5โ€“6 months of daily sales data to calculate averages, identify weekday seasonality, and assess demand variability.
  • Calculated basic forecasting metrics including moving averages and demand variance to improve alignment between expected sales and prep quantities.
  • Assisted in inventory review by estimating lead-time demand and comparing theoretical usage with actual consumption.
  • Monitored waste trends and highlighted high-variance items affecting cost percentage.
European Patent Office
Research Intern โ€” Data Science
Jul 2023 โ€“ Oct 2023๐Ÿ“ United Kingdom
โ–พ
  • Built automated data preprocessing and feature engineering pipelines using Python (pandas, NumPy) for large-scale patent datasets, improving time-series forecasting accuracy by approximately 10% over baseline models.
  • Developed and optimized forecasting models using XGBoost and statistical time-series techniques including ACF/PACF and seasonal decomposition, producing more stable and interpretable patent trend predictions.
  • Validated model assumptions and documented edge cases through trend analysis and error diagnostics, improving transparency, reproducibility, and stakeholder confidence in forecasts.
iNeuron.ai
Data Analytics Training Program
Dec 2020 โ€“ May 2022 ยท 1.5 yrs๐Ÿ“ India
โ–พ
  • Completed structured program covering Python, SQL, statistics, and end-to-end machine learning workflows.
  • Performed data cleaning, feature engineering, and exploratory data analysis on structured and semi-structured datasets.
  • Gained hands-on exposure to model building, model evaluation, cross-validation, hyperparameter tuning, and deployment workflows.
Dembla Valves Limited
Quality Control Engineer
Dec 2018 โ€“ Dec 2019๐Ÿ“ India
โ–พ
  • Validated ERP-based incoming material records and inspection datasets against standards, ensuring structured data integrity and 100% compliance traceability across procurement and production stages.
  • Designed and maintained structured Excel-based supplier performance trackers to monitor defect rates, rejection frequency, documentation gaps, and corrective action closures enabling data-driven vendor evaluation.
  • Managed multi-stage inspection data (receiving, in-process, testing, final inspection) to monitor cycle time, rejection patterns, and quality deviations across production workflows.
  • Tracked third-party inspection schedules and turnaround metrics to minimise delivery delays and maintain audit-ready documentation for client dispatch.
  • Coordinated inspection, procurement, and production records across ERP systems to ensure traceability from raw material receipt to final client dispatch.

Measurable Results

โœ…
100%
Compliance Traceability
Achieved full compliance traceability across procurement and production stages at Dembla Valves by validating ERP-based records against quality standards.
Metric
๐Ÿญ
7,120
Production Records Analyzed
Analyzed 7,120 production records across 8 machines and 3 shifts over a full year for the OEE Manufacturing Performance Dashboard built in Power BI.
Scale
โš™๏ธ
18
DAX Measures Built
Built 18 DAX measures covering OEE components, downtime classification, and capacity utilisation. Assembly Line B identified at 50.87% OEE with 2,083 hours lost annually.
Technical
๐Ÿ”
69.62%
OEE Gap vs 85% World-Class Benchmark
Identified plant-wide OEE of 69.62% vs 85% benchmark. Unplanned breakdowns accounted for 34.21% of downtime. 15.8 point gap between Morning and Night shifts across all machines.
Discovery
๐Ÿค–
Full Stack
ML Pipeline Deployed to Production
Deployed an end-to-end book recommendation system using collaborative filtering, Flask, and Heroku โ€” from model training to live web application.
Deployment
๐Ÿ“Š
XGBoost
Forecasting Models at European Patent Office
Built and optimized XGBoost and statistical time-series models for large-scale patent datasets at EPO, producing stable and interpretable patent trend predictions.
Research

Featured Work

AI-Driven Compliance Query Automation System
โ†—

End-to-end AI compliance assistant using Python, Flask and LLM API to automate audit and compliance queries for 800+ real business clients โ€” reducing response time from hours to under 3 seconds with 24/7 availability. Engineered document intelligence with pdfplumber for instant structured summaries from government notices. Identified and remediated 6 critical vulnerabilities including cross-account session hijacking and 17 categories of prompt injection attacks before production deployment.

PythonFlaskMySQLLLM APIpdfplumberTwilio
Supply Chain Inventory & Logistics Optimization
โ†—

EDA on supply chain data including sales, inventory, transportation, and defect rates. Analyzed revenue by product type and SKU, transportation costs, defect rates across carriers and shipping modes, plus inventory metrics such as stock levels, order quantities, and lead times.

PythonPandasNumPyPlotly
OEE Manufacturing Performance Dashboard
โ†—

Interactive Power BI dashboard analyzing 7,120 production records across 8 machines and 3 shifts. Identified 69.62% OEE vs 85% benchmark. Assembly Line B emerged as the critical underperformer at 50.87% with 2,083 hours lost annually โ€” nearly 4x the best-performing machine.

Power BIDAXExcel
Car Insurance Purchase Prediction Model
โ†—

Predicts car insurance purchase likelihood using customer demographics, vehicle attributes, and behavioral patterns. Compared Decision Tree, KNN, and Random Forest classifiers evaluated using Precision, Recall, F1-score, and ROC-AUC to identify high-likelihood customer segments.

PythonScikit-learnRandom ForestKNN
Recommendation System โ€” Collaborative Filtering
โ†—

Personalized book recommendation system using collaborative filtering in Python. Deployed as a full end-to-end web application using Flask and Heroku, demonstrating practical model integration and delivery.

PythonFlaskHerokuCollab. Filtering
Automated Content Categorization & Tagging (NLP)
โ†—

Automated categorization pipeline using NLP techniques and BERT-based text representations for scalable classification of unstructured text. Improved classification quality through advanced EDA, cleaning, and tokenization ensuring high-integrity model inputs.

PythonBERTNLPTransformers
Product & State-Level Profitability Dashboard
โ†—

Interactive profitability dashboards in Tableau analyzing product-, state-, and category-level sales and margin performance. Created P&L reporting views to identify revenue trends, margin drivers, and customer-level profitability insights.

TableauP&L AnalysisData Viz
WhatsApp Chat Analytics & Engagement Tool
โ†—

Analytics tool processing unstructured WhatsApp chat exports to deliver automated insights into user activity, engagement, and conversation patterns. Features a user-facing web interface for uploading and analyzing chat data.

PythonNLPFlaskEDA

Technical Arsenal

Languages & Frameworks
PythonSQLFlask
Tools & Technologies
Power BIDAXTableauAWS EC2AWS S3Data Preparation & ValidationExploratory Data AnalysisStatistical AnalysisKPI Development & TrackingData CleaningData Visualization
Business & Operations Analytics
Business AnalyticsSupply Chain & Inventory AnalyticsSales & Demand AnalysisOperational Performance Analysis
Delivery & Stakeholder Enablement
Stakeholder ReportingInsight CommunicationRequirements GatheringDecision Support Analytics
ML & Modelling
XGBoostRandom ForestDecision TreeKNNCollaborative FilteringTime Series ForecastingACF/PACFSeasonal DecompositionBERT / NLPFeature EngineeringHyperparameter TuningCross-Validation

Academic Background

๐ŸŽ“
Master's Degree โ€” Data Science and Analytics
Cardiff University
2022 โ€“ 2023๐Ÿ“ United Kingdom
โš™๏ธ
Bachelor of Engineering โ€” Mechanical Engineering
Lokmanya Tilak College of Engineering
2015 โ€“ 2018๐Ÿ“ India
๐Ÿ“
Diploma in Engineering โ€” Mechanical Engineering
Maharashtra State Board of Technical Education (MSBTE)
2012 โ€“ 2015๐Ÿ“ India

Licenses & Credentials

๐Ÿ…
Supply Chain Foundations
Project Management Institute (PMI)
๐Ÿค–
GraphQL: Introduction to graphQL for beginners
Udemy
๐Ÿ“Š
Deloitte Australia - Data Analytics Job Simulation
Forage
๐Ÿค–
Using Generative AI in Supply Chains
LinkedIn Learning
โšก<
Tableau for Data Scientists
LinkedIn Learning
โšก
Power BI
iNeuron.ai
๐Ÿง 
Machine Learning and Deep Learning
iNeuron.ai
๐ŸŽฏ
Data Science Mentorship Program
CampusX

Let's Connect

Open to Data Analyst and Applied Data Scientist roles. I bring a full-stack analytics mindset โ€” from raw data to business decisions. Based in Mumbai, open to remote and relocation opportunities.