Kajal kathave
Power BI Developer DAX Power Query Data Modeling SQL
Power BI Developer with 4+ years of experience building end-to-end BI solutions for Smart City, Energy, and Military Infrastructure projects. Skilled in designing interactive dashboards, optimizing data models, and delivering business insights using Power BI, DAX, Power Query, and SQL. Adept at transforming raw data into actionable KPIs and automating reporting workflows. Experienced in stakeholder collaboration, mobile report optimization, RLS implementation, and data visualization best practices. ************.**@*****.*** 959-***-**** Pune, India linkedin.com/in/kajal-kathave-52b6321a6 WORK EXPERIENCE
Power BI Developer
Recktronic Devices and Systems, Pune
03/2021 - 02/2025,
Built 15+ dynamic dashboards for Energy, Smart City, and Military Monitoring Projects, improving operational reporting by 40%..
Partnered with business teams to define KPIs and reporting needs, translating them into scalable BI solutions Created advanced DAX measures (YTD, conditional KPIs, dynamic filters) and implemented drill-through pages and bookmarks
Designed and optimized data models (star schema), reducing data refresh time by 30%.
Integrated Google Sheets as a data source synced from SQL Server for near-real-time visibility.
Delivered stakeholder-ready mobile views and scheduled refresh using Power BI Service.
Implemented Row-Level Security for user-specific access control and secure data distribution.
Design Engineer
RDS
02/2018 - 03/2021,
Developed SCADA graphics and panel wiring diagrams using AutoCAD for industrial control systems
EDUCATION
Bachelor of Engineering
G.H. Raisoni College of Engineering and
Management, Amravati 2017
Diploma in Engineering
Government Polytechnic, Arvi 2015
SKILLS
Business Intelligence: Power BI (Desktop, Service & Mobile), Row-Level Security, Bookmarks, Drill-throughs, Dashboards
Data Modeling: Star Schema, Relationships, KPIs,
Measures, Calculated Columns Transformation
Tools: Power Query (M), Power Pivot, Merge, Append, Incremental Refresh
DAX Functions: CALCULATE, SUMX, FILTER, SWITCH, Time Intelligence (YTD, MTD, QTD)
Data Sources: SQL Server, Excel, Google Sheets (linked) Visualization Techniques: Matrix, Cards, Slicers, Custom Visuals, Tooltips
PROJECTS
Bhopal Energy Monitoring Project
Tools: Power BI, Power Query, SQL Server, Google Sheets Connected Power BI to Google Sheets linked from SQL for semi- real-time updates.
Built mobile-optimized dashboards with drill-through and bookmarks for water and energy monitoring.
Defined complex DAX measures and set up incremental refresh for performance optimization.
Vadodara & Solapur,Goa Smart City Projects
Analyzed IoT flowmeter and energy sensor data to optimize water distribution and pump usage.
Designed dashboards to monitor pump efficiency, valve operations, and energy consumption patterns.
Enabled predictive maintenance by visualizing consumption and operational anomalies.
CERTIFICATIONS
Create DAX Calculations in Semantic Models -
Microsoft, Issued Jul 2025
LANGUAGES
English, Hindi, Marathi
Full Professional Proficiency
Achievements/Tasks
Achievements/Tasks