Tamizharasan Thangam

⦁ Data Migration from Oracle Database to Snowflakes using Flat files for application Migration from Oracle DB to Snowflake.
⦁ Experience in Snowflakes Object Development such as warehouses, Schemas, Database, Tables, Views, Pipes, Stages, Scaling Policies
⦁ Utilization, Roles. Data migration for Structured Data: By creating Stage & Copy, Transforming
⦁ Data, Copy on Error, File Format & all Copy Options.
⦁ Have hands on Experience on Loading Unstructured data on minimal load using VARIANT Datatype, Flatten, Parquet, etc.
⦁ Developed Snowflake Procedures, Functions and UDTF (User Defined Table Function)
⦁ Created External table to access the data from the files, when the file access is denied in AWS S3.

UTL_FILECommOps

⦁ Created PL/SQL packages, procedures, functions, triggers, and exception handling for retrieving, manipulating, checking and migrating complex data sets.
⦁ Optimize query and performance tuning using indexing, partitioning, tracing query, collections in oracle PLSQL.
⦁ Converted the business need into technical complex SQL queries and subqueries using analytical functions, joins, operators.
⦁ Created Snow Pipe to read the data from the AWS S3 and loaded the data to Snowflake DB to ensure the continuous data integration between the oracle and snowflake DB.
⦁ Created snow tasks as task tree to read the data from the snow stream objects which are created on the base table, to maintain the backup of data while happening DML operation in the target snowflake DB.
⦁ Used secure views and materialized views to share the data to the partner application as per the data requests..

⦁ Involved in both Development Enhancement and Production Support activities.
⦁ Lead a team and met timeline as per commitment for deliverables.
⦁ Experience in implementation cum support for fortune clients. Handled Incident and problem management on L1/L2 Level of tickets.
⦁ Worked on Incident management (IM) tool of various SLA and ensured the fixes were done.
⦁ Create work plan for change control and Implemented in test validation and Production environment.
⦁ Coordinated with the Distributed team to provide them with the necessary stored procedures and packages and the insight into the data.
⦁ Created shell scripts for invoking SQL Scripts and scheduled them using crontab.
⦁ Worked on SQL* Loader and UTL_FILE to load data from flat files obtained from various facilities every day. Created and modified UNIX shell scripting according to the changing needs of the projects and client requirements.
⦁ Involved in continues enhancement and fixing of product problem. Generated server side PL/SQL script for data manipulation and validation and MVs for remote instances.
⦁ Developed scripts to create new tables, views, queries for new enhancement in the application using SQL DEVELOPER. Created indexes on the tables for faster retrieval of the data to enhance database performance..
⦁ Handles errors using exception handling for the ease of debugging and displaying the error messages in the application.
⦁ Collaborated with product management to design, build and test systems.
⦁ Developed code fixes and enhance for inclusion in future code releases and patches.