● Responsible for development and maintenance of web scraping scripts for competitor analysis using python.
● Building dashboards for various products on metabase (BI Tool) using MySQL . Analysed data and identified patters,
anomalies and risks for different products to give useful insights to acquisition and retention squads.
● Maintenance of Databases on MySQL, normalizing tables and fine tuning SQL queries for better performance.
● Created stored procedures for big queries which involved multiple joins and did indexing in MySQL for improving query
performance.
● Responsible for Datawarehouse and Database management and maintenance.
● Responsible for developing and maintaining Data migration tasks using AWS DMS from MongoDB to AWS Redshift and
connect it to Metabase (BI Tool). AWS Services used(EC2 , IAM Roles, VPC, DMS , Redshift, Aurora)
● Created various funnels using mix panel for app tracking and analysing drop off rates and reasons.
● Created Excel pivot tables for customer segmentation using demographics data.