• Creating Power BI reports to help visualise the data effectively and take important decisions using graphs, heatmaps, charts • Embedding Power BI reports and filtering the data according to the user logged in with web application so as the user can view the reports within the same application • Worked on Function App, Logic App as and when the requirement is not able to be achieved using Azure Data Factory • Created data factory, linked servers, datasets, pipelines and gateway to populate data from Oracle, Excel, On Premise SQL Server, FTP, Blob to SQL Azure • Developed SSIS packages (2008, 2012) to pull data from various data source (like databases, spreadsheets) and built an Enterprise Data Warehouse • Created C# solution for creation of data factory, linked servers, datasets and pipelines which can be deployed to Azure Portal • Create Stored Procedures (Full truncate load and Delta load), Views, and Functions to design the Data Mart • Worked on Decrypting and Encrypting Personally identifiable information (PII) data in C# code and database level encryption using “Rijndael algorithm”. • Developed data warehouse by pulling data from different sources of Partners using ETL packages • Created data mart by implementing required business logic using stored procedures, functions and views • Created reporting stored procedures on top of data mart for the purpose of analysing and reporting • Integrated this data with existing cube to enable end users to analyse data based on their requirements • Applied cube level security based on different dimension using scripts and dlls. • Optimised reporting stored procedures with very low response time (within 8 seconds) • Created SSRS reports for reporting Consumption data to end users • Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports • Identified and worked with parameters for parameterized reports in SSRS • Used cascaded parameters to generate a report from two different Data Sets