Lavanya Ravi

Analytics Consultant @Fractal

Bengaluru, IN

Decoded the search rank algorithm for multiple online retailers for a CPG/FMCG client to understand the drivers for the search rank of the product to help the client optimize their online spends and improve their organic search rank.• Developed a media attribution model to identify the drivers of sales, compute various incremental drivers, quantify the impact of competition brands & calculate the return on investment of the promotion campaigns. Identified top incremental keywords to improve the return on investment for the sponsored product campaigns for multiple online retailers.• Implemented an attribution model to understand the relationship between online sales and search rank of a product and to compute the impact of organic search rank and paid search rank on sales.• Leveraged Pyspark and Databricks and harmonized data containing millions of rows and performed transformations on data stored in data lake to be loaded into Power BI and developed the search dashboard with complex DAX queries for a FMCG client using Power BI and scaled it across multiple countries in EU.• Worked on multiple end to end implementations for setting up ETL from Azure Datalake using Azure Databricks for dashboards.• Leveraged Pyspark and Databricks and harmonized data from the model output and built a media attribution dashboard for a FMCG client using Power BI and scaled it across multiple countries in EU.

National Institute of Technology Warangal

M.Sc.