Onkar Kota | Data Analyst | Data portfolio

Onkar Kota

Data Analyst

Based in India

About

I am a dedicated Computer Science and Mathematics student, maintaining a stellar 8.79 CGPA. With over a year of dedicated experience, I specialize in transforming raw data into valuable insights. My proficiency lies in utilizing powerful tools such as Adv Excel, SQL, Tableau, and Python to unravel meaningful patterns and trends.

Skills

Projects

Customer Churn Analysis

House Sales Dashboard

Bike Rides Dashboard

Anomaly Detection Case Study

Market Basket Analysis

Customer Acquisition Cost Analysis

HR Analytics Case Study

Unveiling Trends in YouTube Data

Led Comprehensive YouTube data analysis, utilizing Python for efficient extraction with pandas and API requests, Excel for thoughtful cleaning and python libraries (pandas and NumPy) for insightful exploratory data analysis. Created visually compelling Tableau dashboard to present key prescriptive.

Netflix Subscriptions Forecasting

To Improve user experience and optimize resource allocation, tackled the problem of forecasting Netflix Subscription Patterns. Using historical data analysis and the ARIMA time series forecasting model allowed for precise projections of Netflix subscriptions for strategic decisions-making.

Optimizing the Supply Chain: A Comprehensive Analysis

This project conducts a thorough analysis of the end-to-end supply chain, encompassing key stages such as sourcing, manufacturing, transportation, inventory management, and sales. I have noticed a 15% reduction in transportation costs and a 20% improvement in inventory turnover

Experience

2021 - 2022

Accenture - Data Analyst Virtual Experience

I performed data cleaning on datasets with up to 50,000 records, applied preprocessing techniques to reduce noise by 30%, conducted exploratory data analysis on complex datasets.

2021

KPMG - Data Analyst Virtual Experience

Interpreting large datasets of 1000 new customers to identify trends and patterns in the organization. Utilized power query to clean and preprocess data reducing dataset errors by 20% ensuring high quality data for analysis.

Education

2019-2023

Electronics Engineer at University of Mumbai

- Major in Electronics, Minors in Data Science and Machine learning, - Relevant Coursework: Data Analysis, Data Science, Machine Learning, Algorithms, Artificial Intelligence