Back to Developers
Dinesh Dhiman

Dinesh Dhiman

Data Analyst

Kangra, HP 0+ yrs exp 82 ยท Excellent

About

Data Analyst with hands-on experience turning large, messy datasets into business-ready insights using SQL, Python, Pandas, and Tableau. Built end-to-end analytics pipelines across customer intelligence, retail revenue, and multilingual NLP research, delivering interactive dashboards and identifying actionable customer and revenue segments. Strong foundation in advanced SQL (CTEs, window functions, RFM/cohort analysis) and AI-assisted analytics, with a track record of independently owning projects from raw data to stakeholder-ready visualization.

Skills & Expertise (26)

Python Intermediate
6.5/10
1
Years Exp
SQL Intermediate
6.5/10
1
Years Exp
Data Cleaning Intermediate
6.0/10
1
Years Exp
Customer Segmentation Intermediate
6.0/10
1
Years Exp
Pandas Intermediate
6.0/10
1
Years Exp
Tableau Intermediate
6.0/10
1
Years Exp
NumPy Intermediate
5.5/10
1
Years Exp
Data Annotation Intermediate
5.5/10
1
Years Exp
Joins Intermediate
5.0/10
1
Years Exp
Jupyter Notebook Intermediate
5.0/10
1
Years Exp
Git Intermediate
5.0/10
1
Years Exp
AI-assisted Analytics Intermediate
5.0/10
1
Years Exp
AI-assisted research Intermediate
5.0/10
1
Years Exp
Prompt Engineering Intermediate
5.0/10
1
Years Exp
CASE Statements Intermediate
5.0/10
1
Years Exp
Aggregations Intermediate
5.0/10
1
Years Exp
Subqueries Intermediate
5.0/10
1
Years Exp
Window Functions Intermediate
5.0/10
1
Years Exp
CTEs Intermediate
5.0/10
1
Years Exp
MySql Intermediate
5.0/10
1
Years Exp
LLM Evaluation Cohort Analysis RFM Analysis GitHub EDA DBeaver

Work Experience

Data Analyst

GitHub

Apr 2026 - May 2026

Built an end-to-end retail analytics pipeline, cleaning and transforming raw transactional data with Pandas ahead of SQL and Tableau analysis. Used CTEs, Window Functions, Ranking Functions, and Percentage Contribution Analysis to pinpoint top- and bottom-performing regions, products, and salespeople. Delivered an executive Tableau dashboard surfacing revenue trends and product profitability, enabling faster, data-backed sales decisions.

Data Analyst

GitHub

Jan 2026 - Feb 2026

Analyzed 392,000+ transactions across 4,300+ customers using SQL and Python, uncovering purchasing behaviour and CLV trends to inform retention strategy. Applied RFM and Cohort Analysis using CTEs, Window Functions, and NTILE to segment customers into high-value, repeat, inactive, and at-risk groups โ€“ surfacing the customer base driving majority revenue. Built an interactive Tableau dashboard tracking repeat purchase rate, acquisition trends, and revenue contribution, giving stakeholders a self-serve view into retention KPIs.

Data Analyst

GitHub

Aug 2025 - May 2026

Built and structured a multilingual NLP dataset from Telegram data, enabling reliable LLM-based classification of Human Rights Violations across an 11,000-instance corpus. Personally annotated 6,000+ social-media posts (50%+ of the full dataset), improving ground-truth label reliability and directly supporting model training accuracy. Extended the project into a research work evaluating Mistral, Llama, and OpenHermes for multilingual Human Rights Violation classification, contributing to analysis and write-up alongside a cross-functional research team; helped author an accompanying research paper on the projectโ€™s findings.

Education

Bachelor of Technology, Computer Science - Jaypee University Of Information Technology

- 2026 ยท Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 7/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 82/100

Profile Overview

Member sinceSep 2026

Availability Details

Visa Status

Citizen

Relocation

Depends on Offer