SUMMARY
Data Analyst with expertise in transforming complex datasets into actionable insights. Proficient in Python, SQL, Power BI, and advanced Excel, with hands-on experience in machine learning techniques including predictive modeling and time series forecasting. Demonstrated ability to develop interactive dashboards, perform statistical analysis, and implement data-driven solutions that enhance business performance. Strong background in marketing analytics, customer segmentation, and trend analysis across e-commerce, retail, and logistics domains. Passionate about leveraging data visualization to communicate findings effectively and drive strategic decision-making. Committed to continuous learning and applying innovative analytical approaches to solve real-world business challenges.
EDUCATION
MBA in MARKETING & FINANCE
EXPERIENCE
HARYANA INSTITUTE OF INFORMATION TECHNOLOGY
- Gained hands-on experience in data analytics by working with tools such as Python, SQL, Power BI, and Excel to collect, clean, and analyze data.
- Developed interactive dashboards and reports to evaluate student performance and track key business metrics like revenue, profit, and customer growth.
- Extracted actionable insights to support data-driven decisions that helped improve company performance and customer engagement.
- Worked on HTML and web hosting to understand the basics of website structure and deployment.
- Learned how to secure files and databases using FileZilla, including setting up FTP accounts for safe and organized data transfer.
- Gained exposure to domain management and hosting processes, including how to handle website files securely and ensure proper access control.
- Collaborated with the team to track KPIs and optimize reporting structure for better business visibility.
PROJECTS
- Analyzed cellphone sales data using SQL queries. Identified customer behavior, geographical trends, and product performance.
- Extracted insights on top-selling models, manufacturers, and high-value customers over multiple years.
- Identified and segmented high-value customers by analyzing purchasing patterns, enabling tailored marketing strategies to boost retention and lifetime value.
Analytical tool: Excel, SQL
- The project aimed to leverage data analytics, using Power BI, to analyze player statistics and strategize cricket team selection.
- Formed cricket team capable of scoring average of 180 runs in batting innings and defending a total of 150 runs.
- Selection process prioritized player statistics, aligned the team's objectives of achieving target run-scoring and run defense.
Analytical tool: Excel, Python, Power BI
- Conducted comprehensive marketing analytics for an e-commerce marketplace company in India.
- Analyzed sales data to identify seasonal trends, customer retention rates, and payment preferences.
- Implemented a revenue-based segmentation model for customers and sellers; tailored marketing campaigns that resulted in a 30% increase in customer retention and a 20% rise in seller engagement
- Identified popular products, categories, customer satisfaction metrics to inform product development and marketing strategies.
Analytical tool: Python
- Demonstrated a 99% match between actual and predicted gold prices through effective visualization techniques.
- Identified popular products, categories, customer satisfaction metrics to inform product development & marketing strategies.
- Provided valuable insights for stakeholders in the gold market, leveraging data-driven approaches for decision-making.
Analytical tool: ML Regression Model
- Used three types of data -- industry, store, and environment.
- Focused on showing engagement levels by location (state/city).
- Combined all the data to make one complete view.
- Created interactive maps in Power BI to show insights clearly.
Analytical tool: Power BI
SKILLS
Libraries & Frameworks
- Pandas
- NumPy
- Matplotlib
- Seaborn
- Scikit-learn
Machine Learning
- Predictive Modelling
- Regression (linear)
- Classification (Logistic Regression)
- Segmentation (RFM, K Means)
- Forecasting: (Time Series – Average, Decomposition, ETS models, ARIMA)
Data Analysis & Visualization
- Data Exploratory Analysis
- Visualization
- Creation of Dashboards & Reports
- Data Preparation
Statistics Methods & Techniques
- Basic Statistics
- Z/T-test
- ANOVA
- Correlations
CERTIFICATIONS
Web Development Diploma
DATA ANALYST Course
National Cadet Corps (NCC)
WAC National Volleyball (2018 & 2019)
