siddhant lakhotia

Associate Instructor (Data Analyst)

Pune, India 1+ yrs exp 74 · Very Good

About

No bio added yet

Skills & Expertise (36)

Python Intermediate

7.2/10

Years Exp

SQL Intermediate

7.0/10

Years Exp

Power BI Intermediate

7.0/10

Years Exp

Excel Intermediate

7.0/10

Years Exp

Data Cleaning Intermediate

7.0/10

Years Exp

Dashboard Development Intermediate

7.0/10

Years Exp

Data Visualization Intermediate

7.0/10

Years Exp

Data Wrangling Intermediate

6.8/10

Years Exp

Pandas Intermediate

6.8/10

Years Exp

Jupyter Intermediate

6.5/10

Years Exp

MySql Intermediate

6.5/10

Years Exp

KPI Reporting Intermediate

6.5/10

Years Exp

scikit-learn Intermediate

6.5/10

Years Exp

NumPy Intermediate

6.5/10

Years Exp

Statistical Analysis Intermediate

6.5/10

Years Exp

Predictive Analytics Intermediate

6.5/10

Years Exp

Model Evaluation Intermediate

6.0/10

Years Exp

Feature Engineering Intermediate

6.0/10

Years Exp

Git Intermediate

6.0/10

Years Exp

Matplotlib Intermediate

6.0/10

Years Exp

Classification Intermediate

5.8/10

Years Exp

Random Forest Intermediate

5.8/10

Years Exp

Seaborn Intermediate

5.8/10

Years Exp

Logistic Regression Intermediate

5.8/10

Years Exp

Forecasting Beginner

5.5/10

Years Exp

Business Analysis Beginner

5.5/10

Years Exp

XGBoost Beginner

5.5/10

Years Exp

Tableau Beginner

5.5/10

Years Exp

Excel VBA Beginner

5.0/10

Years Exp

Financial Modeling Beginner

5.0/10

Years Exp

Ratio Analysis Beginner

5.0/10

Years Exp

Valuation Beginner

5.0/10

Years Exp

Budgeting Beginner

5.0/10

Years Exp

Snowflake Beginner

5.0/10

Years Exp

EDA GitHub

Work Experience

Associate Instructor (Data Analyst)

PHN Technology Pvt. Ltd.

Aug 2025 - Present

Engineered ETL pipelines using Python and SQL for data extraction, transformation, validation, and reporting automation. Created interactive dashboards with Power BI using DAX and Power Query to monitor KPIs and performance metrics. Built a machine learning model with Scikit-learn for completion prediction, achieving 78% accuracy on validation data. Conducted Exploratory Data Analysis, feature engineering, statistical analysis, and predictive modeling using Scikit-learn. Automated recurring report workflows using Python, eliminating manual spreadsheet consolidation for weekly KPI reports.

Supply Chain Analyst Intern

Lenskart Solutions Pvt. Ltd.

Jun 2024 - Dec 2024

Wrote SQL queries using joins and aggregations to identify bottlenecks, contributing to a verified 5% reduction in lead-time. Developed interactive Power BI dashboards for inventory tracking, logistics monitoring, KPI analysis, and business reporting. Performed data cleaning, statistical analysis, and demand forecasting using Python and Excel to support inventory planning.

Business Analytics Intern

T-Hub

May 2023 - Jul 2023

Analyzed 70+ startups’ data across technologies, funding, and market trends to support accelerator program strategy. Prepared 20 analytical reports and presentations, translating market research into insights guiding accelerator strategy. Collaborated with 100+ industry leaders, gathering insights on product-market fit to shape early-stage evaluation criteria.