Default profile banner
AR

Abhishek Rawat

@abhishekrawat

Data Analyst

NEW DELHI

www.linkedin.com/in/abhishekrawat19

The Monument ShopLiverpool John Moore University

Abhishek is a data enthusiast with over a year of experience in data analytics and reporting. He is proficient in data mining, statistical analysis, and data visualization techniques. He is skilled in data manipulation using SQL, Python, and Excel, and has a proven track record of delivering data-driven solutions that optimize processes and drive business growth.

Experience

Data Analyst

The Monument Shop

Freelance Project•Oct 2001 - Present•NEW DELHI

Using classification and regression model to identify the improvement/decline in the ranking on online retail platform's search engine. Engaged in data processing and Exploratory Data Analysis to bring out useful insights regarding the specific products on online retail platform. Performing Sentiment analysis to get the positive/negative sentiment score for different products on online retail platform. Forecasting the demand in sales using Auto-Regressive Time Series models and the usage and subscriber via Exponential Smoothing techniques. Explored and implemented various statistical and analytical time series techniques like ARIMAX, SARIMAX, and ADABOOST for forecasting problems.

Junior Analyst

Course 5 Intelligence

•Jul 2001 - Oct 2001

Performed demand forecasting using data from google trends for mobile manufacturing company. Performed Exploratory data analysis for an online retailer to bring useful insights regarding their products and performed Market Basket Analysis.

Course 5 Intelligence

•May 2001 - May 2001

Worked on the sales data for year 2021 to answer business related questions regarding items sold and expansion of business in various states and cities using Python (EDA), SQL and Excel. Performed data visualization by creating dashboards using Tableau for better business insights.

Education

Liverpool John Moore University

Masters in Science

Data Science

NIT, Jalandhar

M.Sc.

Physics

Delhi University

B.Sc.(H)

Physics

Licenses & Certifications

Post Graduate Diploma in Data Science

IIIT, Bangalore

• No expiration

Google Analytics

Google

• No expiration

Azure AZ900

Microsoft

• No expiration

Python Bootcamp

UpGrad

• No expiration

Intro to Python Programming

Kaggle

• No expiration

Skills

Exploratory Data Analysis
Predictive Analysis
Linear Regression
Logistic Regression
Demand and Hierarchical Forecasting
Visualization and Presentation
Data Insights
Data Driven Problem Solving
Inferential Statistics
Hypothesis Testing
Statistical Analysis
Regularization (Ridge and Lasso)
Tree Models (DT & Random Forest)
Advanced Regression
Modeling
Data Wrangling
Python (Pandas, Numpy, Matplotlib, Seaborn, Sklearn, Statsmodel)
SQL
MySQL
Tableau
Power BI
Advanced Excel (Pivots and VLOOKUP)
MS PowerPoint