Summary
Overview
Work History
Education
Skills
Projects
Certification
Languages
Timeline
Generic
SUSHRUT SHARMA

SUSHRUT SHARMA

Pune

Summary

Results-driven Data Analyst with a proven track record at Blue Star, leveraging SQL and Python to automate processes and enhance data retrieval efficiency. Expert in developing real-time dashboards and generating actionable insights, fostering collaboration across departments. Skilled in time series forecasting and committed to delivering precision in analytics.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Data Analyst

Blue Star
Pune
10.2023 - Current
  • Reduced manual effort by 50% through automation using SQL, Python, and Power BI.
  • Developed real-time dashboards for monitoring inventory, shipment status, and predicting demand.
  • Accelerated data retrieval timelines by 40% through deployment of cloud-based automation.
  • Generated supply chain insights using SAP and SQL, resulting in a 25% increase in forecast precision.
  • Worked with various departments to deliver analytical insights, enhancing operational performance.
  • Generated metrics including accuracy, precision, recall, F1 score and AUC to assess model performance.
  • Performed hyperparameter tuning for improving model performance.

MEP QA/QC Engineer

Blue Star Qatar
Doha
03.2018 - 08.2023
  • Oversaw quality assurance and control processes for mechanical, electrical, and plumbing systems.
  • Guaranteed compliance with international standards during client inspections.
  • Collaborated effectively with contractors to execute quality control.
  • Performed material inspections to ensure optimal HVAC system performance.
  • Drafted QA/QC documentation, reports, and compliance checklists to ensure operational standards.

MEP Engineer Intern

Qatar Design Consortium
Doha
09.2017 - 02.2018
  • Assisted senior engineers in designing and reviewing MEP systems, ensuring compliance with industry standards.
  • Conducted site visits and inspections, assisting in resolving technical challenges during project execution.
  • Supported the preparation of BOQs (Bill of Quantities), technical drawings, and project documentation.
  • Gained hands-on experience in HVAC, plumbing, drainage, and firefighting system layouts.
  • Assisted in load calculations and energy efficiency analysis for mechanical and electrical systems.

Education

MBA - Power Management

University of Petroleum & Energy Studies
Dehradun
08.2018

B. Tech - Mechanical Engineering

National Institute of Technology
Surat
11-2015

Skills

  • ARIMA
  • AWS Services (S3, Lambda, and Sagemaker)
  • ETL
  • Microsoft Excel(VBA,Macros & Pivot Tables)
  • Microsoft Power BI
  • Python libraries (NumPy and Pandas)
  • SAP
  • Experienced with Scikit-Learn Libraries
  • SQL
  • Tableau
  • Time Series Forecasting
  • XGBoost
  • Classification algorithms

Projects

Retail Product Analysis & Performance Optimization

01/2023 - 05/2023

  • Analyzed sales and inventory data to identify demand patterns and sales trends, leading to optimized stock management
  • Built interactive dashboards to track product performance, shipment status, and inventory levels
  • Implemented automated reporting solutions, reducing manual efforts by 50%.

Customer Churn Prediction

06/2023 - 08/2023

  • Built an ML model using logistic regression & decision trees to predict customer churn with 85% accuracy
  • Engineered customer behavior features from transactional data, improving model interpretability
  • Developed an interactive Power BI dashboard for business stakeholders to analyze churn trends.

Sales Forecasting for Retail Chain

09/2023 - 02/2025

  • Sales forecasting project leveraging time series analysis for retail chains
  • Developed a time series forecasting model to predict weekly sales, reducing forecasting errors by 20%
  • Automated data pipeline using Python & SQL to streamline ETL processes

Certification

Caltech Post Graduate Program in Data Science
Issued by: Caltech Center for Technology and Management Education & Simplilearn
Date: April 19, 2024
Certificate ID: 101586805

Languages

Hindi
First Language
English
Proficient (C2)
C2

Timeline

Data Analyst

Blue Star
10.2023 - Current

MEP QA/QC Engineer

Blue Star Qatar
03.2018 - 08.2023

MEP Engineer Intern

Qatar Design Consortium
09.2017 - 02.2018

MBA - Power Management

University of Petroleum & Energy Studies

B. Tech - Mechanical Engineering

National Institute of Technology
SUSHRUT SHARMA