Rishav Vishwakarma

Having strong foundation in data analysis principles and passion for problem-solving. Bringing solid understanding of statistical methods and proficiency in analytical tools like Python, SQL and Excel. Ready to use and develop these skills in Data Analyst role, contributing to data-driven decision-making and continuous improvement.

Python for data science

Analyzing E-commerce Transactions: Data Cleaning, Cohort Analysis, and SQL

• Improved accuracy of dataset by removing over 12,000 duplicate records, while cohort analysis revealed a 25% retention rate after three months, Identified that 10% of customers contributed over 55% of revenue.
• Top 10% customer generated 55% of revenue and saturday is the peak day contributing 28% of transactions, suggested loyalty programs and perks for this segment of customers and targeted offers & campaigns on weekends.
• calculated the Average Order Value to be around 75$ per transaction , suggesting a benchmark for further upselling strategies.

Exploring Supply Chain Analytics SQL for Fashion: Exploring Supply Chain Analytics

• Inventory turnover increased by 30%, markdown sales reduced from 40% to 25%, top 10 products account for 60% of total revenue, reduced dead stock by 35%.
• Identified multiple optimization opportunities — resulting in potential cost savings of over $500K annually through improved inventory turnover, reduced stockouts, and optimized shipping logistics.

Smartphone Sales Analysis: From Data Cleanup to Complex SQL Interrogation

• Identified that Samsung led the market with a 35% share, contributing significantly to the total sales. Almost 22% are repeated customers. Further, stockouts caused an estimated $500,000 in lost revenue.
• Best performing month was November with almost 20% of annual sales, repeated customer purchase rate was around 22% and average discount given was around 10% per sale.
• Around 65% of the total products were sold online and rest 35% offline also 55% of transactions were made using digital wallets, further suggested a more focus on e-commerce platforms.