Swastik Sarkar

Tasks/Achievments :

· Cleaning and extracting data from Nielsen GTC database (Retail Data)

· Checking the quality of data on a daily basis

· Creating reports and meaningful insights from large datasets.

· More than 2 years of working experience with CPG RMS data

· Data Analysis: Analysis of data on regular basis from various reports for different KPIs and metrices

· Data Sourcing: Regular follow ups and communication with the Data Providers and clients for issues related to sourcing of the data

· Supporting the team for various Ad hoc requests from the clients

· Extracting data from SQL for reporting purposes

Projects Undertaken:

Monthly Share Report:

Created an end to end report right from data extraction to data quality checks to building the report.This report helped the clients identify the top markets driving the Company’s Share amongst the other 80 markets for different categories

Quarterly Earnings Share Report:

· Created a report based on our quarterly data release. The report includes different KPIs and how the client company is performing compared to its competitors sourced from Nielsen database.

Share Analysis:

· Created a Power BI dashboard demonstrating the performance of specific categories of the client company and how they are performing against their competitor which is refreshed on a monthly basis

Category Review:

· Created a presentation to help the clients understand which category has the highest impact among the top 40 markets based on share change, contribution to growth and various other KPIs as required.