Back to Developers
SAHIL UJGARE

SAHIL UJGARE

Junior Data Analyst

Pune
80
Profile Score

About

Detail-oriented and analytical Junior Data Analyst with hands-on experience in collecting, cleaning, and analyzing data from multiple sources to support business decision-making. Proficient in MS Excel (VLOOKUP, INDEX-MATCH, Pivot Tables, Advanced Charts), SQL, Python (Pandas, NumPy, Matplotlib, Seaborn), and Power BI dashboard development. Skilled at identifying trends, generating actionable insights, preparing stakeholder reports, and ensuring data accuracy and consistency. Passionate about transforming raw data into clear, meaningful visualizations and reports that drive informed business decisions.

Skills & Expertise (46)

SQL Advanced
8.4/10
1
Years Exp
Python Advanced
8.0/10
1
Years Exp
Power BI Advanced
7.9/10
1
Years Exp
Data Visualization Advanced
7.6/10
1
Years Exp
Excel Advanced
7.5/10
1
Years Exp
Seaborn Data visualization with Power BI and Excel scikit-learn Exploratory data analysis Trend Identification Hypothesis Testing correlation analysis Data Quality Monitoring Insight Generation Charts Histograms Heatmaps Bar Charts Dashboards Tableau Jupyter Notebook Git GitHub n8n Automation MS Office Window Functions Reporting VLOOKUP Index-match Pivot Tables Advanced Charts Power Query Data Validation Conditional Formatting Joins CTEs Matplotlib Aggregations Subqueries MySql Interactive Dashboards DAX measures KPI Tracking data model design Pandas NumPy

Work Experience

Data Analyst Intern

HisanLabs Pvt. Ltd.

Jul 2025 - Present

Collected, cleaned, and organized data from multiple sources — SQL databases, CSV files, Excel sheets, and APIs — using Python (Pandas, NumPy) and SQL, ensuring data accuracy, completeness, and consistency. Performed exploratory data analysis (EDA) to identify trends, patterns, and anomalies, delivering data-driven insights that supported business decision-making for senior stakeholders. Created interactive Power BI dashboards and reports tracking key business KPIs, enabling real-time visibility into operational and financial performance across teams. Built advanced Excel reports using VLOOKUP, INDEX-MATCH, Pivot Tables, and Data Validation for ad-hoc management reporting, operational analysis, and stakeholder presentations. Ensured data accuracy and consistency by developing data quality standards and validation procedures — identifying and resolving missing values, duplicates, outliers, and inconsistencies across datasets. Prepared clear documentation and reports translating complex analytical findings into accessible narratives for non-technical stakeholders and management teams. Collaborated with cross-functional teams (Sales, Product, Finance) to understand data requirements and translate business questions into structured, actionable analytical tasks. Applied statistical techniques including hypothesis testing, correlation analysis, and distribution analysis to validate insights and support data-driven recommendations. Automated repetitive data preparation and reporting workflows using Python scripts and n8n, significantly reducing manual processing time and improving team efficiency.

Education

B.Sc. in Computer Science - Haribhai V. Desai College of Arts and Science

2022 - 2025 · India

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 sinceMar 2026

Availability Details

Visa Status

Need Sponsorship

Relocation

Open to Relocation

Skills (46)

SQL Python Power BI Data Visualization Excel Seaborn Data visualization with Power BI and Excel scikit-learn Exploratory data analysis Trend Identification +36 more