Mani Gandan

Power BI Developer with 10+ years of experience in Analytics and MIS, including 5+ years of hands-on Power BI development across manufacturing, automotive, and logistics environments. Skilled in building end-to-end BI solutions - from data modeling and DAX measure development to Power Query transformations, Power BI Service publishing, and stakeholder-ready dashboards. Proficient in writing SQL queries against SQL Server, Oracle, and MySQL, implementing Row-Level Security, and optimizing dashboard performance on large datasets.

Experienced in partnering with sales, production, finance, and operations stakeholders to translate business requirements into clear KPI dashboards that support day-to-day decision-making in manufacturing analytics environments.

Assistant Manager – MIS & Data Analytics at Inframat Alloys (2025-03 – Present)

• Design and maintain Power BI dashboards covering sales, production, and dispatch performance across 1M+ ERP records, consolidating 15+ manufacturing KPIs into a single reporting view.
• Build star-schema data models and 20+ DAX measures for MTD/YTD/YoY trend and variance analysis, giving leadership same-day visibility into plant performance.
• Develop Power Query and SQL-based ETL flows to extract and transform ERP data, adding validation checks that reduced data errors by around 35%.
• Apply Row-Level Security, drill-down, and scheduled refresh in Power BI Service, and optimize data models to cut dashboard load time by roughly 40%.

MIS Analyst – BI & Analytics at Himavasini Hyundai (2023-03 – 2025-03)

• Designed Power BI dashboards (Desktop & Service) for sales funnel, service performance, and workshop KPIs, integrating CRM and ERP data through Power Query with scheduled refresh.
• Built DAX measures for target vs. actual variance, conversion tracking, and sales forecasting to support monthly business reviews.
• Replaced manual Excel-based MIS reporting with Power BI dashboards, cutting reporting turnaround time by roughly 50% and improving consistency across departments.

MIS Analyst at Terex India Pvt. Ltd. (2018-06 – 2023-02)

• Built Power BI dashboards on star-schema data models for inventory management, supply chain tracking, and production analytic across multiple plants.
• Developed DAX measures for inventory turnover, stock ageing, and demand vs. supply analysis using SQL, MySQL, and Oracle ERP data sources.
• Automated recurring reports with Power Query and VBA macros, improving report generation speed by around 40% and giving teams real-time stock visibility.

Operations Executive – MIS & Logistics Reporting at PRM Roadways (2016-07 – 2018-05)

• Managed daily and monthly MIS reporting for logistics KPIs, shipment tracking, and operational performance across multiple data sources.
• Built structured reporting frameworks to monitor delivery SLAs and operational efficiency, providing data-driven insights to management.

Bachelor of Arts in English – Muthurangam Government Arts & Science College (2012 – 2015)