Omkar Kedari

Operations Associate

Pune, Maharashtra, India5 yrs 9 mos experience

Key Highlights

Certified Power BI Data Analyst with proven expertise.
Developed multiple impactful BI solutions for manufacturing.
Skilled in transforming data into actionable insights.

Stackforce AI infers this person is a Business Intelligence Analyst specializing in manufacturing data solutions.

Contact

Skills

Core Skills

Power BiBusiness IntelligencePower AppsData Analysis

Other Skills

Business AnalyticsCommunicationDAXDashboard BuildingData EntryData ExtractionData ModelingData VisualizationDefect AnalysisExtract, Transform, Load (ETL)Key Performance IndicatorsLifelong LearningMicrosoft 365Microsoft ExcelPower Automate

About

Certified Power BI Data Analyst (PL-300) with 4 years of experience in developing end-to-end Business Intelligence solutions. Proven expertise in Power BI, Power Apps, Power Automate, Azure Data Factory (ADF), SQL Server, SharePoint, and Excel. Strong focus on data visualization, automation, and performance optimization across domains like Quality, Operations, and HR. Adept at translating business needs into impactful dashboards that drive real-time decisions and reduce manual effort. Passionate about leveraging data analytics to drive operational efficiency and business growth. Skilled in transforming raw data into actionable insights and creating scalable solutions across diverse industries. Key projects include: Developing a PS1 Data Entry App to ensure high-quality firewall data entry and QA. Building a Defect Concentration App integrated with Power BI for shop-floor defect analysis. Designing an OEE Form IIOT App for real-time operational performance tracking. Implementing Azure Data Factory (ADF) pipelines to extract data from Azure Blob Storage, transform it through SQL-based logic, and load it into Power BI datasets for enterprise reporting. Currently focused on expanding expertise in advanced SQL, ADF pipeline optimization, and end-to-end BI architecture to deliver high-impact analytics solution

Experience

Mahindra group

Assistant Manager

Sep 2025 – Present · 6 mos

Tata autocomp systems ltd

BI AND ETL DEVELOPER

Jan 2023 – Sep 2025 · 2 yrs 8 mos · Pune · On-site

Key Responsibilities:
Developed and deployed 10+ interactive dashboards in Power BI, enabling real-time performance monitoring and analysis for production and quality teams.
Automated workflows using Power Automate, reducing manual data entry time by 30% and improving reporting efficiency.
Created custom applications in Power Apps, saving 10+ hours per week by streamlining data entry and defect tracking processes.
Utilized SQL to extract, transform, and analyze datasets, improving data accuracy by 25%.
Monitored OEE (Overall Equipment Effectiveness) and defect trends, leading to a 15% improvement in production quality.
Key Achievements:
PS1 Data Entry App: Built a data entry and quality assurance system, reducing errors by 20% and ensuring compliance with reporting standards.
Defect Concentration App: Designed and implemented a Power BI-based tool for defect analysis, leading to a 10% reduction in defect rates within the first 3 months.
OEE Form IIOT App: Delivered a real-time performance tracking solution for manufacturing operations, resulting in a 12% increase in overall equipment utilization.
Automated reporting and email notifications, reducing manual intervention and improving response time by 40%.

Power BIPower AutomatePower AppsSQLData VisualizationDashboard Building+1

Sm auto engineering pvt ltd

Trainee Engineer

Aug 2021 – Dec 2022 · 1 yr 4 mos · Pune, Maharashtra, India · On-site

Key Responsibilities:
Supported production data analysis and process improvement projects, contributing to 5% cost savings in manufacturing operations.
Assisted in building Power BI reports to track production metrics and quality performance.
Monitored and analyzed machine downtime trends, leading to a 7% increase in uptime through preventive measures.
Collaborated with the engineering and quality teams to streamline data entry and defect tracking processes.
Key Achievements:
Improved data accuracy and reporting efficiency by 20% through automation and data validation tools.
Developed a maintenance tracking system that reduced downtime incidents by 15%.
Delivered process optimization reports that contributed to 10% faster decision-making for production scheduling.

Power BIData AnalysisProcess Improvement