SRILATHA BHAT

Coco-Cola Bottler Sales & Services - North America

• Responsible for Migrating T-SQL reports to Snowflake DB.
• Experience in data loading to Snowflake using SnowSQL CLI.
• Creating procedures on snowflake to transform data according to business requirements.
• Automating procedures using Snowflake Tasks .
• Experience in Data ingestion to Snowflake from CSV.
• Performed scheduling jobs on SQL server to automate ETL loads using SSIS from Snowflake.
• Responsible for data validation between HANA source and Snowflake source.
• Basic knowledge on developing reports on Power BI for analytics purposes from Snowflake.
• Responsible for giving design and approaches for new modules/ Change requests.

TUI Travels Project: Cyrus Next Gen

Cyrus is the revenue management system for TUI UK and Ireland

• Designed and implemented strategy to secure data pipelines into a Snowflake data warehouse from on premise and cloud data sources
• Creating warehouses, stage and UDF in Snowflake
• Good Knowledge in Snowflake Role Access Management
• Planned and executed migration of existing PL/SQL code to Snowflake SQL using agile methodologies, resulted in reduction of project time
• Experience in Data ingestion to Snowflake from CSV/JSON through S3 bucket
• Design and implementing ELT jobs on Apache Airflow
• Automation of ingestion pipelines and unit test cases for Snowflake using Python
• Collaborated with cross-border clients and led team of 3 engineers to integrate data pipelines and defined scheduling, compiled unit test cases using Unit Test Framework in Python
• Knowledge on Snowflake Snowpipe feature implementation
• Good Understanding on Snowflake operations like COPY, PUT, GET, Zero Copy Cloning etc.
• Experience in Data extraction from Oracle database using in-house built ETL tool in Python
• Familiar with Git,GitLab,GitBash, Eclipse, Jenkins

Tech stack: Snowflake on AWS, GitLab, Apache Airflow, Custom Python ELT-Framework, AWS services

Delivery coordinator

TUI GROUP is the world's number one integrated tourism business operating in around 180 countries worldwide

• Coordinating with onshore and offshore teams in getting release deployed to PAT, Production environments
• Assist in solving business critical production issues with quick turnaround time
• Acted as liaison between offshore and business team
• Supporting business teams during UAT testing
• Support critical issues in production environment
• Support for readiness of new database environment

TUI Travels Project: Cyrus

Cyrus is the revenue management system for TUI UK and Ireland

• Responsible for giving design and approaches for new modules/ Change requests
• Developed PL/SQL packages, Index, Views, and complex Stored Procedures, appropriate functions and effective Triggers, External Tables to facilitate efficient data manipulation and data consistency and to implement business logic for new modules / Change requests
• Used Bulk collection for better performance and easy retrieval of data by reducing context switching between SQL and PL/SQL engines
• Resulted in better performance
• Extensively used bulk table partitioning, DBMS_parallel_execute to enhance performance
• Extensively used advanced features of PL/SQL like Records, Tables, Object Types and Dynamic SQL.
• Handled errors using Exception Handling extensively for ease of debugging and display error message
• Performed SQL and PL/SQL tuning using explain plan and partition tuning.