SHWETA SURYAWANSHI
Navi-Mumbai, India
Phone: 970-***-****
Email: *******************@*****.***
PROFESSIONAL SUMMARY
Dedicated Power BI Developer with a passion for transforming data into actionable insights. Proficient in data modelling, DAX creation, Power Query, report development, RLS, and interactive dashboard creation. Skilled in using Power Apps to build user-friendly applications and streamline workflows. Experienced in extracting, transforming, and visualizing data from diverse sources and integrating them seamlessly using SQL Server Management Studio (SSMS) to create optimized views and joins.
SKILLS
Microsoft Power BI (Desktop)
Power BI Services
Power BI Report Server
Power Query (M Language)
DAX (Data Analysis Expressions)
Data Modelling
RLS (Row Level Security)
Power BI Gateway
Microsoft Fabric
Data Visualization, Dynamic Dashboard
Report Publishing, Sharing and Schedule Refreshing.
Advanced Excel
SSMS (SQL)
ETL (Extract Transform & Load)
Basic Python (NumPy, Pandas, Matplotlib)
SharePoint & Microsoft Dynamics 365.
Power Automation.
Power Apps
PROFESSIONAL EXPERIENCE
Sr. Executive-Power BI
Mahindra Teqo, Apr 2025 – Present
Developed and maintained interactive dashboards for PR to PO tracking, vendor payables, and spend analysis using Power BI and data extracted from SAP.
Performed data transformations in Excel to support reporting needs, conducted data analysis to identify trends, inefficiencies, and cost-saving opportunities in procurement and vendor operations.
Maintained an issue tracking system to monitor data discrepancies and ensure timely resolution for continuous report accuracy.
Sr. Executive-Power BI
Pittie Group, Feb 2024 – Mar 2025
Dashboard Development: Designed and implemented interactive, dynamic dashboards as per user requirements and delivered clear and actionable insights to stakeholders.
Data Integration: Integrated data from Business Central, SQL databases, and Excel spreadsheets, enabling comprehensive, real-time reporting with seamless data flow.
Reporting Efficiency: Streamlined reporting processes with scheduled data refreshes and incremental refresh techniques, ensuring up-to-date and accurate reports with minimal latency.
Operational Efficiency: Enhanced business operations by implementing Row-Level Security (RLS) for data access control, optimizing key performance metric monitoring, and improving oversight and decision-making capabilities.
Performance Optimization: Applied optimization techniques to improve dashboard performance, such as reducing query complexity and utilizing Data Gateway for secure, high-performance data transfers, significantly enhancing load times and overall efficiency.
Power BI Developer
Nine A Business Connect Pvt Ltd, Nov 2022 – Jan 2024
Project Overview: Collaborated with Taj Group to develop Enterprise Finance DBR Dashboard, integrating data from 7 brands and over 200 hotels, providing comprehensive financial insights across the organization.
Dashboard Development: Created specialized dashboards like 'The Chambers' for IHCL and 'STR' for hotel comparisons, utilizing Power BI for interactive, user-friendly visualizations.
Data Integration: Used SSMS (SQL Server Management Studio) to integrate data from multiple sources, ensuring seamless and accurate data flow across the dashboards.
Automation: Implemented a Power BI button to automate the generation of financial statements and integrate with Power Automate to email unsettled amounts, reducing manual effort and improving operational efficiency.
Operational Efficiency: Enhanced data accessibility and reporting speed, allowing faster decision-making and streamlined communication across brands and hotels. EDUCATION
Master of Science in Mathematics
The Institute of Science Mumbai, 2019-2021
Bachelor of Science in Mathematics
University of Mumbai, 2016 - 2019
CERTIFICATIONS
Data Analysis & Business Intelligence, Udemy (UC-115e7d75-91c7-4cba-a969-8c3f6656c34f) December 2024
Power BI Certification, IT Vedant December 2023
PG course in Data Analytics, IT Vedant December 2023
Data Analysis with Python, IBM (0e0fe183dbb34da78b653c3ff6500220) September 2022
Yuva Home Tutor (Data Analyst Internship) November 2022
Elite Techno Groups (Nano degree program on Python master in data science Internship) December 2021 PROJECTS
DBR Report Indian Hotels Company (IHCL) Mumbai: Onsite Nov 2022 – Jan 2024 Develop detailed DBR Reports, utilizing data analysis techniques to summarize key performance indicators (KPIs) and trends, facilitating informed decision-making across the organization. Developed customer debt and hotel-wise aging reports, enabled financial statement downloads using Power Automate, and set up automated email notifications for unsettled amounts and aging debt.
HRMS Power App Indian Hotels Company (IHCL) Mumbai: Onsite Nov 2022 – Jan 2024 Developed an HRMS application using Power Apps to streamline employee data management, leave requests, and approval workflows. Integrated the app with SharePoint to provide real-time analytics and ensure seamless data synchronization.
Daily & Weekly Production Report Pittie Group Juinagar, Navi Mumbai Feb 2024 – Present Configured Power BI Service subscriptions to send daily emails detailing production data at Year-To-Date (YTD), Month-To-Date (MTD), and daily levels. Implemented a weekly scheduled refresh to provide a comprehensive weekly production analysis, ensuring stakeholders receive up-to-date insights
Sales Reports Pittie Group Juinagar, Navi Mumbai Feb 2024 – Present Developed reports for each brand (4) for PITTIE Group for yearly comparisons with the previous year, category-wise performance, top 10 products yearly trends, top 5 retailers' performance with year-over-year comparisons, and state-wise analysis to provide detailed insights across multiple dimensions.
GST Reports Pittie Group Juinagar, Navi Mumbai Feb 2024 – Present Developed GST reports with Standard format which is used globally for each brand (4) for PITTIE Group in Power BI, providing detailed insights on IGST, CGST, and SGST, enabling easy tracking of tax liabilities and compliance. Apart from these mentioned dashboards there are total 27 dashboard which has been created and developed