Back to Developers
Harpreet Lohia

Harpreet Lohia

Data Analyst

Pune
80
Profile Score

About

Detail-oriented Data Analyst with 2.7 years of experience in the BFSI domain, skilled in SQL, Excel, Power BI, Python, and data analytics. Proven ability to analyze large-scale banking transaction and loan data, automate MIS and risk reports, and develop interactive BI dashboards. Experienced in risk analytics, fraud detection, KPI development, EDA, and stakeholder collaboration, with a strong focus on data accuracy, governance, and business decision-making.

Skills & Expertise (27)

Power BI Intermediate
8.3/10
2.7
Years Exp
SQL Intermediate
8.1/10
2.7
Years Exp
Data Visualization Intermediate
8.0/10
2.7
Years Exp
Excel Intermediate
7.9/10
2.7
Years Exp
Python Intermediate
7.6/10
2.7
Years Exp
MS Excel (Pivot Tables, Power Pivot) APIs GitHub Copilot GitHub KPI development MIS Reporting Fraud Detection Risk Analysis BFSI Analytics ETL Concepts Aggregations Subqueries Joins MySql SQL Server Dashboard Development DAX Tableau Data Mining Data Validation Data Cleaning EDA

Work Experience

Data Analyst

HCLTech

Jun 2023 - Present

Analyzed large-scale banking datasets to support risk analytics, fraud detection, and operational reporting. Designed and developed interactive Power BI dashboards, automated MIS reports, collaborated with stakeholders, extracted data using SQL, performed data cleaning and transformation, conducted EDA, analyzed customer transaction behavior, developed KPIs, created DAX measures, used Python for data preparation, ensured data governance compliance, validated reports, delivered actionable insights, and documented data logic.

Education

Btech (Computer Science and Technology) - Rajiv Gandhi College of Engineering Research and Technology, Chandrapur

- 2022 · Afghanistan

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 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 80/100

Profile Overview

Member sinceFeb 2026

Availability Details

Visa Status

Citizen

Relocation

Depends on Offer

Skills (27)

Power BI SQL Data Visualization Excel Python MS Excel (Pivot Tables, Power Pivot) APIs GitHub Copilot GitHub KPI development +17 more