Bala Aggala

Bankers Crossell/Upsell Chatbot Project

• Designed a robust data architecture to integrate and unpack diverse data sources, enabling seamless transformation and analytics.
• Implemented a compound AI chatbot model for cross-sell and up-sell product recommendations, driving business growth through intelligent matching algorithms.
• Extensively utilized Databricks for data transformation, AI/ML model training, and orchestration of personalized push notifications.
• Used Teams webhook API for implementing Push notifications from databricks platform.
• Created more than 20 databricks sql fucntions for the implementation of Compund AI model

• Designed and implemented Delta Lake architecture (bronze, silver, gold layers) on Azure Synapse
• Migrated large datasets from SQL Server to Azure Data Lake in Parquet format
• Automated data workflows with PySpark, Databricks, and Synapse Pipelines
• Established a robust data validation framework ensuring governance compliance
• Integrated Salesforce data into Azure Synapse using Bulk API and AWS Lambda
• Designed cross-cloud solutions for AWS PostgreSQL to Azure Synapse migrations
• Implemented Value added Keyvault mechanism which handled data platform from cyber seurity compliance rules.

• Developed ETL processes using SSIS, Azure Data Factory, and T-SQL
• Migrated on-prem databases to Azure Managed SQL Instances
• Implemented Azure Synapse Analytics for improved data governance
• Established End to End Data quality Frame work using Business and Technical rules for Insurance policy domain.
• Collaborated with cross-functional teams to define requirements and develop end-to-end solutions for complex data engineering projects.

• Migrated legacy systems to Azure Synapse Analytics, improving performance and scalability
• Built end-to-end ETL pipelines using Databricks and PySpark
• Created dynamic Power BI dashboards integrating Azure Data Factory and Synapse
• Designed a new data mart in Azure SQL datawarehouse for Mental health data platform.

• Led enterprise reporting projects using Power BI and Azure Data Factory
• Migrated on-premise SQL Server and SSIS packages to Azure
• Developed DAX measures and time-based functions for advanced reporting
• Desgined and Delivered more than 50 Power BI Reports across Enterprise with different domains

· Developed Cube for Operational Deposit decision reporting with time based Measures.

· Developed Complex Calculations in PLSQL like standard deviation using analytical functions

· Worked on creating tables, synonyms and views in the External Portal.

· Developed Procedures, views, packages and collections to process client data.