Ankit Gawde

About Ankit Gawde

Business Intelligence Engineer with experience in designing scalable data solutions, automating workflows, and optimizing data models. At Walmart, I reduced data refresh times by 50% and query costs by 35% using XMLA partitioning and surrogate keys. I also implemented role-level and tab-level security, improving data governance by 40%.At Microsoft, I automated 65% of manual reporting with Python and Power Automate, saving 300+ hours annually and enhancing report accuracy by 30%. I delivered 50+ reports using Power BI and Tableau, driving a 40% improvement in decision-making speed.Technologies & Skills:Big Data: Google BigQuery, Spark, Hive, MapReduceCloud Services: Azure Data Factory, Azure Synapse, Azure Databricks, Azure DatalakeBI & Reporting Tools: Power BI, Tableau, SSRS, DAXProgramming: Python, R, SQLAutomation & Integration: Power Automate, Power Apps, Tabular EditorDatabases: Azure SQL, Snowflake, PostgreSQL, Microsoft SQL Server

Experience

1. Data Engineer

   Microsoft

   Mar 2025 — Present · Redmond, WA, US

   Built financial data pipelines in Microsoft Fabric and Spark to track Azure service unit costs as part of the One Finance Costing Initiative (OFCI), improving cost accuracy by 25%.Developed Azure Consumption Actuals vs Budget and VTF/VTB forecasting dashboards, reducing manual reporting by 30+ hours/month and accelerating budget variance detection by 20%.Created dynamic headcount and attrition cost dashboards using data from Workday and Active Directory, tracking 100+ open roles and Dev:PM ratios across 50+ teams, leading to a 10% improvement in workforce planning.Designed a centralized semantic model using Tabular Editor and calculation groups, improving report performance and version control across 5 business units.Automated data ingestion from flat files to structured models, decreasing refresh times by 40% and increasing reporting efficiency.Implemented data quality checks and anomaly detection across 20+ pipelines, reducing reporting issues by 40% and boosting stakeholder trust.Led training sessions for 50+ team members and stakeholders, increasing Power BI dashboard adoption by 35%.Managed a team of 3 analysts and delivered multiple cross-functional finance analytics projects on time.Partnered closely with finance, engineering, and operations teams to deliver solutions that improved decision-making and operational efficiency.

Education

• Washington State University Graduate School

  Master's degree, Computer Science

  2017 — 2019

• Thadomal Shahani Engineering College

  Bachelor's degree, Information Technology

  2013 — 2017