Karan Sonawane

About Karan Sonawane

Hi! Thank you for coming here.I have 3+ years of hands-on experience in Power BI reporting, data modeling, and SQL development.Specialized in validating and testing real-world BI scenarios for analytics.Proficient in Power BI Desktop & Service with bookmarks, tooltips, drill-through, and custom navigation.Skilled in creating dynamic KPIs, DAX measures, and Power Query transformations.Simulated enterprise-grade RLS, ETL flows, and publishing workflows using real datasets.Command over SQL, including Joins, CTEs, Stored procedures, and Window functions.What I Bring:Power BI Desktop & Service: Visual storytelling, bookmarks, custom views, drill-throughDAX & Power Query: KPI logic, calculated columns, M scriptingData Modeling: Fact-dimension schema, RLS, governance, incremental refreshSQL Development: Advanced querying, Joins, Stored procedures, CTEs, Window functionsTools: Power BI Desktop and ServiceSQL ServerMySQLETL pipelinesMS ExcelAzure Data Factory Azure DataBricks SharepointPower Apps and Power AutomateGitHubVS Code PythonCurrently, I’m looking to apply my technical foundation to a full-time Data Analyst or Power BI Developer role, where I can contribute to real-world data challenges, learn from industry teams, and grow continuously in the BI space.Let’s connect and talk about data analytics, BI strategies, and automation!

Experience

1. Senior Technical Editor

   Packt

   Jul 2022 — Present · Mumbai, IN

   Conducted in-depth validation of technical content and hands-on testing of Power BI dashboards, SQL scripts, and Python code featured in analytics publications- Designed and tested interactive Power BI dashboards with bookmarks, synced slicers, tooltips, and button navigation to simulate business reporting use cases- Executed DAX measures, calculated columns, and Power Query transformations to verify metrics, KPIs, and modeling logic- Validated SQL queries involving JOINs, CTEs, stored procedures, and window functions to ensure accurate data retrieval and analysis- Used Python for data analytics, using powerful libraries such as NumPy, Pandas, and Matplotlib to efficiently process, analyze, and visualize data, ultimately accelerating insights generation and improving reporting accuracy- Built and tested ETL-like data pipelines using Power Query and Python (Pandas, NumPy), working with REST APIs, flat files, and SQL Server data- Simulated enterprise scenarios for row-level security, data governance, and Power BI Service publishing to ensure content aligned with professional standards- Documented data models, query logic, and visual features to support content clarity, reusability, and maintainability- Collaborated with cross-functional teams including authors, developers, and editors to maintain technical accuracy and stakeholder alignment.

Education

• Bharati Vidyapeeth Institute of Technology

  Diploma, Electronics and Telecommunication Engineering

  2011 — 2014

• Ramrao Adik Institute of Technology

  Bachelor of Engineering (BE), Electronics and Telecommunications Engineering

  2014 — 2017