Omkar Shah Gond — Business Analyst

Core Competencies :- ✅Excel ✅SQL ✅PYTHON :- Lists, Tuples, Dictionaries, Sets. Looping, If Else, Functions, String Formatting etc. Series and DataFrames, NumPy, Pandas. ✅ Tableau ------------------------------------------------------------------------------------- ☑️ Implemented Imputation methods to fill missing values, dealt with data - time features, using various encoding techniques for categorical fields, checking for skewness and outliers on numerical features. ☑️Used various aggregate functions such as count(), sum (), min (), max(), avg(), stdev(), median() on the GroupBy () statement as a part of data analytics. Also worked on various modules such as Probability Density Function and Cumulative Density Function for statistical analysis tasks. ☑️Used the Matplotlib and Seaborn Libraries for generating various plots. Also, worked on some in built visualization methods which are available on Pandas too. Generated various plots such as Distribution Plots, Bar Plots, Box Plots etc. for various numerical fields. Checked the correlation among features using a Heat map and Joint Plot. ☑️ Worked on Regression, Classification and Clustering tasks for Predictive Analysis. Some algorithms includes Simple Linear Regression, Decision Tree and Random Forest. Project Experience Summary Analysis of COVID-19 Dataset • Analysed the COVID-19 dataset and created visualizations. • Using ETL (extract, transform and load) integration process. SQL DATA EXPLORATION • Creating SQL queries in Microsoft SQL Management Studio to show various data factors (Location, Death, Positivity Rate, Percentage etc) have changed over time. Correlation in Python • Correlation coefficients quantify the association between variables or features of a dataset IPL 2021 Dashboard • Build a dashboard using web scraping and streamlit along with various other Python libraries to get the latest updated data/results of IPL 2021.

Stackforce AI infers this person is a Data Analyst with strong skills in data processing and visualization.

Location: Lucknow, Uttar Pradesh, India

Experience: 4 yrs 10 mos