ASHISH KUMAR
Data Analyst
About
Data Analyst with 7+ years of engineering and analytics experience, including a competitive internal transition into a dedicated analytics role at a global manufacturing enterprise, achieved through a technical interview on the strength of self-developed SQL and analytical skills. Proficient in SQL, Python (Pandas, NumPy), Power BI, and Excel, with hands-on experience cleaning and analyzing multi-source data, building KPI dashboards, and automating manual reporting workflows. Skilled at translating business requirements from cross-functional stakeholders into clear, actionable analysis, and comfortable working independently in fast-paced, deadline-driven environments.
Skills & Expertise
No skills listed yet
Work Experience
Data Analyst — Manufacturing & Product Analytics
JCB India Limited (via Sphinx Worldbiz Ltd.)
Nov 2025 - Present
Analyzed multi-source part-level cost data using SQL and Python (Pandas) to clean, transform, and compare BOM datasets, identifying cost variances of up to INR 8.46 lakh across product variants and cutting analysis turnaround time by 40%. Designed and built interactive Power BI dashboards (star-schema data models, DAX measures) to track build status, resolution rates, and approval progress for cross-functional teams — raising a key resolution-rate KPI to 97.6%. Applied machine learning (Random Forest, 84% accuracy) to engineering test data to flag failure-prone components, supporting proactive decision-making worth an estimated INR 12 lakh in avoided cost. Used Generative AI tools to automate extraction and summarization of technical reports, reducing manual documentation effort and freeing up time for higher-value analysis. Built Excel-based data models and pivot analyses to track cost impact and changes across development cycles for stakeholders in design and procurement. Wrote SQL queries against PLM (Teamcenter) data to automate recurring reports on release status, revision history, and sign-off completion, replacing manual status tracking. Partnered with design and procurement teams to build supplier-submission tracking dashboards, reducing resolution time by 37% and improving cross-team visibility into deadlines.
Senior Design Engineer
JCB India Limited (via Sphinx Worldbiz Ltd.)
Aug 2022 - Oct 2025
Built and maintained structured cost/BOM datasets for new product proposals, benchmarking against existing products to quantify part content and cost impact — the analytical foundation later applied to data analytics projects. Led cross-functional design integration, release coordination, and issue tracking/resolution for new product development, ensuring on-time validation and delivery. Directed build support for prototype and pre-production units, tracking and resolving in-process issues to keep programs on schedule. Coordinated supplier submission timelines for bought-in components and documented compliance requirements and technical reports.
Design Engineer
Escorts Kubota Limited (via Design Tech Systems Ltd.)
May 2019 - Aug 2022
Designed components for construction equipment and led structural layout work, applying data-driven design-improvement processes based on test results and traceability records. Applied engineering standards (GD&T, ASME Y14.5) and structured review processes (FMEA/BOM reviews) to new product development.
Education
Post Graduate Diploma in Tool Design & CAD/CAM - Indo German Tool Room (MSME)
2017 - 2019 · Afghanistan
B.Tech, Mechanical Engineering - DIT School of Engineering, Greater Noida (AKTU)
2011 - 2015 · Afghanistan
Certifications
Data Analytics Master Course (with AI)
IIM SKILLS · 2026
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Relocation
Open to Relocation
