YOGDA GHARAT
Phone: - |-| LinkedIn: yogdagharat
SUMMARY
•
Data Science enthusiast with 1+ years of experience in data analysis, data manipulation and modelling in R, Python
•
Adept at presenting data insights to end-users through interactive dashboarding in Tableau and Power BI
•
Proficient at using Agile (Scrum) methodology for software development to deliver to client-specific needs
•
Skilled at extracting, transforming, and loading data (ETL) by writing queries in SQL Server
•
Effective communicator with ability to convey information in a clear, concise manner both verbally and in-writing
•
Dedicated, hard-working individual with problem-solving ability and passion to learn new technologies
TECHNICAL SKILLS
Programming Languages: Python (Pandas, NumPy, Matplotlib, Sci-kit Learn), R (dplyr, tidyverse, ggplot), HTML, CSS
Tools: Microsoft Excel, PowerPoint, RStudio IDE, Tableau, Jupyter, Google Collab, Microsoft Power BI, IBM SPSS
Databases: MySQL, SQLite, PostgreSQL
Skills: Data Wrangling, Statistical Analysis, Data Management, Time Series Analysis, Data Modelling & Visualization
EDUCATION
University of Waterloo, ON, Canada
Master of Management Science | CGPA: 87.88%
University of Mumbai, Mumbai, India
Bachelor of Computer Engineering | CGPA: 9.45/10
Sep 2019 - Dec 2020
Jul 2015 - Jun 2019
WORK EXPERIENCE
Data Analyst Intern
Jun 2019 - Aug 2019
DishantCrafts LLP, Mumbai, India
•
Engaged in sales forecasting and developed insightful dashboards in Excel and Power BI to highlight sales trends
•
Performed factor analysis to identify product preferences among customers, increasing sales by 7%
•
Managed Inventory records and liaised with external stakeholders to determine product requirements
•
Conducted quantitative product research and participated in business development activities
PROJECT EXPERIENCE
Brand Tracking Survey Analysis
Sep 2020 - Dec 2020
•
Developed a comprehensive customer segmentation strategy using Clustering & Principal Component Analysis
•
Performed Hypothesis Testing to make statistical inferences about relationships between brand variables
•
Tracked brand performance and identified factors contributing to brand success using SPSS
Air Quality Analysis and Predictive Modelling
May 2020 - Aug 2020
•
Predicted Air Quality using Machine Learning models built in Python and Google Collab Notebook
•
Used Feature Engineering to identify major air pollutants and recommended measures to curb air pollution
•
Highlighted the impact of Covid-19 restrictions on the Air Quality through visual graphs
Data Analysis of Wine Color
Jan 2020 - Apr 2020
•
Built a Binary Logistic Regressor to predict wine ‘color’ and performed outlier detection & assumption testing in R
•
Evaluated the model against Random Forest Classifier and achieved a better prediction accuracy for the latter
Healthcare Data Projects
Jan 2020 - Apr 2020
•
Performed Exploratory Data Analysis on WHO Tuberculosis Data in R to summarize trends and visualize
factors contributing to TB burden and mortality rate using Tableau
•
Used Multiple Linear Regression model to predict daily MRI requests using Excel
Web Application on Online Tours and Travels
Jul 2018 - Dec 2018
•
Implemented e-Commerce Website with user session management, travel search and reservation features using
PHP, HTML, CSS, XAMPP Web Server Solution Stack
•
Wrote complex queries in MySQL to store, sort, fetch and manage customer data across multiple tables
ADDITIONAL EXPERIENCE
•
Proposed an overall mobile application plan for various UW services as a member of the IT advisory board for UW
•
Processed POS transactions and assisted team members in merchandising as a Cashier at Loblaw’s Wholesale Club
•
Collaboratively organized programming workshops and technical seminars for undergraduate students
•
Led a team of five to organize an Inter-College Technical Coding Competition for undergraduate students
