SAMUDRA PALLAVI TAMANALA

Project 1: LHDN.

• Applied coding best practices to ensure code readability and scalability, developed industry standards-compliant software, and developed continuous integration and continuous delivery pipelines.
• Created and maintained APIs for systems integration, with the Entity Framework, which integrates the Cosmos DB for data retrieval and data saving.
• Worked on Service Bus, Azure Data Lake Storage, APIs, Azure Search AI, and Application Insights.
• Worked on Service Bus for data processing from multiple queues, and stored the data in multiple containers of Cosmos DB.
• Worked on the Azure storage account. Here, we are using blob storage to store the files in raw format.
• I have written C# code that can read XML files and process the data.

Project 2: AB InBev

• Utilized Agile and Scrum to manage sprints, coordinate with stakeholders, and prioritize tasks that aligned with the company's goals.
• Designed a pipeline in ADF to convert the files from CSV format to Parquet format, and store the data in ADLS.
• From the ADLS, the data from Parquet files stored in SQL pool tables. The pipeline is completely parameterized.
• We migrate the data using ADF for copying data Bronze -> Silver -> Gold Layers
• The truncate and load mechanism is implemented at the AZ layer for every run.
• Written parameterized stored procedures using dynamic SQL to compare and load the data from staging tables to master tables.
• Implemented a logging mechanism for every pipeline to log the errors, as well as the execution details.
• Implemented the Achieving mechanism after ingestion happens to HZ layer and deletion of the same file after archiving done.

Project 3: TeleDoc.

• In this project, we concentrate on data masking the data and storing it in the delta tables using Azure Databricks.
• Created a synapse pipeline for file movement from one storage account to another, based on DQ checks.
• DQ checks are performed through stored procedures.
• Collaborated with team members to provide technical guidance and support.
• Created delta tables in the Synapse workspace and accessed them through Azure Databricks and vice versa.
• Worked on REST API, Cosmos DB to Integrate with UI.