Back to Developers
Harsh Mehra

Harsh Mehra

Data Analyst

Noida, India 3+ yrs exp 87 ยท Excellent

About

Data Analyst with 2+ years of experience building Power BI reports and semantic models, with hands-on exposure to Microsoft Fabric and Workspaces. Skilled in DAX, SQL, Power Query and fact/dimension modeling, with experience building Bronze and Silver layers in Py-Spark and creating Data Pipelines in Fabric. Experienced in creating pipelines to ingest and transform data from SQL Server into Fabric SQL Warehouses, including SQL querying to create separate and aggregated tables. Proficient in publishing and managing reports through Fabric workspaces and Power BI Apps. Delivered analytics across pharmaceutical supply chain, customer revenue segmentation and operations reporting.

Skills & Expertise (44)

Power BI Advanced
8.2/10
3
Years Exp
Data Analysis Advanced
7.8/10
3
Years Exp
DAX Intermediate
7.6/10
3
Years Exp
Python Intermediate
7.4/10
3
Years Exp
T-SQL Intermediate
7.0/10
3
Years Exp
Data Cleaning Intermediate
7.0/10
3
Years Exp
SQL joins Intermediate
7.0/10
3
Years Exp
Statistical Analysis Intermediate
6.5/10
3
Years Exp
Data Warehousing Intermediate
6.5/10
3
Years Exp
ETL Basics Intermediate
6.5/10
3
Years Exp
Data Transformation Intermediate
6.5/10
3
Years Exp
Microsoft Azure Advanced Excel PySpark Pandas NumPy Data Validation Data Modeling Requirements Gathering Stakeholder Management User Stories Gap Analysis Process Improvement Business Process Analysis workflow optimization Documentation SSMS Business Intelligence KPI development Dashboard Reporting EDA Trend Analysis Root Cause Analysis A/B testing Data Storytelling Seaborn Query Optimization CTEs Indexing Database Management Star Schema Medallion Architecture Power Query Matplotlib

Work Experience

Data Analyst

Neenopal INC

Jul 2026 - Sep 2026

Designed interactive Power Bi dashboards to track Operations KPIs, reducing monthly reporting time by 30%. Created visual analytics using filters, parameters, and calculated fields to help stakeholders drill down into regional revenue growth.

Data Analyst

HCL Technologies

May 2024 - Jun 2026

Created Bronze and Silver layer pipelines in Microsoft Fabric to load GA4 data from BigQuery into a Lakehouse, preparing cleaned datasets for monthly customer revenue analysis. Developed a reusable recursive PySpark function to flatten multi-level nested JSON/STRUCT/ARRAY data, separating event parameters, user properties and item-level arrays into analytical tables and reducing repetitive transformation code. Formed the Power BI semantic model on Gold-layer tables, connecting customer, region, product and calendar dimensions with transactional revenue data to enable monthly customer-level analysis. Developed dynamic DAX-based customer tagging (Lost, Growth, Stable, Retained) using a 12-month revenue-inactivity window and comparison against historical monthly averages. Built interactive Tag vs. Actuals analysis with customer, region, date and tag filters, allowing stakeholders to drill from overall revenue into specific customers and regional segments. Identified about 15% of customers with consistent revenue growth, and enabled the sales team to track movement between segments and act on at-risk accounts before they became Lost. Published to a Fabric workspace and managed client-group access; delivered a Power BI App at the client's request.

Database Engineer

HCL Technologies

Jan 2023 - Apr 2024

Reduced database space issues by 40% by designing weekly data and & log reports; analyzed performance bottlenecks on critical servers to minimize downtime and ensure seamless availability for application teams. Converted legacy Excel reports to Power BI dashboards; trend analysis on operational data backup failures that lowered downtime risk by 75% via proactive alerting. Improved complex T-SQL queries and execution plans through strategic indexing and query refactoring, driving a 20% reduction in database response times.

Education

Bachelor of Computer Applications - Amity University

- 2024 ยท Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 12/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 87/100

Profile Overview

Member sinceSep 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation