Summary
Overview
Work History
Education
Skills
TOOL
Personal Information
Languages
Disclaimer
Accomplishments
Certification
Timeline
Generic

Karthikeyan Anandan

Chennai

Summary

Dynamic Snowflake Developer with over 5 years of expertise in Snowflake Data Warehousing and PL/SQL. Proficient in Oracle SQL, ETL tools, adept at driving project success through process optimization. Actively contribute to decision-making within Toyota-USA Retail,, ensuring seamless AWS-Snowflake integration and robust data management strategies. Known for professional demeanor, articulate communication, and collaborative approach.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Senior Snowflake Developer

Cognizant Technology Solutions
03.2022 - Current
  • Orchestrated critical data migration projects from Oracle databases to Snowflake, ensuring seamless transitions and minimal disruption
  • Developed and optimized Snowflake objects and dashboards, amplifying business analysis efficiency by 15%
  • Integrated performance-tuning measures, achieving a 94.4% reduction in job run times and cutting duration by 17 hours
  • Engineered Snowflake procedures, functions, and User Defined Table Functions (UDTF) for enhanced functionality
  • Mastered Snowflake object development encompassing warehouses, schemas, databases, tables, views, pipes, stages, and scaling policies
  • Implemented Snowpipe for AWS cloud integration, ensuring smooth data flow and consistency
  • Utilized Oracle PL/SQL procedures for data validation, ensuring functional dependency and identifying technical errors.

Snowflake Developer

Pointel Technologies
06.2019 - 03.2022
  • Engineered PL/SQL solutions including packages, procedures, functions, triggers, and exception handling for efficient data retrieval, manipulation, validation, and migration
  • Optimized Oracle PL/SQL query performance through indexing, partitioning, and tracing techniques, resulting in enhanced system efficiency
  • Translated business requirements into technical SQL queries and subqueries utilizing analytical functions, joins, and operators for effective data processing
  • Implemented Snow Pipe to ensure continuous data integration between AWS S3 and Snowflake DB, facilitating seamless data flow across Oracle and Snowflake environments.

Education

B.E Mechanical Engineering -

Mookambigai College of Engineering
01.2019

Skills

  • SQL (ORACLE)
  • POSTGRE SQL
  • PL/SQL
  • SNOW FLAKE
  • UNIX
  • SCALA
  • AWS

TOOL

WINDOWS, SNOWFLAKE, ORACLE 10g/11g, SNOWSQL, SQL, PL/SQL, TOAD, SQL DEVELOPER,
JIRA, TALEND,STONE BRANCH, AWS,DATABRICKS,DVS

Personal Information

  • Title: Senior Snowflake Developer
  • Date of Birth: 01/07/1997
  • Marital Status: Unmarried

Languages

English, Tamil, Hindi

Disclaimer

I hereby declare that the above provided details are true to the best of my knowledge.

Accomplishments

  • The Raising Star

Certification

Certified in Oracle SQL

Timeline

Senior Snowflake Developer

Cognizant Technology Solutions
03.2022 - Current

Snowflake Developer

Pointel Technologies
06.2019 - 03.2022

B.E Mechanical Engineering -

Mookambigai College of Engineering

Similar Profiles

CREATE PROFILE
Karthikeyan Anandan