Piyush Tiwari

Implement Business rules on staged data to extract the information using Azure Databricks. Performed Custom ETL Logics to Transform Data as per client Requirements. Worked on more than 7 Projects for Microsoft. Created Data Cubes on Top of Transformed Data for Easy access of Client. Created Interactive reporting Power BI Dashboard to Represent Data. Created Interface for the User to update the data directly in Power BI Dataset Using Power Apps and Power Automate. Represented Team in Internal Audits regarding Quality Assurance and Project Architecture reviews. Played key role in development for the 3rd most highest visibility project of Microsoft.

Created Test Cases for the validation of different scenarios of the Project in Azure Dashboard. Worked on Daily Ad Hoc Database Query Requests received from client. Used Excel Features to create Excel Pivots for preliminary data analysis. Optimized Daily Pipeline Run Activities for Easy Updates and Failure Notifications through Thread in Teams.