Manjot Singh

Experience

• 

  Indian Institute of Information Technology Vadodara

  May 2022 - Jul 2022

  Research Internship (Deep Learning)

  Conversion of Music Notes from images of Bhatkhande Notation System into MIDI file(audio file) involving Images Processing using OpenCV, Deep convolutional neural network modeling using Tensorflow & Keras and extracting the resultant notes to be converted into a playable audio file using music21 toolkit for computer-aided musicology.

• 

  Testbook

  Jan 2023 - now

  Product Analyst

  • Set up 3+ automated data aggregation pipelines via Apache Airflow, Google Cloud Platform & ClickHouse.• Designed 20+ dashboards, 400+ queries & 1k+ visualisations for reporting KPIs of all products and teams.• Detected and blacklisted 150+ malicious users using advanced data analysis techniques.• Automated session management with Calendly, reduced missed sessions by 25% across 15,000+ mentorship sessions.• Optimized translator management in Kissflow CRM, saving costs on 10,000+ translations.• Integrated data of 17M+ MAUs from 6+ sources to generate product insights & periodic investor reports.• Prioritised 5+ product improvement ideas via KNN clustering, Linear Regression & A/B testing on Firebase.• Automated 25+ ETL processes through Google Sheets, Apps Script & APIs to update & ingest backend data.• Created app & web events collecting data of 2M+ DAUs for designing effective user retargeting campaigns.• Responsible for successful planning and migration of web events & data from Universal Analytics to Google Analytics 4.• Performed Exploratory Analysis to identify unusual trends in engagement data & fixed misfiring user events. Show less