PRANAY BHASIN

[email protected] • +91-9811644926 • Pitampura, New Delhi

PROFESSIONAL SUMMARY

• Worked under the profile of Data Analyst • Analyzed sales trends, customer preferences, and inventory data to optimize product offerings • Used tools like SQL and Excel to extract and clean large datasets, ensuring data accuracy for decision-making • Created Power BI dashboards to visualize fashion trends and sales performance to enhance clarity • Conducted market research to identify top-selling fashion categories • Automated reports to track customer engagement and product demand, reducing manual effort by 7%

WORK EXPERIENCE

Intern
05/2024 - 12/2024
H.P Fashions , Delhi
• Worked under the profile of Data Analyst
• Analyzed sales trends, customer preferences, and inventory data to optimize product offerings
• Used tools like SQL and Excel to extract and clean large datasets, ensuring data accuracy for decision-making
• Created Power BI dashboards to visualize fashion trends and sales performance to enhance clarity
• Conducted market research to identify top-selling fashion categories
• Automated reports to track customer engagement and product demand, reducing manual effort by 7%
Intern
05/2025 - 07/2025
HOUSE OF MARKTECH
• Selected among top 50 from 14,000+ applicants for a high-performance internship at India’s fastest-growing marketing-tech startup
• Analyzed platform-wise lead quality and built conversion dashboards using Excel & Google Sheets
• Developed HR KPI frameworks and dashboard planning layouts (India, UAE, US, Europe)
• Led market research for PR/CRM feature wishlist and localization strategy
• Cleaned and segmented large-scale lead datasets for outreach targeting
• Designed and submitted all reporting, documentation, and handover materials independently

EDUCATION

BCA
01/2021 - 01/2024
Institute of Information Technology & Management, Delhi GPA: 7.2
CBSE, Commerce
01/2007 - 01/2021
Bal Bharati Public School, Delhi

SKILLS

PROJECTS

Sentiment Analysis
Technologies: Python, Pandas, NumPy, NLP, Machine Learning
• Engineered a sentiment analysis model using natural language processing (NLP) techniques, achieving 90% accuracy in predicting customer sentiment on social media platforms
• Conducted data mining and analysis to identify trends, patterns, and anomalies in large datasets
• Utilized statistical methods and machine learning algorithms to build predictive models and optimize business processes
• Leveraged Python libraries (Pandas, NumPy) for statistical analysis and machine learning, resulting in improved data insights and predictive modelling.​
Dashboarding Project using Power BI
Technologies: Power BI, DAX
• Visualized e-commerce data: Analyzed sales, customer demographics, and product performance
• Enhanced decision-making: Achieved a 20% increase in sales forecast accuracy
• Data processing: Utilized DAX expressions to clean and preprocess data, reducing reporting time by 30%

CERTIFICATIONS

Data Analytics
01/2025
Techgyan IIT Delhi
Data Science
01/2023
Mood Indigo IIT Bombay