KAUSHAL KISHOR
@kaushal.kishor
Assistant Consultant at Tata Consultancy Services Ltd
Mumbai, Maharashtra, India
Kaushal Kishor is a seasoned data professional with 10 years of experience specializing in cloud data warehousing and ETL solutions. He possesses deep expertise in Microsoft Azure Data Factory, Synapse, Power BI, and Snowflake. His background includes migrating legacy on-premises applications to Azure cloud using IaaS and PaaS models, coupled with proficiency in complex SQL query optimization and development.
Experience
Assistant Consultant
Tata Consultancy Services Ltd
Managed multiple data migration and warehousing projects, including migrating legacy databases (Oracle, SQL Server 2002/2005, MS Access) to Azure cloud using IaaS & PaaS models. Developed SSIS packages and performed DBA activities, implementing TDE certificates and performance tuning. Key projects involved setting up Azure Data Factory pipelines for ingesting data into Snowflake and Azure Synapse, utilizing pyspark and Delta Tables for ETL. Responsibilities included designing SSIS packages, developing T-SQL stored procedures, and building complex reports using SSRS and Power BI.
Associate Software
Synechron Technologies
Developed modules for the Tullow Oil website using Sitefinity modules, MVC4 razor, and Sitefinity APIs, including image gallery and result listing documents.
Software Developer
Lake Water Software Pvt. Ltd.
Conducted conversion of Oracle Database to SQL Server 2008, including views, procedures, and tables. Developed front-end components to display SSRS reports using MVC and C#.
Bi Developer
A Connexion Bpo Services Private Limited
Supported BI applications by writing SQL queries, functions, and stored procedures. Generated reports using MicroStrategy ETL tool and created indexes for query optimization.