• Executed POCs (Proof of Concept) to optimize ELT pipelines on Databricks for client Blue Cross Blue Shield of Michigan.• Created Power BI dashboards using data sourced from aggregated fact tables.• Contributed to the development of data warehouse on Snowflake for AdalFi startup to capture the whole journey of a customer resulting in better insights for sales and cross-functional teams.• Achieved 40% reduction in cost as compared to the previous pipeline by implementing enhanced ETL using Apache Spark and Airflow.• Reduced manual efforts by 90% by deploying ETL pipeline on client side using docker containerization.• Optimized SQL queries and refined the design of the data warehouse dimensional model, leading to a notable 25% performance enhancement.• Created dashboards using Excel to capture insights and tracking of internal teams by using multiple tables coming from multiple threads of a project.