Pawan Lakhera

Data Analyst

Dehradun, Uttarakhand $18/hr Hybrid Full-time 0+ yrs exp 91 · Outstanding

About

Junior Data Analyst with internship experience in collecting, cleaning, analyzing, and visualizing data to support business decisions. Skilled in Excel, SQL, Power BI, Python, data validation, dashboard development, and business reporting. Built end-to-end analytics projects using datasets containing 10,000+ records and developed actionable insights through trend analysis and KPI reporting. Strong analytical, problem-solving, and communication skills with the ability to work independently in remote environments.

Skills & Expertise (34)

Problem-solving Advanced

8.0/10

0.25

Years Exp

Strong communication skills Advanced

8.0/10

0.25

Years Exp

Advanced Microsoft Excel Advanced

8.0/10

0.25

Years Exp

Python Intermediate

7.5/10

Years Exp

Power BI Intermediate

7.5/10

0.25

Years Exp

Data Cleaning Intermediate

7.0/10

Years Exp

Statistics Intermediate

7.0/10

0.25

Years Exp

Exploratory data analysis Intermediate

6.5/10

0.25

Years Exp

ETL Intermediate

6.5/10

0.25

Years Exp

Data Visualization Intermediate

6.5/10

0.25

Years Exp

Data Preprocessing Intermediate

6.5/10

0.25

Years Exp

Data Wrangling Intermediate

6.5/10

0.25

Years Exp

Power Query Intermediate

6.5/10

0.25

Years Exp

Trend Analysis Intermediate

4.5/10

0.25

Years Exp

Outlier Detection Intermediate

4.5/10

0.25

Years Exp

Root Cause Analysis Intermediate

4.5/10

0.25

Years Exp

Advanced Excel Intermediate

4.5/10

0.25

Years Exp

Reports Intermediate

4.5/10

0.25

Years Exp

Data Filtering Intermediate

4.5/10

0.25

Years Exp

Cross-Functional Collaboration Intermediate

4.5/10

0.25

Years Exp

Generative AI Intermediate

4.5/10

0.25

Years Exp

Communication Skills Intermediate

4.5/10

0.25

Years Exp

Attention to Detail Intermediate

4.5/10

0.25

Years Exp

Business Insights Intermediate

4.5/10

0.25

Years Exp

MySql Intermediate

4.5/10

0.25

Years Exp

Predictive Modeling Intermediate

4.5/10

0.25

Years Exp

Tableau Intermediate

4.5/10

0.25

Years Exp

Charts Intermediate

4.5/10

0.25

Years Exp

XLOOKUP Intermediate

4.5/10

0.25

Years Exp

VLOOKUP Intermediate

4.5/10

0.25

Years Exp

Pivot Tables Intermediate

4.5/10

0.25

Years Exp

Data Processing Google Sheets Formulas

Work Experience

Data Analytics Intern

Unified Mentor

Apr 2026 - Jul 2026

Delivered two end-to-end analytics projects (EduPro instructor-performance dashboard and Palo Alto Networks HR analytics) using Power BI, DAX, Power query, and Python, converting raw data into business-ready dashboards. Built Star Schema and flat fact-table data models, DAX calculated columns and measures, to analyze 10,000+ transaction records and 1,470-employee HR dataset. Deployed both dashboards via Streamlit and documented findings through research papers.

Education

Bachelor Of Computer Applications - Graphic Era Hill University

2018 - 2021 · India

Intermediate - R.A.S.V.M. Inter College

2017 - 2018 · India

Certifications

Data Analytics

IBM · 2026

Excel and Copilot Fundamentals

Microsoft · 2026

Deloitte Australia Data Analytics Job Simulation on Forage

· 2026

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 6/15

💰 Rate 5/5

🏆 Certs 5/5

✅ Verified 5/5

Total Score 91/100

Profile Overview

Member sinceJul 2026

Work ModeHybrid

AvailabilityFull-time

Availability Details

Relocation

Open to Relocation

Skills (34)

Click a skill to find developers with the same skill

Problem-solving Strong communication skills Advanced Microsoft Excel Python Power BI Data Cleaning Statistics Exploratory data analysis ETL Data Visualization +24 more

Similar Profiles

Abhineet Verma

Data

Rahul Agarwal

Data Analyst

Saijyothi A

Data Analyst

Amruta Shelke

Data Analyst

View All Developers →