Harisai Mandalapu

Data Engineer @Liya Technologies Ltd

Bexleyheath, GB

Experienced Data Engineer with a proven track record in developing data solutions leveraging Power BI, MSBI (SSRS, SSAS, SSIS), and a range of Azure Data tools including Azure Data Factory, Azure Databricks, Azure Synapse Analytics, and Azure SQL Database. Skilled in all stages of the data lifecycle, from data modelling to infrastructure automation, with a focus on enabling continuous integration and delivery of BI solutions.My hands-on experience extends to ETL pipeline development using Azure Data Factory, loading data into Azure SQL Database from multiple sources and ensuring secure credential management with Key Vaults. I specialize in migrating SQL databases to Azure cloud storage solutions like Azure Data Lake Storage, Azure Data Lake Analytics, and Azure SQL Data Warehouse.In addition to my expertise in SQL programming for optimization and complex queries, I have a solid foundation in Python scripting, developing and maintaining Python applications for various projects. I\'ve collaborated closely with data engineers and data scientists, integrating PySpark solutions into production systems and optimizing PySpark applications on Databricks to significantly reduce costs.My versatility extends to tasks like developing stored procedures, functions, and triggers, as well as ad-hoc queries for reports across SQL Server and Oracle databases. I excel in SQL Server performance tuning and query optimization, ensuring efficient data processing and retrieval.With a flexible, enthusiastic, and project-oriented approach, I thrive in collaborative environments, leveraging my strong communication and leadership skills to develop creative solutions for challenging client needs.

University of Exeter

Master's in Data science

Sree Vidyanekathan Engineering College

Bachelor of Technology (BTech)