Adithya Malladi

Data Science Grad @ UMass | Analytics & Data Science Professional | AI Enthusiast

Data Analyst with 2 years of Demonstrated Experience, Proficient in SQL, Python and Tableau. Expertise in creating & maintaining dashboards, data storytelling and building ML models to drive actionable insights.

Work Experience

Data Analyst

Airmeet | Remote, India | 09/2022 - 09/2023

HubSpot CRM Snowflake SQL Machine Learning Tableau Storytelling & Visualization
  • Designed and Automated the Sales funnel from Lead Generation to Pipe Conversion. Insights at every stage of the funnel have helped the company to scale pipeline generation by 30%.
  • Built Churn Model using Decision tree to identify probable churn customers and refined strategies for Retention by identifying top KPIs of the recurring customers. The model has been working with a Recall of 80%.
  • Leveraged HubSpot CRM & Snowflake DB for creating new reports on User Acquisition supporting ad hoc requests for sales & marketing leadership.

Data Analyst

PharmEasy | Bangalore, India | 01/2022 - 06/2022

SQL Python Microstrategy Reporting Apache Airflow AWS Services(S3, Redshift) Hive
  • Engineered an end-to-end pricing system by implementing advanced SQL techniques to process daily pricing data of 50+ product categories across 400+ cities. Developed automated MSTR dashboard enabling business teams to monitor competitor pricing patterns, resulting in 15% optimization in Private Label product pricing and improved market competitiveness.
  • Architected scalable data pipelines between Redshift and Hive Db's using Apache Airflow & Python, automating complex ETL workflows. Reduced manual data processing time by 70% while ensuring data consistency across platforms.
  • Created customers purchase pattern analysis across 6+ GMV ranges using aggregations and bucketing techniques. Uncovered key price sensitivity insights enabling targeted marketing strategies and improved inventory planning.

Technical Skills

Programming

SQL Python R Core Java & OOPs UNIX Commands

Business Intelligence

Tableau PowerBI MS Excel HubSpot CRM Micro Strategy

Data Science

Machine Learning NLP Deep Learning AWS MongoDB Data Analysis

Other Technical Skills

Matlab Web Development Stack - HTML, CSS, Javascript, PHP Android Application Development - Java & Android Studio UI & UX Design - Figma

Academic Journey

Master's Degree in Data Science

University of Massachusetts Dartmouth

09/2023 - 12/2024 (Expected) | CGPA: 4.0/4.0

Relevant Coursework: Business Analytics & Data Mining, Big Data Analytics, Advanced Machine Learning, Artificial Intelligence, Statistics , High Performance Scientific Computing

Bachelor's Degree in Computer Science

VIT AP University, India

09/2018 - 09/2022 | CGPA: 3.45/4.0

Relevant Coursework: Data Structures & Algorithms, Web Technologies, Software Engineering, Cloud Computing, Android App Development

Academic Projects

Clustering Analysis on Pharmaceutical Data

R Clustering

Implemented hierarchical and k-means clustering analysis on 21 pharmaceutical companies using 9 key financial indicators. Applied data normalization and optimization techniques to identify three distinct company clusters (high, mid, and low performers), revealing strategic groupings based on market capitalization, profitability, and leverage metrics.

Zillow Housing Data Analytics

Python Tableau AWS Services(S3,EC2,Redshift DB) Apache Airflow

Automated ETL pipeline for Zillow housing data using AWS services (S3, Lambda, Redshift) and Apache Airflow from data extraction to data warehouse storage. Developed interactive Tableau dashboard to visualize and analyze housing market trends from processed data.

Flight Fare Prediction

Python Machine Learning Web Scraping

Built & Trained Random Forest model in Scikit-learn to predict flight fares with an accuracy of 87%. Extracted data from the live flight booking website called Kayak by utilizing BeautifulSoup and Selenium WebDriver in Python.

E-Commerce Database Management System

MySQL HTML & PHP

Developed an Ecommerce Database Management System, creating tables, relationships, and constraints. Implemented CRUD operations using MySQL and designed a user-friendly website UI using HTML & PHP for data input and management, enabling users to perform CRUD operations from the frontend.

Get in Touch