Default profile banner
SG

Somanshu Gupta

@somanshu

Associate Manager Business Analyst at Physics Wallah

Ghaziabad, Uttar Pradesh, India

Physics WallahDelhi Technological University

Data Engineer with 1.5 years of work experience as data and business analyst in edtech, currently pursuing MTech (R) in Data Science at DTU. Adept at solving complex business problems through cross-functional collaboration. Eager to leverage strong analytical and data engineering skills to contribute to innovative teams and drive data-driven impact.

Experience

Associate Manager Business Analyst

Physics Wallah

•Apr 2024 - Sep 2024

Fronted the development and execution of a tailored Customer Lifecycle Management (CLM) model, delivering a personalized experience for every student, enhancing engagement, and driving long-term retention. Led the design, implementation, and launch of CLM strategies for key platforms including PW MedEd, Drona, Pitara, Mentorship, Batch Infinity, and PW Store, ensuring seamless integration and impactful results. Designed and optimized CLM journeys based on detailed user activity, resulting in a 40% reduction in manual efforts for retention efforts and a 23% increase in conversions.

Associate Business Analyst

Physics Wallah

•Oct 2023 - Mar 2024

Led customer segmentation efforts for Drip Marketing communications, developing targeted strategies to enhance engagement and drive conversion across diverse user groups. Created and maintained user-activity dashboards for over 30+ exam categories, providing actionable insights for decision-makers to drive user engagement and retention.

Business Analyst Trainee

Physics Wallah

•Apr 2023 - Sep 2023

Gained hands-on experience in SQL, leveraging data extraction, transformation, and analysis to generate insightful reports and optimize decision-making processes. Developed and maintained interactive dashboards, translating complex data into visually compelling insights that empowered stakeholders to make data-driven business decisions.

Education

Delhi Technological University

Master of Technology (R)

Data Science

Aug 2024 - Present•Grade: 8.80/10

Guru Gobind Singh Indraprastha University

Bachelor of Technology

Information Technology

Aug 2019 - Jul 2023•Grade: 8.82/10

Licenses & Certifications

Data Analyst with Python

DataCamp

Intermediate SQL Queries

DataCamp

Python for Data Science

Udemy

Skills

Python
MySQL
MongoDB
Cassandra
Hive
BigQuery
Snowflake
Confluent Kafka
GCP Pub/Sub
Apache Hadoop
Apache Spark
Databricks
Looker Studio
QlikSense
Tableau
Apache Airflow
Git
GitHub
GitHub Actions
MS Excel
MoEngage