SONAL LALGE

• Rolex - Paid Search
• Responsibility - Analyzing performance data to identify trends and patterns in order to improve campaign effectiveness.
• Monitored and managed online advertising budgets and developed budget recommendations.
• Conducted analysis and generated reports

(i) Meteor: Data Science project based on UK market.

• Responsibility - Extraction of data
• Mapping of data by using business rules to portal
• Automation of process using Excel by using logical techniques
• Checking dashboard to tracking the error of data mapping

(ii) Competitive Analysis:

• Involve in Competitive Analysis of Media spends across multiple clients to create a report and share the same with the Global Team
• Use of DBMS (MS SQL Server) to set up the database and mapping and calculations basis SQL queries
• Creating mapping tables and using SQL joins to create reports for spends by applying netting factors and converting it to standardized CHF currency
• Check for the media spends trends for advertisers across the markets and highlighting any variations to the Markets for genuine data

• Online Brand Management for Client Club Mahindra
• Responsibility - Monitored social media platforms and consumer complaint forums
• Responding to users tweets and post on social media platforms consumer complaint forums
• Monitored competitors social media platform mentions and created the detailed presentation for the same