Ashutosh Mishra

About Ashutosh Mishra

Power BI Developer with 5 years of experience delivering end-to-end BI & Data Analytics solutions in Insurance and Banking. Expert in Power BI, DAX, Power Query (M), Power Pivot and SQL Server; proficient with Joins, CTEs, Window Functions and Stored Procedures. Hands-on with Azure Data Factory (ADF), Snowflake, Microsoft Fabric and Alteryx for ETL; Python for data analysis and Tableau for visualization. Built automated pipelines integrating Excel, APIs and diverse sources - reduced report generation time by 40% and analysis time by 30%. Designed optimized data models, implemented RLS, incremental refresh, DirectQuery/Import modes, performance tuning and anomaly detection to ensure compliance and zero breaches. Led dashboard deployments, saving 5 hrs/week and improving operational efficiency by 15-25%. Skilled in Power Platform (Power Automate, Power Apps), BI project scoping, stakeholder requirement gathering, root-cause analysis, data warehousing, KPI monitoring and data governance.• Power BI Development: Desktop, Service, Power Query, Advanced reporting, dashboarding, DAX and data modeling• Data Visualization: Interactive dashboards, executive reports, KPI tracking, trend analysis• SQL Server: T-SQL, Joins, CTEs, Windows Function, and views for query optimization• ETL: Pipeline design, data transformation, automated workflows, data warehousing using Microsoft Fabric dataflows• Programming & Automation: Python scripting, Power Automate, process optimization• Row-Level Security (RLS): Implementation in Power BI for data governance, compliance, and data security• Advanced Excel: Pivot tables, Power Query, VLOOKUP, INDEX/MATCH, advanced formulas• Business Intelligence: Requirements gathering, data modeling, governance protocols, stakeholder management

Experience

1. Senior Power Bi Developer - Assistant Manager - Bi Consultant (Us Insurance Domain)

   EXL

   Jun 2023 — Present · Gurugram, IN

   Specialize in delivering end-to-end Business Intelligence (BI) and Data Analytics solutions leveraging the Microsoft Azure ecosystem. I design, develop, and deploy Power BI dashboards, DAX measures, SQL-based data models, and ETL pipelines to drive insurance analytics, KPI reporting, and executive-level insights.1. Power BI Development & Data Visualization: Designed and implemented enterprise-grade Power BI dashboards and reports with advanced DAX calculations, data modeling, row-level security (RLS), and embedded analytics, reducing reporting time by 40% and improving decision-making efficiency.2. Azure Data Platform & ETL: Automated data pipelines using Azure Data Factory, Azure Databricks, Microsoft Fabric, and Azure Synapse Analytics, integrating 10+ data sources into a centralized Azure SQL Data Warehouse. Optimized ETL processes cut processing times by 30%, enabling real-time analytics for insurance claims, underwriting, and policy reporting.3. SQL & Data Engineering: Developed optimized SQL queries, stored procedures, views, and window functions to handle high-volume data sets, boosting reporting accuracy and scalability for large-scale BI systems.4. Python Automation: Built Python scripts for data cleansing, anomaly detection, and workflow automation, reducing manual effort by 30% and improving data quality.5. Compliance: Implemented RLS, and security protocols ensuring 100% compliance, zero breaches, and audit readiness.6. Led a team of 4–5 BI consultants in dashboard development, stakeholder engagement, and KPI definition, improving client reporting efficiency by 25%. Conducted 15+ Power BI training workshops for 200+ users, driving 30% higher adoption.Core Expertise: Power BI, DAX, SQL, Azure Data Factory, Azure Synapse, Azure Databricks, Microsoft Fabric, Data Modeling, ETL Pipelines, Data Warehousing, Python Automation, Insurance Analytics, KPI Reporting, RLS, Dashboard Development, Business Intelligence, Stakeholder Management.

Education

• Galgotias University

  Bachelor of Technology, Computer Engineering

• Kendriya Vidyalaya

  Secondary Education

  2012 — 2013

• Galgotias University

  Bachelor of Technology, Computer Software and Engineering Specialisation in Cloud Computing and Virtualization

  2016 — 2020

• Kendriya Vidyalaya

  Senior Secondary Education

  2014 — 2015