Power Bi Customer Engagement

RAHUL HANWATE

Pune, India +91-892******* *****.*******@*****.*** LinkedIn GitHub Portfolio Bachelor of Engineering (Computer Science)

Nagpur Institute of Technology, Nagpur 2011 – 2016 Achievements

Increased customer engagement by 30% via data-driven marketing campaigns. Delivered actionable insights through dashboards that influenced C-level decisions. Planned and executed multiple data-driven marketing campaigns, boosting customer engagement by 30%. Designed and optimized campaigns with CRM tools, achieving a 20% improvement in lead conversions. Zepto Analysis (SQL Project) Link

uncove risk profiling & customer behavior patterns. Marketing Campaign Analysis (Power BI) Link – Built dashboards to track KPIs, conversion rates & ROI for campaigns.

Shopify Sales Analysis (Power BI) Link

improving insights into customer lifetime value.

Retail Store Sales Analysis (SQL) Link– Optimized sales operations with SQL queries & reporting for customer experience improvement.

Link – Designed ER performance dashboard to track wait times, patient flow & KPIs.

•

•

•

•

•

•

•

•

Education

•

•

•

Research Analyst Excelsior Research, Pune (Mar 2019 – Sept 2020)

– sales data, identifying top-performing categories & Improved lead conversion rates by 20% using CRM workflows. Data Analytics: SQL, MySQL, Power BI, DAX, Power Query, Excel (VLOOKUP, Pivot Tables, Advanced Formulas, ETL)

Business Intelligence: Dashboarding, Data Modeling, KPI Tracking, Reporting Data Management: Data Cleaning, Data Transformation, Data Storytelling Tools: Power BI Service, Power BI Desktop, CRM, GitHub Domain Expertise: Marketing Analytics, Sales Analytics, Market Research Designed Power BI dashboards to track campaign performance (Leads, MQL SQL conversions, ROI), Wrote SQL queries (joins, window functions) to extract, clean, and analyze customer & campaign data Conducted data analysis & visualization for 10+ marketing campaigns, identifying top-performing channels Hospital Analysis (Excel Dashboard)

improvements in lead conversion and customer engagement. Marketing Research Analyst MachBizz Pvt Ltd, Pune (Sept 2020 – Feb 2025) Results-driven Data Analyst specializing in Marketing Analytics and Business Intelligence. Proficient in end-to-end data processes - from extraction and transformation in SQL and Power Query to building impactful visualizations in Power BI. Demonstrated success in optimizing marketing campaigns and sales strategies, directly contributing to significant Profile Summary

•

•

•

•

•

Professional Experience

•

•

•

Core Skills

reducing manual reporting time by 30%.

from multiple sources (CRM, LinkedIn, Apollo, D&B Hoovers). and boosting lead conversion by 15%.

Link – Exploratory Data Analysis and risk profiling Predicting

– Conducted exploratory analysis on e-commerce inventory dataset to TATA Power BI Virtual Internship (Forage)

Delinquency with AI. Business report and data storytelling for collections strategy Implementing an AI-Driven collection strategy.

Collected and processed raw Excel data to build analytical reports that supported strategic decision-making.

•

Key Projects

Contact this candidate