Prerna Lugade

Aspiring Data Analyst

Pune 0+ yrs exp 81 · Excellent

About

Aspiring Data Analyst skilled in Python, SQL, Excel, and Power BI with hands-on experience in data cleaning, visualization, and analytics. Seeking to contribute to data-driven decision-making.

Skills & Expertise (15)

SQL Intermediate

6.5/10

Years Exp

Python Intermediate

6.5/10

Years Exp

Power BI Intermediate

6.5/10

Years Exp

Pandas Intermediate

6.0/10

Years Exp

Microsoft Excel Intermediate

6.0/10

Years Exp

Jupyter Notebook Intermediate

6.0/10

Years Exp

Problem Solving Intermediate

6.0/10

Years Exp

NumPy Intermediate

5.5/10

Years Exp

Google Sheets Intermediate

5.5/10

Years Exp

Matplotlib Intermediate

5.0/10

Years Exp

Seaborn Intermediate

5.0/10

Years Exp

Postgresql Intermediate

5.0/10

Years Exp

MySql Intermediate

5.0/10

Years Exp

VS Code Intermediate

5.0/10

Years Exp

EDA

Work Experience

Data Analyst Intern

Syngenta India Pvt. Ltd

Jan 2026 - Present

Automated acreage & potential files for multiple states using Python, streamlining agricultural sales analysis. Built a portfolio selling algorithm by consolidating distributor sales data and comparing FY26 sales against historical averages and BGP targets. Extracted and validated CleverTap event data to generate farmer engagement insights. Conducted LGD, TM, and MDO hierarchy mapping across states for accurate territory alignment. Supported GrowerConnect uploads and analyzed farmer visits to classify engagement levels. Assisted in Cropwise Grower and GrowersConnect projects, handling data uploads, farmer mobile extraction, and event-based reporting. Delivered state-wise datasets to Upsolve, integrating acreage, potential, and classification outputs into Syngenta’s workflows.

Data Analyst Intern

Elevate Labs

Mar 2025 - May 2025

Completed 8 real-world tasks and 2 final projects using Power BI, SQL, and Python. Delivered insights via dashboards and GitHub submissions with clear business storytelling.