Sai Gowtham Challa

About Sai Gowtham Challa

Having an experience of 10+ years with knowledge on the Upstream and Downstream Oil and Gas domain, Azure SQL, Azure Databricks, Power BI, ADF, Power Apps.Working as a Data Engineer for the Upstream and Downstream Oil and Gas projects. Collaborated with business teams and technical analysts to understand business requirementsand convert into functional and nonfunctional requirements.Working on the Upstream, mid stream and downstream data processing by connecting with thebusiness on the requirements.In the Downstream, especially for the refinery data, we collaborate with the business on theAsset Management data which is in the new SAP S4 and do the data processing as therequirements.Data integration across On-prem & cloud and experience on data warehousing systems withinMicrosoft Azure, including Blob storage, Azure Data Lake, and Azure Data Factory.Hands on experience on Unified Data Analytics with Data bricks, Data bricks Workspace UserInterface, Managing Data bricks Notebooks, Delta Lake with Python, Delta Lake with Spark SQLWorked extensively on the Rest APIs to fetch data from external sources and multiple services,then processed and transformed this data using Spark within DatabricksUnderstanding of the unity catalog for centralized access control, auditing, lineage and datadiscovery capabilities across the Azure Databricks workspacesHands on experience on the Azure Synapse workspace. Creation of external tables and views byconnecting to the Azure Datalake. Knowledge on the CETAS table creation. Managing theaccesses and roles within the Azure Synapse workspaceSupported the spark application in the Azure Synapse analytics and also monitored the pipelinefailures in the Azure Synapse Analytics workspaceExtensive experience using SQL Server, Azure SQL DB with working knowledge of SQL language.Built end-to-end data integration ADF pipelines to ingest data from different sources to AzureSQL database. Built event based trigger pipelines. Experience on creating the SHIR and Azure IRand source the data from external sources and Azure respectively. Monitored the pipelinefailures, analysis on the failure pipelines and update the solution for the same.Created Power automate flows for scheduling, automating and orchestrating tasks, businessprocesses and workflows. Created stored procedures and queries for data insertion, updatingand data analysis.Created Power Apps Canvas Apps by connecting to multiple sources including Azure SQL, Azure Synapse, Dataverse, Sharepoint etc

Experience

1. Senior Specialist - Data Engineer

   LTIMindtree

   Jun 2025 — Present · Hyderabad, IN

Education

• Narayana Junior College

  Board of Intermediate, MPC

  2008 — 2010

• Jawaharlal Nehru Technological University

  Bachelor's degree, Petroleum Engineering

  2010 — 2014