Power Bi Business Intelligence

PAYAL DILIP MURKUTE

Power BI Developer SQL Data Analytics Dashboard & Reporting Specialist

+91-750******* ****************@*****.*** www.linkedin.com/in/payal-murkute-b19b8b275 PROFILE

Result-driven Business Intelligence Specialist with 4+ years of experience in Power BI Development, SQL Server, Data Warehousing, and data-driven decision-making. Strong background in Data Modeling, DAX, ETL processes, and dashboard optimization. Proven track record in reports migration, stakeholder collaboration, and cloud data analysis. Adept at delivering scalable, interactive dashboards that support business KPIs, with flexibility to work in onshore-offshore collaboration.

EXPERIENCE

Nimbja Security Solutions Pvt. Ltd. Client: TCS Pune,India PowerBi developer 07/2022 – Present

• Performed ETL processes from multiple data sources, ensuring data accuracy and reliability.

• Created and maintained efficient data models with robust validation and data-cleaning processes.

• Developed dashboards and KPIs in Power BI and SQL to deliver business insights.

• Designed and implemented key business dashboards for:

• Prepaid activation (daily/weekly/monthly) across PAN India (23 Circles)

• Post-paid activation/deactivation across PAN India

• MNP activation/deactivation with different slabs

• P2P (Pre to Post, Post to Pre, Pre to Pre, Post to Post)

• Self P2P activation/deactivation

• eKYC, dKYC, sKYC, Paper-based activation

• IOIT, RED Family Activation

Tools & Technologies: Power BI Desktop, Power BI Service, DAX, Power Query, SQL, Excel, Azure Synapse, Dataflows, APIs, Gateways, Git, Jira, Confluence

Penta Software Solution Pvt ltd Pune, India

SQL Production Support 2019 - 2022

• Delivered 24/7 SQL support for high-volume transactional systems.

• Developed and optimized complex SQL queries, stored procedures, and functions for BI teams.

• Ensured data accuracy and supported data migration, replication, and performance tuning tasks.

• Monitored and maintained SQL Server databases with backups, indexing, and troubleshooting. EDUCATION

Kalinga University Raipur Raipur, India

B.Tech in Computer Science Engineering 2015 – 2019

• SGPA :6.91/10

• Relevant coursework : Data Visualization, Data Analysis SKILLS

Data Visualization

Power BI, Tableau, DAX, Custom Visuals, Power BI Service, KPI Scorecards, Dashboard Performance Optimization, Power Query, AWS, Data Analysis & Processing

ETL, Data Modeling, Data Cleansing, Data Structuring, SQL Stored Procedures, Views, Indexing SQL

SQL Query Writing & Optimization,Stored Procedures, Triggers and Views, Database Monitoring & Troubleshooting, Backup & Recovery Processes, Data Migration & Replication, Knowledge of RDBMS (SQL Server, MySQL, Oracle), Communication & Issue Escalation Handling

Soft Skills

Analytical Thinking, Data Communication, Stakeholder Management, Collaboration,Issue Resolution CERTIFICATIONS

• Data Analytics Specialization – June’24

• Master In PowerBI

PROJECTS

CPOS (Central point of sales)

• Developed and maintained Power BI dashboards for customer acquisition (Prepaid, Postpaid, KYC types) across 23 telecom circles.

• Integrated data from SQL, Azure Synapse, APIs, and Excel; performed data modeling, DAX calculations, and Power Query transformations.

• Implemented Row-Level Security (RLS), configured data gateways, and managed reports in Power BI Service.

• Conducted data quality checks, optimized report performance, and provided user support and issue resolution.

• Collaborated with business teams for requirement gathering and documentation via Jira, Confluence, and MS Teams.

• Reduced dashboard load time by 50% through optimization techniques and minimized redundant queries.

• Enabled location-wise RLS filters, improving secure data access across 12+ regions.

• Tracked over 100K customer acquisition records, empowering regional managers with actionable KPIs. Insurance Analytics

• Designed and delivered interactive dashboards to track key insurance metrics such as Claim Settlement Ratio, Loss Ratio, Policy Renewal Rate, and Premium Collection Trends.

• Developed a scalable data model integrating policy, claims, and underwriting data sources.

• Created fraud detection visuals to highlight anomalies and high-risk claims.

• Enabled Role-Level Security (RLS) for region-wise access across branch offices.

• Collaborated with underwriters and claims teams to convert requirements into insightful visual reports.

• Improved report performance by 50% through DAX and Power Query optimization.

• Built customer segmentation dashboards to support personalized communication and upselling strategies. Sales Analysis

• Designed an interactive dashboard to track key metrics like total sales, quantity sold, and customer ratings.

• Visualized sales trends by month, mobile model, city, and payment method using Power BI.

• Enabled stakeholders to gain actionable insights for improving sales strategies and customer experience.

• Enabled product and category segmentation that supported a 15% improvement in inventory decisions.

Contact this candidate