Mihir Singh Chauhan | Data / Business Analyst

Technical Skills

Python (Pandas, NumPy), SQL (SQL Server, SQLite)

Power BI (DAX), Tableau, Excel Dashboards, Matplotlib, Seaborn

Data Cleaning, EDA, KPI Reporting, Flask (Web Apps)

Financial Reporting, Inventory Management, Operations Analytics

Python, Flask, SQLite

Live Project

Architected a Flask-based web application to automate SKU tracking and sales analytics, replacing manual logs and improving data integrity by 90%.
Built structured datasets for historical sales analysis and real-time stock visibility.
Automated billing and daily sales reporting to reduce manual entry errors.

Power BI, SQL, DAX

Completed

Engineered a Power BI analytics suite with DAX measures (Total Revenue, Weekly Revenue, WoW Growth) for transaction performance tracking.
Analyzed revenue, interest income, and customer demographics to identify high-value segments.
Designed executive-ready dashboards with slicers for week, card category, income group, and gender.

Tableau

Completed

Developed an interactive Tableau dashboard analyzing member attendance, calories burned, and workout frequency.
Created calculated fields to measure engagement levels and identify fitness improvement trends.
Designed visualizations with filters and drill-down capabilities for performance monitoring.

Microsoft Excel

Completed

Designed a dynamic Excel dashboard with KPIs, slicers, and year-over-year sales and profit analysis.
Automated reporting workflows using advanced Pivot Tables, reducing manual reporting time by 40%.

Customer Operations Analyst (Non-Voice)

Mumbai Sep 2023 – Jul 2025

Reviewed high-volume customer interaction data to deliver accurate resolutions, maintaining a 95% quality accuracy score.
Identified recurring complaint patterns using data analysis to improve resolution turnaround time.
Delivered data-backed insights contributing to a 15% increase in CSAT scores.

Accounts & Operations Analyst

Mumbai Apr 2023 – Sep 2023

Managed daily financial and inventory data with 99% accuracy in monthly reporting.
Used Excel-based analysis to track costs and revenues, identifying opportunities that led to 10% operational savings.

Bachelor of Accounting and Finance (BAF)

HSC (Commerce)

SSC

Leadership: Organized a 25+ participant Cyclothon; served as a Trekking Guide for local regional expeditions.

Interests: Quantitative fitness tracking, data visualization trends, and endurance cycling.