What am I doing here?

Handling TOFU of OneCard, OneCard Referral Program, Communications & SEO. It all Includes data requests, 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

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

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.

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

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.

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.

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.

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.