Siddhant Lakhotia profile photo 1 on Tal

Siddhant Lakhotia

Associate (Data Analyst) at PHN Technology Pvt Ltd

Pune District

2+ years of work experience

PHN Technology Pvt Ltd
Aug 20251 y 2 moPresent

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
Lenskart.com
Jun 20246 moDec 2024

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.
Madras Fertilizers Limited
Aug 20234 moDec 2023

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.
T-Hub
Apr 20233 moJul 2023

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.

Siddhant’s AI Stack

claude code
claude code
claude
claude
notion
notion
perplexity
perplexity
ChatGPT
ChatGPT

Education

Birla Institute of Technology and Science, Pilani

Bachelor of Engineering - BE, Mechanical Engineering With Minor In Finance

Birla Institute of Technology and Science, Pilani

20214 yrs2025

Join Siddhant and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

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