Hello!

I'm Amit Ranjan





Driving Growth Through Data, Experimentation & Insight

I leverage SQL, Python, and experimentation frameworks to optimize funnels, improve retention, and drive measurable product impact.

linkedin My works

Name: Amit Ranjan

Job Role: Product Analyst | Growth Analytics

Experience: 5 Years

Address: Pune, India

Skills

Core Analytics Skills
  • SQL (Advanced Querying, Joins, Window Functions)
  • Funnel & Cohort Analysis
  • A/B Testing & Experiment Design
  • Retention & LTV Optimization
  • KPI Definition & Metrics Tracking
Tools & Technologies
  • Python (Pandas, NumPy)
  • DuckDB / BigQuery
  • Google Analytics
  • Looker / Dashboarding
  • Excel
Product & Business
  • Growth Strategy & Experimentation
  • Data Storytelling
  • Stakeholder Communication
  • Agile & Sprint Planning

About

About Me

With 5+ years of experience in Product & Growth Analytics, I specialize in transforming raw data into actionable business insight I have worked extensively on funnel analysis, cohort retention tracking, A/B experimentation, and KPI optimization across SaaS and enterprise platforms. My focus is on identifying growth bottlenecks, improving user activation and retention, and translating product problems into measurable, data-driven decisions that impact revenue and customer experience.

  • Profile: Data Product Management
  • Domain: IT SaaS, Automotive & Retail Martech
  • Education: MBA (IT) & B.E (Electronics & Telecom)
  • Language: English, Hindi
  • PM Skills: Critical thinking, Data Analysis, Google Analytics
  • Interest: Traveling, Music, Basketball, Gym



Connect with me on LinkedIn

Let’s Discuss Growth Opportunities Download Resume

Resume

Resume

Product & Growth Analyst with 5+ years of experience in SaaS, funnel optimization, experimentation, and data-driven product strategy.

Experience


2024-Present

Product Consultant

Acoustic , Pune

Acoustic,AI-powered marketing automation and customer engagement solutions.It offers tools for analytics and campaign automation,helping businesses improve their marketing effectiveness.

  • Assisted clients in implementing and optimizing marketing automation solutions,data integrations to enhance customer engagement and retention.
  • Provided data-driven insights and implemented XML API solutions to streamline marketing workflows, improving automation and its efficiency.

2023-2024

Product Analyst

Rwazi, US Remote

Rwazi,A hyper-local market intelligence platform that provides brands with actionable data on who is buying what, for how much, from where, when, and why and real time actionable data.

  • Implemented the Google Analytics 4 for the mobile application to track all the user's activition rate in completing the sign-up workflow.
  • Handled the mappers support system to provide overall assistance to the users & Involved in creating the survey and publish it through.

2022-2023

Product Analyst

Solera, Bengaluru

Solera uses AI, data, and services to work streamlining processes for your vehicle claims and repair, vehicle sales, and fleet management.

  • Worked on a MAN Driver application to implement EV ecosystem and Fleet management by enhancing the navigation system by integrating advanced routing.
  • Maintained Product Backlog and Sprint backlog by analyzing stakeholders needs and conducting sessions for prioritizing Product features UI UX.

2021-2022

Business Analyst

Loconav, Gurugram

Loconav uses AI,full-stack comprehensive & IoT enabled, Fleet Operations Management Ecosystem. Track, monitor, control, and manage everything you need to keep your fleet operations moving safely and efficiently.

  • Implemented process improvements that enhance operational efficiency and streamline workflows in Fleet Management product Loco.
  • Managed all Fleets end-to-end operations along with its Telematics products and GPS tracking services to the Clients in logistics industry.

2017-2018

Data Analyst

IndiaMart, Noida

IndiaMART is India's largest online B2B marketplace, connecting buyers with suppliers. With 60% market share of the online B2B Classified space in India,focuses on providing a platform to SMEs.

  • Collaborated with the product team to design and analyse A/B tests and experiments to optimize website features, user experiences.
  • Segmented customers based on their behaviour, preferences, and demographics and tracked various KPIs such as user engagement & conversion rates.



Education


2019-21

MBA IT

IIIT Allahabad

Grade: First class distinction.

2012-17

B.E (Electronics & Telecom)

Siddaganga Institute of Technology Tumkur

Grade: First class distinction.

Download CV

Impact Highlights

Driving measurable improvements in activation, retention, and revenue through structured analytics and experimentation.

0

M+

Events Analyzed

0

%

End-to-End Conversion Rate Tracked

0

%

Cart → Purchase Optimization Insight

0

+ Years

Product & Growth Analyst

Projects

Projects

Selected projects demonstrating AI systems, advanced analytics, and production-ready engineering.

FEATURED PROJECT

Ecommerce Revenue Forecasting Dashboard

Built an ML-driven revenue forecasting dashboard enabling forward-looking growth planning for ecommerce businesses. Applied walk-forward validation with Random Forest and XGBoost models (MAPE: 12.38%) to generate reliable revenue projections with uncertainty bands.

Live Demo

Ecommerce Growth & LTV Analytics (66M Events)

Analyzed 66M+ ecommerce events to uncover funnel bottlenecks, retention patterns, and high-LTV customer segments. Performed cohort analysis, conversion tracking, and revenue optimization modeling using SQL (DuckDB) and Python. Identified drop-off points across View → Cart → Purchase stages, enabling data-driven recommendations to improve overall conversion and customer lifetime value.

Personal Portfolio Website

Designed and deployed a data-driven personal portfolio integrating live AI capabilities to showcase product analytics and growth case studies. Focused on structured KPI storytelling, intuitive user experience, and clear project communication aligned with product and growth roles. Demonstrates end-to-end ownership from design to deployment using GitHub Pages.

AI-Powered RAG Chatbot

Built an AI-powered Retrieval-Augmented Generation (RAG) system integrated into a live portfolio to dynamically answer product and experience-related queries. Designed structured knowledge ingestion, semantic search, and context retrieval pipelines to simulate real-world product intelligence systems. Demonstrates applied understanding of data modeling, information retrieval, and AI-driven user experience enhancement.

YouTube Mixtape Automation

Designed an automated media processing pipeline using FastAPI and FFmpeg to orchestrate multi-step audio merging and video generation workflows. Implemented structured file handling, background processing, and scalable task execution to simulate production-ready system design. Demonstrates backend automation, workflow optimization, and deployment-ready application architecture.


0 Achievements
0 Projects
0 Mentored Students
0 Cups of coffee

More projects on Github

I love to solve business problems.


GitHub

Contact

Contact Me

Below are the details to reach out to me!

Address

Pune, India

Contact Number

9304177396

Email Address

amitr2k15@gmail.com

Download Resume

resumelink



Have a Question? Click Here


  • Find me on

Ask About Amit