Looking for a job

Loka Pujitha Mandalapu

@lokapujithamandalapu

Message

I turn retail, agricultural, and transaction data into actionable business insights.

India

Message

What I'm looking for

I'm seeking an entry-level Data Analyst role where I can apply SQL, Python, Excel, and analytical problem-solving skills to clean data, generate business insights, and support reporting.

I've built end-to-end analytics projects that turn raw retail, agricultural, and transaction data into practical business insights using Python, SQL, and Excel.

In a retail sales EDA of 9,994 transactions, I identified Technology as the highest-margin category, uncovered loss-making products, and found a Q4 sales peak 35% above the monthly average. I also flagged over-discounting in the Central region as a potential margin risk.

I've analyzed 2,000+ agricultural price records, created Excel pivot-table reporting and recommendations, and designed a five-table transaction database with validation logic for 500+ simulated transactions. Through Deloitte's Forage simulation, I also cleaned and validated 1,000+ records and delivered analytical recommendations under a simulated business deadline.

Experience

Work history, roles, and key accomplishments

Data Analyst Job Simulation

Deloitte

Aug 2025 - Present (1 year 1 month)

Cleaned and validated a structured dataset of 1,000+ records using Excel and Python (Pandas), applying data consistency checks to support reliable reporting. Delivered 2 written analytical recommendations based on findings, under a simulated business deadline.

Excel Python Pandas Data Cleaning Data Validation Data Analysis Reporting