Vikas SMG

Data Analyst

Bhopal, India 0+ yrs exp 87 · Excellent

About

Detail-oriented and analytical Data Analyst with 1 year of hands-on experience in data analytics and MIS reporting. Strong in SQL, Advanced Excel (formulas, pivot tables), Power BI, and Python for collecting, cleaning, validating, and analyzing data. Experienced in building dashboards, KPI reports, and automated recurring reports that turn raw data into clear, accurate, and actionable business insights, reducing manual reporting time by 60%.

Skills & Expertise (20)

Advanced Excel Advanced

7.3/10

Years Exp

Descriptive Analytics Intermediate

6.5/10

Years Exp

Business insight generation Intermediate

6.5/10

Years Exp

Data Accuracy Intermediate

6.5/10

Years Exp

Sales Analysis Intermediate

6.5/10

Years Exp

Report Automation Intermediate

6.5/10

Years Exp

Dashboard Development Intermediate

6.5/10

Years Exp

KPI Reporting Intermediate

6.5/10

Years Exp

MIS Reporting Intermediate

6.5/10

Years Exp

Trend Analysis Intermediate

6.5/10

Years Exp

Data Analysis Intermediate

6.5/10

Years Exp

Data Transformation Intermediate

6.5/10

Years Exp

Data Validation Intermediate

6.5/10

Years Exp

Data Cleaning Intermediate

6.5/10

Years Exp

SQL Intermediate

5.5/10

Years Exp

Data Visualization Intermediate

5.5/10

Years Exp

Power Query Intermediate

5.5/10

Years Exp

Power BI Intermediate

5.5/10

Years Exp

Python Intermediate

4.5/10

Years Exp

Generative AI Beginner

4.5/10

Years Exp

Work Experience

MIS Analyst

Shri Maa Group (SMG)

Nov 2025 - Present

Prepare daily, weekly, and monthly MIS and KPI reports covering sales, stock, outstanding, and invoice data using Advanced Excel (formulas, pivot tables), ensuring data accuracy and consistency for management review. Automated recurring reports using Excel formulas and Power Query, reducing manual report preparation time by 60% and streamlining the reporting workflow. Build and maintain a daily sales dashboard tracking MTD/FTD sales performance, product/model-wise performance, and employee-wise target vs. achievement, enabling real-time performance monitoring. Collect, clean, validate, and organize sales, stock, and operational data, check for inconsistencies, and analyze it using Excel and Power BI to identify trends, patterns, and actionable business insights.