SHUBHANKAR SINGH

Dynamic Senior Data & Business Analyst
Bengaluru, IN.

About

Dynamic Senior Data & Business Analyst with over 3.5 years of experience in real money gaming, fintech, and e-commerce. Proficient in SQL, Python, and advanced analytics, I excel at designing robust data warehouses, orchestrating A/B tests, and executing cohort analyses to uncover actionable insights. I am an accomplished storyteller adept at crafting compelling narratives grounded in data, consistently driving significant business growth and operational efficiencies.

Work

Stealth Startup
|

Assistant Manager - Business/Product Analytics

Remote, Remote, India

Summary

Led business and product analytics initiatives for a real money gaming startup, focusing on A/B testing, data warehousing, and strategic insights to drive user engagement and revenue growth.

Highlights

Designed and executed an A/B test on withdrawal limit changes, achieving a 19% absolute uplift in withdrawing users and a 7% increase in repeat depositors, significantly enhancing user trust and retention.

Developed an ROI funnel for marketing campaigns based on comprehensive click and conversion data, leading to a 7% relative uplift in first-time deposit (FTD) conversions from diverse partners.

Engineered and automated daily reward A/B tests via SQL and Python scripts, resulting in an 8% uplift in D1 to D7 retention for game plays.

Spearheaded the design and implementation of an analytics data warehouse, consolidating disparate event streams (server logs, client-side, transaction records) and establishing multiple ETL workflows for seamless data integration.

Passion gaming Pvt Ltd
|

Senior Data Analyst

Chandigarh, Punjab, India

Summary

Orchestrated A/B testing frameworks, developed segmentation models, and implemented automation solutions to enhance player engagement and optimize operational efficiency for a real money gaming platform.

Highlights

Designed and executed an A/B test framework to analyze the impact of match and cash bonuses, increasing the second deposit percentage from 31% to 47% with a 51.6% relative improvement (p<0.1).

Improved Instant Withdrawal (VPA) acceptance from 83% to 91% using fuzzy logic, enhancing user experience and setting up real-time alerts for the team.

Introduced an RFM-based segmentation framework, driving a 6% uplift in monthly game plays and generating an incremental Rs.24 lakhs in revenue by personalizing bonus offers.

Developed an OCR system for reading PAN numbers, reducing operational time from 3.5 hours to 30 minutes and significantly improving efficiency.

Cashfree Payments Pvt Ltd
|

Data Analyst - Payment Gateway

Bengaluru, Karnataka, India

Summary

Mitigated financial risks, optimized payment success rates, and improved data quality through advanced analytics and statistical modeling for a leading fintech payment gateway.

Highlights

Prevented a potential loss of 4.5 crores by proactively identifying payment gateway deprecation and establishing threshold-based alerts.

Performed statistical modeling for a threshold-based routing system, increasing the success rate on Cards from 68% to 72%.

Decreased bin level failures by 23% through identifying and removing deprecated bins, enhancing system reliability.

Corrected MCCs for over 430 merchants on the platform, leading to a higher success rate for transactions.

Flipkart Pvt Ltd
|

Data Analyst - Market Place

Bengaluru, Karnataka, India

Summary

Conducted in-depth market analysis, optimized inventory, and improved product listing strategies to enhance sales performance and reduce churn for a major e-commerce marketplace.

Highlights

Analyzed the competitive market, identifying opportunities to integrate over 15% more selections into the Value Engineering Project.

Identified listings of mskus experiencing weekly churn based on GMV, reducing churn percentage from 51% to 43%.

Contributed to Out-of-stock Analysis, rolling out various products to increase the achievement score from 78% to 84% monthly.

Education

Punjab Engineering College
Chandigarh, Punjab, India

Bachelors of Engineering

Production and Industrial Engineering

Courses

Engineering Mathematics

Operations Research

Statistical Quality Control

Supply Chain Management

Data Analytics Fundamentals

Adarsh Bal Niketan Roorkee
Roorkee, Uttarakhand, India

Senior Secondary

Science Stream

Courses

Physics

Chemistry

Mathematics

Biology

Certificates

The Complete Data Science Bootcamp: 365 Careers

Issued By

Udemy

Marketing Analyst

Issued By

Coursera

Complete SQL Boot Camp

Issued By

Udemy

Skills

Data Analysis & Visualization

MySQL, SQL Hive, Python, Pandas, NumPy, matplotlib, Seaborn, MS-Excel, Tableau, Google Analytics, QuickSight, Metabase, Data Storytelling, Strategic Insights.

Cloud & Big Data Platforms

AWS S3, AWS Lambda, Audacity, MongoDB, Elastic Search, Kibana, NoSQL.

Experimentation & Segmentation

A/B Testing, Cohort Analysis, RFM Segmentation, CleverTap, Mixpanel.

Project & Stakeholder Management

Linux, MS-PowerPoint, Stakeholder Management, Project Delivery.