Ishan Malhara

About Ishan Malhara

I am a Microsoft Certified Sr. Power BI Developer (DP-600 | PL-300 | PL-900) with 4+ years of experience turning raw data into actionable insights that help organizations make smarter, faster decisions.I specialize in the Microsoft BI and Azure ecosystem — including Power BI, Microsoft Fabric, Azure SQL, Azure Data Factory (ADF), DAX, Power Query, and ETL pipelines. My strength lies in building scalable semantic models, high-performing dashboards, and seamless data integrations that bring clarity to complex datasets.Problems I Solve:Slow, inconsistent, or fragmented reporting → I streamline data flows with optimized queries and ETL pipelines.Lack of clarity for decision-makers → I design intuitive dashboards that surface insights in real time.Data accessibility challenges → I implement row-level security, Power BI alerts, and automation to ensure the right people get the right data at the right time.Why I’m Valuable:I bridge the gap between business needs and technical solutions, ensuring every BI project drives measurable impact. My work has consistently improved reporting efficiency, reduced load times by up to 40%, and increased stakeholder satisfaction through tailored BI solutions.I’m passionate about helping organizations unlock the full potential of their data by combining technical expertise with business understanding. My goal is simple: to enable truly data-driven decision-making that fuels growth and innovation.

Experience

1. Senior Associate - Data Infrastructure

   Advaiya Solutions, Inc

   Jan 2024 — Present · Udaipur, IN

   Developed a unified global semantic model used as a single data source across multiple Power BI reports, ensuring 100% data consistency and improving reporting efficiency by 30%.Implemented real-time Power BI alerts to monitor KPIs and notify stakeholders of critical changes, enhancing decision-making speed and operational efficiency by 25%.Configured Microsoft Fabric Data Agent with custom instructions and example queries, accelerating data discovery and access to insights by 40% across teams.Automated integration of dynamic logos in reports based on site and customer selection, raising personalization and brand alignment by 40%.Built dynamic Power Query parameters enabling users to segment data flexibly, increasing report usability and user satisfaction.Optimized complex queries through advanced query folding and DAX techniques, reducing report load times by 40% and improving performance.Led stakeholder sessions to gather requirements and translate them into aligned technical specifications for Power BI reports.Created Power Automate workflows to trigger email notifications on Power BI alerts, improving user awareness and responsiveness by 50%.Managed project backlogs using JIRA and tracked delivery through Azure DevOps to ensure smooth, on-time BI solution deployment.Developed localized Power BI reports with multi-language support for Polish, German, Spanish, and Brazilian markets.Implemented dynamic titles for report visuals, improving update efficiency and boosting performance by 25%.Migrated Power BI datasets and reports from version 3.0 to 4.0, enhancing report accuracy, cleaning data, and optimizing performance.Executed SQL scripts to automate promotion of fields across Development, Acceptance, and Production environments, ensuring data consistency and reliability.

Education

• Techno India NJR Institute Of Technology

  B.Tech, Information Technology

  2015 — 2019