Vasi Sultan

Project: LAM Research

• As an Azure Data Engineer converted Alteryx workflows into stored procedures of dedicated SQL Pool. Wrote complex SQL queries, performed data transformation on CSV files using Spark SQL of Azure Data Bricks and created synapse pipelines to bring data from Azure SQL DB .Scheduled execution of these procedures using synapse pipeline.
• Developed stored procedures on dedicated SQL Pool which join and transform data of the multiple staging tables and do the incremental data load in destination tables following the concepts like high-watermark.
• Involved in creating the medallion lake house on serverless SQL pool by developing stored procedures which brings the data from ADLS Gen2 account into different data layers like bronze, silver and gold using concepts like external tables ,views and Openrowset function. Involved in creating synapse pipeline to execute these procedures on daily basis.
• Created Azure DevOps pipeline to move published Synapse workspace changes from Dev to QA and Prod environment.

Project: PSO Consulting

• Created Business Rules and Formulas for more than 50 clients by creating oracle database objects like functions , procedures and Packages.
• Used other PL/SQL concepts like Loops, Conditional Statements, Cursor,Exceptions, Records, Nested Tables, Varrays and Dynamic SQL as per the required logic of business rules and formulas.

Project: Independent TV

• Created oracle database objects like functions, procedures, sequences,triggers, views and tables etc.
• Identified need of code changes for already existing database objects.
• Wrote complex SQL queries and various DML,DDL and TCL statements.

Project: Cambridge Assessment

• Developed oracle database objects like tables, views, Sequences, Synonyms, procedures, function, procedure, packages, collections, Cursor and Triggers etc
• Checked execution plan of bad performing SQL statements and took the corrective actions. Suggested changes in execution plan to optimizer through various Oracle hints.