Balakrishnan Ramasamy

Domain : Insurance

Client : AllianzGI

Environment : Oracle,AWS S3, Snowflake DB

• Designed and optimized Snowflake data pipelines, including Snowpipe, Streams, and Tasks for seamless data integration and automation.
• Migrated large-scale structured and unstructured data from Oracle to Snowflake, ensuring data accuracy and integrity.
• Built Star Schema models with Fact and Dimension tables to support business analytics and reporting.
• Developed and maintained ETL pipelines using IICS, ensuring efficient and reliable data processing.
• Automated workflows using Jenkins and CI/CD pipelines for smooth deployment and integration.
• Implemented Time Travel and Fail-Safe features to recover critical data during accidental deletions.
• Used Secure Views and Materialized Views for data sharing with external stakeholders while maintaining data privacy.

Client: Comerica Bank

Domain: BFSI

Environment: Snowflake DB,ORACLE,AWS S3

• Created Snowflake Procedures, Functions, and UDTFs for efficient data validation and transformations.
• Designed PL/SQL packages, procedures, and triggers to support robust data processing workflows.
• Migrated data from legacy systems to Snowflake using flat files and optimized pipelines.
• Utilized indexing and partitioning techniques to enhance query performance.
• Created audit trails using Streams and Tasks to back up critical data during DML operations.
• Implemented Zero-Copy Cloning for development and testing environments to minimize storage usage.
• Conducted performance tuning and optimization for complex queries, ensuring efficient data processing.
• Automated data ingestion from AWS S3 to Snowflake using Snowpipe and external stages.
• Developed Snowflake schemas, databases,tables, and roles to support data governance.
• Used DBT for ELT transformations, ensuring data quality and consistency across pipelines.
• Monitored data processes and resolved incidents using Datadog and PagerDuty to ensure system reliability.
• Built dashboards and reports using Tableau to provide actionable insights for business stakeholders.