Project 3:Developed Power BI dashboards for Customer, Transaction, and Financial data (Buy/Sell, Deposit/Withdraw, Banking, Profits, Assets).The dashboards analyze customer trends and financial metrics, enabling stakeholders to identify patterns, make informed decisions, and drive strategic initiatives for business growth.Utilized drill-through, drill-down, cross-filtering, and bookmarks to enhance dashboard interactivity.Cleaned data in Power Query, built data models, and managed relationships within Power BI.Inserted seed data into the database using SSIS packages and stored procedures.Imported Excel data into database tables and optimized stored procedures using temp tables and CTEs, eliminating loops and cursors for better performance.Automated SSIS packages and stored procedures with SQL Server Agent.Project 2:Developed sales dashboards focused on key performance metrics, including GMV trends, RSP trends, and Net Sales trends, providing insights to support informed decision-making.Migrated Excel data from Azure Blob Storage to the database using SSIS, automating the process with SQL Server Agent.Employed For Each Loop Containers to migrate multiple Excel files simultaneously, avoiding data duplication.Created Fact and Dimension tables for performance optimization and maintained table relationships in Power BI.Project 1:Built a Data Warehouse utilizing Star and Snowflake schemas, creating Dimension and Fact tables.Migrated data from transactional databases to the warehouse using SSIS incremental load packages, with job creation and report-based monitoring.Developed DB objects, including stored procedures, functions, and views.Gathered and analyzed requirements from the Product Owner, provided estimations, and designed solutions presented for feedback before development.Developed Power BI dashboards for Finance, Workflow, and HR data, participating in daily stand-ups and issue discussions.