• Extracted raw transactional and master data from Dynamics 365 using Export to Data Lake, ensuring seamless integration with downstream analytical processes. • Designed and implemented ETL pipelines to clean, transform, and standardize the data, addressing data quality issues such as duplicates, missing values, and inconsistent formats. • Developed optimized SQL queries leveraging joins, subqueries, and CTEs to create structured analytical views for reporting and performance optimization. • Built a Power BI data model, establishing one-to-many and many-to-many relationships between tables to enable efficient data navigation. • Created advanced DAX measures and calculated columns for key performance metrics, enabling dynamic and interactive visualizations in Power BI dashboards.