OCTOBER 2023 - JULY 2024 ● Designed and implemented ETL pipelines using Azure Data Factory, automating data workflows and improving integration processes, reducing manual effort by 40% and enhancing data refresh rates by 15% ● orked on data warehousing solutions on Microsoft Azure, optimizing data storage and improving query response time by 25% ● Applied Python, SQL, and Azure Machine Learning to conduct advanced data analysis, identifying key inefficiencies and recovering 10% of annual lost revenue ● Leveraged Azure Databricks and Spark to streamline data processing workflows, boosting processing speed by 35% and cutting project delivery timelines by 20%
JULY 2022 - OCTOBER 2023 ● Designed and developed ETL processes to implement Slowly Changing Dimension (SCD) Type 2, enabling the tracking of historical data changes and ensuring the integrity of versioned records ● Managed and maintained dimension tables to preserve historical data and ensure the accuracy of business insights. This involved ensuring proper handling of changes in source data to enable effective reporting and analysis ● Collaborated with senior team members to ensure the accuracy of data transformations and processed information, contributing to the integrity of data pipelines and systems ● Contributed to the optimization of data workflows by supporting the development of automated data processes and reducing manual intervention
FEBRUARY 2022 - MAY 2022 ● Strengthened my knowledge of Data Warehousing concepts. Trained on various data warehousing tools such as Informatica, IICS, etc. ● Enhanced my skills in MySQL and Database Management System. ● Implemented a mini project using SCD Type II concept
JANUARY 2021 - JANUARY 2021 ● Built various machine learning models which strengthened my basics in machine learning
JUNE 2019 - JUNE 2021 ● Coached and evaluated grade 10 students (ICSE) in Computer Applications ● Adapted the approach of practice worksheets, regular assessments, and quizzes to track student’s performance.