Dhrumin Panchal

Business Analyst and Business Intelligence Professional with 2.6+ years of experience delivering Power BI, Tableau, SQL, Databricks, and Snowflake-based analytics solutions across Pharma, Retail, FMCG, Healthcare, and Operations domains. Experienced in developing interactive dashboards, automating reporting workflows using Power Automate, performing data modeling and transformation, and collaborating with stakeholders to translate business requirements into actionable insights. Microsoft PL-300 certified with a strong focus on business intelligence, data visualization, and data-driven decision-making.

Business Analyst – BI at Innovatics Solutions Pvt. Ltd. (2024-01 – Present)

• Delivered 10+ BI dashboards across Retail, Pharma, Healthcare, FMCG, and Operations domains, enabling centralized KPI monitoring and improved stakeholder reporting visibility.
• Developed complex DAX measures, KPIs, drill-through reports, and interactive visualizations to support business performance monitoring and stakeholder reporting requirements.
• Designed and deployed 3+ Power Automate workflows for scheduled file synchronization, automated monthly Excel report generation, and SharePoint integration — eliminating manual intervention across 2+ reporting cycles.
• Utilized SQL across Databricks and Snowflake environments for data extraction, transformation, validation, and reporting dataset preparation.
• Collaborated closely with business stakeholders to gather reporting requirements, define and validate KPIs, and iterate on dashboards to ensure alignment with business objectives.
• Performed data cleaning, transformation, and modeling using Power Query to optimize dashboard performance and data accuracy.

Business Intelligence Analyst Intern at Innovatics Solutions Pvt. Ltd. (2023-05 – 2023-06)

• Developed a Retail Inventory Management Dashboard enabling inventory monitoring, stock movement analysis, ABC-XYZ segmentation, and stock-out identification across product categories.
• Designed interactive filters, slicers, and drill-down capabilities for product-level inventory insights and stock-out analysis.
• Integrated Power Automate workflows with Power BI for automated inventory reporting and operational monitoring.

MBA in Business Intelligence – B.K. School of Professional and Management Studies, Ahmedabad (2022 – 2024)

Bachelor of Commerce in Commerce – Shree Shahjanand Commerce College, Ahmedabad (2019 – 2022)