pavana yanamandala

Designed and delivered a scalable, cloud-native regulatory reporting and risk data platform using Snowflake and dbt. Modernized legacy, hard-coded ETL processes by implementing dbt-driven transformation frameworks built on modular, reusable, and fully testable SQL models. Established enterprise-grade data quality, documentation, lineage, and CI/CD standards through dbt tests, snapshots, macros, and version-controlled deployments. Engineered resilient Apache Airflow orchestration with dynamic DAGs and Python operators to manage end-to-end regulatory and credit-risk data pipelines. Drove Snowflake performance tuning and cost optimization via query profiling, clustering, and warehouse right-sizing. Applied DataOps and reliability practices to deliver governed, auditable, and AI-ready datasets while collaborating across domain teams and mentoring junior engineers. Contributed to AI RAG proof-of-concept.

Designed and delivered end-to-end data pipelines on Snowflake leveraging Snowpipe, Streams, Tasks, Time Travel, Zero-Copy Cloning, and performance optimization techniques to process large-scale healthcare datasets. Integrated Azure Blob Storage as external cloud storage for secure ingestion, staging, and archival using Snowflake external stages. Developed curated data models using Snowpark (Python) with strong emphasis on scalability and reusability. Implemented RBAC and data-masking policies to meet HIPAA and healthcare governance requirements. Enabled analytic-ready datasets and business insights through Power BI reporting.

Designed and delivered scalable data pipelines using Azure Databricks to ingest, cleanse, and process clinical trials, drug safety, manufacturing, and supply-chain data. Implemented Delta Lake–based architectures with optimized storage formats and advanced transformation logic to support high-volume, regulated datasets. Developed notebook-driven frameworks, job clusters, and automated workflows with embedded QC and validation rules aligned to pharmaceutical compliance standards. Produced curated analytical layers integrated with Azure services to enable regulatory submissions, R&D analytics, and commercial insights.