DUSHYANT RAGHAV (Data Analyst)
(Available for Immediate Joining)
@dushyantraghav33@gmail.com | Ph. +91 9711074725 | Add. Sohna Road, Gurugram
PROFILE SUMMARY
B.Tech Fresher with 6-month training certificate along with 1-year of internship in Data Science from
CTC data science training institute in Gurgaon with advance technologies like Tableau, Power BI,
MYSQL Server, Alteryx, Advanced Excel, Python and SAS.
Experience in utilizing SQL Server to create Tableau and Power BI dashboards, KPIs, calculated fields,
filters, sets, hierarchies, groups and parameters.
Created workflows using Alteryx with advance transformations like cross tab, multi row, dynamic
renaming, transpose etc.
Expert in creating DAX (Data Analysis Expressions) in Power BI, demonstrating strong aptitude for
deriving significant insights and patterns from intricate datasets.
TECHNICAL SKILLS
Languages : SQL Server,Python
Data Visualization : Tableau,Power BI
Other Tools : Alteryx,Excel
INTERNSHIP
Certification in Data Science from CTC data science training institute in Gurgaon. The training
consists of different courses like Excel, Tableau, Power BI, SQL Server, Alteryx, Advance excel,
SAS, Python etc. along with 1 year of internship in Data science from CTC data science training
institute, Gurgaon. Duration of internship (July 2023- June 2024).
EDUCATION
Bachelors in Technology (computer science) from GD Goenka University. (2016-2020)
Class 12th Vidya Niketan Sr. Sec. School, Gurgaon. (2014-2016)
PROJECTS:
Demand Analysis- Cluster Model
Client: Retail
Role: Data Modeler and Visualization expert
Major Responsibilities: Project Management
For a US based client identified the location for new service plants to be opened basis the
demand data available with Latitude and Longitude.
Targeted to meet 80% demand in 2 transit day.
Generated demand centric clusters using K- Mean cluster in R.
Environment: SQL Server, Excel , Tableau.
Retail Store Network
Project in brief: The Objective of this model was to recognize and define network of stores in the
given territory and thereby understanding cross-shopping behavior of customers across various
store formats.
Steps Taken:
• Identified the cross shopping of the customer between two stores to solve the out of
stock condition.
• Then developed a distance matrix of all stores using % of cross shopping as a
parameter to decide closeness between stores.
• Created Clusters based on distance matrix calculate various other attributes like
weekly spend, basket size, % of unique customers at store level and analyses them on
each cluster.
Environment: Python, Tableau.
PERSONAL DETAILS
Name Dushyant Raghav
Date of Birth 15-Oct-1997
Father's Name Mr.Satish Raghav
Mother's Name Mrs.Mamta Raghav
Gender Male
Marital Status Single
Language Known English, Hindi