Overview
Work History
Education
Core Skills
Projects
Websites
Certification
Timeline
Generic

SHIVAM THETE

Mississauga,ON

Overview

6
6
years of professional experience
1
1
Certification

Work History

Data Analyst

MedyMate Inc.
05.2023 - Current
  • Analysed the data from Google Ad campaigns, redirected resources and increased efficiency, and ROI by 25%
  • Assisted in data preparation, analysis, and interpretation to support business decision-making
  • Collaborated with cross-functional teams to define project requirements and deliver data-driven solutions
  • Conducted statistical analysis using Python, extracting actionable insights from complex datasets
  • Built predictive models using machine learning algorithms with the help of Python libraries like pandas, numpy, scikitlearn and matplotlib
  • Spearheaded the creation of visually compelling Power BI dashboards and reports, transforming complex data into clear and compelling visualizations that enabled stakeholders to quickly understand trends and make informed business decisions.

Final Year Dissertation

Lambton College
01.2023 - 05.2023
  • Generated a dataset of chest X-ray images for the prediction of COVID-19 using different available public datasets
  • Developed 2 Machine Learning models (R-CNN and Resnet-50) to predict Covid-19 using chest x-ray images
  • Recommended Resnet-50 based on results of the confusion matrix keeping in mind the consequences of false positive and false negative in the practical implementation
  • Developed custom accuracy measures to ensure robust results trading off precision for higher recall.
  • Used the JIRA portal for project management, documentation and communication between team members and faculty.

Technical Analyst

Amazon Development Centre Ltd.
06.2019 - 11.2021
  • Successfully increased the revenue of Amazon Audible by 15% through the implementation of data driven marketing campaigns.
  • Created dataset from different amazon business domains and met performance requirements during the pilot phase. Created data models using database design techniques such as normalization, denormalization, and entity-relationship diagrams.
  • Derived data insights using Amazon Quicksight for data visualization and highlighted the target audience.
  • Contributed in feature engineering of the model resulting in unbiased results.
  • Designed and executed test cases to validate the accuracy and consistency of data processed by AI algorithms,
    identifying and reporting any discrepancies or anomalies.
  • Prepared comprehensive test plans, test cases, and test reports documenting test results, identified defects, and
    recommendations for improvement, ensuring clear communication across teams.
  • Worked closely with other Business Analysts, developers, and project managers to ensure project alignment
    and progress.

Business Analyst Intern

Drilling Info.
06.2018 - 09.2018
  • Collected and analysed the data of PE-backed E&P Oil and Gas companies focused in the United States
  • Developed technical requirements for new features, corrections, and upstream changes in collaboration with developers and business teams
  • Presented the data as per the company guidelines using Microsoft Excel, QGIS software and other resources provided by the company
  • Used Microsoft Excel to clean data and perform various operations (VLOOKUP) and automation (VBA)
  • Worked on QGIS software to create a snapshot of company acreage
  • Used Microsoft PowerPoint to present my findings and insights to the QA team.

Education

Post-graduate Diploma - Big Data Analytics

Lambton College
09.2023

Bachelor's Degree - Petroleum Engineering

Maharashtra Institute of Technology
06.2019

Core Skills

Languages & Technology: SQL, Python, R, SCALA, PIG Latin, Unix, Jupyter Notebook, Hadoop, Apache Spark, HDFS, Yarn, Hive, Yarn, Scoop, XML, JSON, AWS, Microsoft Azure, SDLC, ETL, VBA, Functional Testing, Natural
Language Processing, CNN, Neural Network, Data mining, Data pre-processing, Data Science, Machine Learning, Data Modelling, Data Analytics, Predictive analytics, statistics, probability
Python Libraries: pandas, numpy, scikitlearn, matplotlib, seaborn, regex, BeautifulSoup, NLTK, Pytorch, Keras
Project Management & Designing Tools: Jira, Confluence, Figma, Canva, Draw.io
Databases: MS SQL Server, MySQL, PostgreSQL, Oracle SQL Server, MongoDB, PL/SQL
Software: Microsoft PowerBI, MS Project, Microsoft Excel, Visual Studio Code, MS Office, VMware, Talend
Methodologies: Agile, Scrum, Waterfall
Soft Skills: Communication, collaboration, adaptability, quick learning agility, teamwork, attention to detail, problem solving, time management, customer orientation, continuous learning, presentation, analytical thinking, troubleshooting, technical writing, leadership, conflict resolution, decision making, Risk management, project management

Projects

  • Credit Risk Analysis - Analysed the risk of lending money for banks based on attributes of applicants. Applied a Logistic regression model
  • Spam detection - Predicted a message as spam or not spam by building a natural language processing prediction model. Used regex for data pre-processing and NLTK fro modelling.
  • Housing Price Prediction - Predicted housing prices based on different features of California neighbourhood. Carried out extensive data pre-processing and applied XgBoost.
  • Sentiment analysis - Built NLP models and product improvement insights using regex and NLTK

Websites

Certification

  • SQL - HackerRank, 95377E984103
  • Microsoft Certified: Azure Data Fundamentals - Microsoft, 694AA09F16DB0DF6
  • Implementing a Data Warehouse SQL Server 2019 - LinkedIn

Timeline

Data Analyst

MedyMate Inc.
05.2023 - Current

Final Year Dissertation

Lambton College
01.2023 - 05.2023

Technical Analyst

Amazon Development Centre Ltd.
06.2019 - 11.2021

Business Analyst Intern

Drilling Info.
06.2018 - 09.2018

Post-graduate Diploma - Big Data Analytics

Lambton College

Bachelor's Degree - Petroleum Engineering

Maharashtra Institute of Technology

Similar Profiles

CREATE PROFILE
SHIVAM THETE