Pranav Adhav

Pranav Adhav

IT / Data Engineering Intern

Followers of Pranav Adhav1000 followers
location of Pranav AdhavUnited States

Connect with Pranav Adhav to Send Message

Connect

Connect with Pranav Adhav to Send Message

Connect
  • Timeline

  • About me

    Data Engineer | Information Systems @Northeastern University

  • Education

    • Northeastern University

      2021 - 2023
      Master's degree Information Systems
    • K.K.Wagh institute of Engineering Education & Research

      2014 - 2019
      Bachelor of Engineering - BE Electrical, Electronics and Communications Engineering
  • Experience

    • Wayfair

      Jan 2023 - Aug 2023
      IT / Data Engineering Intern
    • Met Life

      Feb 2024 - Apr 2024
      Data Engineer

      Developed a sophisticated risk assessment model for insurance, leveraging big data to improve risk prediction accuracy by 25%. • Designed and developed a centralized data warehouse architecture on Snowflake, optimizing data storage and retrieval for enhanced analytics efficiency and predictive analysis capabilities. • Created an end-to-end ETL pipeline to seamlessly move data from OLTP database (PostgreSQL) to Snowflake data warehouse, streamlining data integration processes. • Utilized Python for extracting data from PostgreSQL, performing data cleaning, aggregation, and transformation to prepare it for analysis. • Implemented data staging on AWS S3 to efficiently store and manage intermediate data before ingestion into Snowflake, optimizing data processing workflows. • Leveraged Snow pipe for automatic ingestion of staged data into Snowflake, ensuring real-time updates and minimal latency in data availability. • Reduced the time to insights for business analysts by automating data preprocessing and enrichment, increasing productivity by 50%. • Implemented Change Data Capture (CDC) mechanisms to capture incremental changes from the source database, facilitating efficient data synchronization. Show less

  • Licenses & Certifications