Interacted with stakeholders to understand the business requirements and translated them into technical requirements. Fetched data by writing optimized SQL queries in Snow ake and conducted A/B testing to analyze the impact of new or existing products on business. By doing RCA and prescribing preventative measures for cost-cutting, several blockages that were present in an existing product were resolved. Developed a PowerBI dashboard to monitor data for various KPIs associated with the analysis while taking stakeholders' expectations into account. Created several tables for storing desired data and automated the procedure on a daily basis using Databricks, Git-Hub and Airflow.