Summary
Overview
Work History
Education
Skills
Interests
Timeline
Generic
Vasi Sultan

Vasi Sultan

Gurgaon

Summary

Technology Lead with 8 years of overall experience which includes experience of working on technologies/tools like Azure Synapse Analytics , Oracle PL/SQL , Microsoft Power BI , Azure DataBricks and Azure DevOps.

Overview

8
8
years of professional experience

Work History

Azure Data Engineer

Infosys Limited
Gurgaon
08.2021 - Current

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.

Oracle PL/SQL Developer

Extended Ventiv Risk Services Pvt. Ltd
Noida
02.2019 - 08.2021

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.

Oracle PL/SQL Developer

Magnaquest Technologies Ltd
Hyderabad
09.2018 - 02.2019

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.

Oracle PL/SQL Developer

Cognizant Technology Solutions
Kolkata
01.2016 - 08.2018

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.

Education

Bachelor Of Technology -

Jaypee University of Engineering
Guna, Madhya Pradesh
06.2015

Senior Secondary Examination -

Board Of Secondary Education, Rajasthan
Kota, Rajasthan
05.2010

Secondary Examination -

Board Of Secondary Education, Rajasthan
Kota,Rajasthan
05.2008

Skills

  • Azure Synapse Analytics
  • Oracle SQL & PLSQL
  • Synapse SQL/T-SQL
  • Synapse Dedicated SQL pools
  • Synapse Serverless SQL pools
  • Synapse Pipelines/Azure Data Factory
  • Azure Blob Storage
  • ADLS Gen2
  • Delta Lake
  • Azure Data Bricks
  • Spark SQL
  • Azure DevOps
  • Power BI
  • PySpark
  • Git Bash
  • Git Repository
  • Data Warehouse
  • Azure Portal
  • Agile Methodology

Interests

  • Learning new skills
  • Listening to music
  • Gardening
  • Travelling
  • Cricket

Timeline

Azure Data Engineer

Infosys Limited
08.2021 - Current

Oracle PL/SQL Developer

Extended Ventiv Risk Services Pvt. Ltd
02.2019 - 08.2021

Oracle PL/SQL Developer

Magnaquest Technologies Ltd
09.2018 - 02.2019

Oracle PL/SQL Developer

Cognizant Technology Solutions
01.2016 - 08.2018

Bachelor Of Technology -

Jaypee University of Engineering

Senior Secondary Examination -

Board Of Secondary Education, Rajasthan

Secondary Examination -

Board Of Secondary Education, Rajasthan
Vasi Sultan