Summary
Overview
Work History
Education
Skills
Certification
Timeline
Onkar  Mate

Onkar Mate

Summary

Data analyst with over three years of experience working across business intelligence and analytics, supporting data-driven decision-making in both business and manufacturing environments. My background includes strong experience in SQL, Power BI, ETL, and data modeling, along with hands-on work in Python for statistical analysis and automation.

I have worked on developing and enhancing analytics tools that perform statistical process and capability analysis, including Cp, Cpk, Pp, and Ppk, and generate automated visualizations and reports from structured input data. I enjoy translating complex datasets into clear insights, building reliable analytics workflows, and collaborating closely with stakeholders to solve real-world quality and process problems.

Overview

4
4
years of professional experience

Work History

Data Analyst

Molex
Banglore, Karnataka
10.2025 - Current
  • Enhanced and maintained a Python-based Capability Analysis application used by the Advanced Product Quality (AQP) team to perform dimensional quality assessments for manufactured parts.
  • Built a custom statistical computation model to perform end-to-end process capability analysis, including Cp, Cpk, Pp, Ppk, overall standard deviation, and within standard deviation, aligned with manufacturing.
  • Developed automated data visualisation components to generate:Histograms, Normal probability plots, Capability charts, Box Plot
  • Implemented automated report generation workflows that produce audit-ready outputs with embedded statistics and visualisations in Excel format and File-based report formats for documentation and traceability
  • Improved tool usability by enabling user-driven configuration, including dimension selection, specification limits, and analysis parameters through a structured interface.
  • Collaborated closely with AQP, quality, and manufacturing stakeholders to ensure statistical outputs and reports aligned with real-world process behaviour , quality expectations, and audit requirements.

BI Developer

Koch Business Solutions India
01.2023 - 09.2025
  • Years of demonstrated experience in developing and promoting business adoption of OLAP cubes using
  • SSAS, SSRS, and SSMS
  • Skilled in monitoring daily refresh processes, managing exceptions in case of failures, ensuring cubes are updated with the latest data, and providing daily refresh status updates to business users
  • Designed automated alerts for critical job failures using power bi and mdx queries, these notifications escalated response time among team members, resulting in an overall decrease of incident resolution time by six hours weekly
  • Developed a strong understanding of business processes and technical knowledge to effectively support enhancement tasks based on requirements, while managing (70+) incidents, (120+) tasks generated by the business and Enhanced 10+ requests, generating $50K+ in business value using this expertise
  • Enhanced ETL processes by optimizing View/stored Procedure queries, SSIS, SSAS Packages resulting in a reduction in cube refresh time
  • Developed comprehensive documentation for root cause analysis and Knowledge transfer, enabling colleagues to gain key business insights and providing clear guidance for effective decision-making
  • Created power BI reports based on business user requirements, utilizing modelling techniques to deliver actionable insights and support data-driven decision-making.

Data analyst intern

06.2022 - 09.2022
  • Customer Segmentation Model (python, NumPy, pandas, Matplotlib, seaborn, SciPy, statistics)
  • Identify potential customer segmentation and provide some meaningful insights from each segment
  • Suggested decision the company should take based on the data insights
  • Capital Asset Pricing Model (python, NumPy, pandas, Matplotlib, Regression)
  • Created CAPM to describe the relationship between systematic risk and expected return for assets with respect to S&P 500

Education

Bachelor of Electrical Engineering -

SPPU University , Nashik, MH
08-2022

Skills

  • Python & Statistical Analysis : Python Pandas NumPy SciPy Stats Models Statistical Modelling Process Capability Analysis
  • Analytics & BI : Power BI SSRS SSIS SSAS DAX SQL Query Tuning
  • Data Engineering & Modelling : ETL Data Warehousing Star Schema Snowflake Schema SQL Server IBM DB2 Indexing
  • Data Quality & Visualisation : Data Profiling Data Cleansing Histograms Probability Plots Data Visualisation
  • Application & Automation : PyQt Excel Automation Report Automation
  • Collaboration & Version Control : GitHub Jira Confluence

Certification

Introduction to Data Analytics (IBM)

Data Analytics Essentials Authorized by IBM

Python for Data Science, AI & Development (IBM)

Databases and SQL for Data Science with Python (IBM)

Timeline

Data Analyst - Molex
10.2025 - Current
BI Developer - Koch Business Solutions India
01.2023 - 09.2025
Data analyst intern -
06.2022 - 09.2022
SPPU University - Bachelor of Electrical Engineering,
Onkar Mate