Pranav Adhav

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