• Participated in gathering User Requirements and System Specifications for dimensioning modelling of data warehouse.• Designed and implemented the ETL processes using SSIS which involved collection of data from sources like SQL Server. • Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports. • Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps. • Generated Monthly, Yearly, Quarterly, and daily reports in Power BI.• Utilizing Power BI's integration with Azure SQL Database for optimized data storage and querying.• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to Power BI Service.• Expertise in DAX & MDX Languages which helps in understanding and analyzing the data.• Explore data in a variety of ways and across multiple visualizations using Power BI.• Developed and deployed SSIS packages, configuration files and scheduled job to run the packages to generate data in CSV files and Flat files. • Automated File Transfer Processes and mail notifications by using FTP Task and Send Mail task in packages. • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities. • Data modelling in business intelligence and data warehousing. • Designed and build up high performance ETL packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS

• Involved in developing different reports using Microsoft BI tools like SSIS, SSRS and developed Power BI dashboards that would help business operate smoothly. • Expert in Creating Custom Columns, Inserted Merged Columns, Filtering Rows using Power BI • Used different kind of visualizations in Power BI like Line Chart, Clustered bar chat, Pie chart, Matrix table, Gauges, Scatter chart, Map, Card, Slicers Etc. • Demonstrable knowledgeable experience with Oracle SQL, PL/SQL development.• Expert in Managing the relation between Visualizations in Power BI. • Wrote DAX in Power BI for Aggregations. • Created detailed reports in Power BI using Drill through filters. • Created SSIS packages to validate, extract, transform and load data-to-data warehouse databases and deployed with minimal changes using XML configuration file.

• Developed ETL using SSIS including data extraction, transformation and loading between multiple data sources and destinations. • Worked on ETL in creating SSIS packages, building, deploying, and executing the packages.• Migrated data from different sources (text-based files, Excel spreadsheets) to SQL Server databases using SQL Server Integration Services (SSIS). • Developed Package configurations for Integration, Test and Production environments and execution of SSIS packages automatically.• Created various kinds of report using SSRS, deployed & executed in Report Server.• Created sub-reports, drill down reports, summary reports, parameterized reports, and ad-hoc reports using SSRS.