Share This
17.6868 83.2185 Based In India
//Words About
Kunal.
Few things that you need to know about me.

Jack of all Tech
Master of Some

Not ashamed for the sentence above, because someday you'll need a guy like me.

I'm a Data Analytics Lead, getting my brain stormed with Data Viz, Analytics and Data Science. The path towards Analytics, Data Science and Engineering has been quite, hmm, nahh, much interesting.
I live for the data, i feed the data, at the end of the day it's all about the data anyway. Data is everywhere, You just need to keep your eyes and ears open, and obviously mouth shut!
With work experience in Data Science, Data Analytics and Blogging, I've developed immense indulgence in the field of Data Visualization, Data Analytics, Marketing Analytics, Crypto-Currency and Security. Oh, Yes! I know web development too ;)

You can take a look at my projects in the portfolio section.

Have something interesting ? Hit me up! Would love to collaborate.

Always remember, Even small insights can change your business outlook.

My Portfolio

Some Insights about my
work

I have completed some exciting projects, as well as volunteered for social causes.

Numbers
0
Finished projects
0
Lines of code
0
Working hours
0
Coffee Cups
My Resume //

Something about my professional life

My Awesome professional life Story

From working on Viz Tools, Excel, SQL & Python to working on Web Development, Data Analytics, Data Science and Blockchain.
I've done it all.

Analytics Lead - SaaS Platforms - Publicis Groupe

Jul'23 - Current
01. -

What am I doing here?

I take care of Data Requests for various clients, Manage a Team of Analysts, Adhoc Analysis & Insights Generation, Dashboards, Event Tracking for app and web, and collaborate with other departments/clients to make their work easier by automating things and also making the product experience better for them.

  • Google Analytics, Firebase & Tag Manager
  • Neo4j & SQL
  • Microsoft Azure, Databricks & Pipelines
  • Excel & PowerBI
  • Stakeholder Management

Analytics Lead (TOFU, Referral & Engagement) - OneCard

Jan'23 - Jul'23
02. -

What am I doing here?

Handling TOFU of OneCard, OneCard Referral Program, Comms Engagement & SEO. It all Includes data requests, managing a team of analysts, Data Analysis, Product Optimization, Comms efficiency & Optimization, Marketing Analytics and adhocs all day everyday

  • Google Analytics, Firebase & AppsFlyer
  • Athena, Bigquery & AWS
  • Python, Sagemaker & Superset
  • SQL and Excel
  • Stakeholder Management

Analytics Lead - Testbook

June'21 - Dec'22
03. -

What am I doing here?

Became the offical Team Lead after leading the team for an year. I take care of Data Requests, Manage a Team of 11+ Analysts, Adhoc Analysis & Insights Generation, Dashboards, Event Tracking for app and web, and collaborate with other departments to make their work easier by automating things and also making the product better.

  • Google Analytics, Firebase and Tag Manager
  • MongoDB, BigQuery and Redash
  • Python, Airflow and Google Apps Script
  • SQL and Excel
  • Stakeholder Management

Senior Analyst (Business, Data & Product) - Testbook

Feb'21 - June'21
04. -

What am I doing here?

The journey here till now has been exciting. I take care of Data Requests, Manage a Team of 8 Analysts, Adhoc Analysis & Insights Generation, Dashboards, Event Tracking for app and web, and collaborate with other departments to make their work easier by automating things and also making the product better.

  • Google Analytics, Firebase and Tag Manager
  • MongoDB, BigQuery and Redash
  • Python and Google Apps Script
  • SQL and Excel
  • Stakeholder Management

