Skills & Expertise (18)
Work Experience
Product Analyst
Ninjacart
Nov 2024 - Present
Conducted RFM analysis on video content using SQL and Python across both content consumption and serving layers enabling identification of high-quality videos and leading to a 6.3% increase in viewer engagement and 2.7% increase in watch time. Designed and evaluated user journey funnels to uncover key drop-off points and bottlenecks; implemented data-driven optimizations that resulted in a 3.4% improvement in impressions. Automated bi-monthly Bureau Reporting process using Apache Airflow, streamlining data workflows and reducing manual reporting efforts by 40%, improving operational efficiency. Built a real-time KPI monitoring workflow using Apache Airflow to send automated emails 4 times per day, tracking the top 7 engagement and performance metrics — significantly improving stakeholder visibility and decision-making speed.
Data Analyst Intern
Quick Ride
May 2023 - Aug 2023
Analyzed taxi booking data using SQL and Power BI to develop and execute strategic, actionable insights, configuring day-wise hourly taxi optimal pricing, which resulted in an 11.8% increase in total bookings and a 7.3% increase in completion percentage. Investigated car booking data using Power BI, which identifies trends, anomalies, and opportunities, presents findings by easy-to-understand visual representations to stakeholders, and helps in business development.
Project Associate
Flipkart
Jun 2024 - Nov 2024
Tracked daily business performance and key metrics, ensuring timely updates and actionable insights for the team. Updated project trackers weekly with advanced Excel functions (VLOOKUP, COUNTIF, DATEDIF), managing over 3 ongoing projects and ensuring data quality and timely reporting. Fetched and compiled critical data on purchase orders (PO), including PO dates and amounts, utilizing SQL to populate detailed project sheets, processing over 170 POs weekly. Coordinated with stakeholders, resolved client queries efficiently through regular calls, maintaining over 75% resolution rate within the first call leading to a 20% improvement in project completion times and ensuring client satisfaction. Managed communication channels with stakeholders, providing timely updates and maintaining seamless project execution, contributing to a 12% enhanced project throughput and delivery speed and supporting process optimization.
Education
M. Tech [Infrastructure Management] - IIT Kharagpur
2022 - 2024 · Afghanistan
B. Tech [Civil Engineering] - Jalpaiguri Government Engineering College
2016 - 2020 · Afghanistan
