Harshil Trivedi
Relay Human Cloud India
5
years of professional experience
Summary
Power BI Developer and Data Analyst with 4+ years of experience delivering enterprise BI solutions, interactive dashboards, semantic data models, DAX measures, SQL analytics, Power Query transformations, ETL workflows, and reporting automation. Hands-on experience translating business requirements into scalable Power BI reports, KPI frameworks, data models, validation logic, and executive reporting solutions. Strong background in Power BI Desktop/Service, DAX, SQL, Power Query (M), Advanced Excel, data modelling, data quality, and stakeholder collaboration, with exposure to Microsoft Fabric and NoSQL data concepts.
Work History
Data Analyst
3 Years 7 Months- Designed and developed enterprise Power BI dashboards for operational performance monitoring, KPI tracking, workforce analytics, and executive reporting.
- Built semantic data models, DAX measures, calculated KPIs, drill-through reports, and dynamic visualizations aligned with stakeholder reporting requirements.
- Developed SQL, Power Query, and Excel-based ETL workflows for data extraction, cleansing, transformation, validation, and recurring reporting.
- Built reusable data-preparation pipelines and automated recurring reporting activities to improve reporting efficiency and reduce manual effort.
- Implemented structured data validation and reconciliation frameworks to identify reporting inconsistencies, duplicate records, and operational data mismatches.
- Developed SQL-based validation and QA logic to maintain reporting integrity and data accuracy across multiple datasets.
- Analysed large operational datasets to identify trends, productivity patterns, KPI movements, and business performance insights.
- Developed ad-hoc reports and analytical dashboards and collaborated with stakeholders to translate business requirements into reporting solutions.
Biomedical Image Analyst
1 Year 3 Months- Automated Excel-based operational reporting workflows and tracking processes using advanced Excel functions and Power Automate.
- Developed standardized operational reports and templates to improve reporting consistency, accuracy, and process efficiency.
- Conducted analytical validation and quality assurance checks across operational and imaging datasets.
- Built structured validation workflows to identify data inconsistencies, reporting discrepancies, and process anomalies.
- Collaborated with stakeholders to define KPI logic, reporting structures, validation rules, and operational reporting requirements.
Education
Master of Science (M.Sc.) - Biotechnology
GPA: 7.0
Skills
Power BI
Power BI Desktop
Power BI Service
Report and Dashboard Development
Semantic Models
Row Level Security
Gateway Management
DAX & Data Modeling
Advanced DAX measures
Star Schema
Multi Source Reporting Workflows
Relational Modelling
SQL & Data
MySQL and Microsoft SQL Server Management
Data Extraction – Transformation - Validation
Query Optimization
Cloud
Microsoft Fabric Fundamentals
Data Quality and Reconciliation
Reporting Governance
Excel and Automation
Advanced Microsoft Excel
Power Automate
Projects
- Enterprise Power BI Reporting Solution:, Developed interactive Power BI dashboards for KPI monitoring, operational analytics, and executive reporting; built DAX-driven measures and optimized semantic data models.
- Automated ETL & Data Transformation Workflow, Designed SQL, Power Query, and Excel workflows for structured data preparation and recurring MIS/reporting automation.
- Data Validation & Reconciliation Framework, Built SQL-based validation and reconciliation checks to improve reporting integrity, identify inconsistencies, and strengthen reporting governance.
Timeline
Data Analyst
Relay Human Cloud India
03.2023 - Current
Biomedical Image Analyst
Borek IT Sourcing Pvt Ltd
11.2021 - 02.2023
Sardar Patel University
Master of Science (M.Sc.) from Biotechnology