Summary
Overview
Work History
Education
Skills
Websites
Data science projects
Timeline
Generic

Ullahas Gurav

Data analyst

Summary

Data Analysis with over 2.3+ year of experience in the field. Proficient in utilizing Python for data analysis and well-versed in machine learning algorithms. Skilled in extracting data from SAP.

I'm specialize in transforming raw data into meaningful insights. Adept at creating interactive dashboards using data visualization tools like Power-BI, Tableau, and QlikView. Proven ability to translate complex data sets into actionable recommendations for informed business decisions. Passionate about leveraging analytical skills to contribute to data-driven strategies and foster organizational success.

Overview

3
3
years of post-secondary education

Work History

Software Engineer

I-clarity IT Services
5 2022 - Current
  • Cash flow–Purchases and Sold report Analysis (Tool used: QlikView, Excel)
  • · Extract data from SAP run all the jobs in QMC.
  • Performs data segregation on fetch data and make data in unique uniform form Make Daily basis various reports as per our client requirement Make calibration and insure that every day Data Stream works flawless Match the historical data and the current data which is in dashboard.
  • Monthly Cash flow closing (Tool used: QlikView, SAP, Excel)
  • · Primary taking backup of whatever the reports documents of that month Making changes in every cash flow applications to initiate new cash flow of next month Making changes in SAP to get new data in QlikView application And making complete month Cash flow Summery.
  • Sale Prediction (Tool used: Python, Power-BI, Excel)
  • · Data preprocessing-missing value/Outlier treatment. Getting meaningful insight in data from by making Power-BI dashboard. By using ML algorithms found which customer buy and also predict which sale price is accurate for best business according to that region

Education

Graduation in Mechanical Engineering -

G.H Raisoni Collage Of Engineering
Pune, India
01.2016 - 06.2019

Skills

    Data Visualization: QlikView, Power BI, Tableau

    Programming Languages: Python, SQL

    Machine Learning: Regression analysis, and classification

    Data Manipulation: transforming, and manipulating data using libraries like Pandas and sklearn

    Data Cleaning: handling missing data, outliers, and inconsistencies in datasets

    Statistical Analysis

    Data Storytelling

    Microsoft Excel

    Data Validation

    Data Cleaning

    Data Visualization and Presentations

    Excel Functions

    Data Modeling

    Tableau

    Analytical Problem Solving

    Technical Analysis

    Report Writing

    Data Science

    Report Preparation

    ETL processes

Data science projects

Exploratory Data analysis Loan Prediction

· Identify skew, outliers and relationship among other variables in the data by using Univariate and Bivariate analysis of Loan Prediction.

Regression Housing Sale price

· Data preprocessing, EDA, for feature selection apply backward selection, MLR, Ridge, Lasso, select best Algorithm, predict sale price.

Classification Car Type

· Data preprocessing, measure performance of classification algorithms, select one of the best for prediction. Supervised Loan Prediction· Missing data treatment, Data preprocessing, apply classification algorithms to predict Loan Prediction, apply regression algorithms to predict Loan Amount and Term.

Unsupervised Similar Car recommendation

· Read data, data preprocessing, apply Kmeans Clustering, get the input from user then print the similar car by the cluster value.

Startups Analysis

· Explore and analysis the data to identify which gives best variable to predict the profit. Use Simple Linear Regression to find profit along with RND column. After it for multi-linear regression (backward elimination & forward selection) used to identify which is further good predictors to predict the profit. Formed an OLS model to identify and eliminate unnecessary columns from analysis.

Heart Disease prediction

· to understand how people has medical illness history. Performed Various machine learning models of Classification and Regression as above mentioned. After making models predict the whether patient suffering from heart disease or not. Making each model checked its accuracy through Accuracy Score metrics.

Timeline

Graduation in Mechanical Engineering -

G.H Raisoni Collage Of Engineering
01.2016 - 06.2019

Software Engineer

I-clarity IT Services
5 2022 - Current
Ullahas GuravData analyst