Harshil Patel

Experience

• 

  BRUSSELS LIFE SCIENCE

  Mar 2021 - Sept 2021

  Power BI Developer

  Created multiple projects on Power BI-Developed reports on Healthcare, Retail, Insurance claim, HR, E-Commerce, Etc.-Managed schema including cleaning of data, establishing relationships, merging queries,creating calculated columns, creating measures, creating custom tables/data sets and performing transformation of data.-Performed Data Visualization-Performed Data Modelling and possess good knowledge of DAX.

• 

  SalesPoint Incorporation

  Oct 2021 - Apr 2022

  Power BI Developer

  -Working for Microsoft (client)-Managed schema including cleaning of data, establishing relationships, merging queries, creating calculated columns, creating measures, creating custom tables/data sets, and performing transformation of data. -Performed Data Modelling and possess good knowledge of DAX.

• 

  MMJS DataPhi

  Apr 2022 - now

  -My responsibility in this role is to establish connections with various data sources, including Azure Analysis Service, Azure SQL Database, Azure Databricks Delta table, SQL Server, Excel, and other sources. Additionally, I am responsible for creating data models that align with the project's reporting and analysis requirements.-Creating data models that cater to the project's reporting and analysis needs.-Building visually appealing and informative dashboards and reports is also a part of my job using the Power BI toolset and incorporating DAX, M Query, Power Query, Power Pivot, and Power View.-Automate the process of refreshing and updating data in the reports, I use PySpark and ADF.-Collaborating with the project team, I provide recommendations on the best ways to present the data and utilize Azure Data Factory and PySpark to perform data validation and cleansing to ensure data quality.-Monitoring and maintaining the performance of data models and reports, optimize their performance using PySpark, and troubleshoot any issues that arise in the process.-Staying updated with the latest trends and technologies in data visualization and reporting is crucial, and I continuously strive to improve and update the project's reporting and analysis capabilities.-communicate effectively with the project team and stakeholders to ensure that the project's data and reporting needs are met in a timely and efficient manner. Show less

  • Associate Consultant

    Jan 2024 - now

  • Data Analyst

    Apr 2022 - Jan 2024