Sokoskills

Business Analyst

YouTube

Creating Content related to Data Analytics techniques including Data Cleaning, Data Manipulation and Data Visualization using tools like Advanced Excel, SQL, Tableau and R Studio. 

YouTube channel : https://www.youtube.com/@learnandapplywithMohit

Content Creator

VerSe Innovation

• Developed the pricing chart of various categories of products like education, Healthcare, real estate etc using keyword planner in Google Ads and updated the same in CRM. 
• Managed Google campaigns like Search, Display and YouTube and proposed estimated clicks and impressions for various clients across custom proposals.
• Collaborated with Campaign Managers and Strategy team to verify the pricing and any over delivery or under delivery of campaigns.

Tools : Advanced Excel, LeadSquaredCRM, Google Ads, Google Sheets

Data Analyst

Sabbatical

Sabbatical Break

Mobile Premier League (MPL)

• Worked on Python Automation. 
• Analyzed Business Metrics related to Content Creation, Consumption, Transmission, Monetization, Retention, Engagement and accelerated content creation by 10x and user engagement by 2x. 
• Worked on Short Videos, Live Audio Shows,Chats and Stories while working with Social Content Team. 
• Collaborated with Product Managers, Senior Stakeholders including VP of Social Content, Tech, Data Engineering and Analytics team.
• Worked on Deep Dive analysis of 1v1 chat with Senior BA and Product Managers before presenting 
   my insights to Senior Stakeholders.
• A team player and assisted team members in writing complex SQL queries using CTE which 
  improved Team’s productivity.
• Performed data quality check via instrumentation and reported the same to Product, Tech and Data Engineering Team.
• Calculated User Acquisition and LTV/CAC across different marketing channels like Google, Facebook, Organic, Referral and others.
Tools : SparkSQL, Qubole, G-Suite, Clevertap, PySpark, Advanced Excel

Data Analyst - Content and Marketing Analytics 

Vedantu

	Coordinated with Tech, Analytics, Content and Product Team to understand data related requirements and business related requirements.
	Developed Interactive Dashboards in Excel and Tableau to understand factors that impact session completion Rate and Session Rating in live online interactive sessions. 
	Brought Tableau BI Tool at Vedantu via presenting my insights through Tableau Public Dashboards.
	Improved the Session Completion Rate from 50% - 80% post analysis, insights and recommendations. 
	Measured Quiz Attempt%, Quiz Accuracy% and Quiz difficulty level (Easy, Moderate, Tough) across Subjects, Grades, Course, Months, Teachers, Attendance to measure learning outcome score from each sessions.
	Predicted Content Quality Score by building a linear regression model in Excel where independent variables are time spent per slide, doubts asked per slide, %Doubts resolved per slide, Avg chats per slide and like/dislike 
ratios per slide. Used lead/lag function to get time spent per slide.
	Built Linear Regression Model in Excel and R to calculate Session Engagement Score which is a multiplication of 
session rating and session completion rate.
Tools : Tableau, PostgreSQL, R Studio, Metabase, Advanced Excel using Vlookup, Countifs etc.

Business Analyst - Content Learning 

Indian Academy of Sciences

Worked on a project titled "Trace element study of the minerals separated from the mafic dyke found in the Southern Granulite terrain and its petrogenesis during May-July 2015 as a Summer Research Fellow under the supervision of Dr. Rajneesh Bhutani, Pondicherry University, Puducherry. The Summer Research Fellowship Programme is jointly sponsored by Indian Academy of Sciences(Bengaluru), Indian National Science Academy(New Delhi) and The National Academy of Sciences (Allahabad). 

Mentor : Dr. Jitendra Kumar Dash.

Received an EX Grade during Internship Presentation at IIT Kharagpur

 Summer Research Fellow

Prithvi IIT Kharagpur

✦ Served as Executive Committee Member and led a team comprising of 10 Publicity members.

✦ Successfully conducted the fest by increasing the student participation to two-fold compared to the previous session.

*‘PRITHVI’ is the annual technical fest of the department of Geology and Geophysics at IIT Kharagpur

Executive Committee Member 

✦ Worked in a team of 6 and was responsible for publicizing the fest both inside as well as outside the institute campus.

✦ Reached out to colleges across India via email or calls and brought more leads and participation.

Sub- Executive Committee Member

As a Data Analyst, I am passionate about sharing my knowledge and expertise in Data Analytics. I have over 3 years of experience as a Data Analyst in various domains, such as FinTech, EdTech, Gaming, and Social Content. I use tools like Advanced Excel, SQL, Tableau, and R Studio that covers Data Cleaning, Data Manipulation, and Data Visualization techniques. 

Some of my key achievements include acquiring more than 100 subscribers to my newsletter on "Motivation for Introverts" on the same day of publishing it, making a movie series with 3 parts using video editing software, and bringing Tableau BI Tool at Vedantu by presenting my insights through Tableau Public Dashboards. I also have certifications in Google Analytics, Advanced Google Analytics, and Introduction to R. I am an IIT Kharagpur graduate with a degree in Applied Geology and a recipient of INSPIRE Scholarship and Science Academies' Summer Research Fellowship. I am actively seeking Analytics opportunities where I can apply my skills and contribute to the growth and success of the organization.

Taplio

Mohit Kedia's Linkedin Analytics

Mohit Kedia

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Mohit Kedia's Linkedin Analytics

Mohit Kedia

Want to drive more opportunities from LinkedIn?

Mohit Kedia's Linkedin Analytics