Girish Prabhu P

PROJECT - 1

DOMAIN : BANKING

CLIENT : Commerzbank

• Executed bulk loading from external (AWS S3) and internal stages into Snowflake the COPY command.
  
• Managed data utilization, roles, and structured data migration by creating stages followed by transformations.
  
• Built Snowflake streams on base tables to enable data capture and backup during DML operations in target databases.
  
• Deployed Snowpipe for continuous, automated data ingestion from AWS S3 buckets.
  
• Designed a structured task tree using Snowflake tasks to process data from stream objects.
  
• Leveraged zero-copy cloning by creating clone objects for efficient data duplication.
  
• Applied the FLATTEN table function to generate lateral view ARRAY columns.
  
• Implemented secure views and materialized views to applications

PROJECT - 2

DOMAIN : HEALTHCARE

CLIENT : ARKRAY HEALTHCARE

• Designed and deployed scalable Snowflake cloud data warehouses to enable healthcare analytics.
  
• Engineered automated ETL/ELT pipelines with Snowpipe for seamless AWS S3 data ingestion.
  
• Leveraged Snowflake Streams and Tasks to enable efficient incremental data processing.
  
• Created advanced Snowflake SQL transformations to power reporting and analytics workflows.
  
• Optimized virtual warehouses and queries, achieving ~20% reduction in compute costs.
  
• Applied Time Travel and Zero-Copy Cloning for robust data recovery, testing, and deployment validation.
  
• Delivered production support, including data quality checks, monitoring, and SLA-driven issue resolution.