Power Bi Sql Server

CHANDRA KANTH DANDE

****************@*****.*** 331-***-****

PROFESSIONAL SUMMARY

SQL / Power BI Developer with over 5 years of IT experience in database design, development, ETL processes, data modelling, and business intelligence (BI) solutions. Proven expertise in Microsoft SQL Server (2016–2021), SSIS, SSRS, SSAS, Power BI and Tableau for building reports, dashboards, and data visualizations. Strong experience in data collection, data analytics, and data science, with a solid foundation in relational databases such as SQL Server and Oracle. Proficient in advanced T-SQL, DAX programming, and performance tuning for scalable BI solutions. Skilled in writing optimized queries and designing interactive reports and semantic models in Power BI. Experienced in Python and R programming, enhancing capabilities in analytics and statistical modelling.

Hands-on with Azure Data Services, including Azure SQL, Data Factory, and cloud migration strategies. Adept at transforming business requirements into technical solutions that drive strategic decisions through impactful insights. Collaborative, detail-oriented, and committed to continuous improvement in data-driven environments.

EDUCATION

MBA in Management Information Systems

Concordia University Wisconsin, Mequon, WI

TECHNICAL SKILLS

• Databases: SQL Server 2021/2019/2017/2016, Azure SQL, Oracle 11g, MySQL

• Cloud Platforms: Microsoft Azure (Data Factory, Synapse, Data Lake, Azure SQL)

• ETL Tools: SSIS, Azure Data Factory (ADF)

• Reporting & Visualization: Power BI (Service, Desktop, Gateway), SSRS, Tableau, Report Builder

• Languages: T-SQL, DAX, MDX, Python, R, C#, LINQ, Shell Scripting

• OLAP & Modeling: SSAS (Tabular & Multidimensional), Power BI Dataflows, Star/Snowflake Schemas

• DevOps & Source Control: Azure DevOps, Git, TFS, Visual Studio

• Monitoring/Utilities: SQL Profiler, Performance Monitor, Query Store, SQL CMD

• Operating Systems: Windows Server 2022/2019, Linux (basic)

• Methodologies: Agile, Scrum, SDLC, CI/CD

PROFESSIONAL EXPERIENCE

SQL / Power BI Developer

Liberty Mutual Insurance, Boston, MA — July 2024 to Present

• Built enterprise dashboards in Power BI using DAX and Power Query across Azure SQL and on-premises data sources.

• Created complex SSIS packages with enhanced error handling and logging using Event Handlers and Expressions.

• Developed and deployed Power BI Reports to Power BI Service, using dataflows, paginated reports, and Row-Level Security (RLS).

• Worked with Azure Synapse for large-scale data warehousing and analysis using serverless SQL pools.

• Utilized Power BI Gateway for scheduled data refresh from on-prem SQL to Power BI services.

• Designed SSAS tabular models with calculated columns and measures using DAX.

• Enhanced performance of T-SQL queries and managed indexes using Query Store and Execution Plans.

• Collaborated with data scientists for predictive modeling and advanced analytics.

• Automated deployment pipelines using Azure DevOps (YAML CI/CD pipelines). Environment: SQL Server 2021/2019, Azure SQL, Power BI Service, SSIS, SSAS, Azure Synapse, Power BI Gateway, Git, Azure DevOps

SQL BI Developer

Wipro, India — July 2020 to Jan 2023

• Developed SSIS packages with advanced control flow, logging, and checkpointing for fault- tolerant ETL.

• Built Power BI dashboards incorporating Bookmarks, Drillthrough, and Smart Narrative features.

• Migrated legacy reports from SSRS to Power BI and enhanced visual storytelling through Power BI features.

• Utilized Azure Data Factory pipelines for orchestrating ETL flows from Blob Storage and SQL to Azure SQL.

• Performed data modeling using star/snowflake schema for optimized BI performance. Environment: SQL Server 2019/2017, Power BI, SSIS, SSRS, ADF, Git, Azure SQL Server BI Developer

Accenture, India — May 2018 to June 2020

• Designed and deployed SSAS multidimensional cubes and tabular models.

• Created detailed operational and executive dashboards in Tableau and Power BI.

• Automated ETL flows using SSIS to load data from legacy systems into the data warehouse.

• Developed parameterized SSRS reports with drill-down features and data export options.

• Created optimized indexes and materialized views for improved report performance. Environment: SQL Server 2016/2017, SSAS, SSIS, SSRS, Tableau, Power BI

Contact this candidate