Santhosh Aluvala

About Santhosh Aluvala

I am a Senior Consultant at CBRE Group Inc, having around 14 years of experience in data engineering, data warehousing, data modeling, data transformation, and data analytics, using various tools and technologies such as Azure, AWS, Python, Pyspark, DataBricks, Snowflake, Docker, and Kubernetes. As a certified Cloud Data Engineer Associate, I specialize in designing and implementing data pipelines, architectures, and solutions that meet business requirements and data quality standards for clients. Leveraging my expertise in both Azure and AWS cloud platforms, I have delivered projects utilizing tools such as Azure Data Factory, Azure Data Lake Storage, Synapse Analytics, Cosmos DB, and AWS services like Glue, Redshift, S3, and Athena. Additionally, I apply Data-Ops practices to enhance collaboration, accelerate data delivery, and ensure reliability. I am passionate about adopting new technologies and tackling complex data challenges to deliver impactful solutions for clients and society. Primary Skillset: Azure Data Factory (ADF), Azure Synapse Analytics, Azure Data Lake Storage (ADLS), Azure Databricks, Azure Purview, Azure Stream Analytics, Azure SQL Database, Azure Cosmos DB, Azure Logic Apps, Azure Functions, Azure DevOps, Azure Monitor, Power BI, Snowflake, DBT (Data Build Tool),AWS Glue, Amazon S3, Amazon Redshift, Amazon RDS, Amazon DynamoDB, Amazon Kinesis, AWS Step Functions, AWS Lambda, Amazon EMR, AWS CodePipeline, AWS CloudWatch, AWS CloudTrail, AWS QuickSight,Power BI, Tableau

Experience

1. Data Architect Senior Data Engineer

   CBRE

   Jan 2024 — Present

   Designing Data pipelines to perform ETL using Azure data factory, Azure databricks and Azure synapse.Experience in designing the architecture of Datawarehouse using advanced data modelling concepts like SCD, Snowflake.Able to make use of most of the Azure services like Azure Data Factory, Databricks,Azure Synapse Analytics & Data Lake Storage.Designed and built both streaming and batch data ETL framework using delta lake.Built custom log framework using Azure log analytics.Implemented a pipeline to push ingested parquet files into Azure Datawarehouse (Azure Synapse Analytics) tables.Designed strong data model within Synapse to support both analytics and data load.Experience in working on version control systems like Subversion and GIT,clear case, Stash used Source code management client tools like Tortoise SVN,GIT Bash, GitHub, GIT Gui and other command line applications etc.Worked on a Generative AI POC for a data integration project, utilizing OpenAI\'s GPT model to generate contextual text and summaries from structured data.Leveraged Python libraries such as pandas for data extraction, transformation, and loading (ETL), and SQLite for storing enriched data with AI-generated insights.Integrated Generative AI to enhance data quality and enrichment, automating the generation of summaries and missing information to improve the overall data processing workflow.

Education

• Jawaharlal Nehru Technological University

  Bachelor of Technology - BTech, Computer Science