Sonal Pandey | Big Data Analytics at Georgian College, Canada | Ex- Senior Analytics Executive at WPP | Consumer Insights | Digital Data Analytics | Market Research

Sonal Pandey

Big Data Analytics at Georgian College, Canada | Ex- Senior Analytics Executive at WPP | Consumer Insights | Digital Data Analytics | Market Research

Based in Ontario, Canada

About

Welcome to my portfolio! I am an accomplished data analyst with a strong academic background and over 2 years of professional experience in the field of data analytics, specializing in Consumer Insights, Digital Data Analytics, and Market Research. I hold a bachelor's degree in Electrical and Electronics Engineering from GGSIPU University in Delhi, India, and I am currently pursuing a post-graduate program in Big Data Analytics at Georgian College in Canada. My passion lies in transforming raw data into actionable insights that drive business growth and inform strategic decisions. With a keen eye for detail and a problem-solving mindset, I excel at utilizing advanced analytics techniques to extract valuable information from complex datasets.

Skills

Projects

Sentiment Analysis-Amazon Echo Customer Reviews

In this project, I have built, trained and tested an AI model to predict sentiment from real Amazon customer reviews. AI/Ml based sentiment analysis is crucial for companies to automatically predict whether their customers are happy or not.

Twitter Sentiment-Analysis using Naive Bayes Classification

In this project, I have trained a Naive Bayes classifier to predict sentiment from thousands of Twitter tweets. This project could be practically used by any organization with social media presence to automatically predict customer's sentiment (i.e.: whether their customers are happy or not).

COVID19 Data Visualization Using Python

In this project I have used the COVID19 dataset which consist of the data related a cumulative number of confirmed, recovered, and deaths cases. I have prepared this dataset to answer these questions: How does Global Spread of the virus look like? How intensive the spread of the virus has been

Relationship between the spread of the the virus in a country and how happy people are, living in that country

In this project I worked with COVID19 dataset, published by John Hopkins University. Also I had another dataset consist of various life factors, scored by the people living in each country around the around the globe. I merged these two datasets to see if there is any relationship between them.

End to End Business Intelligence solution using MICROSOFT POWER BI

WORLD HAPPINESS REPORT 2021 by Sonal Pandey

Tableau Public- Sonal Pandey

Welcome to Sonal Pandey's Data Viz Gallery!

Covid 19 vs World Happiness- Advance Excel Analysis

The World Happiness Report and COVID-19 data can be correlated using statistical techniques such as correlation analysis. Here are a few potential correlations to investigate: Examine the association between socioeconomic factors and COVID-19 cases by looking at variables like GDP per capita

Publication - Human computer interaction an overview of software architecture

NDIAcom 2019 IEEE Conference ID 46181 Copy Right © INDIACom-2019; ISSN 0973-7529; ISBN 978-93-80544-32-8

Experience

2019

Project Internship - Defence Research and Development Organisation (DRDO)

Worked under the guidance of Dr. A T Nimal, scientist 'F', SAW group, SSPL DRDO and assisted him on live projects

2021

Data Analyst - BetterPlace Safety Solutions

Performed data manipulation and data exploration to support high-quality data and catch errors before processing. Conducted Data Visualization and reporting using interactive dashboards in Google data studio, Tableau. Good statistical knowledge and ability to find tough data points in a sea of information. Well versed in scientific research, statistics and data driven models. Able to process data quickly to build Reports to deliver valuable insights via data analytics and communicate findings effectively to individual.

2021-2023

Senior Analytics Executive (Google) - Essence, WPP

-Proficiently implemented media campaign measurement techniques, including Brand Lift Studies, Conversion Lift Studies, and Matched Market Testing, to gauge the impact and success of advertising initiatives. -Analyzed complex data sets to derive actionable insights that informed future campaigns, enabling clients to enhance the effectiveness of their advertising efforts. -Collaborated seamlessly with the broader client team and cross-functional teams within EssenceMediacom to implement measurement and analytics solutions that aligned with client objective. -Facilitated open communication and idea exchange to ensure the success of measurement and analytics project. -Played a crucial role in collecting and reporting incrementality results from various media channels

Education

2016-2020

Electrical and Electronics Engineering from GGSIPU Delhi India

Grade- First class with distinction

2023-2023

Post Graduate Certificate in Big Data Analytics from Georgian College Ontario Canada

Grade- First class with Distinction (Expected)