Somnath Sutar

Data & Reporting Analyst with 3.7 years of experience creating Power BI dashboards, MIS reports, and automated reporting solutions using SQL, Power Query, DAX, and Advanced Excel. I've built dashboards for operational and spend/cost KPIs that reduced manual reporting by up to 30% and improved decision-making speed. My work includes data extraction, validation, and modelling in MS SQL Server and Snowflake, along with reporting support using SAP data.

I enjoy working with operations, marketing, and leadership teams to turn reporting requirements into practical, reusable dashboards.

Power BI Analyst at Godrej Properties (2026-02 – Present)

• Managed Annual Operating Plan (AOP) tracking for the Administration function by developing Power BI and Excel reports to compare planned versus actual performance, identify variances and support leadership reporting.
• Designed and maintained an attendance dashboard consolidating data for 1,300+ employees across all regions, automating multi-region attendance MIS reporting.
• Collaborated with the SAP team on the SAP HANA data model to source, extract, and validate reporting data, maintaining consistency between SAP and downstream Power BI dashboards
• Partnered with the Procurement team to develop procurement and spend reporting dashboards, converting procurement data into KPI views that improved cost tracking and supported decision-making.

Data Analyst at Swiggy (2025-01 – 2026-02)

• Built and automated scalable Power BI dashboards integrated with Snowflake, reducing manual reporting efforts by approximately 30% and improving reporting efficiency for Operations and Marketing teams.
• Designed real-time operational dashboards to monitor critical KPIs, including delivery efficiency, order accuracy, and operational performance, enabling data-driven decision-making for leadership
• Developed and optimized SQL and Snowflake queries to extract, transform, and validate data from 10M+ record datasets, supporting accurate and reliable daily and weekly reporting.
• Created reusable DAX measures and Power Query (M) transformations to develop dynamic, month-aware data models, minimizing manual formula updates and improving dashboard scalability.

Data Analyst at Vision India Tech Service (2023-12 – 2025-01)

• Developed interactive Power BI reports and dashboards to support strategic and operational decision-making, reducing report generation time by approximately 40% through reporting automation.
• Managed and processed large datasets using MySQL and Excel, performing data validation, quality checks and reconciliation to ensure data accuracy and integrity for business intelligence and reporting.
• Automated recurring Excel reporting processes using Power Query and VBA macros, eliminating repetitive manual tasks and saving 5+ hours of manual effort per week.
• Collaborated with business stakeholders to gather reporting requirements and translate business needs into scalable Power BI data models, leveraging Power Query and DAX for data transformation, calculations and analytics.

MIS Executive at Vaibhav Tech Solution (2022-12 – 2023-12)

• Developed and maintained 15+ MIS reports, streamlining business operations and improving data accuracy.
• Reduced reporting discrepancies by ~25% through data cleansing, validation, and trend analysis in Advanced Excel.
• Automated repetitive reporting tasks with Excel macros and formulas, improving reporting efficiency and turnaround.
• Built Power BI dashboards visualizing key performance metrics to improve business insights and reporting.

Master Program in Data Science – Simplilearn (2022-02 – 2023-10)

Bachelor of Commerce in Commerce – Savitribai Phule Pune University (2018 – 2021)

Diploma in Automobile Engineering – Pimpri Chinchwad Polytechnic (2012 – 2014)