TestbookTestbook

Testbook · Analyst · Aug 2020 – Jan 2022

Building Analytics & Operational Foundations at Testbook

My first job out of college, on a five-person analytics team. Worked across analytics, reporting, product instrumentation, and operational automation workflows supporting product, sales, and growth teams within a fast-moving edtech startup environment.

AnalyticsRedashMongoDBFirebaseGoogle Apps Script

From Data to Decisions

Collect

Data from multiple operational and product sources

Process

Query, transform, and structure data for reporting

Analyze

Build dashboards and derive operational insights

Alert

Configure alerts using business thresholds

Act

Enable teams to make data-driven decisions

1. Product Analytics & Dashboards

  • ·MongoDB querying across collections
  • ·Redash dashboards for product, sales & marketing
  • ·Query-based alert systems
  • ·MIS & monthly engagement reporting workflows
  • ·Adhoc analytical support for teams

Tech Stack

MongoDBRedashSQL (Mongo Queries)

2. Event Instrumentation & Experimentation

  • ·Planned analytics events, triggers & property schemas
  • ·Worked with developers & QA for event implementation
  • ·Firebase, WebEngage & pixel instrumentation
  • ·GA + Google Tag Manager event planning & user-journey tracking
  • ·A/B testing dashboards for PM workflows
  • ·Product & growth event tracking

Tech Stack

FirebaseWebEngagePixel EventsA/B Testing

3. Operational Automation

  • ·Automated manual data ingestion workflows
  • ·Automated recurring reports with Apps Script + MongoDB queries
  • ·Google Apps Script + Sheets automation
  • ·Bulk lead insertion workflows
  • ·REST API integrations
  • ·Custom Sheets toolbar actions
  • ·Backup workflows using Google Cloud

Tech Stack

Google Apps ScriptGoogle SheetsREST APIsGCP Storage

Testbook gave me early exposure to product analytics, operational automation, and cross-functional execution — shaping the foundation for my later work in production data systems and infrastructure engineering.