Swathi Gowtham

Power BI Developer with 7 years of overall IT experience, including 5 years of relevant experience delivering enterprise BI solutions using Power BI Desktop, Power BI Service, SQL, DAX, and Power Query. Skilled in data modeling, ETL, dashboard development, Row-Level Security, scheduled refresh, and performance optimization, with a proven ability to deliver scalable, high-performing solutions.

Power BI Developer - Amtex Software Solutions Pvt. Ltd.

(2019-08)

Overall Experience: 7 Years | Relevant Power BI Experience: 5 Years

• Conducted requirement gathering and business analysis sessions with stakeholders to translate business needs into scalable Power BI dashboard solutions.
• Designed and developed interactive dashboards using Power BI Desktop, publishing and managing them through Power BI Service for enterprise-wide consumption.
• Built paginated reports using Power BI Report Builder for structured, print-ready operational and executive reporting.
• Authored advanced DAX measures, calculated columns, and time-intelligence functions to support business reporting and analytical decision-making.
• Developed SQL-based backend logic and built ETL workflows using Power Query, implementing query folding to improve refresh performance.
• Designed dimensional data models using star schema and snowflake schema methodologies with well-defined fact and dimension tables.
• Wrote and optimized complex SQL queries against SQL Server, improving data extraction accuracy and overall query performance.
• Integrated Power BI with Microsoft Azure, SharePoint, and Snowflake for cloud-based data modeling and centralized enterprise reporting.
• Configured Row-Level Security (RLS) to enforce role-based, secure data access across all deployed reports.
• Set up scheduled refresh and incremental refresh strategies, and configured On-Premises Data Gateway connectivity for secure hybrid data access.
• Optimized report and dashboard performance through DAX tuning, data model restructuring, and SQL query optimization, while performing data validation and UAT prior to sign-off.
• Managed report deployment and production support across environments, following Agile methodology with sprint planning, stakeholder communication, and documentation.

Bachelor of Engineering - ECE - K. S. R. College of Engineering (2010-08 - 2014-09)