A

Adarsh Bhandari

About

Detail

Actively Seeking Full-Time Roles | MS in Big Data @SDSU | Ex- TCS | Data Engineer | Data Analyst | Software Engineer | Business Analyst | Business Intelligence
Chula Vista, California, United States

Contact Adarsh regarding: 
work
Full-time jobs

Timeline


work
Job
folder
Project

Résumé


Jobs verified_user 0% verified
  • F
    Data Engineer
    Freddiemac
    Mar 2024 - Current (2 years 8 months)
    • Designed and implemented a fully operational production-grade data solution on Snowflake Data Warehouse, processing 20 terabytes of data per day, resulting in 28% improvement in data processing speed compared to the previous system. • Migrated 3 on-premises big data workloads to AWS, leveraging S3 and Python for structured and semi-structured data ingestion and processing, leading to 20% cost reduction and 8% increase in data availability. • Designed and implemented data aggregations on Hive for ETL processing on Amazon EMR, handling 10 data sources and processing 10% terabytes of data per month, meeting all business requirements for data analysis. • Migrated data from MySQL to Hadoop using Sqoop, evaluated the performance of 3 algori
  • ResMed
    Data and Analytics Intern
    ResMed
    May 2023 - Aug 2023 (4 months)
    • Facilitated daily stand-ups, sprint planning sessions, and retrospectives, enhancing team performance by 20% . • Optimized data extracts for customized Tableau dashboards, updated 15+ KPIs regularly, and improved customer acquisition by 7% . • Industrialized TensorFlow-based machine learning models, achieving 90% accuracy for predictive maintenance applications. • Achieved a 15% increase in resource allocation efficiency and 2x improvement in deployment using a container for data and statistical analysis by collaborating with different stakeholders and KPI analysis.
  • T
    System Engineer/Data Engineer
    Tata consultancy services,
    May 2021 - Jul 2022 (1 year 3 months)
    • Directed multi-team collaboration to outline project specifications and design scalable data pipelines, resulting in 30% faster data processing and a 25% increase in system reliability. • Engineered and fine-tuned SQL queries to enhance ETL processes, resulting in a 45% reduction in data processing time and a 30% increase in data accuracy from diverse sources. • Enhanced performance of Hive & Apache Spark jobs, achieving a 30% improvement in query execution and overall data processing efficiency. • Improved database performance by optimizing schemas & queries in MySQL & PostgreSQL, resulting in notable 25% improvement in query efficiency. • Added to GitLab open-source projects, promoting coding best practices and collaboration within
  • K
    Data Engineer Associate
    KellTon,
    Aug 2019 - Apr 2021 (1 year 9 months)
    • Cleaned and structured huge unstructured data for data analysis, resulting in 10% increase in accuracy and 15% reduction in processing time. • Developed & implemented 8+ data pipelines & workflows, automating data processing & reporting, leading to a 40% reduction in manual effort. • Extracted and visualized data insights from 3+ databases, creating compelling data stories that led to 15% increase in sales. • Generated 10+ reports & summaries for stakeholders by SQL analysis of data from external & internal sources, that supported growth in KPIs. • Developed data models, resulting in 5% reduction in data redundancy.
Education verified_user 0% verified
  • M
    Bachelor of Technology
    Medi-Caps University
  • San Diego State University
    MS
    San Diego State University
Projects (professional or personal) verified_user 0% verified
  • B
    Baseball Win Game Prediction
    Jan 2023 - May 2023 (5 months)
    • Analyzed 7M+ baseball records, engineered 40+ predictive features from MariaDB using SQL, and achieved 67% accuracy across Machine Learning models such as Random Forest, SVM, and Logistic regression. • Employed linters to refine code for seamless deployment and containerized the project with Docker.
  • C
    Customer Churn Analysis
    • Designed a dashboard to analyse 20.37% churn rate among 10k users using multiple KPIs for 3