Sowjanya Deva

Master's

Data Analytics

Massanutten Resorts

Data Engineering

• Expertise in designing and maintaining data warehousing solutions, including leveraging Amazon Redshift and Snowflake. • Deployed an AWS DDK/CDK solution integrated with a data lake across multiple accounts (dev and prod) and created Amazon marketing cloud SQL-based use cases to uncover 10% additional media effectiveness on Amazon Advertising for a Fortune 100 food & beverage company. • Implemented MLOps practices to integrate machine learning workloads with existing databases seamlessly, improving model deployment speed by 50% and enhancing the accuracy of predictive analytics by 15%. • Enhanced data governance and security with AWS Lake Formation filters and Quicksight, ensuring industry-standard compliance • Major pipelines include reading and writing into S3, Athena queries on S3 and Glue catalog, loading into Redshift, and executing ETL transformations using customized EMR clusters. • Orchestrated the integration of diverse data sources into the Snowflake data warehouse, incorporating Change Data Capture (CDC) to ensure real-time data availability. • Conducted a POC (proof of concept) on Apache airflow version 2.2.2 for backward compatibility with version 1.10.12