Contributed to a customizable web app for a team to manage its resources using React, .NET, and Azure services. Increased team productivity by providing a one-stop solution to manage and find all resources.
•
Developed ETL pipelines for business intelligence on telemetry data with half a million daily records. Built a Power BI report having Page Load Time (PLT) of less than 6 seconds to visualize the data.
•
Created SQL stored procedure to automate view creation with logging in Data Warehouse.
•
Integrated Git Large File Storage (LFS) to manage Power BI reports created by multiple teams in a single repository which reduced build times by over 90%.
•
Automated Power BI reports’ build and release through CI/CD pipeline to reduce manual efforts by 70%.
•
Streamlined tracking device maintenance requests by developing apps and automated workflows in Microsoft Power Platform.
•
Developed workflows to import data from various types of data sources like SQL data warehouse, REST API, Kusto (Azure Data Explorer), and CosmosDB. Created plugins for model-driven app in Power Apps to auto fill metadata based on product details.
•
Trained and mentored new team members in both domain and technical knowledge.
•
Involved in functional areas like requirements analysis, architecture, testing, and code reviews.