Iswarya Pradeep Kumar

Client: Citi Bank (Tata Consultancy Services – BFSI Domain)

Project: Data Warehouse Modernization & Real-time Analytics

• Migrated enterprise data from Oracle to Snowflake using flat file staging and custom file formats.
• Built core Snowflake objects: Warehouses, Tables, Views, Stages, Pipes, Streams, Tasks, and External Tables.
• Developed real-time ingestion pipelines using Snowpipe and multi-step Task Trees for change data capture (CDC).
• Processed complex semi-structured data (JSON, Parquet) using VARIANT and FLATTEN.
• Created Stored Procedures, UDFs, and UDTFs to automate business logic and transformations.
• Implemented row-level security, data masking, and RBAC for PII protection and compliance.
• Used Time Travel, Fail-safe, and Cloning for backup, audit, and environment provisioning.
• Built and maintained DBT models to transform raw data into clean data marts, added DBT tests to ensure accuracy, and automated DBT runs and documentation using Git and Jenkins.
• Optimized workloads via Query Profiling, warehouse tuning, and auto- suspend/resume setup.
• Integrated Snowflake with Power BI and Tableau for real-time reporting.

Client: Standard Charted Bank

Project: Snowflake Data Lake & Reporting Framework

• Designed and implemented Snowpipe for real-time data ingestion from AWS S3.
• Built Task Trees and Streams to automate audit logging. Created Secure and Materialized Views for row-level security and reporting performance.
• Established backup and disaster recovery strategies with regular testing.
• Performed SQL optimization and fine-tuning of warehouse performance.
• Migrated legacy ETL pipelines to Snowflake-native solutions, improving performance by 30%.

Client: Standard Charted Bank

Project Name: Data Migration and Core Banking PL/SQL Modules

• Developed critical Oracle PL/SQL components (procedures, packages, triggers).
• Optimized complex SQL queries and analytical functions for reporting.
• Led large-scale data migration projects ensuring accuracy and minimal downtime.
• Integrated PL/SQL logic with front-end systems via APIs and database links. Conducted code reviews and performance tuning to enhance efficiency.

• Processed SWIFT RMA requests and performed static data maintenance.
• Handled setup, amendment, and deletion of RMA activities.
• Managed message routing, EOD/SOD operations, and reconciliations.
• Trained team members and implemented automation improvements.