Bhuvan kumar

Managed and supported ETL processes for large-scale Snowflake cloud data warehouses, ensuring timely weekly, monthly, and quarterly status reporting to clients.

Executed end-to-end data integration with third-party tools, encompassing architecting, designing, coding, and testing phases.

Optimized complex SQL queries and views, enhancing performance and ensuring data security within and outside Snowflake environments.

Applied extensive expertise in Snowflake concepts including Snow SQL, Snowpipe, Streams, Time Travel, Optimizer, Data Sharing, and Stored Procedures to deliver robust solutions.

Performed comprehensive data integration with third-party tools, overseeing architecting, designing, coding, and testing phases for robust data pipelines.

Engaged regularly with teams to provide status reports and manage routine activities, ensuring project alignment and transparency.

Designed and implemented Data Warehouse star and snowflake schemas, including Dimensions, Facts, and Data modeling for efficient data organization.

Gathered and analyzed project requirements, developing materialized and secure views to support diverse reporting needs.

Automated data loading and unloading processes between Snowflake data warehouse and AWS S3 by creating efficient task flows and automated scripts.

Conducted performance tuning for sessions, mappings, and PL/SQL procedures, significantly improving data processing efficiency.

Provided critical production support, including troubleshooting, data analysis, and resolving ad-hoc requests by collaborating with business analysts and clients.

Managed various Snowflake administrative roles (account, security, user, sysadmin) and developed custom roles to enhance security and access control.

Utilized COPY/INSERT, PUT, GET commands for efficient data loading from internal/external stages and bulk loading/unloading large datasets (JSON, ORC, PARQUET CSV) into Snowflake tables.