Power BI & SQL Data Analytics Specialist

RAHUL HANWATE

Pune, India +91-892******* *****.*******@*****.*** LinkedIn

BI Tools & Platforms: Microsoft Power BI Desktop, Power BI Service, Power Query (M Language), DAX Databases & Languages: SQL (T-SQL), SQL Server Management Studio (SSMS) Data Modeling: Star Schema, Snowflake Schema, Relationship Management, Performance Optimization DAX & Analysis: Calculated Columns & Measures, Time Intelligence (TOTALYTD,SAMEPERIODLASTYEAR), Filter Context, KPI Development

Data Integration & ETL: Power Query, Data Transformation, Scheduled Data Refresh Other Technologies: Microsoft Excel (Advanced PivotTables, Formulas), SharePoint, Agile/Scrum Methodology Service Now REST API

Power BI Developer Bahwan CyberTek, Mumbai (Jan 2026 – Present) Designed and enhanced interactive dashboards and reports using Power BI Desktop to support business decision- making.

Created data models by integrating multiple data sources such as SQL Server, Excel, and cloud platforms. Developed complex DAX calculations (measures, calculated columns, KPIs) for advanced analytics and reporting. Performed data transformation and cleansing using Power Query (M language). Implemented row-level security (RLS) and ensured data governance best practices. Optimized report performance by improving data models, relationships, and query efficiency. Published and managed reports on Power BI Service, including workspace management and access control. Collaborated with business stakeholders to gather requirements and translate them into technical solutions. Scheduled data refreshes and monitored report performance in Power BI Service. Established drill-through, drill-down, and dynamic filtering features for enhanced user experience. BI Analyst MachBizz Pvt Ltd, Pune (Sept 2020 – Feb 2025) Designed and enhanced over 15 interactive Power BI dashboards and reports from scratch, serving 100+ users across Sales, Marketing, and Finance departments. Engineered robust data models by extracting and transforming data from multiple sources including SQL Server, Excel, and SharePoint lists using Power Query, improving data refresh reliability by 30%. Authored complex DAX formulas and measures to create calculated columns, KPIs, and time-intelligence metrics for YoY growth, quarter-to-date (QTD), and running totals. Automated manual reporting processes by setting up scheduled data refreshes in the Power BI Service, reducing manual effort by 15 hours per week.

Collaborated with business stakeholders to gather requirements, present prototypes, and incorporate feedback into final deliverables, ensuring alignment with business objectives. Optimized report performance by refining data models and DAX calculations, decreasing average dashboard load time by 40%.

Results-driven and analytical Power BI Developer with 3.2 years of experience designing, developing, and deploying interactive business intelligence solutions. Proficient in transforming complex data from diverse sources into actionable insights through advanced data modeling, DAX, and compelling visualizations. Proven ability to collaborate with cross- functional teams to understand business requirements and deliver dashboards that drive data-informed decision-making and improve operational efficiency. Seeking to leverage my skills to contribute to the success of a forward-thinking organization

CoreSkills

Profile Summary

Professional Experience

Bachelor of Engineering (Computer Science) Nagpur

Institute of Technology, Nagpur 2011 – 2016

Data Analyst Course With Azure, AI & Co Pilot - Basic To Advance Increased customer engagement by 30% via data-driven marketing campaigns. Improved lead conversion rates by 20% using CRM workflows. Delivered actionable insights through dashboards that influenced C-level decisions Objective: To measure the effectiveness and return on investment of various marketing campaigns. Actions: Integrated data from Google Analytics API and Salesforce using Power Query; created visualizations to compare cost-per-lead and customer acquisition cost across different channels. Result: Provided clear insights that helped reallocate $50,000 of marketing budget to the highest- performing channels, increasing overall campaign ROI by 18%. Process Associate Wipro, Pune (Feb 2017 – July 2017) Handled queries via calls and emails for Telstra (Australian telecom client) ensuring timely and accurate resolutions.

Performed troubleshooting for telecom services including broadband, mobile, and fixed line issues. Objective: To provide sales leadership with a unified view of regional performance, sales pipeline health, and achievement against targets.

Actions: Connected to Azure SQL Database; built a star-schema data model; developed key DAX measures for YTD Sales, Sales Growth %, and Conversion Rate; implemented drill-through pages for detailed transaction analysis.

Result: Enabled managers to identify underperforming regions quickly, leading to a 10% increase in sales in targeted areas within one quarter.

Education

Key Projects

Certificate

Achievements

•MarketingCampaignAnalysis Domain : Marketing

• Sales Performance Management Dashboard Domain : Retail

•

•

•

Contact this candidate