Project Highlights :

    1. Optimize the leads being ingested into the CRM, save man hours and improve conversion rate. This problem was solved by analysing the data for that particular lead source right from the user acquisition source to user activities, thier time taken and so on. New lead source was created with updated criteria and all the metrics improved by 2-5x. This was done using mongoDB, python and Redash.

    2. The project that had impact both on business and product level was about finding the Insights related to the user's first core (tests, quiz, video etc) activity. The first core activity of the user for any product generally determines whether the user will be engaging on the platform futher or will drop off without any engagement/getting monetised. The user's that gets monetized are the one's that does some engagement on the platform and we had a similar assumption. But, after we did the analysis for the same the results were kinda surprising, to our surprise around 30% of users for that particular date range did no activity but got monetized. To dig this deep futher we checked their signup and acquisition source, platform age and other non core activites, activites after getting monetised etc and, yes we did find the pattern for a set of users. We then proceeded to get the users from similar sources and made others do similar non core activites by making the app journey adjusted for them and we are able to see considerable increase in the engagement (10%) and the revenue(3.5%). This entire task had a lot of data stitching and analysing work, from getting data from Analytical Tools to Getting data from the database to automating it for the ease of access of data to stitching Analytical tool data with DB data. The tech and tools used were python, SQL, MongoDB and Webengage

    3. Making android users journeys better for selling more courses on the platform. We added a new sub-product that offered free videos to the user and then the relevant course was pitched to the user on the video page. The earlier flow was broken since the user had to make 10 clicks to reach the pitched course but after analysing the user data on the conversions, click rates etc we added a direct for the user to reach the course via free video while keeping the video running in pip mode to not let the experience fade away. We indeed saw better conversions rates for the courses and more traffic on the courses. This was done using mongoDB, SQL and python.

Analyst (Business & Product) - Testbook

Dec'19 - Feb'21
05. -

What am I doing here?

The journey here till now has been exciting. I take care of Data Requests, Analysis, Dashboards, Event Tracking for app and web, and collaborate with other departments to make their work easier by automating things and also making the product better.

  • Google Analytics and Tag Manager
  • MongoDB and Redash
  • Python and Google Apps Script
  • SQL and Excel

Data & Analytics Engineer - Zebi

July'18 - Dec'19
06. -

What I did here?

I joined Zebi as a Software Engineer about a year and half ago. This was my first full time job. I worked on various technologies here. Name it, I've worked on it. Listing a few below.

  • Data Analytics & Visualization - Python & D3.js
  • Blockchain
  • Web Development & SQL
  • Content Writing

Among the things mentioned above, the tech that I've worked on the most is Data Analytics & Visualization

Project Highlights :

    1. Hotel management software data analysis to find the hotel hoppers, user behaviour, high traffic areas and seasonality in the hotel data. It was done using python and tableau.

    2. Zebi Crypto Platform's day to day analysis on traffic, volume, price, nodes, blocks created and so on.

Data Analyst - Intern - Systech solutions

Jan'18 - April'18
07. -

What I did here?

I joined Systech Solution as Data Analyst - Intern. This was probably the best learning experience ever. This started from new year'18 and went all along until April. The learning schema here has helped me alot to grasp the tech mentioned down below.

  • SQL
  • Tableau
  • Oracle SQL & Developer

Oh, This was my last internship BTW. After which I joined Zebi.

Analyst - intern - Vtech soft it services

June'17 - Aug'17
08. -

What I did here?

I joined Vtech as an Analyst - Intern. I worked here mostly on analysing their client's data and making Visualizations. Also, learned some stuff about the branding world. The tech I've worked here are:

  • Excel
  • R Programming
  • PowerBI

This was that time when I fell in love with R. Although, I haven't worked more on it during my fulltime but just a quick refreshment would do the work. Check my GITHUB for R projects.

Market Analyst - Intern - Paytm

July'16 - Oct'16
09. -

What I did here?

At this moment I got exposed to the Corporate world. The first impression was quite good. I developed the interest in Data Science just here. Got to work on Analytics projects and learning curve was good. The tech I've used here are:

  • Digital Marketing
  • Excel and javascript
  • Tableau

From forecasting to time series analysis, I have done it all here.

Download Resume

My Video Presentation

I created a personal virtual assistant and shared this video on linkedin. This is just a quick demo of my project. Many more videos are in the pipeline for near future. Meanwhile, Why don't you just follow me? Pleaaaaseeeeeeeee.

My Youtube Channel

My Software and
Coding Skills

I have worked on different tools and languages in my career.

Power
//attainments

Software and Tools

01. -

PowerBI & Tableau

Google Analytics & Tag Manager

Excel & Google Sheets

Apache Airflow & DataBricks

Marketing Automation Softwares

ChatGPT Prompts

Coding Skills

02. -
Python
75%
JavaScript & Google Apps Script
70%
MongoDB, SQL & Neo4J
77%
GCP, AWS & Azure
55%

Ready To Get on a Roller Coaster with me ?

© Kunal Dhariwal 2023 / All rights reserved.
Get in Touch
Close