10/09/2025 updated
KM
100 % available
MIS Executive with Power BI and Data Analytics Expertise
Surat, India B.E. Mechanical Engineering (First Class)
About me
Data Analyst skilled in Excel, SQL, Power BI & Python. Experienced in data cleaning, visualization & reporting. Builds interactive dashboards & insights to support business decisions and improve performance through data-driven analysis.
AutomationBusiness IntelligenceDrilling OperationsData ValidationData CleansingData ModelingEnterprise Resource PlanningPython (Programming Language)NumPyOracle ApplicationsPivot TableRaw DataPower BIProcess AutomationSAP Plant MaintenanceSQL DatabasesBusiness StrategiesPandasData AnalyticsKpi Reporting
Power BI
Dashboard Design, DAX, Data Modeling, Bookmarks, Reset Button, KPI Cards, and Drill-through Reports for creating interactive visualizations and business intelligence solutions.
Advanced Excel
Advanced formulas, Pivot Tables, Conditional Formatting, Data Validation, and Dashboards for comprehensive data analysis and reporting automation.
SQL
Data extraction, joins, and summary reports for MIS with integration capabilities for business intelligence solutions.
Python
Data cleaning and analysis using libraries like Pandas and NumPy for automating reporting processes.
ERP Systems
Experience with SAP PM and Oracle for maintaining logs and generating reports.
Data Analytics
Analytical thinking and problem-solving skills for transforming raw data into actionable business insights.
Process Automation
Automation of MIS reports reducing manual reporting time by 70% through integration of Excel, SQL, and Power BI.
Dashboard Design, DAX, Data Modeling, Bookmarks, Reset Button, KPI Cards, and Drill-through Reports for creating interactive visualizations and business intelligence solutions.
Advanced Excel
Advanced formulas, Pivot Tables, Conditional Formatting, Data Validation, and Dashboards for comprehensive data analysis and reporting automation.
SQL
Data extraction, joins, and summary reports for MIS with integration capabilities for business intelligence solutions.
Python
Data cleaning and analysis using libraries like Pandas and NumPy for automating reporting processes.
ERP Systems
Experience with SAP PM and Oracle for maintaining logs and generating reports.
Data Analytics
Analytical thinking and problem-solving skills for transforming raw data into actionable business insights.
Process Automation
Automation of MIS reports reducing manual reporting time by 70% through integration of Excel, SQL, and Power BI.
Languages
EnglishFluentHindiFluent
Project history
Built Power BI dashboards and Excel reports to track KPIs, production, and downtime trends. Designed interactive dashboards with slicers, bookmarks, and reset buttons for management insights. Automated MIS reports using Excel, SQL, and Power BI, reducing manual reporting time by 70%. Mentored team members on data-driven decision-making and developed reports for spare parts inventory, cost optimization, and machine efficiency.
Created an interactive Power BI dashboard for analyzing equipment downtime, maintenance costs, and KPIs (MTBF, MTTR). Integrated Excel and SQL data sources; implemented DAX measures and bookmarks for dynamic reports. Enhanced management decision-making and maintenance efficiency through automated reporting.
Designed a Power BI dashboard to monitor product-wise sales, inventory turnover, and top-performing SKUs. Developed KPIs such as Sales Growth %, Stock Turnover Ratio, and Contribution %. Improved visibility of slow-moving inventory and sales trends.
Portfolio
Production & Maintenance Dashboard
Designed an interactive Production & Maintenance Dashboard in Power BI to track machine performance, downtime, and output efficiency. Automated data updates and visualized key KPIs to support real-time decision-making and improve operational productivity.
Production & Maintenance Dashboard
Designed an interactive Production & Maintenance Dashboard in Power BI to track machine performance, downtime, and output efficiency. Automated data updates and visualized key KPIs to support real-time decision-making and improve operational productivity.