Summary
Overview
Work History
Education
Skills
Timeline
Generic

Harshit Bharrdwaj

Delhi

Summary

An open-minded, focused and versatile individual with strong teamwork and communication skills, looking to enhance my knowledge and interpersonal skills in the field of Data Analysis, Product, Research and Marketing through practical applications.
Proficient in data cleaning and analysis on Python and SQL.
LinkedIn profile: https://www.linkedin.com/in/harshit-bharrdwaj-4b7a6316a/

Overview

4
4
years of professional experience

Work History

Data Analyst (Product Development)

FuelBuddy - Tries Solution LLP
Gurgaon
09.2023 - Current
  • Automated Ad-hoc requests by reducing daily man-hours from ~60 minutes to 0 minutes.
  • Working closely with various departments, including marketing, operations, and customer service, to provide data-driven insights and recommendations.
  • Created more than 15 dashboards. These dashboards focus on real-time monitoring of fuel delivery operations, optimizing logistical efficiency, tracking product funnel performance, comparing overdue and outstanding amounts, analyzing sales versus margins, and assessing customer service metrics. Together, these dashboards provide comprehensive insights to streamline operations and enhance overall performance.
  • Utilized Internet of Things (IoT) technologies to gather real-time data from various sources. Analyzed this data to improve operational efficiency, predict equipment maintenance needs, and enhance customer experience.
  • Crafted and optimized SQL queries for backend developers to integrate into the Fuelbuddy Customer App. These queries enabled the presentation of real-time data on customer dashboards, including key metrics like mileage, asset utilization, and real-time fuel data. This initiative significantly enhanced the app's functionality, providing customers with immediate, valuable insights into their usage.

Data Analyst (Growth)

Milkbasket - Reliance Retails
Gurgaon
12.2021 - 08.2023
  • Customer Fraud Identification : Developed a customer fraud logic which identifies fraudulent behaviour at the time of registration marking 30% of the customers as fraud reducing overall cost of acquisition.
  • Optimized Analytics Processes : Moved the entire Growth team with over 70 scripts from using untracked and unstable mechanisms of writing reports and scripts to a Git Based solution to track and stabilize reports. Overall reduction in man-hours,
    infrastructure cost and deeper insights and tracking for the reports being sent throughout the organisation.
  • Basket Removal : Analysed the trends and behaviour of customers removing products from their cart throughout the day over a period of time in order to avoid fraud and reduce cost of maintaining inventory.
  • Dashboards : Created over 25+ dashboards for senior management, covering a wide range of key metrics including digital conversion rates, offline conversion analysis, referral summaries, customer segmentation, product funnel performance.
  • Automation : Automated Trackers for the Growth Team giving the units more time for working on strategy rather than waiting and crunching for numbers on Excel. Observed an overall increase of 150% in daily orders.

Associate Analyst

Vaco Binary Semantics LLP
Gurgaon
01.2020 - 07.2020
  • Crawling and Extracting structured and unstructured data from external websites with manually written, regular expression based scripts (using Python and Crawzal) in order to enhance Knowledge Graph Database
  • Transforming crawled information into structured format using Python
  • Created a few python scripts which extracts unstructured data of movies released worldwide from different APIs and then the data from these APIs has been linked through some predefined parameters and at last the data was converted into a structured format as requested by the client.

Education

Post Graduate Program in Data Science and Engineering -

Great Lakes Institute of Management
08.2021

B.Tech Mechanical Engineering -

Noida International University
07.2018

Skills

  • Python
  • SQL
  • Data Visualization
  • Data Studio
  • Tableau

Timeline

Data Analyst (Product Development)

FuelBuddy - Tries Solution LLP
09.2023 - Current

Data Analyst (Growth)

Milkbasket - Reliance Retails
12.2021 - 08.2023

Associate Analyst

Vaco Binary Semantics LLP
01.2020 - 07.2020

Post Graduate Program in Data Science and Engineering -

Great Lakes Institute of Management

B.Tech Mechanical Engineering -

Noida International University
Harshit Bharrdwaj