Ambika Bahuguna

Business Analyst | Senior Data Analyst | Data & AI Automation Specialist
Bengaluru, IN.

About

Highly analytical Business Analyst with 5+ years of experience across gaming, fintech, and e-commerce, adept at leveraging advanced data analysis, experiment design, and automation with SQL, Python, and data visualization tools. Proven ability to drive data-informed decisions and optimize processes, exemplified by automating reporting workflows with AI/LLMs to save significant hours and enhance D7 retention by 2%. Passionate about transforming analytics with emerging technologies to deliver measurable business impact.

Work

Hike (Rush Gaming Universe)
|

Business Analyst

Bengaluru, Karnataka, India

Summary

Currently serving as a Business Analyst, leading A/B experiment design, data analysis, and automation initiatives to enhance user retention and streamline reporting for the CEO's office.

Highlights

Spearheaded A/B experiment design and analysis for incentivized ads, targeting 65-70% non-paying users, boosting D7 retention by 2% and achieving a 2% improvement in CM1% by optimizing retention bonuses without impacting user deposits.

Automated Daily Analysis Report (DAR) generation and distribution using Tableau and Python, eliminating manual dependency, saving the CEO's office team ~5 hours weekly, and significantly enhancing report accuracy and efficiency.

Groww
|

Senior Data Analyst

Bengaluru, Karnataka, India

Summary

As a Senior Data Analyst, performed extensive root cause analysis, developed ETL pipelines, and created Tableau dashboards to drive actionable insights and improve system stability.

Highlights

Conducted extensive root cause analysis on self-logout incidents, identifying and resolving a critical bug that reduced involuntary logouts by 25% and delivered actionable insights to the development team.

Designed and implemented an ETL pipeline using Jira API and BigQuery to power Tableau dashboards for internal bug tracking and customer support, automating Python-driven Slack alerts for weekly KPI summaries to stakeholders.

Led a comprehensive Tableau Learning and Development session, training the entire analytics team on advanced self-serving dashboard creation to foster data literacy and autonomy.

LimeRoad
|

Business Analyst

Gurgaon, Haryana, India

Summary

Served as a Business Analyst, leading conversion optimization projects and analytics for new user acquisition channels, delivering data-driven insights to improve user engagement and efficiency.

Highlights

Led conversion drop root cause analysis for Facebook acquisition channel users, delivering data-driven insights to the Supply and Technology team that increased first-day user conversion by approximately 50%.

Served as Analytics Lead for the 'Cut The Price (CTP) - Referral Program' new user acquisition channel, establishing end-to-end data visibility through Tableau dashboards to generate actionable insights.

Conducted a training workshop for Business stakeholders on basic SQL usage and standardized queries, reducing ad-hoc data requests by 50% for the data team.

Volunteer

Toastmasters International (Indirapuram Toastmasters Club)
|

Associate to VP Membership

Indirapuram, Uttar Pradesh, India

Summary

Served as Associate to the VP Membership, actively contributing to club growth and member engagement.

Highlights

Increased club member strength by a significant 20% through strategic membership initiatives and support.

Education

IGNOU
New Delhi, Delhi, India

Masters

Psychology (Minors: Statistics)

Grade: First Division with Distinction

Delhi University
New Delhi, Delhi, India

Bachelors

Physical Sciences (Chemistry)

Grade: CGPA: 8.2

Awards

ML Hackathon (Groww) - Top 3 Finish

Awarded By

Groww

Achieved a Top 3 ranking in the 2023 ML Hackathon for developing an XGBoost ML model to predict credit default.

Toastmasters Club - Level 1 Leadership Development Pathway

Awarded By

Toastmasters International

Completed Level-1 of the Leadership Development Pathway, demonstrating foundational leadership and communication skills.

Public Speaking - 1st Position (Club & Area), 2nd Runner-up (Division)

Awarded By

Toastmasters International Speech Contest

Secured 1st position at the Club and Area level, and 2nd Runner-up at the Division level in the Toastmasters International Speech Contest.

Languages

English
Hindi

Skills

Data Analysis & Scripting

SQL, Python, HackerRank Gold Badge, Advanced Data Analysis, Data Modeling, Data Cleaning, Statistical Analysis.

Data Visualization & Tools

Tableau, Looker, Google BigQuery, Jupyter Notebooks, MS-Excel, GSheets, Data Storytelling, Dashboard Creation.

Experimentation

A/B Testing, Multivariate Testing, Hypothesis Testing, Significance Testing, Experiment Design, Statistical Inference.

Data Management & Engineering

ETL, Airflow, Jira API, Data Pipelines, Data Integration, Database Management.

AI & Machine Learning

GenAI, LLMs, XGBoost ML, Predictive Modeling, Machine Learning Algorithms.

Cross-functional Collaboration

Product Management, Business Operations, Engineering Teams, Stakeholder Management, Communication, Project Management.

Problem Solving

Root Cause Analysis, Strategic Planning, Process Optimization, Actionable Insights, Critical Thinking.