M

Mugdha Sanjay Parbat

About

Detail

data analyst
United States
Contact Mugdha regarding: 
work
Full-time jobs

Timeline

work
Job
school
Education
folder
Project

Résumé

Jobs verified_user 0% verified
  • Mimecast
    Analytics Intern
    Mimecast
    Jun 2022 - Dec 2022 (7 months)
    • Reduced reporting time of marketing leadership by 15+ weekly hours by building dashboards for 30+ strategic campaigns • Developed a hygiene inspection tool on Tableau Desktop & Tableau Prep to optimize the sales pipeline to spot nulls • Discovered ~600 low impact dashboards by building metrics from Tableau server's metadata on PostgreSQL using CTEs • Minimized Tableau server repetitive tasks by 75% by developing multiple automation scripts to support business analysts • Created clustering & classification algorithms to identify individuals likely to purchase the product resulting in a +3% in sales • Reduced data discrepancies by 8% using Python with statistical profiling on transaction values, ensuring accurate reporting
  • I
    Data Analyst Intern
    Impact Consulting - Lagos
    May 2021 - Aug 2021 (4 months)
    • Saved 5% of the marketing budget by writing MySQL queries to pull traffic sources data which enabled bid optimization • Developed ETL pipelines with Alteryx to automate data cleaning processes, enhance data quality & decrease manual effort by 20% • Generated recurring reports on Tableau for C-suite & streamlined the process by leveraging Tableau's automating capability
  • T
    Data Analyst
    The Keelworks Foundation,
    Mar 2021 - Current (5 years 8 months)
    • Developed SQL queries to extract & analyze user engagement metrics, determining inactivity thresholds for user deactivation • Automated the identification and deactivation process using Python scripts, improving efficiency and accuracy by 40% • Collaborated with IT team to implement deactivation protocols, ensuring compliance with data security & user privacy regulations
  • C
    Business Analyst Intern
    Cyphertree,
    Aug 2020 - Jan 2021 (6 months)
    • Created & maintained SQL scripts to generate EU startups summary by region supporting content marketing strategy • Ideated & developed 7 new metrics on Tableau to visualize 20k+ candidate data points to support HR decision making • Saved $3000 of advertising costs by extracting data using complex joins & subqueries in SQL in identifying business trends
  • J
    Business Analyst Intern
    Johnson Plastosonic,
    Jan 2020 - Jun 2020 (6 months)
    • Conducted weekly team meetings to gather requirements, communicate with stakeholders & define scope for 2 new products • Increased efficiency of MySQL queries used for data extraction by implementing temporary tables & CASE statements • Managed vendor relationships & negotiated contracts to ensure cost-effective solutions, resulting in an 8% cost reduction
Education verified_user 0% verified
  • Northeastern University
    Master of Science in Engineering
    Northeastern University
    Sep 2021 - Dec 2023 (2 years 4 months)
  • Vishwakarma Institute of Technology
    Bachelor of Science in Engineering
    Vishwakarma Institute of Technology
    Jul 2017 - Jun 2021 (4 years)
Projects (professional or personal) verified_user 0% verified
  • Y
    Youtube Data Engineering
    Sep 2023 - Dec 2023 (4 months)
    • Led ETL pipeline development with AWS Glue and Lambda for data processing on S3, optimizing workflows • Architected scalable AWS infrastructure with QuickSight for precise YouTube data analysis and targeted advertising campaigns.
  • H
    Home Insurance Database System
    Jan 2022 - Mar 2022 (3 months)
    • Established relationship between 12 entities by designing ER diagram in Lucid Chart to store data for underwriting team • Composed triggers to automate status (approval/rejection/standby) updating procedure of customer application
  • H
    Heart Disease Prediction (Python)
    Jan 2022 - Mar 2022 (3 months)
    • Investigated dataset of Cleveland's Heart Disease from UCI Repository & selected applicable parameters from 300+ records • Fitted K Nearest Neighbor, Decision Tree, Random Forest, SVM & achieved 91.60% as highest accuracy for Random Forest
  • A
    Atliq Stores Sales Analysis
    Sep 2021 - Nov 2021 (3 months)
    • Designed a Star Schema & queried information from the dataset containing live orders • Performed ETL using Tableau, & built visually impactful dashboards showcasing sales trends over the period of 5 years