Learn Data Skills
Beta
Pumpy Sarkar

Pumpy Sarkar

Business Analyst

IIT Kanpur

Technologies

My Portfolio Highlights

My New Track

Spreadsheet Fundamentals

My New Course

Introduction to Python

My New Track

Spreadsheet Fundamentals

Data wizard, conjuring insights from the depths of complex datasets.

My Work

Take a look at my latest work.

DataLab

questions and ans

DataLab

Untitled Python workspace

DataLab

Project

DataLab

questions and ans

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Intermediate SQL
Joining Data in SQL

My Work Experience

Where I've interned and worked during my career.

Yes2Growh | Jun 2023 - Sep 2023

Project Associate

Conducted comprehensive Market Research to gain insights into customer needs, preferences, and current industry trends for ETF Junction. Analyzed Competitor Products to identify opportunities for differentiation and potential areas for improvement. • Collaborated with Managers to develop and maintain the Product Roadmap. Proposed new features by utilizing findings from Market Research that aligns with customer demands • Evaluated the potential impact of different functionalities, and enhancements by mapping User Journey and JBTD Framework • Prioritized the product functionalities and tools based on their alignment with the product strategy and goal of onboarding 1K investors to add SIP within a stipulated period of 45-60 days. • Utilized Product Performance Metrics, user feedback, and usage data to identify opportunities for product improvement and Optimized the User Experience based on the insights gathered from the analysis
Show More

Clicflyer | Nov 2022 - Feb 2023

Data Analyst

Consumer Behaviors Analysis – KSA National Day • Filtered the data for the last week of Sep’22 in order to analyze the engagement on Promotion Flyers of National Day theme • Performed a comprehensive engagement analysis of approximately 266K monthly offers in a wide range of categories, subcategories, Items, and products using SQL subqueries, Joins and Advanced Excel • Analyzed the Clickstream Data of 200 million events per month on the Clicflyer App, collated actionable insights using BigQuery and multiple visualization tools covering consumer buying behaviour and purchase propensity Data Extraction & Manipulation • Fetched Product and Packunit data of Gulf Corporation Council with different SKUs of the last 2 years, refined data to retain 0.5K unique combinations of Product and Packunit from 1.5K using Excel Lookup, If-else functions, and Pivot Table • Reduced the combinations to 33% of the total, and increased the efficiency of Data Entry team with an accuracy of more than 95% Dashboarding and Reporting • Created dashboards to track MAU, WAU, and DAU of 1.5Mn new users of ME Countries on the Clicflyer App by using CLICDATA • Worked on the Internal dashboard and kept a record of live Clicflyer Search Results having a total search text count of 0.7 million

Iim Lucknow | May 2016 - Jun 2016

Intern

Worked in a team of 5 to reconstruct the pricing model of Ludhiana City Buses with the objective of increasing profits • Maximized the operating profit and return on capital by raising bus tariffs, fares aiming for minimum or zero loss of existing customers, identified avenues to generate revenue through non-transport activities • Reduced Break-Even Period by increasing return on capital from 1.9% to at least 4%

My Education

Take a look at my formal education

BTech in Metallurgy IIT Kanpur | 2020

About Me

Pumpy Sarkar

Pumpy hasn't filled in a bio text

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free