Divesh Singh

Data Analyst

Delhi, India 2+ yrs exp 84 · Excellent

About

Data Analyst with hands-on proficiency in SQL, Python, Power BI, and Excel, specializing in data cleaning, statistical analysis, data visualization, and dashboard reporting. Transitioning from a business and financial-operations background (MBA, Branch Sales Manager) into analytics, having built end-to-end SQL-to-dashboard projects covering data cleaning, customer segmentation, and KPI monitoring. Comfortable presenting findings to both technical and non-technical stakeholders, with a consultative approach to solving business problems through data.

Skills & Expertise (32)

Excel Advanced

8.0/10

Years Exp

Advanced Excel Advanced

8.0/10

Years Exp

VLOOKUP Advanced

7.0/10

Years Exp

Pivot Tables Advanced

7.0/10

Years Exp

SQL Intermediate

6.5/10

Years Exp

Power BI Intermediate

6.5/10

Years Exp

Dashboard Development Intermediate

6.5/10

Years Exp

KPI Reporting Intermediate

6.5/10

Years Exp

MS Office Suite Intermediate

6.0/10

Years Exp

Charts Intermediate

6.0/10

Years Exp

Power Query Intermediate

6.0/10

Years Exp

Aggregations Intermediate

6.0/10

Years Exp

Joins Intermediate

6.0/10

Years Exp

Data Storytelling Intermediate

5.5/10

Years Exp

Python Intermediate

5.5/10

Years Exp

Financial Analysis Intermediate

5.5/10

Years Exp

Statistical Analysis Intermediate

5.5/10

Years Exp

Subqueries Intermediate

5.5/10

Years Exp

Matplotlib Intermediate

5.0/10

Years Exp

NumPy Intermediate

5.0/10

Years Exp

Pandas Intermediate

5.0/10

Years Exp

Problem Solving Intermediate

5.0/10

Years Exp

Tally ERP Intermediate

5.0/10

Years Exp

CTEs Intermediate

5.0/10

Years Exp

Seaborn Intermediate

4.5/10

Years Exp

Supply Chain Management Intermediate

4.5/10

Years Exp

Sales Strategy Intermediate

4.5/10

Years Exp

Client Relationship Management Intermediate

4.0/10

Years Exp

Team Leadership Intermediate

4.0/10

Years Exp

Strategic Planning Intermediate

4.0/10

Years Exp

Cross-Functional Collaboration Intermediate

4.0/10

Years Exp

Microsoft Power BI

Work Experience

Branch Sales Manager

Piramal Finance

Jan 2024 - Jan 2025

Built Excel-based KPI dashboards to track a team of 4 sales executives, driving 100% average achievement of monthly targets. Analyzed regional sales data in Excel to design data-backed strategies, expanding market presence across Gurugram. Built recurring Excel reports to track portfolio quality metrics across accounts, ensuring 100% compliance with organisational and regulatory policies. Analyzed client and channel-partner data to identify growth opportunities, driving a 20% increase in branch revenue across 100+ relationships.

Sales Intern

Hindustan Times

Jan 2023 - Jan 2023

Tracked campaign performance data to test and refine promotion strategies, hitting 80% of assigned door-to-door sales targets. Analyzed customer feedback trends to strengthen relationships with 20+ households, driving repeat business and brand loyalty.

Accountant

GTS Logistics

Jan 2021 - Jan 2022

Processed and reconciled 50+ monthly shipment billing transactions in Tally ERP and Excel, maintaining 100% accuracy. Automated billing and reporting workflows using Excel formulas and templates, cutting manual data-entry errors by 30% and reducing turnaround time. Compiled and analysed monthly, quarterly, and annual financial statements in Excel, delivering data-driven insights for management decision-making. Streamlined financial reporting processes using Excel automation, reducing report delivery time by 25%.