Anil S Kamble
Power BI Developer
DSK Ranwara Society, Pune, India 411021
****************@*****.***
PROFILE SUMMARY
Experienced Power BI Developer with 3 years’ expertise delivering business intelligence solutions via dashboard design, data modelling, and ETL processes using DAX, Power Query, and SQL Server. Adept at translating business requirements into actionable analytics, optimizing performance, and implementing Row-Level Security (RLS). Proficient with stakeholder collaboration, cross-functional reporting, and data integration for insurance, healthcare, and retail domains
TECHNICAL SKILLS
Programming Languages: MS SQL BI Tools: Power BI (Desktop & Service), SSIS, Excel, DAX, Power Query Database: SQL Server, Azure SQL Database, SharePoint Data Modelling: Star Schema, Normalization, Relationships, Role-Level Security ETL Development: SSIS, Power Query, SQL-based ETL workflows, data gateways Version Control & Deployment: Power BI Deployment Pipeline, Workspace Management Familiar With: Microsoft Fabric, Jira, Performance Analyzer
EXPERIENCE
Innover Infotech Pvt. Ltd.
Power BI Developer
Pune
April 2023–Present
Design and develop robust Power BI dashboards and interactive reports to enable business intelligence and actionable insights.
Translate business requirements into effective data models and reporting mechanisms using Power BI Desktop, DAX, and Power Query.
Perform data extraction, transformation, and loading (ETL) using SQL Server, SSIS, and Azure Data Factory for integration of complex, multi-source data sets.
Implement data warehouse solutions and optimize star schema or snowflake data modelling for scalable analytics.
Configure Row-Level Security (RLS), workspace permissions, and On-premises Data Gateway for secure data access and scheduled refreshes.
Optimize Power BI performance by leveraging Performance Analyzer and best practice techniques for efficient report rendering.
Lead cross-functional collaboration with business stakeholders to gather reporting requirements, define KPIs, and formulate technical specifications.
Validate and document data sources, transformation logic, and report specifications to ensure data quality and consistency.
Stay updated with latest Power BI features and industry trends to implement innovative visualization and BI solutions.
Collect, clean, and analyze data from diverse sources—databases, spreadsheets, APIs—using SQL, Excel, and Python for actionable insights.
Develop reports and dashboards, ensuring stakeholder visibility into trends, patterns, and outliers for strategic decision-making.
Perform complex data analysis using statistical techniques, DAX functions, and visualization tools, providing executive summaries and business recommendations.
Automate data processes for efficient extraction, transformation, and data scraping with scripts/tools in Python, R, or Power Query.
Maintain and manage databases, ensuring data integrity and security with regular updates and troubleshooting.
Collaborate across business functions to specify data requirements, manage master data, and support advanced analytics projects.
Communicate findings through compelling visualizations, charts, and client-ready dashboards, supporting decision-making across business units.
Project: Insurance Analytics Dashboard/Report
Environment: Power BI, SQL Server, DAX, Power Query, Excel, Azure, SharePoint
Designed BI dashboards to track customer behavior, claim trends, policy performance, and regional sales across SQL/SharePoint/SSIS data sources; enabled data-driven strategy in marketing and customer retention.
Project: Sales Analytics Dashboard/Report
Environment: Power BI, SQL Server, Excel, DAX, Power Query, SharePoint
Designed BI dashboards to track customer behavior, claim trends, policy performance, and regional sales across SQL/SharePoint/SSIS data sources; enabled data-driven strategy in marketing and customer retention.
Allied Market Research Pune
Power BI Developer October 2022 – March 2023
Conducted market research and built Excel-based datasets, then developed Power BI Dashboards for market size, CAGR, and KPI visualization for Healthcare, ICT, Automotive, Food & Beverage, Consumer Goods, Energy & Power verticals.
Integrated and transformed multiple sources (D&B Hoovers, Capital IQ, Bloomberg) into dynamic interactive dashboards for client presentations and strategic insights.
Delivered drill-down analytics from global to company segment levels supporting go-to-market and investment planning.
Collect and analyze quantitative and qualitative data using methodologies such as surveys, focus groups, and secondary sources, then integrate findings with Power BI dashboards for deeper business insights.
Interpret market trends and consumer behavior by leveraging data analysis techniques in Power BI, DAX, and SQL, delivering actionable recommendations for marketing and sales strategies.
Visualize competitive intelligence and research outcomes through interactive reports, charts, and presentations in Power BI to support decision-making across teams.
Prepare and communicate research findings using data-driven narratives and visuals, transforming complex market data into clear, strategic business reports and stakeholder presentations.
Research Analyst February 2020 – September 2022
Conducted market research and built Excel-based datasets, then developed Power BI Dashboards for market size, CAGR, and KPI visualization for Healthcare, ICT, Automotive, Food & Beverage, Consumer Goods, Energy & Power verticals.
Integrated and transformed multiple sources (D&B Hoovers, Capital IQ, Bloomberg) into dynamic interactive dashboards for client presentations and strategic insights.
Delivered drill-down analytics from global to company segment levels supporting go-to-market and investment planning.
EDUCATION
MIT School of Management
Master of Business Administration (Marketing)
Pune
2016-2018
Dr. DY Patil College of Business Management Pune
Bachelor of Business Administration (Marketing) 2011-2016