Designed Data Modeling, Design Specifications and to analyze Dependencies.Created Snowflake stored procedures, Python scripts for data migration from different sources to Snowflake. Migrated the data from Oracle to Snowflake using Data Bricks.

Gathering requirements from product-application teams, JIRA, Confluence.Interacting with customers through Emails and Slack calls. Creating Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, functions, Packages, Cursors, Ref Cursor, Collections as per the Business requirements.Writing complex SQLs to extract data directly from DB Server to produce XMLs, Jason format data.Writing SQL queries and creating flat tables to move data to different DB’s and Schemas by using Snowflake.

Worked on all stages of Application implement.Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.

Performed initial impact analysis for providing L0 sizing for new enhancementsCollected User Requirements by participating in meetings and studying existing System.Prepared Technical design and Understanding documents for new enhancements. Also created traceability matrix documentation.Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, functions, Packages, Cursors, Ref Cursor, table types as per the Business requirements.

Worked in SLA project.Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from Oracle-8i database to Oracle 11G database.Tracked tickets by using HP ALM tool and resolved issues by accessing database.Modified existing Oracle objects.Created various DML and DDL statements using Oracle Pl/SQL and SQL.