I am a data analyst with 4+ years of experience in SQL, Power BI, Python, Advanced Excel, and AWS, focused on sales operations analytics, BI dashboards, and automated reporting. I partner with stakeholders to turn complex data into actionable insights that drive retention, reduce churn, and grow revenue. In my roles, I enjoy delivering KPI-driven business intelligence and empowering teams with clear, data-backed decisions. I thrive in collaborative environments and take pride in building user-friendly dashboards that enable quick, reliable decision-making. My goal is to continuously improve data quality and analytical processes while aligning analytics deliverables with business objectives.…

Ashwani Mahur

I am a data analyst with 4+ years of experience in SQL, Power BI, Python, Advanced Excel, and AWS, focused on sales operations analytics, BI dashboards, and automated reporting. I partner with stakeholders to turn complex data into actionable insights that drive retention, reduce churn, and grow revenue. In my roles, I enjoy delivering KPI-driven business intelligence and empowering teams with clear, data-backed decisions. I thrive in collaborative environments and take pride in building user-friendly dashboards that enable quick, reliable decision-making. My goal is to continuously improve data quality and analytical processes while aligning analytics deliverables with business objectives.…

Available to hire

I am a data analyst with 4+ years of experience in SQL, Power BI, Python, Advanced Excel, and AWS, focused on sales operations analytics, BI dashboards, and automated reporting. I partner with stakeholders to turn complex data into actionable insights that drive retention, reduce churn, and grow revenue. In my roles, I enjoy delivering KPI-driven business intelligence and empowering teams with clear, data-backed decisions.

I thrive in collaborative environments and take pride in building user-friendly dashboards that enable quick, reliable decision-making. My goal is to continuously improve data quality and analytical processes while aligning analytics deliverables with business objectives.

See more

Skills

Experience Level

Power BI
Expert
SQL
Expert
Microsoft Excel
Expert
AWS
Expert
Python
Expert
Data Visualization
Intermediate

Language

English
Fluent

Work Experience

Business Intelligence Analyst at SmartBrain Technologies Pvt. Ltd
November 1, 2024 - December 1, 2025
Delivered CEO-level reporting through automated Power BI dashboards with scheduled data refreshes. Designed and maintained daily performance dashboards to monitor team productivity, OKRs, and PMO metrics. Developed advanced DAX measures (CALCULATE, SUMX, FILTER, VAR), What-If parameters, bookmarks, and drill-through, reducing analysis time by 20%. Served as Functional Lead, managing a team of 7 analysts, overseeing dashboard delivery, data accuracy, and stakeholder communication. Analyzed large datasets to generate actionable insights, contributing to a 5% reduction in customer churn. Created KPI-driven dashboards for quick and actionable business insights.
Data Analyst at Vcare Credits Pvt. Ltd
December 1, 2021 - August 1, 2024
Built a comprehensive ACP performance dashboard in Power BI during the wind-down phase. Designed advanced DAX KPIs (CALCULATE, SUMX, FILTER, VAR) to analyze CLV, churn rate, service tenure, and adoption trends. Executed end-to-end ETL processes using SQL and Power Query, including schema mapping, null handling, and calculated column creation. Developed analytics-ready datasets using CTEs, joins, window functions, and aggregations. Presented executive-level insights on geographic enrollment trends and service utilization, supporting strategic decision-making.
Associate – Technical Support at Concentrix
June 1, 2021 - October 1, 2021
Maintained accurate CRM case documentation and performance metrics while supporting Apple iPhone and iMac users. Followed SOPs and QA standards to ensure data accuracy, compliance, and reporting quality.
Technical Support Engineer I at Energizer
June 1, 2019 - September 1, 2020
Logged and tracked technical issues in CRM systems, ensuring structured data capture and reporting consistency while supporting Samsung phones users. Adhered to SOPs and QA processes to maintain high-quality operational data.

Education

B.Tech in Mechanical Engineering at Vivekanand Institute of Technology & Science
January 11, 2030 - January 1, 2018

Qualifications

Add your qualifications or awards here.

Industry Experience

Software & Internet, Professional Services, Financial Services, Retail, Media & Entertainment
    paper Financial Complaint Dashboard

    This project transforms 75,000+ financial complaint records spanning nearly a decadehttps://www.twine.net/signin) into a comprehensive Power BI dashboard. The analysis reveals key operational metrics, seasonal trends, geographic patterns, and product-specific insights to support data-driven decision-making in the financial services sector.

    Key Performance Indicators (KPIs)
    Total Complaints: 75,074
    Timely Response Rate: 98.05%
    In Progress Cases: 280
    Disputed Rate: 9.71%
    Resolved at No Cost: 84.50%

    🔍 Key Insights
    Operational Performance
    ✅ 98.05% timely response rate demonstrates strong operational efficiency ✅ 84.50% no-cost resolution indicates effective customer service ⚠️ 9.71% dispute rate suggests areas for quality improvement

    Complaint Drivers
    📌 Account management issues are the #1 complaint category (6.1K) 📌 Deposits and withdrawals tie as a top concern (6.1K) 📌 Payment processing troubles rank third (3.5K)

    Product Analysis
    💳 Credit cards generate the most complaints (19K) - high transaction volume 🏠 Mortgages are second (12K) - complexity and long-term nature 🏦 Checking/Savings accounts are third (13K) - everyday banking issues

    Temporal Patterns
    📈 Complaint volume peaks in May (7.1K) - potential tax season correlation 📉 Steady decline toward year-end - seasonal staffing implications 📊 Average monthly complaints: ~6.3K

    Geographic Distribution
    🗺️ North America concentration - US market dominance 🎯 State-level hotspots visible - regional targeting opportunities