---
title: "Siddhant Lakhotia - Data Analyst in Pune District | Tal"
description: "Meet Siddhant Lakhotia, Associate (Data Analyst) at PHN Technology Pvt Ltd based in Pune District. AI stack includes claude code, claude, and notion. Explore public work links including in.linkedin.com."
image: "https://tal.club/meet/siddhant-lakhotia/share-image"
---

# Siddhant Lakhotia on Tal

## Headline

Associate \(Data Analyst\) at PHN Technology Pvt Ltd

## About

Analyst with professional experience applying Python, SQL, Power BI, and machine learning to build ETL pipelines, analytical dashboards, and predictive models across education, supply chain, and business analytics projects\. Finance Minor from BITS Pilani with a strong foundation in business intelligence and data\-driven decision\-making\.

## Location

Pune District

## AI stack

claude code

claude

notion

perplexity

ChatGPT

## Work experience

Data Analyst at PHN Technology Pvt Ltd, Aug 2025 \- Present · 1 y 2 mo, Pune, • Built ETL pipelines using Python and SQLconsolidating 3 sources\(SQL databases, Excel, CSV\) into reporting\-ready tables, processing∼10K records per run with checks for duplicates, outliers, missing values and format mismatches\. • Designed 3 Power BI dashboards using DAX and Power Query to track the project and operational KPIs for 5–10 users\. • Ran EDA and statistical analysis on operational and warehouse data, presenting trends, outliers and delays to stakeholders\. • Automated a weekly KPI report in Python, cutting manual preparation and data cleaning time 50% \(3 to 1\.5 hours weekly\)\. Internship Experience

Analyst and Supply Chain Management Intern at Lenskart\.com, Jun 2024 \- Dec 2024 · 6 mo, Gurugram, Haryana, India, • Wrote SQL queries \(joins, aggregations\) on warehouse and inventory data to identify processing delays and inventory gaps\. • Developed a Power BI dashboard for inventory tracking, logistics monitoring, KPI analysis and reporting for 7 divisions\. • Performed data cleaning, statistical analysis, and demand forecasting using Python and Excel to support inventory planning\.

Company Analysis \- Financial Managemet at Madras Fertilizers Limited, Aug 2023 \- Dec 2023 · 4 mo, Pilani, Rajasthan, India, • Carried out a thorough financial and strategic analysis of Madras Fertilizers Ltd\. by reviewing its FY23 annual reports and stock data, in collaboration with Prof\.Rajan Pandey in the course of Financial Management\. • Evaluated their performance based on five key indicators: board composition, financial metrics \(like RoA, RoE, leverage, and turnover\), growth in assets, revenue, and profit, as well as their capital investments and sustainability efforts\. • Evaluated 8 quarters of profitability and stock movement trends; this analysis resulted in a review of the correlation between stock price, revenue growth, and net income, all of which had a positive correlation\. • Provided actionable insights on investment priorities and long\-term funding appropriateness; each conclusion was supported by data visualization and financial modeling\.

Business Analytics Intern at T\-Hub, Apr 2023 \- Jul 2023 · 3 mo, Hyderabad, • 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\.

## Education

Bachelor of Engineering \- BE, Mechanical Engineering With Minor In Finance, Birla Institute of Technology and Science, Pilani

## Public links

- in\.linkedin\.com: https://in\.linkedin\.com/in/siddhant\-lakhotia

[View the original profile](https://tal.club/meet/siddhant-lakhotia)

```json
{
  "@context": "https://schema.org",
  "@graph": [
    {
      "@type": "Person",
      "@id": "https://tal.club/meet/siddhant-lakhotia#person",
      "name": "Siddhant Lakhotia",
      "url": "https://tal.club/meet/siddhant-lakhotia",
      "image": "https://tal.club/meet/siddhant-lakhotia/profile-photo.jpg",
      "description": "Meet Siddhant Lakhotia, Associate (Data Analyst) at PHN Technology Pvt Ltd based in Pune District. AI stack includes claude code, claude, and notion. Explore public work links including in.linkedin.com.",
      "jobTitle": "Data Analyst",
      "worksFor": {
        "@type": "Organization",
        "name": "PHN Technology Pvt Ltd"
      },
      "hasOccupation": {
        "@type": "Occupation",
        "name": "Data Analyst"
      },
      "homeLocation": {
        "@type": "Place",
        "name": "Pune District"
      },
      "alumniOf": [
        {
          "@type": "EducationalOrganization",
          "name": "Birla Institute of Technology and Science, Pilani"
        }
      ],
      "knowsAbout": [
        "claude code",
        "claude",
        "notion",
        "perplexity",
        "ChatGPT"
      ],
      "sameAs": [
        "https://in.linkedin.com/in/siddhant-lakhotia"
      ],
      "mainEntityOfPage": {
        "@id": "https://tal.club/meet/siddhant-lakhotia#webpage"
      }
    },
    {
      "@type": "ProfilePage",
      "@id": "https://tal.club/meet/siddhant-lakhotia#webpage",
      "url": "https://tal.club/meet/siddhant-lakhotia",
      "name": "Siddhant Lakhotia on Tal",
      "description": "Meet Siddhant Lakhotia, Associate (Data Analyst) at PHN Technology Pvt Ltd based in Pune District. AI stack includes claude code, claude, and notion. Explore public work links including in.linkedin.com.",
      "dateModified": "2026-10-26T18:40:00.528Z",
      "isPartOf": {
        "@id": "https://tal.club/#website"
      },
      "mainEntity": {
        "@id": "https://tal.club/meet/siddhant-lakhotia#person"
      },
      "primaryImageOfPage": {
        "@type": "ImageObject",
        "url": "https://tal.club/meet/siddhant-lakhotia/profile-photo.jpg",
        "contentUrl": "https://tal.club/meet/siddhant-lakhotia/profile-photo.jpg",
        "caption": "Siddhant Lakhotia profile photo on Tal"
      },
      "inLanguage": "en-IN"
    }
  ]
}
```