Rashi Garg 1

Hyderabad, Telangana, India

Yearly Stats: $0 Earned |

5+ experience in Azure SQL,PowerBI,SQL S

• 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

$25 / Hour
$25 minimum budget