Palash Rai

Business Analyst

Gurugram, Haryana, India4 yrs 5 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Proven track record in data-driven decision making.
Expert in building impactful dashboards for business growth.
Strong analytical skills with a focus on performance marketing.

Stackforce AI infers this person is a Data Analyst specializing in E-commerce and Business Intelligence.

Contact

Skills

Core Skills

Data AnalyticsPerformance MarketingBusiness Analysis

Other Skills

Microsoft ExcelData VisualizationPython (Programming Language)Organization SkillsMarket ResearchSQLStrategic AnalysisMarketing StrategyData AnalysisAnalytic Problem SolvingCreative ThinkingAmazon RedshiftStakeholder ManagementData-driven Decision MakingGitHub

About

Palash is a results-oriented Data Analyst with 4+ years of experience leveraging data analytics to drive strategic decision-making and business growth in the D2C domain. Adept at transforming complex datasets into actionable insights, Palash excels in using SQL, Python, Microsoft Excel, and data visualization tools to build impactful dashboards and optimize processes. He has a proven track record of working with large-scale data, writing SQL queries, and delivering end-to-end data solutions that support business growth and innovation. Currently at Blinkit, Palash applies his expertise in Data Analytics and Business Intelligence to support the Category Management, Marketing, and Monetization teams. With a strong foundation in data analytics, he is passionate about using data to unlock opportunities and drive business growth. Palash holds an Integrated Master of Technology in Electronics and Communication Engineering from Jaypee Institute of Information Technology, Noida, and is committed to continuous learning and development in the field of data analytics. Let’s connect if you're interested in leveraging data to fuel business insights or if you're seeking collaboration on innovative data projects.

Experience

4 yrs 5 mos

Total Experience

2 yrs 2 mos

Average Tenure

3 yrs 4 mos

Current Experience

Blinkit

Analyst - Category Monetisation

Jan 2023 – Present · 3 yrs 4 mos

Created and implemented real-time dashboards to track key metrics, enabling the team to make data-driven decisions, resulting in a 13% CMGR improvement in overall ad revenue through optimised campaign performance.
Led in-depth analysis of search ads performance, helping the team identify underperforming keywords and optimise bidding strategies, leading to significant improvements in CPM, RPS (Revenue per Search), and overall ad engagement.
Enabled the team to strategically optimise campaigns during peak festive seasons by analysing high-performing keywords and categories, resulting in a 3-4x increase in RPS and driving substantial revenue growth during key events like Diwali, Rakhi, Christmas, and others.
Conducted detailed customer segmentation and cohort analysis, uncovering valuable insights into user retention and behaviour. This enabled more targeted marketing strategies, resulting in increased customer engagement and conversions.
Facilitated real-time tracking of festive campaign performance through dynamic dashboards, showcasing metrics like Impressions, CTR, Conversion Rates, GMV, and Share of Voice (SOV). This enhanced visibility empowered teams to make quick, data-driven decisions, optimising campaigns in real-time for maximum impact during peak seasons and ensuring agile responses to market dynamics and user behaviour.
Delivered comprehensive reports tracking sales, revenue, market share, category growth, and Share of Voice (SOV), while collaborating with cross-functional teams to align on growth strategies. Provided actionable insights that drove incremental revenue and ensured campaigns were consistently optimised for business success.

Microsoft ExcelData VisualizationPerformance MarketingData AnalyticsPython (Programming Language)Organization Skills+13

Magicpin

Business Analyst

Dec 2021 – Jan 2023 · 1 yr 1 mo

Developed and maintained automated dashboards and trackers for monitoring KPIs,leading to the quicker discovery of problems and insights.
Regressively measure and track key business metrics, including order volume, cancellations, recovery, revenue, etc., and assist business units in strategizing business, marketing campaigns, and offers for brand growth in terms of sales, views, and CTR.
Enhancing the user experience by tracking and ensuring minimal cancellations on four levels (daily, monthly, category, and merchant level); Also monitoring brands' performance in terms of order fulfillment and store activation on the app, which leads to 0.8 % MX cancellation and 90%+ activation.
Created a dashboard in Data Studio integrated with a BigQuery database to track sales associate performance, conversions, and monthly incentives.
Drafted daily & monthly sales reports and analysis that aid in organizing different
campaigns to increase demand at partner brands, manage their P&L, and generate revenue through ad sales at these brands.
Worked with other teams to resolve issues, drive product changes, and improve business intelligence.

MySQLMicrosoft ExcelData VisualizationData AnalyticsPython (Programming Language)SQL+9